Révision 4fcefb60 src/sql/labstocks_db.sql
| b/src/sql/labstocks_db.sql | ||
|---|---|---|
| 1 |
|
|
| 2 |
CREATE TABLE IF NOT EXISTS `storage_minus20freezers` ( |
|
| 3 |
`name` varchar(100) COLLATE utf8_general_ci NOT NULL, |
|
| 4 |
PRIMARY KEY (`name`) |
|
| 5 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; |
|
| 6 |
|
|
| 7 |
INSERT INTO `storage_minus20freezers` (`name`) VALUES ('GY -20 freezer');
|
|
| 8 |
|
|
| 9 |
|
|
| 10 |
CREATE TABLE IF NOT EXISTS `storage_minus80freezers` ( |
|
| 11 |
`name` varchar(100) COLLATE utf8_general_ci NOT NULL, |
|
| 12 |
PRIMARY KEY (`name`) |
|
| 13 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; |
|
| 14 |
|
|
| 15 |
INSERT INTO `storage_minus80freezers` (`name`) VALUES ('GY -80 freezer');
|
|
| 16 |
|
|
| 17 |
|
|
| 18 |
CREATE TABLE IF NOT EXISTS `storage_fridges` ( |
|
| 19 |
`name` varchar(100) COLLATE utf8_general_ci NOT NULL, |
|
| 20 |
PRIMARY KEY (`name`) |
|
| 21 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; |
|
| 22 |
|
|
| 23 |
INSERT INTO `storage_fridges` (`name`) VALUES ('GY fridge');
|
|
| 24 |
|
|
| 25 |
|
|
| 26 |
CREATE TABLE IF NOT EXISTS `storage_rooms` ( |
|
| 27 |
`name` varchar(100) COLLATE utf8_general_ci NOT NULL, |
|
| 28 |
PRIMARY KEY (`name`) |
|
| 29 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; |
|
| 30 |
|
|
| 31 |
INSERT INTO `storage_rooms` (`name`) VALUES ('GY room');
|
|
| 32 |
|
|
| 33 |
|
|
| 34 |
|
|
| 35 |
|
|
| 1 | 36 |
-- phpMyAdmin SQL Dump |
| 2 | 37 |
-- version 3.4.11.1deb2 |
| 3 | 38 |
-- http://www.phpmyadmin.net |
| ... | ... | |
| 143 | 178 |
`Dilution-WB` text NOT NULL, |
| 144 | 179 |
`Volume-ChIP` text NOT NULL, |
| 145 | 180 |
`ProductID` varchar(20) NOT NULL, |
| 181 |
`storage_minus20freezers` varchar(100) DEFAULT NULL, |
|
| 182 |
`storage_minus80freezers` varchar(100) DEFAULT NULL, |
|
| 183 |
`storage_fridges` varchar(100) DEFAULT NULL, |
|
| 184 |
`storage_rooms` varchar(100) DEFAULT NULL, |
|
| 146 | 185 |
PRIMARY KEY (`id`), |
| 147 | 186 |
KEY `Author` (`Ordered_by`) |
| 148 | 187 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
| ... | ... | |
| 216 | 255 |
`PCR_conditions_predicted` longtext, |
| 217 | 256 |
`Author` varchar(50) DEFAULT NULL, |
| 218 | 257 |
`Purif` varchar(40) NOT NULL, |
| 258 |
`storage_minus20freezers` varchar(100) DEFAULT NULL, |
|
| 259 |
`storage_minus80freezers` varchar(100) DEFAULT NULL, |
|
| 260 |
`storage_fridges` varchar(100) DEFAULT NULL, |
|
| 261 |
`storage_rooms` varchar(100) DEFAULT NULL, |
|
| 219 | 262 |
PRIMARY KEY (`id`), |
| 220 | 263 |
KEY `Author` (`Author`) |
| 221 | 264 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
| ... | ... | |
| 493 | 536 |
`sequence` text, |
| 494 | 537 |
`image_file` varchar(100) DEFAULT NULL, |
| 495 | 538 |
`Author` varchar(50) DEFAULT NULL, |
| 539 |
`storage_minus20freezers` varchar(100) DEFAULT NULL, |
|
| 540 |
`storage_minus80freezers` varchar(100) DEFAULT NULL, |
|
| 541 |
`storage_fridges` varchar(100) DEFAULT NULL, |
|
| 542 |
`storage_rooms` varchar(100) DEFAULT NULL, |
|
| 496 | 543 |
PRIMARY KEY (`id`), |
| 497 | 544 |
UNIQUE KEY `Link_to_file` (`Link_to_file`), |
| 498 | 545 |
UNIQUE KEY `Link_to_file_2` (`Link_to_file`), |
| ... | ... | |
| 741 | 788 |
`Last_modified` date DEFAULT NULL, |
| 742 | 789 |
`MET15` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, |
| 743 | 790 |
`Author` varchar(50) DEFAULT NULL, |
| 791 |
`storage_minus20freezers` varchar(100) DEFAULT NULL, |
|
| 792 |
`storage_minus80freezers` varchar(100) DEFAULT NULL, |
|
| 793 |
`storage_fridges` varchar(100) DEFAULT NULL, |
|
| 794 |
`storage_rooms` varchar(100) DEFAULT NULL, |
|
| 744 | 795 |
PRIMARY KEY (`id`), |
| 745 | 796 |
KEY `Author` (`Author`) |
| 746 | 797 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
Formats disponibles : Unified diff