API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 5th, 2017
96
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.15 KB | None | 0 0
raw download clone embed print report
  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`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!