Révision a9b72d88 src/sql/labstocks_db.sql

b/src/sql/labstocks_db.sql
1204 1204 

  		





  1205
  1205
  
    
LOCK TABLES `strains` WRITE;


  		





  1206
  1206
  
    
/*!40000 ALTER TABLE `strains` DISABLE KEYS */;


  		





  1207
  
  
    
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);


  		





  
  1207
  
    
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,'Saccharomyces cerevisiae');


  		





  1208
  1208
  
    
/*!40000 ALTER TABLE `strains` ENABLE KEYS */;


  		





  1209
  1209
  
    
UNLOCK TABLES;


  		





  1210
  1210
  
    

  		





  ......




  1242
  1242
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		





  1243
  1243
  
    
/*!40101 SET character_set_client = utf8 */;


  		





  1244
  1244
  
    
CREATE TABLE `websession` (


  		





  1245
  
  
    
  `id_session` varchar(100) NOT NULL,


  		





  
  1245
  
    
  `id_session` varchar(255) NOT NULL,


  		





  1246
  1246
  
    
  `login` varchar(40) NOT NULL,


  		





  1247
  1247
  
    
  `time_limit` decimal(10,0) NOT NULL,


  		





  1248
  1248
  
    
  `target_table` varchar(40) DEFAULT NULL,


  		












Formats disponibles :
  Unified diff