SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!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 utf8mb4 */;

INSERT INTO `tags` (`id_tag`, `slug`, `name`) VALUES
(1, 'tag', 'tag'),
(2, 'mot-cle', 'mot-clé'),
(3, 'theme', 'theme');

INSERT INTO `categories` (`id_categorie`, `name`, `slug`) VALUES
(1, 'catégorie 1', 'categorie-1'),
(2, 'seconde catégorie', 'seconde-categorie'),
(3, 'autre cat', 'autre-cat');

INSERT INTO `articles` (`id_article`, `id_categorie`, `title`, `tags`, `cover_image`, `date_publication`, `intro_text`, `body_texts`, `body_titles`, `body_images`, `body_galeries`, `body_cta`, `body_links`, `body_videos`, `body_pdf`, `body_html_element`, `lectures`, `auteur`, `id_user`, `is_active`, `featured`, `slug`) VALUES
(1, 1, 'premier article', 'a:2:{i:0;i:1;i:1;i:2;}', 'uploads/photos/covers/sample.jpg', '07-09-2022', 'Lorem ipsum dolor sit amet consectetur adipiscing, elit nascetur mollis duis gravida eros, natoque feugiat nulla pellentesque maximus.', 'a:1:{i:2;s:959:\"Lorem ipsum dolor sit amet consectetur adipiscing elit, fringilla ultrices ad scelerisque id vitae, potenti orci convallis lacinia pharetra eu duis, platea pellentesque vivamus varius cursus. A ipsum convallis aliquet taciti ad orci blandit odio cras, potenti dictumst habitant aptent risus massa phasellus fringilla, quam suspendisse hac morbi maecenas mauris ex montes.<br /><br />Ornare interdum eget vivamus ligula nisi posuere turpis maecenas elit cursus lacus, leo tempor nostra sed lorem laoreet conubia quisque mauris. Netus aenean libero velit auctor vehicula quisque cras laoreet bibendum, est ridiculus proin inceptos viverra eget risus habitant, non facilisis nascetur vestibulum montes pellentesque ornare commodo. Venenatis felis cursus mi quam auctor luctus eget erat pharetra magna ac, magnis cubilia rutrum integer maecenas montes libero nam ultrices ullamcorper sociosqu, orci blandit id vulputate primis hac class sodales placerat nascetur.\";}', 'a:7:{i:1;s:13:\"Zone de texte\";i:3;s:5:\"Image\";i:5;s:4:\"Lien\";i:7;s:7:\"Galerie\";i:9;s:3:\"CTA\";i:11;s:3:\"PDF\";i:13;s:9:\"Code HTML\";}', 'a:1:{i:4;s:32:\"uploads/photos/images/sample.jpg\";}', 'a:1:{i:8;a:2:{i:0;s:34:\"uploads/photos/galeries/sample.jpg\";i:1;s:35:\"uploads/photos/galeries/sample2.jpg\";}}', 'a:1:{i:10;a:5:{s:5:\"titre\";s:5:\"Titre\";s:5:\"label\";s:4:\"Call\";s:4:\"lien\";s:22:\"https://www.google.com\";s:5:\"texte\";s:26:\"Lorem ipsum dolor sit amet\";s:5:\"image\";s:29:\"uploads/photos/cta/sample.jpg\";}}', 'a:1:{i:6;a:2:{s:5:\"label\";s:16:\"Lien vers google\";s:4:\"link\";s:22:\"https://www.google.com\";}}', 'N;', 'a:1:{i:12;a:2:{s:5:\"titre\";s:11:\"Fichier PDF\";s:4:\"file\";s:22:\"uploads/pdf/sample.pdf\";}}', 'a:1:{i:14;s:51:\"<pre><code>\r\nun exemple de code HTML\r\n</code></pre>\";}', 3, 'Admin meltingk', 1, 1, NULL, 'premier-article'),
(2, 2, 'article test', 'a:2:{i:0;i:1;i:1;i:3;}', 'uploads/photos/covers/sample.jpg', '07-09-2022', '', 'N;', 'N;', 'N;', 'N;', 'N;', 'N;', 'N;', 'N;', 'N;', 7, 'Test Test', 2, 1, NULL, 'article-test');

INSERT INTO `product_options` (`id_option`, `name`, `slug`) VALUES
(1, 'Végétarien', 'vegetarien'),
(2, 'Nouveau', 'nouveau'),
(3, 'Sans gluten', 'sans-gluten');

INSERT INTO `products` (`id_product`, `name`, `slug`, `description`, `price_1`, `price_2`, `price_3`, `weight`, `options`) VALUES
(3, 'Salade chèvre chaud', 'salade-chevre-chaud', '', '8,00', '14,00', '', '', 'a:0:{}'),
(4, 'Entrecôte', 'entrecote', 'Origine france', '14,90', '', '', '250g', 'a:1:{i:0;s:1:\"2\";}'),
(5, 'Magret de canard', 'magret-de-canard', '', '18,50', '', '', '300g', 'a:0:{}'),
(6, 'Salade végétarienne', 'salade-vegetarienne', '', '10,00', '16,00', '', '', 'a:1:{i:0;s:1:\"1\";}');

INSERT INTO `product_categories` (`id_category`, `display_order`, `name`, `slug`, `text_1`, `text_2`, `products`, `price_1_name`, `price_2_name`, `price_3_name`, `price`) VALUES
(1, 3, 'Menu', 'menu', 'Entrée + plat ou plat + dessert', 'Uniquement les midis du lundi au vendredi.', 'a:2:{i:0;a:2:{s:5:\"title\";s:8:\"Entrées\";s:8:\"products\";a:2:{i:0;s:1:\"3\";i:1;s:1:\"6\";}}i:1;a:2:{s:5:\"title\";s:5:\"Plats\";s:8:\"products\";a:2:{i:0;s:1:\"4\";i:1;s:1:\"5\";}}}', '', '', '', '25,00'),
(3, 2, 'Plats', 'plats', '', '', 'a:2:{i:0;s:1:\"4\";i:1;s:1:\"5\";}', '', '', '', ''),
(4, 1, 'Salades', 'salades', '', '', 'a:2:{i:0;s:1:\"3\";i:1;s:1:\"6\";}', 'Petite', 'Grande', '', '');

COMMIT;

/*!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 */;
