daily pastebin goal
82%
SHARE
TWEET

Untitled

a guest Jun 5th, 2017 74 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.4.1.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Client :  localhost:3306
  6. -- Généré le :  Lun 05 Juin 2017 à 16:38
  7. -- Version du serveur :  5.5.42
  8. -- Version de PHP :  5.6.7
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Base de données :  `DEMENOUS_DB`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Structure de la table `DEN_COMMANDES`
  21. --
  22.  
  23. CREATE TABLE `DEN_COMMANDES` (
  24.   `id` int(11) NOT NULL,
  25.   `demenagement_id` int(11) DEFAULT NULL,
  26.   `user_id` int(11) NOT NULL,
  27.   `dateCreation` datetime NOT NULL,
  28.   `dateMAJ` datetime NOT NULL,
  29.   `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  30.   `statut` int(11) NOT NULL,
  31.   `cout` int(11) NOT NULL,
  32.   `nettoyage_id` int(11) DEFAULT NULL
  33. ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  34.  
  35. --
  36. -- Contenu de la table `DEN_COMMANDES`
  37. --
  38.  
  39. INSERT INTO `DEN_COMMANDES` (`id`, `demenagement_id`, `user_id`, `dateCreation`, `dateMAJ`, `libelle`, `statut`, `cout`, `nettoyage_id`) VALUES
  40. (8, 8, 4, '2016-06-05 17:00:00', '2016-06-05 08:00:00', 'Déménagement', 2, 290, NULL),
  41. (9, 9, 3, '2016-06-05 17:00:00', '2016-06-05 08:00:00', 'Déménagement a valider', 2, 620, NULL),
  42. (10, 10, 4, '2016-07-05 17:00:00', '2016-07-05 08:00:00', 'Test', 2, 290, NULL),
  43. (11, 11, 4, '2016-07-05 17:00:00', '2016-07-05 08:00:00', 'dess', 2, 320, NULL),
  44. (12, 12, 4, '2016-07-05 17:00:00', '2016-07-05 08:00:00', '', 1, 240, NULL),
  45. (13, 13, 4, '2016-07-05 17:00:00', '2016-07-05 08:00:00', 'deddes', 2, 360, NULL),
  46. (14, NULL, 1, '2016-08-09 17:00:00', '2016-08-09 08:00:00', '', 1, 75, 4);
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. --
  51. -- Structure de la table `DEN_DEMENAGEMENTS`
  52. --
  53.  
  54. CREATE TABLE `DEN_DEMENAGEMENTS` (
  55.   `id` int(11) NOT NULL,
  56.   `ancienneAdresse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  57.   `nouvelleAdresse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  58.   `description` longtext COLLATE utf8_unicode_ci,
  59.   `vehicule` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  60.   `nbDemenageurs` int(11) NOT NULL,
  61.   `date` datetime NOT NULL,
  62.   `duree` int(11) NOT NULL,
  63.   `debut` time NOT NULL,
  64.   `fin` time NOT NULL,
  65.   `cout` int(11) NOT NULL,
  66.   `creation` datetime NOT NULL,
  67.   `modification` datetime DEFAULT NULL
  68. a) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  69.  
  70. --
  71. -- Contenu de la table `DEN_DEMENAGEMENTS`
  72. --
  73.  
  74. INSERT INTO `DEN_DEMENAGEMENTS` (`id`, `ancienneAdresse`, `nouvelleAdresse`, `description`, `vehicule`, `nbDemenageurs`, `date`, `duree`, `debut`, `fin`, `cout`, `creation`, `modification`) VALUES
  75. (8, '', '', NULL, '', 0, '0000-00-00 00:00:00', 0, '00:00:00', '00:00:00', 0, '0000-00-00 00:00:00', NULL),
  76. (9, '', '', NULL, '', 0, '0000-00-00 00:00:00', 0, '00:00:00', '00:00:00', 0, '0000-00-00 00:00:00', NULL),
  77. (10, '', '', NULL, '', 0, '0000-00-00 00:00:00', 0, '00:00:00', '00:00:00', 0, '0000-00-00 00:00:00', NULL),
  78. (11, '', '', NULL, '', 0, '0000-00-00 00:00:00', 0, '00:00:00', '00:00:00', 0, '0000-00-00 00:00:00', NULL),
  79. (12, 'Rue de Dunkerque, Paris, France', 'Rueil-Malmaison, France', 'desse', 'aucun', 2, '2016-07-07 00:00:00', 4, '18:00:00', '22:00:00', 240, '0000-00-00 00:00:00', NULL),
  80. (13, 'Rue de Dunkerque, Paris, France', 'Rueil-Malmaison, France', 'desse', 'aucun', 3, '2016-07-07 00:00:00', 7, '08:00:00', '17:00:00', 360, '0000-00-00 00:00:00', NULL);
  81.  
  82. -- --------------------------------------------------------
  83.  
  84. --
  85. -- Structure de la table `DEN_GROUPS`
  86. --
  87.  
  88. CREATE TABLE `DEN_GROUPS` (
  89.   `id` int(11) NOT NULL,
  90.   `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  91.   `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  92.   `description` longtext COLLATE utf8_unicode_ci
  93. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  94.  
  95. --
  96. -- Contenu de la table `DEN_GROUPS`
  97. --
  98.  
  99. INSERT INTO `DEN_GROUPS` (`id`, `name`, `roles`, `description`) VALUES
  100. (1, 'administrateurs', 'a:0:{}', NULL);
  101.  
  102. -- --------------------------------------------------------
  103.  
  104. --
  105. -- Structure de la table `DEN_NETTOYAGES`
  106. --
  107.  
  108. CREATE TABLE `DEN_NETTOYAGES` (
  109.   `id` int(11) NOT NULL,
  110.   `adresseNettoyage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  111.   `surface` decimal(3,0) NOT NULL,
  112.   `frequence` int(11) NOT NULL,
  113.   `description` longtext COLLATE utf8_unicode_ci,
  114.   `creation` datetime NOT NULL,
  115.   `modification` datetime DEFAULT NULL,
  116.   `date` datetime NOT NULL,
  117.   `duree` int(11) NOT NULL,
  118.   `debut` time NOT NULL,
  119.   `fin` time NOT NULL,
  120.   `cout` int(11) NOT NULL
  121. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  122.  
  123. --
  124. -- Contenu de la table `DEN_NETTOYAGES`
  125. --
  126.  
  127. INSERT INTO `DEN_NETTOYAGES` (`id`, `adresseNettoyage`, `surface`, `frequence`, `description`, `creation`, `modification`, `date`, `duree`, `debut`, `fin`, `cout`) VALUES
  128. (1, 'ddddd', '234', 2, 'ddffff', '2016-07-31 13:47:44', '2016-07-31 13:47:44', '2016-07-31 00:00:00', 7, '08:00:00', '17:00:00', 70),
  129. (2, 'rue des plamiers', '233', 1, 'lorem ipsum', '2016-08-08 07:37:59', '2016-08-08 07:37:59', '2016-08-27 00:00:00', 7, '08:00:00', '17:00:00', 70),
  130. (3, 'Rue des martyrs', '345', 3, 'Merci de me contacter que je puise vous indiquer préciser mon pb', '2016-08-08 07:44:25', '2016-08-08 07:44:25', '2016-08-24 00:00:00', 3, '13:00:00', '16:00:00', 60),
  131. (4, 'dessse', '34', 1, 'dddfff ffff', '2016-08-09 07:36:03', '2016-08-09 07:36:03', '2016-08-25 00:00:00', 3, '17:00:00', '20:00:00', 75);
  132.  
  133. -- --------------------------------------------------------
  134.  
  135. --
  136. -- Structure de la table `DEN_PRODUITS`
  137. --
  138.  
  139. CREATE TABLE `DEN_PRODUITS` (
  140.   `id` int(11) NOT NULL,
  141.   `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  142.   `description` longtext COLLATE utf8_unicode_ci,
  143.   `prix` double NOT NULL,
  144.   `onLine` tinyint(1) NOT NULL,
  145.   `dispo` tinyint(1) NOT NULL,
  146.   `categorie_id` int(11) NOT NULL,
  147.   `quantite` int(11) NOT NULL,
  148.   `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  149.   `tva_id` int(11) NOT NULL,
  150.   `creation` datetime NOT NULL,
  151.   `maj` datetime NOT NULL
  152. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  153.  
  154. --
  155. -- Contenu de la table `DEN_PRODUITS`
  156. --
  157.  
  158. INSERT INTO `DEN_PRODUITS` (`id`, `libelle`, `description`, `prix`, `onLine`, `dispo`, `categorie_id`, `quantite`, `image`, `tva_id`, `creation`, `maj`) VALUES
  159. (1, 'Carton 50m3', 'Tous les Carton 50 m3', 100, 1, 1, 1, 10, 'carton.jpg', 1, '2016-07-16 14:23:32', '2016-07-16 16:33:02'),
  160. (2, 'Carton 100m3', 'cARTON', 18, 1, 1, 1, 1, '100.jpg', 1, '2016-07-16 14:25:01', '2016-07-16 14:25:01');
  161.  
  162. -- --------------------------------------------------------
  163.  
  164. --
  165. -- Structure de la table `DEN_USERS`
  166. --
  167.  
  168. CREATE TABLE `DEN_USERS` (
  169.   `id` int(11) NOT NULL,
  170.   `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  171.   `username_canonical` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  172.   `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  173.   `email_canonical` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  174.   `enabled` tinyint(1) NOT NULL,
  175.   `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  176.   `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  177.   `last_login` datetime DEFAULT NULL,
  178.   `locked` tinyint(1) NOT NULL,
  179.   `expired` tinyint(1) NOT NULL,
  180.   `expires_at` datetime DEFAULT NULL,
  181.   `confirmation_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  182.   `password_requested_at` datetime DEFAULT NULL,
  183.   `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  184.   `credentials_expired` tinyint(1) NOT NULL,
  185.   `credentials_expire_at` datetime DEFAULT NULL,
  186.   `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  187.   `prenom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  188.   `civilite` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  189.   `telephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  190.   `sign_in_date` datetime DEFAULT NULL
  191. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  192.  
  193. --
  194. -- Contenu de la table `DEN_USERS`
  195. --
  196.  
  197. INSERT INTO `DEN_USERS` (`id`, `username`, `username_canonical`, `email`, `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `locked`, `expired`, `expires_at`, `confirmation_token`, `password_requested_at`, `roles`, `credentials_expired`, `credentials_expire_at`, `nom`, `prenom`, `civilite`, `telephone`, `sign_in_date`) VALUES
  198. (1, 'patricx', 'patricx', 'mail@mail.com', 'mail@mail.com', 1, 'qo2p4w63kms8ckg0s440w4ss4sc8kw8', '$2y$13$qo2p4w63kms8ckg0s440wuvCa38yfQCKuPZEyg711EaWnBd/JS/R2', '2016-08-09 07:24:29', 0, 0, NULL, NULL, NULL, 'a:1:{i:0;s:10:"ROLE_ADMIN";}', 0, NULL, 'achille', 'SIMO', '2', '0967453425', NULL),
  199. (2, 'jjk', 'jjk', 'jjk@mail.com', 'jjk@mail.com', 1, 'jj5m91flm00go44g80k0w4gskskwk0c', '$2y$13$jj5m91flm00go44g80k0wucfqAShIUSmbiFbNXj612zJZz5/SRNJa', '2016-05-10 16:07:48', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'jean', 'Jacques', '1', '0967453425', NULL),
  200. (3, 'Jules', 'jules', 'jules@jules.com', 'jules@jules.com', 1, '445p6l80zdc0wgow4w4wwo8sckswwso', '$2y$13$445p6l80zdc0wgow4w4wweU1kckgfrGcj3dRqVhYdcs2elNJzhvRW', '2016-06-05 14:11:42', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'jules', 'jules', '1', '0754342514', NULL),
  201. (4, 'marie', 'marie', 'marie@marie.com', 'marie@marie.com', 1, 'plh94m9e8kgksg4ggk0kkockg8co0sw', '$2y$13$plh94m9e8kgksg4ggk0kkeWYqDNYzj9s3Lz3lJRXwp6ZD9BtKBXmy', '2017-06-05 16:31:16', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'marie', 'marie', '2', '0967453425', NULL);
  202.  
  203. -- --------------------------------------------------------
  204.  
  205. --
  206. -- Structure de la table `DEN_USERS_USERS_GROUPS`
  207. --
  208.  
  209. CREATE TABLE `DEN_USERS_USERS_GROUPS` (
  210.   `user_id` int(11) NOT NULL,
  211.   `group_id` int(11) NOT NULL
  212. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  213.  
  214. -- --------------------------------------------------------
  215.  
  216. --
  217. -- Structure de la table `recherche`
  218. --
  219.  
  220. CREATE TABLE `recherche` (
  221.   `id` int(11) NOT NULL,
  222.   `depart` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  223.   `arrivee` varchar(255) COLLATE utf8_unicode_ci NOT NULL
  224. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  225.  
  226. --
  227. -- Index pour les tables exportées
  228. --
  229.  
  230. --
  231. -- Index pour la table `DEN_COMMANDES`
  232. --
  233. ALTER TABLE `DEN_COMMANDES`
  234.   ADD PRIMARY KEY (`id`),
  235.   ADD UNIQUE KEY `UNIQ_81BEB01E9B48A2D0` (`demenagement_id`),
  236.   ADD UNIQUE KEY `UNIQ_81BEB01EC4A1BF66` (`nettoyage_id`),
  237.   ADD KEY `IDX_81BEB01EA76ED395` (`user_id`);
  238.  
  239. --
  240. -- Index pour la table `DEN_DEMENAGEMENTS`
  241. --
  242. ALTER TABLE `DEN_DEMENAGEMENTS`
  243.   ADD PRIMARY KEY (`id`);
  244.  
  245. --
  246. -- Index pour la table `DEN_GROUPS`
  247. --
  248. ALTER TABLE `DEN_GROUPS`
  249.   ADD PRIMARY KEY (`id`),
  250.   ADD UNIQUE KEY `UNIQ_B8039F305E237E06` (`name`);
  251.  
  252. --
  253. -- Index pour la table `DEN_NETTOYAGES`
  254. --
  255. ALTER TABLE `DEN_NETTOYAGES`
  256.   ADD PRIMARY KEY (`id`);
  257.  
  258. --
  259. -- Index pour la table `DEN_PRODUITS`
  260. --
  261. ALTER TABLE `DEN_PRODUITS`
  262.   ADD PRIMARY KEY (`id`),
  263.   ADD UNIQUE KEY `UNIQ_DF0BDA50A4D60759` (`libelle`);
  264.  
  265. --
  266. -- Index pour la table `DEN_USERS`
  267. --
  268. ALTER TABLE `DEN_USERS`
  269.   ADD PRIMARY KEY (`id`),
  270.   ADD UNIQUE KEY `UNIQ_C813AE6E92FC23A8` (`username_canonical`),
  271.   ADD UNIQUE KEY `UNIQ_C813AE6EA0D96FBF` (`email_canonical`);
  272.  
  273. --
  274. -- Index pour la table `DEN_USERS_USERS_GROUPS`
  275. --
  276. ALTER TABLE `DEN_USERS_USERS_GROUPS`
  277.   ADD PRIMARY KEY (`user_id`,`group_id`),
  278.   ADD KEY `IDX_C6F0F8B2A76ED395` (`user_id`),
  279.   ADD KEY `IDX_C6F0F8B2FE54D947` (`group_id`);
  280.  
  281. --
  282. -- Index pour la table `recherche`
  283. --
  284. ALTER TABLE `recherche`
  285.   ADD PRIMARY KEY (`id`);
  286.  
  287. --
  288. -- AUTO_INCREMENT pour les tables exportées
  289. --
  290.  
  291. --
  292. -- AUTO_INCREMENT pour la table `DEN_COMMANDES`
  293. --
  294. ALTER TABLE `DEN_COMMANDES`
  295.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
  296. --
  297. -- AUTO_INCREMENT pour la table `DEN_DEMENAGEMENTS`
  298. --
  299. ALTER TABLE `DEN_DEMENAGEMENTS`
  300.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
  301. --
  302. -- AUTO_INCREMENT pour la table `DEN_GROUPS`
  303. --
  304. ALTER TABLE `DEN_GROUPS`
  305.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  306. --
  307. -- AUTO_INCREMENT pour la table `DEN_NETTOYAGES`
  308. --
  309. ALTER TABLE `DEN_NETTOYAGES`
  310.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
  311. --
  312. -- AUTO_INCREMENT pour la table `DEN_PRODUITS`
  313. --
  314. ALTER TABLE `DEN_PRODUITS`
  315.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
  316. --
  317. -- AUTO_INCREMENT pour la table `DEN_USERS`
  318. --
  319. ALTER TABLE `DEN_USERS`
  320.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
  321. --
  322. -- AUTO_INCREMENT pour la table `recherche`
  323. --
  324. ALTER TABLE `recherche`
  325.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  326. --
  327. -- Contraintes pour les tables exportées
  328. --
  329.  
  330. --
  331. -- Contraintes pour la table `DEN_COMMANDES`
  332. --
  333. ALTER TABLE `DEN_COMMANDES`
  334.   ADD CONSTRAINT `FK_81BEB01E9B48A2D0` FOREIGN KEY (`demenagement_id`) REFERENCES `DEN_DEMENAGEMENTS` (`id`),
  335.   ADD CONSTRAINT `FK_81BEB01EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `DEN_USERS` (`id`),
  336.   ADD CONSTRAINT `FK_81BEB01EC4A1BF66` FOREIGN KEY (`nettoyage_id`) REFERENCES `DEN_NETTOYAGES` (`id`);
  337.  
  338. --
  339. -- Contraintes pour la table `DEN_USERS_USERS_GROUPS`
  340. --
  341. ALTER TABLE `DEN_USERS_USERS_GROUPS`
  342.   ADD CONSTRAINT `FK_C6F0F8B2A76ED395` FOREIGN KEY (`user_id`) REFERENCES `DEN_USERS` (`id`),
  343.   ADD CONSTRAINT `FK_C6F0F8B2FE54D947` FOREIGN KEY (`group_id`) REFERENCES `DEN_GROUPS` (`id`);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top