· 4 years ago · May 14, 2021, 07:16 AM
1-- Adminer 4.7.6 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `app_user`;
11CREATE TABLE `app_user` (
12 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
13 `email` varchar(128) NOT NULL,
14 `password` varchar(60) NOT NULL,
15 `firstname` varchar(64) DEFAULT NULL,
16 `lastname` varchar(64) DEFAULT NULL,
17 `role` enum('admin','catalog-manager') NOT NULL,
18 `status` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '1 => actif\n2 => désactivé/bloqué',
19 `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
20 `updated_at` timestamp NULL DEFAULT NULL,
21 PRIMARY KEY (`id`),
22 UNIQUE KEY `email_UNIQUE` (`email`)
23) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
24
25INSERT INTO `app_user` (`id`, `email`, `password`, `firstname`, `lastname`, `role`, `status`, `created_at`, `updated_at`) VALUES
26(1, 'philippe@oclock.io', 'rocknroll', 'Philippe', 'Candille', 'admin', 1, '2021-05-04 10:22:02', NULL),
27(2, 'lucie@oclock.io', 'cameleon', 'Lucie', 'Copin', 'admin', 1, '2021-05-04 10:22:02', NULL),
28(3, 'nicole@oclock.io', 'onews', 'Nicole', 'Café', 'catalog-manager', 1, '2021-05-04 10:22:02', NULL),
29(4, 'coucou@gmail.com', '$2y$10$49TNpPgaPXZnRT7VfbUcouNKjtczn3mOalwCr9N1smzToRXsg.PLG', 'Chris', 'Rousseau', 'admin', 1, '2021-05-05 21:15:52', NULL),
30(5, 'greg@oclock.io', '$2y$10$Gr7dSrNC.2oQqPdXjl.CeOwastYuuB0NcElTb20FCLp/HXLWUjFde', 'Grego', 'Smith', 'catalog-manager', 2, '2021-05-05 21:17:52', NULL);
31
32DROP TABLE IF EXISTS `brand`;
33CREATE TABLE `brand` (
34 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
35 `name` varchar(45) NOT NULL COMMENT 'Le nom de la marque',
36 `footer_order` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'L''ordre d''affichage de la marque dans le footer (0=pas affichée dans le footer)',
37 `created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'La date de création de la marque',
38 `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'La date de la dernière mise à jour de la marque',
39 PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
41
42INSERT INTO `brand` (`id`, `name`, `footer_order`, `created_at`, `updated_at`) VALUES
43(1, 'oCirage', 1, '2018-10-17 09:00:00', NULL),
44(2, 'BOOTstrap', 3, '2018-10-17 09:00:00', NULL),
45(3, 'Talonette', 4, '2018-10-17 09:00:00', NULL),
46(4, 'Shossures', 2, '2018-10-17 09:00:00', NULL),
47(5, 'O\'shoes', 0, '2018-10-17 09:00:00', NULL),
48(6, 'Pattes d\'eph', 0, '2018-10-17 09:00:00', NULL),
49(7, 'PHPieds', 5, '2018-10-17 09:00:00', NULL),
50(8, 'oPompes', 0, '2018-10-17 09:00:00', NULL);
51
52DROP TABLE IF EXISTS `category`;
53CREATE TABLE `category` (
54 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
55 `name` varchar(64) NOT NULL COMMENT 'Le nom de la catégorie',
56 `subtitle` varchar(64) DEFAULT NULL,
57 `picture` varchar(128) DEFAULT NULL COMMENT 'L''URL de l''image de la catégorie (utilisée en home, par exemple)',
58 `home_order` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'L''ordre d''affichage de la catégorie sur la home (0=pas affichée en home)',
59 `created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'La date de création de la catégorie',
60 `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp() COMMENT 'La date de la dernière mise à jour de la catégorie',
61 PRIMARY KEY (`id`)
62) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
63
64INSERT INTO `category` (`id`, `name`, `subtitle`, `picture`, `home_order`, `created_at`, `updated_at`) VALUES
65(1, 'Moozoo34', 'Ouais le sous titre', 'assets/images/categ1.jpeg', 2, '2018-10-17 08:00:00', '2021-05-06 16:16:50'),
66(2, 'Au travail', 'C\'est parti', 'assets/images/categ2.jpeg', 3, '2018-10-17 08:00:00', '2021-05-06 16:16:50'),
67(3, 'Cérémonie', 'Bien choisir', 'assets/images/categ3.jpeg', 4, '2018-10-17 08:00:00', '2021-05-06 16:16:50'),
68(4, 'Sortir', 'Faire un tour', 'assets/images/categ4.jpeg', 0, '2018-10-17 08:00:00', '2021-05-06 16:16:35'),
69(5, 'Vintage', 'Découvrir', 'assets/images/categ5.jpeg', 5, '2018-10-17 08:00:00', '2021-05-06 16:16:50'),
70(6, 'Piscine et bains', NULL, NULL, 0, '2018-10-17 08:00:00', '2021-05-06 16:12:42'),
71(7, 'Sport', NULL, NULL, 1, '2018-10-17 08:00:00', '2021-05-06 16:16:50'),
72(12, 'Chaussette', '', '', 0, '2021-05-02 11:17:44', '2021-05-06 16:12:42');
73
74DROP TABLE IF EXISTS `product`;
75CREATE TABLE `product` (
76 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
77 `name` varchar(45) NOT NULL COMMENT 'Le nom du produit',
78 `description` text DEFAULT NULL COMMENT 'La description du produit',
79 `picture` varchar(128) DEFAULT NULL COMMENT 'L''URL de l''image du produit',
80 `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Le prix du produit',
81 `rate` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'L''avis sur le produit, de 1 à 5',
82 `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Le statut du produit (1=dispo, 2=pas dispo)',
83 `created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'La date de création du produit',
84 `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'La date de la dernière mise à jour du produit',
85 `brand_id` int(10) unsigned NOT NULL,
86 `category_id` int(10) unsigned NOT NULL,
87 `type_id` int(10) unsigned NOT NULL,
88 PRIMARY KEY (`id`),
89 KEY `fk_product_brand_idx` (`brand_id`),
90 KEY `fk_product_category1_idx` (`category_id`),
91 KEY `fk_product_type1_idx` (`type_id`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
93
94INSERT INTO `product` (`id`, `name`, `description`, `picture`, `price`, `rate`, `status`, `created_at`, `updated_at`, `brand_id`, `category_id`, `type_id`) VALUES
95(1, 'Kissing MUAH', 'Proinde concepta rabie saeviore, quam desperatio incendebat et fames, amplificatis viribus ardore incohibili in excidium urbium matris Seleuciae efferebantur, quam comes tuebatur Castricius tresque legiones bellicis sudoribus induratae.', 'assets/images/produits/1-kiss.jpg', 40.00, 4, 1, '2018-10-17 11:00:00', '2021-05-03 16:00:35', 2, 1, 7),
96(2, 'Pink Lady', 'Nunc vero inanes flatus quorundam vile esse quicquid extra urbis pomerium nascitur aestimant praeter orbos et caelibes, nec credi potest qua obsequiorum diversitate coluntur homines sine liberis Romae.', 'assets/images/produits/2-rose.jpg', 20.00, 2, 1, '2018-10-17 11:00:00', NULL, 4, 6, 2),
97(3, 'Panda', 'Homines enim eruditos et sobrios ut infaustos et inutiles vitant, eo quoque accedente quod et nomenclatores adsueti haec et talia venditare, mercede accepta lucris quosdam et prandiis inserunt subditicios ignobiles et obscuros.', 'assets/images/produits/3-panda.jpg', 50.00, 5, 1, '2018-10-17 11:00:00', NULL, 5, 1, 7),
98(4, 'Zombie2', 'Sed si ille hac tam eximia fortuna propter utilitatem rei publicae frui non properat, ut omnia illa conficiat, quid ego, senator, facere debeo, quem, etiamsi ille aliud vellet, rei publicae consulere oporteret?', 'assets/images/produits/4-zombie.jpg', 40.00, 2, 1, '2018-10-17 11:00:00', '2021-05-03 17:07:04', 7, 3, 7),
99(5, 'Minion', 'Ut enim benefici liberalesque sumus, non ut exigamus gratiam (neque enim beneficium faeneramur sed natura propensi ad liberalitatem sumus), sic amicitiam non spe mercedis adducti sed quod omnis eius fructus in ipso amore inest, expetendam putamus.', 'assets/images/produits/5-minion.jpg', 44.00, 3, 1, '2018-10-17 11:00:00', NULL, 6, 1, 7),
100(6, 'Père Noël', 'Tempore quo primis auspiciis in mundanum fulgorem surgeret victura dum erunt homines Roma, ut augeretur sublimibus incrementis, foedere pacis aeternae Virtus convenit atque Fortuna plerumque dissidentes, quarum si altera defuisset, ad perfectam non venerat summitatem.', 'assets/images/produits/6-pernoel.jpg', 36.00, 2, 2, '2018-10-17 11:00:00', NULL, 8, 1, 7),
101(7, 'Sleepy', 'Vita est illis semper in fuga uxoresque mercenariae conductae ad tempus ex pacto atque, ut sit species matrimonii, dotis nomine futura coniunx hastam et tabernaculum offert marito, post statum diem si id elegerit discessura, et incredibile est quo ardore apud eos in venerem uterque solvitur sexus.', 'assets/images/produits/7-sleepy.jpg', 40.00, 3, 1, '2018-10-17 11:00:00', NULL, 4, 1, 7),
102(8, 'Bear', 'Fieri, inquam, Triari, nullo pacto potest, ut non dicas, quid non probes eius, a quo dissentias. quid enim me prohiberet Epicureum esse, si probarem, quae ille diceret? cum praesertim illa perdiscere ludus esset.', 'assets/images/produits/8-bear.jpg', 46.00, 4, 1, '2018-10-17 11:00:00', NULL, 5, 1, 7),
103(9, 'Pantufa', 'Quam ob rem dissentientium inter se reprehensiones non sunt vituperandae, maledicta, contumeliae, tum iracundiae, contentiones concertationesque in disputando pertinaces indignae philosophia mihi videri solent.', 'assets/images/produits/9-pantufa.jpg', 48.00, 4, 1, '2018-10-17 11:00:00', NULL, 6, 1, 7),
104(10, 'Jack', 'Quam ob rem id primum videamus, si placet, quatenus amor in amicitia progredi debeat. Numne, si Coriolanus habuit amicos, ferre contra patriam arma illi cum Coriolano debuerunt? num Vecellinum amici regnum adpetentem, num Maelium debuerunt iuvare?', 'assets/images/produits/10-jack.jpg', 50.00, 3, 1, '2018-10-17 11:00:00', NULL, 8, 1, 7),
105(11, 'Teeturtle', 'Nec minus feminae quoque calamitatum participes fuere similium. nam ex hoc quoque sexu peremptae sunt originis altae conplures, adulteriorum flagitiis obnoxiae vel stuprorum. inter quas notiores fuere Claritas et Flaviana, quarum altera cum duceretur ad mortem.', 'assets/images/produits/11-teeturtle.jpg', 50.00, 3, 1, '2018-10-17 11:00:00', NULL, 7, 1, 7),
106(12, 'Pikachu', 'Claritas et Flaviana, quarum altera cum duceretur ad mortem, indumento, quo vestita erat, abrepto, ne velemen quidem secreto membrorum sufficiens retinere permissa est. ideoque carnifex nefas admisisse convictus inmane, vivus exustus est.', 'assets/images/produits/12-pika.jpg', 50.00, 4, 1, '2018-10-17 11:00:00', NULL, 2, 1, 7),
107(13, 'Unicorn', 'Haec igitur Epicuri non probo, inquam. De cetero vellem equidem aut ipse doctrinis fuisset instructior est enim, quod tibi ita videri necesse est, non satis politus iis artibus, quas qui tenent, eruditi appellantur aut ne deterruisset alios a studiis. quamquam te quidem video minime esse deterritum.', 'assets/images/produits/13-unicorn.jpg', 50.00, 4, 1, '2018-10-17 11:00:00', NULL, 5, 1, 7),
108(14, 'Shark', 'Intellectum est enim mihi quidem in multis, et maxime in me ipso, sed paulo ante in omnibus, cum M. Marcellum senatui reique publicae concessisti, commemoratis praesertim offensionibus, te auctoritatem huius ordinis dignitatemque rei publicae tuis vel doloribus vel suspicionibus anteferre', 'assets/images/produits/14-shark.jpg', 40.00, 3, 1, '2018-10-17 11:00:00', NULL, 7, 1, 7),
109(15, 'Eagles', 'Ille quidem fructum omnis ante actae vitae hodierno die maximum cepit, cum summo consensu senatus, tum iudicio tuo gravissimo et maximo. Ex quo profecto intellegis quanta in dato beneficio sit laus, cum in accepto sit tanta gloria.', 'assets/images/produits/15-eagle.jpg', 34.00, 2, 1, '2018-10-17 11:00:00', NULL, 2, 1, 7),
110(18, 'Pokeball', 'Sed ut tum ad senem senex de senectute, sic hoc libro ad amicum amicissimus scripsi de amicitia. Tum est Cato locutus, quo erat nemo fere senior temporibus illis, nemo prudentior; nunc Laelius et sapiens (sic enim est habitus) et amicitiae gloria excellens de amicitia loquetur.', 'assets/images/produits/18-pokeball.jpg', 46.00, 3, 2, '2018-10-17 11:00:00', NULL, 8, 1, 7),
111(19, 'Hobbit', 'Tu velim a me animum parumper avertas, Laelium loqui ipsum putes. C. Fannius et Q. Mucius ad socerum veniunt post mortem Africani; ab his sermo oritur, respondet Laelius, cuius tota disputatio est de amicitia, quam legens te ipse cognosces.', 'assets/images/produits/19-hobbit.jpg', 46.00, 3, 1, '2018-10-17 11:00:00', NULL, 6, 1, 7),
112(20, 'Deadpool', 'Pandente itaque viam fatorum sorte tristissima, qua praestitutum erat eum vita et imperio spoliari, itineribus interiectis permutatione iumentorum emensis venit Petobionem oppidum Noricorum, ubi reseratae sunt insidiarum latebrae omnes, et Barbatio repente apparuit comes.', 'assets/images/produits/20-deadpool.jpg', 36.00, 4, 1, '2018-10-17 11:00:00', NULL, 2, 1, 7),
113(21, 'Convrese', 'Sed ut tum ad senem senex de senectute, sic hoc libro ad amicum amicissimus scripsi de amicitia. Tum est Cato locutus, quo erat nemo fere senior temporibus illis, nemo prudentior; nunc Laelius et sapiens (sic enim est habitus) et amicitiae gloria excellens de amicitia loquetur.', 'assets/images/produits/21-converse.jpg', 60.00, 3, 1, '2018-10-17 11:00:00', NULL, 5, 5, 1),
114(22, 'Mike', 'Tu velim a me animum parumper avertas, Laelium loqui ipsum putes. C. Fannius et Q. Mucius ad socerum veniunt post mortem Africani; ab his sermo oritur, respondet Laelius, cuius tota disputatio est de amicitia, quam legens te ipse cognosces.', 'assets/images/produits/22-nike.jpg', 68.00, 3, 1, '2018-10-17 11:00:00', NULL, 5, 4, 1),
115(23, 'Jardon', 'Fieri, inquam, Triari, nullo pacto potest, ut non dicas, quid non probes eius, a quo dissentias. quid enim me prohiberet Epicureum esse, si probarem, quae ille diceret? cum praesertim illa perdiscere ludus esset.', 'assets/images/produits/23-jordan.jpg', 120.00, 4, 2, '2018-10-17 11:00:00', NULL, 7, 7, 2),
116(24, 'Running', 'Fieri, inquam, Triari, nullo pacto potest, ut non dicas, quid non probes eius, a quo dissentias. quid enim me prohiberet Epicureum esse, si probarem, quae ille diceret? cum praesertim illa perdiscere ludus esset.', 'assets/images/produits/24-running-nike.jpg', 80.00, 3, 1, '2018-10-17 11:00:00', NULL, 5, 7, 2),
117(25, 'Sans dale', 'Nunc vero inanes flatus quorundam vile esse quicquid extra urbis pomerium nascitur aestimant praeter orbos et caelibes, nec credi potest qua obsequiorum diversitate coluntur homines sine liberis Romae.', 'assets/images/produits/25-100dales.jpg', 23.00, 2, 1, '2018-10-17 11:00:00', NULL, 7, 4, 4),
118(26, 'Talon aibrille', 'Proinde concepta rabie saeviore, quam desperatio incendebat et fames, amplificatis viribus ardore incohibili in excidium urbium matris Seleuciae efferebantur, quam comes tuebatur Castricius tresque legiones bellicis sudoribus induratae.', 'assets/images/produits/26-oCirage.jpg', 240.00, 5, 1, '2018-10-17 11:00:00', NULL, 3, 3, 5),
119(28, 'Tongaa', 'La tonge du siècle !', 'tongaa.jpg', 150.00, 5, 0, '2021-04-30 14:54:38', '2021-04-30 14:54:38', 5, 3, 3),
120(29, 'Test', 'testtttttt', '', 40.00, 4, 0, '2021-04-30 15:41:36', '2021-04-30 15:41:36', 2, 3, 5),
121(30, 'Ouais le produit', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin a tempus dolor, pretium lacinia lacus. Pellentesque mi dui, aliquet at eros nec, elementum consequat quam. Sed aliquam interdum eros, at congue dui consectetur suscipit. Praesent aliquet hendrerit placerat. Ut in ullamcorper arcu. Duis non leo a mauris venenatis viverra vitae eget est.', '', 50.00, 5, 0, '2021-05-03 15:38:58', '2021-05-03 15:38:58', 2, 1, 4);
122
123DROP TABLE IF EXISTS `product_has_tag`;
124CREATE TABLE `product_has_tag` (
125 `product_id` int(10) unsigned NOT NULL,
126 `tag_id` int(10) unsigned NOT NULL,
127 PRIMARY KEY (`product_id`,`tag_id`),
128 KEY `fk_product_has_tag_tag1_idx` (`tag_id`),
129 KEY `fk_product_has_tag_product1_idx` (`product_id`)
130) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
131
132INSERT INTO `product_has_tag` (`product_id`, `tag_id`) VALUES
133(1, 1),
134(1, 7),
135(2, 5),
136(3, 1),
137(3, 6),
138(4, 1),
139(4, 7),
140(5, 3),
141(6, 7),
142(7, 7),
143(8, 1),
144(8, 6),
145(11, 1),
146(11, 3),
147(11, 6),
148(12, 1),
149(12, 2),
150(13, 1),
151(13, 6),
152(14, 6),
153(15, 5),
154(15, 6),
155(18, 1),
156(18, 2),
157(20, 1),
158(20, 3),
159(20, 7),
160(21, 5),
161(22, 5),
162(23, 5),
163(24, 5);
164
165DROP TABLE IF EXISTS `tag`;
166CREATE TABLE `tag` (
167 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
168 `name` varchar(32) NOT NULL,
169 `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
170 `updated_at` timestamp NULL DEFAULT NULL,
171 PRIMARY KEY (`id`)
172) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
173
174INSERT INTO `tag` (`id`, `name`, `created_at`, `updated_at`) VALUES
175(1, 'oclock', '2018-10-17 09:00:00', NULL),
176(2, 'pokemon', '2018-10-17 09:00:00', NULL),
177(3, 'films', '2018-10-17 09:00:00', NULL),
178(4, 'séries', '2018-10-17 09:00:00', NULL),
179(5, 'sport', '2018-10-17 09:00:00', NULL),
180(6, 'animal', '2018-10-17 09:00:00', NULL),
181(7, 'fun', '2018-10-17 09:00:00', NULL);
182
183DROP TABLE IF EXISTS `type`;
184CREATE TABLE `type` (
185 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
186 `name` varchar(64) NOT NULL COMMENT 'Le nom du type',
187 `footer_order` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'L''ordre d''affichage du type dans le footer (0=pas affichée dans le footer)',
188 `created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'La date de création de la catégorie',
189 `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'La date de la dernière mise à jour de la catégorie',
190 PRIMARY KEY (`id`)
191) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
192
193INSERT INTO `type` (`id`, `name`, `footer_order`, `created_at`, `updated_at`) VALUES
194(1, 'Chaussures de ville', 1, '2018-10-17 10:00:00', NULL),
195(2, 'Chaussures de sport', 2, '2018-10-17 10:00:00', NULL),
196(3, 'Tongs', 4, '2018-10-17 10:00:00', NULL),
197(4, 'Chaussures ouvertes', 0, '2018-10-17 10:00:00', NULL),
198(5, 'Talons éguilles', 0, '2018-10-17 10:00:00', NULL),
199(6, 'Talons', 0, '2018-10-17 10:00:00', NULL),
200(7, 'Pantoufles', 3, '2018-10-17 10:00:00', NULL),
201(8, 'Chaussons', 5, '2018-10-17 10:00:00', NULL);
202
203-- 2021-05-14 07:09:57