 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;

 * 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,

    sequence                  INT(10) UNSIGNED NOT NULL,
    media                     TINYINT(1) DEFAULT 0,
    data_analysis             TINYINT(1) DEFAULT 0,
    stable_key                INT(10) DEFAULT 0,
 
    PRIMARY KEY (id),
    KEY parameter_stable_id_idx (stable_id)
    
