184 "`cells` double NOT NULL DEFAULT 0," |
184 "`cells` double NOT NULL DEFAULT 0," |
185 "`viability` double NOT NULL DEFAULT 0.99," |
185 "`viability` double NOT NULL DEFAULT 0.99," |
186 "`max` tinyint(4) NOT NULL DEFAULT 100," |
186 "`max` tinyint(4) NOT NULL DEFAULT 100," |
187 "`size` float NOT NULL DEFAULT 0," |
187 "`size` float NOT NULL DEFAULT 0," |
188 "`used` int(11) NOT NULL DEFAULT 0," |
188 "`used` int(11) NOT NULL DEFAULT 0," |
|
189 "`valid` tinyint(1) NOT NULL DEFAULT 0," |
189 "PRIMARY KEY (`record`)," |
190 "PRIMARY KEY (`record`)," |
190 "UNIQUE KEY `uuid` (`uuid`)," |
191 "UNIQUE KEY `uuid` (`uuid`)," |
191 "UNIQUE KEY `package` (`laboratory`,`form`,`package`)," |
192 "UNIQUE KEY `package` (`laboratory`,`form`,`package`)," |
192 "KEY `lab_form` (`laboratory`,`form`) USING BTREE" |
193 "KEY `lab_form` (`laboratory`,`form`) USING BTREE" |
193 ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Yeast packages data'"); |
194 ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Yeast packages data'"); |