-- Table structure for table `bl_shop`
--

CREATE TABLE `bl_shop` (
  `id_shop` int(11) NOT NULL AUTO_INCREMENT,
  `id_shop_group` int(11) NOT NULL,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_category` int(11) NOT NULL,
  `theme_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_shop`),
  KEY `IDX_C91E8637F5C9E40` (`id_shop_group`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bl_shop`
--

INSERT INTO `bl_shop` VALUES (1,1,'Boutique Lac Copping','',2,'ledonia-child',1,0);

--
-- Table structure for table `bl_shop_group`
--

CREATE TABLE `bl_shop_group` (
  `id_shop_group` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `share_customer` tinyint(1) NOT NULL,
  `share_order` tinyint(1) NOT NULL,
  `share_stock` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_shop_group`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bl_shop_group`
--

INSERT INTO `bl_shop_group` VALUES (1,'Default','',0,0,0,1,0);

--
-- Table structure for table `bl_shop_url`
--

CREATE TABLE `bl_shop_url` (
  `id_shop_url` int(11) NOT NULL AUTO_INCREMENT,
  `id_shop` int(11) NOT NULL,
  `domain` varchar(150) NOT NULL,
  `domain_ssl` varchar(150) NOT NULL,
  `physical_uri` varchar(64) NOT NULL,
  `virtual_uri` varchar(64) NOT NULL,
  `main` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_shop_url`),
  KEY `IDX_7A0BEB5274A50A0` (`id_shop`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_shop_url`
--

INSERT INTO `bl_shop_url` VALUES (1,1,'boutiquelaccopping.webtotal.ca','boutiquelaccopping.webtotal.ca','/','',1,1);

--
-- Table structure for table `bl_smarty_cache`
--

CREATE TABLE `bl_smarty_cache` (
  `id_smarty_cache` char(40) NOT NULL,
  `name` char(40) NOT NULL,
  `cache_id` varchar(254) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `content` longtext NOT NULL,
  PRIMARY KEY (`id_smarty_cache`),
  KEY `name` (`name`),
  KEY `cache_id` (`cache_id`),
  KEY `modified` (`modified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_smarty_cache`
--


--
-- Table structure for table `bl_smarty_last_flush`
--

CREATE TABLE `bl_smarty_last_flush` (
  `type` enum('compile','template') NOT NULL,
  `last_flush` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_smarty_last_flush`
--


--
-- Table structure for table `bl_smarty_lazy_cache`
--

CREATE TABLE `bl_smarty_lazy_cache` (
  `template_hash` varchar(32) NOT NULL DEFAULT '',
  `cache_id` varchar(191) NOT NULL DEFAULT '',
  `compile_id` varchar(32) NOT NULL DEFAULT '',
  `filepath` varchar(255) NOT NULL DEFAULT '',
  `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`template_hash`,`cache_id`,`compile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_smarty_lazy_cache`
--


--
-- Table structure for table `bl_specific_price`
--

CREATE TABLE `bl_specific_price` (
  `id_specific_price` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_specific_price_rule` int(11) unsigned NOT NULL,
  `id_cart` int(11) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',
  `id_shop_group` int(11) unsigned NOT NULL,
  `id_currency` int(10) unsigned NOT NULL,
  `id_country` int(10) unsigned NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  `id_customer` int(10) unsigned NOT NULL,
  `id_product_attribute` int(10) unsigned NOT NULL,
  `price` decimal(20,6) NOT NULL,
  `from_quantity` mediumint(8) unsigned NOT NULL,
  `reduction` decimal(20,6) NOT NULL,
  `reduction_tax` tinyint(1) NOT NULL DEFAULT '1',
  `reduction_type` enum('amount','percentage') NOT NULL,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  PRIMARY KEY (`id_specific_price`),
  UNIQUE KEY `id_product_2` (`id_product`,`id_product_attribute`,`id_customer`,`id_cart`,`from`,`to`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`id_specific_price_rule`),
  KEY `id_product` (`id_product`,`id_shop`,`id_currency`,`id_country`,`id_group`,`id_customer`,`from_quantity`,`from`,`to`),
  KEY `from_quantity` (`from_quantity`),
  KEY `id_specific_price_rule` (`id_specific_price_rule`),
  KEY `id_cart` (`id_cart`),
  KEY `id_product_attribute` (`id_product_attribute`),
  KEY `id_shop` (`id_shop`),
  KEY `id_customer` (`id_customer`),
  KEY `from` (`from`),
  KEY `to` (`to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_specific_price`
--


--
-- Table structure for table `bl_specific_price_priority`
--

CREATE TABLE `bl_specific_price_priority` (
  `id_specific_price_priority` int(11) NOT NULL AUTO_INCREMENT,
  `id_product` int(11) NOT NULL,
  `priority` varchar(80) NOT NULL,
  PRIMARY KEY (`id_specific_price_priority`,`id_product`),
  UNIQUE KEY `id_product` (`id_product`)
) ENGINE=InnoDB AUTO_INCREMENT=1175 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_specific_price_priority`
--

INSERT INTO `bl_specific_price_priority` VALUES (1,20,'id_group;id_currency;id_country;id_shop'),(28,23,'id_group;id_currency;id_country;id_shop'),(42,25,'id_group;id_currency;id_country;id_shop'),(45,26,'id_group;id_currency;id_country;id_shop'),(47,27,'id_group;id_currency;id_country;id_shop'),(50,28,'id_group;id_currency;id_country;id_shop'),(52,29,'id_group;id_currency;id_country;id_shop'),(54,30,'id_group;id_currency;id_country;id_shop'),(56,31,'id_group;id_currency;id_country;id_shop'),(60,32,'id_group;id_currency;id_country;id_shop'),(70,33,'id_group;id_currency;id_country;id_shop'),(72,34,'id_group;id_currency;id_country;id_shop'),(77,35,'id_group;id_currency;id_country;id_shop'),(79,36,'id_group;id_currency;id_country;id_shop'),(80,37,'id_group;id_currency;id_country;id_shop'),(82,38,'id_group;id_currency;id_country;id_shop'),(83,39,'id_group;id_currency;id_country;id_shop'),(84,41,'id_group;id_currency;id_country;id_shop'),(86,42,'id_group;id_currency;id_country;id_shop'),(98,45,'id_group;id_currency;id_country;id_shop'),(101,46,'id_group;id_currency;id_country;id_shop'),(110,47,'id_group;id_currency;id_country;id_shop'),(112,48,'id_group;id_currency;id_country;id_shop'),(114,49,'id_group;id_currency;id_country;id_shop'),(126,50,'id_group;id_currency;id_country;id_shop'),(131,51,'id_group;id_currency;id_country;id_shop'),(133,52,'id_group;id_currency;id_country;id_shop'),(135,53,'id_group;id_currency;id_country;id_shop'),(136,54,'id_group;id_currency;id_country;id_shop'),(137,55,'id_group;id_currency;id_country;id_shop'),(138,56,'id_group;id_currency;id_country;id_shop'),(139,57,'id_group;id_currency;id_country;id_shop'),(140,58,'id_group;id_currency;id_country;id_shop'),(141,59,'id_group;id_currency;id_country;id_shop'),(142,60,'id_group;id_currency;id_country;id_shop'),(143,61,'id_group;id_currency;id_country;id_shop'),(144,62,'id_group;id_currency;id_country;id_shop'),(145,63,'id_group;id_currency;id_country;id_shop'),(146,64,'id_group;id_currency;id_country;id_shop'),(161,66,'id_group;id_currency;id_country;id_shop'),(163,67,'id_group;id_currency;id_country;id_shop'),(164,68,'id_group;id_currency;id_country;id_shop'),(165,69,'id_group;id_currency;id_country;id_shop'),(167,70,'id_group;id_currency;id_country;id_shop'),(168,71,'id_group;id_currency;id_country;id_shop'),(187,73,'id_group;id_currency;id_country;id_shop'),(188,74,'id_group;id_currency;id_country;id_shop'),(191,75,'id_group;id_currency;id_country;id_shop'),(192,76,'id_group;id_currency;id_country;id_shop'),(195,77,'id_group;id_currency;id_country;id_shop'),(204,78,'id_group;id_currency;id_country;id_shop'),(221,79,'id_group;id_currency;id_country;id_shop'),(224,81,'id_group;id_currency;id_country;id_shop'),(225,82,'id_group;id_currency;id_country;id_shop'),(226,83,'id_group;id_currency;id_country;id_shop'),(227,84,'id_group;id_currency;id_country;id_shop'),(228,85,'id_group;id_currency;id_country;id_shop'),(230,86,'id_group;id_currency;id_country;id_shop'),(235,87,'id_group;id_currency;id_country;id_shop'),(244,89,'id_group;id_currency;id_country;id_shop'),(245,90,'id_group;id_currency;id_country;id_shop'),(246,91,'id_group;id_currency;id_country;id_shop'),(248,92,'id_group;id_currency;id_country;id_shop'),(250,93,'id_group;id_currency;id_country;id_shop'),(251,95,'id_group;id_currency;id_country;id_shop'),(252,96,'id_group;id_currency;id_country;id_shop'),(253,97,'id_group;id_currency;id_country;id_shop'),(254,98,'id_group;id_currency;id_country;id_shop'),(257,99,'id_group;id_currency;id_country;id_shop'),(258,100,'id_group;id_currency;id_country;id_shop'),(259,101,'id_group;id_currency;id_country;id_shop'),(260,102,'id_group;id_currency;id_country;id_shop'),(262,103,'id_group;id_currency;id_country;id_shop'),(263,104,'id_group;id_currency;id_country;id_shop'),(264,105,'id_group;id_currency;id_country;id_shop'),(268,106,'id_group;id_currency;id_country;id_shop'),(269,107,'id_group;id_currency;id_country;id_shop'),(272,108,'id_group;id_currency;id_country;id_shop'),(273,111,'id_group;id_currency;id_country;id_shop'),(274,113,'id_group;id_currency;id_country;id_shop'),(275,114,'id_group;id_currency;id_country;id_shop'),(276,115,'id_group;id_currency;id_country;id_shop'),(277,116,'id_group;id_currency;id_country;id_shop'),(278,117,'id_group;id_currency;id_country;id_shop'),(279,118,'id_group;id_currency;id_country;id_shop'),(280,119,'id_group;id_currency;id_country;id_shop'),(281,120,'id_group;id_currency;id_country;id_shop'),(287,121,'id_group;id_currency;id_country;id_shop'),(289,122,'id_group;id_currency;id_country;id_shop'),(290,123,'id_group;id_currency;id_country;id_shop'),(292,124,'id_group;id_currency;id_country;id_shop'),(293,125,'id_group;id_currency;id_country;id_shop'),(294,126,'id_group;id_currency;id_country;id_shop'),(295,127,'id_group;id_currency;id_country;id_shop'),(296,128,'id_group;id_currency;id_country;id_shop'),(304,129,'id_group;id_currency;id_country;id_shop'),(305,130,'id_group;id_currency;id_country;id_shop'),(306,131,'id_group;id_currency;id_country;id_shop'),(307,132,'id_group;id_currency;id_country;id_shop'),(309,133,'id_group;id_currency;id_country;id_shop'),(310,134,'id_group;id_currency;id_country;id_shop'),(312,135,'id_group;id_currency;id_country;id_shop'),(314,137,'id_group;id_currency;id_country;id_shop'),(315,136,'id_group;id_currency;id_country;id_shop'),(317,138,'id_group;id_currency;id_country;id_shop'),(319,139,'id_group;id_currency;id_country;id_shop'),(321,141,'id_group;id_currency;id_country;id_shop'),(323,143,'id_group;id_currency;id_country;id_shop'),(324,144,'id_group;id_currency;id_country;id_shop'),(326,145,'id_group;id_currency;id_country;id_shop'),(328,140,'id_group;id_currency;id_country;id_shop'),(329,147,'id_group;id_currency;id_country;id_shop'),(344,148,'id_group;id_currency;id_country;id_shop'),(345,150,'id_group;id_currency;id_country;id_shop'),(350,151,'id_group;id_currency;id_country;id_shop'),(351,152,'id_group;id_currency;id_country;id_shop'),(353,153,'id_group;id_currency;id_country;id_shop'),(354,154,'id_group;id_currency;id_country;id_shop'),(355,155,'id_group;id_currency;id_country;id_shop'),(356,156,'id_group;id_currency;id_country;id_shop'),(358,157,'id_group;id_currency;id_country;id_shop'),(359,158,'id_group;id_currency;id_country;id_shop'),(361,159,'id_group;id_currency;id_country;id_shop'),(363,160,'id_group;id_currency;id_country;id_shop'),(364,161,'id_group;id_currency;id_country;id_shop'),(365,162,'id_group;id_currency;id_country;id_shop'),(366,163,'id_group;id_currency;id_country;id_shop'),(368,164,'id_group;id_currency;id_country;id_shop'),(369,165,'id_group;id_currency;id_country;id_shop'),(371,166,'id_group;id_currency;id_country;id_shop'),(372,167,'id_group;id_currency;id_country;id_shop'),(373,168,'id_group;id_currency;id_country;id_shop'),(375,169,'id_group;id_currency;id_country;id_shop'),(376,170,'id_group;id_currency;id_country;id_shop'),(378,171,'id_group;id_currency;id_country;id_shop'),(379,172,'id_group;id_currency;id_country;id_shop'),(380,173,'id_group;id_currency;id_country;id_shop'),(385,174,'id_group;id_currency;id_country;id_shop'),(387,175,'id_group;id_currency;id_country;id_shop'),(388,176,'id_group;id_currency;id_country;id_shop'),(389,177,'id_group;id_currency;id_country;id_shop'),(390,178,'id_group;id_currency;id_country;id_shop'),(392,179,'id_group;id_currency;id_country;id_shop'),(393,180,'id_group;id_currency;id_country;id_shop'),(394,181,'id_group;id_currency;id_country;id_shop'),(395,182,'id_group;id_currency;id_country;id_shop'),(396,183,'id_group;id_currency;id_country;id_shop'),(398,184,'id_group;id_currency;id_country;id_shop'),(401,185,'id_group;id_currency;id_country;id_shop'),(403,186,'id_group;id_currency;id_country;id_shop'),(404,187,'id_group;id_currency;id_country;id_shop'),(405,188,'id_group;id_currency;id_country;id_shop'),(406,189,'id_group;id_currency;id_country;id_shop'),(407,190,'id_group;id_currency;id_country;id_shop'),(408,191,'id_group;id_currency;id_country;id_shop'),(410,192,'id_group;id_currency;id_country;id_shop'),(412,193,'id_group;id_currency;id_country;id_shop'),(413,194,'id_group;id_currency;id_country;id_shop'),(415,195,'id_group;id_currency;id_country;id_shop'),(416,196,'id_group;id_currency;id_country;id_shop'),(418,197,'id_group;id_currency;id_country;id_shop'),(420,198,'id_group;id_currency;id_country;id_shop'),(421,199,'id_group;id_currency;id_country;id_shop'),(423,200,'id_group;id_currency;id_country;id_shop'),(425,201,'id_group;id_currency;id_country;id_shop'),(427,202,'id_group;id_currency;id_country;id_shop'),(429,203,'id_group;id_currency;id_country;id_shop'),(430,204,'id_group;id_currency;id_country;id_shop'),(431,205,'id_group;id_currency;id_country;id_shop'),(439,207,'id_group;id_currency;id_country;id_shop'),(440,208,'id_group;id_currency;id_country;id_shop'),(441,209,'id_group;id_currency;id_country;id_shop'),(445,211,'id_group;id_currency;id_country;id_shop'),(447,212,'id_group;id_currency;id_country;id_shop'),(448,213,'id_group;id_currency;id_country;id_shop'),(450,215,'id_group;id_currency;id_country;id_shop'),(451,216,'id_group;id_currency;id_country;id_shop'),(453,217,'id_group;id_currency;id_country;id_shop'),(454,218,'id_group;id_currency;id_country;id_shop'),(455,219,'id_group;id_currency;id_country;id_shop'),(456,220,'id_group;id_currency;id_country;id_shop'),(458,221,'id_group;id_currency;id_country;id_shop'),(459,222,'id_group;id_currency;id_country;id_shop'),(460,223,'id_group;id_currency;id_country;id_shop'),(461,224,'id_group;id_currency;id_country;id_shop'),(464,225,'id_group;id_currency;id_country;id_shop'),(466,227,'id_group;id_currency;id_country;id_shop'),(467,228,'id_group;id_currency;id_country;id_shop'),(468,229,'id_group;id_currency;id_country;id_shop'),(469,230,'id_group;id_currency;id_country;id_shop'),(471,231,'id_group;id_currency;id_country;id_shop'),(472,232,'id_group;id_currency;id_country;id_shop'),(473,233,'id_group;id_currency;id_country;id_shop'),(474,234,'id_group;id_currency;id_country;id_shop'),(475,235,'id_group;id_currency;id_country;id_shop'),(476,236,'id_group;id_currency;id_country;id_shop'),(477,237,'id_group;id_currency;id_country;id_shop'),(478,238,'id_group;id_currency;id_country;id_shop'),(480,239,'id_group;id_currency;id_country;id_shop'),(481,240,'id_group;id_currency;id_country;id_shop'),(482,241,'id_group;id_currency;id_country;id_shop'),(483,242,'id_group;id_currency;id_country;id_shop'),(484,243,'id_group;id_currency;id_country;id_shop'),(485,244,'id_group;id_currency;id_country;id_shop'),(494,245,'id_group;id_currency;id_country;id_shop'),(495,246,'id_group;id_currency;id_country;id_shop'),(496,247,'id_group;id_currency;id_country;id_shop'),(497,249,'id_group;id_currency;id_country;id_shop'),(500,250,'id_group;id_currency;id_country;id_shop'),(502,251,'id_group;id_currency;id_country;id_shop'),(504,252,'id_group;id_currency;id_country;id_shop'),(512,254,'id_group;id_currency;id_country;id_shop'),(515,255,'id_group;id_currency;id_country;id_shop'),(518,256,'id_group;id_currency;id_country;id_shop'),(520,257,'id_group;id_currency;id_country;id_shop'),(521,258,'id_group;id_currency;id_country;id_shop'),(675,259,'id_group;id_currency;id_country;id_shop'),(685,260,'id_group;id_currency;id_country;id_shop'),(693,261,'id_group;id_currency;id_country;id_shop'),(694,262,'id_group;id_currency;id_country;id_shop'),(699,263,'id_group;id_currency;id_country;id_shop'),(708,264,'id_group;id_currency;id_country;id_shop'),(719,265,'id_group;id_currency;id_country;id_shop'),(722,266,'id_group;id_currency;id_country;id_shop'),(724,267,'id_group;id_currency;id_country;id_shop'),(729,268,'id_group;id_currency;id_country;id_shop'),(738,269,'id_group;id_currency;id_country;id_shop'),(744,270,'id_group;id_currency;id_country;id_shop'),(754,271,'id_group;id_currency;id_country;id_shop'),(765,272,'id_group;id_currency;id_country;id_shop'),(771,273,'id_group;id_currency;id_country;id_shop'),(782,274,'id_group;id_currency;id_country;id_shop'),(786,275,'id_group;id_currency;id_country;id_shop'),(794,276,'id_group;id_currency;id_country;id_shop'),(802,277,'id_group;id_currency;id_country;id_shop'),(810,278,'id_group;id_currency;id_country;id_shop'),(814,279,'id_group;id_currency;id_country;id_shop'),(816,281,'id_group;id_currency;id_country;id_shop'),(822,282,'id_group;id_currency;id_country;id_shop'),(830,283,'id_group;id_currency;id_country;id_shop'),(842,284,'id_group;id_currency;id_country;id_shop'),(845,285,'id_group;id_currency;id_country;id_shop'),(852,286,'id_group;id_currency;id_country;id_shop'),(854,287,'id_group;id_currency;id_country;id_shop'),(855,288,'id_group;id_currency;id_country;id_shop'),(860,289,'id_group;id_currency;id_country;id_shop'),(865,290,'id_group;id_currency;id_country;id_shop'),(872,291,'id_group;id_currency;id_country;id_shop'),(874,292,'id_group;id_currency;id_country;id_shop'),(882,293,'id_group;id_currency;id_country;id_shop'),(884,294,'id_group;id_currency;id_country;id_shop'),(886,295,'id_group;id_currency;id_country;id_shop'),(888,296,'id_group;id_currency;id_country;id_shop'),(890,297,'id_group;id_currency;id_country;id_shop'),(892,298,'id_group;id_currency;id_country;id_shop'),(894,299,'id_group;id_currency;id_country;id_shop'),(897,300,'id_group;id_currency;id_country;id_shop'),(899,301,'id_group;id_currency;id_country;id_shop'),(901,302,'id_group;id_currency;id_country;id_shop'),(902,303,'id_group;id_currency;id_country;id_shop'),(903,304,'id_group;id_currency;id_country;id_shop'),(904,305,'id_group;id_currency;id_country;id_shop'),(905,306,'id_group;id_currency;id_country;id_shop'),(907,307,'id_group;id_currency;id_country;id_shop'),(908,308,'id_group;id_currency;id_country;id_shop'),(909,309,'id_group;id_currency;id_country;id_shop'),(910,310,'id_group;id_currency;id_country;id_shop'),(911,311,'id_group;id_currency;id_country;id_shop'),(913,312,'id_group;id_currency;id_country;id_shop'),(914,313,'id_group;id_currency;id_country;id_shop'),(915,314,'id_group;id_currency;id_country;id_shop'),(916,315,'id_group;id_currency;id_country;id_shop'),(917,316,'id_group;id_currency;id_country;id_shop'),(918,317,'id_group;id_currency;id_country;id_shop'),(919,319,'id_group;id_currency;id_country;id_shop'),(920,321,'id_group;id_currency;id_country;id_shop'),(930,324,'id_group;id_currency;id_country;id_shop'),(931,325,'id_group;id_currency;id_country;id_shop'),(935,326,'id_group;id_currency;id_country;id_shop'),(938,327,'id_group;id_currency;id_country;id_shop'),(941,328,'id_group;id_currency;id_country;id_shop'),(942,329,'id_group;id_currency;id_country;id_shop'),(943,330,'id_group;id_currency;id_country;id_shop'),(946,331,'id_group;id_currency;id_country;id_shop'),(949,332,'id_group;id_currency;id_country;id_shop'),(950,333,'id_group;id_currency;id_country;id_shop'),(956,334,'id_group;id_currency;id_country;id_shop'),(959,335,'id_group;id_currency;id_country;id_shop'),(960,336,'id_group;id_currency;id_country;id_shop'),(961,337,'id_group;id_currency;id_country;id_shop'),(962,338,'id_group;id_currency;id_country;id_shop'),(963,339,'id_group;id_currency;id_country;id_shop'),(965,341,'id_group;id_currency;id_country;id_shop'),(967,342,'id_group;id_currency;id_country;id_shop'),(969,343,'id_group;id_currency;id_country;id_shop'),(970,344,'id_group;id_currency;id_country;id_shop'),(971,345,'id_group;id_currency;id_country;id_shop'),(972,346,'id_group;id_currency;id_country;id_shop'),(973,347,'id_group;id_currency;id_country;id_shop'),(974,348,'id_group;id_currency;id_country;id_shop'),(975,349,'id_group;id_currency;id_country;id_shop'),(976,350,'id_group;id_currency;id_country;id_shop'),(977,351,'id_group;id_currency;id_country;id_shop'),(979,352,'id_group;id_currency;id_country;id_shop'),(980,353,'id_group;id_currency;id_country;id_shop'),(982,354,'id_group;id_currency;id_country;id_shop'),(983,355,'id_group;id_currency;id_country;id_shop'),(984,356,'id_group;id_currency;id_country;id_shop'),(985,357,'id_group;id_currency;id_country;id_shop'),(986,358,'id_group;id_currency;id_country;id_shop'),(987,359,'id_group;id_currency;id_country;id_shop'),(989,360,'id_group;id_currency;id_country;id_shop'),(990,361,'id_group;id_currency;id_country;id_shop'),(991,362,'id_group;id_currency;id_country;id_shop'),(992,363,'id_group;id_currency;id_country;id_shop'),(993,364,'id_group;id_currency;id_country;id_shop'),(994,365,'id_group;id_currency;id_country;id_shop'),(995,366,'id_group;id_currency;id_country;id_shop'),(996,367,'id_group;id_currency;id_country;id_shop'),(998,368,'id_group;id_currency;id_country;id_shop'),(1000,369,'id_group;id_currency;id_country;id_shop'),(1002,370,'id_group;id_currency;id_country;id_shop'),(1004,371,'id_group;id_currency;id_country;id_shop'),(1005,372,'id_group;id_currency;id_country;id_shop'),(1006,373,'id_group;id_currency;id_country;id_shop'),(1007,374,'id_group;id_currency;id_country;id_shop'),(1009,375,'id_group;id_currency;id_country;id_shop'),(1010,376,'id_group;id_currency;id_country;id_shop'),(1012,377,'id_group;id_currency;id_country;id_shop'),(1014,378,'id_group;id_currency;id_country;id_shop'),(1015,379,'id_group;id_currency;id_country;id_shop'),(1016,380,'id_group;id_currency;id_country;id_shop'),(1018,381,'id_group;id_currency;id_country;id_shop'),(1022,382,'id_group;id_currency;id_country;id_shop'),(1024,383,'id_group;id_currency;id_country;id_shop'),(1025,384,'id_group;id_currency;id_country;id_shop'),(1026,385,'id_group;id_currency;id_country;id_shop'),(1027,387,'id_group;id_currency;id_country;id_shop'),(1028,388,'id_group;id_currency;id_country;id_shop'),(1029,389,'id_group;id_currency;id_country;id_shop'),(1030,390,'id_group;id_currency;id_country;id_shop'),(1032,391,'id_group;id_currency;id_country;id_shop'),(1034,392,'id_group;id_currency;id_country;id_shop'),(1035,393,'id_group;id_currency;id_country;id_shop'),(1036,394,'id_group;id_currency;id_country;id_shop'),(1037,395,'id_group;id_currency;id_country;id_shop'),(1039,396,'id_group;id_currency;id_country;id_shop'),(1041,397,'id_group;id_currency;id_country;id_shop'),(1042,398,'id_group;id_currency;id_country;id_shop'),(1044,399,'id_group;id_currency;id_country;id_shop'),(1046,400,'id_group;id_currency;id_country;id_shop'),(1052,401,'id_group;id_currency;id_country;id_shop'),(1053,402,'id_group;id_currency;id_country;id_shop'),(1054,403,'id_group;id_currency;id_country;id_shop'),(1055,404,'id_group;id_currency;id_country;id_shop'),(1059,405,'id_group;id_currency;id_country;id_shop'),(1071,406,'id_group;id_currency;id_country;id_shop'),(1073,407,'id_group;id_currency;id_country;id_shop'),(1075,408,'id_group;id_currency;id_country;id_shop'),(1078,409,'id_group;id_currency;id_country;id_shop'),(1079,410,'id_group;id_currency;id_country;id_shop'),(1080,411,'id_group;id_currency;id_country;id_shop'),(1081,412,'id_group;id_currency;id_country;id_shop'),(1095,413,'id_group;id_currency;id_country;id_shop'),(1096,414,'id_group;id_currency;id_country;id_shop'),(1097,415,'id_group;id_currency;id_country;id_shop'),(1100,416,'id_group;id_currency;id_country;id_shop'),(1104,417,'id_group;id_currency;id_country;id_shop'),(1106,418,'id_group;id_currency;id_country;id_shop'),(1109,419,'id_group;id_currency;id_country;id_shop'),(1114,420,'id_group;id_currency;id_country;id_shop'),(1117,421,'id_group;id_currency;id_country;id_shop'),(1120,422,'id_group;id_currency;id_country;id_shop'),(1122,423,'id_group;id_currency;id_country;id_shop'),(1124,424,'id_group;id_currency;id_country;id_shop'),(1126,425,'id_group;id_currency;id_country;id_shop'),(1127,426,'id_group;id_currency;id_country;id_shop'),(1128,427,'id_group;id_currency;id_country;id_shop'),(1129,428,'id_group;id_currency;id_country;id_shop'),(1130,429,'id_group;id_currency;id_country;id_shop'),(1131,430,'id_group;id_currency;id_country;id_shop');

--
-- Table structure for table `bl_specific_price_rule`
--

CREATE TABLE `bl_specific_price_rule` (
  `id_specific_price_rule` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',
  `id_currency` int(10) unsigned NOT NULL,
  `id_country` int(10) unsigned NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  `from_quantity` mediumint(8) unsigned NOT NULL,
  `price` decimal(20,6) DEFAULT NULL,
  `reduction` decimal(20,6) NOT NULL,
  `reduction_tax` tinyint(1) NOT NULL DEFAULT '1',
  `reduction_type` enum('amount','percentage') NOT NULL,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  PRIMARY KEY (`id_specific_price_rule`),
  KEY `id_product` (`id_shop`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`from`,`to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_specific_price_rule`
--


--
-- Table structure for table `bl_specific_price_rule_condition`
--

CREATE TABLE `bl_specific_price_rule_condition` (
  `id_specific_price_rule_condition` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_specific_price_rule_condition_group` int(11) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id_specific_price_rule_condition`),
  KEY `id_specific_price_rule_condition_group` (`id_specific_price_rule_condition_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_specific_price_rule_condition`
--


--
-- Table structure for table `bl_specific_price_rule_condition_group`
--

CREATE TABLE `bl_specific_price_rule_condition_group` (
  `id_specific_price_rule_condition_group` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_specific_price_rule` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_specific_price_rule_condition_group`,`id_specific_price_rule`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_specific_price_rule_condition_group`
--


--
-- Table structure for table `bl_state`
--

CREATE TABLE `bl_state` (
  `id_state` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(11) unsigned NOT NULL,
  `id_zone` int(11) unsigned NOT NULL,
  `name` varchar(80) NOT NULL,
  `iso_code` varchar(7) NOT NULL,
  `tax_behavior` smallint(1) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_state`),
  KEY `id_country` (`id_country`),
  KEY `name` (`name`),
  KEY `id_zone` (`id_zone`)
) ENGINE=InnoDB AUTO_INCREMENT=353 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_state`
--

INSERT INTO `bl_state` VALUES (1,21,2,'AA','AA',0,1),(2,21,2,'AE','AE',0,1),(3,21,2,'AP','AP',0,1),(4,21,2,'Alabama','AL',0,1),(5,21,2,'Alaska','AK',0,1),(6,21,2,'Arizona','AZ',0,1),(7,21,2,'Arkansas','AR',0,1),(8,21,2,'California','CA',0,1),(9,21,2,'Colorado','CO',0,1),(10,21,2,'Connecticut','CT',0,1),(11,21,2,'Delaware','DE',0,1),(12,21,2,'Florida','FL',0,1),(13,21,2,'Georgia','GA',0,1),(14,21,2,'Hawaii','HI',0,1),(15,21,2,'Idaho','ID',0,1),(16,21,2,'Illinois','IL',0,1),(17,21,2,'Indiana','IN',0,1),(18,21,2,'Iowa','IA',0,1),(19,21,2,'Kansas','KS',0,1),(20,21,2,'Kentucky','KY',0,1),(21,21,2,'Louisiana','LA',0,1),(22,21,2,'Maine','ME',0,1),(23,21,2,'Maryland','MD',0,1),(24,21,2,'Massachusetts','MA',0,1),(25,21,2,'Michigan','MI',0,1),(26,21,2,'Minnesota','MN',0,1),(27,21,2,'Mississippi','MS',0,1),(28,21,2,'Missouri','MO',0,1),(29,21,2,'Montana','MT',0,1),(30,21,2,'Nebraska','NE',0,1),(31,21,2,'Nevada','NV',0,1),(32,21,2,'New Hampshire','NH',0,1),(33,21,2,'New Jersey','NJ',0,1),(34,21,2,'New Mexico','NM',0,1),(35,21,2,'New York','NY',0,1),(36,21,2,'North Carolina','NC',0,1),(37,21,2,'North Dakota','ND',0,1),(38,21,2,'Ohio','OH',0,1),(39,21,2,'Oklahoma','OK',0,1),(40,21,2,'Oregon','OR',0,1),(41,21,2,'Pennsylvania','PA',0,1),(42,21,2,'Rhode Island','RI',0,1),(43,21,2,'South Carolina','SC',0,1),(44,21,2,'South Dakota','SD',0,1),(45,21,2,'Tennessee','TN',0,1),(46,21,2,'Texas','TX',0,1),(47,21,2,'Utah','UT',0,1),(48,21,2,'Vermont','VT',0,1),(49,21,2,'Virginia','VA',0,1),(50,21,2,'Washington','WA',0,1),(51,21,2,'West Virginia','WV',0,1),(52,21,2,'Wisconsin','WI',0,1),(53,21,2,'Wyoming','WY',0,1),(54,21,2,'Puerto Rico','PR',0,1),(55,21,2,'US Virgin Islands','VI',0,1),(56,21,2,'District of Columbia','DC',0,1),(57,144,2,'Aguascalientes','AGU',0,1),(58,144,2,'Baja California','BCN',0,1),(59,144,2,'Baja California Sur','BCS',0,1),(60,144,2,'Campeche','CAM',0,1),(61,144,2,'Chiapas','CHP',0,1),(62,144,2,'Chihuahua','CHH',0,1),(63,144,2,'Ciudad de México','CMX',0,1),(64,144,2,'Coahuila','COA',0,1),(65,144,2,'Colima','COL',0,1),(66,144,2,'Durango','DUR',0,1),(67,144,2,'Guanajuato','GUA',0,1),(68,144,2,'Guerrero','GRO',0,1),(69,144,2,'Hidalgo','HID',0,1),(70,144,2,'Jalisco','JAL',0,1),(71,144,2,'Estado de México','MEX',0,1),(72,144,2,'Michoacán','MIC',0,1),(73,144,2,'Morelos','MOR',0,1),(74,144,2,'Nayarit','NAY',0,1),(75,144,2,'Nuevo León','NLE',0,1),(76,144,2,'Oaxaca','OAX',0,1),(77,144,2,'Puebla','PUE',0,1),(78,144,2,'Querétaro','QUE',0,1),(79,144,2,'Quintana Roo','ROO',0,1),(80,144,2,'San Luis Potosí','SLP',0,1),(81,144,2,'Sinaloa','SIN',0,1),(82,144,2,'Sonora','SON',0,1),(83,144,2,'Tabasco','TAB',0,1),(84,144,2,'Tamaulipas','TAM',0,1),(85,144,2,'Tlaxcala','TLA',0,1),(86,144,2,'Veracruz','VER',0,1),(87,144,2,'Yucatán','YUC',0,1),(88,144,2,'Zacatecas','ZAC',0,1),(89,4,2,'Ontario','ON',0,1),(90,4,2,'Quebec','QC',0,1),(91,4,2,'British Columbia','BC',0,1),(92,4,2,'Alberta','AB',0,1),(93,4,2,'Manitoba','MB',0,1),(94,4,2,'Saskatchewan','SK',0,1),(95,4,2,'Nova Scotia','NS',0,1),(96,4,2,'New Brunswick','NB',0,1),(97,4,2,'Newfoundland and Labrador','NL',0,1),(98,4,2,'Prince Edward Island','PE',0,1),(99,4,2,'Northwest Territories','NT',0,1),(100,4,2,'Yukon','YT',0,1),(101,4,2,'Nunavut','NU',0,1),(102,44,6,'Buenos Aires','B',0,1),(103,44,6,'Catamarca','K',0,1),(104,44,6,'Chaco','H',0,1),(105,44,6,'Chubut','U',0,1),(106,44,6,'Ciudad de Buenos Aires','C',0,1),(107,44,6,'Córdoba','X',0,1),(108,44,6,'Corrientes','W',0,1),(109,44,6,'Entre Ríos','E',0,1),(110,44,6,'Formosa','P',0,1),(111,44,6,'Jujuy','Y',0,1),(112,44,6,'La Pampa','L',0,1),(113,44,6,'La Rioja','F',0,1),(114,44,6,'Mendoza','M',0,1),(115,44,6,'Misiones','N',0,1),(116,44,6,'Neuquén','Q',0,1),(117,44,6,'Río Negro','R',0,1),(118,44,6,'Salta','A',0,1),(119,44,6,'San Juan','J',0,1),(120,44,6,'San Luis','D',0,1),(121,44,6,'Santa Cruz','Z',0,1),(122,44,6,'Santa Fe','S',0,1),(123,44,6,'Santiago del Estero','G',0,1),(124,44,6,'Tierra del Fuego','V',0,1),(125,44,6,'Tucumán','T',0,1),(126,10,1,'Agrigento','AG',0,1),(127,10,1,'Alessandria','AL',0,1),(128,10,1,'Ancona','AN',0,1),(129,10,1,'Aosta','AO',0,1),(130,10,1,'Arezzo','AR',0,1),(131,10,1,'Ascoli Piceno','AP',0,1),(132,10,1,'Asti','AT',0,1),(133,10,1,'Avellino','AV',0,1),(134,10,1,'Bari','BA',0,1),(135,10,1,'Barletta-Andria-Trani','BT',0,1),(136,10,1,'Belluno','BL',0,1),(137,10,1,'Benevento','BN',0,1),(138,10,1,'Bergamo','BG',0,1),(139,10,1,'Biella','BI',0,1),(140,10,1,'Bologna','BO',0,1),(141,10,1,'Bolzano','BZ',0,1),(142,10,1,'Brescia','BS',0,1),(143,10,1,'Brindisi','BR',0,1),(144,10,1,'Cagliari','CA',0,1),(145,10,1,'Caltanissetta','CL',0,1),(146,10,1,'Campobasso','CB',0,1),(147,10,1,'Carbonia-Iglesias','CI',0,1),(148,10,1,'Caserta','CE',0,1),(149,10,1,'Catania','CT',0,1),(150,10,1,'Catanzaro','CZ',0,1),(151,10,1,'Chieti','CH',0,1),(152,10,1,'Como','CO',0,1),(153,10,1,'Cosenza','CS',0,1),(154,10,1,'Cremona','CR',0,1),(155,10,1,'Crotone','KR',0,1),(156,10,1,'Cuneo','CN',0,1),(157,10,1,'Enna','EN',0,1),(158,10,1,'Fermo','FM',0,1),(159,10,1,'Ferrara','FE',0,1),(160,10,1,'Firenze','FI',0,1),(161,10,1,'Foggia','FG',0,1),(162,10,1,'Forlì-Cesena','FC',0,1),(163,10,1,'Frosinone','FR',0,1),(164,10,1,'Genova','GE',0,1),(165,10,1,'Gorizia','GO',0,1),(166,10,1,'Grosseto','GR',0,1),(167,10,1,'Imperia','IM',0,1),(168,10,1,'Isernia','IS',0,1),(169,10,1,'L\'Aquila','AQ',0,1),(170,10,1,'La Spezia','SP',0,1),(171,10,1,'Latina','LT',0,1),(172,10,1,'Lecce','LE',0,1),(173,10,1,'Lecco','LC',0,1),(174,10,1,'Livorno','LI',0,1),(175,10,1,'Lodi','LO',0,1),(176,10,1,'Lucca','LU',0,1),(177,10,1,'Macerata','MC',0,1),(178,10,1,'Mantova','MN',0,1),(179,10,1,'Massa','MS',0,1),(180,10,1,'Matera','MT',0,1),(181,10,1,'Medio Campidano','VS',0,1),(182,10,1,'Messina','ME',0,1),(183,10,1,'Milano','MI',0,1),(184,10,1,'Modena','MO',0,1),(185,10,1,'Monza e della Brianza','MB',0,1),(186,10,1,'Napoli','NA',0,1),(187,10,1,'Novara','NO',0,1),(188,10,1,'Nuoro','NU',0,1),(189,10,1,'Ogliastra','OG',0,1),(190,10,1,'Olbia-Tempio','OT',0,1),(191,10,1,'Oristano','OR',0,1),(192,10,1,'Padova','PD',0,1),(193,10,1,'Palermo','PA',0,1),(194,10,1,'Parma','PR',0,1),(195,10,1,'Pavia','PV',0,1),(196,10,1,'Perugia','PG',0,1),(197,10,1,'Pesaro-Urbino','PU',0,1),(198,10,1,'Pescara','PE',0,1),(199,10,1,'Piacenza','PC',0,1),(200,10,1,'Pisa','PI',0,1),(201,10,1,'Pistoia','PT',0,1),(202,10,1,'Pordenone','PN',0,1),(203,10,1,'Potenza','PZ',0,1),(204,10,1,'Prato','PO',0,1),(205,10,1,'Ragusa','RG',0,1),(206,10,1,'Ravenna','RA',0,1),(207,10,1,'Reggio Calabria','RC',0,1),(208,10,1,'Reggio Emilia','RE',0,1),(209,10,1,'Rieti','RI',0,1),(210,10,1,'Rimini','RN',0,1),(211,10,1,'Roma','RM',0,1),(212,10,1,'Rovigo','RO',0,1),(213,10,1,'Salerno','SA',0,1),(214,10,1,'Sassari','SS',0,1),(215,10,1,'Savona','SV',0,1),(216,10,1,'Siena','SI',0,1),(217,10,1,'Siracusa','SR',0,1),(218,10,1,'Sondrio','SO',0,1),(219,10,1,'Taranto','TA',0,1),(220,10,1,'Teramo','TE',0,1),(221,10,1,'Terni','TR',0,1),(222,10,1,'Torino','TO',0,1),(223,10,1,'Trapani','TP',0,1),(224,10,1,'Trento','TN',0,1),(225,10,1,'Treviso','TV',0,1),(226,10,1,'Trieste','TS',0,1),(227,10,1,'Udine','UD',0,1),(228,10,1,'Varese','VA',0,1),(229,10,1,'Venezia','VE',0,1),(230,10,1,'Verbano-Cusio-Ossola','VB',0,1),(231,10,1,'Vercelli','VC',0,1),(232,10,1,'Verona','VR',0,1),(233,10,1,'Vibo Valentia','VV',0,1),(234,10,1,'Vicenza','VI',0,1),(235,10,1,'Viterbo','VT',0,1),(236,110,3,'Aceh','ID-AC',0,1),(237,110,3,'Bali','ID-BA',0,1),(238,110,3,'Banten','ID-BT',0,1),(239,110,3,'Bengkulu','ID-BE',0,1),(240,110,3,'Gorontalo','ID-GO',0,1),(241,110,3,'Jakarta','ID-JK',0,1),(242,110,3,'Jambi','ID-JA',0,1),(243,110,3,'Jawa Barat','ID-JB',0,1),(244,110,3,'Jawa Tengah','ID-JT',0,1),(245,110,3,'Jawa Timur','ID-JI',0,1),(246,110,3,'Kalimantan Barat','ID-KB',0,1),(247,110,3,'Kalimantan Selatan','ID-KS',0,1),(248,110,3,'Kalimantan Tengah','ID-KT',0,1),(249,110,3,'Kalimantan Timur','ID-KI',0,1),(250,110,3,'Kalimantan Utara','ID-KU',0,1),(251,110,3,'Kepulauan Bangka Belitug','ID-BB',0,1),(252,110,3,'Kepulauan Riau','ID-KR',0,1),(253,110,3,'Lampung','ID-LA',0,1),(254,110,3,'Maluku','ID-MA',0,1),(255,110,3,'Maluku Utara','ID-MU',0,1),(256,110,3,'Nusa Tengara Barat','ID-NB',0,1),(257,110,3,'Nusa Tenggara Timur','ID-NT',0,1),(258,110,3,'Papua','ID-PA',0,1),(259,110,3,'Papua Barat','ID-PB',0,1),(260,110,3,'Riau','ID-RI',0,1),(261,110,3,'Sulawesi Barat','ID-SR',0,1),(262,110,3,'Sulawesi Selatan','ID-SN',0,1),(263,110,3,'Sulawesi Tengah','ID-ST',0,1),(264,110,3,'Sulawesi Tenggara','ID-SG',0,1),(265,110,3,'Sulawesi Utara','ID-SA',0,1),(266,110,3,'Sumatera Barat','ID-SB',0,1),(267,110,3,'Sumatera Selatan','ID-SS',0,1),(268,110,3,'Sumatera Utara','ID-SU',0,1),(269,110,3,'Yogyakarta','ID-YO',0,1),(270,11,3,'Aichi','23',0,1),(271,11,3,'Akita','05',0,1),(272,11,3,'Aomori','02',0,1),(273,11,3,'Chiba','12',0,1),(274,11,3,'Ehime','38',0,1),(275,11,3,'Fukui','18',0,1),(276,11,3,'Fukuoka','40',0,1),(277,11,3,'Fukushima','07',0,1),(278,11,3,'Gifu','21',0,1),(279,11,3,'Gunma','10',0,1),(280,11,3,'Hiroshima','34',0,1),(281,11,3,'Hokkaido','01',0,1),(282,11,3,'Hyogo','28',0,1),(283,11,3,'Ibaraki','08',0,1),(284,11,3,'Ishikawa','17',0,1),(285,11,3,'Iwate','03',0,1),(286,11,3,'Kagawa','37',0,1),(287,11,3,'Kagoshima','46',0,1),(288,11,3,'Kanagawa','14',0,1),(289,11,3,'Kochi','39',0,1),(290,11,3,'Kumamoto','43',0,1),(291,11,3,'Kyoto','26',0,1),(292,11,3,'Mie','24',0,1),(293,11,3,'Miyagi','04',0,1),(294,11,3,'Miyazaki','45',0,1),(295,11,3,'Nagano','20',0,1),(296,11,3,'Nagasaki','42',0,1),(297,11,3,'Nara','29',0,1),(298,11,3,'Niigata','15',0,1),(299,11,3,'Oita','44',0,1),(300,11,3,'Okayama','33',0,1),(301,11,3,'Okinawa','47',0,1),(302,11,3,'Osaka','27',0,1),(303,11,3,'Saga','41',0,1),(304,11,3,'Saitama','11',0,1),(305,11,3,'Shiga','25',0,1),(306,11,3,'Shimane','32',0,1),(307,11,3,'Shizuoka','22',0,1),(308,11,3,'Tochigi','09',0,1),(309,11,3,'Tokushima','36',0,1),(310,11,3,'Tokyo','13',0,1),(311,11,3,'Tottori','31',0,1),(312,11,3,'Toyama','16',0,1),(313,11,3,'Wakayama','30',0,1),(314,11,3,'Yamagata','06',0,1),(315,11,3,'Yamaguchi','35',0,1),(316,11,3,'Yamanashi','19',0,1),(317,24,5,'Australian Capital Territory','ACT',0,1),(318,24,5,'New South Wales','NSW',0,1),(319,24,5,'Northern Territory','NT',0,1),(320,24,5,'Queensland','QLD',0,1),(321,24,5,'South Australia','SA',0,1),(322,24,5,'Tasmania','TAS',0,1),(323,24,5,'Victoria','VIC',0,1),(324,24,5,'Western Australia','WA',0,1),(325,109,3,'Andhra Pradesh','AP',0,1),(326,109,3,'Arunachal Pradesh','AR',0,1),(327,109,3,'Assam','AS',0,1),(328,109,3,'Bihar','BR',0,1),(329,109,3,'Chhattisgarh','CT',0,1),(330,109,3,'Goa','GA',0,1),(331,109,3,'Gujarat','GJ',0,1),(332,109,3,'Haryana','HR',0,1),(333,109,3,'Himachal Pradesh','HP',0,1),(334,109,3,'Jharkhand','JH',0,1),(335,109,3,'Karnataka','KA',0,1),(336,109,3,'Kerala','KL',0,1),(337,109,3,'Madhya Pradesh','MP',0,1),(338,109,3,'Maharashtra','MH',0,1),(339,109,3,'Manipur','MN',0,1),(340,109,3,'Meghalaya','ML',0,1),(341,109,3,'Mizoram','MZ',0,1),(342,109,3,'Nagaland','NL',0,1),(343,109,3,'Odisha','OR',0,1),(344,109,3,'Punjab','PB',0,1),(345,109,3,'Rajasthan','RJ',0,1),(346,109,3,'Sikkim','SK',0,1),(347,109,3,'Tamil Nadu','TN',0,1),(348,109,3,'Telangana','TG',0,1),(349,109,3,'Tripura','TR',0,1),(350,109,3,'Uttar Pradesh','UP',0,1),(351,109,3,'Uttarakhand','UT',0,1),(352,109,3,'West Bengal','WB',0,1);

--
-- Table structure for table `bl_statssearch`
--

CREATE TABLE `bl_statssearch` (
  `id_statssearch` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned NOT NULL DEFAULT '1',
  `id_shop_group` int(10) unsigned NOT NULL DEFAULT '1',
  `keywords` varchar(255) NOT NULL,
  `results` int(6) NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_statssearch`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_statssearch`
--

INSERT INTO `bl_statssearch` VALUES (1,1,1,'1',0,'2023-05-03 03:33:45'),(2,1,1,'101',2,'2023-05-03 03:33:46'),(3,1,1,'101',2,'2023-05-03 03:33:46'),(4,1,1,'ca',0,'2023-05-03 11:23:16'),(5,1,1,'cam',5,'2023-05-03 11:23:16'),(6,1,1,'campin',1,'2023-05-03 11:23:17'),(7,1,1,'camping',1,'2023-05-03 11:23:18'),(8,1,1,'camping',1,'2023-05-03 11:23:18'),(9,1,1,'t',0,'2023-05-04 03:13:33'),(10,1,1,'ti',0,'2023-05-04 03:13:34'),(11,1,1,'tisa',7,'2023-05-04 03:13:34'),(12,1,1,'tisanne',5,'2023-05-04 03:13:35'),(13,1,1,'tisanne',5,'2023-05-04 03:13:35'),(14,1,1,'tisanne',5,'2023-05-04 03:14:28'),(15,1,1,'tisan',7,'2023-05-04 03:14:29'),(16,1,1,'tisane',7,'2023-05-04 03:14:30'),(17,1,1,'b',0,'2023-06-13 08:21:33'),(18,1,1,'bo',0,'2023-06-13 08:21:36'),(19,1,1,'boeu',15,'2023-06-13 08:21:37'),(20,1,1,'boeuB',15,'2023-06-13 08:21:50'),(21,1,1,'boeuBo',15,'2023-06-13 08:21:51'),(22,1,1,'boeuBoeu',25,'2023-06-13 08:21:51'),(23,1,1,'boeuBoeuf',15,'2023-06-13 08:21:52'),(24,1,1,'ftydytd',16,'2023-06-13 10:01:21'),(25,1,1,'ftydytdygy6ftf',0,'2023-06-13 10:01:22'),(26,1,1,'ftydytdygy6ft',0,'2023-06-13 10:01:45'),(27,1,1,'ftydytdygy6f',0,'2023-06-13 10:01:45'),(28,1,1,'f',0,'2023-06-13 10:01:46'),(29,1,1,'ea',0,'2023-06-13 10:01:50'),(30,1,1,'eau',72,'2023-06-13 10:01:51'),(31,1,1,'ea',0,'2023-06-13 10:02:08'),(32,1,1,'eay',72,'2023-06-13 10:02:09'),(33,1,1,'ea',0,'2023-06-13 10:02:09'),(34,1,1,'eau',72,'2023-06-13 10:02:10'),(35,1,1,'ea',0,'2023-06-13 10:02:28'),(36,1,1,'e',0,'2023-06-13 10:02:30'),(37,1,1,'ea',0,'2023-06-13 10:02:30'),(38,1,1,'eau',72,'2023-06-13 10:02:31'),(39,1,1,'e',0,'2023-06-13 10:02:33'),(40,1,1,'eau',72,'2023-06-13 10:02:34'),(41,1,1,'bo',0,'2023-06-13 10:46:38'),(42,1,1,'b',0,'2023-06-13 10:46:38'),(43,1,1,'boeuf',15,'2023-06-13 10:46:38'),(44,1,1,'boeu',15,'2023-06-13 10:46:39'),(45,1,1,'boe',15,'2023-06-13 10:46:39');

--
-- Table structure for table `bl_stock`
--

CREATE TABLE `bl_stock` (
  `id_stock` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_warehouse` int(11) unsigned NOT NULL,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `reference` varchar(64) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `isbn` varchar(32) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `mpn` varchar(40) DEFAULT NULL,
  `physical_quantity` int(11) unsigned NOT NULL,
  `usable_quantity` int(11) unsigned NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000',
  PRIMARY KEY (`id_stock`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_product` (`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_stock`
--


--
-- Table structure for table `bl_stock_available`
--

CREATE TABLE `bl_stock_available` (
  `id_stock_available` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  `id_shop_group` int(11) unsigned NOT NULL,
  `quantity` int(10) NOT NULL DEFAULT '0',
  `physical_quantity` int(11) NOT NULL DEFAULT '0',
  `reserved_quantity` int(11) NOT NULL DEFAULT '0',
  `depends_on_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `out_of_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `location` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_stock_available`),
  UNIQUE KEY `product_sqlstock` (`id_product`,`id_product_attribute`,`id_shop`,`id_shop_group`),
  KEY `id_shop` (`id_shop`),
  KEY `id_shop_group` (`id_shop_group`),
  KEY `id_product` (`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`)
) ENGINE=InnoDB AUTO_INCREMENT=656 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_stock_available`
--

INSERT INTO `bl_stock_available` VALUES (19,19,0,1,0,300,300,0,0,2,''),(59,11,0,1,0,0,0,0,0,0,''),(60,10,0,1,0,0,0,0,0,0,''),(61,9,0,1,0,0,0,0,0,0,''),(62,2,0,1,0,0,0,0,0,0,''),(63,1,0,1,0,0,0,0,0,0,''),(64,20,0,1,0,2,2,0,0,2,''),(65,20,40,1,0,1,1,0,0,2,''),(66,20,41,1,0,1,1,0,0,2,''),(71,23,0,1,0,2,2,0,0,2,''),(72,23,44,1,0,1,1,0,0,2,''),(73,23,45,1,0,1,1,0,0,2,''),(75,25,0,1,0,1,1,0,0,2,''),(76,26,0,1,0,1,1,0,0,2,''),(77,27,0,1,0,1,1,0,0,2,''),(78,28,0,1,0,1,1,0,0,2,''),(79,29,0,1,0,1,1,0,0,2,''),(80,30,0,1,0,1,1,0,0,2,''),(81,31,0,1,0,1,1,0,0,2,''),(82,32,0,1,0,1,1,0,0,2,''),(83,33,0,1,0,1,1,0,0,2,''),(84,34,0,1,0,1,1,0,0,2,''),(85,35,0,1,0,1,1,0,0,2,''),(86,36,0,1,0,1,1,0,0,2,''),(87,37,0,1,0,1,1,0,0,2,''),(88,38,0,1,0,1,1,0,0,2,''),(89,39,0,1,0,1,1,0,0,2,''),(91,41,0,1,0,1,1,0,0,2,''),(92,42,0,1,0,1,1,0,0,2,''),(95,45,0,1,0,1,1,0,0,2,''),(96,46,0,1,0,1,1,0,0,2,''),(97,47,0,1,0,1,1,0,0,2,''),(98,48,0,1,0,1,1,0,0,2,''),(99,49,0,1,0,1,1,0,0,2,''),(100,50,0,1,0,1,1,0,0,0,''),(101,51,0,1,0,1,1,0,0,2,''),(102,52,0,1,0,1,1,0,0,2,''),(103,53,0,1,0,1,1,0,0,2,''),(104,54,0,1,0,1,1,0,0,2,''),(105,55,0,1,0,1,1,0,0,2,''),(106,56,0,1,0,1,1,0,0,2,''),(107,57,0,1,0,1,1,0,0,2,''),(108,58,0,1,0,1,1,0,0,2,''),(109,59,0,1,0,1,1,0,0,2,''),(110,60,0,1,0,1,1,0,0,2,''),(111,61,0,1,0,1,1,0,0,0,''),(112,62,0,1,0,1,1,0,0,2,''),(113,63,0,1,0,1,1,0,0,2,''),(114,64,0,1,0,1,1,0,0,2,''),(116,66,0,1,0,1,1,0,0,2,''),(117,67,0,1,0,1,1,0,0,2,''),(118,68,0,1,0,1,1,0,0,2,''),(119,69,0,1,0,1,1,0,0,2,''),(120,70,0,1,0,1,1,0,0,2,''),(121,71,0,1,0,1,1,0,0,2,''),(123,73,0,1,0,1,1,0,0,2,''),(124,74,0,1,0,1,1,0,0,2,''),(125,75,0,1,0,1,1,0,0,2,''),(126,76,0,1,0,1,1,0,0,2,''),(127,77,0,1,0,1,1,0,0,2,''),(128,78,0,1,0,1,1,0,0,2,''),(129,79,0,1,0,1,1,0,0,2,''),(131,81,0,1,0,1,1,0,0,2,''),(132,82,0,1,0,1,1,0,0,2,''),(133,83,0,1,0,1,1,0,0,2,''),(134,84,0,1,0,1,1,0,0,2,''),(135,85,0,1,0,1,1,0,0,2,''),(136,86,0,1,0,1,1,0,0,2,''),(137,87,0,1,0,1,1,0,0,2,''),(139,89,0,1,0,1,1,0,0,2,''),(140,90,0,1,0,1,1,0,0,2,''),(141,91,0,1,0,1,1,0,0,2,''),(142,92,0,1,0,1,1,0,0,2,''),(143,93,0,1,0,1,1,0,0,2,''),(145,95,0,1,0,1,1,0,0,2,''),(146,96,0,1,0,1,1,0,0,2,''),(147,97,0,1,0,1,1,0,0,2,''),(148,98,0,1,0,1,1,0,0,2,''),(149,99,0,1,0,1,1,0,0,2,''),(150,100,0,1,0,1,1,0,0,2,''),(151,101,0,1,0,1,1,0,0,2,''),(152,102,0,1,0,1,1,0,0,2,''),(153,103,0,1,0,1,1,0,0,2,''),(154,104,0,1,0,1,1,0,0,2,''),(155,105,0,1,0,1,1,0,0,2,''),(156,106,0,1,0,1,1,0,0,2,''),(157,107,0,1,0,1,1,0,0,2,''),(158,108,0,1,0,1,1,0,0,2,''),(161,111,0,1,0,1,1,0,0,2,''),(163,113,0,1,0,1,1,0,0,2,''),(164,114,0,1,0,1,1,0,0,2,''),(165,115,0,1,0,1,1,0,0,2,''),(166,116,0,1,0,1,1,0,0,2,''),(167,117,0,1,0,1,1,0,0,2,''),(168,118,0,1,0,1,1,0,0,2,''),(169,119,0,1,0,1,1,0,0,2,''),(170,120,0,1,0,1,1,0,0,2,''),(171,121,0,1,0,1,1,0,0,2,''),(172,122,0,1,0,1,1,0,0,2,''),(173,123,0,1,0,1,1,0,0,2,''),(174,124,0,1,0,1,1,0,0,2,''),(175,125,0,1,0,1,1,0,0,2,''),(176,126,0,1,0,1,1,0,0,2,''),(177,127,0,1,0,1,1,0,0,2,''),(180,128,0,1,0,0,0,0,0,0,''),(181,129,0,1,0,1,1,0,0,2,''),(182,130,0,1,0,1,1,0,0,2,''),(183,131,0,1,0,1,1,0,0,2,''),(184,132,0,1,0,1,1,0,0,2,''),(185,133,0,1,0,1,1,0,0,2,''),(186,134,0,1,0,1,1,0,0,2,''),(187,135,0,1,0,1,1,0,0,2,''),(188,136,0,1,0,1,1,0,0,0,''),(189,137,0,1,0,1,1,0,0,2,''),(190,138,0,1,0,1,1,0,0,2,''),(191,139,0,1,0,1,1,0,0,2,''),(192,140,0,1,0,1,1,0,0,2,''),(193,141,0,1,0,1,1,0,0,2,''),(195,143,0,1,0,1,1,0,0,2,''),(196,144,0,1,0,1,1,0,0,2,''),(197,145,0,1,0,1,1,0,0,2,''),(199,147,0,1,0,1,1,0,0,2,''),(200,148,0,1,0,1,1,0,0,2,''),(202,150,0,1,0,1,1,0,0,2,''),(203,151,0,1,0,1,1,0,0,2,''),(204,152,0,1,0,1,1,0,0,0,''),(205,153,0,1,0,1,1,0,0,2,''),(206,154,0,1,0,1,1,0,0,2,''),(207,155,0,1,0,1,1,0,0,2,''),(208,156,0,1,0,1,1,0,0,2,''),(209,157,0,1,0,1,1,0,0,2,''),(210,158,0,1,0,1,1,0,0,2,''),(211,159,0,1,0,1,1,0,0,2,''),(212,160,0,1,0,1,1,0,0,2,''),(213,161,0,1,0,1,1,0,0,2,''),(214,162,0,1,0,1,1,0,0,2,''),(215,163,0,1,0,1,1,0,0,2,''),(216,164,0,1,0,1,1,0,0,2,''),(217,165,0,1,0,1,1,0,0,2,''),(218,166,0,1,0,1,1,0,0,2,''),(219,167,0,1,0,1,1,0,0,2,''),(220,168,0,1,0,1,1,0,0,2,''),(221,169,0,1,0,1,1,0,0,2,''),(222,170,0,1,0,1,1,0,0,2,''),(223,171,0,1,0,1,1,0,0,2,''),(224,172,0,1,0,1,1,0,0,2,''),(225,173,0,1,0,1,1,0,0,2,''),(226,174,0,1,0,1,1,0,0,2,''),(227,175,0,1,0,1,1,0,0,2,''),(228,176,0,1,0,1,1,0,0,2,''),(229,177,0,1,0,1,1,0,0,2,''),(230,178,0,1,0,1,1,0,0,2,''),(231,179,0,1,0,1,1,0,0,2,''),(232,180,0,1,0,1,1,0,0,2,''),(233,181,0,1,0,1,1,0,0,2,''),(234,182,0,1,0,1,1,0,0,2,''),(235,183,0,1,0,1,1,0,0,2,''),(236,184,0,1,0,1,1,0,0,2,''),(237,185,0,1,0,1,1,0,0,2,''),(238,186,0,1,0,1,1,0,0,2,''),(239,187,0,1,0,1,1,0,0,2,''),(240,188,0,1,0,1,1,0,0,2,''),(241,189,0,1,0,1,1,0,0,2,''),(242,190,0,1,0,1,1,0,0,2,''),(243,191,0,1,0,1,1,0,0,2,''),(244,192,0,1,0,1,1,0,0,2,''),(245,193,0,1,0,1,1,0,0,2,''),(246,194,0,1,0,1,1,0,0,2,''),(247,195,0,1,0,1,1,0,0,2,''),(248,196,0,1,0,1,1,0,0,2,''),(249,197,0,1,0,1,1,0,0,2,''),(250,198,0,1,0,1,1,0,0,2,''),(251,199,0,1,0,1,1,0,0,0,''),(252,200,0,1,0,1,1,0,0,2,''),(253,201,0,1,0,1,1,0,0,2,''),(254,202,0,1,0,1,1,0,0,2,''),(255,203,0,1,0,1,1,0,0,2,''),(256,204,0,1,0,1,1,0,0,2,''),(257,205,0,1,0,1,1,0,0,2,''),(259,207,0,1,0,1,1,0,0,2,''),(260,208,0,1,0,1,1,0,0,2,''),(261,209,0,1,0,1,1,0,0,2,''),(263,211,0,1,0,1,1,0,0,2,''),(264,212,0,1,0,1,1,0,0,2,''),(265,213,0,1,0,1,1,0,0,2,''),(267,215,0,1,0,1,1,0,0,2,''),(268,216,0,1,0,1,1,0,0,2,''),(269,217,0,1,0,1,1,0,0,2,''),(270,218,0,1,0,1,1,0,0,2,''),(271,219,0,1,0,1,1,0,0,2,''),(272,220,0,1,0,1,1,0,0,2,''),(273,221,0,1,0,1,1,0,0,2,''),(274,222,0,1,0,1,1,0,0,2,''),(275,223,0,1,0,1,1,0,0,2,''),(276,224,0,1,0,1,1,0,0,2,''),(277,225,0,1,0,1,1,0,0,2,''),(279,227,0,1,0,1,1,0,0,2,''),(280,228,0,1,0,1,1,0,0,2,''),(281,229,0,1,0,1,1,0,0,2,''),(282,230,0,1,0,1,1,0,0,2,''),(283,231,0,1,0,1,1,0,0,2,''),(284,232,0,1,0,1,1,0,0,2,''),(285,233,0,1,0,1,1,0,0,2,''),(286,234,0,1,0,1,1,0,0,2,''),(287,235,0,1,0,1,1,0,0,2,''),(288,236,0,1,0,1,1,0,0,2,''),(289,237,0,1,0,1,1,0,0,2,''),(290,238,0,1,0,2,1,0,0,2,''),(291,239,0,1,0,5,1,0,0,2,''),(292,240,0,1,0,2,1,0,0,2,''),(293,241,0,1,0,5,1,0,0,2,''),(294,242,0,1,0,3,1,0,0,2,''),(295,243,0,1,0,4,1,0,0,2,''),(296,244,0,1,0,4,1,0,0,2,''),(297,245,0,1,0,5,1,0,0,1,''),(298,246,0,1,0,5,1,0,0,2,''),(299,247,0,1,0,5,1,0,0,2,''),(301,249,0,1,0,2,2,0,0,2,''),(307,251,0,1,0,2,2,0,0,2,''),(310,252,0,1,0,2,2,0,0,2,''),(314,254,0,1,0,2,2,0,0,2,''),(317,255,0,1,0,2,0,0,0,0,''),(329,238,64,1,0,1,0,0,0,2,''),(330,238,65,1,0,1,0,0,0,2,''),(331,239,66,1,0,1,0,0,0,2,''),(332,239,67,1,0,1,0,0,0,2,''),(333,239,68,1,0,1,0,0,0,2,''),(334,239,69,1,0,1,0,0,0,2,''),(335,239,70,1,0,1,0,0,0,2,''),(336,240,71,1,0,1,0,0,0,2,''),(337,240,72,1,0,1,0,0,0,2,''),(338,241,73,1,0,1,0,0,0,2,''),(339,241,74,1,0,1,0,0,0,2,''),(340,241,75,1,0,1,0,0,0,2,''),(342,241,77,1,0,1,0,0,0,2,''),(343,241,78,1,0,1,0,0,0,2,''),(344,0,79,1,0,0,0,0,0,0,''),(345,241,76,1,0,0,0,0,0,2,''),(346,0,80,1,0,0,0,0,0,0,''),(347,0,81,1,0,0,0,0,0,0,''),(348,242,82,1,0,1,0,0,0,2,''),(349,242,83,1,0,1,0,0,0,2,''),(351,0,85,1,0,0,0,0,0,0,''),(352,242,84,1,0,0,0,0,0,2,''),(353,242,86,1,0,1,0,0,0,2,''),(354,0,87,1,0,0,0,0,0,0,''),(355,0,88,1,0,0,0,0,0,0,''),(356,0,89,1,0,0,0,0,0,0,''),(357,0,90,1,0,0,0,0,0,0,''),(359,244,92,1,0,1,0,0,0,2,''),(360,244,93,1,0,1,0,0,0,2,''),(361,0,94,1,0,0,0,0,0,0,''),(362,244,91,1,0,0,0,0,0,2,''),(363,244,95,1,0,1,0,0,0,2,''),(364,244,97,1,0,1,0,0,0,2,''),(365,243,104,1,0,1,0,0,0,2,''),(366,243,105,1,0,1,0,0,0,2,''),(367,243,106,1,0,1,0,0,0,2,''),(368,243,107,1,0,1,0,0,0,2,''),(369,245,108,1,0,1,0,0,0,1,''),(370,245,109,1,0,1,0,0,0,1,''),(371,245,110,1,0,1,0,0,0,1,''),(372,245,111,1,0,1,0,0,0,1,''),(373,245,112,1,0,1,0,0,0,1,''),(374,246,113,1,0,1,0,0,0,2,''),(375,246,114,1,0,1,0,0,0,2,''),(376,246,115,1,0,1,0,0,0,2,''),(377,246,116,1,0,1,0,0,0,2,''),(379,246,118,1,0,1,0,0,0,2,''),(380,247,119,1,0,1,0,0,0,2,''),(381,247,120,1,0,1,0,0,0,2,''),(382,247,121,1,0,1,0,0,0,2,''),(383,247,122,1,0,1,0,0,0,2,''),(384,247,123,1,0,1,0,0,0,2,''),(386,259,0,1,0,22,0,0,0,2,''),(387,259,125,1,0,20,0,0,0,2,''),(388,259,126,1,0,2,0,0,0,2,''),(389,260,0,1,0,22,0,0,0,2,''),(390,260,127,1,0,20,0,0,0,2,''),(391,260,128,1,0,2,0,0,0,2,''),(392,261,0,1,0,2,0,0,0,2,''),(393,262,0,1,0,2,0,0,0,0,''),(396,263,0,1,0,22,0,0,0,2,''),(397,263,131,1,0,20,0,0,0,2,''),(398,263,132,1,0,2,0,0,0,2,''),(399,264,0,1,0,2,0,0,0,2,''),(400,265,0,1,0,2,0,0,0,2,''),(401,266,0,1,0,2,0,0,0,2,''),(402,267,0,1,0,22,0,0,0,2,''),(403,267,133,1,0,20,0,0,0,2,''),(404,267,134,1,0,2,0,0,0,2,''),(405,268,0,1,0,22,0,0,0,2,''),(406,268,135,1,0,20,0,0,0,2,''),(407,268,136,1,0,2,0,0,0,2,''),(408,269,0,1,0,15,0,0,0,2,''),(409,269,137,1,0,10,0,0,0,2,''),(410,269,138,1,0,5,0,0,0,2,''),(411,270,0,1,0,22,0,0,0,2,''),(412,270,139,1,0,20,0,0,0,2,''),(413,270,140,1,0,2,0,0,0,2,''),(414,271,0,1,0,22,0,0,0,2,''),(415,271,141,1,0,20,0,0,0,2,''),(416,271,142,1,0,2,0,0,0,2,''),(417,272,0,1,0,22,0,0,0,2,''),(418,272,143,1,0,20,0,0,0,2,''),(419,272,144,1,0,2,0,0,0,2,''),(420,273,0,1,0,6,0,0,0,2,''),(421,273,145,1,0,4,0,0,0,2,''),(422,273,146,1,0,2,0,0,0,2,''),(423,274,0,1,0,2,0,0,0,2,''),(424,275,0,1,0,22,0,0,0,2,''),(425,275,147,1,0,20,0,0,0,2,''),(426,275,148,1,0,2,0,0,0,2,''),(427,276,0,1,0,22,0,0,0,2,''),(428,276,149,1,0,20,0,0,0,2,''),(429,276,150,1,0,2,0,0,0,2,''),(430,277,0,1,0,22,0,0,0,2,''),(431,277,151,1,0,20,0,0,0,2,''),(432,277,152,1,0,2,0,0,0,2,''),(433,278,0,1,0,2,0,0,0,2,''),(434,279,0,1,0,2,0,0,0,2,''),(436,281,0,1,0,22,0,0,0,2,''),(437,281,153,1,0,20,0,0,0,2,''),(438,281,154,1,0,2,0,0,0,2,''),(439,282,0,1,0,22,0,0,0,2,''),(440,282,155,1,0,20,0,0,0,2,''),(441,282,156,1,0,2,0,0,0,2,''),(442,283,0,1,0,2,0,0,0,2,''),(443,250,0,1,0,0,0,0,0,0,''),(444,284,0,1,0,2,0,0,0,2,''),(445,285,0,1,0,2,0,0,0,0,''),(446,286,0,1,0,2,0,0,0,0,''),(447,287,0,1,0,2,0,0,0,0,''),(448,288,0,1,0,22,0,0,0,2,''),(449,288,157,1,0,20,0,0,0,2,''),(450,288,158,1,0,2,0,0,0,2,''),(451,289,0,1,0,22,0,0,0,2,''),(452,289,159,1,0,20,0,0,0,2,''),(453,289,160,1,0,2,0,0,0,2,''),(454,290,0,1,0,22,0,0,0,2,''),(455,290,161,1,0,20,0,0,0,2,''),(456,290,162,1,0,2,0,0,0,2,''),(457,291,0,1,0,2,0,0,0,2,''),(458,256,0,1,0,0,0,0,0,0,''),(459,257,0,1,0,0,0,0,0,0,''),(460,258,0,1,0,0,0,0,0,0,''),(461,292,0,1,0,22,0,0,0,2,''),(462,292,163,1,0,20,0,0,0,2,''),(463,292,164,1,0,2,0,0,0,2,''),(464,293,0,1,0,2,0,0,0,2,''),(465,294,0,1,0,2,0,0,0,2,''),(466,295,0,1,0,2,0,0,0,0,''),(467,296,0,1,0,12,0,0,0,2,''),(468,297,0,1,0,12,0,0,0,2,''),(469,298,0,1,0,12,0,0,0,2,''),(470,299,0,1,0,12,0,0,0,2,''),(471,300,0,1,0,12,0,0,0,2,''),(472,301,0,1,0,12,0,0,0,0,''),(473,302,0,1,0,12,0,0,0,2,''),(474,303,0,1,0,0,0,0,0,0,''),(475,304,0,1,0,0,0,0,0,0,''),(476,305,0,1,0,0,0,0,0,0,''),(477,306,0,1,0,0,0,0,0,0,''),(478,307,0,1,0,0,0,0,0,0,''),(479,308,0,1,0,0,0,0,0,0,''),(480,309,0,1,0,0,0,0,0,0,''),(481,310,0,1,0,0,0,0,0,0,''),(482,311,0,1,0,0,0,0,0,0,''),(483,312,0,1,0,0,0,0,0,0,''),(484,313,0,1,0,0,0,0,0,0,''),(485,314,0,1,0,0,0,0,0,0,''),(486,315,0,1,0,0,0,0,0,0,''),(487,316,0,1,0,0,0,0,0,0,''),(488,317,0,1,0,0,0,0,0,0,''),(490,319,0,1,0,0,0,0,0,0,''),(492,321,0,1,0,0,0,0,0,0,''),(495,324,0,1,0,0,0,0,0,0,''),(496,325,0,1,0,0,0,0,0,0,''),(497,325,165,1,0,0,0,0,0,0,''),(498,325,166,1,0,0,0,0,0,0,''),(499,326,0,1,0,0,0,0,0,0,''),(500,327,0,1,0,0,0,0,0,0,''),(501,328,0,1,0,0,0,0,0,0,''),(502,328,167,1,0,0,0,0,0,0,''),(503,328,168,1,0,0,0,0,0,0,''),(504,329,0,1,0,0,0,0,0,0,''),(505,330,0,1,0,0,0,0,0,0,''),(506,331,0,1,0,0,0,0,0,0,''),(507,332,0,1,0,0,0,0,0,0,''),(508,333,0,1,0,0,0,0,0,0,''),(509,334,0,1,0,0,0,0,0,0,''),(510,335,0,1,0,0,0,0,0,0,''),(511,336,0,1,0,0,0,0,0,0,''),(512,337,0,1,0,0,0,0,0,0,''),(513,338,0,1,0,0,0,0,0,0,''),(514,339,0,1,0,0,0,0,0,0,''),(516,341,0,1,0,0,0,0,0,0,''),(517,342,0,1,0,0,0,0,0,0,''),(518,343,0,1,0,0,0,0,0,0,''),(519,344,0,1,0,0,0,0,0,0,''),(520,345,0,1,0,0,0,0,0,0,''),(521,346,0,1,0,0,0,0,0,0,''),(522,347,0,1,0,0,0,0,0,0,''),(523,348,0,1,0,0,0,0,0,0,''),(524,349,0,1,0,0,0,0,0,0,''),(525,350,0,1,0,0,0,0,0,0,''),(526,351,0,1,0,0,0,0,0,0,''),(527,352,0,1,0,0,0,0,0,0,''),(528,353,0,1,0,0,0,0,0,0,''),(529,354,0,1,0,0,0,0,0,0,''),(530,355,0,1,0,0,0,0,0,0,''),(531,356,0,1,0,0,0,0,0,0,''),(532,357,0,1,0,0,0,0,0,0,''),(533,358,0,1,0,0,0,0,0,0,''),(534,359,0,1,0,0,0,0,0,0,''),(535,360,0,1,0,0,0,0,0,0,''),(536,361,0,1,0,0,0,0,0,0,''),(537,362,0,1,0,0,0,0,0,0,''),(538,363,0,1,0,0,0,0,0,0,''),(539,364,0,1,0,0,0,0,0,0,''),(540,365,0,1,0,0,0,0,0,0,''),(541,366,0,1,0,0,0,0,0,0,''),(542,367,0,1,0,0,0,0,0,0,''),(543,368,0,1,0,0,0,0,0,0,''),(544,369,0,1,0,0,0,0,0,0,''),(545,370,0,1,0,0,0,0,0,0,''),(546,371,0,1,0,0,0,0,0,0,''),(547,372,0,1,0,0,0,0,0,0,''),(548,373,0,1,0,0,0,0,0,0,''),(549,374,0,1,0,0,0,0,0,0,''),(550,375,0,1,0,0,0,0,0,0,''),(551,376,0,1,0,0,0,0,0,0,''),(552,377,0,1,0,0,0,0,0,0,''),(553,378,0,1,0,0,0,0,0,0,''),(554,379,0,1,0,0,0,0,0,0,''),(555,380,0,1,0,0,0,0,0,0,''),(556,381,0,1,0,0,0,0,0,0,''),(557,382,0,1,0,0,0,0,0,0,''),(558,383,0,1,0,0,0,0,0,0,''),(559,384,0,1,0,0,0,0,0,0,''),(560,385,0,1,0,0,0,0,0,0,''),(562,387,0,1,0,0,0,0,0,0,''),(563,388,0,1,0,0,0,0,0,0,''),(564,389,0,1,0,0,0,0,0,0,''),(565,390,0,1,0,0,0,0,0,0,''),(566,391,0,1,0,0,0,0,0,0,''),(567,392,0,1,0,0,0,0,0,0,''),(568,393,0,1,0,0,0,0,0,0,''),(569,394,0,1,0,0,0,0,0,0,''),(570,395,0,1,0,0,0,0,0,0,''),(571,396,0,1,0,0,0,0,0,0,''),(572,397,0,1,0,0,0,0,0,0,''),(573,398,0,1,0,0,0,0,0,0,''),(574,399,0,1,0,0,0,0,0,0,''),(577,400,0,1,0,0,0,0,0,0,''),(582,401,0,1,0,0,0,0,0,0,''),(583,402,0,1,0,0,0,0,0,0,''),(584,403,0,1,0,0,0,0,0,0,''),(587,405,0,1,0,13,0,0,0,0,''),(588,406,0,1,0,13,0,0,0,0,''),(590,407,0,1,0,16,0,0,0,0,''),(591,408,0,1,0,15,0,0,0,0,''),(592,409,0,1,0,14,0,0,0,0,''),(593,410,0,1,0,14,0,0,0,0,''),(594,411,0,1,0,13,0,0,0,0,''),(595,412,0,1,0,14,0,0,0,0,''),(596,412,177,1,0,12,0,0,0,0,''),(597,412,178,1,0,2,0,0,0,0,''),(598,411,179,1,0,12,0,0,0,0,''),(599,411,180,1,0,1,0,0,0,0,''),(600,410,181,1,0,12,0,0,0,0,''),(601,410,182,1,0,2,0,0,0,0,''),(602,409,183,1,0,12,0,0,0,0,''),(603,409,184,1,0,2,0,0,0,0,''),(604,408,185,1,0,14,0,0,0,0,''),(605,408,186,1,0,1,0,0,0,0,''),(606,407,187,1,0,12,0,0,0,0,''),(607,407,188,1,0,4,0,0,0,0,''),(608,406,189,1,0,12,0,0,0,0,''),(609,406,190,1,0,1,0,0,0,0,''),(610,405,191,1,0,1,0,0,0,0,''),(611,405,192,1,0,12,0,0,0,0,''),(612,413,0,1,0,14,0,0,0,0,''),(613,413,193,1,0,12,0,0,0,0,''),(614,413,194,1,0,2,0,0,0,0,''),(618,414,0,1,0,0,0,0,0,0,''),(619,415,0,1,0,14,0,0,0,0,''),(620,415,197,1,0,12,0,0,0,0,''),(621,415,198,1,0,2,0,0,0,0,''),(622,416,0,1,0,13,0,0,0,0,''),(623,417,0,1,0,13,0,0,0,0,''),(624,418,0,1,0,14,0,0,0,0,''),(625,418,199,1,0,12,0,0,0,0,''),(626,418,200,1,0,2,0,0,0,0,''),(627,419,0,1,0,13,0,0,0,0,''),(628,419,201,1,0,12,0,0,0,0,''),(629,419,202,1,0,1,0,0,0,0,''),(630,420,0,1,0,11,0,0,0,0,''),(631,420,203,1,0,1,0,0,0,0,''),(632,420,204,1,0,10,0,0,0,0,''),(633,421,0,1,0,13,0,0,0,0,''),(634,421,205,1,0,12,0,0,0,0,''),(635,421,206,1,0,1,0,0,0,0,''),(636,422,0,1,0,11,0,0,0,0,''),(637,422,207,1,0,10,0,0,0,0,''),(638,422,208,1,0,1,0,0,0,0,''),(639,423,0,1,0,13,0,0,0,0,''),(640,423,209,1,0,12,0,0,0,0,''),(641,423,210,1,0,1,0,0,0,0,''),(642,424,0,1,0,13,0,0,0,0,''),(643,424,211,1,0,12,0,0,0,0,''),(644,424,212,1,0,1,0,0,0,0,''),(645,425,0,1,0,6,0,0,0,0,''),(646,426,0,1,0,6,0,0,0,0,''),(647,427,0,1,0,6,0,0,0,0,''),(648,428,0,1,0,6,0,0,0,0,''),(649,429,0,1,0,6,0,0,0,0,''),(650,430,0,1,0,0,0,0,0,0,''),(652,417,214,1,0,1,0,0,0,0,''),(653,417,215,1,0,12,0,0,0,0,''),(654,416,216,1,0,1,0,0,0,0,''),(655,416,217,1,0,12,0,0,0,0,'');

--
-- Table structure for table `bl_stock_mvt`
--

CREATE TABLE `bl_stock_mvt` (
  `id_stock_mvt` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_stock` int(11) NOT NULL,
  `id_order` int(11) DEFAULT NULL,
  `id_supply_order` int(11) DEFAULT NULL,
  `id_stock_mvt_reason` int(11) NOT NULL,
  `id_employee` int(11) NOT NULL,
  `employee_lastname` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employee_firstname` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `physical_quantity` int(11) NOT NULL,
  `date_add` datetime NOT NULL,
  `sign` smallint(6) NOT NULL DEFAULT '1',
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `last_wa` decimal(20,6) DEFAULT '0.000000',
  `current_wa` decimal(20,6) DEFAULT '0.000000',
  `referer` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id_stock_mvt`),
  KEY `id_stock` (`id_stock`),
  KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`)
) ENGINE=InnoDB AUTO_INCREMENT=387 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bl_stock_mvt`
--

INSERT INTO `bl_stock_mvt` VALUES (1,64,NULL,NULL,11,2,'Lapointe','Michel',1,'2023-04-10 05:11:23',1,0.000000,0.000000,0.000000,NULL),(2,65,NULL,NULL,11,2,'Lapointe','Michel',1,'2023-04-10 05:12:58',1,0.000000,0.000000,0.000000,NULL),(3,66,NULL,NULL,11,2,'Lapointe','Michel',1,'2023-04-10 05:14:25',1,0.000000,0.000000,0.000000,NULL),(4,67,NULL,NULL,11,2,'Lapointe','Michel',1,'2023-04-10 05:15:50',1,0.000000,0.000000,0.000000,NULL),(5,68,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 09:29:56',1,0.000000,0.000000,0.000000,NULL),(6,73,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 10:59:08',1,0.000000,0.000000,0.000000,NULL),(7,72,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:00:30',1,0.000000,0.000000,0.000000,NULL),(8,75,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:11:08',1,0.000000,0.000000,0.000000,NULL),(9,76,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:24:22',1,0.000000,0.000000,0.000000,NULL),(10,77,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:29:55',1,0.000000,0.000000,0.000000,NULL),(11,78,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:37:27',1,0.000000,0.000000,0.000000,NULL),(12,79,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:44:56',1,0.000000,0.000000,0.000000,NULL),(13,80,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:49:59',1,0.000000,0.000000,0.000000,NULL),(14,81,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 11:54:50',1,0.000000,0.000000,0.000000,NULL),(15,82,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 12:06:21',1,0.000000,0.000000,0.000000,NULL),(16,83,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 12:17:17',1,0.000000,0.000000,0.000000,NULL),(17,84,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 16:06:43',1,0.000000,0.000000,0.000000,NULL),(18,85,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 16:20:06',1,0.000000,0.000000,0.000000,NULL),(19,86,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 16:30:27',1,0.000000,0.000000,0.000000,NULL),(20,87,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 16:40:50',1,0.000000,0.000000,0.000000,NULL),(21,88,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 16:49:21',1,0.000000,0.000000,0.000000,NULL),(22,89,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 16:54:31',1,0.000000,0.000000,0.000000,NULL),(23,91,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 16:57:25',1,0.000000,0.000000,0.000000,NULL),(24,92,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 17:03:09',1,0.000000,0.000000,0.000000,NULL),(25,95,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 17:33:44',1,0.000000,0.000000,0.000000,NULL),(26,96,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 17:36:36',1,0.000000,0.000000,0.000000,NULL),(27,97,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 17:47:39',1,0.000000,0.000000,0.000000,NULL),(28,98,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 17:49:44',1,0.000000,0.000000,0.000000,NULL),(29,99,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 17:52:19',1,0.000000,0.000000,0.000000,NULL),(30,100,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 20:26:31',1,0.000000,0.000000,0.000000,NULL),(31,101,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 20:35:59',1,0.000000,0.000000,0.000000,NULL),(32,102,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 21:50:05',1,0.000000,0.000000,0.000000,NULL),(33,103,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 21:55:34',1,0.000000,0.000000,0.000000,NULL),(34,104,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:00:22',1,0.000000,0.000000,0.000000,NULL),(35,105,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:04:26',1,0.000000,0.000000,0.000000,NULL),(36,106,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:07:07',1,0.000000,0.000000,0.000000,NULL),(37,107,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:09:57',1,0.000000,0.000000,0.000000,NULL),(38,108,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:12:33',1,0.000000,0.000000,0.000000,NULL),(39,109,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:15:50',1,0.000000,0.000000,0.000000,NULL),(40,110,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:19:52',1,0.000000,0.000000,0.000000,NULL),(41,111,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:22:38',1,0.000000,0.000000,0.000000,NULL),(42,112,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:25:15',1,0.000000,0.000000,0.000000,NULL),(43,113,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:28:56',1,0.000000,0.000000,0.000000,NULL),(44,114,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-10 22:30:57',1,0.000000,0.000000,0.000000,NULL),(45,123,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:09:09',1,0.000000,0.000000,0.000000,NULL),(46,124,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:11:07',1,0.000000,0.000000,0.000000,NULL),(47,120,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:14:23',1,0.000000,0.000000,0.000000,NULL),(48,117,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:17:06',1,0.000000,0.000000,0.000000,NULL),(49,125,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:19:23',1,0.000000,0.000000,0.000000,NULL),(50,126,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:20:53',1,0.000000,0.000000,0.000000,NULL),(51,118,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:22:51',1,0.000000,0.000000,0.000000,NULL),(52,127,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:24:31',1,0.000000,0.000000,0.000000,NULL),(53,121,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:26:38',1,0.000000,0.000000,0.000000,NULL),(54,128,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:34:24',1,0.000000,0.000000,0.000000,NULL),(55,119,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:41:29',1,0.000000,0.000000,0.000000,NULL),(56,116,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 07:48:36',1,0.000000,0.000000,0.000000,NULL),(57,129,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:20:26',1,0.000000,0.000000,0.000000,NULL),(58,131,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:33:38',1,0.000000,0.000000,0.000000,NULL),(59,132,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:36:52',1,0.000000,0.000000,0.000000,NULL),(60,133,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:40:37',1,0.000000,0.000000,0.000000,NULL),(61,134,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:45:05',1,0.000000,0.000000,0.000000,NULL),(62,135,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:48:19',1,0.000000,0.000000,0.000000,NULL),(63,136,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:51:37',1,0.000000,0.000000,0.000000,NULL),(64,137,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 10:57:08',1,0.000000,0.000000,0.000000,NULL),(65,139,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:14:45',1,0.000000,0.000000,0.000000,NULL),(66,140,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:17:30',1,0.000000,0.000000,0.000000,NULL),(67,141,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:20:21',1,0.000000,0.000000,0.000000,NULL),(68,142,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:24:00',1,0.000000,0.000000,0.000000,NULL),(69,143,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:30:49',1,0.000000,0.000000,0.000000,NULL),(70,145,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:42:09',1,0.000000,0.000000,0.000000,NULL),(71,146,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:47:57',1,0.000000,0.000000,0.000000,NULL),(72,147,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:52:02',1,0.000000,0.000000,0.000000,NULL),(73,148,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:55:23',1,0.000000,0.000000,0.000000,NULL),(74,149,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 11:58:34',1,0.000000,0.000000,0.000000,NULL),(75,150,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:00:27',1,0.000000,0.000000,0.000000,NULL),(76,151,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:02:30',1,0.000000,0.000000,0.000000,NULL),(77,152,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:11:23',1,0.000000,0.000000,0.000000,NULL),(78,153,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:16:09',1,0.000000,0.000000,0.000000,NULL),(79,154,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:20:29',1,0.000000,0.000000,0.000000,NULL),(80,155,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:25:16',1,0.000000,0.000000,0.000000,NULL),(81,156,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:30:16',1,0.000000,0.000000,0.000000,NULL),(82,157,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:33:31',1,0.000000,0.000000,0.000000,NULL),(83,158,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:37:33',1,0.000000,0.000000,0.000000,NULL),(84,161,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 12:54:14',1,0.000000,0.000000,0.000000,NULL),(85,163,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:08:45',1,0.000000,0.000000,0.000000,NULL),(86,164,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:11:13',1,0.000000,0.000000,0.000000,NULL),(87,165,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:13:33',1,0.000000,0.000000,0.000000,NULL),(88,166,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:16:31',1,0.000000,0.000000,0.000000,NULL),(89,167,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:20:16',1,0.000000,0.000000,0.000000,NULL),(90,168,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:26:20',1,0.000000,0.000000,0.000000,NULL),(91,169,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:28:38',1,0.000000,0.000000,0.000000,NULL),(92,170,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:31:10',1,0.000000,0.000000,0.000000,NULL),(93,171,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:38:18',1,0.000000,0.000000,0.000000,NULL),(94,172,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:41:15',1,0.000000,0.000000,0.000000,NULL),(95,173,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:43:48',1,0.000000,0.000000,0.000000,NULL),(96,174,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:47:22',1,0.000000,0.000000,0.000000,NULL),(97,175,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:50:52',1,0.000000,0.000000,0.000000,NULL),(98,176,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:53:22',1,0.000000,0.000000,0.000000,NULL),(99,177,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:56:43',1,0.000000,0.000000,0.000000,NULL),(100,178,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 15:59:23',1,0.000000,0.000000,0.000000,NULL),(101,179,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:01:59',1,0.000000,0.000000,0.000000,NULL),(102,181,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:08:19',1,0.000000,0.000000,0.000000,NULL),(103,182,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:10:24',1,0.000000,0.000000,0.000000,NULL),(104,183,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:12:29',1,0.000000,0.000000,0.000000,NULL),(105,184,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:17:36',1,0.000000,0.000000,0.000000,NULL),(106,185,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:21:24',1,0.000000,0.000000,0.000000,NULL),(107,186,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:24:31',1,0.000000,0.000000,0.000000,NULL),(108,187,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:27:58',1,0.000000,0.000000,0.000000,NULL),(109,189,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:30:35',1,0.000000,0.000000,0.000000,NULL),(110,188,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:32:18',1,0.000000,0.000000,0.000000,NULL),(111,190,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:34:08',1,0.000000,0.000000,0.000000,NULL),(112,191,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:36:19',1,0.000000,0.000000,0.000000,NULL),(113,193,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:40:43',1,0.000000,0.000000,0.000000,NULL),(114,195,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:44:21',1,0.000000,0.000000,0.000000,NULL),(115,196,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:46:57',1,0.000000,0.000000,0.000000,NULL),(116,197,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:49:23',1,0.000000,0.000000,0.000000,NULL),(117,192,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-11 16:58:07',1,0.000000,0.000000,0.000000,NULL),(118,199,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 05:33:08',1,0.000000,0.000000,0.000000,NULL),(119,200,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:03:58',1,0.000000,0.000000,0.000000,NULL),(120,202,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:10:58',1,0.000000,0.000000,0.000000,NULL),(121,203,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:20:19',1,0.000000,0.000000,0.000000,NULL),(122,204,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:23:43',1,0.000000,0.000000,0.000000,NULL),(123,205,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:26:38',1,0.000000,0.000000,0.000000,NULL),(124,206,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:32:21',1,0.000000,0.000000,0.000000,NULL),(125,207,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:35:17',1,0.000000,0.000000,0.000000,NULL),(126,208,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:38:56',1,0.000000,0.000000,0.000000,NULL),(127,209,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:42:38',1,0.000000,0.000000,0.000000,NULL),(128,210,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:45:53',1,0.000000,0.000000,0.000000,NULL),(129,211,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:53:18',1,0.000000,0.000000,0.000000,NULL),(130,212,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 11:57:06',1,0.000000,0.000000,0.000000,NULL),(131,213,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:00:04',1,0.000000,0.000000,0.000000,NULL),(132,214,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:03:16',1,0.000000,0.000000,0.000000,NULL),(133,215,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:06:19',1,0.000000,0.000000,0.000000,NULL),(134,216,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:10:04',1,0.000000,0.000000,0.000000,NULL),(135,217,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:12:14',1,0.000000,0.000000,0.000000,NULL),(136,218,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:21:03',1,0.000000,0.000000,0.000000,NULL),(137,219,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:23:58',1,0.000000,0.000000,0.000000,NULL),(138,220,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 12:26:50',1,0.000000,0.000000,0.000000,NULL),(139,221,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 13:33:31',1,0.000000,0.000000,0.000000,NULL),(140,222,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 13:36:17',1,0.000000,0.000000,0.000000,NULL),(141,223,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 13:39:03',1,0.000000,0.000000,0.000000,NULL),(142,224,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 13:50:04',1,0.000000,0.000000,0.000000,NULL),(143,225,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 13:53:01',1,0.000000,0.000000,0.000000,NULL),(144,226,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 13:58:32',1,0.000000,0.000000,0.000000,NULL),(145,227,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:03:39',1,0.000000,0.000000,0.000000,NULL),(146,228,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:09:50',1,0.000000,0.000000,0.000000,NULL),(147,229,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:13:10',1,0.000000,0.000000,0.000000,NULL),(148,230,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:15:59',1,0.000000,0.000000,0.000000,NULL),(149,231,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:19:01',1,0.000000,0.000000,0.000000,NULL),(150,232,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:22:23',1,0.000000,0.000000,0.000000,NULL),(151,233,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:29:21',1,0.000000,0.000000,0.000000,NULL),(152,234,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:31:43',1,0.000000,0.000000,0.000000,NULL),(153,235,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:34:43',1,0.000000,0.000000,0.000000,NULL),(154,236,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:38:03',1,0.000000,0.000000,0.000000,NULL),(155,237,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:41:05',1,0.000000,0.000000,0.000000,NULL),(156,238,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:44:02',1,0.000000,0.000000,0.000000,NULL),(157,239,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:46:21',1,0.000000,0.000000,0.000000,NULL),(158,240,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:49:14',1,0.000000,0.000000,0.000000,NULL),(159,241,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 14:57:31',1,0.000000,0.000000,0.000000,NULL),(160,242,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:01:20',1,0.000000,0.000000,0.000000,NULL),(161,243,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:04:28',1,0.000000,0.000000,0.000000,NULL),(162,244,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:07:49',1,0.000000,0.000000,0.000000,NULL),(163,245,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:10:54',1,0.000000,0.000000,0.000000,NULL),(164,246,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:14:56',1,0.000000,0.000000,0.000000,NULL),(165,247,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:18:42',1,0.000000,0.000000,0.000000,NULL),(166,248,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:25:02',1,0.000000,0.000000,0.000000,NULL),(167,249,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:31:46',1,0.000000,0.000000,0.000000,NULL),(168,250,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:35:24',1,0.000000,0.000000,0.000000,NULL),(169,251,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:38:42',1,0.000000,0.000000,0.000000,NULL),(170,252,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:45:24',1,0.000000,0.000000,0.000000,NULL),(171,253,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:47:10',1,0.000000,0.000000,0.000000,NULL),(172,254,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:50:07',1,0.000000,0.000000,0.000000,NULL),(173,255,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 15:59:56',1,0.000000,0.000000,0.000000,NULL),(174,256,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:05:57',1,0.000000,0.000000,0.000000,NULL),(175,257,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:09:08',1,0.000000,0.000000,0.000000,NULL),(176,259,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:27:46',1,0.000000,0.000000,0.000000,NULL),(177,260,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:31:37',1,0.000000,0.000000,0.000000,NULL),(178,261,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:37:46',1,0.000000,0.000000,0.000000,NULL),(179,263,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:45:55',1,0.000000,0.000000,0.000000,NULL),(180,264,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:51:01',1,0.000000,0.000000,0.000000,NULL),(181,265,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-12 16:54:44',1,0.000000,0.000000,0.000000,NULL),(182,267,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 11:28:15',1,0.000000,0.000000,0.000000,NULL),(183,268,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 11:32:35',1,0.000000,0.000000,0.000000,NULL),(184,269,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 11:35:21',1,0.000000,0.000000,0.000000,NULL),(185,270,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 11:38:19',1,0.000000,0.000000,0.000000,NULL),(186,271,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 11:42:05',1,0.000000,0.000000,0.000000,NULL),(187,272,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 11:44:49',1,0.000000,0.000000,0.000000,NULL),(188,273,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 12:40:02',1,0.000000,0.000000,0.000000,NULL),(189,274,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 12:42:36',1,0.000000,0.000000,0.000000,NULL),(190,275,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 12:47:11',1,0.000000,0.000000,0.000000,NULL),(191,276,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 12:50:30',1,0.000000,0.000000,0.000000,NULL),(192,277,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 12:53:42',1,0.000000,0.000000,0.000000,NULL),(193,279,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 12:58:54',1,0.000000,0.000000,0.000000,NULL),(194,280,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:01:21',1,0.000000,0.000000,0.000000,NULL),(195,281,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:07:34',1,0.000000,0.000000,0.000000,NULL),(196,282,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:12:45',1,0.000000,0.000000,0.000000,NULL),(197,283,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:15:56',1,0.000000,0.000000,0.000000,NULL),(198,284,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:19:36',1,0.000000,0.000000,0.000000,NULL),(199,285,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:23:03',1,0.000000,0.000000,0.000000,NULL),(200,286,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:25:38',1,0.000000,0.000000,0.000000,NULL),(201,287,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:27:59',1,0.000000,0.000000,0.000000,NULL),(202,288,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:30:51',1,0.000000,0.000000,0.000000,NULL),(203,289,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:33:28',1,0.000000,0.000000,0.000000,NULL),(204,290,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:46:54',1,0.000000,0.000000,0.000000,NULL),(205,291,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:48:49',1,0.000000,0.000000,0.000000,NULL),(206,292,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:51:29',1,0.000000,0.000000,0.000000,NULL),(207,293,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:53:18',1,0.000000,0.000000,0.000000,NULL),(208,294,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:56:09',1,0.000000,0.000000,0.000000,NULL),(209,295,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 13:58:05',1,0.000000,0.000000,0.000000,NULL),(210,296,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:00:07',1,0.000000,0.000000,0.000000,NULL),(211,297,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:05:27',1,0.000000,0.000000,0.000000,NULL),(212,298,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:07:27',1,0.000000,0.000000,0.000000,NULL),(213,299,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:09:59',1,0.000000,0.000000,0.000000,NULL),(214,303,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:39:20',1,0.000000,0.000000,0.000000,NULL),(215,302,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:39:20',1,0.000000,0.000000,0.000000,NULL),(216,304,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:48:15',1,0.000000,0.000000,0.000000,NULL),(217,306,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:48:34',1,0.000000,0.000000,0.000000,NULL),(218,305,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:48:34',1,0.000000,0.000000,0.000000,NULL),(219,307,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 14:59:48',1,0.000000,0.000000,0.000000,NULL),(220,308,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 15:00:41',1,0.000000,0.000000,0.000000,NULL),(221,309,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 15:00:41',1,0.000000,0.000000,0.000000,NULL),(222,311,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 15:08:33',1,0.000000,0.000000,0.000000,NULL),(223,312,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 15:08:33',1,0.000000,0.000000,0.000000,NULL),(224,315,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 15:22:57',1,0.000000,0.000000,0.000000,NULL),(225,316,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 15:22:57',1,0.000000,0.000000,0.000000,NULL),(226,323,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-15 15:54:54',1,0.000000,0.000000,0.000000,NULL),(227,325,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-20 23:29:33',1,0.000000,0.000000,0.000000,NULL),(228,326,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-20 23:29:33',1,0.000000,0.000000,0.000000,NULL),(229,325,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-20 23:38:25',1,0.000000,0.000000,0.000000,NULL),(230,329,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:42:31',1,0.000000,0.000000,0.000000,NULL),(231,330,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:42:56',1,0.000000,0.000000,0.000000,NULL),(232,331,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:48:23',1,0.000000,0.000000,0.000000,NULL),(233,332,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:48:23',1,0.000000,0.000000,0.000000,NULL),(234,333,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:49:27',1,0.000000,0.000000,0.000000,NULL),(235,334,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:49:27',1,0.000000,0.000000,0.000000,NULL),(236,335,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:50:32',1,0.000000,0.000000,0.000000,NULL),(237,336,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:53:03',1,0.000000,0.000000,0.000000,NULL),(238,337,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:53:03',1,0.000000,0.000000,0.000000,NULL),(239,338,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:59:26',1,0.000000,0.000000,0.000000,NULL),(240,339,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:59:26',1,0.000000,0.000000,0.000000,NULL),(241,340,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:59:26',1,0.000000,0.000000,0.000000,NULL),(242,342,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:59:26',1,0.000000,0.000000,0.000000,NULL),(243,343,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 12:59:26',1,0.000000,0.000000,0.000000,NULL),(244,348,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:03:43',1,0.000000,0.000000,0.000000,NULL),(245,349,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:03:43',1,0.000000,0.000000,0.000000,NULL),(246,353,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:03:43',1,0.000000,0.000000,0.000000,NULL),(247,359,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:09:36',1,0.000000,0.000000,0.000000,NULL),(248,360,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:09:36',1,0.000000,0.000000,0.000000,NULL),(249,363,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:09:36',1,0.000000,0.000000,0.000000,NULL),(250,364,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:09:36',1,0.000000,0.000000,0.000000,NULL),(251,365,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:13:16',1,0.000000,0.000000,0.000000,NULL),(252,366,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:13:16',1,0.000000,0.000000,0.000000,NULL),(253,367,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:13:16',1,0.000000,0.000000,0.000000,NULL),(254,368,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:13:16',1,0.000000,0.000000,0.000000,NULL),(255,369,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:20:00',1,0.000000,0.000000,0.000000,NULL),(256,370,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:20:00',1,0.000000,0.000000,0.000000,NULL),(257,371,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:20:00',1,0.000000,0.000000,0.000000,NULL),(258,372,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:20:00',1,0.000000,0.000000,0.000000,NULL),(259,373,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:20:00',1,0.000000,0.000000,0.000000,NULL),(260,374,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:25:39',1,0.000000,0.000000,0.000000,NULL),(261,375,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:25:39',1,0.000000,0.000000,0.000000,NULL),(262,376,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:25:39',1,0.000000,0.000000,0.000000,NULL),(263,377,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:25:39',1,0.000000,0.000000,0.000000,NULL),(264,379,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:25:39',1,0.000000,0.000000,0.000000,NULL),(265,380,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:32:08',1,0.000000,0.000000,0.000000,NULL),(266,382,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:32:08',1,0.000000,0.000000,0.000000,NULL),(267,381,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:32:08',1,0.000000,0.000000,0.000000,NULL),(268,383,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:32:08',1,0.000000,0.000000,0.000000,NULL),(269,384,NULL,NULL,11,5,'Benard','Veronic',1,'2023-04-30 13:32:08',1,0.000000,0.000000,0.000000,NULL),(270,388,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 14:21:25',1,0.000000,0.000000,0.000000,NULL),(271,387,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 14:21:25',1,0.000000,0.000000,0.000000,NULL),(272,390,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 14:28:12',1,0.000000,0.000000,0.000000,NULL),(273,391,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 14:28:12',1,0.000000,0.000000,0.000000,NULL),(274,392,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 14:35:18',1,0.000000,0.000000,0.000000,NULL),(275,397,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 14:53:17',1,0.000000,0.000000,0.000000,NULL),(276,398,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 14:53:17',1,0.000000,0.000000,0.000000,NULL),(277,399,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 15:01:02',1,0.000000,0.000000,0.000000,NULL),(278,400,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 15:20:35',1,0.000000,0.000000,0.000000,NULL),(279,401,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 15:31:45',1,0.000000,0.000000,0.000000,NULL),(280,402,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 15:39:10',1,0.000000,0.000000,0.000000,NULL),(281,407,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 15:50:19',1,0.000000,0.000000,0.000000,NULL),(282,406,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 15:50:19',1,0.000000,0.000000,0.000000,NULL),(283,415,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 16:15:29',1,0.000000,0.000000,0.000000,NULL),(284,416,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:15:29',1,0.000000,0.000000,0.000000,NULL),(285,412,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 16:19:12',1,0.000000,0.000000,0.000000,NULL),(286,413,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:19:12',1,0.000000,0.000000,0.000000,NULL),(287,409,NULL,NULL,11,5,'Benard','Veronic',10,'2023-04-30 16:19:37',1,0.000000,0.000000,0.000000,NULL),(288,410,NULL,NULL,11,5,'Benard','Veronic',5,'2023-04-30 16:19:37',1,0.000000,0.000000,0.000000,NULL),(289,403,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 16:20:07',1,0.000000,0.000000,0.000000,NULL),(290,404,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:20:07',1,0.000000,0.000000,0.000000,NULL),(291,418,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 16:30:09',1,0.000000,0.000000,0.000000,NULL),(292,419,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:30:09',1,0.000000,0.000000,0.000000,NULL),(293,421,NULL,NULL,11,5,'Benard','Veronic',4,'2023-04-30 16:39:10',1,0.000000,0.000000,0.000000,NULL),(294,422,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:39:10',1,0.000000,0.000000,0.000000,NULL),(295,423,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:46:25',1,0.000000,0.000000,0.000000,NULL),(296,425,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 16:53:13',1,0.000000,0.000000,0.000000,NULL),(297,426,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:53:13',1,0.000000,0.000000,0.000000,NULL),(298,427,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 16:56:00',1,0.000000,0.000000,0.000000,NULL),(299,429,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:06:16',1,0.000000,0.000000,0.000000,NULL),(300,428,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 17:06:16',1,0.000000,0.000000,0.000000,NULL),(301,431,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 17:11:46',1,0.000000,0.000000,0.000000,NULL),(302,432,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:11:46',1,0.000000,0.000000,0.000000,NULL),(303,433,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:17:57',1,0.000000,0.000000,0.000000,NULL),(304,434,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:23:08',1,0.000000,0.000000,0.000000,NULL),(305,437,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 17:30:12',1,0.000000,0.000000,0.000000,NULL),(306,438,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:30:12',1,0.000000,0.000000,0.000000,NULL),(307,439,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:32:13',1,0.000000,0.000000,0.000000,NULL),(308,440,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 17:35:25',1,0.000000,0.000000,0.000000,NULL),(309,441,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:35:25',1,0.000000,0.000000,0.000000,NULL),(310,442,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:39:21',1,0.000000,0.000000,0.000000,NULL),(311,301,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:46:58',1,0.000000,0.000000,0.000000,NULL),(312,307,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:51:54',1,0.000000,0.000000,0.000000,NULL),(313,310,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:52:59',1,0.000000,0.000000,0.000000,NULL),(314,314,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 17:56:44',1,0.000000,0.000000,0.000000,NULL),(315,444,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:00:50',1,0.000000,0.000000,0.000000,NULL),(316,445,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:08:16',1,0.000000,0.000000,0.000000,NULL),(317,393,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:09:33',1,0.000000,0.000000,0.000000,NULL),(318,317,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:11:27',1,0.000000,0.000000,0.000000,NULL),(319,446,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:13:47',1,0.000000,0.000000,0.000000,NULL),(320,447,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:18:32',1,0.000000,0.000000,0.000000,NULL),(321,449,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 18:21:42',1,0.000000,0.000000,0.000000,NULL),(322,450,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:21:43',1,0.000000,0.000000,0.000000,NULL),(323,452,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 18:28:20',1,0.000000,0.000000,0.000000,NULL),(324,453,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:28:20',1,0.000000,0.000000,0.000000,NULL),(325,454,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:32:45',1,0.000000,0.000000,0.000000,NULL),(326,455,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 18:37:23',1,0.000000,0.000000,0.000000,NULL),(327,456,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:37:23',1,0.000000,0.000000,0.000000,NULL),(328,457,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:41:48',1,0.000000,0.000000,0.000000,NULL),(329,462,NULL,NULL,11,5,'Benard','Veronic',20,'2023-04-30 18:46:51',1,0.000000,0.000000,0.000000,NULL),(330,463,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:46:51',1,0.000000,0.000000,0.000000,NULL),(331,464,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:52:29',1,0.000000,0.000000,0.000000,NULL),(332,465,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:56:48',1,0.000000,0.000000,0.000000,NULL),(333,466,NULL,NULL,11,5,'Benard','Veronic',2,'2023-04-30 18:59:38',1,0.000000,0.000000,0.000000,NULL),(334,467,NULL,NULL,11,5,'Benard','Veronic',12,'2023-04-30 19:20:56',1,0.000000,0.000000,0.000000,NULL),(335,468,NULL,NULL,11,5,'Benard','Veronic',12,'2023-04-30 19:23:53',1,0.000000,0.000000,0.000000,NULL),(336,469,NULL,NULL,11,5,'Benard','Veronic',12,'2023-04-30 19:26:46',1,0.000000,0.000000,0.000000,NULL),(337,470,NULL,NULL,11,5,'Benard','Veronic',12,'2023-04-30 19:28:08',1,0.000000,0.000000,0.000000,NULL),(338,471,NULL,NULL,11,5,'Benard','Veronic',12,'2023-04-30 19:32:33',1,0.000000,0.000000,0.000000,NULL),(339,472,NULL,NULL,11,5,'Benard','Veronic',12,'2023-04-30 19:34:51',1,0.000000,0.000000,0.000000,NULL),(340,473,NULL,NULL,11,5,'Benard','Veronic',12,'2023-04-30 19:36:39',1,0.000000,0.000000,0.000000,NULL),(341,602,NULL,NULL,11,1,'Fournier','Eric',10,'2023-06-12 08:32:46',1,0.000000,0.000000,0.000000,NULL),(342,602,NULL,NULL,11,1,'Fournier','Eric',10,'2023-06-12 08:44:00',-1,0.000000,0.000000,0.000000,NULL),(343,643,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:38:07',1,0.000000,0.000000,0.000000,NULL),(344,644,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:38:07',1,0.000000,0.000000,0.000000,NULL),(345,651,NULL,NULL,11,5,'Benard','Veronic',6,'2023-06-12 09:38:29',1,0.000000,0.000000,0.000000,NULL),(346,641,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:39:24',1,0.000000,0.000000,0.000000,NULL),(347,640,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:39:25',1,0.000000,0.000000,0.000000,NULL),(348,638,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:40:01',1,0.000000,0.000000,0.000000,NULL),(349,637,NULL,NULL,11,5,'Benard','Veronic',10,'2023-06-12 09:40:01',1,0.000000,0.000000,0.000000,NULL),(350,649,NULL,NULL,11,5,'Benard','Veronic',6,'2023-06-12 09:40:17',1,0.000000,0.000000,0.000000,NULL),(351,648,NULL,NULL,11,5,'Benard','Veronic',6,'2023-06-12 09:40:32',1,0.000000,0.000000,0.000000,NULL),(352,647,NULL,NULL,11,5,'Benard','Veronic',6,'2023-06-12 09:40:43',1,0.000000,0.000000,0.000000,NULL),(353,646,NULL,NULL,11,5,'Benard','Veronic',6,'2023-06-12 09:40:57',1,0.000000,0.000000,0.000000,NULL),(354,645,NULL,NULL,11,5,'Benard','Veronic',6,'2023-06-12 09:41:10',1,0.000000,0.000000,0.000000,NULL),(355,635,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:41:50',1,0.000000,0.000000,0.000000,NULL),(356,634,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:41:50',1,0.000000,0.000000,0.000000,NULL),(357,629,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:42:26',1,0.000000,0.000000,0.000000,NULL),(358,628,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:42:26',1,0.000000,0.000000,0.000000,NULL),(359,626,NULL,NULL,11,5,'Benard','Veronic',2,'2023-06-12 09:42:54',1,0.000000,0.000000,0.000000,NULL),(360,625,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:42:54',1,0.000000,0.000000,0.000000,NULL),(361,652,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:43:29',1,0.000000,0.000000,0.000000,NULL),(362,653,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:43:29',1,0.000000,0.000000,0.000000,NULL),(363,654,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:44:42',1,0.000000,0.000000,0.000000,NULL),(364,655,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:44:43',1,0.000000,0.000000,0.000000,NULL),(365,621,NULL,NULL,11,5,'Benard','Veronic',2,'2023-06-12 09:45:08',1,0.000000,0.000000,0.000000,NULL),(366,620,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:45:08',1,0.000000,0.000000,0.000000,NULL),(367,614,NULL,NULL,11,5,'Benard','Veronic',2,'2023-06-12 09:45:48',1,0.000000,0.000000,0.000000,NULL),(368,613,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:45:48',1,0.000000,0.000000,0.000000,NULL),(369,597,NULL,NULL,11,5,'Benard','Veronic',2,'2023-06-12 09:48:05',1,0.000000,0.000000,0.000000,NULL),(370,596,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:48:05',1,0.000000,0.000000,0.000000,NULL),(371,599,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:48:55',1,0.000000,0.000000,0.000000,NULL),(372,598,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:48:55',1,0.000000,0.000000,0.000000,NULL),(373,601,NULL,NULL,11,5,'Benard','Veronic',2,'2023-06-12 09:50:20',1,0.000000,0.000000,0.000000,NULL),(374,600,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:50:20',1,0.000000,0.000000,0.000000,NULL),(375,603,NULL,NULL,11,5,'Benard','Veronic',2,'2023-06-12 09:53:06',1,0.000000,0.000000,0.000000,NULL),(376,602,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:53:06',1,0.000000,0.000000,0.000000,NULL),(377,605,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:53:32',1,0.000000,0.000000,0.000000,NULL),(378,604,NULL,NULL,11,5,'Benard','Veronic',14,'2023-06-12 09:53:33',1,0.000000,0.000000,0.000000,NULL),(379,607,NULL,NULL,11,5,'Benard','Veronic',4,'2023-06-12 09:54:00',1,0.000000,0.000000,0.000000,NULL),(380,606,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:54:00',1,0.000000,0.000000,0.000000,NULL),(381,609,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:54:24',1,0.000000,0.000000,0.000000,NULL),(382,608,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:54:24',1,0.000000,0.000000,0.000000,NULL),(383,631,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:55:52',1,0.000000,0.000000,0.000000,NULL),(384,632,NULL,NULL,11,5,'Benard','Veronic',10,'2023-06-12 09:55:52',1,0.000000,0.000000,0.000000,NULL),(385,611,NULL,NULL,11,5,'Benard','Veronic',12,'2023-06-12 09:57:29',1,0.000000,0.000000,0.000000,NULL),(386,610,NULL,NULL,11,5,'Benard','Veronic',1,'2023-06-12 09:57:29',1,0.000000,0.000000,0.000000,NULL);

--
-- Table structure for table `bl_stock_mvt_reason`
--

CREATE TABLE `bl_stock_mvt_reason` (
  `id_stock_mvt_reason` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sign` tinyint(1) NOT NULL DEFAULT '1',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_stock_mvt_reason`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_stock_mvt_reason`
--

INSERT INTO `bl_stock_mvt_reason` VALUES (1,1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(2,-1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(3,-1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(4,-1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(5,1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(6,-1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(7,1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(8,1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(9,1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(10,1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(11,1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0),(12,-1,'2023-04-06 11:25:52','2023-04-06 11:25:52',0);

--
-- Table structure for table `bl_stock_mvt_reason_lang`
--

CREATE TABLE `bl_stock_mvt_reason_lang` (
  `id_stock_mvt_reason` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id_stock_mvt_reason`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_stock_mvt_reason_lang`
--

INSERT INTO `bl_stock_mvt_reason_lang` VALUES (1,1,'Augmentation'),(1,2,'Increase'),(1,3,'Augmentation'),(2,1,'Diminution'),(2,2,'Decrease'),(2,3,'Diminution'),(3,1,'Commande client'),(3,2,'Customer Order'),(3,3,'Commande client'),(4,1,'Regulation following an inventory of stock'),(4,2,'Regulation following an inventory of stock'),(4,3,'Regulation following an inventory of stock'),(5,1,'Regulation following an inventory of stock'),(5,2,'Regulation following an inventory of stock'),(5,3,'Regulation following an inventory of stock'),(6,1,'Transfert vers un autre entrepôt'),(6,2,'Transfer to another warehouse'),(6,3,'Transfert vers un autre entrepôt'),(7,1,'Transfert depuis un autre entrepôt'),(7,2,'Transfer from another warehouse'),(7,3,'Transfert d\'un autre entrepôt'),(8,1,'Commande fournisseur'),(8,2,'Supply Order'),(8,3,'Commande fournisseur'),(9,1,'Commande client'),(9,2,'Customer Order'),(9,3,'Commande client'),(10,1,'Retour produit'),(10,2,'Product return'),(10,3,'Retour produit'),(11,1,'Employee Edition'),(11,2,'Employee Edition'),(11,3,'Employee Edition'),(12,1,'Employee Edition'),(12,2,'Employee Edition'),(12,3,'Employee Edition');

--
-- Table structure for table `bl_store`
--

CREATE TABLE `bl_store` (
  `id_store` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(10) unsigned NOT NULL,
  `id_state` int(10) unsigned DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `postcode` varchar(12) NOT NULL,
  `latitude` decimal(13,8) DEFAULT NULL,
  `longitude` decimal(13,8) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `fax` varchar(16) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_store`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_store`
--

INSERT INTO `bl_store` VALUES (6,4,90,'Notre-Dame-de-la-Merci','J0T 2A0',46.26151000,74.07005000,'819 424-3736','','',1,'2023-05-04 03:11:37','2023-06-05 15:36:13');

--
-- Table structure for table `bl_store_lang`
--

CREATE TABLE `bl_store_lang` (
  `id_store` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `hours` text,
  `note` text,
  PRIMARY KEY (`id_store`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_store_lang`
--

INSERT INTO `bl_store_lang` VALUES (6,1,'Boutique Lac Copping','3318 Chem. des Lacs','','[[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"]]',''),(6,2,'Boutique Lac Copping','3318 Chem. des Lacs','','[[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"]]',''),(6,3,'Boutique Lac Copping','3318 Chem. des Lacs','','[[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"],[\"\"]]','');

--
-- Table structure for table `bl_store_shop`
--

CREATE TABLE `bl_store_shop` (
  `id_store` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_store`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_store_shop`
--

INSERT INTO `bl_store_shop` VALUES (6,1);

--
-- Table structure for table `bl_stripe_capture`
--

CREATE TABLE `bl_stripe_capture` (
  `id_stripe_capture` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_payment_intent` varchar(40) NOT NULL,
  `id_order` int(10) NOT NULL,
  `expired` tinyint(1) unsigned NOT NULL,
  `date_catch` datetime NOT NULL,
  `date_authorize` datetime NOT NULL,
  PRIMARY KEY (`id_stripe_capture`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_stripe_capture`
--


--
-- Table structure for table `bl_stripe_customer`
--

CREATE TABLE `bl_stripe_customer` (
  `id_stripe_customer` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_customer` int(10) NOT NULL,
  `stripe_customer_key` varchar(50) NOT NULL,
  `id_account` varchar(50) NOT NULL,
  PRIMARY KEY (`id_stripe_customer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_stripe_customer`
--


--
-- Table structure for table `bl_stripe_event`
--

CREATE TABLE `bl_stripe_event` (
  `id_stripe_event` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_payment_intent` varchar(40) NOT NULL,
  `status` varchar(30) NOT NULL,
  `date_add` datetime NOT NULL,
  `is_processed` tinyint(1) unsigned NOT NULL,
  `flow_type` varchar(30) NOT NULL,
  PRIMARY KEY (`id_stripe_event`),
  UNIQUE KEY `ix_id_payment_intentstatus` (`id_payment_intent`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_stripe_event`
--


--
-- Table structure for table `bl_stripe_idempotency_key`
--

CREATE TABLE `bl_stripe_idempotency_key` (
  `id_idempotency_key` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cart` int(10) NOT NULL,
  `idempotency_key` varchar(255) NOT NULL,
  `id_payment_intent` varchar(255) NOT NULL,
  PRIMARY KEY (`id_idempotency_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_stripe_idempotency_key`
--


--
-- Table structure for table `bl_stripe_official_processlogger`
--

CREATE TABLE `bl_stripe_official_processlogger` (
  `id_stripe_official_processlogger` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `msg` mediumtext NOT NULL,
  `level` varchar(10) NOT NULL,
  `object_name` varchar(100) NOT NULL,
  `object_id` int(10) unsigned DEFAULT NULL,
  `id_session` varchar(255) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_stripe_official_processlogger`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_stripe_official_processlogger`
--


--
-- Table structure for table `bl_stripe_payment`
--

CREATE TABLE `bl_stripe_payment` (
  `id_payment` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_stripe` varchar(255) NOT NULL,
  `id_payment_intent` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `id_cart` int(10) NOT NULL,
  `last4` int(10) NOT NULL,
  `type` varchar(20) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `refund` decimal(10,2) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `result` int(10) NOT NULL,
  `state` int(10) NOT NULL,
  `voucher_url` varchar(255) NOT NULL,
  `voucher_expire` datetime NOT NULL,
  `voucher_validate` datetime NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_payment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_stripe_payment`
--


--
-- Table structure for table `bl_stripe_payment_intent`
--

CREATE TABLE `bl_stripe_payment_intent` (
  `id_stripe_payment_intent` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_payment_intent` varchar(40) NOT NULL,
  `status` varchar(30) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_stripe_payment_intent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_stripe_payment_intent`
--


--
-- Table structure for table `bl_supplier`
--

CREATE TABLE `bl_supplier` (
  `id_supplier` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_supplier`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supplier`
--

INSERT INTO `bl_supplier` VALUES (1,'Fashion supplier','2023-04-06 11:26:33','2023-04-06 11:26:33',1),(2,'Accessories supplier','2023-04-06 11:26:33','2023-04-06 11:26:33',1);

--
-- Table structure for table `bl_supplier_lang`
--

CREATE TABLE `bl_supplier_lang` (
  `id_supplier` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `description` text,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id_supplier`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supplier_lang`
--

INSERT INTO `bl_supplier_lang` VALUES (1,1,'','','',''),(1,2,'','','',''),(1,3,'','','',''),(2,1,'','','',''),(2,2,'','','',''),(2,3,'','','','');

--
-- Table structure for table `bl_supplier_shop`
--

CREATE TABLE `bl_supplier_shop` (
  `id_supplier` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_supplier`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supplier_shop`
--

INSERT INTO `bl_supplier_shop` VALUES (1,1),(2,1);

--
-- Table structure for table `bl_supply_order`
--

CREATE TABLE `bl_supply_order` (
  `id_supply_order` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supplier` int(11) unsigned NOT NULL,
  `supplier_name` varchar(64) NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `id_currency` int(11) unsigned NOT NULL,
  `id_ref_currency` int(11) unsigned NOT NULL,
  `reference` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `date_delivery_expected` datetime DEFAULT NULL,
  `total_te` decimal(20,6) DEFAULT '0.000000',
  `total_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `total_tax` decimal(20,6) DEFAULT '0.000000',
  `total_ti` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `is_template` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id_supply_order`),
  KEY `id_supplier` (`id_supplier`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `reference` (`reference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supply_order`
--


--
-- Table structure for table `bl_supply_order_detail`
--

CREATE TABLE `bl_supply_order_detail` (
  `id_supply_order_detail` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order` int(11) unsigned NOT NULL,
  `id_currency` int(11) unsigned NOT NULL,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `reference` varchar(64) NOT NULL,
  `supplier_reference` varchar(64) NOT NULL,
  `name` varchar(128) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `isbn` varchar(32) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `mpn` varchar(40) DEFAULT NULL,
  `exchange_rate` decimal(20,6) DEFAULT '0.000000',
  `unit_price_te` decimal(20,6) DEFAULT '0.000000',
  `quantity_expected` int(11) unsigned NOT NULL,
  `quantity_received` int(11) unsigned NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `price_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `tax_rate` decimal(20,6) DEFAULT '0.000000',
  `tax_value` decimal(20,6) DEFAULT '0.000000',
  `price_ti` decimal(20,6) DEFAULT '0.000000',
  `tax_value_with_order_discount` decimal(20,6) DEFAULT '0.000000',
  `price_with_order_discount_te` decimal(20,6) DEFAULT '0.000000',
  PRIMARY KEY (`id_supply_order_detail`),
  KEY `id_supply_order` (`id_supply_order`,`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`),
  KEY `id_product_product_attribute` (`id_product`,`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supply_order_detail`
--


--
-- Table structure for table `bl_supply_order_history`
--

CREATE TABLE `bl_supply_order_history` (
  `id_supply_order_history` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(255) DEFAULT '',
  `employee_firstname` varchar(255) DEFAULT '',
  `id_state` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_supply_order_history`),
  KEY `id_supply_order` (`id_supply_order`),
  KEY `id_employee` (`id_employee`),
  KEY `id_state` (`id_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supply_order_history`
--


--
-- Table structure for table `bl_supply_order_receipt_history`
--

CREATE TABLE `bl_supply_order_receipt_history` (
  `id_supply_order_receipt_history` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order_detail` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(255) DEFAULT '',
  `employee_firstname` varchar(255) DEFAULT '',
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `quantity` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_supply_order_receipt_history`),
  KEY `id_supply_order_detail` (`id_supply_order_detail`),
  KEY `id_supply_order_state` (`id_supply_order_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supply_order_receipt_history`
--


--
-- Table structure for table `bl_supply_order_state`
--

CREATE TABLE `bl_supply_order_state` (
  `id_supply_order_state` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_note` tinyint(1) NOT NULL DEFAULT '0',
  `editable` tinyint(1) NOT NULL DEFAULT '0',
  `receipt_state` tinyint(1) NOT NULL DEFAULT '0',
  `pending_receipt` tinyint(1) NOT NULL DEFAULT '0',
  `enclosed` tinyint(1) NOT NULL DEFAULT '0',
  `color` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id_supply_order_state`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supply_order_state`
--

INSERT INTO `bl_supply_order_state` VALUES (1,0,1,0,0,0,'#faab00'),(2,1,0,0,0,0,'#273cff'),(3,0,0,0,1,0,'#ff37f5'),(4,0,0,1,1,0,'#ff3e33'),(5,0,0,1,0,1,'#00d60c'),(6,0,0,0,0,1,'#666666');

--
-- Table structure for table `bl_supply_order_state_lang`
--

CREATE TABLE `bl_supply_order_state_lang` (
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id_supply_order_state`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_supply_order_state_lang`
--

INSERT INTO `bl_supply_order_state_lang` VALUES (1,1,'1 - En cours de création'),(1,2,'1 - Creation in progress'),(1,3,'1 - En cours de création'),(2,1,'2 - Commande validée'),(2,2,'2 - Order validated'),(2,3,'2 - Commande validée'),(3,1,'3 - En attente de réception'),(3,2,'3 - Pending receipt'),(3,3,'3 - En attente de réception'),(4,1,'4 - Commande reçue partiellement'),(4,2,'4 - Order received in part'),(4,3,'4 - Commande reçue partiellement'),(5,1,'5 - Commande reçue intégralement'),(5,2,'5 - Order received completely'),(5,3,'5 - Commande reçue complètement'),(6,1,'6 - Commande annulée'),(6,2,'6 - Order canceled'),(6,3,'6 - Commande annulée');

--
-- Table structure for table `bl_tab`
--

CREATE TABLE `bl_tab` (
  `id_tab` int(11) NOT NULL AUTO_INCREMENT,
  `id_parent` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `module` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route_name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `icon` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wording` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wording_domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id_tab`)
) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bl_tab`
--

INSERT INTO `bl_tab` VALUES (1,0,0,NULL,'AdminDashboard','',1,1,'trending_up','Dashboard','Admin.Navigation.Menu'),(2,0,1,NULL,'SELL','',1,1,'','Sell','Admin.Navigation.Menu'),(3,2,0,NULL,'AdminParentOrders','',1,1,'shopping_basket','Orders','Admin.Navigation.Menu'),(4,3,0,NULL,'AdminOrders','',1,1,'','Orders','Admin.Navigation.Menu'),(5,3,1,NULL,'AdminInvoices','',1,1,'','Invoices','Admin.Navigation.Menu'),(6,3,2,NULL,'AdminSlip','',1,1,'','Credit Slips','Admin.Navigation.Menu'),(7,3,3,NULL,'AdminDeliverySlip','',1,1,'','Delivery Slips','Admin.Navigation.Menu'),(8,3,4,NULL,'AdminCarts','',1,1,'','Shopping Carts','Admin.Navigation.Menu'),(9,2,1,NULL,'AdminCatalog','',1,1,'store','Catalog','Admin.Navigation.Menu'),(10,9,0,NULL,'AdminProducts','',1,1,'','Products','Admin.Navigation.Menu'),(11,9,1,NULL,'AdminCategories','',1,1,'','Categories','Admin.Navigation.Menu'),(12,9,2,NULL,'AdminTracking','',1,1,'','Monitoring','Admin.Navigation.Menu'),(13,9,3,NULL,'AdminParentAttributesGroups','',1,1,'','Attributes & Features','Admin.Navigation.Menu'),(14,13,0,NULL,'AdminAttributesGroups','',1,1,'','Attributes','Admin.Navigation.Menu'),(15,13,1,NULL,'AdminFeatures','',1,1,'','Features','Admin.Navigation.Menu'),(16,9,4,NULL,'AdminParentManufacturers','',1,1,'','Brands & Suppliers','Admin.Navigation.Menu'),(17,16,0,NULL,'AdminManufacturers','',1,1,'','Brands','Admin.Navigation.Menu'),(18,16,1,NULL,'AdminSuppliers','',1,1,'','Suppliers','Admin.Navigation.Menu'),(19,9,5,NULL,'AdminAttachments','',1,1,'','Files','Admin.Navigation.Menu'),(20,9,6,NULL,'AdminParentCartRules','',1,1,'','Discounts','Admin.Navigation.Menu'),(21,20,0,NULL,'AdminCartRules','',1,1,'','Cart Rules','Admin.Navigation.Menu'),(22,20,1,NULL,'AdminSpecificPriceRule','',1,1,'','Catalog Price Rules','Admin.Navigation.Menu'),(23,9,7,NULL,'AdminStockManagement','',1,1,'','Stock','Admin.Navigation.Menu'),(24,2,2,NULL,'AdminParentCustomer','',1,1,'account_circle','Customers','Admin.Navigation.Menu'),(25,24,0,NULL,'AdminCustomers','',1,1,'','Customers','Admin.Navigation.Menu'),(26,24,1,NULL,'AdminAddresses','',1,1,'','Addresses','Admin.Navigation.Menu'),(27,24,2,NULL,'AdminOutstanding','',0,1,'','Outstanding','Admin.Navigation.Menu'),(28,2,3,NULL,'AdminParentCustomerThreads','',1,1,'chat','Customer Service','Admin.Navigation.Menu'),(29,28,0,NULL,'AdminCustomerThreads','',1,1,'','Customer Service','Admin.Navigation.Menu'),(30,28,1,NULL,'AdminOrderMessage','',1,1,'','Order Messages','Admin.Navigation.Menu'),(31,28,2,NULL,'AdminReturn','',1,1,'','Merchandise Returns','Admin.Navigation.Menu'),(32,2,4,NULL,'AdminStats','',1,1,'assessment','Stats','Admin.Navigation.Menu'),(33,2,5,NULL,'AdminStock','',1,1,'store','',''),(34,33,0,NULL,'AdminWarehouses','',1,1,'','Warehouses','Admin.Navigation.Menu'),(35,33,1,NULL,'AdminParentStockManagement','',1,1,'','Stock Management','Admin.Navigation.Menu'),(36,35,0,NULL,'AdminStockManagement','',1,1,'','Stock Management','Admin.Navigation.Menu'),(37,0,2,NULL,'IMPROVE','',1,1,'','Improve','Admin.Navigation.Menu'),(38,37,0,NULL,'AdminParentModulesSf','',1,1,'extension','Modules','Admin.Navigation.Menu'),(39,38,0,NULL,'AdminModulesSf','',1,1,'','Module Manager','Admin.Navigation.Menu'),(40,39,0,NULL,'AdminModulesManage','',1,1,'','Modules','Admin.Navigation.Menu'),(41,39,1,NULL,'AdminModulesNotifications','',1,1,'','Alerts','Admin.Navigation.Menu'),(42,39,2,NULL,'AdminModulesUpdates','',1,1,'','Updates','Admin.Navigation.Menu'),(43,37,1,NULL,'AdminParentThemes','',1,1,'desktop_mac','Design','Admin.Navigation.Menu'),(44,126,1,'','AdminThemes','',1,1,'','Theme & Logo','Admin.Navigation.Menu'),(45,43,1,NULL,'AdminParentMailTheme','',1,1,'','Email Theme','Admin.Navigation.Menu'),(46,45,0,NULL,'AdminMailTheme','',1,1,'','Email Theme','Admin.Navigation.Menu'),(47,43,2,NULL,'AdminCmsContent','',1,1,'','Pages','Admin.Navigation.Menu'),(48,43,3,NULL,'AdminModulesPositions','',1,1,'','Positions','Admin.Navigation.Menu'),(49,43,4,NULL,'AdminImages','',1,1,'','Image Settings','Admin.Navigation.Menu'),(50,37,2,NULL,'AdminParentShipping','',1,1,'local_shipping','Shipping','Admin.Navigation.Menu'),(51,50,0,NULL,'AdminCarriers','',1,1,'','Carriers','Admin.Navigation.Menu'),(52,50,1,NULL,'AdminShipping','',1,1,'','Preferences','Admin.Navigation.Menu'),(53,37,3,NULL,'AdminParentPayment','',1,1,'payment','Payment','Admin.Navigation.Menu'),(54,53,0,NULL,'AdminPayment','',1,1,'','Payment Methods','Admin.Navigation.Menu'),(55,53,1,NULL,'AdminPaymentPreferences','',1,1,'','Preferences','Admin.Navigation.Menu'),(56,37,4,NULL,'AdminInternational','',1,1,'language','International','Admin.Navigation.Menu'),(57,56,0,NULL,'AdminParentLocalization','',1,1,'','Localization','Admin.Navigation.Menu'),(58,57,0,NULL,'AdminLocalization','',1,1,'','Localization','Admin.Navigation.Menu'),(59,57,1,NULL,'AdminLanguages','',1,1,'','Languages','Admin.Navigation.Menu'),(60,57,2,NULL,'AdminCurrencies','',1,1,'','Currencies','Admin.Navigation.Menu'),(61,57,3,NULL,'AdminGeolocation','',1,1,'','Geolocation','Admin.Navigation.Menu'),(62,56,1,NULL,'AdminParentCountries','',1,1,'','Locations','Admin.Navigation.Menu'),(63,62,0,NULL,'AdminZones','',1,1,'','Zones','Admin.Navigation.Menu'),(64,62,1,NULL,'AdminCountries','',1,1,'','Countries','Admin.Navigation.Menu'),(65,62,2,NULL,'AdminStates','',1,1,'','States','Admin.Navigation.Menu'),(66,56,2,NULL,'AdminParentTaxes','',1,1,'','Taxes','Admin.Navigation.Menu'),(67,66,0,NULL,'AdminTaxes','',1,1,'','Taxes','Admin.Navigation.Menu'),(68,66,1,NULL,'AdminTaxRulesGroup','',1,1,'','Tax Rules','Admin.Navigation.Menu'),(69,56,3,NULL,'AdminTranslations','',1,1,'','Translations','Admin.Navigation.Menu'),(70,0,3,NULL,'CONFIGURE','',1,1,'','Configure','Admin.Navigation.Menu'),(71,70,0,NULL,'ShopParameters','',1,1,'settings','Shop Parameters','Admin.Navigation.Menu'),(72,71,0,NULL,'AdminParentPreferences','',1,1,'','General','Admin.Navigation.Menu'),(73,72,0,NULL,'AdminPreferences','',1,1,'','General','Admin.Navigation.Menu'),(74,72,1,NULL,'AdminMaintenance','',1,1,'','Maintenance','Admin.Navigation.Menu'),(75,71,1,NULL,'AdminParentOrderPreferences','',1,1,'','Order Settings','Admin.Navigation.Menu'),(76,75,0,NULL,'AdminOrderPreferences','',1,1,'','Order Settings','Admin.Navigation.Menu'),(77,75,1,NULL,'AdminStatuses','',1,1,'','Statuses','Admin.Navigation.Menu'),(78,71,2,NULL,'AdminPPreferences','',1,1,'','Product Settings','Admin.Navigation.Menu'),(79,71,3,NULL,'AdminParentCustomerPreferences','',1,1,'','Customer Settings','Admin.Navigation.Menu'),(80,79,0,NULL,'AdminCustomerPreferences','',1,1,'','Customer Settings','Admin.Navigation.Menu'),(81,79,1,NULL,'AdminGroups','',1,1,'','Groups','Admin.Navigation.Menu'),(82,79,2,NULL,'AdminGenders','',1,1,'','Titles','Admin.Navigation.Menu'),(83,71,4,NULL,'AdminParentStores','',1,1,'','Contact','Admin.Navigation.Menu'),(84,83,0,NULL,'AdminContacts','',1,1,'','Contacts','Admin.Navigation.Menu'),(85,83,1,NULL,'AdminStores','',1,1,'','Stores','Admin.Navigation.Menu'),(86,71,5,NULL,'AdminParentMeta','',1,1,'','Traffic & SEO','Admin.Navigation.Menu'),(87,86,0,NULL,'AdminMeta','',1,1,'','SEO & URLs','Admin.Navigation.Menu'),(88,86,1,NULL,'AdminSearchEngines','',1,1,'','Search Engines','Admin.Navigation.Menu'),(89,71,6,NULL,'AdminParentSearchConf','',1,1,'','Search','Admin.Navigation.Menu'),(90,89,0,NULL,'AdminSearchConf','',1,1,'','Search','Admin.Navigation.Menu'),(91,89,1,NULL,'AdminTags','',1,1,'','Tags','Admin.Navigation.Menu'),(92,70,1,NULL,'AdminAdvancedParameters','',1,1,'settings_applications','Advanced Parameters','Admin.Navigation.Menu'),(93,92,0,NULL,'AdminInformation','',1,1,'','Information','Admin.Navigation.Menu'),(94,92,1,NULL,'AdminPerformance','',1,1,'','Performance','Admin.Navigation.Menu'),(95,92,2,NULL,'AdminAdminPreferences','',1,1,'','Administration','Admin.Navigation.Menu'),(96,92,3,NULL,'AdminEmails','',1,1,'','E-mail','Admin.Navigation.Menu'),(97,92,4,NULL,'AdminImport','',1,1,'','Import','Admin.Navigation.Menu'),(98,92,5,NULL,'AdminParentEmployees','',1,1,'','Team','Admin.Navigation.Menu'),(99,98,0,NULL,'AdminEmployees','',1,1,'','Employees','Admin.Navigation.Menu'),(100,98,1,NULL,'AdminProfiles','',1,1,'','Profiles','Admin.Navigation.Menu'),(101,98,2,NULL,'AdminAccess','',1,1,'','Permissions','Admin.Navigation.Menu'),(102,92,6,NULL,'AdminParentRequestSql','',1,1,'','Database','Admin.Navigation.Menu'),(103,102,0,NULL,'AdminRequestSql','',1,1,'','SQL Manager','Admin.Navigation.Menu'),(104,102,1,NULL,'AdminBackup','',1,1,'','DB Backup','Admin.Navigation.Menu'),(105,92,7,NULL,'AdminLogs','',1,1,'','Logs','Admin.Navigation.Menu'),(106,92,8,NULL,'AdminWebservice','',1,1,'','Webservice','Admin.Navigation.Menu'),(107,92,9,NULL,'AdminShopGroup','',0,1,'','Multistore','Admin.Navigation.Menu'),(108,92,10,NULL,'AdminShopUrl','',0,1,'','Multistore','Admin.Navigation.Menu'),(109,92,11,NULL,'AdminFeatureFlag','',1,1,'','New & Experimental Features','Admin.Navigation.Menu'),(110,92,12,NULL,'AdminParentSecurity','',1,1,'','',''),(111,110,0,NULL,'AdminSecurity','admin_security',1,1,'','Security','Admin.Navigation.Menu'),(112,110,1,NULL,'AdminSecuritySessionEmployee','admin_security_sessions_employee_list',1,1,'','',''),(113,110,2,NULL,'AdminSecuritySessionCustomer','admin_security_sessions_customer_list',1,1,'','',''),(114,-1,0,NULL,'AdminQuickAccesses','',1,1,'','Quick Access','Admin.Navigation.Menu'),(115,0,4,NULL,'DEFAULT','',1,1,'','More','Admin.Navigation.Menu'),(116,-1,1,NULL,'AdminPatterns','',1,1,'','',''),(117,43,5,'ps_linklist','AdminLinkWidget','admin_link_block_list',1,1,'','Link List','Modules.Linklist.Admin'),(118,0,5,'blockreassurance','AdminBlockListing','',0,0,'',NULL,NULL),(119,38,1,'blockwishlist','WishlistConfigurationAdminParentController','',0,0,'',NULL,NULL),(120,119,1,'blockwishlist','WishlistConfigurationAdminController','',1,0,'',NULL,NULL),(121,119,2,'blockwishlist','WishlistStatisticsAdminController','',1,0,'',NULL,NULL),(122,-1,2,'psgdpr','AdminAjaxPsgdpr','',1,1,'',NULL,NULL),(123,-1,3,'psgdpr','AdminDownloadInvoicesPsgdpr','',1,1,'',NULL,NULL),(124,-1,4,'dashgoals','AdminDashgoals','',1,1,'',NULL,NULL),(125,-1,5,'ps_faviconnotificationbo','AdminConfigureFaviconBo','',1,1,'',NULL,NULL),(126,43,0,'','AdminThemesParent','',1,1,'','Theme & Logo','Admin.Navigation.Menu'),(127,126,2,'ps_themecusto','AdminPsThemeCustoConfiguration','',1,1,'',NULL,NULL),(128,126,3,'ps_themecusto','AdminPsThemeCustoAdvanced','',1,1,'',NULL,NULL),(129,38,2,'an_productextratabs','AdminProductTabs','',0,1,'',NULL,NULL),(130,38,3,'an_productextratabs','AdminProducttabsSettings','',0,1,'',NULL,NULL),(131,38,4,'an_productextratabs','AdminProducttabsAjax','',0,1,'',NULL,NULL),(132,37,5,'anblog','AdminAnblogManagement','',1,0,'create',NULL,NULL),(133,132,1,'anblog','AdminAnblogBlogs','',1,0,'',NULL,NULL),(134,132,2,'anblog','AdminAnblogCategories','',1,0,'',NULL,NULL),(135,132,3,'anblog','AdminAnblogComments','',1,0,'',NULL,NULL),(136,132,4,'anblog','AdminAnblogSettings','',1,0,'',NULL,NULL),(137,38,5,'an_sizeguide','AdminAnsizeguideWidgets','',0,1,'',NULL,NULL),(138,38,6,'an_trust_badges','AdminAntrustbadgesIcons','',0,1,'',NULL,NULL),(139,38,7,'an_trust_badges','AdminAntrustbadgesWidgets','',0,1,'',NULL,NULL),(140,38,8,'an_homeproducts','AdminAnhomeproductsBlocks','',0,1,'',NULL,NULL),(141,38,9,'an_homeproducts','AdminAnhomeproductsSettings','',0,1,'',NULL,NULL),(142,38,10,'an_homeproducts','AdminAnhomeproductsBanners','',0,1,'',NULL,NULL),(143,38,11,'an_advantages','AdminAnAdvantages','',0,0,'',NULL,NULL),(144,38,12,'an_advantages','AdminAnadvantagesBlocktext','',0,0,'',NULL,NULL),(145,38,13,'an_homeslider','AdminAnhomeSlides','',0,1,'',NULL,NULL),(146,38,14,'an_homeslider','AdminAnhomeSliders','',0,1,'',NULL,NULL),(147,38,15,'an_banners','AdminAnBanners','',0,1,'',NULL,NULL),(148,38,16,'an_simple_contact','AdminAnContact','',0,1,'',NULL,NULL),(149,0,6,'an_theme','AdminAn_theme','',0,1,'',NULL,NULL),(150,37,6,'an_theme_dashboard','AdminAn_theme_dashboard','',1,1,'dashboard',NULL,NULL),(151,71,7,'wkcustompayment','AdminCustomPaymentList','',1,1,'',NULL,NULL),(152,151,1,'wkcustompayment','AdminCustomPayment','',1,1,'',NULL,NULL),(153,151,2,'wkcustompayment','AdminCustomPaymentBannerSetting','',1,1,'',NULL,NULL),(154,0,7,'stripe_official','AdminStripe_officialProcessLogger','',0,1,'',NULL,NULL),(155,0,8,'stripe_official','AdminStripe_officialPaymentIntent','',0,1,'',NULL,NULL);

--
-- Table structure for table `bl_tab_lang`
--

CREATE TABLE `bl_tab_lang` (
  `id_tab` int(11) NOT NULL,
  `id_lang` int(11) NOT NULL,
  `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id_tab`,`id_lang`),
  KEY `IDX_EFE68142ED47AB56` (`id_tab`),
  KEY `IDX_EFE68142BA299860` (`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bl_tab_lang`
--

INSERT INTO `bl_tab_lang` VALUES (1,1,'Tableau de bord'),(1,2,'Dashboard'),(1,3,'Tableau de bord'),(2,1,'Vendre'),(2,2,'Sell'),(2,3,'Vendre'),(3,1,'Commandes'),(3,2,'Orders'),(3,3,'Commandes'),(4,1,'Commandes'),(4,2,'Orders'),(4,3,'Commandes'),(5,1,'Factures'),(5,2,'Invoices'),(5,3,'Factures'),(6,1,'Avoirs'),(6,2,'Credit Slips'),(6,3,'Notes de crédit'),(7,1,'Bons de livraison'),(7,2,'Delivery Slips'),(7,3,'Bons de livraison'),(8,1,'Paniers'),(8,2,'Shopping Carts'),(8,3,'Paniers'),(9,1,'Catalogue'),(9,2,'Catalog'),(9,3,'Catalogue'),(10,1,'Produits'),(10,2,'Products'),(10,3,'Produits'),(11,1,'Catégories'),(11,2,'Categories'),(11,3,'Catégories'),(12,1,'Suivi'),(12,2,'Monitoring'),(12,3,'Suivi'),(13,1,'Attributs & caractéristiques'),(13,2,'Attributes & Features'),(13,3,'Attributs & caractéristiques'),(14,1,'Attributs'),(14,2,'Attributes'),(14,3,'Attributs'),(15,1,'Caractéristiques'),(15,2,'Features'),(15,3,'Caractéristiques'),(16,1,'Marques et fournisseurs'),(16,2,'Brands & Suppliers'),(16,3,'Marques et fournisseurs'),(17,1,'Marques'),(17,2,'Brands'),(17,3,'Marques'),(18,1,'Fournisseurs'),(18,2,'Suppliers'),(18,3,'Fournisseurs'),(19,1,'Fichiers'),(19,2,'Files'),(19,3,'Fichiers'),(20,1,'Réductions'),(20,2,'Discounts'),(20,3,'Réductions'),(21,1,'Règles panier'),(21,2,'Cart Rules'),(21,3,'Règles panier'),(22,1,'Règles de prix catalogue'),(22,2,'Catalog Price Rules'),(22,3,'Règles de prix catalogue'),(23,1,'Stock'),(23,2,'Stock'),(23,3,'Stock'),(24,1,'Clients'),(24,2,'Customers'),(24,3,'Clients'),(25,1,'Clients'),(25,2,'Customers'),(25,3,'Clients'),(26,1,'Adresses'),(26,2,'Addresses'),(26,3,'Adresses'),(27,1,'Encours autorisés'),(27,2,'Outstanding'),(27,3,'Encours autorisés'),(28,1,'SAV'),(28,2,'Customer Service'),(28,3,'Service à la clientèle'),(29,1,'SAV'),(29,2,'Customer Service'),(29,3,'Service à la clientèle'),(30,1,'Messages prédéfinis'),(30,2,'Order Messages'),(30,3,'Messages prédéfinis'),(31,1,'Retours produits'),(31,2,'Merchandise Returns'),(31,3,'Retours produits'),(32,1,'Statistiques'),(32,2,'Stats'),(32,3,'Statistiques'),(34,1,'Entrepôts'),(34,2,'Warehouses'),(34,3,'Entrepôts'),(35,1,'Gestion du stock'),(35,2,'Stock Management'),(35,3,'Gestion du stock'),(37,1,'Personnaliser'),(37,2,'Improve'),(37,3,'Améliorer'),(38,1,'Modules'),(38,2,'Modules'),(38,3,'Modules'),(39,1,'Gestionnaire de modules '),(39,2,'Module Manager'),(39,3,'Gestionnaire de modules '),(40,1,'Modules'),(40,2,'Modules'),(40,3,'Modules'),(41,1,'Alertes'),(41,2,'Alerts'),(41,3,'Notifications'),(42,1,'Mises à jour'),(42,2,'Updates'),(42,3,'Mises à jour'),(43,1,'Apparence'),(43,2,'Design'),(43,3,'Conception'),(44,1,'Thème et logo'),(44,2,'Theme & Logo'),(44,3,'Thème et logo'),(45,1,'Thème d\'email'),(45,2,'Email Theme'),(45,3,'Thème d\'email'),(46,1,'Thème d\'email'),(46,2,'Email Theme'),(46,3,'Thème d\'email'),(47,1,'Pages'),(47,2,'Pages'),(47,3,'Pages vues'),(48,1,'Positions'),(48,2,'Positions'),(48,3,'Positions'),(49,1,'Images'),(49,2,'Image Settings'),(49,3,'Paramètres de l\'image'),(50,1,'Livraison'),(50,2,'Shipping'),(50,3,'Expédition'),(51,1,'Transporteurs'),(51,2,'Carriers'),(51,3,'Transporteurs'),(52,1,'Préférences'),(52,2,'Preferences'),(52,3,'Préférences'),(53,1,'Paiement'),(53,2,'Payment'),(53,3,'Paiement'),(54,1,'Modes de paiement'),(54,2,'Payment Methods'),(54,3,'Modes de paiement'),(55,1,'Préférences'),(55,2,'Preferences'),(55,3,'Préférences'),(56,1,'International'),(56,2,'International'),(56,3,'International'),(57,1,'Localisation'),(57,2,'Localization'),(57,3,'Localisation'),(58,1,'Localisation'),(58,2,'Localization'),(58,3,'Localisation'),(59,1,'Langues'),(59,2,'Languages'),(59,3,'Langues'),(60,1,'Devises'),(60,2,'Currencies'),(60,3,'Devises'),(61,1,'Géolocalisation'),(61,2,'Geolocation'),(61,3,'Géolocalisation'),(62,1,'Zones géographiques'),(62,2,'Locations'),(62,3,'Zones géographiques'),(63,1,'Zones'),(63,2,'Zones'),(63,3,'Zones'),(64,1,'Pays'),(64,2,'Countries'),(64,3,'Pays'),(65,1,'États'),(65,2,'States'),(65,3,'États'),(66,1,'Taxes'),(66,2,'Taxes'),(66,3,'Taxes'),(67,1,'Taxes'),(67,2,'Taxes'),(67,3,'Taxes'),(68,1,'Règles de taxes'),(68,2,'Tax Rules'),(68,3,'Règles de taxes'),(69,1,'Traductions'),(69,2,'Translations'),(69,3,'Traductions'),(70,1,'Configurer'),(70,2,'Configure'),(70,3,'Configurer'),(71,1,'Paramètres de la boutique'),(71,2,'Shop Parameters'),(71,3,'Paramètres de la boutique'),(72,1,'Paramètres généraux'),(72,2,'General'),(72,3,'Paramètres généraux'),(73,1,'Paramètres généraux'),(73,2,'General'),(73,3,'Paramètres généraux'),(74,1,'Maintenance'),(74,2,'Maintenance'),(74,3,'Maintenance'),(75,1,'Commandes'),(75,2,'Order Settings'),(75,3,'Paramètres de commande'),(76,1,'Commandes'),(76,2,'Order Settings'),(76,3,'Paramètres de commande'),(77,1,'États de commandes'),(77,2,'Statuses'),(77,3,'États de commandes'),(78,1,'Produits'),(78,2,'Product Settings'),(78,3,'Paramètres du produit'),(79,1,'Clients'),(79,2,'Customer Settings'),(79,3,'Paramètres du client'),(80,1,'Clients'),(80,2,'Customer Settings'),(80,3,'Paramètres du client'),(81,1,'Groupes'),(81,2,'Groups'),(81,3,'Groupes'),(82,1,'Titres de civilité'),(82,2,'Titles'),(82,3,'Titres de civilité'),(83,1,'Contact'),(83,2,'Contact'),(83,3,'Contact'),(84,1,'Contacts'),(84,2,'Contacts'),(84,3,'Contacts'),(85,1,'Magasins'),(85,2,'Stores'),(85,3,'Magasins'),(86,1,'Trafic et SEO'),(86,2,'Traffic & SEO'),(86,3,'Trafic et SEO'),(87,1,'SEO & URL'),(87,2,'SEO & URLs'),(87,3,'SEO & URL'),(88,1,'Moteurs de recherche'),(88,2,'Search Engines'),(88,3,'Moteurs de recherche'),(89,1,'Rechercher'),(89,2,'Search'),(89,3,'Rechercher'),(90,1,'Rechercher'),(90,2,'Search'),(90,3,'Rechercher'),(91,1,'Mots-clés'),(91,2,'Tags'),(91,3,'Mots-clés'),(92,1,'Paramètres avancés'),(92,2,'Advanced Parameters'),(92,3,'Paramètres avancés'),(93,1,'Informations'),(93,2,'Information'),(93,3,'Informations'),(94,1,'Performances'),(94,2,'Performance'),(94,3,'Performances'),(95,1,'Administration'),(95,2,'Administration'),(95,3,'Administration'),(96,1,'E-mail'),(96,2,'E-mail'),(96,3,'E-mail'),(97,1,'Importer'),(97,2,'Import'),(97,3,'Importer'),(98,1,'Équipe'),(98,2,'Team'),(98,3,'Équipe'),(99,1,'Employés'),(99,2,'Employees'),(99,3,'Employés'),(100,1,'Profils'),(100,2,'Profiles'),(100,3,'Profils'),(101,1,'Permissions'),(101,2,'Permissions'),(101,3,'Autorisations'),(102,1,'Base de données'),(102,2,'Database'),(102,3,'Base de données'),(103,1,'Gestionnaire SQL'),(103,2,'SQL Manager'),(103,3,'Gestionnaire SQL'),(104,1,'Sauvegarde BDD'),(104,2,'DB Backup'),(104,3,'Sauvegarde BDD'),(105,1,'Logs'),(105,2,'Logs'),(105,3,'Logs'),(106,1,'Webservice'),(106,2,'Webservice'),(106,3,'Webservice'),(107,1,'Multiboutique'),(107,2,'Multistore'),(107,3,'Multiboutique'),(108,1,'Multiboutique'),(108,2,'Multistore'),(108,3,'Multiboutique'),(109,1,'Fonctionnalités nouvelles et expérimentales'),(109,2,'New & Experimental Features'),(109,3,'Fonctionnalités nouvelles et expérimentales'),(110,1,'Sécurité'),(110,2,'Security'),(110,3,'Sécurité'),(111,1,'Sécurité'),(111,2,'Security'),(111,3,'Sécurité'),(112,1,'Sessions employés'),(112,2,'Employee Sessions'),(112,3,'Sessions employés'),(113,1,'Sessions clients'),(113,2,'Customer Sessions'),(113,3,'Sessions clients'),(114,1,'Accès rapide'),(114,2,'Quick Access'),(114,3,'Accès Rapide'),(115,1,'Détails'),(115,2,'More'),(115,3,'Détails'),(117,1,'Liste de liens'),(117,2,'Link List'),(117,3,'Liste de liens'),(118,1,'AdminBlockListing'),(118,2,'AdminBlockListing'),(118,3,'AdminBlockListing'),(119,1,'Wishlist Module'),(119,2,'Wishlist Module'),(119,3,'Wishlist Module'),(120,1,'Paramètres'),(120,2,'Configuration'),(120,3,'Paramètres'),(121,1,'Statistics'),(121,2,'Statistics'),(121,3,'Statistics'),(122,1,'RGPD Officiel '),(122,2,'RGPD Officiel '),(122,3,'RGPD Officiel '),(123,1,'RGPD Officiel '),(123,2,'RGPD Officiel '),(123,3,'RGPD Officiel '),(124,1,'Dashgoals'),(124,2,'Dashgoals'),(124,3,'Dashgoals'),(125,1,'Notifications de commandes sur le Favicon'),(125,2,'Notifications de commandes sur le Favicon'),(125,3,'Notifications de commandes sur le Favicon'),(126,1,'Thème et logo'),(126,2,'Theme & Logo'),(126,3,'Thème et logo'),(127,1,'Pages Configuration'),(127,2,'Pages Configuration'),(127,3,'Pages Configuration'),(128,1,'Personnalisation avancée'),(128,2,'Advanced Customization'),(128,3,'Advanced Customization'),(129,1,'Product Tabs: Tabs'),(129,2,'Product Tabs: Tabs'),(129,3,'Product Tabs: Tabs'),(130,1,'Product Tabs: Settings'),(130,2,'Product Tabs: Settings'),(130,3,'Product Tabs: Settings'),(131,1,'Product Tabs: Ajax'),(131,2,'Product Tabs: Ajax'),(131,3,'Product Tabs: Ajax'),(132,1,'AN Blog Management'),(132,2,'AN Blog Management'),(132,3,'AN Blog Management'),(133,1,'Posts'),(133,2,'Posts'),(133,3,'Posts'),(134,1,'Categories'),(134,2,'Categories'),(134,3,'Categories'),(135,1,'Comments'),(135,2,'Comments'),(135,3,'Comments'),(136,1,'Settings'),(136,2,'Settings'),(136,3,'Settings'),(137,1,'Size Guide'),(137,2,'Size Guide'),(137,3,'Size Guide'),(138,1,'Trust Badges: Icons'),(138,2,'Trust Badges: Icons'),(138,3,'Trust Badges: Icons'),(139,1,'Trust Badges: Widgets'),(139,2,'Trust Badges: Widgets'),(139,3,'Trust Badges: Widgets'),(140,1,'Products to display'),(140,2,'Products to display'),(140,3,'Products to display'),(141,1,'Settings'),(141,2,'Settings'),(141,3,'Settings'),(142,1,'Banners'),(142,2,'Banners'),(142,3,'Banners'),(143,1,'Advantages'),(143,2,'Advantages'),(143,3,'Advantages'),(144,1,'Block text'),(144,2,'Block text'),(144,3,'Block text'),(145,1,'Slides'),(145,2,'Slides'),(145,3,'Slides'),(146,1,'Slider'),(146,2,'Slider'),(146,3,'Slider'),(147,1,'Banners'),(147,2,'Banners'),(147,3,'Banners'),(148,1,'Simple Contact Block'),(148,2,'Simple Contact Block'),(148,3,'Simple Contact Block'),(149,1,'AdminAn_theme'),(149,2,'AdminAn_theme'),(149,3,'AdminAn_theme'),(150,1,'AN Theme Dashboard'),(150,2,'AN Theme Dashboard'),(150,3,'AN Theme Dashboard'),(151,1,'Custom Payment'),(151,2,'Custom Payment'),(151,3,'Custom Payment'),(152,1,'Payment Options'),(152,2,'Payment Options'),(152,3,'Payment Options'),(153,1,'Banner Settings'),(153,2,'Banner Settings'),(153,3,'Banner Settings'),(154,1,'Logs'),(154,2,'Logs'),(154,3,'Logs'),(155,1,'Liste des intentions de paiement'),(155,2,'Paiment Intent List'),(155,3,'Paiment Intent List');

--
-- Table structure for table `bl_tab_module_preference`
--

CREATE TABLE `bl_tab_module_preference` (
  `id_tab_module_preference` int(11) NOT NULL AUTO_INCREMENT,
  `id_employee` int(11) NOT NULL,
  `id_tab` int(11) NOT NULL,
  `module` varchar(191) NOT NULL,
  PRIMARY KEY (`id_tab_module_preference`),
  UNIQUE KEY `employee_module` (`id_employee`,`id_tab`,`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tab_module_preference`
--


--
-- Table structure for table `bl_tag`
--

CREATE TABLE `bl_tag` (
  `id_tag` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_tag`),
  KEY `tag_name` (`name`),
  KEY `id_lang` (`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tag`
--


--
-- Table structure for table `bl_tag_count`
--

CREATE TABLE `bl_tag_count` (
  `id_group` int(10) unsigned NOT NULL DEFAULT '0',
  `id_tag` int(10) unsigned NOT NULL DEFAULT '0',
  `id_lang` int(10) unsigned NOT NULL DEFAULT '0',
  `id_shop` int(11) unsigned NOT NULL DEFAULT '0',
  `counter` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_group`,`id_tag`),
  KEY `id_group` (`id_group`,`id_lang`,`id_shop`,`counter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tag_count`
--


--
-- Table structure for table `bl_tax`
--

CREATE TABLE `bl_tax` (
  `id_tax` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rate` decimal(10,3) NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_tax`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tax`
--

INSERT INTO `bl_tax` VALUES (1,5.000,1,0),(2,5.000,1,0),(3,5.000,1,0),(4,15.000,1,0),(5,15.000,1,0),(6,15.000,1,0),(7,13.000,1,0),(8,15.000,1,0),(9,9.975,1,0),(10,5.000,1,0);

--
-- Table structure for table `bl_tax_lang`
--

CREATE TABLE `bl_tax_lang` (
  `id_tax` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_tax`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tax_lang`
--

INSERT INTO `bl_tax_lang` VALUES (1,1,'CA 5%'),(1,2,'CA 5%'),(1,3,'CA 5%'),(2,1,'CA-BC 5%'),(2,2,'CA-BC 7%'),(2,3,'CA-BC 7%'),(3,1,'CA-MB 5%'),(3,2,'CA-MB 8%'),(3,3,'CA-MB 8%'),(4,1,'CA-NB 15%'),(4,2,'CA-NB 8%'),(4,3,'CA-NB 8%'),(5,1,'CA-NL 15%'),(5,2,'CA-NL 8%'),(5,3,'CA-NL 8%'),(6,1,'CA-NS 15%'),(6,2,'CA-NS 10%'),(6,3,'CA-NS 10%'),(7,1,'CA-ON 13%'),(7,2,'CA-ON 8%'),(7,3,'CA-ON 8%'),(8,1,'CA-PE 15%'),(8,2,'CA-PE 9%'),(8,3,'CA-PE 9%'),(9,1,'CA-QC 9.975%'),(9,2,'CA-QC 9.975%'),(9,3,'CA-QC 9.975%'),(10,1,'CA-SK 5%'),(10,2,'CA-SK 5%'),(10,3,'CA-SK 5%');

--
-- Table structure for table `bl_tax_rule`
--

CREATE TABLE `bl_tax_rule` (
  `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT,
  `id_tax_rules_group` int(11) NOT NULL,
  `id_country` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `zipcode_from` varchar(12) NOT NULL,
  `zipcode_to` varchar(12) NOT NULL,
  `id_tax` int(11) NOT NULL,
  `behavior` int(11) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id_tax_rule`),
  KEY `id_tax_rules_group` (`id_tax_rules_group`),
  KEY `id_tax` (`id_tax`),
  KEY `category_getproducts` (`id_tax_rules_group`,`id_country`,`id_state`,`zipcode_from`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tax_rule`
--

INSERT INTO `bl_tax_rule` VALUES (1,1,4,0,'0','0',1,1,'TPS'),(2,1,4,91,'0','0',2,0,''),(3,1,4,93,'0','0',3,0,''),(4,1,4,96,'0','0',4,0,''),(5,1,4,97,'0','0',5,0,''),(6,1,4,95,'0','0',6,0,''),(7,1,4,89,'0','0',7,0,''),(8,1,4,98,'0','0',8,0,''),(9,1,4,90,'0','0',9,1,'TVQ'),(10,1,4,94,'0','0',10,0,'');

--
-- Table structure for table `bl_tax_rules_group`
--

CREATE TABLE `bl_tax_rules_group` (
  `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `active` int(11) NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_tax_rules_group`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tax_rules_group`
--

INSERT INTO `bl_tax_rules_group` VALUES (1,'CA Standard Rate',1,0,'2023-04-06 11:25:53','2023-05-04 02:19:35');

--
-- Table structure for table `bl_tax_rules_group_shop`
--

CREATE TABLE `bl_tax_rules_group_shop` (
  `id_tax_rules_group` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_tax_rules_group`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_tax_rules_group_shop`
--

INSERT INTO `bl_tax_rules_group_shop` VALUES (1,1);

--
-- Table structure for table `bl_timezone`
--

CREATE TABLE `bl_timezone` (
  `id_timezone` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_timezone`)
) ENGINE=InnoDB AUTO_INCREMENT=561 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_timezone`
--

INSERT INTO `bl_timezone` VALUES (1,'Africa/Abidjan'),(2,'Africa/Accra'),(3,'Africa/Addis_Ababa'),(4,'Africa/Algiers'),(5,'Africa/Asmara'),(6,'Africa/Asmera'),(7,'Africa/Bamako'),(8,'Africa/Bangui'),(9,'Africa/Banjul'),(10,'Africa/Bissau'),(11,'Africa/Blantyre'),(12,'Africa/Brazzaville'),(13,'Africa/Bujumbura'),(14,'Africa/Cairo'),(15,'Africa/Casablanca'),(16,'Africa/Ceuta'),(17,'Africa/Conakry'),(18,'Africa/Dakar'),(19,'Africa/Dar_es_Salaam'),(20,'Africa/Djibouti'),(21,'Africa/Douala'),(22,'Africa/El_Aaiun'),(23,'Africa/Freetown'),(24,'Africa/Gaborone'),(25,'Africa/Harare'),(26,'Africa/Johannesburg'),(27,'Africa/Kampala'),(28,'Africa/Khartoum'),(29,'Africa/Kigali'),(30,'Africa/Kinshasa'),(31,'Africa/Lagos'),(32,'Africa/Libreville'),(33,'Africa/Lome'),(34,'Africa/Luanda'),(35,'Africa/Lubumbashi'),(36,'Africa/Lusaka'),(37,'Africa/Malabo'),(38,'Africa/Maputo'),(39,'Africa/Maseru'),(40,'Africa/Mbabane'),(41,'Africa/Mogadishu'),(42,'Africa/Monrovia'),(43,'Africa/Nairobi'),(44,'Africa/Ndjamena'),(45,'Africa/Niamey'),(46,'Africa/Nouakchott'),(47,'Africa/Ouagadougou'),(48,'Africa/Porto-Novo'),(49,'Africa/Sao_Tome'),(50,'Africa/Timbuktu'),(51,'Africa/Tripoli'),(52,'Africa/Tunis'),(53,'Africa/Windhoek'),(54,'America/Adak'),(55,'America/Anchorage '),(56,'America/Anguilla'),(57,'America/Antigua'),(58,'America/Araguaina'),(59,'America/Argentina/Buenos_Aires'),(60,'America/Argentina/Catamarca'),(61,'America/Argentina/ComodRivadavia'),(62,'America/Argentina/Cordoba'),(63,'America/Argentina/Jujuy'),(64,'America/Argentina/La_Rioja'),(65,'America/Argentina/Mendoza'),(66,'America/Argentina/Rio_Gallegos'),(67,'America/Argentina/Salta'),(68,'America/Argentina/San_Juan'),(69,'America/Argentina/San_Luis'),(70,'America/Argentina/Tucuman'),(71,'America/Argentina/Ushuaia'),(72,'America/Aruba'),(73,'America/Asuncion'),(74,'America/Atikokan'),(75,'America/Atka'),(76,'America/Bahia'),(77,'America/Barbados'),(78,'America/Belem'),(79,'America/Belize'),(80,'America/Blanc-Sablon'),(81,'America/Boa_Vista'),(82,'America/Bogota'),(83,'America/Boise'),(84,'America/Buenos_Aires'),(85,'America/Cambridge_Bay'),(86,'America/Campo_Grande'),(87,'America/Cancun'),(88,'America/Caracas'),(89,'America/Catamarca'),(90,'America/Cayenne'),(91,'America/Cayman'),(92,'America/Chicago'),(93,'America/Chihuahua'),(94,'America/Coral_Harbour'),(95,'America/Cordoba'),(96,'America/Costa_Rica'),(97,'America/Cuiaba'),(98,'America/Curacao'),(99,'America/Danmarkshavn'),(100,'America/Dawson'),(101,'America/Dawson_Creek'),(102,'America/Denver'),(103,'America/Detroit'),(104,'America/Dominica'),(105,'America/Edmonton'),(106,'America/Eirunepe'),(107,'America/El_Salvador'),(108,'America/Ensenada'),(109,'America/Fort_Wayne'),(110,'America/Fortaleza'),(111,'America/Glace_Bay'),(112,'America/Godthab'),(113,'America/Goose_Bay'),(114,'America/Grand_Turk'),(115,'America/Grenada'),(116,'America/Guadeloupe'),(117,'America/Guatemala'),(118,'America/Guayaquil'),(119,'America/Guyana'),(120,'America/Halifax'),(121,'America/Havana'),(122,'America/Hermosillo'),(123,'America/Indiana/Indianapolis'),(124,'America/Indiana/Knox'),(125,'America/Indiana/Marengo'),(126,'America/Indiana/Petersburg'),(127,'America/Indiana/Tell_City'),(128,'America/Indiana/Vevay'),(129,'America/Indiana/Vincennes'),(130,'America/Indiana/Winamac'),(131,'America/Indianapolis'),(132,'America/Inuvik'),(133,'America/Iqaluit'),(134,'America/Jamaica'),(135,'America/Jujuy'),(136,'America/Juneau'),(137,'America/Kentucky/Louisville'),(138,'America/Kentucky/Monticello'),(139,'America/Knox_IN'),(140,'America/La_Paz'),(141,'America/Lima'),(142,'America/Los_Angeles'),(143,'America/Louisville'),(144,'America/Maceio'),(145,'America/Managua'),(146,'America/Manaus'),(147,'America/Marigot'),(148,'America/Martinique'),(149,'America/Mazatlan'),(150,'America/Mendoza'),(151,'America/Menominee'),(152,'America/Merida'),(153,'America/Mexico_City'),(154,'America/Miquelon'),(155,'America/Moncton'),(156,'America/Monterrey'),(157,'America/Montevideo'),(158,'America/Montreal'),(159,'America/Montserrat'),(160,'America/Nassau'),(161,'America/New_York'),(162,'America/Nipigon'),(163,'America/Nome'),(164,'America/Noronha'),(165,'America/North_Dakota/Center'),(166,'America/North_Dakota/New_Salem'),(167,'America/Panama'),(168,'America/Pangnirtung'),(169,'America/Paramaribo'),(170,'America/Phoenix'),(171,'America/Port-au-Prince'),(172,'America/Port_of_Spain'),(173,'America/Porto_Acre'),(174,'America/Porto_Velho'),(175,'America/Puerto_Rico'),(176,'America/Rainy_River'),(177,'America/Rankin_Inlet'),(178,'America/Recife'),(179,'America/Regina'),(180,'America/Resolute'),(181,'America/Rio_Branco'),(182,'America/Rosario'),(183,'America/Santarem'),(184,'America/Santiago'),(185,'America/Santo_Domingo'),(186,'America/Sao_Paulo'),(187,'America/Scoresbysund'),(188,'America/Shiprock'),(189,'America/St_Barthelemy'),(190,'America/St_Johns'),(191,'America/St_Kitts'),(192,'America/St_Lucia'),(193,'America/St_Thomas'),(194,'America/St_Vincent'),(195,'America/Swift_Current'),(196,'America/Tegucigalpa'),(197,'America/Thule'),(198,'America/Thunder_Bay'),(199,'America/Tijuana'),(200,'America/Toronto'),(201,'America/Tortola'),(202,'America/Vancouver'),(203,'America/Virgin'),(204,'America/Whitehorse'),(205,'America/Winnipeg'),(206,'America/Yakutat'),(207,'America/Yellowknife'),(208,'Antarctica/Casey'),(209,'Antarctica/Davis'),(210,'Antarctica/DumontDUrville'),(211,'Antarctica/Mawson'),(212,'Antarctica/McMurdo'),(213,'Antarctica/Palmer'),(214,'Antarctica/Rothera'),(215,'Antarctica/South_Pole'),(216,'Antarctica/Syowa'),(217,'Antarctica/Vostok'),(218,'Arctic/Longyearbyen'),(219,'Asia/Aden'),(220,'Asia/Almaty'),(221,'Asia/Amman'),(222,'Asia/Anadyr'),(223,'Asia/Aqtau'),(224,'Asia/Aqtobe'),(225,'Asia/Ashgabat'),(226,'Asia/Ashkhabad'),(227,'Asia/Baghdad'),(228,'Asia/Bahrain'),(229,'Asia/Baku'),(230,'Asia/Bangkok'),(231,'Asia/Beirut'),(232,'Asia/Bishkek'),(233,'Asia/Brunei'),(234,'Asia/Calcutta'),(235,'Asia/Choibalsan'),(236,'Asia/Chongqing'),(237,'Asia/Chungking'),(238,'Asia/Colombo'),(239,'Asia/Dacca'),(240,'Asia/Damascus'),(241,'Asia/Dhaka'),(242,'Asia/Dili'),(243,'Asia/Dubai'),(244,'Asia/Dushanbe'),(245,'Asia/Gaza'),(246,'Asia/Harbin'),(247,'Asia/Ho_Chi_Minh'),(248,'Asia/Hong_Kong'),(249,'Asia/Hovd'),(250,'Asia/Irkutsk'),(251,'Asia/Istanbul'),(252,'Asia/Jakarta'),(253,'Asia/Jayapura'),(254,'Asia/Jerusalem'),(255,'Asia/Kabul'),(256,'Asia/Kamchatka'),(257,'Asia/Karachi'),(258,'Asia/Kashgar'),(259,'Asia/Kathmandu'),(260,'Asia/Katmandu'),(261,'Asia/Kolkata'),(262,'Asia/Krasnoyarsk'),(263,'Asia/Kuala_Lumpur'),(264,'Asia/Kuching'),(265,'Asia/Kuwait'),(266,'Asia/Macao'),(267,'Asia/Macau'),(268,'Asia/Magadan'),(269,'Asia/Makassar'),(270,'Asia/Manila'),(271,'Asia/Muscat'),(272,'Asia/Nicosia'),(273,'Asia/Novosibirsk'),(274,'Asia/Omsk'),(275,'Asia/Oral'),(276,'Asia/Phnom_Penh'),(277,'Asia/Pontianak'),(278,'Asia/Pyongyang'),(279,'Asia/Qatar'),(280,'Asia/Qyzylorda'),(281,'Asia/Rangoon'),(282,'Asia/Riyadh'),(283,'Asia/Saigon'),(284,'Asia/Sakhalin'),(285,'Asia/Samarkand'),(286,'Asia/Seoul'),(287,'Asia/Shanghai'),(288,'Asia/Singapore'),(289,'Asia/Taipei'),(290,'Asia/Tashkent'),(291,'Asia/Tbilisi'),(292,'Asia/Tehran'),(293,'Asia/Tel_Aviv'),(294,'Asia/Thimbu'),(295,'Asia/Thimphu'),(296,'Asia/Tokyo'),(297,'Asia/Ujung_Pandang'),(298,'Asia/Ulaanbaatar'),(299,'Asia/Ulan_Bator'),(300,'Asia/Urumqi'),(301,'Asia/Vientiane'),(302,'Asia/Vladivostok'),(303,'Asia/Yakutsk'),(304,'Asia/Yekaterinburg'),(305,'Asia/Yerevan'),(306,'Atlantic/Azores'),(307,'Atlantic/Bermuda'),(308,'Atlantic/Canary'),(309,'Atlantic/Cape_Verde'),(310,'Atlantic/Faeroe'),(311,'Atlantic/Faroe'),(312,'Atlantic/Jan_Mayen'),(313,'Atlantic/Madeira'),(314,'Atlantic/Reykjavik'),(315,'Atlantic/South_Georgia'),(316,'Atlantic/St_Helena'),(317,'Atlantic/Stanley'),(318,'Australia/ACT'),(319,'Australia/Adelaide'),(320,'Australia/Brisbane'),(321,'Australia/Broken_Hill'),(322,'Australia/Canberra'),(323,'Australia/Currie'),(324,'Australia/Darwin'),(325,'Australia/Eucla'),(326,'Australia/Hobart'),(327,'Australia/LHI'),(328,'Australia/Lindeman'),(329,'Australia/Lord_Howe'),(330,'Australia/Melbourne'),(331,'Australia/North'),(332,'Australia/NSW'),(333,'Australia/Perth'),(334,'Australia/Queensland'),(335,'Australia/South'),(336,'Australia/Sydney'),(337,'Australia/Tasmania'),(338,'Australia/Victoria'),(339,'Australia/West'),(340,'Australia/Yancowinna'),(341,'Europe/Amsterdam'),(342,'Europe/Andorra'),(343,'Europe/Athens'),(344,'Europe/Belfast'),(345,'Europe/Belgrade'),(346,'Europe/Berlin'),(347,'Europe/Bratislava'),(348,'Europe/Brussels'),(349,'Europe/Bucharest'),(350,'Europe/Budapest'),(351,'Europe/Chisinau'),(352,'Europe/Copenhagen'),(353,'Europe/Dublin'),(354,'Europe/Gibraltar'),(355,'Europe/Guernsey'),(356,'Europe/Helsinki'),(357,'Europe/Isle_of_Man'),(358,'Europe/Istanbul'),(359,'Europe/Jersey'),(360,'Europe/Kaliningrad'),(361,'Europe/Kiev'),(362,'Europe/Lisbon'),(363,'Europe/Ljubljana'),(364,'Europe/London'),(365,'Europe/Luxembourg'),(366,'Europe/Madrid'),(367,'Europe/Malta'),(368,'Europe/Mariehamn'),(369,'Europe/Minsk'),(370,'Europe/Monaco'),(371,'Europe/Moscow'),(372,'Europe/Nicosia'),(373,'Europe/Oslo'),(374,'Europe/Paris'),(375,'Europe/Podgorica'),(376,'Europe/Prague'),(377,'Europe/Riga'),(378,'Europe/Rome'),(379,'Europe/Samara'),(380,'Europe/San_Marino'),(381,'Europe/Sarajevo'),(382,'Europe/Simferopol'),(383,'Europe/Skopje'),(384,'Europe/Sofia'),(385,'Europe/Stockholm'),(386,'Europe/Tallinn'),(387,'Europe/Tirane'),(388,'Europe/Tiraspol'),(389,'Europe/Uzhgorod'),(390,'Europe/Vaduz'),(391,'Europe/Vatican'),(392,'Europe/Vienna'),(393,'Europe/Vilnius'),(394,'Europe/Volgograd'),(395,'Europe/Warsaw'),(396,'Europe/Zagreb'),(397,'Europe/Zaporozhye'),(398,'Europe/Zurich'),(399,'Indian/Antananarivo'),(400,'Indian/Chagos'),(401,'Indian/Christmas'),(402,'Indian/Cocos'),(403,'Indian/Comoro'),(404,'Indian/Kerguelen'),(405,'Indian/Mahe'),(406,'Indian/Maldives'),(407,'Indian/Mauritius'),(408,'Indian/Mayotte'),(409,'Indian/Reunion'),(410,'Pacific/Apia'),(411,'Pacific/Auckland'),(412,'Pacific/Chatham'),(413,'Pacific/Easter'),(414,'Pacific/Efate'),(415,'Pacific/Enderbury'),(416,'Pacific/Fakaofo'),(417,'Pacific/Fiji'),(418,'Pacific/Funafuti'),(419,'Pacific/Galapagos'),(420,'Pacific/Gambier'),(421,'Pacific/Guadalcanal'),(422,'Pacific/Guam'),(423,'Pacific/Honolulu'),(424,'Pacific/Johnston'),(425,'Pacific/Kiritimati'),(426,'Pacific/Kosrae'),(427,'Pacific/Kwajalein'),(428,'Pacific/Majuro'),(429,'Pacific/Marquesas'),(430,'Pacific/Midway'),(431,'Pacific/Nauru'),(432,'Pacific/Niue'),(433,'Pacific/Norfolk'),(434,'Pacific/Noumea'),(435,'Pacific/Pago_Pago'),(436,'Pacific/Palau'),(437,'Pacific/Pitcairn'),(438,'Pacific/Ponape'),(439,'Pacific/Port_Moresby'),(440,'Pacific/Rarotonga'),(441,'Pacific/Saipan'),(442,'Pacific/Samoa'),(443,'Pacific/Tahiti'),(444,'Pacific/Tarawa'),(445,'Pacific/Tongatapu'),(446,'Pacific/Truk'),(447,'Pacific/Wake'),(448,'Pacific/Wallis'),(449,'Pacific/Yap'),(450,'Brazil/Acre'),(451,'Brazil/DeNoronha'),(452,'Brazil/East'),(453,'Brazil/West'),(454,'Canada/Atlantic'),(455,'Canada/Central'),(456,'Canada/East-Saskatchewan'),(457,'Canada/Eastern'),(458,'Canada/Mountain'),(459,'Canada/Newfoundland'),(460,'Canada/Pacific'),(461,'Canada/Saskatchewan'),(462,'Canada/Yukon'),(463,'CET'),(464,'Chile/Continental'),(465,'Chile/EasterIsland'),(466,'CST6CDT'),(467,'Cuba'),(468,'EET'),(469,'Egypt'),(470,'Eire'),(471,'EST'),(472,'EST5EDT'),(473,'Etc/GMT'),(474,'Etc/GMT+0'),(475,'Etc/GMT+1'),(476,'Etc/GMT+10'),(477,'Etc/GMT+11'),(478,'Etc/GMT+12'),(479,'Etc/GMT+2'),(480,'Etc/GMT+3'),(481,'Etc/GMT+4'),(482,'Etc/GMT+5'),(483,'Etc/GMT+6'),(484,'Etc/GMT+7'),(485,'Etc/GMT+8'),(486,'Etc/GMT+9'),(487,'Etc/GMT-0'),(488,'Etc/GMT-1'),(489,'Etc/GMT-10'),(490,'Etc/GMT-11'),(491,'Etc/GMT-12'),(492,'Etc/GMT-13'),(493,'Etc/GMT-14'),(494,'Etc/GMT-2'),(495,'Etc/GMT-3'),(496,'Etc/GMT-4'),(497,'Etc/GMT-5'),(498,'Etc/GMT-6'),(499,'Etc/GMT-7'),(500,'Etc/GMT-8'),(501,'Etc/GMT-9'),(502,'Etc/GMT0'),(503,'Etc/Greenwich'),(504,'Etc/UCT'),(505,'Etc/Universal'),(506,'Etc/UTC'),(507,'Etc/Zulu'),(508,'Factory'),(509,'GB'),(510,'GB-Eire'),(511,'GMT'),(512,'GMT+0'),(513,'GMT-0'),(514,'GMT0'),(515,'Greenwich'),(516,'Hongkong'),(517,'HST'),(518,'Iceland'),(519,'Iran'),(520,'Israel'),(521,'Jamaica'),(522,'Japan'),(523,'Kwajalein'),(524,'Libya'),(525,'MET'),(526,'Mexico/BajaNorte'),(527,'Mexico/BajaSur'),(528,'Mexico/General'),(529,'MST'),(530,'MST7MDT'),(531,'Navajo'),(532,'NZ'),(533,'NZ-CHAT'),(534,'Poland'),(535,'Portugal'),(536,'PRC'),(537,'PST8PDT'),(538,'ROC'),(539,'ROK'),(540,'Singapore'),(541,'Turkey'),(542,'UCT'),(543,'Universal'),(544,'US/Alaska'),(545,'US/Aleutian'),(546,'US/Arizona'),(547,'US/Central'),(548,'US/East-Indiana'),(549,'US/Eastern'),(550,'US/Hawaii'),(551,'US/Indiana-Starke'),(552,'US/Michigan'),(553,'US/Mountain'),(554,'US/Pacific'),(555,'US/Pacific-New'),(556,'US/Samoa'),(557,'UTC'),(558,'W-SU'),(559,'WET'),(560,'Zulu');

--
-- Table structure for table `bl_translation`
--

CREATE TABLE `bl_translation` (
  `id_translation` int(11) NOT NULL AUTO_INCREMENT,
  `id_lang` int(11) NOT NULL,
  `key` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `translation` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id_translation`),
  KEY `IDX_B9406018BA299860` (`id_lang`),
  KEY `key` (`domain`)
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bl_translation`
--



--
-- Table structure for table `bl_warehouse`
--

CREATE TABLE `bl_warehouse` (
  `id_warehouse` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_currency` int(11) unsigned NOT NULL,
  `id_address` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `reference` varchar(64) DEFAULT NULL,
  `name` varchar(45) NOT NULL,
  `management_type` enum('WA','FIFO','LIFO') NOT NULL DEFAULT 'WA',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_warehouse`
--


--
-- Table structure for table `bl_warehouse_carrier`
--

CREATE TABLE `bl_warehouse_carrier` (
  `id_carrier` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_warehouse`,`id_carrier`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_carrier` (`id_carrier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_warehouse_carrier`
--


--
-- Table structure for table `bl_warehouse_product_location`
--

CREATE TABLE `bl_warehouse_product_location` (
  `id_warehouse_product_location` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  `location` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_warehouse_product_location`),
  UNIQUE KEY `id_product` (`id_product`,`id_product_attribute`,`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_warehouse_product_location`
--


--
-- Table structure for table `bl_warehouse_shop`
--

CREATE TABLE `bl_warehouse_shop` (
  `id_shop` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_warehouse`,`id_shop`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_warehouse_shop`
--


--
-- Table structure for table `bl_web_browser`
--

CREATE TABLE `bl_web_browser` (
  `id_web_browser` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_web_browser`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_web_browser`
--

INSERT INTO `bl_web_browser` VALUES (1,'Safari'),(2,'Safari iPad'),(3,'Firefox'),(4,'Opera'),(5,'IE 6'),(6,'IE 7'),(7,'IE 8'),(8,'IE 9'),(9,'IE 10'),(10,'IE 11'),(11,'Chrome');

--
-- Table structure for table `bl_webservice_account`
--

CREATE TABLE `bl_webservice_account` (
  `id_webservice_account` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(32) NOT NULL,
  `description` text,
  `class_name` varchar(50) NOT NULL DEFAULT 'WebserviceRequest',
  `is_module` tinyint(2) NOT NULL DEFAULT '0',
  `module_name` varchar(50) DEFAULT NULL,
  `active` tinyint(2) NOT NULL,
  PRIMARY KEY (`id_webservice_account`),
  KEY `key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_webservice_account`
--


--
-- Table structure for table `bl_webservice_account_shop`
--

CREATE TABLE `bl_webservice_account_shop` (
  `id_webservice_account` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_webservice_account`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_webservice_account_shop`
--


--
-- Table structure for table `bl_webservice_permission`
--

CREATE TABLE `bl_webservice_permission` (
  `id_webservice_permission` int(11) NOT NULL AUTO_INCREMENT,
  `resource` varchar(50) NOT NULL,
  `method` enum('GET','POST','PUT','PATCH','DELETE','HEAD') NOT NULL,
  `id_webservice_account` int(11) NOT NULL,
  PRIMARY KEY (`id_webservice_permission`),
  UNIQUE KEY `resource_2` (`resource`,`method`,`id_webservice_account`),
  KEY `resource` (`resource`),
  KEY `method` (`method`),
  KEY `id_webservice_account` (`id_webservice_account`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_webservice_permission`
--


--
-- Table structure for table `bl_wishlist`
--

CREATE TABLE `bl_wishlist` (
  `id_wishlist` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_customer` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned DEFAULT '1',
  `id_shop_group` int(10) unsigned DEFAULT '1',
  `token` varchar(64) NOT NULL,
  `name` varchar(64) NOT NULL,
  `counter` int(10) unsigned DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `default` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id_wishlist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_wishlist`
--


--
-- Table structure for table `bl_wishlist_product`
--

CREATE TABLE `bl_wishlist_product` (
  `id_wishlist_product` int(10) NOT NULL AUTO_INCREMENT,
  `id_wishlist` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_product_attribute` int(10) unsigned NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `priority` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_wishlist_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_wishlist_product`
--


--
-- Table structure for table `bl_wishlist_product_cart`
--

CREATE TABLE `bl_wishlist_product_cart` (
  `id_wishlist_product` int(10) unsigned NOT NULL,
  `id_cart` int(10) unsigned NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `date_add` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_wishlist_product_cart`
--


--
-- Table structure for table `bl_wk_custompayment`
--

CREATE TABLE `bl_wk_custompayment` (
  `id_wk_custompayment` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_order_state` int(10) unsigned DEFAULT '0',
  `sendmail` tinyint(1) unsigned DEFAULT '0',
  `logo` varchar(255) DEFAULT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `group_restriction` varchar(255) DEFAULT NULL,
  `carrier_restriction` varchar(255) DEFAULT NULL,
  `order_total` int(10) unsigned DEFAULT '0',
  `currency_restriction` varchar(255) DEFAULT NULL,
  `country_restriction` varchar(255) DEFAULT NULL,
  `discount_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `discount_product_amount` int(10) unsigned NOT NULL DEFAULT '0',
  `discount_value` int(10) unsigned NOT NULL DEFAULT '0',
  `display_out_of_range` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `id_cart_rule` int(10) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_wk_custompayment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_wk_custompayment`
--


--
-- Table structure for table `bl_wk_custompayment_lang`
--

CREATE TABLE `bl_wk_custompayment_lang` (
  `id_wk_custompayment` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL DEFAULT '1',
  `name` varchar(32) DEFAULT NULL,
  `details` text,
  `confirmation_text` varchar(255) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id_wk_custompayment`,`id_shop`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bl_wk_custompayment_lang`
--


--
-- Table structure for table `bl_zone`
--

CREATE TABLE `bl_zone` (
  `id_zone` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_zone`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_zone`
--

INSERT INTO `bl_zone` VALUES (1,'Europe',0),(2,'North America',1),(3,'Asia',0),(4,'Africa',0),(5,'Oceania',0),(6,'South America',0),(7,'Europe (non-EU)',0),(8,'Central America/Antilla',0);

--
-- Table structure for table `bl_zone_shop`
--

CREATE TABLE `bl_zone_shop` (
  `id_zone` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_zone`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bl_zone_shop`
--

INSERT INTO `bl_zone_shop` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1);


