LBMC » MyLabStocks

-- MySQL dump 10.13  Distrib 5.5.31, for debian-linux-gnu (x86_64)

--

-- Host: localhost    Database: labstocks_db

-- ------------------------------------------------------

-- Server version        5.5.31-0+wheezy1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--

-- Table structure for table `ab_avail`

--

DROP TABLE IF EXISTS `ab_avail`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_avail` (

  `Type` varchar(50) NOT NULL,

  PRIMARY KEY (`Type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `ab_avail`

--

LOCK TABLES `ab_avail` WRITE;

/*!40000 ALTER TABLE `ab_avail` DISABLE KEYS */;

INSERT INTO `ab_avail` VALUES ('available'),('out of stock');

/*!40000 ALTER TABLE `ab_avail` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `ab_host`

--

DROP TABLE IF EXISTS `ab_host`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_host` (

  `Host` varchar(50) NOT NULL,

  PRIMARY KEY (`Host`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `ab_host`

--

LOCK TABLES `ab_host` WRITE;

/*!40000 ALTER TABLE `ab_host` DISABLE KEYS */;

INSERT INTO `ab_host` VALUES ('goat'),('horse'),('mouse'),('rabbit');

/*!40000 ALTER TABLE `ab_host` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `ab_monopoly`

--

DROP TABLE IF EXISTS `ab_monopoly`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_monopoly` (

  `Type` varchar(50) NOT NULL,

  PRIMARY KEY (`Type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `ab_monopoly`

--

LOCK TABLES `ab_monopoly` WRITE;

/*!40000 ALTER TABLE `ab_monopoly` DISABLE KEYS */;

INSERT INTO `ab_monopoly` VALUES ('monoclonal'),('polyclonal');

/*!40000 ALTER TABLE `ab_monopoly` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `ab_supplier`

--

DROP TABLE IF EXISTS `ab_supplier`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_supplier` (

  `Supplier` varchar(50) NOT NULL,

  PRIMARY KEY (`Supplier`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `ab_supplier`

--

LOCK TABLES `ab_supplier` WRITE;

/*!40000 ALTER TABLE `ab_supplier` DISABLE KEYS */;

INSERT INTO `ab_supplier` VALUES ('Abcam'),('ActiveMotif'),('Covance/Eurogentec'),('Diagenode'),('MPBiomedicals'),('Sigma'),('Upstate/Millipore');

/*!40000 ALTER TABLE `ab_supplier` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `ab_type`

--

DROP TABLE IF EXISTS `ab_type`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_type` (

  `Type` varchar(50) NOT NULL,

  PRIMARY KEY (`Type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `ab_type`

--

LOCK TABLES `ab_type` WRITE;

/*!40000 ALTER TABLE `ab_type` DISABLE KEYS */;

INSERT INTO `ab_type` VALUES ('monoclonal'),('polyclonal');

/*!40000 ALTER TABLE `ab_type` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `antibodies`

--

DROP TABLE IF EXISTS `antibodies`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `antibodies` (

  `id` int(15) NOT NULL,

  `Antigen` varchar(150) NOT NULL,

  `InStock` varchar(25) NOT NULL,

  `Date` date DEFAULT NULL,

  `Comments` longtext,

  `Host` varchar(40) DEFAULT NULL,

  `Ordered_by` varchar(50) DEFAULT NULL,

  `Type` varchar(40) NOT NULL,

  `Batch_Reference` varchar(40) DEFAULT NULL,

  `Supplier` varchar(40) NOT NULL,

  `Location` varchar(40) NOT NULL,

  `Dilution-WB` text NOT NULL,

  `Volume-ChIP` text NOT NULL,

  `ProductID` varchar(20) NOT NULL,

  `storage_minus20freezers` varchar(100) DEFAULT NULL,

  `storage_minus80freezers` varchar(100) DEFAULT NULL,

  `storage_fridges` varchar(100) DEFAULT NULL,

  `storage_rooms` varchar(100) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `Author` (`Ordered_by`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

--

-- Dumping data for table `antibodies`

--

LOCK TABLES `antibodies` WRITE;

/*!40000 ALTER TABLE `antibodies` DISABLE KEYS */;

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

/*!40000 ALTER TABLE `antibodies` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_name`

--

DROP TABLE IF EXISTS `cl_name`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_name` (

  `name` varchar(100) NOT NULL,

  `description` longtext,

  `origin` longtext,

  `Author` varchar(50) DEFAULT NULL,

  `type` varchar(100) DEFAULT NULL,

  PRIMARY KEY (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `cl_name`

--

LOCK TABLES `cl_name` WRITE;

/*!40000 ALTER TABLE `cl_name` DISABLE KEYS */;

INSERT INTO `cl_name` VALUES ('LCL_e','EBV-transformed B cell from Evelyne Manet','gift from Evelyne Manet','Gift.or.Purchased','LCL'),('LCL_GFP','LCL with GFP on ...','Home made','Gift.or.Purchased','LCL');

/*!40000 ALTER TABLE `cl_name` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_passages`

--

DROP TABLE IF EXISTS `cl_passages`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_passages` (

  `ID` int(15) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(100) DEFAULT NULL,

  `passage` longtext,

  `Author` varchar(50) DEFAULT NULL,

  `date_of_freezing` date DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `cl_passages`

--

LOCK TABLES `cl_passages` WRITE;

/*!40000 ALTER TABLE `cl_passages` DISABLE KEYS */;

INSERT INTO `cl_passages` VALUES (1,'LCL_GFP','3','Gift.or.Purchased','2014-02-18'),(2,'LCL_e','n+10','Gift.or.Purchased','2014-02-19');

/*!40000 ALTER TABLE `cl_passages` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_storage`

--

DROP TABLE IF EXISTS `cl_storage`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_storage` (

  `ID` int(15) unsigned NOT NULL AUTO_INCREMENT,

  `container` varchar(50) DEFAULT NULL,

  `rack` varchar(50) DEFAULT NULL,

  `box` varchar(50) DEFAULT NULL,

  `field_y` varchar(50) DEFAULT NULL,

  `field_x` varchar(50) DEFAULT NULL,

  `cl_passages` int(15) DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `cl_storage`

--

LOCK TABLES `cl_storage` WRITE;

/*!40000 ALTER TABLE `cl_storage` DISABLE KEYS */;

INSERT INTO `cl_storage` VALUES (1,'1','1','1','A','1',NULL),(2,'1','1','1','A','2',NULL),(3,'1','1','1','B','1',NULL),(4,'1','1','1','B','2',NULL),(5,'1','1','1','B','3',NULL),(6,'1','1','1','C','1',NULL),(7,'1','1','1','C','2',NULL),(8,'1','1','1','C','3',NULL),(9,'1','1','1','C','4',NULL),(10,'1','1','1','D','1',NULL),(11,'1','1','1','D','2',NULL),(12,'1','1','1','D','3',NULL),(13,'1','1','1','D','4',NULL),(14,'1','1','1','D','5',NULL),(15,'1','1','1','E','1',NULL),(16,'1','1','1','E','2',NULL),(17,'1','1','1','E','3',NULL),(18,'1','1','1','E','4',NULL),(19,'1','1','1','E','5',NULL),(20,'1','1','1','E','6',NULL),(21,'1','1','1','F','1',NULL),(22,'1','1','1','F','2',NULL),(23,'1','1','1','F','3',NULL),(24,'1','1','1','F','4',NULL),(25,'1','1','1','F','5',NULL),(26,'1','1','1','F','6',NULL),(27,'1','1','1','F','7',NULL),(28,'1','1','1','G','1',NULL),(29,'1','1','1','G','2',NULL),(30,'1','1','1','G','3',NULL),(31,'1','1','1','G','4',NULL),(32,'1','1','1','G','5',NULL),(33,'1','1','1','G','6',NULL),(34,'1','1','1','G','7',NULL),(35,'1','1','1','G','8',NULL),(36,'1','1','1','H','1',NULL),(37,'1','1','1','H','2',NULL),(38,'1','1','1','H','3',NULL),(39,'1','1','1','H','4',NULL),(40,'1','1','1','H','5',NULL),(41,'1','1','1','H','6',NULL),(42,'1','1','1','H','7',NULL),(43,'1','1','1','H','8',NULL),(44,'1','1','1','H','9',NULL),(45,'1','1','1','I','1',NULL),(46,'1','1','1','I','2',NULL),(47,'1','1','1','I','3',NULL),(48,'1','1','1','I','4',NULL),(49,'1','1','1','I','5',NULL),(50,'1','1','1','I','6',NULL),(51,'1','1','1','I','7',NULL),(52,'1','1','1','I','8',NULL),(53,'1','1','1','I','9',NULL),(54,'1','1','1','I','10',NULL),(55,'1','1','1','J','1',NULL),(56,'1','1','1','J','2',NULL),(57,'1','1','1','J','3',NULL),(58,'1','1','1','J','4',NULL),(59,'1','1','1','J','5',NULL),(60,'1','1','1','J','6',NULL),(61,'1','1','1','J','7',NULL),(62,'1','1','1','J','8',NULL),(63,'1','1','1','J','9',NULL),(64,'1','1','1','K','1',NULL),(65,'1','1','1','K','2',NULL),(66,'1','1','1','K','3',NULL),(67,'1','1','1','K','4',NULL);

/*!40000 ALTER TABLE `cl_storage` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_type`

--

DROP TABLE IF EXISTS `cl_type`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_type` (

  `type` varchar(100) NOT NULL,

  PRIMARY KEY (`type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `cl_type`

--

LOCK TABLES `cl_type` WRITE;

/*!40000 ALTER TABLE `cl_type` DISABLE KEYS */;

INSERT INTO `cl_type` VALUES ('HEK293'),('HeLa'),('LCL');

/*!40000 ALTER TABLE `cl_type` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `lab_members`

--

DROP TABLE IF EXISTS `lab_members`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `lab_members` (

  `id` varchar(50) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

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

--

-- Dumping data for table `lab_members`

--

LOCK TABLES `lab_members` WRITE;

/*!40000 ALTER TABLE `lab_members` DISABLE KEYS */;

INSERT INTO `lab_members` VALUES ('Christelle.D'),('Florent.C'),('Gael.Y'),('Gift.or.Purchased'),('Helene.B');

/*!40000 ALTER TABLE `lab_members` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `notebooks`

--

DROP TABLE IF EXISTS `notebooks`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `notebooks` (

  `ID` int(15) unsigned NOT NULL,

  `Begin_Date` date DEFAULT NULL,

  `End_Date` date DEFAULT NULL,

  `Author` varchar(50) NOT NULL,

  `Serial_Number` varchar(20) NOT NULL,

  PRIMARY KEY (`ID`),

  UNIQUE KEY `Serial_Number` (`Serial_Number`),

  KEY `Author` (`Author`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

--

-- Dumping data for table `notebooks`

--

LOCK TABLES `notebooks` WRITE;

/*!40000 ALTER TABLE `notebooks` DISABLE KEYS */;

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

/*!40000 ALTER TABLE `notebooks` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `olig_purif`

--

DROP TABLE IF EXISTS `olig_purif`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `olig_purif` (

  `type` varchar(40) NOT NULL,

  PRIMARY KEY (`type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `olig_purif`

--

LOCK TABLES `olig_purif` WRITE;

/*!40000 ALTER TABLE `olig_purif` DISABLE KEYS */;

INSERT INTO `olig_purif` VALUES (''),('Gold'),('HPLC'),('PAGE'),('SePoP');

/*!40000 ALTER TABLE `olig_purif` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `oligos`

--

DROP TABLE IF EXISTS `oligos`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `oligos` (

  `id` char(15) NOT NULL,

  `Sequence` varchar(150) NOT NULL,

  `Date_` date DEFAULT NULL,

  `Description` longtext,

  `PCR_conditions_predicted` longtext,

  `Author` varchar(50) DEFAULT NULL,

  `Purif` varchar(40) NOT NULL,

  `storage_minus20freezers` varchar(100) DEFAULT NULL,

  `storage_minus80freezers` varchar(100) DEFAULT NULL,

  `storage_fridges` varchar(100) DEFAULT NULL,

  `storage_rooms` varchar(100) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `Author` (`Author`),

  CONSTRAINT `oligos_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

--

-- Dumping data for table `oligos`

--

LOCK TABLES `oligos` WRITE;

/*!40000 ALTER TABLE `oligos` DISABLE KEYS */;

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

/*!40000 ALTER TABLE `oligos` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `pip_events`

--

DROP TABLE IF EXISTS `pip_events`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_events` (

  `Events` varchar(100) NOT NULL,

  PRIMARY KEY (`Events`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

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

--

-- Dumping data for table `pip_events`

--

LOCK TABLES `pip_events` WRITE;

/*!40000 ALTER TABLE `pip_events` DISABLE KEYS */;

INSERT INTO `pip_events` VALUES ('Change Usage'),('Change User'),('Discard'),('Maintenance'),('Misc'),('Purchase');

/*!40000 ALTER TABLE `pip_events` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `pip_generic_user`

--

DROP TABLE IF EXISTS `pip_generic_user`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_generic_user` (

  `User` varchar(100) NOT NULL,

  PRIMARY KEY (`User`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--

-- Dumping data for table `pip_generic_user`

--

LOCK TABLES `pip_generic_user` WRITE;

/*!40000 ALTER TABLE `pip_generic_user` DISABLE KEYS */;

INSERT INTO `pip_generic_user` VALUES ('Christelle.D'),('Everybody'),('Standby'),('Student');

/*!40000 ALTER TABLE `pip_generic_user` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `pip_history`

--

DROP TABLE IF EXISTS `pip_history`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_history` (

  `ID` int(10) NOT NULL AUTO_INCREMENT,

  `Serial_Number` varchar(50) NOT NULL,

  `Date` date NOT NULL,

  `Owner_fromNowOn` varchar(50) NOT NULL,

  `Usage_fromNowOn` varchar(50) NOT NULL,

  `Event_Type` varchar(100) NOT NULL,

  `Comments` text NOT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

--

-- Dumping data for table `pip_history`

--

LOCK TABLES `pip_history` WRITE;

/*!40000 ALTER TABLE `pip_history` DISABLE KEYS */;

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

/*!40000 ALTER TABLE `pip_history` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `pip_marque`

--

DROP TABLE IF EXISTS `pip_marque`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_marque` (

  `Marque` varchar(100) NOT NULL,

  PRIMARY KEY (`Marque`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

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

--

-- Dumping data for table `pip_marque`

--

LOCK TABLES `pip_marque` WRITE;

/*!40000 ALTER TABLE `pip_marque` DISABLE KEYS */;

INSERT INTO `pip_marque` VALUES ('BioHit'),('Eppendorf'),('Gilson');

/*!40000 ALTER TABLE `pip_marque` ENABLE KEYS */;

UNLOCK TABLES;