  * An animal sample is a type of sample
  * The discriminative value is on the sample type
  */
-drop table live_sample;
+
 CREATE TABLE live_sample (
 
     id                        INT(10) UNSIGNED NOT NULL,

    description               VARCHAR(200),
    major_version             INT(10) NOT NULL DEFAULT 1,
    minor_version             INT(10) NOT NULL DEFAULT 0,

    PRIMARY KEY (id)
    
) COLLATE=utf8_general_ci ENGINE=MyISAM;

DROP TABLE IF EXISTS metadata_observation;
DROP TABLE IF EXISTS multidimensional_observation;
DROP TABLE IF EXISTS observation;
DROP TABLE IF EXISTS observation_population;
DROP TABLE IF EXISTS population;
DROP TABLE IF EXISTS ontology_relationship;
DROP TABLE IF EXISTS ontology_term;
DROP TABLE IF EXISTS organisation;
