-- MySQL dump 10.13  Distrib 5.6.24, for osx10.8 (x86_64)
--
-- Host: 127.0.0.1    Database: formulaires
-- ------------------------------------------------------
-- Server version	5.7.11

/*!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 `demandes`
--

DROP TABLE IF EXISTS `demandes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `demandes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) DEFAULT NULL,
  `object` longtext,
  `files` longtext,
  `Date1` datetime NOT NULL,
  `Date2` datetime DEFAULT NULL,
  `Date3` datetime DEFAULT NULL,
  `UserID` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `type` varchar(45) DEFAULT 'Reprographie',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `demandes`
--

LOCK TABLES `demandes` WRITE;
/*!40000 ALTER TABLE `demandes` DISABLE KEYS */;
INSERT INTO `demandes` VALUES (6,'test','démo','[{\"docId\":\"/Users/zucatti/oe/packages/com.cerema.formulaires/bin/uploads/3A4C07F5-8184-4A76-99A5-29CA5C84F62C.csv\",\"filename\":\"2055594F0291461402668283.csv\",\"filetype\":\"text/csv\",\"filesize\":\"1672\"}]','2016-05-11 21:46:21','2016-05-11 23:46:29','2016-05-12 00:47:41',614,'Stéphane ZUCATTI',3,'Reprographie'),(7,'sdfsdf','fdsfdfs','[{\"docId\":\"/Users/zucatti/oe/packages/com.cerema.formulaires/bin/uploads/6575910F-96CC-4906-929D-80B10BF1D10C.csv\",\"filename\":\"2055594F0291461402660289.csv\",\"filetype\":\"text/csv\",\"filesize\":\"1672\"}]','2016-05-11 23:00:08',NULL,NULL,614,'Stéphane ZUCATTI',1,'Reprographie'),(8,'sdfsdf','fdsfdfs','[{\"docId\":\"/Users/zucatti/oe/packages/com.cerema.formulaires/bin/uploads/6575910F-96CC-4906-929D-80B10BF1D10C.csv\",\"filename\":\"2055594F0291461402660289.csv\",\"filetype\":\"text/csv\",\"filesize\":\"1672\"}]','2016-05-11 23:09:04',NULL,NULL,614,'Stéphane ZUCATTI',1,'Reprographie'),(9,'dsd','cxwcwc','[{\"docId\":\"/Users/zucatti/oe/packages/com.cerema.formulaires/bin/uploads/1E0970C6-5BBB-4CEA-9728-E05FE9965FB2.csv\",\"filename\":\"2055594F0291461402668283.csv\",\"filetype\":\"text/csv\",\"filesize\":\"1672\"}]','2016-05-11 23:10:44','2016-05-12 01:13:15','2016-05-12 01:16:02',614,'Stéphane ZUCATTI',3,'Reprographie'),(10,'test 1','sdfsdfsdfsf','[]','2016-05-11 23:12:20','2016-05-12 01:15:04',NULL,614,'Stéphane ZUCATTI',2,'Reprographie');
/*!40000 ALTER TABLE `demandes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `docs`
--

DROP TABLE IF EXISTS `docs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `docs` (
  `docId` varchar(255) NOT NULL DEFAULT 'NO',
  `_blob` longtext,
  `filename` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  PRIMARY KEY (`docId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `docs`
--

LOCK TABLES `docs` WRITE;
/*!40000 ALTER TABLE `docs` DISABLE KEYS */;
INSERT INTO `docs` VALUES ('/Users/zucatti/oe/packages/com.cerema.formulaires/bin/uploads/1E0970C6-5BBB-4CEA-9728-E05FE9965FB2.csv','data:text/csv;base64,TnVt6XJvIENvbXB0ZSAgIDsyMDU1NTk0RjAyOQ0KVHlwZSAgICAgICAgIDtDQ1ANCkNvbXB0ZSB0ZW51IGVuICA7ZXVyb3MNCkRhdGUgICAgICAgICAgICA7MjMvMDQvMjAxNg0KU29sZGUgKEVVUk9TKSAgIDstMjQ2OSwyMw0KU29sZGUgKEZSQU5DUykgIDstMTYxOTcsMDkNCg0KRGF0ZTtMaWJlbGzpO01vbnRhbnQoRVVST1MpO01vbnRhbnQoRlJBTkNTKQ0KMjIvMDQvMjAxNjsiQUNIQVQgQ0IgUEhBUk1BQ0lFIEdSQU4gMjEuMDQuMTYgQ0FSVEUgTlVNRVJPICAgICAgICAgICAgICAgIDc1NiAgIjstMywyMDstMjAsOTkNCjIyLzA0LzIwMTY7IkNBUlRFIFgwNzU2ICAgIDIxLzA0LzE2IEEgMTdIMDIgUkVUUkFJVCBEQUIgTEEgQkFOUVVFIFBPU1RBTEUgICI7LTQwLDAwOy0yNjIsMzgNCjIxLzA0LzIwMTY7IkFDSEFUIENCIEVTU08gTkQgTElNSVRFIDE5LjA0LjE2I<KEY>','2055594F0291461402668283.csv','text/csv',1672),('/Users/zucatti/oe/packages/com.cerema.formulaires/bin/uploads/3A4C07F5-8184-4A76-99A5-29CA5C84F62C.csv','data:text/csv;base64,TnVt6XJvIENvbXB0ZSAgIDsyMDU1NTk0RjAyOQ0KVHlwZSAgICAgICAgIDtDQ1ANCkNvbXB0ZSB0ZW51IGVuICA7ZXVyb3MNCkRhdGUgICAgICAgICAgICA7MjMvMDQvMjAxNg0KU29sZGUgKEVVUk9TKSAgIDstMjQ2OSwyMw0KU29sZGUgKEZSQU<KEY>ZT<KEY>NC8yMDE2OyJQUkVM<KEY>','2055594F0291461402668283.csv','text/csv',1672),('/Users/zucatti/oe/packages/com.cerema.formulaires/bin/uploads/6575910F-96CC-4906-929D-80B10BF1D10C.csv','data:text/csv;base64,TnVt6XJvIENvbXB0ZSAgIDsyMDU1NTk0RjAyOQ0KVHlwZSAgICAgICAgIDtDQ1ANCkNvbXB0ZSB0ZW51IGVuICA7ZXVyb3MNCkRhdGUgICAgICAgICAgICA<KEY>','2055594F0291461402660289.csv','text/csv',1672);
/*!40000 ALTER TABLE `docs` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-05-11 23:19:05
