CREATE DATABASE  IF NOT EXISTS `wonderapps` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `wonderapps`;
-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: 192.168.0.4    Database: wonderapps
-- ------------------------------------------------------
-- Server version	5.5.47-0ubuntu0.14.04.1

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

DROP TABLE IF EXISTS `folders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `folders` (
  `folder_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `folder_name` varchar(255) DEFAULT NULL,
  `folder_obs` text,
  `folder_status` varchar(45) DEFAULT NULL,
  `folder_datecreation` datetime DEFAULT NULL,
  `folder_deleted` smallint(6) DEFAULT '0',
  PRIMARY KEY (`folder_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `folders`
--

LOCK TABLES `folders` WRITE;
/*!40000 ALTER TABLE `folders` DISABLE KEYS */;
INSERT INTO `folders` VALUES (1,1,'Test du 21/10/16','opération test','ACTIVE','2016-09-30 22:58:01',NULL),(2,1,'Test du 22/12','hello','ACTIVE','2016-10-01 10:48:27',NULL),(3,1,'troisième dossier','pour l\'afnor','ACTIVE','2016-10-01 16:01:36',0);
/*!40000 ALTER TABLE `folders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `codes`
--

DROP TABLE IF EXISTS `codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `codes` (
  `code_id` int(11) NOT NULL AUTO_INCREMENT,
  `folder_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `code_name` varchar(45) DEFAULT NULL,
  `code_status` varchar(45) DEFAULT NULL,
  `code_deleted` smallint(6) DEFAULT '0',
  `code_datecreation` datetime DEFAULT NULL,
  `code_title` varchar(45) DEFAULT NULL,
  `code_layout` varchar(45) DEFAULT NULL,
  `code_font` varchar(45) DEFAULT NULL,
  `code_color` varchar(45) DEFAULT NULL,
  `code_obs` text,
  `code_image` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`code_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `codes`
--

LOCK TABLES `codes` WRITE;
/*!40000 ALTER TABLE `codes` DISABLE KEYS */;
INSERT INTO `codes` VALUES (1,2,1,'premier code','ACTIVE',0,'2016-10-01 16:33:07','Grafik plus',NULL,NULL,'silver','',NULL);
/*!40000 ALTER TABLE `codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clients` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `client_name` varchar(45) DEFAULT NULL,
  `client_status` varchar(45) DEFAULT NULL,
  `client_datecreation` datetime DEFAULT NULL,
  `client_obs` text,
  `client_deleted` smallint(6) DEFAULT '0',
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clients`
--

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` VALUES (1,'AFNOR','actif','2016-08-30 09:00:00','Client d\'Edwige',NULL),(2,'CLAAS','ACTIVE','2016-10-01 13:28:20','Client d\'Aurore',0);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lists`
--

DROP TABLE IF EXISTS `lists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lists` (
  `list_id` int(11) NOT NULL AUTO_INCREMENT,
  `list_name` varchar(45) DEFAULT NULL,
  `list_status` varchar(45) DEFAULT NULL,
  `list_datecreation` datetime DEFAULT NULL,
  PRIMARY KEY (`list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lists`
--

LOCK TABLES `lists` WRITE;
/*!40000 ALTER TABLE `lists` DISABLE KEYS */;
INSERT INTO `lists` VALUES (3,'civilité','ACTIVE','2016-08-31 13:50:28'),(4,'oui-non','ACTIVE','2016-08-31 22:42:09');
/*!40000 ALTER TABLE `lists` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `forms`
--

DROP TABLE IF EXISTS `forms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forms` (
  `form_id` int(11) NOT NULL AUTO_INCREMENT,
  `form_name` varchar(45) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `form_status` varchar(45) DEFAULT NULL,
  `form_datecreation` datetime DEFAULT NULL,
  `form_color1` varchar(45) DEFAULT NULL,
  `form_color2` varchar(45) DEFAULT NULL,
  `form_theme` varchar(45) DEFAULT NULL,
  `form_landingtxt` text,
  `form_thankyoutxt` text,
  `form_colorbg` varchar(45) DEFAULT NULL,
  `form_image` varchar(45) DEFAULT NULL,
  `folder_id` int(11) DEFAULT NULL,
  `form_deleted` smallint(6) DEFAULT '0',
  `form_title` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`form_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `forms`
--

LOCK TABLES `forms` WRITE;
/*!40000 ALTER TABLE `forms` DISABLE KEYS */;
INSERT INTO `forms` VALUES (1,'Newsletter',1,'active','2016-08-30 09:13:00','lime','cyan',NULL,'Veuillez remplir le questionnaire ci-dessous pour vous abonner à la newsletter.','Merci pour votre participation.','#ffc4e8',NULL,1,0,NULL),(2,'Fiche contact',1,'active','2016-08-30 16:04:00','navy','cyan',NULL,'Merci de remplir la fiche contact ci-dessous.','Merci pour votre aide.','#eee',NULL,1,0,NULL),(4,'Contact avec civ',1,'ACTIVE','2016-08-31 15:28:03','#412069','',NULL,'','','',NULL,2,0,'Fiche contact'),(5,'Inscription',1,'ACTIVE','2016-08-31 22:57:50','green','',NULL,'Merci de confirmer votre participation à nos journées portes ouvertes.','Merci pour votre réponse.','white',NULL,2,0,NULL),(6,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL);
/*!40000 ALTER TABLE `forms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data_2`
--

DROP TABLE IF EXISTS `data_2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_2` (
  `gp_id` int(11) NOT NULL AUTO_INCREMENT,
  `Prenom` varchar(255) DEFAULT NULL,
  `Prenom_old` varchar(255) DEFAULT NULL,
  `Nom` varchar(255) DEFAULT NULL,
  `Nom_old` varchar(255) DEFAULT NULL,
  `Telephone` varchar(255) DEFAULT NULL,
  `Telephone_old` varchar(255) DEFAULT NULL,
  `Rue` varchar(255) DEFAULT NULL,
  `Rue_old` varchar(255) DEFAULT NULL,
  `Code_Postal` varchar(255) DEFAULT NULL,
  `Code_Postal_old` varchar(255) DEFAULT NULL,
  `Ville` varchar(255) DEFAULT NULL,
  `Ville_old` varchar(255) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Email_old` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `data_2`
--

LOCK TABLES `data_2` WRITE;
/*!40000 ALTER TABLE `data_2` DISABLE KEYS */;
INSERT INTO `data_2` VALUES (1,'Frédérik','Frédéric','Le Corre',NULL,'01 48 58 70 01',NULL,'14 rue Montgolfier',NULL,'93110',NULL,'Rosny-sous-Bois',NULL,'flc@gp3.fr',NULL);
/*!40000 ALTER TABLE `data_2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data_1`
--

DROP TABLE IF EXISTS `data_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_1` (
  `gp_id` int(11) NOT NULL AUTO_INCREMENT,
  `Prenom` varchar(255) DEFAULT NULL,
  `Prenom_old` varchar(255) DEFAULT NULL,
  `Nom` varchar(255) DEFAULT NULL,
  `Nom_old` varchar(255) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Email_old` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `data_1`
--

LOCK TABLES `data_1` WRITE;
/*!40000 ALTER TABLE `data_1` DISABLE KEYS */;
INSERT INTO `data_1` VALUES (1,'Aurore',NULL,'Le Corre','Casse Couille','alc@gp3.fr',NULL);
/*!40000 ALTER TABLE `data_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meta`
--

DROP TABLE IF EXISTS `meta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meta` (
  `meta_id` int(11) NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `col_label` varchar(45) DEFAULT NULL,
  `col_type` varchar(45) DEFAULT NULL,
  `col_sourceid` int(11) DEFAULT NULL,
  `col_field` varchar(45) DEFAULT NULL,
  `col_order` int(11) DEFAULT NULL,
  `col_required` smallint(6) DEFAULT NULL,
  `col_hint` varchar(45) DEFAULT NULL,
  `col_placeholder` varchar(45) DEFAULT NULL,
  `col_layout` int(11) DEFAULT NULL,
  `col_width` smallint(6) DEFAULT NULL,
  `col_height` smallint(6) DEFAULT NULL,
  `col_default` varchar(45) DEFAULT NULL,
  `col_status` varchar(45) DEFAULT NULL,
  `col_datecreation` datetime DEFAULT NULL,
  PRIMARY KEY (`meta_id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meta`
--

LOCK TABLES `meta` WRITE;
/*!40000 ALTER TABLE `meta` DISABLE KEYS */;
INSERT INTO `meta` VALUES (46,1,'gp_id','id_client',NULL,'gp_id',0,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL),(47,1,'Prénom','text',-1,'Prenom',1,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(48,1,'Nom','text',-1,'Nom',2,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(49,1,'Email','email',-1,'Email',3,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(50,2,'gp_id','id_client',NULL,'gp_id',NULL,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(51,2,'Prénom','text',NULL,'Prenom',NULL,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(52,2,'Nom','text',NULL,'Nom',NULL,1,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(53,2,'Telephone','tel',NULL,'Telephone',NULL,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(54,2,'Rue','text',NULL,'Rue',NULL,0,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL),(55,2,'Code postal','text',NULL,'Code_Postal',NULL,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(56,2,'Ville','text',NULL,'Ville',NULL,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(57,2,'Email','email',NULL,'Email',NULL,0,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL),(66,5,'Civilité','radio',3,'Civ',0,0,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL),(67,5,'Prénom','text',-1,'Prenom',0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(68,5,'Nom','text',-1,'Nom',0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(69,5,'Téléphone','tel',-1,'Telephone',0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(70,5,'Email','email',-1,'Email',0,0,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(71,5,'J\'assisterai à l\'événement','radio',4,'Visite',0,0,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `meta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data_5`
--

DROP TABLE IF EXISTS `data_5`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_5` (
  `gp_id` int(11) NOT NULL AUTO_INCREMENT,
  `Civ` varchar(255) DEFAULT NULL,
  `Civ_old` varchar(255) DEFAULT NULL,
  `Prenom` varchar(255) DEFAULT NULL,
  `Prenom_old` varchar(255) DEFAULT NULL,
  `Nom` varchar(255) DEFAULT NULL,
  `Nom_old` varchar(255) DEFAULT NULL,
  `Telephone` varchar(255) DEFAULT NULL,
  `Telephone_old` varchar(255) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Email_old` varchar(255) DEFAULT NULL,
  `Visite` varchar(255) DEFAULT NULL,
  `Visite_old` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `data_5`
--

LOCK TABLES `data_5` WRITE;
/*!40000 ALTER TABLE `data_5` DISABLE KEYS */;
INSERT INTO `data_5` VALUES (1,'M','','Frédérik',NULL,'Le Corre',NULL,'01 48 58 70 01',NULL,'flc@gp3.fr',NULL,'O',NULL);
/*!40000 ALTER TABLE `data_5` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data_4`
--

DROP TABLE IF EXISTS `data_4`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_4` (
  `gp_id` int(11) NOT NULL AUTO_INCREMENT,
  `Civ` varchar(255) DEFAULT NULL,
  `Civ_old` varchar(255) DEFAULT NULL,
  `Prenom` varchar(255) DEFAULT NULL,
  `Prenom_old` varchar(255) DEFAULT NULL,
  `Nom` varchar(255) DEFAULT NULL,
  `Nom_old` varchar(255) DEFAULT NULL,
  `Telephone` varchar(255) DEFAULT NULL,
  `Telephone_old` varchar(255) DEFAULT NULL,
  `Rue` varchar(255) DEFAULT NULL,
  `Rue_old` varchar(255) DEFAULT NULL,
  `Code_Postal` varchar(255) DEFAULT NULL,
  `Code_Postal_old` varchar(255) DEFAULT NULL,
  `Ville` varchar(255) DEFAULT NULL,
  `Ville_old` varchar(255) DEFAULT NULL,
  `Email` varchar(255) DEFAULT NULL,
  `Email_old` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `data_4`
--

LOCK TABLES `data_4` WRITE;
/*!40000 ALTER TABLE `data_4` DISABLE KEYS */;
INSERT INTO `data_4` VALUES (1,'',NULL,'Frédérik',NULL,'Le Corre',NULL,'01 48 58 70 01',NULL,'14 rue Montgolfier',NULL,'93110',NULL,'Rosny-sous-Bois',NULL,'flc@gp3.fr',NULL);
/*!40000 ALTER TABLE `data_4` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `list_items`
--

DROP TABLE IF EXISTS `list_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `list_items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `list_id` int(11) DEFAULT NULL,
  `item_key` varchar(45) DEFAULT NULL,
  `item_val` varchar(45) DEFAULT NULL,
  `item_order` int(11) DEFAULT NULL,
  `item_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `list_items`
--

LOCK TABLES `list_items` WRITE;
/*!40000 ALTER TABLE `list_items` DISABLE KEYS */;
INSERT INTO `list_items` VALUES (1,3,'M','Monsieur',1,NULL),(2,3,'MME','Madame',2,NULL),(5,4,'O','Oui',1,NULL),(6,4,'N','Non',2,NULL);
/*!40000 ALTER TABLE `list_items` 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-10-01 18:52:59
