-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : lun. 22 avr. 2024 à 21:48
-- Version du serveur : 10.4.32-MariaDB
-- Version de PHP : 8.1.25

START TRANSACTION;



--
-- Base de données : `raamshop_front`
--

-- --------------------------------------------------------

--
-- Structure de la table `brands`
--

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `logo` varchar(255) NOT NULL,
  `summary` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `brands`
--

INSERT INTO `brands` (`id`, `title`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`, `logo`, `summary`) VALUES
(1, 'La Roche-Posay', '000001', 'Active', '2024-04-22 16:50:01', NULL, NULL, '/brands/la-roche-posay.png', 'La Roche-Posay est une marque...');

-- --------------------------------------------------------

--
-- Structure de la table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `products_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products_json`)),
  `status` enum('Conservé','Abandonné','Expiré') NOT NULL DEFAULT 'Conservé',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `ordered` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `carts`
--

INSERT INTO `carts` (`id`, `user_id`, `products_json`, `status`, `created_at`, `updated_at`, `deleted_at`, `ordered`) VALUES
(1, 4, '{\"000011\":{\"name\":\"AHA.BHA.PHA\",\"image\":\"storage\\/products\\/ahabhapha-1712734225.jpg\",\"quantity\":1,\"price\":27000,\"total\":27000},\"000013\":{\"name\":\"IN\'OYA\",\"image\":\"storage\\/products\\/inoya-1712734843.jpg\",\"quantity\":1,\"price\":25000,\"total\":25000},\"000007\":{\"name\":\"Facetheory Clarifying\",\"image\":\"storage\\/products\\/facetheory-clarifying-1712674918.jpg\",\"quantity\":1,\"price\":11875,\"total\":11875}}', 'Conservé', '2024-04-01 11:47:18', '2024-04-22 10:56:37', NULL, 0);

-- --------------------------------------------------------

--
-- Structure de la table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `is_parent` varchar(255) DEFAULT NULL,
  `parent_id` varchar(255) DEFAULT NULL,
  `added_by` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `categories`
--

INSERT INTO `categories` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`, `summary`, `photo`, `status`, `is_parent`, `parent_id`, `added_by`) VALUES
(1, '000001', 'Nouveauté', '2024-03-06 22:08:10', '2024-04-09 11:41:46', '2024-04-09 11:41:46', NULL, NULL, 'Inactive', NULL, NULL, NULL),
(2, '000002', 'Souvent Acheté', '2024-03-06 22:08:10', '2024-04-09 11:41:57', '2024-04-09 11:41:57', NULL, NULL, 'Inactive', NULL, NULL, NULL),
(3, '000003', 'Populaire', '2024-03-06 22:08:10', '2024-04-09 11:41:52', '2024-04-09 11:41:52', NULL, NULL, 'Inactive', NULL, NULL, NULL),
(4, '000004', 'Tendance', '2024-03-15 15:04:26', '2024-03-15 15:04:46', '2024-03-15 15:04:46', NULL, NULL, 'Inactive', NULL, NULL, NULL),
(5, '000005', 'Soins de la Peau', '2024-04-09 08:53:04', '2024-04-09 08:53:04', NULL, NULL, NULL, 'Active', NULL, NULL, NULL),
(6, '000006', 'Maquillages', '2024-04-09 08:58:41', '2024-04-09 08:58:41', NULL, NULL, NULL, 'Active', NULL, NULL, NULL),
(7, '000007', 'Hidratants', '2024-04-09 09:58:44', '2024-04-09 09:58:44', NULL, NULL, NULL, 'Active', NULL, NULL, NULL),
(8, '000008', 'Produits Naturels', '2024-04-09 11:51:22', '2024-04-09 11:51:22', NULL, NULL, NULL, 'Active', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `category_product`
--

CREATE TABLE `category_product` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `category_product`
--

INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL),
(2, 1, 2, NULL, NULL),
(3, 1, 3, NULL, NULL),
(4, 1, 4, NULL, NULL),
(5, 3, 4, NULL, NULL),
(6, 2, 5, NULL, NULL),
(7, 5, 6, NULL, NULL),
(8, 8, 7, NULL, NULL),
(9, 6, 8, NULL, NULL),
(10, 7, 9, NULL, NULL),
(11, 8, 10, NULL, NULL),
(12, 5, 10, NULL, NULL),
(13, 8, 11, NULL, NULL),
(14, 5, 11, NULL, NULL),
(15, 5, 12, NULL, NULL),
(16, 6, 13, NULL, NULL),
(17, 5, 14, NULL, NULL),
(18, 5, 15, NULL, NULL),
(19, 6, 15, NULL, NULL),
(20, 7, 16, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `commands`
--

CREATE TABLE `commands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1709766458',
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `products` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products`)),
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `companies`
--

CREATE TABLE `companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `slogan` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone1` varchar(255) DEFAULT NULL,
  `phone2` varchar(255) DEFAULT NULL,
  `phone3` varchar(255) DEFAULT NULL,
  `phone4` varchar(255) DEFAULT NULL,
  `email1` varchar(255) DEFAULT NULL,
  `email2` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `companies`
--

INSERT INTO `companies` (`id`, `name`, `slogan`, `address`, `phone1`, `phone2`, `phone3`, `phone4`, `email1`, `email2`, `logo`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Ra\'am Shop', '', '', '+22812345678', '', '', '', 'email@raamshop.com', '', 'assets/images/logo/logo-dark-120.png', '2024-03-06 22:08:10', '2024-03-06 22:08:10', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `type` enum('Fixé','Pourcentage') NOT NULL DEFAULT 'Fixé',
  `value` decimal(20,2) NOT NULL,
  `status` enum('Actif','Inactif') NOT NULL DEFAULT 'Inactif',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `customers`
--

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phones` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `shipping_name` varchar(255) DEFAULT NULL,
  `shipping_address` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `debtors`
--

CREATE TABLE `debtors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sell_id` bigint(20) UNSIGNED DEFAULT NULL,
  `paid_amount` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `expense_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `receipt` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `expense_types`
--

CREATE TABLE `expense_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `inventories`
--

CREATE TABLE `inventories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `logs`
--

CREATE TABLE `logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `detail` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `subject` text NOT NULL,
  `message` longtext NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `messages`
--

INSERT INTO `messages` (`id`, `name`, `email`, `phone`, `photo`, `subject`, `message`, `read_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'John Doe', 'johndoe@gestapp.com', NULL, 'images/user.png', 'Just a test', 'This is a simple message test. Have a nice Day!', '2024-04-19 15:38:08', '2024-04-19 11:44:29', '2024-04-19 15:38:08', NULL),
(2, 'Utilisatrice de Quinoa', 'quinoa@utilisatrice.com', NULL, 'images/user.png', 'A quand le retour de Quinoa ?', 'Bonjour. J\'aimerais savoir si votre produit \"Quinoa Gel Cleanser\" sera bientôt de retour. Parce que je trouve que c\'est un très bon produit, mais cela fait quand même un moment que nous ne le voyons plus en rayon. \r\n\r\nMerci.', NULL, '2024-04-19 15:56:05', '2024-04-19 15:56:05', NULL),
(3, 'Super Admin', 'sa@proconsulting-info.com', NULL, 'images/user.png', 'Une petite salutation', 'Ceci est un autre message de test (oui, en français cette fois-ci ☺️) envoyé depuis mon téléphone portable.\r\nA ceux et celles qui liront ce message, bonne journée !', NULL, '2024-04-20 10:09:27', '2024-04-20 10:09:27', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2020_07_27_174857_create_categories_table', 1),
(7, '2020_07_27_175010_create_unit_measures_table', 1),
(8, '2020_07_27_175016_create_products_table', 1),
(9, '2020_07_27_175017_create_product_details_table', 1),
(10, '2020_07_27_175018_create_states_table', 1),
(11, '2020_07_27_175424_create_payment_methods_table', 1),
(12, '2020_07_27_180334_create_movement_types_table', 1),
(13, '2020_07_27_180455_create_inventories_table', 1),
(14, '2020_07_27_180722_create_suppliers_table', 1),
(15, '2020_07_27_180803_create_customers_table', 1),
(16, '2020_07_29_162525_create_expense_types_table', 1),
(17, '2020_07_29_162535_create_expenses_table', 1),
(18, '2020_07_29_162609_create_invoices_table', 1),
(19, '2020_07_30_055205_create_stocks_table', 1),
(20, '2020_07_30_063705_create_out_types_table', 1),
(21, '2020_07_30_063706_create_sells_table', 1),
(22, '2020_08_06_150846_create_logs_table', 1),
(23, '2020_08_17_095047_create_companies_table', 1),
(24, '2020_08_18_063346_create_reports_table', 1),
(25, '2020_08_19_141815_create_roles_table', 1),
(26, '2020_08_19_141930_create_permissions_table', 1),
(27, '2020_08_19_141950_create_tables_table', 1),
(28, '2020_08_19_142024_create_role_user_table', 1),
(29, '2020_08_19_142044_create_permission_role_table', 1),
(30, '2020_08_19_142107_create_permission_table_table', 1),
(31, '2020_08_20_115644_create_debtors_table', 1),
(32, '2020_08_25_100729_create_printer_types_table', 1),
(33, '2020_08_25_100759_create_printers_table', 1),
(34, '2020_08_26_073717_create_navigator_types_table', 1),
(35, '2020_08_26_088604_create_navigators_table', 1),
(36, '2020_08_28_114520_create_role_table_table', 1),
(37, '2020_10_22_083406_create_commands_table', 1),
(38, '2021_01_02_121724_create_product_unit_measure_table', 1),
(39, '2021_04_23_111417_create_supplier_credits_table', 1),
(40, '2021_05_07_120456_create_return_stocks_table', 1),
(41, '2023_11_29_092332_create_category_products_table', 1),
(42, '2024_03_06_223936_create_settings_table', 1),
(43, '2024_03_10_181656_updated_brand_category_product_models', 2),
(44, '2024_03_10_192028_redo_softdeletes_for-users', 3),
(45, '2024_03_11_100229_update_permission_table', 4),
(46, '2024_03_11_100245_update_permissionrole_table', 4),
(47, '2024_03_11_123113_create_carts_table', 4),
(48, '2024_03_11_130105_create_coupons_table', 4),
(49, '2024_03_11_164904_create_shippings_table', 5),
(50, '2024_03_11_133057_create_orders_table', 6),
(51, '2024_03_11_161133_create_permission_role_resources_table', 6),
(52, '2024_03_11_163338_create_sales_table', 6),
(53, '2024_03_11_170038_create_wishlists_table', 6),
(54, '2024_03_25_142639_add_category_id_to_products', 7),
(55, '2024_03_25_163807_update_status_to_products', 8),
(56, '2024_03_25_165439_add_status_to_products', 9),
(57, '2024_03_26_172612_edit_status_in_categories', 10),
(58, '2024_03_27_114602_edit_discount_in_products', 11),
(60, '2024_03_30_160947_add_foreign_key_to_orders_table', 12),
(61, '2024_03_11_133056_create_shippings_table', 13),
(62, '2024_03_30_152423_add_ordered_to_carts_table', 13),
(63, '2024_03_30_170757_modify_status_column_in_carts_table', 14),
(64, '2024_03_30_180942_modify_columns_in_products_table', 15),
(65, '2024_04_01_135152_add_cart_id_column_in_wishlists_table', 16),
(66, '2024_04_09_143239_change_summary_type_in_products', 17),
(67, '2024_04_17_145040_add_in_detail_available_quantity_to_products', 18),
(69, '2024_04_19_114014_create_messages_table', 19),
(70, '2024_04_22_162456_update_brands_table', 20),
(71, '2024_04_22_163747_update_brand_id_type_in_products_table', 21);

-- --------------------------------------------------------

--
-- Structure de la table `movement_types`
--

CREATE TABLE `movement_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `movement` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `navigators`
--

CREATE TABLE `navigators` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `navigator_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `navigator_types`
--

CREATE TABLE `navigator_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `order_number` varchar(255) NOT NULL,
  `sub_total` double(8,2) NOT NULL,
  `cart_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('Nouvelle','Traitée','Livrée','Annulée') NOT NULL DEFAULT 'Nouvelle',
  `total_amount` double(8,2) NOT NULL,
  `payment_method_id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `post_code` varchar(255) DEFAULT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `payment_status` enum('Payé','Impayé') NOT NULL DEFAULT 'Impayé',
  `shipping_id` bigint(20) UNSIGNED DEFAULT NULL,
  `coupon_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `out_types`
--

CREATE TABLE `out_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `out_types`
--

INSERT INTO `out_types` (`id`, `code`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, NULL, 'Vente', NULL, NULL, NULL),
(2, NULL, 'Echantillon', NULL, NULL, NULL),
(3, NULL, 'Administration', NULL, NULL, NULL),
(4, NULL, 'Autre', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `method` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `method`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Especes', NULL, NULL, NULL),
(2, 'Flooz', NULL, NULL, NULL),
(3, 'Tmoney', NULL, NULL, NULL),
(4, 'Virement Bancaire', NULL, NULL, NULL),
(5, 'Cheque', NULL, NULL, NULL),
(6, 'Credit', NULL, NULL, NULL),
(7, 'Assurance', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`, `description`) VALUES
(1, 'browse', NULL, NULL, NULL, NULL),
(2, 'edit', NULL, NULL, NULL, NULL),
(3, 'add', NULL, NULL, NULL, NULL),
(4, 'delete', NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED DEFAULT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `create` tinyint(1) DEFAULT NULL,
  `read` tinyint(1) DEFAULT NULL,
  `update` tinyint(1) DEFAULT NULL,
  `delete` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `permission_role`
--

INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`, `create`, `read`, `update`, `delete`) VALUES
(1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 3, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 4, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 3, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 4, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `permission_role_resources`
--

CREATE TABLE `permission_role_resources` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `resource` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `permission_table`
--

CREATE TABLE `permission_table` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED DEFAULT NULL,
  `table_id` bigint(20) UNSIGNED DEFAULT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `permission_table`
--

INSERT INTO `permission_table` (`id`, `permission_id`, `table_id`, `role_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 1, NULL, NULL, NULL),
(2, 2, 1, 1, NULL, NULL, NULL),
(3, 3, 1, 1, NULL, NULL, NULL),
(4, 4, 1, 1, NULL, NULL, NULL),
(5, 1, 2, 1, NULL, NULL, NULL),
(6, 2, 2, 1, NULL, NULL, NULL),
(7, 3, 2, 1, NULL, NULL, NULL),
(8, 4, 2, 1, NULL, NULL, NULL),
(9, 1, 3, 1, NULL, NULL, NULL),
(10, 2, 3, 1, NULL, NULL, NULL),
(11, 3, 3, 1, NULL, NULL, NULL),
(12, 4, 3, 1, NULL, NULL, NULL),
(13, 1, 4, 1, NULL, NULL, NULL),
(14, 2, 4, 1, NULL, NULL, NULL),
(15, 3, 4, 1, NULL, NULL, NULL),
(16, 4, 4, 1, NULL, NULL, NULL),
(17, 1, 5, 1, NULL, NULL, NULL),
(18, 2, 5, 1, NULL, NULL, NULL),
(19, 3, 5, 1, NULL, NULL, NULL),
(20, 4, 5, 1, NULL, NULL, NULL),
(21, 1, 6, 1, NULL, NULL, NULL),
(22, 2, 6, 1, NULL, NULL, NULL),
(23, 3, 6, 1, NULL, NULL, NULL),
(24, 4, 6, 1, NULL, NULL, NULL),
(25, 1, 7, 1, NULL, NULL, NULL),
(26, 2, 7, 1, NULL, NULL, NULL),
(27, 3, 7, 1, NULL, NULL, NULL),
(28, 4, 7, 1, NULL, NULL, NULL),
(29, 1, 8, 1, NULL, NULL, NULL),
(30, 2, 8, 1, NULL, NULL, NULL),
(31, 3, 8, 1, NULL, NULL, NULL),
(32, 4, 8, 1, NULL, NULL, NULL),
(33, 1, 9, 1, NULL, NULL, NULL),
(34, 2, 9, 1, NULL, NULL, NULL),
(35, 3, 9, 1, NULL, NULL, NULL),
(36, 4, 9, 1, NULL, NULL, NULL),
(37, 1, 10, 1, NULL, NULL, NULL),
(38, 2, 10, 1, NULL, NULL, NULL),
(39, 3, 10, 1, NULL, NULL, NULL),
(40, 4, 10, 1, NULL, NULL, NULL),
(41, 1, 11, 1, NULL, NULL, NULL),
(42, 2, 11, 1, NULL, NULL, NULL),
(43, 3, 11, 1, NULL, NULL, NULL),
(44, 4, 11, 1, NULL, NULL, NULL),
(45, 1, 12, 1, NULL, NULL, NULL),
(46, 2, 12, 1, NULL, NULL, NULL),
(47, 3, 12, 1, NULL, NULL, NULL),
(48, 4, 12, 1, NULL, NULL, NULL),
(49, 1, 13, 1, NULL, NULL, NULL),
(50, 2, 13, 1, NULL, NULL, NULL),
(51, 3, 13, 1, NULL, NULL, NULL),
(52, 4, 13, 1, NULL, NULL, NULL),
(53, 1, 14, 1, NULL, NULL, NULL),
(54, 2, 14, 1, NULL, NULL, NULL),
(55, 3, 14, 1, NULL, NULL, NULL),
(56, 4, 14, 1, NULL, NULL, NULL),
(57, 1, 15, 1, NULL, NULL, NULL),
(58, 2, 15, 1, NULL, NULL, NULL),
(59, 3, 15, 1, NULL, NULL, NULL),
(60, 4, 15, 1, NULL, NULL, NULL),
(61, 1, 16, 1, NULL, NULL, NULL),
(62, 2, 16, 1, NULL, NULL, NULL),
(63, 3, 16, 1, NULL, NULL, NULL),
(64, 4, 16, 1, NULL, NULL, NULL),
(65, 1, 17, 1, NULL, NULL, NULL),
(66, 2, 17, 1, NULL, NULL, NULL),
(67, 3, 17, 1, NULL, NULL, NULL),
(68, 4, 17, 1, NULL, NULL, NULL),
(69, 1, 18, 1, NULL, NULL, NULL),
(70, 2, 18, 1, NULL, NULL, NULL),
(71, 3, 18, 1, NULL, NULL, NULL),
(72, 4, 18, 1, NULL, NULL, NULL),
(73, 1, 19, 1, NULL, NULL, NULL),
(74, 2, 19, 1, NULL, NULL, NULL),
(75, 3, 19, 1, NULL, NULL, NULL),
(76, 4, 19, 1, NULL, NULL, NULL),
(77, 1, 20, 1, NULL, NULL, NULL),
(78, 2, 20, 1, NULL, NULL, NULL),
(79, 3, 20, 1, NULL, NULL, NULL),
(80, 4, 20, 1, NULL, NULL, NULL),
(81, 1, 21, 1, NULL, NULL, NULL),
(82, 2, 21, 1, NULL, NULL, NULL),
(83, 3, 21, 1, NULL, NULL, NULL),
(84, 4, 21, 1, NULL, NULL, NULL),
(85, 1, 22, 1, NULL, NULL, NULL),
(86, 2, 22, 1, NULL, NULL, NULL),
(87, 3, 22, 1, NULL, NULL, NULL),
(88, 4, 22, 1, NULL, NULL, NULL),
(89, 1, 23, 1, NULL, NULL, NULL),
(90, 2, 23, 1, NULL, NULL, NULL),
(91, 3, 23, 1, NULL, NULL, NULL),
(92, 4, 23, 1, NULL, NULL, NULL),
(93, 1, 24, 1, NULL, NULL, NULL),
(94, 2, 24, 1, NULL, NULL, NULL),
(95, 3, 24, 1, NULL, NULL, NULL),
(96, 4, 24, 1, NULL, NULL, NULL),
(97, 1, 25, 1, NULL, NULL, NULL),
(98, 2, 25, 1, NULL, NULL, NULL),
(99, 3, 25, 1, NULL, NULL, NULL),
(100, 4, 25, 1, NULL, NULL, NULL),
(101, 1, 26, 1, NULL, NULL, NULL),
(102, 2, 26, 1, NULL, NULL, NULL),
(103, 3, 26, 1, NULL, NULL, NULL),
(104, 4, 26, 1, NULL, NULL, NULL),
(105, 1, 27, 1, NULL, NULL, NULL),
(106, 2, 27, 1, NULL, NULL, NULL),
(107, 3, 27, 1, NULL, NULL, NULL),
(108, 4, 27, 1, NULL, NULL, NULL),
(109, 1, 28, 1, NULL, NULL, NULL),
(110, 2, 28, 1, NULL, NULL, NULL),
(111, 3, 28, 1, NULL, NULL, NULL),
(112, 4, 28, 1, NULL, NULL, NULL),
(113, 1, 29, 1, NULL, NULL, NULL),
(114, 2, 29, 1, NULL, NULL, NULL),
(115, 3, 29, 1, NULL, NULL, NULL),
(116, 4, 29, 1, NULL, NULL, NULL),
(117, 1, 30, 1, NULL, NULL, NULL),
(118, 2, 30, 1, NULL, NULL, NULL),
(119, 3, 30, 1, NULL, NULL, NULL),
(120, 4, 30, 1, NULL, NULL, NULL),
(121, 1, 31, 1, NULL, NULL, NULL),
(122, 2, 31, 1, NULL, NULL, NULL),
(123, 3, 31, 1, NULL, NULL, NULL),
(124, 4, 31, 1, NULL, NULL, NULL),
(125, 1, 32, 1, NULL, NULL, NULL),
(126, 2, 32, 1, NULL, NULL, NULL),
(127, 3, 32, 1, NULL, NULL, NULL),
(128, 4, 32, 1, NULL, NULL, NULL),
(129, 1, 33, 1, NULL, NULL, NULL),
(130, 2, 33, 1, NULL, NULL, NULL),
(131, 3, 33, 1, NULL, NULL, NULL),
(132, 4, 33, 1, NULL, NULL, NULL),
(133, 1, 34, 1, NULL, NULL, NULL),
(134, 2, 34, 1, NULL, NULL, NULL),
(135, 3, 34, 1, NULL, NULL, NULL),
(136, 4, 34, 1, NULL, NULL, NULL),
(137, 1, 35, 1, NULL, NULL, NULL),
(138, 2, 35, 1, NULL, NULL, NULL),
(139, 3, 35, 1, NULL, NULL, NULL),
(140, 4, 35, 1, NULL, NULL, NULL),
(141, 1, 36, 1, NULL, NULL, NULL),
(142, 2, 36, 1, NULL, NULL, NULL),
(143, 3, 36, 1, NULL, NULL, NULL),
(144, 4, 36, 1, NULL, NULL, NULL),
(145, 1, 37, 1, NULL, NULL, NULL),
(146, 2, 37, 1, NULL, NULL, NULL),
(147, 3, 37, 1, NULL, NULL, NULL),
(148, 4, 37, 1, NULL, NULL, NULL),
(149, 1, 38, 1, NULL, NULL, NULL),
(150, 2, 38, 1, NULL, NULL, NULL),
(151, 3, 38, 1, NULL, NULL, NULL),
(152, 4, 38, 1, NULL, NULL, NULL),
(153, 1, 39, 1, NULL, NULL, NULL),
(154, 2, 39, 1, NULL, NULL, NULL),
(155, 3, 39, 1, NULL, NULL, NULL),
(156, 4, 39, 1, NULL, NULL, NULL),
(157, 1, 40, 1, NULL, NULL, NULL),
(158, 2, 40, 1, NULL, NULL, NULL),
(159, 3, 40, 1, NULL, NULL, NULL),
(160, 4, 40, 1, NULL, NULL, NULL),
(161, 1, 41, 1, NULL, NULL, NULL),
(162, 2, 41, 1, NULL, NULL, NULL),
(163, 3, 41, 1, NULL, NULL, NULL),
(164, 4, 41, 1, NULL, NULL, NULL),
(165, 1, 42, 1, NULL, NULL, NULL),
(166, 2, 42, 1, NULL, NULL, NULL),
(167, 3, 42, 1, NULL, NULL, NULL),
(168, 4, 42, 1, NULL, NULL, NULL),
(169, 1, 43, 1, NULL, NULL, NULL),
(170, 2, 43, 1, NULL, NULL, NULL),
(171, 3, 43, 1, NULL, NULL, NULL),
(172, 4, 43, 1, NULL, NULL, NULL),
(173, 1, 1, 1, NULL, NULL, NULL),
(174, 2, 1, 1, NULL, NULL, NULL),
(175, 3, 1, 1, NULL, NULL, NULL),
(176, 4, 1, 1, NULL, NULL, NULL),
(177, 1, 2, 1, NULL, NULL, NULL),
(178, 2, 2, 1, NULL, NULL, NULL),
(179, 3, 2, 1, NULL, NULL, NULL),
(180, 4, 2, 1, NULL, NULL, NULL),
(181, 1, 3, 1, NULL, NULL, NULL),
(182, 2, 3, 1, NULL, NULL, NULL),
(183, 3, 3, 1, NULL, NULL, NULL),
(184, 4, 3, 1, NULL, NULL, NULL),
(185, 1, 4, 1, NULL, NULL, NULL),
(186, 2, 4, 1, NULL, NULL, NULL),
(187, 3, 4, 1, NULL, NULL, NULL),
(188, 4, 4, 1, NULL, NULL, NULL),
(189, 1, 5, 1, NULL, NULL, NULL),
(190, 2, 5, 1, NULL, NULL, NULL),
(191, 3, 5, 1, NULL, NULL, NULL),
(192, 4, 5, 1, NULL, NULL, NULL),
(193, 1, 6, 1, NULL, NULL, NULL),
(194, 2, 6, 1, NULL, NULL, NULL),
(195, 3, 6, 1, NULL, NULL, NULL),
(196, 4, 6, 1, NULL, NULL, NULL),
(197, 1, 7, 1, NULL, NULL, NULL),
(198, 2, 7, 1, NULL, NULL, NULL),
(199, 3, 7, 1, NULL, NULL, NULL),
(200, 4, 7, 1, NULL, NULL, NULL),
(201, 1, 8, 1, NULL, NULL, NULL),
(202, 2, 8, 1, NULL, NULL, NULL),
(203, 3, 8, 1, NULL, NULL, NULL),
(204, 4, 8, 1, NULL, NULL, NULL),
(205, 1, 9, 1, NULL, NULL, NULL),
(206, 2, 9, 1, NULL, NULL, NULL),
(207, 3, 9, 1, NULL, NULL, NULL),
(208, 4, 9, 1, NULL, NULL, NULL),
(209, 1, 10, 1, NULL, NULL, NULL),
(210, 2, 10, 1, NULL, NULL, NULL),
(211, 3, 10, 1, NULL, NULL, NULL),
(212, 4, 10, 1, NULL, NULL, NULL),
(213, 1, 11, 1, NULL, NULL, NULL),
(214, 2, 11, 1, NULL, NULL, NULL),
(215, 3, 11, 1, NULL, NULL, NULL),
(216, 4, 11, 1, NULL, NULL, NULL),
(217, 1, 12, 1, NULL, NULL, NULL),
(218, 2, 12, 1, NULL, NULL, NULL),
(219, 3, 12, 1, NULL, NULL, NULL),
(220, 4, 12, 1, NULL, NULL, NULL),
(221, 1, 13, 1, NULL, NULL, NULL),
(222, 2, 13, 1, NULL, NULL, NULL),
(223, 3, 13, 1, NULL, NULL, NULL),
(224, 4, 13, 1, NULL, NULL, NULL),
(225, 1, 14, 1, NULL, NULL, NULL),
(226, 2, 14, 1, NULL, NULL, NULL),
(227, 3, 14, 1, NULL, NULL, NULL),
(228, 4, 14, 1, NULL, NULL, NULL),
(229, 1, 15, 1, NULL, NULL, NULL),
(230, 2, 15, 1, NULL, NULL, NULL),
(231, 3, 15, 1, NULL, NULL, NULL),
(232, 4, 15, 1, NULL, NULL, NULL),
(233, 1, 16, 1, NULL, NULL, NULL),
(234, 2, 16, 1, NULL, NULL, NULL),
(235, 3, 16, 1, NULL, NULL, NULL),
(236, 4, 16, 1, NULL, NULL, NULL),
(237, 1, 17, 1, NULL, NULL, NULL),
(238, 2, 17, 1, NULL, NULL, NULL),
(239, 3, 17, 1, NULL, NULL, NULL),
(240, 4, 17, 1, NULL, NULL, NULL),
(241, 1, 18, 1, NULL, NULL, NULL),
(242, 2, 18, 1, NULL, NULL, NULL),
(243, 3, 18, 1, NULL, NULL, NULL),
(244, 4, 18, 1, NULL, NULL, NULL),
(245, 1, 19, 1, NULL, NULL, NULL),
(246, 2, 19, 1, NULL, NULL, NULL),
(247, 3, 19, 1, NULL, NULL, NULL),
(248, 4, 19, 1, NULL, NULL, NULL),
(249, 1, 20, 1, NULL, NULL, NULL),
(250, 2, 20, 1, NULL, NULL, NULL),
(251, 3, 20, 1, NULL, NULL, NULL),
(252, 4, 20, 1, NULL, NULL, NULL),
(253, 1, 21, 1, NULL, NULL, NULL),
(254, 2, 21, 1, NULL, NULL, NULL),
(255, 3, 21, 1, NULL, NULL, NULL),
(256, 4, 21, 1, NULL, NULL, NULL),
(257, 1, 22, 1, NULL, NULL, NULL),
(258, 2, 22, 1, NULL, NULL, NULL),
(259, 3, 22, 1, NULL, NULL, NULL),
(260, 4, 22, 1, NULL, NULL, NULL),
(261, 1, 23, 1, NULL, NULL, NULL),
(262, 2, 23, 1, NULL, NULL, NULL),
(263, 3, 23, 1, NULL, NULL, NULL),
(264, 4, 23, 1, NULL, NULL, NULL),
(265, 1, 24, 1, NULL, NULL, NULL),
(266, 2, 24, 1, NULL, NULL, NULL),
(267, 3, 24, 1, NULL, NULL, NULL),
(268, 4, 24, 1, NULL, NULL, NULL),
(269, 1, 25, 1, NULL, NULL, NULL),
(270, 2, 25, 1, NULL, NULL, NULL),
(271, 3, 25, 1, NULL, NULL, NULL),
(272, 4, 25, 1, NULL, NULL, NULL),
(273, 1, 26, 1, NULL, NULL, NULL),
(274, 2, 26, 1, NULL, NULL, NULL),
(275, 3, 26, 1, NULL, NULL, NULL),
(276, 4, 26, 1, NULL, NULL, NULL),
(277, 1, 27, 1, NULL, NULL, NULL),
(278, 2, 27, 1, NULL, NULL, NULL),
(279, 3, 27, 1, NULL, NULL, NULL),
(280, 4, 27, 1, NULL, NULL, NULL),
(281, 1, 28, 1, NULL, NULL, NULL),
(282, 2, 28, 1, NULL, NULL, NULL),
(283, 3, 28, 1, NULL, NULL, NULL),
(284, 4, 28, 1, NULL, NULL, NULL),
(285, 1, 29, 1, NULL, NULL, NULL),
(286, 2, 29, 1, NULL, NULL, NULL),
(287, 3, 29, 1, NULL, NULL, NULL),
(288, 4, 29, 1, NULL, NULL, NULL),
(289, 1, 30, 1, NULL, NULL, NULL),
(290, 2, 30, 1, NULL, NULL, NULL),
(291, 3, 30, 1, NULL, NULL, NULL),
(292, 4, 30, 1, NULL, NULL, NULL),
(293, 1, 31, 1, NULL, NULL, NULL),
(294, 2, 31, 1, NULL, NULL, NULL),
(295, 3, 31, 1, NULL, NULL, NULL),
(296, 4, 31, 1, NULL, NULL, NULL),
(297, 1, 32, 1, NULL, NULL, NULL),
(298, 2, 32, 1, NULL, NULL, NULL),
(299, 3, 32, 1, NULL, NULL, NULL),
(300, 4, 32, 1, NULL, NULL, NULL),
(301, 1, 33, 1, NULL, NULL, NULL),
(302, 2, 33, 1, NULL, NULL, NULL),
(303, 3, 33, 1, NULL, NULL, NULL),
(304, 4, 33, 1, NULL, NULL, NULL),
(305, 1, 34, 1, NULL, NULL, NULL),
(306, 2, 34, 1, NULL, NULL, NULL),
(307, 3, 34, 1, NULL, NULL, NULL),
(308, 4, 34, 1, NULL, NULL, NULL),
(309, 1, 35, 1, NULL, NULL, NULL),
(310, 2, 35, 1, NULL, NULL, NULL),
(311, 3, 35, 1, NULL, NULL, NULL),
(312, 4, 35, 1, NULL, NULL, NULL),
(313, 1, 36, 1, NULL, NULL, NULL),
(314, 2, 36, 1, NULL, NULL, NULL),
(315, 3, 36, 1, NULL, NULL, NULL),
(316, 4, 36, 1, NULL, NULL, NULL),
(317, 1, 37, 1, NULL, NULL, NULL),
(318, 2, 37, 1, NULL, NULL, NULL),
(319, 3, 37, 1, NULL, NULL, NULL),
(320, 4, 37, 1, NULL, NULL, NULL),
(321, 1, 38, 1, NULL, NULL, NULL),
(322, 2, 38, 1, NULL, NULL, NULL),
(323, 3, 38, 1, NULL, NULL, NULL),
(324, 4, 38, 1, NULL, NULL, NULL),
(325, 1, 39, 1, NULL, NULL, NULL),
(326, 2, 39, 1, NULL, NULL, NULL),
(327, 3, 39, 1, NULL, NULL, NULL),
(328, 4, 39, 1, NULL, NULL, NULL),
(329, 1, 40, 1, NULL, NULL, NULL),
(330, 2, 40, 1, NULL, NULL, NULL),
(331, 3, 40, 1, NULL, NULL, NULL),
(332, 4, 40, 1, NULL, NULL, NULL),
(333, 1, 41, 1, NULL, NULL, NULL),
(334, 2, 41, 1, NULL, NULL, NULL),
(335, 3, 41, 1, NULL, NULL, NULL),
(336, 4, 41, 1, NULL, NULL, NULL),
(337, 1, 42, 1, NULL, NULL, NULL),
(338, 2, 42, 1, NULL, NULL, NULL),
(339, 3, 42, 1, NULL, NULL, NULL),
(340, 4, 42, 1, NULL, NULL, NULL),
(341, 1, 43, 1, NULL, NULL, NULL),
(342, 2, 43, 1, NULL, NULL, NULL),
(343, 3, 43, 1, NULL, NULL, NULL),
(344, 4, 43, 1, NULL, NULL, NULL),
(345, 1, 35, 2, NULL, NULL, NULL),
(346, 1, 5, 2, NULL, NULL, NULL),
(347, 1, 6, 2, NULL, NULL, NULL),
(348, 1, 8, 2, NULL, NULL, NULL),
(349, 2, 35, 2, NULL, NULL, NULL),
(350, 2, 5, 2, NULL, NULL, NULL),
(351, 2, 6, 2, NULL, NULL, NULL),
(352, 2, 8, 2, NULL, NULL, NULL),
(353, 3, 35, 2, NULL, NULL, NULL),
(354, 3, 5, 2, NULL, NULL, NULL),
(355, 3, 6, 2, NULL, NULL, NULL),
(356, 3, 8, 2, NULL, NULL, NULL),
(357, 4, 35, 2, NULL, NULL, NULL),
(358, 4, 5, 2, NULL, NULL, NULL),
(359, 4, 6, 2, NULL, NULL, NULL),
(360, 4, 8, 2, NULL, NULL, NULL),
(361, 1, 44, 1, NULL, NULL, NULL),
(362, 2, 44, 1, NULL, NULL, NULL),
(363, 3, 44, 1, NULL, NULL, NULL),
(364, 4, 44, 1, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `printers`
--

CREATE TABLE `printers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `printer_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `port` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `printer_types`
--

CREATE TABLE `printer_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `printer_types`
--

INSERT INTO `printer_types` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Laser', NULL, NULL, NULL),
(2, 'Thermique', NULL, NULL, NULL),
(3, 'Jet d\'encre', NULL, NULL, NULL),
(4, 'Bulle d\'encre', NULL, NULL, NULL),
(5, 'Matricielle', NULL, NULL, NULL),
(6, 'LED', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `tva` varchar(255) NOT NULL DEFAULT '0%',
  `expiration_date` date DEFAULT NULL,
  `security_stock` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED NOT NULL,
  `discount` varchar(255) NOT NULL DEFAULT '0%',
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `summary` text NOT NULL,
  `status` enum('Disponible','Non Disponible','En Promotion','Arreté') NOT NULL DEFAULT 'Disponible',
  `selling_price` double NOT NULL DEFAULT 0,
  `in_detail_available_quantity` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `products`
--

INSERT INTO `products` (`id`, `code`, `name`, `reference`, `image`, `tva`, `expiration_date`, `security_stock`, `created_at`, `updated_at`, `deleted_at`, `brand_id`, `discount`, `is_featured`, `summary`, `status`, `selling_price`, `in_detail_available_quantity`) VALUES
(1, NULL, 'Clair comme Clarisse', '12345678', 'storage/products/clair-comme-clarisse-1710505345.png', '10%', '2025-04-23', 10, '2024-03-15 11:22:26', '2024-03-15 13:10:06', '2024-03-15 13:10:06', 1, '0', 0, 'not null', 'Disponible', 0, 0),
(2, NULL, 'Clair comme Clarisse', '12345678', 'storage/products/clair-comme-clarisse-1710511881.png', '10%', '2025-11-14', 15, '2024-03-15 13:11:21', '2024-03-15 13:16:53', '2024-03-15 13:16:53', 1, '0', 0, 'not null', 'Disponible', 0, 0),
(3, '000003', 'Clair comme Clarisse', '12345678', 'storage/products/clair-comme-clarisse-1711549312.jpg', '10%', NULL, 0, '2024-03-15 13:17:48', '2024-04-09 11:41:46', '2024-04-09 11:41:46', 1, '0', 0, 'not null', 'Disponible', 0, 0),
(4, '000004', 'simple comme simplice', 'P-000004', 'storage/products/simple-comme-simplice-1711540414.png', '0%', NULL, 30, '2024-03-27 10:53:34', '2024-04-09 11:41:46', '2024-04-09 11:41:46', 1, '12%', 0, 'Le produit qu&#039;il vous faut pour devenir aussi simple que Simplice !', 'Disponible', 13000, 0),
(5, '000005', 'Franc comme François', 'P000005', 'storage/products/franc-comme-francois-1711556079.png', '0%', NULL, 40, '2024-03-27 15:14:39', '2024-04-09 11:41:57', '2024-04-09 11:41:57', 1, '10%', 0, 'Avec ce produit, vous serez aussi franc que François', 'Disponible', 750, 0),
(6, '000001', 'Quinoa Gel Cleanser', 'P000001', 'storage/products/quinoa-gel-cleanser-1712674414.jpg', '0%', '2029-04-25', 20, '2024-04-09 12:53:34', '2024-04-09 12:53:34', NULL, 1, '12%', 0, 'Un nettoyant doux qui élimine le maquillage et les pores en une seule étape, tout en offrant un lavage doux et hydratant au pH naturel de votre peau. La combinaison de quinoa et de nutriments sains élimine les toxines de l&#039;environnement pour révéler une peau saine et vivante.\r\n\r\nListe complète des ingrédients\r\nEau, Decyl Glucoside, Sodium Cocoyl Glutamate, Chenopodium Quinoa Seed Extract, Glycerin, Sodium Lauroyl Glutamate, Betaine, Glycine Soja (Soybean Oil), Melaleuca Alternifolia (Tea Tree) Extract, Chlorphenesin, Hydroxyacetophenone, Ethylhexylglycerin, Extrait de feuille de Camellia Sinensis, extrait de Humulus Lupulus (houblon), extrait d&#039;Ocimum Tenuiflorum, extrait de Centella Asiatica, extrait de fleur de Calendula Officinalis, extrait de fruit de Prunus Amygdalus Dulcis (amande douce), acide citrique, huile de Geranium Maculatum, allantoïne.', 'Disponible', 15000, 300),
(7, '000007', 'Facetheory Clarifying', 'P000007', 'storage/products/facetheory-clarifying-1712674918.jpg', '0%', '2026-08-11', 0, '2024-04-09 13:01:58', '2024-04-09 13:01:58', NULL, 1, '5%', 1, 'Notre crème nettoyante clarifiante la plus vendue contient un puissant trio d&#039;acides à pH bas pour les peaux grasses, congestionnées et sujettes aux imperfections.\r\nContient 2 % d&#039;acide salicylique, qui pénètre profondément dans les pores pour éliminer les impuretés et réduire l&#039;apparence des points noirs.\r\nFormulé avec de l&#039;acide glycolique (4 %) et de l&#039;acide lactique (1 %) pour exfolier la peau, éliminer les cellules mortes et améliorer la texture et l&#039;aspect général de la peau.\r\nL&#039;acide salicylique (2 %) pénètre profondément dans les pores.\r\nSans parabènes, silicones, PEG, SLS, SLES et huiles minérales.\r\nVégétalien et sans cruauté. \r\nFabriqué au Royaume-Uni.\r\nLes produits Facetheory contiennent une forte concentration d&#039;actifs, de sorte que seule une petite quantité est nécessaire à chaque utilisation. 180ml durent généralement deux mois.\r\nNe pas utiliser si vous avez moins de 18 ans ou si vous êtes enceinte. \r\nDemandez conseil à votre médecin.', 'Disponible', 12500, 0),
(8, '000008', 'B-BOOST 10% Niacinamide Serum', 'P000008', 'storage/products/b-boost-10-niacinamide-serum-1712675404.jpg', '0%', NULL, 0, '2024-04-09 13:10:04', '2024-04-09 13:10:04', NULL, 1, '0%', 0, 'Découvrez la puissance de notre sérum à 10 % de niacinamide, une formule puissante conçue pour transformer votre peau. Ce sérum associe les bienfaits de la niacinamide, de l&#039;extrait de centella asiatica et d&#039;autres ingrédients soigneusement sélectionnés pour répondre à de multiples préoccupations cutanées.\r\n\r\nNotre sérum régule efficacement la production de sébum, minimise l&#039;apparence des pores et améliore la texture de la peau, pour un teint plus lisse et plus raffiné. Le niacinamide apaise et calme la peau, réduisant les rougeurs et les irritations.\r\n\r\nGrâce à l&#039;ajout de filtrat de sécrétion d&#039;escargot et de glycérine, ce sérum procure une hydratation intense, laissant votre peau rebondie, souple et profondément hydratée. Le niacinamide aide également à estomper les taches sombres, l&#039;hyperpigmentation et les cicatrices d&#039;acné, révélant ainsi un teint plus lumineux et plus uniforme.', 'Disponible', 23800, 0),
(9, '000009', 'JUMISO All Day Vitamin', 'P000009', 'storage/products/jumiso-all-day-vitamin-1712675731.jpg', '7%', '2026-06-09', 25, '2024-04-09 13:15:32', '2024-04-09 14:46:32', NULL, 1, '0%', 0, 'Cette version améliorée du sérum culte à la vitamine C Drop The Vita C présente une texture légère et non collante qui pénètre rapidement la peau. Enrichi en extraits d’arbre de vitamine et de centella asiatica pour apaiser, en acide hyaluronique pour hydrater la peau, et en extrait de camomille pour réguler la production de sébum. Convient à tous les types de peaux.\r\n\r\nHippophae Rhamnoides (Sea Buckthorn) Fruit Extract (86.14%), Methylpropanediol, Glycerin, Niacinamide, Dipropylene Glycol, Sodium Hyaluronate, PEG-Hydrogenated Castor Oil, Centella Asiatica (Gotu Kola) Extract, Polygonum Cuspidatum (Japanese Knotweed) Root Extract, Scutellaria Baicalensis (Baikal Skullcap) Root Extract, Camellia Sinensis (Green Tea) Leaf Extract, Glycyrrhiza Glabra (Licorice) Root Extract, Chamomilla Recutita (Matricaria) Flower Extract, Rosmarinus Officinalis (Rosemary) Leaf Extract, Panthenol, Betaine, Ascorbic Acid, Hydroxyacetophenone, Pentylene Glycol, Caprylyl Glycol, Butylene Glycol, Chlorphenesin, Carbomer, Arginine, Disodium EDTA, Pelargonium Graveolens (Geranium) Flower Oil, Cymbopogon Martini (Palmarosa) Oil, Cananga Odorata (Ylang Ylang) Oil, Citrus Aurantium Bergamia (Bergamot) Peel Oil, Rosa Damascena (Rose) Flower Oil\r\n\r\nNB : Les ingrédients peuvent changer à la discrétion du fabricant. Pour connaître la liste complète et à jour des ingrédients, veuillez vous référer au packaging.\r\n\r\nDétails\r\nInformations produit\r\nCruelty free :	Oui\r\nPays d&#039;importation :	Corée du Sud\r\nRéférence :	1068569767\r\nCe sérum à la vitamine C riche en antioxydants illumine et restaure l’équilibre naturel de la peau, tout en la protégeant du stress oxydatif tout au long de la journée.Le sérum illuminateur et rééquilibrant All Day Vitamin est la nouvelle version du sérum à la vitamine C Drop The Vita C.\r\nBienfaits et avantages :\r\nGrâce à sa vitamine C pure et à son adénosine antioxydantes, ce sérum réduit les ridules, pour une peau visiblement plus belle.\r\nConvient à tous les types de peaux.\r\n* Lors de l’utilisation de ce sérum, vous pouvez ressentir une brève sensation de chaleur au moment de l’absorption de la vitamine pure par votre peau.\r\nUtilisation :\r\nÀ utiliser lors de votre routine du soir. Après le nettoyage, appliquez uniformément une petite quantité de produit sur votre visage.\r\nÀ propos de la marque : JUMISO\r\nFiliale de HELLOSKIN, JUMISO propose des masques et d’autres soins de la peau qui mettent en premier lieu l’accent sur la satisfaction du consommateur. Le nom de la marque vient du coréen « ju », donner, et « miso », sourire. JUMISO fabrique tous ses produits en Corée, notamment ses produits stars : le masque nourrissant Rich Nourishment Mask, le masque éclaircissant First Skin Lightening Mask, le masque apaisant Whoa Whoa Soothing Mask et le Water Splash Mask.', 'Disponible', 35000, 0),
(10, '000010', 'Nineless A-Control', 'P000010', 'storage/products/nineless-a-control-1712682049.jpg', '0%', NULL, 0, '2024-04-09 15:00:49', '2024-04-09 15:00:49', NULL, 1, '0%', 1, 'Voici notre sérum azélaïque à 10 %, une formule puissante qui aide à éclaircir et à unifier le teint de la peau tout en réduisant l&#039;apparence des imperfections et des ridules. Ce sérum est parfait pour les personnes ayant une peau sujette à l&#039;acné ou hyperpigmentée et convient à tous les types de peau.\r\n\r\nNotre sérum contient un mélange puissant d&#039;extrait de centella asiatica, d&#039;acide azélaïque et de niacinamide, qui agissent ensemble pour apaiser la peau irritée.\r\n\r\nL&#039;ajout de filtrat de sécrétion d&#039;escargot aide à hydrater et à promouvoir la production de collagène, tandis que l&#039;acide lactique exfolie en douceur et améliore la texture de la peau.\r\n\r\nNotre sérum est exempt de parabènes, de sulfates et de parfums artificiels, ce qui vous donne l&#039;assurance d&#039;utiliser un produit sûr et efficace. Avec une utilisation continue, notre sérum azélaïque à 10% laissera votre peau radieuse, claire et saine.', 'Disponible', 12500, 0),
(11, '000011', 'AHA.BHA.PHA', 'P000011', 'storage/products/ahabhapha-1712734225.jpg', '0%', '2026-08-03', 10, '2024-04-10 05:30:27', '2024-04-17 16:41:48', NULL, 1, '0%', 0, 'Découvrez les trois ingrédients qui changent et sauvent votre peau en difficulté - AHA BHA PHA. Fréquemment appelés «trio exfoliant» dans une routine de soin de la peau, ces trois ingrédients de soin servent à des fins similaires mais ciblées pour vos problèmes de peau. Les AHA, connus sous le nom d&#039;acides alpha-hydroxy, sont des acides solubles dans l&#039;eau fabriqués à partir de fruits sucrés. Ils aident à décoller la surface de votre peau afin que de nouvelles cellules cutanées plus uniformément pigmentées puissent se générer pour révéler un teint plus éclatant. Les BHA, en revanche, sont les meilleurs pour les peaux à tendance acnéique et peuvent pénétrer davantage dans la peau pour contrôler la production de sébum et d&#039;huile. Les PHA agissent en exfoliant les cellules mortes de la peau à la surface comme les AHA et sont idéales pour les peaux sensibles plus sujettes aux irritations. La combinaison de l&#039;AHA, du BHA et du PHA offre un large éventail d&#039;avantages pour la peau qui aide à améliorer la texture et le teint de votre peau.', 'Disponible', 27000, 60),
(12, '000012', 'Ginseng Cleansing Oil', 'P000012', 'storage/products/ginseng-cleansing-oil-1712734534.jpg', '0%', '2027-07-29', 20, '2024-04-10 05:35:34', '2024-04-10 05:35:34', NULL, 1, '0%', 0, 'Enrichie à 50 % en huile de soja et à 0,1 % en huile de graines de ginseng, pour nettoyer votre visage tout en douceur.\r\nAbsorbe et dissout tout en douceur les résidus de maquillage et les impuretés incrustées dans les pores, tout en lissant le grain de peau en un instant.\r\nProtège la peau des agressions extérieures, et hydrate la peau intensément et en profondeur.\r\nSa texture légère de type huile liquide s’applique sans effort, et sans fini gras.\r\nSon huile de graines de ginseng présente une subtile senteur de plantes, pour faire de l&#039;étape nettoyage un pur moment de relaxation.\r\nUtilisation :\r\n1. Appliquez une quantité appropriée de produit sur visage sec, et massez délicatement en effectuant des mouvements circulaires jusqu&#039;à dissolution complète du maquillage et des impuretés.\r\n2. Rincez soigneusement à l’eau tiède.\r\n\r\nÀ propos de la marque : Beauty of Joseon\r\nRéputée pour sa crème Dynasty, la marque coréenne Beauty of Joseon emploie des plantes orientales raffinées pour créer des soins ciblant les femmes de la vingtaine à la quarantaine. La marque puise son inspiration dans une encyclopédie du 19e siècle décrivant les secrets cosmétiques des femmes de la haute société coréenne de l’époque. Avec ses produits entièrement fabriqués en Corée, Beauty of Joseon révèle la beauté naturelle de la peau en améliorant son état général et en résolvant des problèmes de base tels qu’une peau rêche ou déshydratée, ou un teint terne.', 'Disponible', 22000, 0),
(13, '000013', 'IN\'OYA', 'P000013', 'storage/products/inoya-1712734843.jpg', '0%', '2026-01-20', 10, '2024-04-10 05:40:43', '2024-04-10 05:40:43', NULL, 1, '0%', 1, 'Mon Lait Corps « Unifiant Hydratant » MEL’OYA® Lite est le soin corporel parfait pour les peaux noires, mates et métissées. Formulé avec des actifs nourrissants, protecteurs et relipidants, il permet d&#039;hydrater la peau durant 24 heures et de renforcer sa barrière cutanée.\r\n\r\nIl contient également des actifs unifiant issus de la technologie brevetée MEL’OYA® Lite qui permettent d&#039;illuminer et de révéler l&#039;éclat naturel de la peau sans l&#039;éclaircir.\r\n\r\nIl contribue ainsi à estomper tous types de taches pigmentaires. En plus de pénétrer rapidement dans la peau sans laisser de film gras, il laisse la peau douce, lumineuse et soyeuse avec un délicat parfum poudré. Sa contenance est de 400mL pour permettre une utilisation quotidienne durant plusieurs semaines.\r\n\r\nQUAND Matin et/ou soir sur peau nettoyée\r\n\r\nBÉNÉFICES Peau douce, lumineuse et soyeuse', 'Disponible', 25000, 0),
(14, '000014', 'TOCOBO', 'P000014', 'storage/products/tocobo-1712735050.jpg', '0%', '2027-08-30', 25, '2024-04-10 05:44:10', '2024-04-10 05:44:10', NULL, 1, '0%', 1, 'La marque coréenne et végane de soin du visage TOCOBO s&#039;attache à développer des produits efficaces, pour vous aider à révéler votre beauté intérieure. TOCOBO met l&#039;accent sur la clarté, la modernité et la satisfaction dans le développement de ses produits, en restant toujours transparente sur les ingrédients utilisés dans ses formules, et en garantissant que ses produits suivent les dernières tendances beauté tout en étant à la hauteur des attentes des client.e.s. Les produits les plus populaires de la marque incluent notamment sa crème solaire aqueuse et bio FPS 50 PA++++, un produit hybride entre le sérum et la crème solaire, qui offre un effet apaisant en plus de sa protection solaire. Son stick solaire doux Cotton Soft FPS 50 PA++++, qui protège et hydrate la peau, est également très apprécié. Enfin, n&#039;oublions pas de mentionner également son tonique aux AHA, BHA et citron, muni d&#039;un capuchon adorable en forme de citron. Tous les produits de chez TOCOBO sont entièrement fabriqués en Corée.', 'Disponible', 52000, 0),
(15, '000015', 'REVOX', 'P000015', 'storage/products/revox-1712933631.jpg', '0%', '2025-07-22', 15, '2024-04-12 12:53:52', '2024-04-12 12:53:52', NULL, 1, '0%', 0, 'REVOX B77 JUST ALPHA ARBUTIN 2% + HA est un sérum éclaircissant pour le visage et le cou. L&#039;alpha-arbutine purifiée est un agent éclaircissant doux mais très puissant. Dans sa concentration élevée de 2%, il agit efficacement pour réduire la production de pigments de la peau, prévenir une nouvelle pigmentation et unifier le teint. Cette formule avancée est enrichie en acide hyaluronique pour un conditionnement et un confort supplémentaires de la peau. Le produit cible les rougeurs post-imperfections, les taches de vieillesse et de soleil, ainsi que les cicatrices d&#039;acné pigmentées. Il convient à tous les types de peau. Combiner avec REVOX B77 JUST Vitamine C 20% pour une protection antioxydante, et avec REVOX B77 JUST Acide Hyaluronique 5% ou REVOX B77 JUST Huile d&#039;Argan 100% pour l&#039;hydratation.', 'Disponible', 14500, 0),
(16, '000016', 'ANUA HeartLeaf 77%', 'P000016', 'storage/products/anua-heartleaf-77-1712933962.jpg', '0%', NULL, 20, '2024-04-12 12:59:22', '2024-04-12 12:59:22', NULL, 1, '0%', 0, 'Anua estime qu’une peau saine ne dépend pas uniquement des produits de soins de la peau, mais aussi d’un esprit détendu et d’un mode de vie adapté. La marque se concentre sur le choix d’ingrédients purs et biologiques pour maximiser l’efficacité de ses soins et minimiser les effets nocifs sur la peau. Ses produits respectueux de l’environnement et durables sont fabriqués à 100 % en Corée et conçus avec des emballages simples. Ses best-sellers incluent le toner apaisant Heartleaf 77% Soothing Toner, l’ampoule apaisante Heartleaf 80% Soothing Ampoule et la crème solaire 5-Zero Mild Sun Cream.', 'Disponible', 17000, 0);

-- --------------------------------------------------------

--
-- Structure de la table `product_details`
--

CREATE TABLE `product_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `product_unit_measure`
--

CREATE TABLE `product_unit_measure` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_measure_id` bigint(20) UNSIGNED DEFAULT NULL,
  `unit_price` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `product_unit_measure`
--

INSERT INTO `product_unit_measure` (`id`, `product_id`, `unit_measure_id`, `unit_price`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 5, 0, NULL, NULL, NULL),
(2, 2, 5, 2000, NULL, NULL, NULL),
(3, 3, 5, 2000, NULL, NULL, NULL),
(4, 4, 7, 13000, NULL, NULL, NULL),
(5, 5, 9, 750, NULL, NULL, NULL),
(6, 5, 1, 7500, NULL, NULL, NULL),
(7, 6, 5, 15000, NULL, NULL, NULL),
(8, 7, 7, 12500, NULL, NULL, NULL),
(9, 8, 5, 23800, NULL, NULL, NULL),
(10, 9, 5, 35000, NULL, NULL, NULL),
(11, 10, 5, 12500, NULL, NULL, NULL),
(12, 10, 1, 150000, NULL, NULL, NULL),
(13, 11, 5, 27000, NULL, NULL, NULL),
(14, 12, 8, 22000, NULL, NULL, NULL),
(15, 13, 7, 25000, NULL, NULL, NULL),
(16, 13, 4, 100000, NULL, NULL, NULL),
(17, 14, 7, 52000, NULL, NULL, NULL),
(18, 15, 5, 14500, NULL, NULL, NULL),
(19, 16, 8, 17000, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `reports`
--

CREATE TABLE `reports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `return_stocks`
--

CREATE TABLE `return_stocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1709766459',
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `products` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products`)),
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'admin', NULL, NULL, NULL),
(2, 'vendeur', NULL, NULL, NULL),
(3, 'user', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `role_table`
--

CREATE TABLE `role_table` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `table_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `role_table`
--

INSERT INTO `role_table` (`id`, `role_id`, `table_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, NULL, NULL, NULL),
(2, 1, 2, NULL, NULL, NULL),
(3, 1, 3, NULL, NULL, NULL),
(4, 1, 4, NULL, NULL, NULL),
(7, 1, 7, NULL, NULL, NULL),
(9, 1, 9, NULL, NULL, NULL),
(10, 1, 10, NULL, NULL, NULL),
(11, 1, 11, NULL, NULL, NULL),
(12, 1, 12, NULL, NULL, NULL),
(13, 1, 13, NULL, NULL, NULL),
(14, 1, 14, NULL, NULL, NULL),
(15, 1, 15, NULL, NULL, NULL),
(16, 1, 16, NULL, NULL, NULL),
(17, 1, 17, NULL, NULL, NULL),
(18, 1, 18, NULL, NULL, NULL),
(19, 1, 19, NULL, NULL, NULL),
(20, 1, 20, NULL, NULL, NULL),
(21, 1, 21, NULL, NULL, NULL),
(22, 1, 22, NULL, NULL, NULL),
(23, 1, 23, NULL, NULL, NULL),
(24, 1, 24, NULL, NULL, NULL),
(25, 1, 25, NULL, NULL, NULL),
(26, 1, 26, NULL, NULL, NULL),
(27, 1, 27, NULL, NULL, NULL),
(28, 1, 28, NULL, NULL, NULL),
(29, 1, 29, NULL, NULL, NULL),
(30, 1, 30, NULL, NULL, NULL),
(31, 1, 31, NULL, NULL, NULL),
(32, 1, 32, NULL, NULL, NULL),
(33, 1, 33, NULL, NULL, NULL),
(34, 1, 34, NULL, NULL, NULL),
(36, 1, 36, NULL, NULL, NULL),
(37, 1, 37, NULL, NULL, NULL),
(38, 1, 38, NULL, NULL, NULL),
(39, 1, 39, NULL, NULL, NULL),
(40, 1, 40, NULL, NULL, NULL),
(41, 1, 41, NULL, NULL, NULL),
(42, 1, 42, NULL, NULL, NULL),
(43, 1, 43, NULL, NULL, NULL),
(44, 2, 35, NULL, NULL, NULL),
(45, 2, 5, NULL, NULL, NULL),
(46, 2, 6, NULL, NULL, NULL),
(47, 2, 8, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `role_user`
--

CREATE TABLE `role_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `role_user`
--

INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, NULL, NULL, NULL),
(2, 1, 2, NULL, NULL, NULL),
(3, 2, 3, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `sales`
--

CREATE TABLE `sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1710177648',
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `discount_on_coupon` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `debtor_paid_amount` double NOT NULL DEFAULT 0,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `out_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `sells`
--

CREATE TABLE `sells` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1709766452',
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `achats` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`achats`)),
  `shipping` double NOT NULL DEFAULT 0,
  `discount_on_total` varchar(255) NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `debtor_paid_amount` double NOT NULL DEFAULT 0,
  `tva` varchar(255) NOT NULL DEFAULT '0',
  `out_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `description` longtext NOT NULL,
  `short_des` text NOT NULL,
  `logo` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `settings`
--

INSERT INTO `settings` (`id`, `description`, `short_des`, `logo`, `photo`, `address`, `phone`, `email`, `created_at`, `updated_at`) VALUES
(1, 'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspiciatis unde sunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspiciatis unde omnis iste natus error sit voluptatem Excepteusunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspiciatis Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. sed ut perspi deserunt mollit anim id est laborum. sed ut perspi.', 'Praesent dapibus, neque id cursus ucibus, tortor neque egestas augue, magna eros eu erat. Aliquam erat volutpat. Nam dui mi, tincidunt quis, accumsan porttitor, facilisis luctus, metus.', 'images/logo/logo-dark.png', 'images/others/hero.jpg', 'NO. 342 - Lome Rue de 30 Aout, 012 Togo', '+228 00 11 22 33', 'raamshop@gmail.com', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `shippings`
--

CREATE TABLE `shippings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL DEFAULT '1711817707',
  `price` decimal(8,2) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `states`
--

INSERT INTO `states` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'DRAFT', NULL, NULL, NULL),
(2, 'SENT', NULL, NULL, NULL),
(3, 'ACCEPTED', NULL, NULL, NULL),
(4, 'REJECTED', NULL, NULL, NULL),
(5, 'PERFECT', NULL, NULL, NULL),
(6, 'SEALED', NULL, NULL, NULL),
(7, 'UNPAID', NULL, NULL, NULL),
(8, 'PAID', NULL, NULL, NULL),
(9, 'SEMIPAID', NULL, NULL, NULL),
(10, 'SUCCESS', NULL, NULL, NULL),
(11, 'WARNING', NULL, NULL, NULL),
(12, 'ERROR', NULL, NULL, NULL),
(13, 'CLOSED', NULL, NULL, NULL),
(14, 'CANCELED', NULL, NULL, NULL),
(15, 'PENDING', NULL, NULL, NULL),
(16, 'ADDED', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `stocks`
--

CREATE TABLE `stocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `wholesale_measure_id` bigint(20) UNSIGNED DEFAULT NULL,
  `wholesale_initial_quantity` double NOT NULL DEFAULT 0,
  `wholesale_unit_purchase_price` double NOT NULL DEFAULT 0,
  `in_detail_measure_id` bigint(20) UNSIGNED DEFAULT NULL,
  `in_detail_quantity` double NOT NULL DEFAULT 0,
  `in_detail_unit_purchase_price` double NOT NULL DEFAULT 0,
  `payment_method_id` bigint(20) UNSIGNED DEFAULT NULL,
  `credit_paid_amount` double NOT NULL DEFAULT 0,
  `total_purchase_cost` double NOT NULL DEFAULT 0,
  `receipt` varchar(255) DEFAULT NULL,
  `tva` varchar(255) DEFAULT NULL,
  `charge` double NOT NULL DEFAULT 0,
  `shipping` double NOT NULL DEFAULT 0,
  `discharge` double NOT NULL DEFAULT 0,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `stocks`
--

INSERT INTO `stocks` (`id`, `date`, `supplier_id`, `product_id`, `wholesale_measure_id`, `wholesale_initial_quantity`, `wholesale_unit_purchase_price`, `in_detail_measure_id`, `in_detail_quantity`, `in_detail_unit_purchase_price`, `payment_method_id`, `credit_paid_amount`, `total_purchase_cost`, `receipt`, `tva`, `charge`, `shipping`, `discharge`, `state_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, '2024-04-17', 1, 6, 5, 300, 11000, 5, 300, 11000, 1, 0, 3340000, 'storage/receipt/INV_STOCK-1713353984.png', NULL, 15000, 10000, 15000, 1, '2024-04-17 09:39:45', '2024-04-17 09:39:45', NULL),
(2, '2024-04-09', 2, 13, 4, 4, 80000, 7, 30, 20000, 5, 0, 2425000, '', NULL, 5000, 15000, 5000, 1, '2024-04-17 11:54:45', '2024-04-17 11:54:45', NULL),
(3, '2024-03-12', 2, 11, 5, 60, 20000, 5, 60, 20000, 4, 0, 1250000, '', NULL, 0, 50000, 0, 6, '2024-04-17 13:17:45', '2024-04-17 16:41:48', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `suppliers`
--

CREATE TABLE `suppliers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phones` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `particular_name` varchar(255) DEFAULT NULL,
  `particular_phones` varchar(255) DEFAULT NULL,
  `particular_email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `phones`, `email`, `address`, `particular_name`, `particular_phones`, `particular_email`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Seven Young', '+3376695278', 'orders@sevenyoung.com', '9907 rue des petits champs, Paris, France', 'Emilie Dequenes', '+336521479663', 'emiliedequenes@gmail.com', '2024-04-17 09:11:03', '2024-04-17 09:21:05', NULL),
(2, 'YesStyle', '+85227860817', 'support@yesstyle.com', 'KC100, 5/F, 100 Kwai Cheong Rd, Kwai Chung, Hong Kong', 'Joshua K. Lau', '+85221289810', 'joshualau@gmail.com', '2024-04-17 09:19:36', '2024-04-17 09:19:36', NULL),
(3, 'Facetheory Skincare', '+4408963089', 'help@facetheory.com', 'Unit E, Old Colliery Way Sheffield S20 1DJ United Kingom', 'Jane Young', '+4485120713', 'janeyoung@yahoo.com', '2024-04-17 09:26:29', '2024-04-17 09:26:29', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `supplier_credits`
--

CREATE TABLE `supplier_credits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `supplier_id` bigint(20) UNSIGNED DEFAULT NULL,
  `stock_id` bigint(20) UNSIGNED DEFAULT NULL,
  `paid_amount` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `tables`
--

CREATE TABLE `tables` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `tables`
--

INSERT INTO `tables` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'categories', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(2, 'category_product', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(3, 'commands', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(4, 'companies', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(5, 'customers', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(6, 'debtors', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(7, 'expense_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(8, 'expenses', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(9, 'failed_jobs', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(10, 'inventories', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(11, 'invoices', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(12, 'logs', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(13, 'migrations', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(14, 'movement_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(15, 'navigator_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(16, 'navigators', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(17, 'out_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(18, 'password_reset_tokens', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(19, 'password_resets', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(20, 'payment_methods', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(21, 'permission_role', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(22, 'permission_table', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(23, 'permissions', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(24, 'personal_access_tokens', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(25, 'printer_types', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(26, 'printers', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(27, 'product_details', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(28, 'product_unit_measure', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(29, 'products', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(30, 'reports', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(31, 'return_stocks', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(32, 'role_table', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(33, 'role_user', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(34, 'roles', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(35, 'sells', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(36, 'settings', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(37, 'states', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(38, 'stocks', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(39, 'supplier_credits', '2024-03-06 22:08:05', '2024-03-06 22:08:05', NULL),
(40, 'suppliers', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL),
(41, 'tables', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL),
(42, 'unit_measures', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL),
(43, 'users', '2024-03-06 22:08:06', '2024-03-06 22:08:06', NULL),
(44, 'brands', '2024-04-22 18:11:24', '2024-04-22 18:11:24', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `unit_measures`
--

CREATE TABLE `unit_measures` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `unit_measures`
--

INSERT INTO `unit_measures` (`id`, `unit`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Carton', NULL, NULL, NULL),
(2, 'Sac', NULL, NULL, NULL),
(3, 'Sachet', NULL, NULL, NULL),
(4, 'Casier', NULL, NULL, NULL),
(5, 'Bouteille', NULL, NULL, NULL),
(6, 'Rouleau', NULL, NULL, NULL),
(7, 'Piece', NULL, NULL, NULL),
(8, 'Bidon', NULL, NULL, NULL),
(9, 'Plaquette', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `products_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`products_json`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `cart_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `wishlists`
--

INSERT INTO `wishlists` (`id`, `user_id`, `products_json`, `created_at`, `updated_at`, `deleted_at`, `cart_id`) VALUES
(1, 4, '[]', '2024-04-13 08:18:52', '2024-04-20 07:50:59', NULL, 1);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_user_id_foreign` (`user_id`);

--
-- Index pour la table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `category_product`
--
ALTER TABLE `category_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_product_category_id_foreign` (`category_id`),
  ADD KEY `category_product_product_id_foreign` (`product_id`);

--
-- Index pour la table `commands`
--
ALTER TABLE `commands`
  ADD PRIMARY KEY (`id`),
  ADD KEY `commands_supplier_id_foreign` (`supplier_id`),
  ADD KEY `commands_payment_method_id_foreign` (`payment_method_id`),
  ADD KEY `commands_state_id_foreign` (`state_id`);

--
-- Index pour la table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `coupons_code_unique` (`code`);

--
-- Index pour la table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `debtors`
--
ALTER TABLE `debtors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `debtors_customer_id_foreign` (`customer_id`),
  ADD KEY `debtors_sell_id_foreign` (`sell_id`);

--
-- Index pour la table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expenses_expense_type_id_foreign` (`expense_type_id`);

--
-- Index pour la table `expense_types`
--
ALTER TABLE `expense_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Index pour la table `inventories`
--
ALTER TABLE `inventories`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logs_user_id_foreign` (`user_id`);

--
-- Index pour la table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `movement_types`
--
ALTER TABLE `movement_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `navigators`
--
ALTER TABLE `navigators`
  ADD PRIMARY KEY (`id`),
  ADD KEY `navigators_navigator_type_id_foreign` (`navigator_type_id`);

--
-- Index pour la table `navigator_types`
--
ALTER TABLE `navigator_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_order_number_unique` (`order_number`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_cart_id_foreign` (`cart_id`),
  ADD KEY `orders_payment_method_id_foreign` (`payment_method_id`),
  ADD KEY `orders_shipping_id_foreign` (`shipping_id`);

--
-- Index pour la table `out_types`
--
ALTER TABLE `out_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_role_permission_id_foreign` (`permission_id`),
  ADD KEY `permission_role_role_id_foreign` (`role_id`);

--
-- Index pour la table `permission_role_resources`
--
ALTER TABLE `permission_role_resources`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_role_resources_permission_id_foreign` (`permission_id`),
  ADD KEY `permission_role_resources_role_id_foreign` (`role_id`);

--
-- Index pour la table `permission_table`
--
ALTER TABLE `permission_table`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_table_permission_id_foreign` (`permission_id`),
  ADD KEY `permission_table_table_id_foreign` (`table_id`),
  ADD KEY `permission_table_role_id_foreign` (`role_id`);

--
-- Index pour la table `printers`
--
ALTER TABLE `printers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `printers_printer_type_id_foreign` (`printer_type_id`);

--
-- Index pour la table `printer_types`
--
ALTER TABLE `printer_types`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_brand_id_foreign` (`brand_id`);

--
-- Index pour la table `product_details`
--
ALTER TABLE `product_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_details_product_id_foreign` (`product_id`);

--
-- Index pour la table `product_unit_measure`
--
ALTER TABLE `product_unit_measure`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_unit_measure_product_id_foreign` (`product_id`),
  ADD KEY `product_unit_measure_unit_measure_id_foreign` (`unit_measure_id`);

--
-- Index pour la table `reports`
--
ALTER TABLE `reports`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `return_stocks`
--
ALTER TABLE `return_stocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `return_stocks_supplier_id_foreign` (`supplier_id`),
  ADD KEY `return_stocks_payment_method_id_foreign` (`payment_method_id`),
  ADD KEY `return_stocks_state_id_foreign` (`state_id`);

--
-- Index pour la table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `role_table`
--
ALTER TABLE `role_table`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_table_role_id_foreign` (`role_id`),
  ADD KEY `role_table_table_id_foreign` (`table_id`);

--
-- Index pour la table `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_user_role_id_foreign` (`role_id`),
  ADD KEY `role_user_user_id_foreign` (`user_id`);

--
-- Index pour la table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sales_customer_id_foreign` (`customer_id`),
  ADD KEY `sales_order_id_foreign` (`order_id`),
  ADD KEY `sales_out_type_id_foreign` (`out_type_id`),
  ADD KEY `sales_state_id_foreign` (`state_id`);

--
-- Index pour la table `sells`
--
ALTER TABLE `sells`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sells_customer_id_foreign` (`customer_id`),
  ADD KEY `sells_payment_method_id_foreign` (`payment_method_id`),
  ADD KEY `sells_out_type_id_foreign` (`out_type_id`),
  ADD KEY `sells_state_id_foreign` (`state_id`);

--
-- Index pour la table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `shippings`
--
ALTER TABLE `shippings`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `stocks`
--
ALTER TABLE `stocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stocks_supplier_id_foreign` (`supplier_id`),
  ADD KEY `stocks_product_id_foreign` (`product_id`),
  ADD KEY `stocks_wholesale_measure_id_foreign` (`wholesale_measure_id`),
  ADD KEY `stocks_in_detail_measure_id_foreign` (`in_detail_measure_id`),
  ADD KEY `stocks_payment_method_id_foreign` (`payment_method_id`),
  ADD KEY `stocks_state_id_foreign` (`state_id`);

--
-- Index pour la table `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `supplier_credits`
--
ALTER TABLE `supplier_credits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supplier_credits_supplier_id_foreign` (`supplier_id`),
  ADD KEY `supplier_credits_stock_id_foreign` (`stock_id`);

--
-- Index pour la table `tables`
--
ALTER TABLE `tables`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `unit_measures`
--
ALTER TABLE `unit_measures`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `wishlists`
--
ALTER TABLE `wishlists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wishlists_user_id_foreign` (`user_id`),
  ADD KEY `wishlists_cart_id_foreign` (`cart_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `carts`
--
ALTER TABLE `carts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `category_product`
--
ALTER TABLE `category_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT pour la table `commands`
--
ALTER TABLE `commands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `debtors`
--
ALTER TABLE `debtors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `expense_types`
--
ALTER TABLE `expense_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `inventories`
--
ALTER TABLE `inventories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `logs`
--
ALTER TABLE `logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT pour la table `movement_types`
--
ALTER TABLE `movement_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `navigators`
--
ALTER TABLE `navigators`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `navigator_types`
--
ALTER TABLE `navigator_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `out_types`
--
ALTER TABLE `out_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `permission_role`
--
ALTER TABLE `permission_role`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `permission_role_resources`
--
ALTER TABLE `permission_role_resources`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `permission_table`
--
ALTER TABLE `permission_table`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=365;

--
-- AUTO_INCREMENT pour la table `printers`
--
ALTER TABLE `printers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `printer_types`
--
ALTER TABLE `printer_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT pour la table `product_details`
--
ALTER TABLE `product_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `product_unit_measure`
--
ALTER TABLE `product_unit_measure`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT pour la table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `return_stocks`
--
ALTER TABLE `return_stocks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `role_table`
--
ALTER TABLE `role_table`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT pour la table `role_user`
--
ALTER TABLE `role_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `sales`
--
ALTER TABLE `sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `sells`
--
ALTER TABLE `sells`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `shippings`
--
ALTER TABLE `shippings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `states`
--
ALTER TABLE `states`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT pour la table `stocks`
--
ALTER TABLE `stocks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `supplier_credits`
--
ALTER TABLE `supplier_credits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `tables`
--
ALTER TABLE `tables`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT pour la table `unit_measures`
--
ALTER TABLE `unit_measures`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `wishlists`
--
ALTER TABLE `wishlists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `carts`
--
ALTER TABLE `carts`
  ADD CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `category_product`
--
ALTER TABLE `category_product`
  ADD CONSTRAINT `category_product_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `category_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Contraintes pour la table `commands`
--
ALTER TABLE `commands`
  ADD CONSTRAINT `commands_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  ADD CONSTRAINT `commands_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`),
  ADD CONSTRAINT `commands_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`);

--
-- Contraintes pour la table `debtors`
--
ALTER TABLE `debtors`
  ADD CONSTRAINT `debtors_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `debtors_sell_id_foreign` FOREIGN KEY (`sell_id`) REFERENCES `sells` (`id`);

--
-- Contraintes pour la table `expenses`
--
ALTER TABLE `expenses`
  ADD CONSTRAINT `expenses_expense_type_id_foreign` FOREIGN KEY (`expense_type_id`) REFERENCES `expense_types` (`id`);

--
-- Contraintes pour la table `logs`
--
ALTER TABLE `logs`
  ADD CONSTRAINT `logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `navigators`
--
ALTER TABLE `navigators`
  ADD CONSTRAINT `navigators_navigator_type_id_foreign` FOREIGN KEY (`navigator_type_id`) REFERENCES `navigator_types` (`id`);

--
-- Contraintes pour la table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`),
  ADD CONSTRAINT `orders_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Contraintes pour la table `permission_role_resources`
--
ALTER TABLE `permission_role_resources`
  ADD CONSTRAINT `permission_role_resources_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  ADD CONSTRAINT `permission_role_resources_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Contraintes pour la table `permission_table`
--
ALTER TABLE `permission_table`
  ADD CONSTRAINT `permission_table_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
  ADD CONSTRAINT `permission_table_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  ADD CONSTRAINT `permission_table_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`);

--
-- Contraintes pour la table `printers`
--
ALTER TABLE `printers`
  ADD CONSTRAINT `printers_printer_type_id_foreign` FOREIGN KEY (`printer_type_id`) REFERENCES `printer_types` (`id`);

--
-- Contraintes pour la table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `product_details`
--
ALTER TABLE `product_details`
  ADD CONSTRAINT `product_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Contraintes pour la table `product_unit_measure`
--
ALTER TABLE `product_unit_measure`
  ADD CONSTRAINT `product_unit_measure_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `product_unit_measure_unit_measure_id_foreign` FOREIGN KEY (`unit_measure_id`) REFERENCES `unit_measures` (`id`);

--
-- Contraintes pour la table `return_stocks`
--
ALTER TABLE `return_stocks`
  ADD CONSTRAINT `return_stocks_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  ADD CONSTRAINT `return_stocks_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`),
  ADD CONSTRAINT `return_stocks_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`);

--
-- Contraintes pour la table `role_table`
--
ALTER TABLE `role_table`
  ADD CONSTRAINT `role_table_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  ADD CONSTRAINT `role_table_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`);

--
-- Contraintes pour la table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `sales`
--
ALTER TABLE `sales`
  ADD CONSTRAINT `sales_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `sales_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `sales_out_type_id_foreign` FOREIGN KEY (`out_type_id`) REFERENCES `out_types` (`id`),
  ADD CONSTRAINT `sales_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`);

--
-- Contraintes pour la table `sells`
--
ALTER TABLE `sells`
  ADD CONSTRAINT `sells_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `sells_out_type_id_foreign` FOREIGN KEY (`out_type_id`) REFERENCES `out_types` (`id`),
  ADD CONSTRAINT `sells_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  ADD CONSTRAINT `sells_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`);

--
-- Contraintes pour la table `stocks`
--
ALTER TABLE `stocks`
  ADD CONSTRAINT `stocks_in_detail_measure_id_foreign` FOREIGN KEY (`in_detail_measure_id`) REFERENCES `unit_measures` (`id`),
  ADD CONSTRAINT `stocks_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`),
  ADD CONSTRAINT `stocks_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `stocks_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`),
  ADD CONSTRAINT `stocks_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`),
  ADD CONSTRAINT `stocks_wholesale_measure_id_foreign` FOREIGN KEY (`wholesale_measure_id`) REFERENCES `unit_measures` (`id`);

--
-- Contraintes pour la table `supplier_credits`
--
ALTER TABLE `supplier_credits`
  ADD CONSTRAINT `supplier_credits_stock_id_foreign` FOREIGN KEY (`stock_id`) REFERENCES `stocks` (`id`),
  ADD CONSTRAINT `supplier_credits_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`);

--
-- Contraintes pour la table `wishlists`
--
ALTER TABLE `wishlists`
  ADD CONSTRAINT `wishlists_cart_id_foreign` FOREIGN KEY (`cart_id`) REFERENCES `carts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

