1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
CREATE TABLE IF NOT EXISTS `Bacteria` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`CTMA_ref` varchar(50) DEFAULT NULL,
`Internal_ref` varchar(50) DEFAULT NULL,
`External_ref` varchar(50) DEFAULT NULL,
`Accession` varchar(15) DEFAULT NULL,
`Genus` varchar(50) DEFAULT NULL,
`Species` varchar(50) DEFAULT NULL,
`Subspecies` varchar(50) DEFAULT NULL,
`Other` varchar(150) DEFAULT NULL,
`DNA_type` set('gDNA','pDNA','RNA') DEFAULT NULL,
`Other_storages` varchar(200) DEFAULT NULL,
`Concentration` decimal(8,4) unsigned DEFAULT NULL,
`Type` set('reference','field') DEFAULT NULL,
`Origin` varchar(100) DEFAULT NULL,
`Date` tinytext,
`Notation` varchar(100) DEFAULT NULL,
`Room` varchar(10) DEFAULT NULL,
`Freezer` varchar(50) DEFAULT NULL,
`Drawer` varchar(50) DEFAULT NULL,
`Box` varchar(50) DEFAULT NULL,
`Place` varchar(10) DEFAULT NULL,
`Date_gly` tinytext,
`Notation_gly` varchar(100) DEFAULT NULL,
`Room_gly` varchar(10) DEFAULT NULL,
`Freezer_gly` varchar(50) DEFAULT NULL,
`Drawer_gly` varchar(50) DEFAULT NULL,
`Box_gly` varchar(50) DEFAULT NULL,
`Place_gly` varchar(10) DEFAULT NULL,
`Manager` set('BM','CE',') DEFAULT NULL,
`Tests` text,
`Sequences` longtext,
`Documents` text,
`Note` text,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11513 ; |
Partager