 	KEY project (project_id),
 	KEY organisation (organisation_id)
 
-	) COLLATE=utf8_general_ci ENGINE=MyISAM;
+) COLLATE=utf8_general_ci ENGINE=MyISAM;
+
 
 /**
  * This table holds all the external datasources (MGI, Ensembl)
  */
-
 -- this table holds all the external/ASTD database names
+DROP TABLE IF EXISTS external_db;
 CREATE TABLE external_db (
-
 	id                       INT(10) UNSIGNED NOT NULL,
 	name                     VARCHAR(100) NOT NULL,
 	short_name               VARCHAR(40) NOT NULL,


) COLLATE=utf8_general_ci ENGINE=MyISAM;

/**
 * Contains meta information from release to release to keep track of
 * Numbers through time
 */
CREATE TABLE meta_history (
	id                       INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	property_key             VARCHAR(255) NOT NULL DEFAULT '',

 * An experiment has several observation associated to it.
 * See table observation
 */
DROP TABLE IF EXISTS experiment;
CREATE TABLE experiment (
	id                         INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	db_id                      INT(10) UNSIGNED NOT NULL,
	external_id                VARCHAR(100),
