/src/sql/labstocks_db.sql - Annoter - MyLabStocks - Forge du Centre Blaise Pascal

root / src / sql / labstocks_db.sql @ 38e8e479

Historique | Voir | Annoter | Télécharger (87,05 ko)

1	38e8e479	Florent Chuffart	-- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
2	73b5ba45	Florent Chuffart	--
3	38e8e479	Florent Chuffart	-- Host: localhost Database: labstocks_db
4	38e8e479	Florent Chuffart	-- ------------------------------------------------------
5	38e8e479	Florent Chuffart	-- Server version 5.5.31-0+wheezy1
6	73b5ba45	Florent Chuffart
7	73b5ba45	Florent Chuffart	/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
8	73b5ba45	Florent Chuffart	/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
9	73b5ba45	Florent Chuffart	/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
10	73b5ba45	Florent Chuffart	/!40101 SET NAMES utf8 /;
11	38e8e479	Florent Chuffart	/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
12	38e8e479	Florent Chuffart	/!40103 SET TIME_ZONE='+00:00' /;
13	38e8e479	Florent Chuffart	/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
14	38e8e479	Florent Chuffart	/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
15	38e8e479	Florent Chuffart	/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
16	38e8e479	Florent Chuffart	/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
17	73b5ba45	Florent Chuffart
18	73b5ba45	Florent Chuffart	--
19	73b5ba45	Florent Chuffart	-- Table structure for table `ab_avail`
20	73b5ba45	Florent Chuffart	--
21	73b5ba45	Florent Chuffart
22	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `ab_avail`;
23	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
24	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
25	38e8e479	Florent Chuffart	CREATE TABLE `ab_avail` (
26	38e8e479	Florent Chuffart	`Type` varchar(50) NOT NULL,
27	73b5ba45	Florent Chuffart	PRIMARY KEY (`Type`)
28	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
30	73b5ba45	Florent Chuffart
31	73b5ba45	Florent Chuffart	--
32	73b5ba45	Florent Chuffart	-- Dumping data for table `ab_avail`
33	73b5ba45	Florent Chuffart	--
34	73b5ba45	Florent Chuffart
35	38e8e479	Florent Chuffart	LOCK TABLES `ab_avail` WRITE;
36	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_avail` DISABLE KEYS /;
37	38e8e479	Florent Chuffart	INSERT INTO `ab_avail` VALUES ('available'),('out of stock');
38	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_avail` ENABLE KEYS /;
39	38e8e479	Florent Chuffart	UNLOCK TABLES;
40	73b5ba45	Florent Chuffart
41	73b5ba45	Florent Chuffart	--
42	73b5ba45	Florent Chuffart	-- Table structure for table `ab_host`
43	73b5ba45	Florent Chuffart	--
44	73b5ba45	Florent Chuffart
45	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `ab_host`;
46	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
47	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
48	38e8e479	Florent Chuffart	CREATE TABLE `ab_host` (
49	38e8e479	Florent Chuffart	`Host` varchar(50) NOT NULL,
50	73b5ba45	Florent Chuffart	PRIMARY KEY (`Host`)
51	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
53	73b5ba45	Florent Chuffart
54	73b5ba45	Florent Chuffart	--
55	73b5ba45	Florent Chuffart	-- Dumping data for table `ab_host`
56	73b5ba45	Florent Chuffart	--
57	73b5ba45	Florent Chuffart
58	38e8e479	Florent Chuffart	LOCK TABLES `ab_host` WRITE;
59	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_host` DISABLE KEYS /;
60	38e8e479	Florent Chuffart	INSERT INTO `ab_host` VALUES ('goat'),('horse'),('mouse'),('rabbit');
61	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_host` ENABLE KEYS /;
62	38e8e479	Florent Chuffart	UNLOCK TABLES;
63	73b5ba45	Florent Chuffart
64	73b5ba45	Florent Chuffart	--
65	73b5ba45	Florent Chuffart	-- Table structure for table `ab_monopoly`
66	73b5ba45	Florent Chuffart	--
67	73b5ba45	Florent Chuffart
68	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `ab_monopoly`;
69	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
70	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
71	38e8e479	Florent Chuffart	CREATE TABLE `ab_monopoly` (
72	38e8e479	Florent Chuffart	`Type` varchar(50) NOT NULL,
73	73b5ba45	Florent Chuffart	PRIMARY KEY (`Type`)
74	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
75	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
76	73b5ba45	Florent Chuffart
77	73b5ba45	Florent Chuffart	--
78	73b5ba45	Florent Chuffart	-- Dumping data for table `ab_monopoly`
79	73b5ba45	Florent Chuffart	--
80	73b5ba45	Florent Chuffart
81	38e8e479	Florent Chuffart	LOCK TABLES `ab_monopoly` WRITE;
82	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_monopoly` DISABLE KEYS /;
83	38e8e479	Florent Chuffart	INSERT INTO `ab_monopoly` VALUES ('monoclonal'),('polyclonal');
84	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_monopoly` ENABLE KEYS /;
85	38e8e479	Florent Chuffart	UNLOCK TABLES;
86	73b5ba45	Florent Chuffart
87	73b5ba45	Florent Chuffart	--
88	73b5ba45	Florent Chuffart	-- Table structure for table `ab_supplier`
89	73b5ba45	Florent Chuffart	--
90	73b5ba45	Florent Chuffart
91	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `ab_supplier`;
92	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
93	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
94	38e8e479	Florent Chuffart	CREATE TABLE `ab_supplier` (
95	38e8e479	Florent Chuffart	`Supplier` varchar(50) NOT NULL,
96	73b5ba45	Florent Chuffart	PRIMARY KEY (`Supplier`)
97	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
98	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
99	73b5ba45	Florent Chuffart
100	73b5ba45	Florent Chuffart	--
101	73b5ba45	Florent Chuffart	-- Dumping data for table `ab_supplier`
102	73b5ba45	Florent Chuffart	--
103	73b5ba45	Florent Chuffart
104	38e8e479	Florent Chuffart	LOCK TABLES `ab_supplier` WRITE;
105	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_supplier` DISABLE KEYS /;
106	38e8e479	Florent Chuffart	INSERT INTO `ab_supplier` VALUES ('Abcam'),('ActiveMotif'),('Covance/Eurogentec'),('Diagenode'),('MPBiomedicals'),('Sigma'),('Upstate/Millipore');
107	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_supplier` ENABLE KEYS /;
108	38e8e479	Florent Chuffart	UNLOCK TABLES;
109	73b5ba45	Florent Chuffart
110	73b5ba45	Florent Chuffart	--
111	73b5ba45	Florent Chuffart	-- Table structure for table `ab_type`
112	73b5ba45	Florent Chuffart	--
113	73b5ba45	Florent Chuffart
114	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `ab_type`;
115	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
116	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
117	38e8e479	Florent Chuffart	CREATE TABLE `ab_type` (
118	38e8e479	Florent Chuffart	`Type` varchar(50) NOT NULL,
119	73b5ba45	Florent Chuffart	PRIMARY KEY (`Type`)
120	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
121	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
122	73b5ba45	Florent Chuffart
123	73b5ba45	Florent Chuffart	--
124	73b5ba45	Florent Chuffart	-- Dumping data for table `ab_type`
125	73b5ba45	Florent Chuffart	--
126	73b5ba45	Florent Chuffart
127	38e8e479	Florent Chuffart	LOCK TABLES `ab_type` WRITE;
128	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_type` DISABLE KEYS /;
129	38e8e479	Florent Chuffart	INSERT INTO `ab_type` VALUES ('monoclonal'),('polyclonal');
130	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `ab_type` ENABLE KEYS /;
131	38e8e479	Florent Chuffart	UNLOCK TABLES;
132	73b5ba45	Florent Chuffart
133	73b5ba45	Florent Chuffart	--
134	73b5ba45	Florent Chuffart	-- Table structure for table `antibodies`
135	73b5ba45	Florent Chuffart	--
136	73b5ba45	Florent Chuffart
137	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `antibodies`;
138	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
139	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
140	38e8e479	Florent Chuffart	CREATE TABLE `antibodies` (
141	73b5ba45	Florent Chuffart	`id` int(15) NOT NULL,
142	73b5ba45	Florent Chuffart	`Antigen` varchar(150) NOT NULL,
143	73b5ba45	Florent Chuffart	`InStock` varchar(25) NOT NULL,
144	73b5ba45	Florent Chuffart	`Date` date DEFAULT NULL,
145	73b5ba45	Florent Chuffart	`Comments` longtext,
146	73b5ba45	Florent Chuffart	`Host` varchar(40) DEFAULT NULL,
147	73b5ba45	Florent Chuffart	`Ordered_by` varchar(50) DEFAULT NULL,
148	73b5ba45	Florent Chuffart	`Type` varchar(40) NOT NULL,
149	73b5ba45	Florent Chuffart	`Batch_Reference` varchar(40) DEFAULT NULL,
150	73b5ba45	Florent Chuffart	`Supplier` varchar(40) NOT NULL,
151	73b5ba45	Florent Chuffart	`Location` varchar(40) NOT NULL,
152	73b5ba45	Florent Chuffart	`Dilution-WB` text NOT NULL,
153	73b5ba45	Florent Chuffart	`Volume-ChIP` text NOT NULL,
154	73b5ba45	Florent Chuffart	`ProductID` varchar(20) NOT NULL,
155	38e8e479	Florent Chuffart	`storage_minus20freezers` varchar(100) DEFAULT NULL,
156	38e8e479	Florent Chuffart	`storage_minus80freezers` varchar(100) DEFAULT NULL,
157	38e8e479	Florent Chuffart	`storage_fridges` varchar(100) DEFAULT NULL,
158	38e8e479	Florent Chuffart	`storage_rooms` varchar(100) DEFAULT NULL,
159	73b5ba45	Florent Chuffart	PRIMARY KEY (`id`),
160	73b5ba45	Florent Chuffart	KEY `Author` (`Ordered_by`)
161	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
162	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
163	73b5ba45	Florent Chuffart
164	73b5ba45	Florent Chuffart	--
165	73b5ba45	Florent Chuffart	-- Dumping data for table `antibodies`
166	73b5ba45	Florent Chuffart	--
167	73b5ba45	Florent Chuffart
168	38e8e479	Florent Chuffart	LOCK TABLES `antibodies` WRITE;
169	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `antibodies` DISABLE KEYS /;
170	38e8e479	Florent Chuffart	INSERT INTO `antibodies` VALUES (1,'Actin C4','available','2008-09-11','used for WB control, do not use as control in case of TSA treatment: TSA is known to reduce actin expression.','mouse','Gael.Y','monoclonal','9045J','MPBiomedicals','Boite Ac Primaires#1 / Tiroir #3','1:20000','','69100',NULL,NULL,NULL,NULL);
171	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `antibodies` ENABLE KEYS /;
172	38e8e479	Florent Chuffart	UNLOCK TABLES;
173	73b5ba45	Florent Chuffart
174	38e8e479	Florent Chuffart	--
175	38e8e479	Florent Chuffart	-- Table structure for table `cl_name`
176	38e8e479	Florent Chuffart	--
177	38e8e479	Florent Chuffart
178	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `cl_name`;
179	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
180	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
181	38e8e479	Florent Chuffart	CREATE TABLE `cl_name` (
182	38e8e479	Florent Chuffart	`name` varchar(100) NOT NULL,
183	38e8e479	Florent Chuffart	`description` longtext,
184	38e8e479	Florent Chuffart	`origin` longtext,
185	38e8e479	Florent Chuffart	`type` varchar(100) DEFAULT NULL,
186	38e8e479	Florent Chuffart	PRIMARY KEY (`name`)
187	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
188	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
189	38e8e479	Florent Chuffart
190	38e8e479	Florent Chuffart	--
191	38e8e479	Florent Chuffart	-- Dumping data for table `cl_name`
192	38e8e479	Florent Chuffart	--
193	38e8e479	Florent Chuffart
194	38e8e479	Florent Chuffart	LOCK TABLES `cl_name` WRITE;
195	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_name` DISABLE KEYS /;
196	38e8e479	Florent Chuffart	INSERT INTO `cl_name` VALUES ('LCL_e','EBV-transformed B cell from Evelyne Manet','gift from Evelyne Manet','LCL'),('LCL_GFP','LCL with GFP on ...','Home made','LCL');
197	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_name` ENABLE KEYS /;
198	38e8e479	Florent Chuffart	UNLOCK TABLES;
199	38e8e479	Florent Chuffart
200	38e8e479	Florent Chuffart	--
201	38e8e479	Florent Chuffart	-- Table structure for table `cl_passages`
202	38e8e479	Florent Chuffart	--
203	38e8e479	Florent Chuffart
204	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `cl_passages`;
205	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
206	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
207	38e8e479	Florent Chuffart	CREATE TABLE `cl_passages` (
208	38e8e479	Florent Chuffart	`ID` int(15) unsigned NOT NULL AUTO_INCREMENT,
209	38e8e479	Florent Chuffart	`name` varchar(100) DEFAULT NULL,
210	38e8e479	Florent Chuffart	`passage` longtext,
211	38e8e479	Florent Chuffart	`date_of_freezing` date DEFAULT NULL,
212	38e8e479	Florent Chuffart	PRIMARY KEY (`ID`)
213	38e8e479	Florent Chuffart	) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
214	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
215	38e8e479	Florent Chuffart
216	38e8e479	Florent Chuffart	--
217	38e8e479	Florent Chuffart	-- Dumping data for table `cl_passages`
218	38e8e479	Florent Chuffart	--
219	38e8e479	Florent Chuffart
220	38e8e479	Florent Chuffart	LOCK TABLES `cl_passages` WRITE;
221	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_passages` DISABLE KEYS /;
222	38e8e479	Florent Chuffart	INSERT INTO `cl_passages` VALUES (1,'LCL_GFP','3','2014-02-18'),(2,'LCL_e','n+10','2014-02-19');
223	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_passages` ENABLE KEYS /;
224	38e8e479	Florent Chuffart	UNLOCK TABLES;
225	38e8e479	Florent Chuffart
226	38e8e479	Florent Chuffart	--
227	38e8e479	Florent Chuffart	-- Table structure for table `cl_storage`
228	38e8e479	Florent Chuffart	--
229	38e8e479	Florent Chuffart
230	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `cl_storage`;
231	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
232	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
233	38e8e479	Florent Chuffart	CREATE TABLE `cl_storage` (
234	38e8e479	Florent Chuffart	`ID` int(15) unsigned NOT NULL AUTO_INCREMENT,
235	38e8e479	Florent Chuffart	`container` varchar(50) DEFAULT NULL,
236	38e8e479	Florent Chuffart	`rack` varchar(50) DEFAULT NULL,
237	38e8e479	Florent Chuffart	`box` varchar(50) DEFAULT NULL,
238	38e8e479	Florent Chuffart	`field` varchar(50) DEFAULT NULL,
239	38e8e479	Florent Chuffart	`cl_passages` int(15) DEFAULT NULL,
240	38e8e479	Florent Chuffart	PRIMARY KEY (`ID`)
241	38e8e479	Florent Chuffart	) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8;
242	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
243	38e8e479	Florent Chuffart
244	38e8e479	Florent Chuffart	--
245	38e8e479	Florent Chuffart	-- Dumping data for table `cl_storage`
246	38e8e479	Florent Chuffart	--
247	38e8e479	Florent Chuffart
248	38e8e479	Florent Chuffart	LOCK TABLES `cl_storage` WRITE;
249	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_storage` DISABLE KEYS /;
250	38e8e479	Florent Chuffart	INSERT INTO `cl_storage` VALUES (1,'1','1','A','1',NULL),(2,'1','1','A','2',NULL),(3,'1','1','B','1',NULL),(4,'1','1','B','2',NULL),(5,'1','1','B','3',NULL),(6,'1','1','C','1',NULL),(7,'1','1','C','2',NULL),(8,'1','1','C','3',NULL),(9,'1','1','C','4',NULL),(10,'1','1','D','1',NULL),(11,'1','1','D','2',NULL),(12,'1','1','D','3',NULL),(13,'1','1','D','4',NULL),(14,'1','1','D','5',NULL),(15,'1','1','E','1',NULL),(16,'1','1','E','2',NULL),(17,'1','1','E','3',NULL),(18,'1','1','E','4',NULL),(19,'1','1','E','5',NULL),(20,'1','1','E','6',NULL),(21,'1','1','F','1',NULL),(22,'1','1','F','2',NULL),(23,'1','1','F','3',NULL),(24,'1','1','F','4',NULL),(25,'1','1','F','5',NULL),(26,'1','1','F','6',NULL),(27,'1','1','F','7',NULL),(28,'1','1','G','1',NULL),(29,'1','1','G','2',NULL),(30,'1','1','G','3',NULL),(31,'1','1','G','4',NULL),(32,'1','1','G','5',NULL),(33,'1','1','G','6',NULL),(34,'1','1','G','7',NULL),(35,'1','1','G','8',NULL),(36,'1','1','H','1',NULL),(37,'1','1','H','2',NULL),(38,'1','1','H','3',NULL),(39,'1','1','H','4',NULL),(40,'1','1','H','5',NULL),(41,'1','1','H','6',NULL),(42,'1','1','H','7',NULL),(43,'1','1','H','8',NULL),(44,'1','1','H','9',NULL),(45,'1','1','I','1',NULL),(46,'1','1','I','2',NULL),(47,'1','1','I','3',NULL),(48,'1','1','I','4',NULL),(49,'1','1','I','5',NULL),(50,'1','1','I','6',NULL),(51,'1','1','I','7',NULL),(52,'1','1','I','8',NULL),(53,'1','1','I','9',NULL),(54,'1','1','I','10',NULL),(55,'1','1','J','1',NULL),(56,'1','1','J','2',NULL),(57,'1','1','J','3',NULL),(58,'1','1','J','4',NULL),(59,'1','1','J','5',NULL),(60,'1','1','J','6',NULL),(61,'1','1','J','7',NULL),(62,'1','1','J','8',NULL),(63,'1','1','J','9',NULL),(64,'1','1','K','1',NULL),(65,'1','1','K','2',NULL),(66,'1','1','K','3',NULL),(67,'1','1','K','4',NULL),(68,'1','2','A','1',NULL),(69,'1','2','A','2',NULL),(70,'1','2','B','1',NULL),(71,'1','2','B','2',NULL),(72,'1','2','B','3',NULL),(73,'1','2','C','1',NULL),(74,'1','2','C','2',NULL),(75,'1','2','C','3',NULL),(76,'1','2','C','4',NULL),(77,'1','2','D','1',NULL),(78,'1','2','D','2',NULL),(79,'1','2','D','3',NULL),(80,'1','2','D','4',NULL),(81,'1','2','D','5',NULL),(82,'1','2','E','1',NULL),(83,'1','2','E','2',NULL),(84,'1','2','E','3',NULL),(85,'1','2','E','4',NULL),(86,'1','2','E','5',NULL),(87,'1','2','E','6',NULL),(88,'1','2','F','1',NULL),(89,'1','2','F','2',NULL),(90,'1','2','F','3',NULL),(91,'1','2','F','4',NULL),(92,'1','2','F','5',NULL),(93,'1','2','F','6',NULL),(94,'1','2','F','7',NULL),(95,'1','2','G','1',NULL),(96,'1','2','G','2',NULL),(97,'1','2','G','3',NULL),(98,'1','2','G','4',NULL),(99,'1','2','G','5',NULL),(100,'1','2','G','6',NULL),(101,'1','2','G','7',NULL),(102,'1','2','G','8',NULL),(103,'1','2','H','1',NULL),(104,'1','2','H','2',NULL),(105,'1','2','H','3',NULL),(106,'1','2','H','4',NULL),(107,'1','2','H','5',NULL),(108,'1','2','H','6',NULL),(109,'1','2','H','7',NULL),(110,'1','2','H','8',NULL),(111,'1','2','H','9',NULL),(112,'1','2','I','1',NULL),(113,'1','2','I','2',NULL),(114,'1','2','I','3',NULL),(115,'1','2','I','4',NULL),(116,'1','2','I','5',NULL),(117,'1','2','I','6',NULL),(118,'1','2','I','7',NULL),(119,'1','2','I','8',NULL),(120,'1','2','I','9',NULL),(121,'1','2','I','10',NULL),(122,'1','2','J','1',NULL),(123,'1','2','J','2',NULL),(124,'1','2','J','3',NULL),(125,'1','2','J','4',NULL),(126,'1','2','J','5',NULL),(127,'1','2','J','6',NULL),(128,'1','2','J','7',NULL),(129,'1','2','J','8',NULL),(130,'1','2','J','9',NULL),(131,'1','2','K','1',NULL),(132,'1','2','K','2',NULL),(133,'1','2','K','3',NULL),(134,'1','2','K','4',NULL),(135,'2','1','A','1',NULL),(136,'2','1','A','2',NULL),(137,'2','1','B','1',NULL),(138,'2','1','B','2',NULL),(139,'2','1','B','3',NULL),(140,'2','1','C','1',NULL),(141,'2','1','C','2',NULL),(142,'2','1','C','3',NULL),(143,'2','1','C','4',NULL),(144,'2','1','D','1',NULL),(145,'2','1','D','2',NULL),(146,'2','1','D','3',NULL),(147,'2','1','D','4',NULL),(148,'2','1','D','5',NULL),(149,'2','1','E','1',NULL),(150,'2','1','E','2',NULL),(151,'2','1','E','3',NULL),(152,'2','1','E','4',NULL),(153,'2','1','E','5',NULL),(154,'2','1','E','6',NULL),(155,'2','1','F','1',NULL),(156,'2','1','F','2',NULL),(157,'2','1','F','3',NULL),(158,'2','1','F','4',NULL),(159,'2','1','F','5',NULL),(160,'2','1','F','6',NULL),(161,'2','1','F','7',NULL),(162,'2','1','G','1',NULL),(163,'2','1','G','2',NULL),(164,'2','1','G','3',NULL),(165,'2','1','G','4',NULL),(166,'2','1','G','5',NULL),(167,'2','1','G','6',NULL),(168,'2','1','G','7',NULL),(169,'2','1','G','8',NULL),(170,'2','1','H','1',NULL),(171,'2','1','H','2',NULL),(172,'2','1','H','3',NULL),(173,'2','1','H','4',NULL),(174,'2','1','H','5',NULL),(175,'2','1','H','6',NULL),(176,'2','1','H','7',NULL),(177,'2','1','H','8',NULL),(178,'2','1','H','9',NULL),(179,'2','1','I','1',NULL),(180,'2','1','I','2',NULL),(181,'2','1','I','3',NULL),(182,'2','1','I','4',NULL),(183,'2','1','I','5',NULL),(184,'2','1','I','6',NULL),(185,'2','1','I','7',NULL),(186,'2','1','I','8',NULL),(187,'2','1','I','9',NULL),(188,'2','1','I','10',NULL),(189,'2','1','J','1',NULL),(190,'2','1','J','2',NULL),(191,'2','1','J','3',NULL),(192,'2','1','J','4',NULL),(193,'2','1','J','5',NULL),(194,'2','1','J','6',NULL),(195,'2','1','J','7',NULL),(196,'2','1','J','8',NULL),(197,'2','1','J','9',NULL),(198,'2','1','K','1',NULL),(199,'2','1','K','2',NULL),(200,'2','1','K','3',NULL),(201,'2','1','K','4',NULL),(202,'2','2','A','1',NULL),(203,'2','2','A','2',NULL),(204,'2','2','B','1',NULL),(205,'2','2','B','2',NULL),(206,'2','2','B','3',NULL),(207,'2','2','C','1',NULL),(208,'2','2','C','2',NULL),(209,'2','2','C','3',NULL),(210,'2','2','C','4',NULL),(211,'2','2','D','1',NULL),(212,'2','2','D','2',NULL),(213,'2','2','D','3',NULL),(214,'2','2','D','4',NULL),(215,'2','2','D','5',NULL),(216,'2','2','E','1',NULL),(217,'2','2','E','2',NULL),(218,'2','2','E','3',NULL),(219,'2','2','E','4',NULL),(220,'2','2','E','5',NULL),(221,'2','2','E','6',NULL),(222,'2','2','F','1',NULL),(223,'2','2','F','2',NULL),(224,'2','2','F','3',NULL),(225,'2','2','F','4',NULL),(226,'2','2','F','5',NULL),(227,'2','2','F','6',NULL),(228,'2','2','F','7',NULL),(229,'2','2','G','1',NULL),(230,'2','2','G','2',NULL),(231,'2','2','G','3',NULL),(232,'2','2','G','4',NULL),(233,'2','2','G','5',NULL),(234,'2','2','G','6',NULL),(235,'2','2','G','7',NULL),(236,'2','2','G','8',NULL),(237,'2','2','H','1',NULL),(238,'2','2','H','2',NULL),(239,'2','2','H','3',NULL),(240,'2','2','H','4',NULL),(241,'2','2','H','5',NULL),(242,'2','2','H','6',NULL),(243,'2','2','H','7',NULL),(244,'2','2','H','8',NULL),(245,'2','2','H','9',NULL),(246,'2','2','I','1',NULL),(247,'2','2','I','2',NULL),(248,'2','2','I','3',NULL),(249,'2','2','I','4',NULL),(250,'2','2','I','5',NULL),(251,'2','2','I','6',NULL),(252,'2','2','I','7',NULL),(253,'2','2','I','8',NULL),(254,'2','2','I','9',NULL),(255,'2','2','I','10',NULL),(256,'2','2','J','1',NULL),(257,'2','2','J','2',NULL),(258,'2','2','J','3',NULL),(259,'2','2','J','4',NULL),(260,'2','2','J','5',NULL),(261,'2','2','J','6',NULL),(262,'2','2','J','7',NULL),(263,'2','2','J','8',NULL),(264,'2','2','J','9',NULL),(265,'2','2','K','1',NULL),(266,'2','2','K','2',NULL),(267,'2','2','K','3',NULL),(268,'2','2','K','4',NULL),(269,'2','3','A','1',NULL),(270,'2','3','A','2',NULL),(271,'2','3','B','1',NULL),(272,'2','3','B','2',NULL),(273,'2','3','B','3',NULL),(274,'2','3','C','1',NULL),(275,'2','3','C','2',NULL),(276,'2','3','C','3',NULL),(277,'2','3','C','4',NULL),(278,'2','3','D','1',NULL),(279,'2','3','D','2',NULL),(280,'2','3','D','3',NULL),(281,'2','3','D','4',NULL),(282,'2','3','D','5',NULL),(283,'2','3','E','1',NULL),(284,'2','3','E','2',NULL),(285,'2','3','E','3',NULL),(286,'2','3','E','4',NULL),(287,'2','3','E','5',NULL),(288,'2','3','E','6',NULL),(289,'2','3','F','1',NULL),(290,'2','3','F','2',NULL),(291,'2','3','F','3',NULL),(292,'2','3','F','4',NULL),(293,'2','3','F','5',NULL),(294,'2','3','F','6',NULL),(295,'2','3','F','7',NULL),(296,'2','3','G','1',NULL),(297,'2','3','G','2',NULL),(298,'2','3','G','3',NULL),(299,'2','3','G','4',NULL),(300,'2','3','G','5',NULL),(301,'2','3','G','6',NULL),(302,'2','3','G','7',NULL),(303,'2','3','G','8',NULL),(304,'2','3','H','1',NULL),(305,'2','3','H','2',NULL),(306,'2','3','H','3',NULL),(307,'2','3','H','4',NULL),(308,'2','3','H','5',NULL),(309,'2','3','H','6',NULL),(310,'2','3','H','7',NULL),(311,'2','3','H','8',NULL),(312,'2','3','H','9',NULL),(313,'2','3','I','1',NULL),(314,'2','3','I','2',NULL),(315,'2','3','I','3',NULL),(316,'2','3','I','4',NULL),(317,'2','3','I','5',NULL),(318,'2','3','I','6',NULL),(319,'2','3','I','7',NULL),(320,'2','3','I','8',NULL),(321,'2','3','I','9',NULL),(322,'2','3','I','10',NULL),(323,'2','3','J','1',NULL),(324,'2','3','J','2',NULL),(325,'2','3','J','3',NULL),(326,'2','3','J','4',NULL),(327,'2','3','J','5',NULL),(328,'2','3','J','6',NULL),(329,'2','3','J','7',NULL),(330,'2','3','J','8',NULL),(331,'2','3','J','9',NULL),(332,'2','3','K','1',NULL),(333,'2','3','K','2',NULL),(334,'2','3','K','3',NULL),(335,'2','3','K','4',NULL);
251	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_storage` ENABLE KEYS /;
252	38e8e479	Florent Chuffart	UNLOCK TABLES;
253	38e8e479	Florent Chuffart
254	38e8e479	Florent Chuffart	--
255	38e8e479	Florent Chuffart	-- Table structure for table `cl_type`
256	38e8e479	Florent Chuffart	--
257	38e8e479	Florent Chuffart
258	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `cl_type`;
259	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
260	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
261	38e8e479	Florent Chuffart	CREATE TABLE `cl_type` (
262	38e8e479	Florent Chuffart	`type` varchar(100) NOT NULL,
263	38e8e479	Florent Chuffart	PRIMARY KEY (`type`)
264	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
265	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
266	38e8e479	Florent Chuffart
267	38e8e479	Florent Chuffart	--
268	38e8e479	Florent Chuffart	-- Dumping data for table `cl_type`
269	38e8e479	Florent Chuffart	--
270	38e8e479	Florent Chuffart
271	38e8e479	Florent Chuffart	LOCK TABLES `cl_type` WRITE;
272	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_type` DISABLE KEYS /;
273	38e8e479	Florent Chuffart	INSERT INTO `cl_type` VALUES ('HEK293'),('HeLa'),('LCL');
274	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `cl_type` ENABLE KEYS /;
275	38e8e479	Florent Chuffart	UNLOCK TABLES;
276	73b5ba45	Florent Chuffart
277	73b5ba45	Florent Chuffart	--
278	73b5ba45	Florent Chuffart	-- Table structure for table `lab_members`
279	73b5ba45	Florent Chuffart	--
280	73b5ba45	Florent Chuffart
281	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `lab_members`;
282	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
283	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
284	38e8e479	Florent Chuffart	CREATE TABLE `lab_members` (
285	73b5ba45	Florent Chuffart	`id` varchar(50) NOT NULL,
286	73b5ba45	Florent Chuffart	PRIMARY KEY (`id`)
287	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
288	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
289	73b5ba45	Florent Chuffart
290	73b5ba45	Florent Chuffart	--
291	73b5ba45	Florent Chuffart	-- Dumping data for table `lab_members`
292	73b5ba45	Florent Chuffart	--
293	73b5ba45	Florent Chuffart
294	38e8e479	Florent Chuffart	LOCK TABLES `lab_members` WRITE;
295	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `lab_members` DISABLE KEYS /;
296	38e8e479	Florent Chuffart	INSERT INTO `lab_members` VALUES ('Christelle.D'),('Florent.C'),('Gael.Y'),('Gift.or.Purchased'),('Helene.B');
297	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `lab_members` ENABLE KEYS /;
298	38e8e479	Florent Chuffart	UNLOCK TABLES;
299	73b5ba45	Florent Chuffart
300	73b5ba45	Florent Chuffart	--
301	73b5ba45	Florent Chuffart	-- Table structure for table `notebooks`
302	73b5ba45	Florent Chuffart	--
303	73b5ba45	Florent Chuffart
304	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `notebooks`;
305	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
306	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
307	38e8e479	Florent Chuffart	CREATE TABLE `notebooks` (
308	73b5ba45	Florent Chuffart	`ID` int(15) unsigned NOT NULL,
309	73b5ba45	Florent Chuffart	`Begin_Date` date DEFAULT NULL,
310	73b5ba45	Florent Chuffart	`End_Date` date DEFAULT NULL,
311	73b5ba45	Florent Chuffart	`Author` varchar(50) NOT NULL,
312	73b5ba45	Florent Chuffart	`Serial_Number` varchar(20) NOT NULL,
313	73b5ba45	Florent Chuffart	PRIMARY KEY (`ID`),
314	73b5ba45	Florent Chuffart	UNIQUE KEY `Serial_Number` (`Serial_Number`),
315	73b5ba45	Florent Chuffart	KEY `Author` (`Author`)
316	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
317	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
318	73b5ba45	Florent Chuffart
319	73b5ba45	Florent Chuffart	--
320	73b5ba45	Florent Chuffart	-- Dumping data for table `notebooks`
321	73b5ba45	Florent Chuffart	--
322	73b5ba45	Florent Chuffart
323	38e8e479	Florent Chuffart	LOCK TABLES `notebooks` WRITE;
324	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `notebooks` DISABLE KEYS /;
325	38e8e479	Florent Chuffart	INSERT INTO `notebooks` VALUES (1,'2005-04-01','2006-01-31','Gael.Y','GY8'),(2,'2005-05-24','2005-12-07','Christelle.D','CD1'),(3,'2008-01-16','0000-00-00','Helene.B','EVO'),(4,'2009-07-06','2010-01-19','Helene.B','B49069'),(5,'2012-09-03','0000-00-00','Florent.C','E002933');
326	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `notebooks` ENABLE KEYS /;
327	38e8e479	Florent Chuffart	UNLOCK TABLES;
328	38e8e479	Florent Chuffart
329	38e8e479	Florent Chuffart	--
330	38e8e479	Florent Chuffart	-- Table structure for table `olig_purif`
331	38e8e479	Florent Chuffart	--
332	38e8e479	Florent Chuffart
333	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `olig_purif`;
334	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
335	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
336	38e8e479	Florent Chuffart	CREATE TABLE `olig_purif` (
337	38e8e479	Florent Chuffart	`type` varchar(40) NOT NULL,
338	38e8e479	Florent Chuffart	PRIMARY KEY (`type`)
339	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
340	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
341	38e8e479	Florent Chuffart
342	38e8e479	Florent Chuffart	--
343	38e8e479	Florent Chuffart	-- Dumping data for table `olig_purif`
344	38e8e479	Florent Chuffart	--
345	38e8e479	Florent Chuffart
346	38e8e479	Florent Chuffart	LOCK TABLES `olig_purif` WRITE;
347	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `olig_purif` DISABLE KEYS /;
348	38e8e479	Florent Chuffart	INSERT INTO `olig_purif` VALUES (''),('Gold'),('HPLC'),('PAGE'),('SePoP');
349	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `olig_purif` ENABLE KEYS /;
350	38e8e479	Florent Chuffart	UNLOCK TABLES;
351	73b5ba45	Florent Chuffart
352	73b5ba45	Florent Chuffart	--
353	73b5ba45	Florent Chuffart	-- Table structure for table `oligos`
354	73b5ba45	Florent Chuffart	--
355	73b5ba45	Florent Chuffart
356	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `oligos`;
357	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
358	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
359	38e8e479	Florent Chuffart	CREATE TABLE `oligos` (
360	73b5ba45	Florent Chuffart	`id` char(15) NOT NULL,
361	73b5ba45	Florent Chuffart	`Sequence` varchar(150) NOT NULL,
362	73b5ba45	Florent Chuffart	`Date_` date DEFAULT NULL,
363	73b5ba45	Florent Chuffart	`Description` longtext,
364	73b5ba45	Florent Chuffart	`PCR_conditions_predicted` longtext,
365	73b5ba45	Florent Chuffart	`Author` varchar(50) DEFAULT NULL,
366	73b5ba45	Florent Chuffart	`Purif` varchar(40) NOT NULL,
367	38e8e479	Florent Chuffart	`storage_minus20freezers` varchar(100) DEFAULT NULL,
368	38e8e479	Florent Chuffart	`storage_minus80freezers` varchar(100) DEFAULT NULL,
369	38e8e479	Florent Chuffart	`storage_fridges` varchar(100) DEFAULT NULL,
370	38e8e479	Florent Chuffart	`storage_rooms` varchar(100) DEFAULT NULL,
371	73b5ba45	Florent Chuffart	PRIMARY KEY (`id`),
372	38e8e479	Florent Chuffart	KEY `Author` (`Author`),
373	38e8e479	Florent Chuffart	CONSTRAINT `oligos_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)
374	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
375	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
376	73b5ba45	Florent Chuffart
377	73b5ba45	Florent Chuffart	--
378	73b5ba45	Florent Chuffart	-- Dumping data for table `oligos`
379	73b5ba45	Florent Chuffart	--
380	73b5ba45	Florent Chuffart
381	38e8e479	Florent Chuffart	LOCK TABLES `oligos` WRITE;
382	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `oligos` DISABLE KEYS /;
383	38e8e479	Florent Chuffart	INSERT INTO `oligos` VALUES ('1C09','cttaatgcgccgctacaggg','2006-10-05','to screen bacteria for cloning of GAL3 fragment into pRS306',' #1: Product of length 475 (rating: 171)\r\n Contains region of the molecule from 4048 to 4522\r\n Tm: 80.5 C TaOpt: 58.6 C GC: 53.7\r\n Sense Primer:\r\n CTTAATGCGCCGCTACAGGG\r\n Similarity: 100.0%\r\n Length: 20 Tm: 57.2 C GC: 60.0\r\n dH: -170.4 kcal/mol dS: -437.5 cal/mol dG: -38.2 kcal/mol\r\n Antisense Primer:\r\n GCTACTGCGACTCTTAGGGCCAAT\r\n Similarity: 100.0%\r\n Length: 24 Tm: 58.9 C GC: 54.17\r\n dH: -191.8 kcal/mol dS: -495.6 cal/mol dG: -42.3 kcal/mol\r\n Tm Difference: 1.8\r\n GC Difference: 5.8\r\n','Gael.Y','',NULL,NULL,NULL,NULL),('1F14','gtgatgacggtgaaaacctc','2009-09-07','Upstream selection marker in pSH* plasmids.','','Gael.Y','',NULL,NULL,NULL,NULL),('1F19','ataagggcgacacggaaatg','2009-10-12','To sequence CEN/ARS of pCEN-AdeAru','','Gael.Y','',NULL,NULL,NULL,NULL),('1F97','tgtaacccactcgtgcac','2010-03-01','To sequence any plasmid from the AmpR coding sequence.','','Gael.Y','SePoP',NULL,NULL,NULL,NULL),('1H75','cactatagggcgaattgg','2011-01-06','To amplify yEGFP-CYC1term from pGY8 and clone it into pCM183 by homologous recombination in yeast.','','Gael.Y','SePoP',NULL,NULL,NULL,NULL),('1I97','atttagagcttgacggggaaagcc','2013-03-28','For Laser Game mutagenesis of Cre-VVD II.','Taille du fragment amplifié : 1531 nucl.\r\nGC% : 46%\r\nTempérature d\'hybridation suggérée (TA) : 57°C\r\nAmorce sens : 1I96\r\nAmorce anti-sens : 1I97\r\n\r\nPrimer: 1I96 (1) 5\' tacctgttttgccgggtcagaa 3\' (22)\r\n \|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\r\nTarget: (4077) 5\' tacctgttttgccgggtcagaa 3\' (4099)\r\nscore : 178\r\nTM : 58\r\n\r\n\r\nPrimer: 1I97[compl.] (24) \r\n3\' ggctttccccgtcaagctctaaat 5\' (1)\r\n \|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\|\r\nTarget: (5584) \r\n5\' ggctttccccgtcaagctctaaat 3\' (5608)\r\nscore : 180\r\nTM : 59\r\n\r\nTarget= pGY286','Helene.B','SePoP',NULL,NULL,NULL,NULL);
384	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `oligos` ENABLE KEYS /;
385	38e8e479	Florent Chuffart	UNLOCK TABLES;
386	73b5ba45	Florent Chuffart
387	73b5ba45	Florent Chuffart	--
388	73b5ba45	Florent Chuffart	-- Table structure for table `pip_events`
389	73b5ba45	Florent Chuffart	--
390	73b5ba45	Florent Chuffart
391	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_events`;
392	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
393	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
394	38e8e479	Florent Chuffart	CREATE TABLE `pip_events` (
395	38e8e479	Florent Chuffart	`Events` varchar(100) NOT NULL,
396	73b5ba45	Florent Chuffart	PRIMARY KEY (`Events`)
397	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
398	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
399	73b5ba45	Florent Chuffart
400	73b5ba45	Florent Chuffart	--
401	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_events`
402	73b5ba45	Florent Chuffart	--
403	73b5ba45	Florent Chuffart
404	38e8e479	Florent Chuffart	LOCK TABLES `pip_events` WRITE;
405	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_events` DISABLE KEYS /;
406	38e8e479	Florent Chuffart	INSERT INTO `pip_events` VALUES ('Change Usage'),('Change User'),('Discard'),('Maintenance'),('Misc'),('Purchase');
407	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_events` ENABLE KEYS /;
408	38e8e479	Florent Chuffart	UNLOCK TABLES;
409	73b5ba45	Florent Chuffart
410	73b5ba45	Florent Chuffart	--
411	73b5ba45	Florent Chuffart	-- Table structure for table `pip_generic_user`
412	73b5ba45	Florent Chuffart	--
413	73b5ba45	Florent Chuffart
414	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_generic_user`;
415	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
416	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
417	38e8e479	Florent Chuffart	CREATE TABLE `pip_generic_user` (
418	38e8e479	Florent Chuffart	`User` varchar(100) NOT NULL,
419	73b5ba45	Florent Chuffart	PRIMARY KEY (`User`)
420	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
421	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
422	73b5ba45	Florent Chuffart
423	73b5ba45	Florent Chuffart	--
424	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_generic_user`
425	73b5ba45	Florent Chuffart	--
426	73b5ba45	Florent Chuffart
427	38e8e479	Florent Chuffart	LOCK TABLES `pip_generic_user` WRITE;
428	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_generic_user` DISABLE KEYS /;
429	38e8e479	Florent Chuffart	INSERT INTO `pip_generic_user` VALUES ('Christelle.D'),('Everybody'),('Standby'),('Student');
430	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_generic_user` ENABLE KEYS /;
431	38e8e479	Florent Chuffart	UNLOCK TABLES;
432	73b5ba45	Florent Chuffart
433	73b5ba45	Florent Chuffart	--
434	73b5ba45	Florent Chuffart	-- Table structure for table `pip_history`
435	73b5ba45	Florent Chuffart	--
436	73b5ba45	Florent Chuffart
437	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_history`;
438	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
439	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
440	38e8e479	Florent Chuffart	CREATE TABLE `pip_history` (
441	73b5ba45	Florent Chuffart	`ID` int(10) NOT NULL AUTO_INCREMENT,
442	38e8e479	Florent Chuffart	`Serial_Number` varchar(50) NOT NULL,
443	73b5ba45	Florent Chuffart	`Date` date NOT NULL,
444	38e8e479	Florent Chuffart	`Owner_fromNowOn` varchar(50) NOT NULL,
445	38e8e479	Florent Chuffart	`Usage_fromNowOn` varchar(50) NOT NULL,
446	38e8e479	Florent Chuffart	`Event_Type` varchar(100) NOT NULL,
447	38e8e479	Florent Chuffart	`Comments` text NOT NULL,
448	73b5ba45	Florent Chuffart	PRIMARY KEY (`ID`)
449	38e8e479	Florent Chuffart	) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
450	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
451	73b5ba45	Florent Chuffart
452	73b5ba45	Florent Chuffart	--
453	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_history`
454	73b5ba45	Florent Chuffart	--
455	73b5ba45	Florent Chuffart
456	38e8e479	Florent Chuffart	LOCK TABLES `pip_history` WRITE;
457	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_history` DISABLE KEYS /;
458	38e8e479	Florent Chuffart	INSERT INTO `pip_history` VALUES (1,'Y60538M','2005-00-00','Christelle.D','Misc','Purchase',''),(2,'Y60538M','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(3,'Y60538M','2009-03-04','Helene.B','Misc','Maintenance','Change of parts (spring was broken 2009_02_12)'),(4,'Y58817M','2005-00-00','Christelle.D','Misc','Purchase',''),(5,'Y58817M','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(6,'Y58817M','2009-03-04','Helene.B','Misc','Maintenance','Change of parts '),(7,'Y63235M','2005-00-00','Christelle.D','Misc','Purchase',''),(8,'Y63235M','2009-03-04','Helene.B','Misc','Maintenance',''),(9,'Y63235M','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(10,'Z64108A','2005-00-00','Christelle.D','Misc','Purchase',''),(11,'Z64108A','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(12,'Z64108A','2009-03-04','Helene.B','Misc','Maintenance',''),(13,'2102895','2005-09-01','Everybody','Misc','Purchase',''),(14,'6133327','2007-03-02','Everybody','Misc','Purchase',''),(15,'Z64108A','2011-02-18','Andri.Leonidou','Misc','Change User','Previous user: Christelle Damon');
459	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_history` ENABLE KEYS /;
460	38e8e479	Florent Chuffart	UNLOCK TABLES;
461	73b5ba45	Florent Chuffart
462	73b5ba45	Florent Chuffart	--
463	73b5ba45	Florent Chuffart	-- Table structure for table `pip_marque`
464	73b5ba45	Florent Chuffart	--
465	73b5ba45	Florent Chuffart
466	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_marque`;
467	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
468	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
469	38e8e479	Florent Chuffart	CREATE TABLE `pip_marque` (
470	38e8e479	Florent Chuffart	`Marque` varchar(100) NOT NULL,
471	73b5ba45	Florent Chuffart	PRIMARY KEY (`Marque`)
472	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
473	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
474	73b5ba45	Florent Chuffart
475	73b5ba45	Florent Chuffart	--
476	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_marque`
477	73b5ba45	Florent Chuffart	--
478	73b5ba45	Florent Chuffart
479	38e8e479	Florent Chuffart	LOCK TABLES `pip_marque` WRITE;
480	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_marque` DISABLE KEYS /;
481	38e8e479	Florent Chuffart	INSERT INTO `pip_marque` VALUES ('BioHit'),('Eppendorf'),('Gilson');
482	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_marque` ENABLE KEYS /;
483	38e8e479	Florent Chuffart	UNLOCK TABLES;
484	73b5ba45	Florent Chuffart
485	73b5ba45	Florent Chuffart	--
486	73b5ba45	Florent Chuffart	-- Table structure for table `pip_nonusers`
487	73b5ba45	Florent Chuffart	--
488	73b5ba45	Florent Chuffart
489	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_nonusers`;
490	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
491	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
492	38e8e479	Florent Chuffart	CREATE TABLE `pip_nonusers` (
493	38e8e479	Florent Chuffart	`User` varchar(100) NOT NULL,
494	73b5ba45	Florent Chuffart	PRIMARY KEY (`User`)
495	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
496	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
497	73b5ba45	Florent Chuffart
498	73b5ba45	Florent Chuffart	--
499	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_nonusers`
500	73b5ba45	Florent Chuffart	--
501	73b5ba45	Florent Chuffart
502	38e8e479	Florent Chuffart	LOCK TABLES `pip_nonusers` WRITE;
503	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_nonusers` DISABLE KEYS /;
504	38e8e479	Florent Chuffart	INSERT INTO `pip_nonusers` VALUES ('Florent.C'),('Gift.or.Purchased');
505	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_nonusers` ENABLE KEYS /;
506	38e8e479	Florent Chuffart	UNLOCK TABLES;
507	73b5ba45	Florent Chuffart
508	73b5ba45	Florent Chuffart	--
509	73b5ba45	Florent Chuffart	-- Table structure for table `pip_stock`
510	73b5ba45	Florent Chuffart	--
511	73b5ba45	Florent Chuffart
512	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_stock`;
513	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
514	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
515	38e8e479	Florent Chuffart	CREATE TABLE `pip_stock` (
516	73b5ba45	Florent Chuffart	`ID` int(10) NOT NULL AUTO_INCREMENT,
517	38e8e479	Florent Chuffart	`Serial_Number` varchar(40) NOT NULL,
518	38e8e479	Florent Chuffart	`Marque` varchar(40) NOT NULL,
519	38e8e479	Florent Chuffart	`Type` varchar(50) NOT NULL,
520	73b5ba45	Florent Chuffart	PRIMARY KEY (`ID`),
521	73b5ba45	Florent Chuffart	UNIQUE KEY `Serial_Number` (`Serial_Number`)
522	38e8e479	Florent Chuffart	) ENGINE=MyISAM AUTO_INCREMENT=228 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
523	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
524	73b5ba45	Florent Chuffart
525	73b5ba45	Florent Chuffart	--
526	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_stock`
527	73b5ba45	Florent Chuffart	--
528	73b5ba45	Florent Chuffart
529	38e8e479	Florent Chuffart	LOCK TABLES `pip_stock` WRITE;
530	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_stock` DISABLE KEYS /;
531	38e8e479	Florent Chuffart	INSERT INTO `pip_stock` VALUES (1,'Y60538M','Gilson','P1000'),(2,'Y58817M','Gilson','P200'),(3,'Y63235M','Gilson','P20'),(4,'Z64108A','Gilson','P2'),(5,'2102895','Eppendorf','multicanaux_10-100ul'),(6,'6133327','BioHit','multicanaux_02-10ul');
532	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_stock` ENABLE KEYS /;
533	38e8e479	Florent Chuffart	UNLOCK TABLES;
534	73b5ba45	Florent Chuffart
535	73b5ba45	Florent Chuffart	--
536	73b5ba45	Florent Chuffart	-- Table structure for table `pip_type`
537	73b5ba45	Florent Chuffart	--
538	73b5ba45	Florent Chuffart
539	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_type`;
540	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
541	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
542	38e8e479	Florent Chuffart	CREATE TABLE `pip_type` (
543	38e8e479	Florent Chuffart	`Type` varchar(50) NOT NULL,
544	73b5ba45	Florent Chuffart	PRIMARY KEY (`Type`)
545	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
546	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
547	73b5ba45	Florent Chuffart
548	73b5ba45	Florent Chuffart	--
549	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_type`
550	73b5ba45	Florent Chuffart	--
551	73b5ba45	Florent Chuffart
552	38e8e479	Florent Chuffart	LOCK TABLES `pip_type` WRITE;
553	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_type` DISABLE KEYS /;
554	38e8e479	Florent Chuffart	INSERT INTO `pip_type` VALUES ('multicanaux_02-10ul'),('multicanaux_10-100ul'),('multicanaux_50-1200ul'),('P1000'),('P2'),('P20'),('P200');
555	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_type` ENABLE KEYS /;
556	38e8e479	Florent Chuffart	UNLOCK TABLES;
557	73b5ba45	Florent Chuffart
558	73b5ba45	Florent Chuffart	--
559	73b5ba45	Florent Chuffart	-- Table structure for table `pip_usage`
560	73b5ba45	Florent Chuffart	--
561	73b5ba45	Florent Chuffart
562	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_usage`;
563	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
564	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
565	38e8e479	Florent Chuffart	CREATE TABLE `pip_usage` (
566	38e8e479	Florent Chuffart	`Usage` varchar(100) NOT NULL,
567	73b5ba45	Florent Chuffart	PRIMARY KEY (`Usage`)
568	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
569	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
570	73b5ba45	Florent Chuffart
571	73b5ba45	Florent Chuffart	--
572	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_usage`
573	73b5ba45	Florent Chuffart	--
574	73b5ba45	Florent Chuffart
575	38e8e479	Florent Chuffart	LOCK TABLES `pip_usage` WRITE;
576	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_usage` DISABLE KEYS /;
577	38e8e479	Florent Chuffart	INSERT INTO `pip_usage` VALUES ('Cellular'),('Misc'),('RNA');
578	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_usage` ENABLE KEYS /;
579	38e8e479	Florent Chuffart	UNLOCK TABLES;
580	73b5ba45	Florent Chuffart
581	73b5ba45	Florent Chuffart	--
582	73b5ba45	Florent Chuffart	-- Table structure for table `pip_users`
583	73b5ba45	Florent Chuffart	--
584	73b5ba45	Florent Chuffart
585	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pip_users`;
586	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
587	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
588	38e8e479	Florent Chuffart	CREATE TABLE `pip_users` (
589	38e8e479	Florent Chuffart	`User` varchar(100) NOT NULL,
590	73b5ba45	Florent Chuffart	PRIMARY KEY (`User`)
591	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
592	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
593	73b5ba45	Florent Chuffart
594	73b5ba45	Florent Chuffart	--
595	73b5ba45	Florent Chuffart	-- Dumping data for table `pip_users`
596	73b5ba45	Florent Chuffart	--
597	73b5ba45	Florent Chuffart
598	38e8e479	Florent Chuffart	LOCK TABLES `pip_users` WRITE;
599	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_users` DISABLE KEYS /;
600	38e8e479	Florent Chuffart	INSERT INTO `pip_users` VALUES ('Christelle.D'),('Helene.B');
601	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pip_users` ENABLE KEYS /;
602	38e8e479	Florent Chuffart	UNLOCK TABLES;
603	73b5ba45	Florent Chuffart
604	73b5ba45	Florent Chuffart	--
605	73b5ba45	Florent Chuffart	-- Table structure for table `pl_bacterial_selection`
606	73b5ba45	Florent Chuffart	--
607	73b5ba45	Florent Chuffart
608	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pl_bacterial_selection`;
609	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
610	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
611	38e8e479	Florent Chuffart	CREATE TABLE `pl_bacterial_selection` (
612	38e8e479	Florent Chuffart	`type` varchar(40) NOT NULL,
613	73b5ba45	Florent Chuffart	PRIMARY KEY (`type`)
614	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
615	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
616	73b5ba45	Florent Chuffart
617	73b5ba45	Florent Chuffart	--
618	73b5ba45	Florent Chuffart	-- Dumping data for table `pl_bacterial_selection`
619	73b5ba45	Florent Chuffart	--
620	73b5ba45	Florent Chuffart
621	38e8e479	Florent Chuffart	LOCK TABLES `pl_bacterial_selection` WRITE;
622	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_bacterial_selection` DISABLE KEYS /;
623	38e8e479	Florent Chuffart	INSERT INTO `pl_bacterial_selection` VALUES (''),('Amp'),('Chloramphenicol'),('Kan');
624	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_bacterial_selection` ENABLE KEYS /;
625	38e8e479	Florent Chuffart	UNLOCK TABLES;
626	73b5ba45	Florent Chuffart
627	73b5ba45	Florent Chuffart	--
628	73b5ba45	Florent Chuffart	-- Table structure for table `pl_features`
629	73b5ba45	Florent Chuffart	--
630	73b5ba45	Florent Chuffart
631	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pl_features`;
632	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
633	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
634	38e8e479	Florent Chuffart	CREATE TABLE `pl_features` (
635	73b5ba45	Florent Chuffart	`id` int(10) NOT NULL AUTO_INCREMENT,
636	73b5ba45	Florent Chuffart	`Sequence` longtext NOT NULL,
637	73b5ba45	Florent Chuffart	`Date_` date DEFAULT NULL,
638	73b5ba45	Florent Chuffart	`Description` longtext,
639	38e8e479	Florent Chuffart	`Comments` longtext NOT NULL,
640	73b5ba45	Florent Chuffart	`Author` varchar(50) DEFAULT NULL,
641	73b5ba45	Florent Chuffart	`Category` varchar(15) NOT NULL DEFAULT 'OTH',
642	73b5ba45	Florent Chuffart	PRIMARY KEY (`id`),
643	73b5ba45	Florent Chuffart	UNIQUE KEY `Sequence` (`Sequence`(128)),
644	38e8e479	Florent Chuffart	KEY `Author` (`Author`),
645	38e8e479	Florent Chuffart	CONSTRAINT `pl_features_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)
646	38e8e479	Florent Chuffart	) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
647	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
648	73b5ba45	Florent Chuffart
649	73b5ba45	Florent Chuffart	--
650	73b5ba45	Florent Chuffart	-- Dumping data for table `pl_features`
651	73b5ba45	Florent Chuffart	--
652	73b5ba45	Florent Chuffart
653	38e8e479	Florent Chuffart	LOCK TABLES `pl_features` WRITE;
654	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_features` DISABLE KEYS /;
655	38e8e479	Florent Chuffart	INSERT INTO `pl_features` VALUES (1,'CGCTTGCCTGTAACTTACACGCGCCTCGTATCTTTTAATGATGGAATAATTTGGGAATTTACTCTGTGTTTATTTATTTTTATGTTTTGTATTTGGATTTTAGAAAGTAAATAAAGAAGGTAGAAGAGTTACGGAATGAAGAAAAAAAAATAAACAAAGGTTTAAAAAATTTCAACAAAAAGCGTACTTTACATATATATTTATTAGACAAGAAAAGCAGATTAAATAGATATACATTCGATTAACGATAAGTAAAATGTAAAATCACAGGATTTTCGTGTGTGGTCTTCTACACAGACAAGATGAAACAATTCGGCATTAATACCTGAGAGCAGGAAGAGCAAGATAAAAGGTAGTATTTGTTGGCGATCCCCCTAGAGTCTTTTACATCTTCGGAAAACAAAAACTATTTTTTCTTTAATTTCTTTTTTTACTTTCTATTTTTAATTTATATATTTATATTAAAAAATTTAAATTATAATTATTTTTATAGCACGTGATGAAAAGGACC','2013-06-11','CEN6/ARSH4','','Gael.Y','ORI'),(2,'ATAACTTCGTATAATGTATGCTATACGAAGTTAT','2013-06-11','LoxP','','Gael.Y','OTH'),(3,'ATGTCTAAAGGTGAAGAATTATTCACTGGTGTTGTCCCAATTTTGGTTGAATTAGATGGTGATGTTAATGGTCACAAATTTTCTGTCTCCGGTGAAGGTGAAGGTGATGCTACTTACGGTAAATTGACCTTAAAATTTATTTGTACTACTGGTAAATTGCCAGTTCCATGGCCAACCTTAGTCACTACTTTCGGTTATGGTGTTCAATGTTTTGCTAGATACCCAGATCATATGAAACAACATGACTTTTTCAAGTCTGCCATGCCAGAAGGTTATGTTCAAGAAAGAACTATTTTTTTCAAAGATGACGGTAACTACAAGACCAGAGCTGAAGTCAAGTTTGAAGGTGATACCTTAGTTAATAGAATCGAATTAAAAGGTATTGATTTTAAAGAAGATGGTAACATTTTAGGTCACAAATTGGAATACAACTATAACTCTCACAATGTTTACATCATGGCTGACAAACAAAAGAATGGTATCAAAGTTAACTTCAAAATTAGACACAACATTGAAGATGGTTCTGTTCAATTAGCTGACCATTATCAACAAAATACTCCAATTGGTGATGGTCCAGTCTTGTTACCAGACAACCATTACTTATCCACTCAATCTGCCTTATCCAAAGATCCAAACGAAAAGAGAGACCACATGGTCTTGTTAGAATTTGTTACTGCTGCTGGTATTACCCATGGTATGGATGAATTGTACAAA','2013-06-11','yEGFP3-CDS','','Gael.Y','REP'),(4,'atgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcttttaaagaggccctactggcgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagctttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtaccaacgatgttccctccaccaaaggtgttcttatgtag','2013-07-19','HIS3-CDS','','Gael.Y','SEL'),(5,'cgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttcccctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaag','2013-07-19','HIS3-prom','','Gael.Y','PRO'),(6,'tgacaccgattatttaaagctgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcga','2013-07-19','HIS3-term','','Gael.Y','TER');
656	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_features` ENABLE KEYS /;
657	38e8e479	Florent Chuffart	UNLOCK TABLES;
658	73b5ba45	Florent Chuffart
659	73b5ba45	Florent Chuffart	--
660	73b5ba45	Florent Chuffart	-- Table structure for table `pl_features_catname`
661	73b5ba45	Florent Chuffart	--
662	73b5ba45	Florent Chuffart
663	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pl_features_catname`;
664	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
665	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
666	38e8e479	Florent Chuffart	CREATE TABLE `pl_features_catname` (
667	38e8e479	Florent Chuffart	`Category` varchar(15) NOT NULL,
668	38e8e479	Florent Chuffart	`Name` varchar(50) DEFAULT NULL,
669	73b5ba45	Florent Chuffart	PRIMARY KEY (`Category`)
670	38e8e479	Florent Chuffart	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
671	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
672	73b5ba45	Florent Chuffart
673	73b5ba45	Florent Chuffart	--
674	73b5ba45	Florent Chuffart	-- Dumping data for table `pl_features_catname`
675	73b5ba45	Florent Chuffart	--
676	73b5ba45	Florent Chuffart
677	38e8e479	Florent Chuffart	LOCK TABLES `pl_features_catname` WRITE;
678	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_features_catname` DISABLE KEYS /;
679	38e8e479	Florent Chuffart	INSERT INTO `pl_features_catname` VALUES ('PRO','Promoters'),('REG','Regulatory sequences'),('TER','Terminators'),('SEL','Selectable markers'),('ORI','Replication origins'),('REP','Reporter genes'),('TAG','Affinity tags'),('LOC','Localization sequences'),('HYB','Hybrid genes'),('OTH','Miscellaneous features');
680	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_features_catname` ENABLE KEYS /;
681	38e8e479	Florent Chuffart	UNLOCK TABLES;
682	73b5ba45	Florent Chuffart
683	73b5ba45	Florent Chuffart	--
684	73b5ba45	Florent Chuffart	-- Table structure for table `pl_tag`
685	73b5ba45	Florent Chuffart	--
686	73b5ba45	Florent Chuffart
687	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pl_tag`;
688	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
689	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
690	38e8e479	Florent Chuffart	CREATE TABLE `pl_tag` (
691	38e8e479	Florent Chuffart	`type` varchar(40) NOT NULL,
692	73b5ba45	Florent Chuffart	PRIMARY KEY (`type`)
693	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
694	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
695	73b5ba45	Florent Chuffart
696	73b5ba45	Florent Chuffart	--
697	73b5ba45	Florent Chuffart	-- Dumping data for table `pl_tag`
698	73b5ba45	Florent Chuffart	--
699	73b5ba45	Florent Chuffart
700	38e8e479	Florent Chuffart	LOCK TABLES `pl_tag` WRITE;
701	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_tag` DISABLE KEYS /;
702	38e8e479	Florent Chuffart	INSERT INTO `pl_tag` VALUES (''),('FLAG'),('FlAsH'),('GST'),('HA'),('HIS'),('Myc'),('ProA'),('TAP');
703	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_tag` ENABLE KEYS /;
704	38e8e479	Florent Chuffart	UNLOCK TABLES;
705	73b5ba45	Florent Chuffart
706	73b5ba45	Florent Chuffart	--
707	73b5ba45	Florent Chuffart	-- Table structure for table `pl_type`
708	73b5ba45	Florent Chuffart	--
709	73b5ba45	Florent Chuffart
710	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pl_type`;
711	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
712	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
713	38e8e479	Florent Chuffart	CREATE TABLE `pl_type` (
714	38e8e479	Florent Chuffart	`type` varchar(40) NOT NULL,
715	73b5ba45	Florent Chuffart	PRIMARY KEY (`type`)
716	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
717	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
718	73b5ba45	Florent Chuffart
719	73b5ba45	Florent Chuffart	--
720	73b5ba45	Florent Chuffart	-- Dumping data for table `pl_type`
721	73b5ba45	Florent Chuffart	--
722	73b5ba45	Florent Chuffart
723	38e8e479	Florent Chuffart	LOCK TABLES `pl_type` WRITE;
724	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_type` DISABLE KEYS /;
725	38e8e479	Florent Chuffart	INSERT INTO `pl_type` VALUES (''),('2-mu'),('centromeric'),('integrative');
726	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_type` ENABLE KEYS /;
727	38e8e479	Florent Chuffart	UNLOCK TABLES;
728	73b5ba45	Florent Chuffart
729	73b5ba45	Florent Chuffart	--
730	73b5ba45	Florent Chuffart	-- Table structure for table `pl_yeast_marker`
731	73b5ba45	Florent Chuffart	--
732	73b5ba45	Florent Chuffart
733	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pl_yeast_marker`;
734	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
735	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
736	38e8e479	Florent Chuffart	CREATE TABLE `pl_yeast_marker` (
737	38e8e479	Florent Chuffart	`type` varchar(40) NOT NULL,
738	73b5ba45	Florent Chuffart	PRIMARY KEY (`type`)
739	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
740	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
741	73b5ba45	Florent Chuffart
742	73b5ba45	Florent Chuffart	--
743	73b5ba45	Florent Chuffart	-- Dumping data for table `pl_yeast_marker`
744	73b5ba45	Florent Chuffart	--
745	73b5ba45	Florent Chuffart
746	38e8e479	Florent Chuffart	LOCK TABLES `pl_yeast_marker` WRITE;
747	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_yeast_marker` DISABLE KEYS /;
748	38e8e479	Florent Chuffart	INSERT INTO `pl_yeast_marker` VALUES (''),('ADE2'),('bialaphos'),('CaURA3'),('HIS3'),('HIS3MX6'),('HphNT1'),('HygromycinB'),('Kan'),('KanMX'),('KanMX4'),('KlLEU2'),('KlTRP1'),('KlURA3'),('KlURA3MX4'),('LEU2'),('LYS2'),('Nat'),('NatMX'),('NatNT2'),('phleomycin'),('spHIS5'),('TRP1'),('URA3');
749	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_yeast_marker` ENABLE KEYS /;
750	38e8e479	Florent Chuffart	UNLOCK TABLES;
751	73b5ba45	Florent Chuffart
752	73b5ba45	Florent Chuffart	--
753	73b5ba45	Florent Chuffart	-- Table structure for table `pl_yeast_promoter`
754	73b5ba45	Florent Chuffart	--
755	73b5ba45	Florent Chuffart
756	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `pl_yeast_promoter`;
757	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
758	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
759	38e8e479	Florent Chuffart	CREATE TABLE `pl_yeast_promoter` (
760	38e8e479	Florent Chuffart	`type` varchar(40) NOT NULL,
761	73b5ba45	Florent Chuffart	PRIMARY KEY (`type`)
762	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
763	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
764	73b5ba45	Florent Chuffart
765	73b5ba45	Florent Chuffart	--
766	73b5ba45	Florent Chuffart	-- Dumping data for table `pl_yeast_promoter`
767	73b5ba45	Florent Chuffart	--
768	73b5ba45	Florent Chuffart
769	38e8e479	Florent Chuffart	LOCK TABLES `pl_yeast_promoter` WRITE;
770	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_yeast_promoter` DISABLE KEYS /;
771	38e8e479	Florent Chuffart	INSERT INTO `pl_yeast_promoter` VALUES (''),('ADH'),('CUP1'),('CYC1'),('GAL'),('GAL1'),('GALL'),('GALS'),('GPD'),('MET25'),('TEF');
772	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `pl_yeast_promoter` ENABLE KEYS /;
773	38e8e479	Florent Chuffart	UNLOCK TABLES;
774	73b5ba45	Florent Chuffart
775	73b5ba45	Florent Chuffart	--
776	38e8e479	Florent Chuffart	-- Table structure for table `plasmids`
777	73b5ba45	Florent Chuffart	--
778	73b5ba45	Florent Chuffart
779	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `plasmids`;
780	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
781	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
782	38e8e479	Florent Chuffart	CREATE TABLE `plasmids` (
783	73b5ba45	Florent Chuffart	`id` int(10) unsigned NOT NULL,
784	38e8e479	Florent Chuffart	`Name_` varchar(50) DEFAULT NULL,
785	38e8e479	Florent Chuffart	`Other_names` varchar(50) DEFAULT NULL,
786	38e8e479	Florent Chuffart	`date_` date DEFAULT NULL,
787	38e8e479	Florent Chuffart	`Checkings` varchar(200) DEFAULT NULL,
788	38e8e479	Florent Chuffart	`Type_` varchar(25) DEFAULT NULL,
789	38e8e479	Florent Chuffart	`Marker_1` varchar(25) DEFAULT NULL,
790	38e8e479	Florent Chuffart	`Marker_2` varchar(25) DEFAULT NULL,
791	38e8e479	Florent Chuffart	`Bacterial_selection` varchar(25) DEFAULT NULL,
792	38e8e479	Florent Chuffart	`Tags` varchar(25) DEFAULT NULL,
793	38e8e479	Florent Chuffart	`parent_vector` varchar(50) DEFAULT NULL,
794	38e8e479	Florent Chuffart	`Insert_` varchar(50) DEFAULT NULL,
795	38e8e479	Florent Chuffart	`Insert_Type` varchar(25) DEFAULT NULL,
796	38e8e479	Florent Chuffart	`Construction_Description` longtext,
797	38e8e479	Florent Chuffart	`Reference_` varchar(200) DEFAULT NULL,
798	38e8e479	Florent Chuffart	`Reporter` varchar(25) DEFAULT NULL,
799	38e8e479	Florent Chuffart	`Promoter` varchar(25) DEFAULT NULL,
800	38e8e479	Florent Chuffart	`Link_to_file` varchar(100) DEFAULT NULL,
801	38e8e479	Florent Chuffart	`sequence` text,
802	38e8e479	Florent Chuffart	`image_file` varchar(100) DEFAULT NULL,
803	73b5ba45	Florent Chuffart	`Author` varchar(50) DEFAULT NULL,
804	38e8e479	Florent Chuffart	`storage_minus20freezers` varchar(100) DEFAULT NULL,
805	38e8e479	Florent Chuffart	`storage_minus80freezers` varchar(100) DEFAULT NULL,
806	38e8e479	Florent Chuffart	`storage_fridges` varchar(100) DEFAULT NULL,
807	38e8e479	Florent Chuffart	`storage_rooms` varchar(100) DEFAULT NULL,
808	73b5ba45	Florent Chuffart	PRIMARY KEY (`id`),
809	38e8e479	Florent Chuffart	UNIQUE KEY `Link_to_file` (`Link_to_file`),
810	38e8e479	Florent Chuffart	UNIQUE KEY `Link_to_file_2` (`Link_to_file`),
811	38e8e479	Florent Chuffart	KEY `Author` (`Author`),
812	38e8e479	Florent Chuffart	CONSTRAINT `plasmids_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)
813	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
814	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
815	73b5ba45	Florent Chuffart
816	73b5ba45	Florent Chuffart	--
817	38e8e479	Florent Chuffart	-- Dumping data for table `plasmids`
818	73b5ba45	Florent Chuffart	--
819	73b5ba45	Florent Chuffart
820	38e8e479	Florent Chuffart	LOCK TABLES `plasmids` WRITE;
821	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `plasmids` DISABLE KEYS /;
822	38e8e479	Florent Chuffart	INSERT INTO `plasmids` VALUES (1,'pRSII303',NULL,'2013-05-28','','centromeric','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n\r\n','','Lac Z','','pRSII303.gb.gz','TCGCGCGTTTCGGTGATGACGGTGAAAACCTCTGACACATGCAGCTCCCGGAGACGGTCACAGCTTGTCTGTAAGCGGATGCCGGGAGCAGACAAGCCCGTCAGGGCGCGTCAGCGGGTGTTGGCGGGTGTCGGGGCTGGCTTAACTATGCGGCATCAGAGCAGATTGTACTGAGAGTGCACCATAAATTCCCGTTTTAAGAGCTTGGTGAGCGCTAGGAGTCACTGCCAGGTATCGTTTGAACACGGCATTAGTCAGGGAAGTCATAACACAGTCCTTTCCCGCAATTTTCTTTTTCTATTACTCTTGGCCTCCTCTAGTACACTCTATATTTTTTTATGCCTCGGTAATGATTTTCATTTTTTTTTTTCCACCTAGCGGATGACTCTTTTTTTTTCTTAGCGATTGGCATTATCACATAATGAATTATACATTATATAAAGTAATGTGATTTCTTCGAAGAATATACTAAAAAATGAGCAGGCAAGATAAACGAAGGCAAAGATGACAGAGCAGAAAGCCCTAGTAAAGCGTATTACAAATGAAACCAAGATTCAGATTGCGATCTCTTTAAAGGGTGGTCCCCTAGCGATAGAGCACTCGATCTTCCCAGAAAAAGAGGCAGAAGCAGTAGCAGAACAGGCCACACAATCGCAAGTGATTAACGTCCACACAGGTATAGGGTTTCTGGACCATATGATACATGCTCTGGCCAAGCATTCCGGCTGGTCGCTAATCGTTGAGTGCATTGGTGACTTACACATAGACGACCATCACACCACTGAAGACTGCGGGATTGCTCTCGGTCAAGCATTTAAAGAGGCCCTAGGGGCCGTGCGTGGAGTAAAAAGGTTTGGATCAGGATTTGCGCCTTTGGATGAGGCACTTTCCAGAGCGGTGGTAGATCTTTCGAACAGGCCGTACGCAGTTGTCGAACTTGGTTTGCAAAGGGAGAAAGTAGGAGATCTCTCTTGCGAGATGATCCCGCATTTTCTTGAAAGTTTTGCAGAGGCTAGCAGAATTACCCTCCACGTTGATTGTCTGCGAGGCAAGAATGATCATCACCGTAGTGAGAGTGCGTTCAAGGCTCTTGCGGTTGCCATAAGAGAAGCCACCTCGCCCAATGGTACAAACGATGTTCCCTCCACCAAAGGTGTTCTTATGTAGTGACACCGATTATTTAAAGTTGCAGCATACGATATATATACATGTGTATATATGTATACCTATGAATGTCAGTAAGTATGTATACGAACAGTATGATACTGAAGATGACAAGGTAATGCATCATTCTATACGTGTCATTCTGAACGAGGCGCGCTTTCCTTTTTTCTTTTTGCTTTTTCTTTTTTTTTCTCTTGAACTCGACGGATCTATGCGGTGTGAAATACCGCACAGATGCGTAAGGAGAAAATACCGCATCAGGAAATTGTAAGCGTTAATATTTTGTTAAAATTCGCGTTAAATTTTTGTTAAATCAGCTCATTTTTTAACCAATAGGCCGAAATCGGCAAAATCCCTTATAAATCAAAAGAATAGACCGAGATAGGGTTGAGTGTTGTTCCAGTTTGGAACAAGAGTCCACTATTAAAGAACGTGGACTCCAACGTCAAAGGGCGAAAAACCGTCTATCAGGGCGATGGCCCACTACGTGAACCATCACCCTAATCAAGTTTTTTGGGGTCGAGGTGCCGTAAAGCACTAAATCGGAACCCTAAAGGGAGCCCCCGATTTAGAGCTTGACGGGGAAAGCCGGCGAACGTGGCGAGAAAGGAAGGGAAGAAAGCGAAAGGAGCGGGCGCTAGGGCGCTGGCAAGTGTAGCGGTCACGCTGCGCGTAACCACCACACCCGCCGCGCTTAATGCGCCGCTACAGGGCGCGTCCATTCGCCATTCAGGCTGCGCAACTGTTGGGAAGGGCGATCGGTGCGGGCCTCTTCGCTATTACGCCAGCTGGCGAAAGGGGGATGTGCTGCAAGGCGATTAAGTTGGGTAACGCCAGGGTTTTCCCAGTCACGACGTTGTAAAACGACGGCCAGTGAATTGTAATACGACTCACTATAGGGCGAATTGGAGCTCCACCGCGGTGGCGGCCGCTCTAGAACTAGTGGATCCCCCGGGCTGCAGGAATTCGATATCAAGCTTATCGATACCGTCGACCTCGAGGGGGGGCCCGGTACCAGCTTTTGTTCCCTTTAGTGAGGGTTAATTTCGAGCTTGGCGTAATCATGGTCATAGCTGTTTCCTGTGTGAAATTGTTATCCGCTCACAATTCCACACAACATACGAGCCGGAAGCATAAAGTGTAAAGCCTGGGGTGCCTAATGAGTGAGCTAACTCACATTAATTGCGTTGCGCTCACTGCCCGCTTTCCAGTCGGGAAACCTGTCGTGCCAGCTGCATTAATGAATCGGCCAACGCGCGGGGAGAGGCGGTTTGCGTATTGGGCGCTCTTCCGCTTCCTCGCTCACTGACTCGCTGCGCTCGGTCGTTCGGCTGCGGCGAGCGGTATCAGCTCACTCAAAGGCGGTAATACGGTTATCCACAGAATCAGGGGATAACGCAGGAAAGAACATGTGAGCAAAAGGCCAGCAAAAGGCCAGGAACCGTAAAAAGGCCGCGTTGCTGGCGTTTTTCCATAGGCTCCGCCCCCCTGACGAGCATCACAAAAATCGACGCTCAAGTCAGAGGTGGCGAAACCCGACAGGACTATAAAGATACCAGGCGTTTCCCCCTGGAAGCTCCCTCGTGCGCTCTCCTGTTCCGACCCTGCCGCTTACCGGATACCTGTCCGCCTTTCTCCCTTCGGGAAGCGTGGCGCTTTCTCATAGCTCACGCTGTAGGTATCTCAGTTCGGTGTAGGTCGTTCGCTCCAAGCTGGGCTGTGTGCACGAACCCCCCGTTCAGCCCGACCGCTGCGCCTTATCCGGTAACTATCGTCTTGAGTCCAACCCGGTAAGACACGACTTATCGCCACTGGCAGCAGCCACTGGTAACAGGATTAGCAGAGCGAGGTATGTAGGCGGTGCTACAGAGTTCTTGAAGTGGTGGCCTAACTACGGCTACACTAGAAGAACAGTATTTGGTATCTGCGCTCTGCTGAAGCCAGTTACCTTCGGAAAAAGAGTTGGTAGCTCTTGATCCGGCAAACAAACCACCGCTGGTAGCGGTGGTTTTTTTGTTTGCAAGCAGCAGATTACGCGCAGAAAAAAAGGATCTCAAGAAGATCCTTTGATCTTTTCTACGGGGTCTGACGCTCAGTGGAACGAAAACTCACGTTAAGGGATTTTGGTCATGAGATTATCAAAAAGGATCTTCACCTAGATCCTTTTAAATTAAAAATGAAGTTTTAAATCAATCTAAAGTATATATGAGTAAACTTGGTCTGACAGTTACCAATGCTTAATCAGTGAGGCACCTATCTCAGCGATCTGTCTATTTCGTTCATCCATAGTTGCCTGACTCCCCGTCGTGTAGATAACTACGATACGGGAGGGCTTACCATCTGGCCCCAGTGCTGCAATGATACCGCGAGACCCACGCTCACCGGCTCCAGATTTATCAGCAATAAACCAGCCAGCCGGAAGGGCCGAGCGCAGAAGTGGTCCTGCAACTTTATCCGCCTCCATCCAGTCTATTAATTGTTGCCGGGAAGCTAGAGTAAGTAGTTCGCCAGTTAATAGTTTGCGCAACGTTGTTGCCATTGCTACAGGCATCGTGGTGTCACGCTCGTCGTTTGGTATGGCTTCATTCAGCTCCGGTTCCCAACGATCAAGGCGAGTTACATGATCCCCCATGTTGTGCAAAAAAGCGGTTAGCTCCTTCGGTCCTCCGATCGTTGTCAGAAGTAAGTTGGCCGCAGTGTTATCACTCATGGTTATGGCAGCACTGCATAATTCTCTTACTGTCATGCCATCCGTAAGATGCTTTTCTGTGACTGGTGAGTACTCAACCAAGTCATTCTGAGAATAGTGTATGCGGCGACCGAGTTGCTCTTGCCCGGCGTCAATACGGGATAATACCGCGCCACATAGCAGAACTTTAAAAGTGCTCATCATTGGAAAACGTTCTTCGGGGCGAAAACTCTCAAGGATCTTACCGCTGTTGAGATCCAGTTCGATGTAACCCACTCGTGCACCCAACTGATCTTCAGCATCTTTTACTTTCACCAGCGTTTCTGGGTGAGCAAAAACAGGAAGGCAAAATGCCGCAAAAAAGGGAATAAGGGCGACACGGAAATGTTGAATACTCATACTCTTCCTTTTTCAATATTATTGAAGCATTTATCAGGGTTATTGTCTCATGAGCGGATACATATTTGAATGTATTTAGAAAAATAAACAAATAGGGGTTCCGCGCACATTTCCCCGAAAAGTGCCACCTGACGTCTAAGAAACCATTATTATCATGACATTAACCTATAAAAATAGGCGTATCACGAGGCCCTTTCGTC',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(2,'pRSII403',NULL,'2013-05-28','','centromeric','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n\r\n','','Lac Z','','pRSII403.gb.gz','tcgcgcgtttcggtgatgacggtgaaaacctctgacacatgcagctcccggagacggtcacagcttgtctgtaagcggatgccgggagcagacaagcccgtcagggcgcgtcagcgggtgttggcgggtgtcggggctggcttaactatgcggcatcagagcagattgtactgagagtgcaccataaattcccgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttccAcctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaagatgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcAtttaaagaggccctaGGggcCGTgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagTtttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtacAaacgatgttccctccaccaaaggtgttcttatgtagtgacaccgattatttaaagTtgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcgacggatctatgcggtgtgaaataccgcacagatgcgtaaggagaaaataccgcatcaggaaattgtaaGcgttaatattttgttaaaattcgcgttaaatttttgttaaatcagctcattttttaaccaataggccgaaatcggcaaaatcccttataaatcaaaagaatagaccgagatagggttgagtgttgttccagtttggaacaagagtccactattaaagaacgtggactccaacgtcaaagggcgaaaaaccgtctatcagggcgatggcccactacgtgaaccatcaccctaatcaagttttttggggtcgaggtgccgtaaagcactaaatcggaaccctaaagggagcccccgatttagagcttgacggggaaagccggcgaacgtggcgagaaaggaagggaagaaagcgaaaggagcgggcgctagggcgctggcaagtgtagcggtcacgctgcgcgtaaccaccacacccgccgcgcttaatgcgccgctacagggcgcgtccattcgccattcaggctgcgcaactgttgggaagggcgatcggtgcgggcctcttcgctattacgccagctggcgaaagggggatgtgctgcaaggcgattaagttgggtaacgccagggttttcccagtcacgacgttgtaaaacgacggccagtgagcgcgcgtaatacgactcactatagggcgaattgggtaccgggccccccctcgaggtcgacggtatcgataagcttgatatcgaattcctgcagcccgggggatccactagttctagagcggccgccaccgcggtggagctccagcttttgttccctttagtgagggttaattgcgcgcttggcgtaatcatggtcatagctgtttcctgtgtgaaattgttatccgctcacaattccacacaacataCgagccggaagcataaagtgtaaagcctggggtgcctaatgagtgagCtaactcacattaattgcgttgcgctcactgcccgctttccagtcgggaaacctgtcgtgccagctgcattaatgaatcggccaacgcgcggggagaggcggtttgcgtattgggcgctcttccgcttcctcgctcactgactcgctgcgctcggtcgttcggctgcggcgagcggtatcagctcactcaaaggcggtaatacggttatccacagaatcaggggataacgcaggaaagaacatgtgagcaaaaggccagcaaaaggccaggaaccgtaaaaaggccgcgttgctggcgtttttccataggctccgcccccctgacgagcatcacaaaaatcgacgctcaagtcagaggtggcgaaacccgacaggactataaagataccaggcgtttccccctggaagctccctcgtgcgctctcctgttccgaccctgccgcttaccggatacctgtccgcctttctcccttcgggaagcgtggcgctttctcatagctcacgctgtaggtatctcagttcggtgtaggtcgttcgctccaagctgggctgtgtgcacgaaccccccgttcagcccgaccgctgcgccttatccggtaactatcgtcttgagtccaacccggtaagacacgacttatcgccactggcagcagccactggtaacaggattagcagagcgaggtatgtaggcggtgctacagagttcttgaagtggtggcctaactacggctacactagaagAacagtatttggtatctgcgctctgctgaagccagttaccttcggaaaaagagttggtagctcttgatccggcaaacaaaccaccgctggtagcggtggtttttttgtttgcaagcagcagattacgcgcagaaaaaaaggatctcaagaagatcctttgatcttttctacggggtctgacgctcagtggaacgaaaactcacgttaagggattttggtcatgagattatcaaaaaggatcttcacctagatccttttaaattaaaaatgaagttttaaatcaatctaaagtatatatgagtaaacttggtctgacagttaccaatgcttaatcagtgaggcacctatctcagcgatctgtctatttcgttcatccatagttgcctgactccccgtcgtgtagataactacgatacgggagggcttaccatctggccccagtgctgcaatgataccgcgagacccacgctcaccggctccagatttatcagcaataaaccagccagccggaagggccgagcgcagaagtggtcctgcaactttatccgcctccatccagtctattaattgttgccgggaagctagagtaagtagttcgccagttaatagtttgcgcaacgttgttgccattgctacaggcatcgtggtgtcacgctcgtcgtttggtatggcttcattcagctccggttcccaacgatcaaggcgagttacatgatcccccatgttgtgcaaaaaagcggttagctccttcggtcctccgatcgttgtcagaagtaagttggccgcagtgttatcactcatggttatggcagcactgcataattctcttactgtcatgccatccgtaagatgcttttctgtgactggtgagtactcaaccaagtcattctgagaatagtgtatgcggcgaccgagttgctcttgcccggcgtcaatacgggataataccgcgccacatagcagaactttaaaagtgctcatcattggaaaacgttcttcggggcgaaaactctcaaggatcttaccgctgttgagatccagttcgatgtaacccactcgtgcacccaactgatcttcagcatcttttactttcaccagcgtttctgggtgagcaaaaacaggaaggcaaaatgccgcaaaaaagggaataagggcgacacggaaatgttgaatactcatactcttcctttttcaatattattgaagcatttatcagggttattgtctcatgagcggatacatatttgaatgtatttagaaaaataaacaaataggggttccgcgcacatttccccgaaaagtgccacctgacgtctaagaaaccattattatcatgacattaacctataaaaataggcgtatcacgaggccctttcgtc',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(3,'pRSII313',NULL,'2013-05-28','','integrative','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n','','Lac Z','','pRSII313.gb.gz','TCGCGCGTTTCGGTGATGACGGTGAAAACCTCTGACACATGCAGCTCCCGGAGACGGTCACAGCTTGTCTGTAAGCGGATGCCGGGAGCAGACAAGCCCGTCAGGGCGCGTCAGCGGGTGTTGGCGGGTGTCGGGGCTGGCTTAACTATGCGGCATCAGAGCAGATTGTACTGAGAGTGCACCATAAATTCCCGTTTTAAGAGCTTGGTGAGCGCTAGGAGTCACTGCCAGGTATCGTTTGAACACGGCATTAGTCAGGGAAGTCATAACACAGTCCTTTCCCGCAATTTTCTTTTTCTATTACTCTTGGCCTCCTCTAGTACACTCTATATTTTTTTATGCCTCGGTAATGATTTTCATTTTTTTTTTTCCACCTAGCGGATGACTCTTTTTTTTTCTTAGCGATTGGCATTATCACATAATGAATTATACATTATATAAAGTAATGTGATTTCTTCGAAGAATATACTAAAAAATGAGCAGGCAAGATAAACGAAGGCAAAGATGACAGAGCAGAAAGCCCTAGTAAAGCGTATTACAAATGAAACCAAGATTCAGATTGCGATCTCTTTAAAGGGTGGTCCCCTAGCGATAGAGCACTCGATCTTCCCAGAAAAAGAGGCAGAAGCAGTAGCAGAACAGGCCACACAATCGCAAGTGATTAACGTCCACACAGGTATAGGGTTTCTGGACCATATGATACATGCTCTGGCCAAGCATTCCGGCTGGTCGCTAATCGTTGAGTGCATTGGTGACTTACACATAGACGACCATCACACCACTGAAGACTGCGGGATTGCTCTCGGTCAAGCATTTAAAGAGGCCCTAGGGGCCGTGCGTGGAGTAAAAAGGTTTGGATCAGGATTTGCGCCTTTGGATGAGGCACTTTCCAGAGCGGTGGTAGATCTTTCGAACAGGCCGTACGCAGTTGTCGAACTTGGTTTGCAAAGGGAGAAAGTAGGAGATCTCTCTTGCGAGATGATCCCGCATTTTCTTGAAAGTTTTGCAGAGGCTAGCAGAATTACCCTCCACGTTGATTGTCTGCGAGGCAAGAATGATCATCACCGTAGTGAGAGTGCGTTCAAGGCTCTTGCGGTTGCCATAAGAGAAGCCACCTCGCCCAATGGTACAAACGATGTTCCCTCCACCAAAGGTGTTCTTATGTAGTGACACCGATTATTTAAAGTTGCAGCATACGATATATATACATGTGTATATATGTATACCTATGAATGTCAGTAAGTATGTATACGAACAGTATGATACTGAAGATGACAAGGTAATGCATCATTCTATACGTGTCATTCTGAACGAGGCGCGCTTTCCTTTTTTCTTTTTGCTTTTTCTTTTTTTTTCTCTTGAACTCGACGGATCTATGCGGTGTGAAATACCGCACAGATGCGTAAGGAGAAAATACCGCATCAGGAAATTGTAAGCGTTAATATTTTGTTAAAATTCGCGTTAAATTTTTGTTAAATCAGCTCATTTTTTAACCAATAGGCCGAAATCGGCAAAATCCCTTATAAATCAAAAGAATAGACCGAGATAGGGTTGAGTGTTGTTCCAGTTTGGAACAAGAGTCCACTATTAAAGAACGTGGACTCCAACGTCAAAGGGCGAAAAACCGTCTATCAGGGCGATGGCCCACTACGTGAACCATCACCCTAATCAAGTTTTTTGGGGTCGAGGTGCCGTAAAGCACTAAATCGGAACCCTAAAGGGAGCCCCCGATTTAGAGCTTGACGGGGAAAGCCGGCGAACGTGGCGAGAAAGGAAGGGAAGAAAGCGAAAGGAGCGGGCGCTAGGGCGCTGGCAAGTGTAGCGGTCACGCTGCGCGTAACCACCACACCCGCCGCGCTTAATGCGCCGCTACAGGGCGCGTCCATTCGCCATTCAGGCTGCGCAACTGTTGGGAAGGGCGATCGGTGCGGGCCTCTTCGCTATTACGCCAGCTGGCGAAAGGGGGATGTGCTGCAAGGCGATTAAGTTGGGTAACGCCAGGGTTTTCCCAGTCACGACGTTGTAAAACGACGGCCAGTGAATTGTAATACGACTCACTATAGGGCGAATTGGAGCTCCACCGCGGTGGCGGCCGCTCTAGAACTAGTGGATCCCCCGGGCTGCAGGAATTCGATATCAAGCTTATCGATACCGTCGACCTCGAGGGGGGGCCCGGTACCAGCTTTTGTTCCCTTTAGTGAGGGTTAATTTCGAGCTTGGCGTAATCATGGTCATAGCTGTTTCCTGTGTGAAATTGTTATCCGCTCACAATTCCACACAACATACGAGCCGGAAGCATAAAGTGTAAAGCCTGGGGTGCCTAATGAGTGAGCTAACTCACATTAATTGCGTTGCGCTCACTGCCCGCTTTCCAGTCGGGAAACCTGTCGTGCCAGCTGCATTAATGAATCGGCCAACGCGCGGGGAGAGGCGGTTTGCGTATTGGGCGCTCTTCCGCTTCCTCGCTCACTGACTCGCTGCGCTCGGTCGTTCGGCTGCGGCGAGCGGTATCAGCTCACTCAAAGGCGGTAATACGGTTATCCACAGAATCAGGGGATAACGCAGGAAAGAACATGTGAGCAAAAGGCCAGCAAAAGGCCAGGAACCGTAAAAAGGCCGCGTTGCTGGCGTTTTTCCATAGGCTCCGCCCCCCTGACGAGCATCACAAAAATCGACGCTCAAGTCAGAGGTGGCGAAACCCGACAGGACTATAAAGATACCAGGCGTTTCCCCCTGGAAGCTCCCTCGTGCGCTCTCCTGTTCCGACCCTGCCGCTTACCGGATACCTGTCCGCCTTTCTCCCTTCGGGAAGCGTGGCGCTTTCTCATAGCTCACGCTGTAGGTATCTCAGTTCGGTGTAGGTCGTTCGCTCCAAGCTGGGCTGTGTGCACGAACCCCCCGTTCAGCCCGACCGCTGCGCCTTATCCGGTAACTATCGTCTTGAGTCCAACCCGGTAAGACACGACTTATCGCCACTGGCAGCAGCCACTGGTAACAGGATTAGCAGAGCGAGGTATGTAGGCGGTGCTACAGAGTTCTTGAAGTGGTGGCCTAACTACGGCTACACTAGAAGAACAGTATTTGGTATCTGCGCTCTGCTGAAGCCAGTTACCTTCGGAAAAAGAGTTGGTAGCTCTTGATCCGGCAAACAAACCACCGCTGGTAGCGGTGGTTTTTTTGTTTGCAAGCAGCAGATTACGCGCAGAAAAAAAGGATCTCAAGAAGATCCTTTGATCTTTTCTACGGGGTCTGACGCTCAGTGGAACGAAAACTCACGTTAAGGGATTTTGGTCATGAGATTATCAAAAAGGATCTTCACCTAGATCCTTTTAAATTAAAAATGAAGTTTTAAATCAATCTAAAGTATATATGAGTAAACTTGGTCTGACAGTTACCAATGCTTAATCAGTGAGGCACCTATCTCAGCGATCTGTCTATTTCGTTCATCCATAGTTGCCTGACTCCCCGTCGTGTAGATAACTACGATACGGGAGGGCTTACCATCTGGCCCCAGTGCTGCAATGATACCGCGAGACCCACGCTCACCGGCTCCAGATTTATCAGCAATAAACCAGCCAGCCGGAAGGGCCGAGCGCAGAAGTGGTCCTGCAACTTTATCCGCCTCCATCCAGTCTATTAATTGTTGCCGGGAAGCTAGAGTAAGTAGTTCGCCAGTTAATAGTTTGCGCAACGTTGTTGCCATTGCTACAGGCATCGTGGTGTCACGCTCGTCGTTTGGTATGGCTTCATTCAGCTCCGGTTCCCAACGATCAAGGCGAGTTACATGATCCCCCATGTTGTGCAAAAAAGCGGTTAGCTCCTTCGGTCCTCCGATCGTTGTCAGAAGTAAGTTGGCCGCAGTGTTATCACTCATGGTTATGGCAGCACTGCATAATTCTCTTACTGTCATGCCATCCGTAAGATGCTTTTCTGTGACTGGTGAGTACTCAACCAAGTCATTCTGAGAATAGTGTATGCGGCGACCGAGTTGCTCTTGCCCGGCGTCAATACGGGATAATACCGCGCCACATAGCAGAACTTTAAAAGTGCTCATCATTGGAAAACGTTCTTCGGGGCGAAAACTCTCAAGGATCTTACCGCTGTTGAGATCCAGTTCGATGTAACCCACTCGTGCACCCAACTGATCTTCAGCATCTTTTACTTTCACCAGCGTTTCTGGGTGAGCAAAAACAGGAAGGCAAAATGCCGCAAAAAAGGGAATAAGGGCGACACGGAAATGTTGAATACTCATACTCTTCCTTTTTCAATATTATTGAAGCATTTATCAGGGTTATTGTCTCATGAGCGGATACATATTTGAATGTATTTAGAAAAATAAACAAATAGGGGTTCCGCGCACATTTCCCCGAAAAGTGCCACCTGggtccttttcatcacgtgctataaaaataattataatttaaattttttaatataaatatataaattaaaaatagaaagtaaaaaaagaaattaaagaaaaaatagtttttgttttccgaagatgtaaaagactctagggggatcgccaacaaatactaccttttatcttgctcttcctgctctcaggtattaatgccgaattgtttcatcttgtctgtgtagaagaccacacacgaaaatcctgtgattttacattttacttatcgttaatcgaatgtatatctatttaatctgcttttcttgtctaataaatatatatgtaaagtacgctttttgttgaaattttttaaacctttgtttatttttttttcttcattccgtaactcttctaccttctttatttactttctaaaatccaaatacaaaacataaaaataaataaacacagagtaaattcccaaattattccatcattaaaagatacgaggcgcgtgtaagttacaggcaagcgatcCGTCTAAGAAACCATTATTATCATGACATTAACCTATAAAAATAGGCGTATCACGAGGCCCTTTCGTC',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(4,'pRSII323',NULL,'2013-05-29','','2-mu','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n2 micron origin is from YEplac195, which has had its XbaI site removed.','','Lac Z','','pRSII323.gb.gz','TCGCGCGTTTCGGTGATGACGGTGAAAACCTCTGACACATGCAGCTCCCGGAGACGGTCACAGCTTGTCTGTAAGCGGATGCCGGGAGCAGACAAGCCCGTCAGGGCGCGTCAGCGGGTGTTGGCGGGTGTCGGGGCTGGCTTAACTATGCGGCATCAGAGCAGATTGTACTGAGAGTGCACCATAAATTCCCGTTTTAAGAGCTTGGTGAGCGCTAGGAGTCACTGCCAGGTATCGTTTGAACACGGCATTAGTCAGGGAAGTCATAACACAGTCCTTTCCCGCAATTTTCTTTTTCTATTACTCTTGGCCTCCTCTAGTACACTCTATATTTTTTTATGCCTCGGTAATGATTTTCATTTTTTTTTTTCCACCTAGCGGATGACTCTTTTTTTTTCTTAGCGATTGGCATTATCACATAATGAATTATACATTATATAAAGTAATGTGATTTCTTCGAAGAATATACTAAAAAATGAGCAGGCAAGATAAACGAAGGCAAAGATGACAGAGCAGAAAGCCCTAGTAAAGCGTATTACAAATGAAACCAAGATTCAGATTGCGATCTCTTTAAAGGGTGGTCCCCTAGCGATAGAGCACTCGATCTTCCCAGAAAAAGAGGCAGAAGCAGTAGCAGAACAGGCCACACAATCGCAAGTGATTAACGTCCACACAGGTATAGGGTTTCTGGACCATATGATACATGCTCTGGCCAAGCATTCCGGCTGGTCGCTAATCGTTGAGTGCATTGGTGACTTACACATAGACGACCATCACACCACTGAAGACTGCGGGATTGCTCTCGGTCAAGCATTTAAAGAGGCCCTAGGGGCCGTGCGTGGAGTAAAAAGGTTTGGATCAGGATTTGCGCCTTTGGATGAGGCACTTTCCAGAGCGGTGGTAGATCTTTCGAACAGGCCGTACGCAGTTGTCGAACTTGGTTTGCAAAGGGAGAAAGTAGGAGATCTCTCTTGCGAGATGATCCCGCATTTTCTTGAAAGTTTTGCAGAGGCTAGCAGAATTACCCTCCACGTTGATTGTCTGCGAGGCAAGAATGATCATCACCGTAGTGAGAGTGCGTTCAAGGCTCTTGCGGTTGCCATAAGAGAAGCCACCTCGCCCAATGGTACAAACGATGTTCCCTCCACCAAAGGTGTTCTTATGTAGTGACACCGATTATTTAAAGTTGCAGCATACGATATATATACATGTGTATATATGTATACCTATGAATGTCAGTAAGTATGTATACGAACAGTATGATACTGAAGATGACAAGGTAATGCATCATTCTATACGTGTCATTCTGAACGAGGCGCGCTTTCCTTTTTTCTTTTTGCTTTTTCTTTTTTTTTCTCTTGAACTCGACGGATCTATGCGGTGTGAAATACCGCACAGATGCGTAAGGAGAAAATACCGCATCAGGAAATTGTAAGCGTTAATATTTTGTTAAAATTCGCGTTAAATTTTTGTTAAATCAGCTCATTTTTTAACCAATAGGCCGAAATCGGCAAAATCCCTTATAAATCAAAAGAATAGACCGAGATAGGGTTGAGTGTTGTTCCAGTTTGGAACAAGAGTCCACTATTAAAGAACGTGGACTCCAACGTCAAAGGGCGAAAAACCGTCTATCAGGGCGATGGCCCACTACGTGAACCATCACCCTAATCAAGTTTTTTGGGGTCGAGGTGCCGTAAAGCACTAAATCGGAACCCTAAAGGGAGCCCCCGATTTAGAGCTTGACGGGGAAAGCCGGCGAACGTGGCGAGAAAGGAAGGGAAGAAAGCGAAAGGAGCGGGCGCTAGGGCGCTGGCAAGTGTAGCGGTCACGCTGCGCGTAACCACCACACCCGCCGCGCTTAATGCGCCGCTACAGGGCGCGTCCATTCGCCATTCAGGCTGCGCAACTGTTGGGAAGGGCGATCGGTGCGGGCCTCTTCGCTATTACGCCAGCTGGCGAAAGGGGGATGTGCTGCAAGGCGATTAAGTTGGGTAACGCCAGGGTTTTCCCAGTCACGACGTTGTAAAACGACGGCCAGTGAATTGTAATACGACTCACTATAGGGCGAATTGGAGCTCCACCGCGGTGGCGGCCGCTCTAGAACTAGTGGATCCCCCGGGCTGCAGGAATTCGATATCAAGCTTATCGATACCGTCGACCTCGAGGGGGGGCCCGGTACCAGCTTTTGTTCCCTTTAGTGAGGGTTAATTTCGAGCTTGGCGTAATCATGGTCATAGCTGTTTCCTGTGTGAAATTGTTATCCGCTCACAATTCCACACAACATACGAGCCGGAAGCATAAAGTGTAAAGCCTGGGGTGCCTAATGAGTGAGCTAACTCACATTAATTGCGTTGCGCTCACTGCCCGCTTTCCAGTCGGGAAACCTGTCGTGCCAGCTGCATTAATGAATCGGCCAACGCGCGGGGAGAGGCGGTTTGCGTATTGGGCGCTCTTCCGCTTCCTCGCTCACTGACTCGCTGCGCTCGGTCGTTCGGCTGCGGCGAGCGGTATCAGCTCACTCAAAGGCGGTAATACGGTTATCCACAGAATCAGGGGATAACGCAGGAAAGAACATGTGAGCAAAAGGCCAGCAAAAGGCCAGGAACCGTAAAAAGGCCGCGTTGCTGGCGTTTTTCCATAGGCTCCGCCCCCCTGACGAGCATCACAAAAATCGACGCTCAAGTCAGAGGTGGCGAAACCCGACAGGACTATAAAGATACCAGGCGTTTCCCCCTGGAAGCTCCCTCGTGCGCTCTCCTGTTCCGACCCTGCCGCTTACCGGATACCTGTCCGCCTTTCTCCCTTCGGGAAGCGTGGCGCTTTCTCATAGCTCACGCTGTAGGTATCTCAGTTCGGTGTAGGTCGTTCGCTCCAAGCTGGGCTGTGTGCACGAACCCCCCGTTCAGCCCGACCGCTGCGCCTTATCCGGTAACTATCGTCTTGAGTCCAACCCGGTAAGACACGACTTATCGCCACTGGCAGCAGCCACTGGTAACAGGATTAGCAGAGCGAGGTATGTAGGCGGTGCTACAGAGTTCTTGAAGTGGTGGCCTAACTACGGCTACACTAGAAGAACAGTATTTGGTATCTGCGCTCTGCTGAAGCCAGTTACCTTCGGAAAAAGAGTTGGTAGCTCTTGATCCGGCAAACAAACCACCGCTGGTAGCGGTGGTTTTTTTGTTTGCAAGCAGCAGATTACGCGCAGAAAAAAAGGATCTCAAGAAGATCCTTTGATCTTTTCTACGGGGTCTGACGCTCAGTGGAACGAAAACTCACGTTAAGGGATTTTGGTCATGAGATTATCAAAAAGGATCTTCACCTAGATCCTTTTAAATTAAAAATGAAGTTTTAAATCAATCTAAAGTATATATGAGTAAACTTGGTCTGACAGTTACCAATGCTTAATCAGTGAGGCACCTATCTCAGCGATCTGTCTATTTCGTTCATCCATAGTTGCCTGACTCCCCGTCGTGTAGATAACTACGATACGGGAGGGCTTACCATCTGGCCCCAGTGCTGCAATGATACCGCGAGACCCACGCTCACCGGCTCCAGATTTATCAGCAATAAACCAGCCAGCCGGAAGGGCCGAGCGCAGAAGTGGTCCTGCAACTTTATCCGCCTCCATCCAGTCTATTAATTGTTGCCGGGAAGCTAGAGTAAGTAGTTCGCCAGTTAATAGTTTGCGCAACGTTGTTGCCATTGCTACAGGCATCGTGGTGTCACGCTCGTCGTTTGGTATGGCTTCATTCAGCTCCGGTTCCCAACGATCAAGGCGAGTTACATGATCCCCCATGTTGTGCAAAAAAGCGGTTAGCTCCTTCGGTCCTCCGATCGTTGTCAGAAGTAAGTTGGCCGCAGTGTTATCACTCATGGTTATGGCAGCACTGCATAATTCTCTTACTGTCATGCCATCCGTAAGATGCTTTTCTGTGACTGGTGAGTACTCAACCAAGTCATTCTGAGAATAGTGTATGCGGCGACCGAGTTGCTCTTGCCCGGCGTCAATACGGGATAATACCGCGCCACATAGCAGAACTTTAAAAGTGCTCATCATTGGAAAACGTTCTTCGGGGCGAAAACTCTCAAGGATCTTACCGCTGTTGAGATCCAGTTCGATGTAACCCACTCGTGCACCCAACTGATCTTCAGCATCTTTTACTTTCACCAGCGTTTCTGGGTGAGCAAAAACAGGAAGGCAAAATGCCGCAAAAAAGGGAATAAGGGCGACACGGAAATGTTGAATACTCATACTCTTCCTTTTTCAATATTATTGAAGCATTTATCAGGGTTATTGTCTCATGAGCGGATACATATTTGAATGTATTTAGAAAAATAAACAAATAGGGGTTCCGCGCACATTTCCCCGAAAAGTGCCACCTGAAcgaagcatctgtgcttcattttgtagaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgaaagcgctattttaccaacgaagaatctgtgcttcatttttgtaaaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgagagcgctattttaccaacaaagaatctatacttcttttttgttctacaaaaatgcatcccgagagcgctatttttctaacaaagcatcttagattactttttttctcctttgtgcgctctataatgcagtctcttgataactttttgcactgtaggtccgttaaggttagaagaaggctactttggtgtctattttctcttccataaaaaaagcctgactccacttcccgcgtttactgattactagcgaagctgcgggtgcattttttcaagataaaggcatccccgattatattctataccgatgtggattgcgcatactttgtgaacagaaagtgatagcgttgatgattcttcattggtcagaaaattatgaacggtttcttctattttgtctctatatactacgtataggaaatgtttacattttcgtattgttttcgattcactctatgaatagttcttactacaatttttttgtctaaagagtaatactagagataaacataaaaaatgtagaggtcgagtttagatgcaagttcaaggagcgaaaggtggatgggtaggttatatagggatatagcacagagatatatagcaaagagatacttttgagcaatgtttgtggaagcggtattcgcaatattttagtagctcgttacagtccggtgcgtttttggttttttgaaagtgcgtcttcagagcgcttttggttttcaaaagcgctctgaagttcctatactttctagCTAGagaataggaacttcggaataggaacttcaaagcgtttccgaaaacgagcgcttccgaaaatgcaacgcgagctgcgcacatacagctcactgttcacgtcgcacctatatctgcgtgttgcctgtatatatatatacatgagaagaacggcatagtgcgtgtttatgcttaaatgcgtacttatatgcgtctatttatgtaggatgaaaggtagtctagtacctcctgtgatattatcccattccatgcggggtatcgtatgcttccttcagcactaccctttagctgttctatatgctgccactcctcaattggattagtctcatccttcaatgctatcatttcctttgatattggatcaTCTAAGAAACCATTATTATCATGACATTAACCTATAAAAATAGGCGTATCACGAGGCCCTTTCGTC',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(5,'pRSII423',NULL,'2013-05-29','','2-mu','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n2 micron replication origin is from YEplac195 and has had its XbaI site removed.','','Lac Z','','pRSII423.gb.gz','tcgcgcgtttcggtgatgacggtgaaaacctctgacacatgcagctcccggagacggtcacagcttgtctgtaagcggatgccgggagcagacaagcccgtcagggcgcgtcagcgggtgttggcgggtgtcggggctggcttaactatgcggcatcagagcagattgtactgagagtgcaccataaattcccgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttccAcctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaagatgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcAtttaaagaggccctaGGggcCGTgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagTtttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtacAaacgatgttccctccaccaaaggtgttcttatgtagtgacaccgattatttaaagTtgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcgacggatctatgcggtgtgaaataccgcacagatgcgtaaggagaaaataccgcatcaggaaattgtaaGcgttaatattttgttaaaattcgcgttaaatttttgttaaatcagctcattttttaaccaataggccgaaatcggcaaaatcccttataaatcaaaagaatagaccgagatagggttgagtgttgttccagtttggaacaagagtccactattaaagaacgtggactccaacgtcaaagggcgaaaaaccgtctatcagggcgatggcccactacgtgaaccatcaccctaatcaagttttttggggtcgaggtgccgtaaagcactaaatcggaaccctaaagggagcccccgatttagagcttgacggggaaagccggcgaacgtggcgagaaaggaagggaagaaagcgaaaggagcgggcgctagggcgctggcaagtgtagcggtcacgctgcgcgtaaccaccacacccgccgcgcttaatgcgccgctacagggcgcgtccattcgccattcaggctgcgcaactgttgggaagggcgatcggtgcgggcctcttcgctattacgccagctggcgaaagggggatgtgctgcaaggcgattaagttgggtaacgccagggttttcccagtcacgacgttgtaaaacgacggccagtgagcgcgcgtaatacgactcactatagggcgaattgggtaccgggccccccctcgaggtcgacggtatcgataagcttgatatcgaattcctgcagcccgggggatccactagttctagagcggccgccaccgcggtggagctccagcttttgttccctttagtgagggttaattgcgcgcttggcgtaatcatggtcatagctgtttcctgtgtgaaattgttatccgctcacaattccacacaacataCgagccggaagcataaagtgtaaagcctggggtgcctaatgagtgagCtaactcacattaattgcgttgcgctcactgcccgctttccagtcgggaaacctgtcgtgccagctgcattaatgaatcggccaacgcgcggggagaggcggtttgcgtattgggcgctcttccgcttcctcgctcactgactcgctgcgctcggtcgttcggctgcggcgagcggtatcagctcactcaaaggcggtaatacggttatccacagaatcaggggataacgcaggaaagaacatgtgagcaaaaggccagcaaaaggccaggaaccgtaaaaaggccgcgttgctggcgtttttccataggctccgcccccctgacgagcatcacaaaaatcgacgctcaagtcagaggtggcgaaacccgacaggactataaagataccaggcgtttccccctggaagctccctcgtgcgctctcctgttccgaccctgccgcttaccggatacctgtccgcctttctcccttcgggaagcgtggcgctttctcatagctcacgctgtaggtatctcagttcggtgtaggtcgttcgctccaagctgggctgtgtgcacgaaccccccgttcagcccgaccgctgcgccttatccggtaactatcgtcttgagtccaacccggtaagacacgacttatcgccactggcagcagccactggtaacaggattagcagagcgaggtatgtaggcggtgctacagagttcttgaagtggtggcctaactacggctacactagaagAacagtatttggtatctgcgctctgctgaagccagttaccttcggaaaaagagttggtagctcttgatccggcaaacaaaccaccgctggtagcggtggtttttttgtttgcaagcagcagattacgcgcagaaaaaaaggatctcaagaagatcctttgatcttttctacggggtctgacgctcagtggaacgaaaactcacgttaagggattttggtcatgagattatcaaaaaggatcttcacctagatccttttaaattaaaaatgaagttttaaatcaatctaaagtatatatgagtaaacttggtctgacagttaccaatgcttaatcagtgaggcacctatctcagcgatctgtctatttcgttcatccatagttgcctgactccccgtcgtgtagataactacgatacgggagggcttaccatctggccccagtgctgcaatgataccgcgagacccacgctcaccggctccagatttatcagcaataaaccagccagccggaagggccgagcgcagaagtggtcctgcaactttatccgcctccatccagtctattaattgttgccgggaagctagagtaagtagttcgccagttaatagtttgcgcaacgttgttgccattgctacaggcatcgtggtgtcacgctcgtcgtttggtatggcttcattcagctccggttcccaacgatcaaggcgagttacatgatcccccatgttgtgcaaaaaagcggttagctccttcggtcctccgatcgttgtcagaagtaagttggccgcagtgttatcactcatggttatggcagcactgcataattctcttactgtcatgccatccgtaagatgcttttctgtgactggtgagtactcaaccaagtcattctgagaatagtgtatgcggcgaccgagttgctcttgcccggcgtcaatacgggataataccgcgccacatagcagaactttaaaagtgctcatcattggaaaacgttcttcggggcgaaaactctcaaggatcttaccgctgttgagatccagttcgatgtaacccactcgtgcacccaactgatcttcagcatcttttactttcaccagcgtttctgggtgagcaaaaacaggaaggcaaaatgccgcaaaaaagggaataagggcgacacggaaatgttgaatactcatactcttcctttttcaatattattgaagcatttatcagggttattgtctcatgagcggatacatatttgaatgtatttagaaaaataaacaaataggggttccgcgcacatttccccgaaaagtgccacctgaAcgaagcatctgtgcttcattttgtagaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgaaagcgctattttaccaacgaagaatctgtgcttcatttttgtaaaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgagagcgctattttaccaacaaagaatctatacttcttttttgttctacaaaaatgcatcccgagagcgctatttttctaacaaagcatcttagattactttttttctcctttgtgcgctctataatgcagtctcttgataactttttgcactgtaggtccgttaaggttagaagaaggctactttggtgtctattttctcttccataaaaaaagcctgactccacttcccgcgtttactgattactagcgaagctgcgggtgcattttttcaagataaaggcatccccgattatattctataccgatgtggattgcgcatactttgtgaacagaaagtgatagcgttgatgattcttcattggtcagaaaattatgaacggtttcttctattttgtctctatatactacgtataggaaatgtttacattttcgtattgttttcgattcactctatgaatagttcttactacaatttttttgtctaaagagtaatactagagataaacataaaaaatgtagaggtcgagtttagatgcaagttcaaggagcgaaaggtggatgggtaggttatatagggatatagcacagagatatatagcaaagagatacttttgagcaatgtttgtggaagcggtattcgcaatattttagtagctcgttacagtccggtgcgtttttggttttttgaaagtgcgtcttcagagcgcttttggttttcaaaagcgctctgaagttcctatactttctagCTAGagaataggaacttcggaataggaacttcaaagcgtttccgaaaacgagcgcttccgaaaatgcaacgcgagctgcgcacatacagctcactgttcacgtcgcacctatatctgcgtgttgcctgtatatatatatacatgagaagaacggcatagtgcgtgtttatgcttaaatgcgtacttatatgcgtctatttatgtaggatgaaaggtagtctagtacctcctgtgatattatcccattccatgcggggtatcgtatgcttccttcagcactaccctttagctgttctatatgctgccactcctcaattggattagtctcatccttcaatgctatcatttcctttgatattggatcatctaagaaaccattattatcatgacattaacctataaaaataggcgtatcacgaggccctttcgtc',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL);
823	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `plasmids` ENABLE KEYS /;
824	38e8e479	Florent Chuffart	UNLOCK TABLES;
825	73b5ba45	Florent Chuffart
826	73b5ba45	Florent Chuffart	--
827	73b5ba45	Florent Chuffart	-- Table structure for table `st_ADE2`
828	73b5ba45	Florent Chuffart	--
829	73b5ba45	Florent Chuffart
830	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_ADE2`;
831	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
832	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
833	38e8e479	Florent Chuffart	CREATE TABLE `st_ADE2` (
834	38e8e479	Florent Chuffart	`alleles` varchar(20) NOT NULL,
835	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
836	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
837	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
838	73b5ba45	Florent Chuffart
839	73b5ba45	Florent Chuffart	--
840	73b5ba45	Florent Chuffart	-- Dumping data for table `st_ADE2`
841	73b5ba45	Florent Chuffart	--
842	73b5ba45	Florent Chuffart
843	38e8e479	Florent Chuffart	LOCK TABLES `st_ADE2` WRITE;
844	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_ADE2` DISABLE KEYS /;
845	38e8e479	Florent Chuffart	INSERT INTO `st_ADE2` VALUES (''),('ade2-1'),('ade2-1/ADE2'),('ade2-1/ade2-1'),('ADE2.'),('ade2/ade2'),('ade2∆::hisG'),('loxP-ADE2-loxP-HphMX'),('unknown');
846	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_ADE2` ENABLE KEYS /;
847	38e8e479	Florent Chuffart	UNLOCK TABLES;
848	73b5ba45	Florent Chuffart
849	73b5ba45	Florent Chuffart	--
850	73b5ba45	Florent Chuffart	-- Table structure for table `st_HIS3`
851	73b5ba45	Florent Chuffart	--
852	73b5ba45	Florent Chuffart
853	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_HIS3`;
854	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
855	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
856	38e8e479	Florent Chuffart	CREATE TABLE `st_HIS3` (
857	38e8e479	Florent Chuffart	`alleles` varchar(40) NOT NULL,
858	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
859	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
860	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
861	73b5ba45	Florent Chuffart
862	73b5ba45	Florent Chuffart	--
863	73b5ba45	Florent Chuffart	-- Dumping data for table `st_HIS3`
864	73b5ba45	Florent Chuffart	--
865	73b5ba45	Florent Chuffart
866	38e8e479	Florent Chuffart	LOCK TABLES `st_HIS3` WRITE;
867	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_HIS3` DISABLE KEYS /;
868	38e8e479	Florent Chuffart	INSERT INTO `st_HIS3` VALUES (''),('his3'),('his3-11,15'),('his3-11,15/HIS3'),('his3-11,15/his3-11,15'),('HIS3.'),('his3∆1'),('his3∆1/HIS3'),('his3∆1/his3∆1'),('his3∆200'),('his3∆200/HIS3'),('his3∆200/his3∆200'),('unknown');
869	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_HIS3` ENABLE KEYS /;
870	38e8e479	Florent Chuffart	UNLOCK TABLES;
871	73b5ba45	Florent Chuffart
872	73b5ba45	Florent Chuffart	--
873	73b5ba45	Florent Chuffart	-- Table structure for table `st_LEU2`
874	73b5ba45	Florent Chuffart	--
875	73b5ba45	Florent Chuffart
876	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_LEU2`;
877	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
878	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
879	38e8e479	Florent Chuffart	CREATE TABLE `st_LEU2` (
880	38e8e479	Florent Chuffart	`alleles` varchar(40) NOT NULL,
881	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
882	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
883	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
884	73b5ba45	Florent Chuffart
885	73b5ba45	Florent Chuffart	--
886	73b5ba45	Florent Chuffart	-- Dumping data for table `st_LEU2`
887	73b5ba45	Florent Chuffart	--
888	73b5ba45	Florent Chuffart
889	38e8e479	Florent Chuffart	LOCK TABLES `st_LEU2` WRITE;
890	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_LEU2` DISABLE KEYS /;
891	38e8e479	Florent Chuffart	INSERT INTO `st_LEU2` VALUES (''),('leu2'),('leu2-3,112'),('leu2-3,112/LEU2'),('leu2-3,112/leu2-3,112'),('LEU2.'),('leu2::hisG'),('leu2::hisG/LEU2'),('leu2::hisG/leu2::hisG'),('leu2∆(asp781-EcoRI)'),('leu2∆(asp781-EcoRI)/LEU2'),('leu2∆(asp781-EcoRI)/leu2∆(asp781-EcoRI)'),('leu2∆0'),('leu2∆0/LEU2'),('leu2∆0/leu2∆0'),('leu2∆1'),('leu2∆1/LEU2'),('leu2∆1/leu2∆1'),('unknown');
892	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_LEU2` ENABLE KEYS /;
893	38e8e479	Florent Chuffart	UNLOCK TABLES;
894	73b5ba45	Florent Chuffart
895	73b5ba45	Florent Chuffart	--
896	73b5ba45	Florent Chuffart	-- Table structure for table `st_LYS2`
897	73b5ba45	Florent Chuffart	--
898	73b5ba45	Florent Chuffart
899	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_LYS2`;
900	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
901	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
902	38e8e479	Florent Chuffart	CREATE TABLE `st_LYS2` (
903	38e8e479	Florent Chuffart	`alleles` varchar(40) NOT NULL,
904	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
905	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
906	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
907	73b5ba45	Florent Chuffart
908	73b5ba45	Florent Chuffart	--
909	73b5ba45	Florent Chuffart	-- Dumping data for table `st_LYS2`
910	73b5ba45	Florent Chuffart	--
911	73b5ba45	Florent Chuffart
912	38e8e479	Florent Chuffart	LOCK TABLES `st_LYS2` WRITE;
913	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_LYS2` DISABLE KEYS /;
914	38e8e479	Florent Chuffart	INSERT INTO `st_LYS2` VALUES (''),('lys2'),('lys2-128d'),('LYS2.'),('lys2/lys2'),('lys2∆0'),('lys2∆0/LYS2'),('lys2∆0/lys2∆0'),('lys2∆0::lox-ADEaru-xol'),('lys2∆202'),('lys2∆202/LYS2'),('lys2∆202/lys2∆202'),('unknown');
915	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_LYS2` ENABLE KEYS /;
916	38e8e479	Florent Chuffart	UNLOCK TABLES;
917	73b5ba45	Florent Chuffart
918	73b5ba45	Florent Chuffart	--
919	73b5ba45	Florent Chuffart	-- Table structure for table `st_MAT`
920	73b5ba45	Florent Chuffart	--
921	73b5ba45	Florent Chuffart
922	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_MAT`;
923	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
924	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
925	38e8e479	Florent Chuffart	CREATE TABLE `st_MAT` (
926	38e8e479	Florent Chuffart	`alleles` varchar(40) NOT NULL,
927	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
928	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
929	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
930	73b5ba45	Florent Chuffart
931	73b5ba45	Florent Chuffart	--
932	73b5ba45	Florent Chuffart	-- Dumping data for table `st_MAT`
933	73b5ba45	Florent Chuffart	--
934	73b5ba45	Florent Chuffart
935	38e8e479	Florent Chuffart	LOCK TABLES `st_MAT` WRITE;
936	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_MAT` DISABLE KEYS /;
937	38e8e479	Florent Chuffart	INSERT INTO `st_MAT` VALUES ('MATa'),('MATa/MATa'),('MATa/MATa/MATb/MATb'),('MATa/MATb'),('MATb'),('MATb/MATb'),('MATb/MATb/MATa'),('unknown');
938	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_MAT` ENABLE KEYS /;
939	38e8e479	Florent Chuffart	UNLOCK TABLES;
940	73b5ba45	Florent Chuffart
941	73b5ba45	Florent Chuffart	--
942	73b5ba45	Florent Chuffart	-- Table structure for table `st_MET15`
943	73b5ba45	Florent Chuffart	--
944	73b5ba45	Florent Chuffart
945	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_MET15`;
946	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
947	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
948	38e8e479	Florent Chuffart	CREATE TABLE `st_MET15` (
949	38e8e479	Florent Chuffart	`alleles` varchar(40) NOT NULL,
950	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
951	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
952	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
953	73b5ba45	Florent Chuffart
954	73b5ba45	Florent Chuffart	--
955	73b5ba45	Florent Chuffart	-- Dumping data for table `st_MET15`
956	73b5ba45	Florent Chuffart	--
957	73b5ba45	Florent Chuffart
958	38e8e479	Florent Chuffart	LOCK TABLES `st_MET15` WRITE;
959	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_MET15` DISABLE KEYS /;
960	38e8e479	Florent Chuffart	INSERT INTO `st_MET15` VALUES (''),('MET15.'),('met15∆0'),('met15∆0/MET15'),('met15∆0/met15∆0'),('unknown');
961	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_MET15` ENABLE KEYS /;
962	38e8e479	Florent Chuffart	UNLOCK TABLES;
963	73b5ba45	Florent Chuffart
964	73b5ba45	Florent Chuffart	--
965	73b5ba45	Florent Chuffart	-- Table structure for table `st_TRP1`
966	73b5ba45	Florent Chuffart	--
967	73b5ba45	Florent Chuffart
968	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_TRP1`;
969	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
970	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
971	38e8e479	Florent Chuffart	CREATE TABLE `st_TRP1` (
972	38e8e479	Florent Chuffart	`alleles` varchar(40) NOT NULL,
973	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
974	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
975	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
976	73b5ba45	Florent Chuffart
977	73b5ba45	Florent Chuffart	--
978	73b5ba45	Florent Chuffart	-- Dumping data for table `st_TRP1`
979	73b5ba45	Florent Chuffart	--
980	73b5ba45	Florent Chuffart
981	38e8e479	Florent Chuffart	LOCK TABLES `st_TRP1` WRITE;
982	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_TRP1` DISABLE KEYS /;
983	38e8e479	Florent Chuffart	INSERT INTO `st_TRP1` VALUES (''),('trp1'),('trp1-1'),('trp1-1/TRP1'),('trp1-1/trp1-1'),('trp1-289'),('trp1-289/TRP1'),('trp1-289/trp1-289'),('TRP1.'),('trp1∆1'),('trp1∆1/TRP1'),('trp1∆1/trp1∆1'),('trp1∆2'),('trp1∆2/TRP1'),('trp1∆2/trp1∆2'),('trp1∆63'),('trp1∆63/TRP1'),('trp1∆63/trp1∆63'),('trp1∆::KanMX4'),('trp1∆::KanMX4/TRP1'),('trp1∆::KanMX4/trp1∆::KanMX4'),('unknown');
984	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_TRP1` ENABLE KEYS /;
985	38e8e479	Florent Chuffart	UNLOCK TABLES;
986	73b5ba45	Florent Chuffart
987	73b5ba45	Florent Chuffart	--
988	73b5ba45	Florent Chuffart	-- Table structure for table `st_URA3`
989	73b5ba45	Florent Chuffart	--
990	73b5ba45	Florent Chuffart
991	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_URA3`;
992	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
993	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
994	38e8e479	Florent Chuffart	CREATE TABLE `st_URA3` (
995	38e8e479	Florent Chuffart	`alleles` varchar(20) NOT NULL,
996	73b5ba45	Florent Chuffart	PRIMARY KEY (`alleles`)
997	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
998	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
999	73b5ba45	Florent Chuffart
1000	73b5ba45	Florent Chuffart	--
1001	73b5ba45	Florent Chuffart	-- Dumping data for table `st_URA3`
1002	73b5ba45	Florent Chuffart	--
1003	73b5ba45	Florent Chuffart
1004	38e8e479	Florent Chuffart	LOCK TABLES `st_URA3` WRITE;
1005	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_URA3` DISABLE KEYS /;
1006	38e8e479	Florent Chuffart	INSERT INTO `st_URA3` VALUES (''),('unknown'),('ura3'),('ura3-1'),('ura3-52'),('ura3-52/URA3'),('ura3-52/ura3-52'),('URA3.'),('ura3/ura3'),('ura3::KanMX'),('ura3::KanMX/URA3'),('ura3∆0'),('ura3∆0/URA3'),('ura3∆0/ura3∆0'),('ura3∆0::TRP1'),('ura3∆::hphNT1'),('URA::CMV-tTA');
1007	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_URA3` ENABLE KEYS /;
1008	38e8e479	Florent Chuffart	UNLOCK TABLES;
1009	38e8e479	Florent Chuffart
1010	38e8e479	Florent Chuffart	--
1011	38e8e479	Florent Chuffart	-- Table structure for table `st_general_backgrounds`
1012	38e8e479	Florent Chuffart	--
1013	38e8e479	Florent Chuffart
1014	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `st_general_backgrounds`;
1015	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1016	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1017	38e8e479	Florent Chuffart	CREATE TABLE `st_general_backgrounds` (
1018	38e8e479	Florent Chuffart	`background` varchar(20) NOT NULL,
1019	38e8e479	Florent Chuffart	PRIMARY KEY (`background`)
1020	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1021	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1022	38e8e479	Florent Chuffart
1023	38e8e479	Florent Chuffart	--
1024	38e8e479	Florent Chuffart	-- Dumping data for table `st_general_backgrounds`
1025	38e8e479	Florent Chuffart	--
1026	38e8e479	Florent Chuffart
1027	38e8e479	Florent Chuffart	LOCK TABLES `st_general_backgrounds` WRITE;
1028	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_general_backgrounds` DISABLE KEYS /;
1029	38e8e479	Florent Chuffart	INSERT INTO `st_general_backgrounds` VALUES ('273614X'),('322134S'),('378604X'),('A364A'),('AJA2'),('CBS2888_1'),('CBS3093_1'),('CBS403_1'),('CBS7960_1'),('CECT10109_1'),('CECT10266_1'),('CEN.PK'),('CLIB154_1'),('CLIB157_1'),('CLIB192_1'),('CLIB208_1'),('CLIB215_1'),('CLIB219_2'),('CLIB272_2'),('CLIB274_1'),('CLIB294_1'),('CLIB318_1'),('CLIB324_2'),('CLIB326_1'),('CLIB328'),('CLIB382_1'),('CLIB413_1'),('CLIB483_1'),('DBVPG1373_1'),('DBVPG1399_1'),('DBVPG1788_1'),('DBVPG1794_1'),('DBVPG1853_1'),('DBVPG3591_1'),('DBVPG4651_1'),('DBVPG6041_1'),('DBVPG6861'),('EM93_3'),('FL100'),('FL200'),('FY3'),('I14_a'),('IL-01'),('industrial'),('JAY270'),('JAY291'),('K12_2'),('K1_1'),('L9-4A'),('M22_a'),('mixture'),('NC-02'),('PW5'),('RM11'),('RM12'),('RM13'),('RM3'),('RM5'),('RM9'),('S288c'),('SK1'),('T73_1'),('TL229S2.2'),('UC1_a'),('UC5'),('UC8_1'),('unknown'),('V5'),('VL1'),('W303'),('WE372_1'),('Y10_a'),('Y12_1'),('Y3_a'),('Y4_1'),('Y55'),('Y5_1'),('Y6_b'),('Y8_1'),('Y9J_1'),('Y9_4'),('YJM269_a'),('YJM280'),('YJM320'),('YJM326'),('YJM413'),('YJM421'),('YJM428'),('YJM434_1'),('YJM436_a'),('YJM440_d'),('YJM454_a'),('YJM653_1'),('YJM678_1'),('YJM789'),('YJM978'),('YJM981'),('YPS1000_a'),('YPS1009'),('YPS163_a');
1030	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `st_general_backgrounds` ENABLE KEYS /;
1031	38e8e479	Florent Chuffart	UNLOCK TABLES;
1032	38e8e479	Florent Chuffart
1033	38e8e479	Florent Chuffart	--
1034	38e8e479	Florent Chuffart	-- Table structure for table `storage_fridges`
1035	38e8e479	Florent Chuffart	--
1036	38e8e479	Florent Chuffart
1037	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `storage_fridges`;
1038	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1039	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1040	38e8e479	Florent Chuffart	CREATE TABLE `storage_fridges` (
1041	38e8e479	Florent Chuffart	`name` varchar(100) NOT NULL,
1042	38e8e479	Florent Chuffart	PRIMARY KEY (`name`)
1043	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1044	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1045	38e8e479	Florent Chuffart
1046	38e8e479	Florent Chuffart	--
1047	38e8e479	Florent Chuffart	-- Dumping data for table `storage_fridges`
1048	38e8e479	Florent Chuffart	--
1049	38e8e479	Florent Chuffart
1050	38e8e479	Florent Chuffart	LOCK TABLES `storage_fridges` WRITE;
1051	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_fridges` DISABLE KEYS /;
1052	38e8e479	Florent Chuffart	INSERT INTO `storage_fridges` VALUES ('GY fridge');
1053	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_fridges` ENABLE KEYS /;
1054	38e8e479	Florent Chuffart	UNLOCK TABLES;
1055	38e8e479	Florent Chuffart
1056	38e8e479	Florent Chuffart	--
1057	38e8e479	Florent Chuffart	-- Table structure for table `storage_minus20freezers`
1058	38e8e479	Florent Chuffart	--
1059	38e8e479	Florent Chuffart
1060	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `storage_minus20freezers`;
1061	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1062	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1063	38e8e479	Florent Chuffart	CREATE TABLE `storage_minus20freezers` (
1064	38e8e479	Florent Chuffart	`name` varchar(100) NOT NULL,
1065	38e8e479	Florent Chuffart	PRIMARY KEY (`name`)
1066	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1067	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1068	38e8e479	Florent Chuffart
1069	38e8e479	Florent Chuffart	--
1070	38e8e479	Florent Chuffart	-- Dumping data for table `storage_minus20freezers`
1071	38e8e479	Florent Chuffart	--
1072	38e8e479	Florent Chuffart
1073	38e8e479	Florent Chuffart	LOCK TABLES `storage_minus20freezers` WRITE;
1074	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_minus20freezers` DISABLE KEYS /;
1075	38e8e479	Florent Chuffart	INSERT INTO `storage_minus20freezers` VALUES ('GY -20 freezer');
1076	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_minus20freezers` ENABLE KEYS /;
1077	38e8e479	Florent Chuffart	UNLOCK TABLES;
1078	38e8e479	Florent Chuffart
1079	38e8e479	Florent Chuffart	--
1080	38e8e479	Florent Chuffart	-- Table structure for table `storage_minus80freezers`
1081	38e8e479	Florent Chuffart	--
1082	38e8e479	Florent Chuffart
1083	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `storage_minus80freezers`;
1084	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1085	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1086	38e8e479	Florent Chuffart	CREATE TABLE `storage_minus80freezers` (
1087	38e8e479	Florent Chuffart	`name` varchar(100) NOT NULL,
1088	38e8e479	Florent Chuffart	PRIMARY KEY (`name`)
1089	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1090	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1091	38e8e479	Florent Chuffart
1092	38e8e479	Florent Chuffart	--
1093	38e8e479	Florent Chuffart	-- Dumping data for table `storage_minus80freezers`
1094	38e8e479	Florent Chuffart	--
1095	38e8e479	Florent Chuffart
1096	38e8e479	Florent Chuffart	LOCK TABLES `storage_minus80freezers` WRITE;
1097	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_minus80freezers` DISABLE KEYS /;
1098	38e8e479	Florent Chuffart	INSERT INTO `storage_minus80freezers` VALUES ('GY -80 freezer');
1099	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_minus80freezers` ENABLE KEYS /;
1100	38e8e479	Florent Chuffart	UNLOCK TABLES;
1101	38e8e479	Florent Chuffart
1102	38e8e479	Florent Chuffart	--
1103	38e8e479	Florent Chuffart	-- Table structure for table `storage_rooms`
1104	38e8e479	Florent Chuffart	--
1105	38e8e479	Florent Chuffart
1106	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `storage_rooms`;
1107	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1108	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1109	38e8e479	Florent Chuffart	CREATE TABLE `storage_rooms` (
1110	38e8e479	Florent Chuffart	`name` varchar(100) NOT NULL,
1111	38e8e479	Florent Chuffart	PRIMARY KEY (`name`)
1112	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1113	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1114	38e8e479	Florent Chuffart
1115	38e8e479	Florent Chuffart	--
1116	38e8e479	Florent Chuffart	-- Dumping data for table `storage_rooms`
1117	38e8e479	Florent Chuffart	--
1118	38e8e479	Florent Chuffart
1119	38e8e479	Florent Chuffart	LOCK TABLES `storage_rooms` WRITE;
1120	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_rooms` DISABLE KEYS /;
1121	38e8e479	Florent Chuffart	INSERT INTO `storage_rooms` VALUES ('GY room');
1122	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `storage_rooms` ENABLE KEYS /;
1123	38e8e479	Florent Chuffart	UNLOCK TABLES;
1124	38e8e479	Florent Chuffart
1125	38e8e479	Florent Chuffart	--
1126	38e8e479	Florent Chuffart	-- Table structure for table `strains`
1127	38e8e479	Florent Chuffart	--
1128	38e8e479	Florent Chuffart
1129	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `strains`;
1130	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1131	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1132	38e8e479	Florent Chuffart	CREATE TABLE `strains` (
1133	38e8e479	Florent Chuffart	`id` int(10) unsigned NOT NULL,
1134	38e8e479	Florent Chuffart	`Name_` varchar(25) NOT NULL,
1135	38e8e479	Florent Chuffart	`Date_` date DEFAULT NULL,
1136	38e8e479	Florent Chuffart	`Comments` longtext,
1137	38e8e479	Florent Chuffart	`General_Background` varchar(25) NOT NULL,
1138	38e8e479	Florent Chuffart	`Mating_Type` varchar(25) DEFAULT NULL,
1139	38e8e479	Florent Chuffart	`ADE2` varchar(25) DEFAULT NULL,
1140	38e8e479	Florent Chuffart	`HIS3` varchar(25) DEFAULT NULL,
1141	38e8e479	Florent Chuffart	`LEU2` varchar(50) DEFAULT NULL,
1142	38e8e479	Florent Chuffart	`LYS2` varchar(25) DEFAULT NULL,
1143	38e8e479	Florent Chuffart	`TRP1` varchar(25) DEFAULT NULL,
1144	38e8e479	Florent Chuffart	`URA3` varchar(25) DEFAULT NULL,
1145	38e8e479	Florent Chuffart	`HO_` varchar(50) DEFAULT NULL,
1146	38e8e479	Florent Chuffart	`locus1` varchar(75) DEFAULT NULL,
1147	38e8e479	Florent Chuffart	`locus2` varchar(50) DEFAULT NULL,
1148	38e8e479	Florent Chuffart	`locus3` varchar(50) DEFAULT NULL,
1149	38e8e479	Florent Chuffart	`Parental_strain` varchar(25) DEFAULT NULL,
1150	38e8e479	Florent Chuffart	`Obtained_by` varchar(25) DEFAULT NULL,
1151	38e8e479	Florent Chuffart	`Checkings` varchar(225) DEFAULT NULL,
1152	38e8e479	Florent Chuffart	`extrachromosomal_plasmid` varchar(50) DEFAULT NULL,
1153	38e8e479	Florent Chuffart	`Other_names` varchar(25) DEFAULT NULL,
1154	38e8e479	Florent Chuffart	`Reference_` varchar(125) DEFAULT NULL,
1155	38e8e479	Florent Chuffart	`locus4` varchar(25) DEFAULT NULL,
1156	38e8e479	Florent Chuffart	`locus5` varchar(50) DEFAULT NULL,
1157	38e8e479	Florent Chuffart	`Cytoplasmic_Character` varchar(25) DEFAULT NULL,
1158	38e8e479	Florent Chuffart	`Last_modified` date DEFAULT NULL,
1159	38e8e479	Florent Chuffart	`MET15` varchar(25) DEFAULT NULL,
1160	38e8e479	Florent Chuffart	`Author` varchar(50) DEFAULT NULL,
1161	38e8e479	Florent Chuffart	`storage_minus20freezers` varchar(100) DEFAULT NULL,
1162	38e8e479	Florent Chuffart	`storage_minus80freezers` varchar(100) DEFAULT NULL,
1163	38e8e479	Florent Chuffart	`storage_fridges` varchar(100) DEFAULT NULL,
1164	38e8e479	Florent Chuffart	`storage_rooms` varchar(100) DEFAULT NULL,
1165	38e8e479	Florent Chuffart	PRIMARY KEY (`id`),
1166	38e8e479	Florent Chuffart	KEY `Author` (`Author`),
1167	38e8e479	Florent Chuffart	CONSTRAINT `strains_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)
1168	38e8e479	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1169	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1170	38e8e479	Florent Chuffart
1171	38e8e479	Florent Chuffart	--
1172	38e8e479	Florent Chuffart	-- Dumping data for table `strains`
1173	38e8e479	Florent Chuffart	--
1174	38e8e479	Florent Chuffart
1175	38e8e479	Florent Chuffart	LOCK TABLES `strains` WRITE;
1176	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `strains` DISABLE KEYS /;
1177	38e8e479	Florent Chuffart	INSERT INTO `strains` VALUES (1,'BY4700','2005-02-01','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,NULL,NULL,NULL,NULL,'ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(2,'BY4709','2005-02-01','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATb',NULL,NULL,NULL,NULL,NULL,'ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(3,'BY4719','2005-02-01','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,NULL,NULL,NULL,'trp1∆63','ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(4,'BY4724','2005-02-01','Gift from Gottschling Lab. Strain from ','S288c','MATa',NULL,NULL,NULL,'lys2∆0',NULL,'ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(5,'BY4720','2003-05-06',NULL,'S288c','MATb',NULL,NULL,NULL,'lys2∆0','trp1∆63','ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann et al; Yeast 1998 14:115-132.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(6,'BY4716',NULL,'Gift from Hartwell Lab, who got it from Brachmann et al. Yeast 1998 14:115-132.','S288c','MATb',NULL,NULL,NULL,'lys2∆0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann et al. Yeast 1998 14:115-132.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(7,'BY4741','2005-10-11','Gift from Gilson Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,'his3∆1','leu2∆0',NULL,NULL,'ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02','met15∆0','Gift.or.Purchased',NULL,NULL,NULL,NULL),(8,'BY4742','2005-10-11','Gift from Gilson Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATb',NULL,'his3∆1','leu2∆0','lys2∆0',NULL,'ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(9,'BY4706','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02','met15∆0','Gift.or.Purchased',NULL,NULL,NULL,NULL),(10,'BY4707','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATb',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02','met15∆0','Gift.or.Purchased',NULL,NULL,NULL,NULL),(11,'BY4710','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,NULL,NULL,NULL,'trp1∆63',NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(12,'BY4711','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATb',NULL,NULL,NULL,NULL,'trp1∆63',NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(13,'BY4712','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,NULL,'leu2∆0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(14,'BY4713','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATb',NULL,NULL,'leu2∆0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(15,'BY4714','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,'his3∆200',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(16,'BY4715','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa',NULL,NULL,NULL,'lys2∆0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(17,'BY4717','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa','ade2∆::hisG',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(18,'BY4725','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATa','ade2∆::hisG',NULL,NULL,NULL,NULL,'ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(19,'BY4726','2005-11-03','Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.','S288c','MATb','ade2∆::hisG',NULL,NULL,NULL,NULL,'ura3∆0',NULL,NULL,NULL,NULL,NULL,'Gift',NULL,NULL,NULL,'Brachmann Yeast 14:115-132, 1998.',NULL,NULL,NULL,'2006-11-02',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL);
1178	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `strains` ENABLE KEYS /;
1179	38e8e479	Florent Chuffart	UNLOCK TABLES;
1180	73b5ba45	Florent Chuffart
1181	73b5ba45	Florent Chuffart	--
1182	73b5ba45	Florent Chuffart	-- Table structure for table `visitors`
1183	73b5ba45	Florent Chuffart	--
1184	73b5ba45	Florent Chuffart
1185	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `visitors`;
1186	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1187	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1188	38e8e479	Florent Chuffart	CREATE TABLE `visitors` (
1189	73b5ba45	Florent Chuffart	`login` varchar(20) NOT NULL,
1190	73b5ba45	Florent Chuffart	`pwd` varchar(100) NOT NULL,
1191	73b5ba45	Florent Chuffart	`target_table` varchar(40) NOT NULL,
1192	73b5ba45	Florent Chuffart	`mode` varchar(40) NOT NULL,
1193	73b5ba45	Florent Chuffart	PRIMARY KEY (`login`)
1194	73b5ba45	Florent Chuffart	) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1195	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1196	73b5ba45	Florent Chuffart
1197	73b5ba45	Florent Chuffart	--
1198	73b5ba45	Florent Chuffart	-- Dumping data for table `visitors`
1199	73b5ba45	Florent Chuffart	--
1200	73b5ba45	Florent Chuffart
1201	38e8e479	Florent Chuffart	LOCK TABLES `visitors` WRITE;
1202	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `visitors` DISABLE KEYS /;
1203	38e8e479	Florent Chuffart	INSERT INTO `visitors` VALUES ('add','8fb37f04c67f8ea2f11cc8d823c833dd','dyn','add'),('edit','68fc3e4b774ac9e5561bb3d8413963b3','dyn','edit'),('superuser','fe01ce2a7fbac8fafaed7c982a04e229','all','super'),('view','fe01ce2a7fbac8fafaed7c982a04e229','all','view');
1204	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `visitors` ENABLE KEYS /;
1205	38e8e479	Florent Chuffart	UNLOCK TABLES;
1206	73b5ba45	Florent Chuffart
1207	73b5ba45	Florent Chuffart	--
1208	73b5ba45	Florent Chuffart	-- Table structure for table `websession`
1209	73b5ba45	Florent Chuffart	--
1210	73b5ba45	Florent Chuffart
1211	38e8e479	Florent Chuffart	DROP TABLE IF EXISTS `websession`;
1212	38e8e479	Florent Chuffart	/!40101 SET @saved_cs_client = @@character_set_client /;
1213	38e8e479	Florent Chuffart	/!40101 SET character_set_client = utf8 /;
1214	38e8e479	Florent Chuffart	CREATE TABLE `websession` (
1215	73b5ba45	Florent Chuffart	`id_session` varchar(100) NOT NULL,
1216	73b5ba45	Florent Chuffart	`login` varchar(40) NOT NULL,
1217	73b5ba45	Florent Chuffart	`time_limit` decimal(10,0) NOT NULL,
1218	73b5ba45	Florent Chuffart	`target_table` varchar(40) DEFAULT NULL,
1219	73b5ba45	Florent Chuffart	`mode` varchar(40) DEFAULT NULL,
1220	73b5ba45	Florent Chuffart	PRIMARY KEY (`id_session`),
1221	73b5ba45	Florent Chuffart	KEY `login` (`login`)
1222	73b5ba45	Florent Chuffart	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1223	38e8e479	Florent Chuffart	/!40101 SET character_set_client = @saved_cs_client /;
1224	73b5ba45	Florent Chuffart
1225	73b5ba45	Florent Chuffart	--
1226	38e8e479	Florent Chuffart	-- Dumping data for table `websession`
1227	73b5ba45	Florent Chuffart	--
1228	73b5ba45	Florent Chuffart
1229	38e8e479	Florent Chuffart	LOCK TABLES `websession` WRITE;
1230	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `websession` DISABLE KEYS /;
1231	38e8e479	Florent Chuffart	INSERT INTO `websession` VALUES ('h4mpkgd3c0ooesgqibecn9j433','view',1392978187,'all','view');
1232	38e8e479	Florent Chuffart	/!40000 ALTER TABLE `websession` ENABLE KEYS /;
1233	38e8e479	Florent Chuffart	UNLOCK TABLES;
1234	38e8e479	Florent Chuffart	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
1235	73b5ba45	Florent Chuffart
1236	38e8e479	Florent Chuffart	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
1237	38e8e479	Florent Chuffart	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
1238	38e8e479	Florent Chuffart	/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
1239	73b5ba45	Florent Chuffart	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
1240	73b5ba45	Florent Chuffart	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
1241	73b5ba45	Florent Chuffart	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
1242	38e8e479	Florent Chuffart	/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
1243	38e8e479	Florent Chuffart
1244	38e8e479	Florent Chuffart	-- Dump completed on 2014-02-21 4:53:20

LBMC » MyLabStocks

root / src / sql / labstocks_db.sql @ 38e8e479