/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.23-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: lean_shop_net
-- ------------------------------------------------------
-- Server version	10.6.23-MariaDB-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `leanps_product_shop`
--

DROP TABLE IF EXISTS `leanps_product_shop`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_product_shop` (
  `id_product` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL,
  `id_category_default` int(10) unsigned DEFAULT NULL,
  `id_tax_rules_group` int(11) unsigned NOT NULL,
  `on_sale` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `online_only` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `ecotax` decimal(17,6) NOT NULL DEFAULT 0.000000,
  `minimal_quantity` int(10) unsigned NOT NULL DEFAULT 1,
  `low_stock_threshold` int(10) DEFAULT NULL,
  `low_stock_alert` tinyint(1) NOT NULL DEFAULT 0,
  `price` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `wholesale_price` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `unity` varchar(255) DEFAULT NULL,
  `unit_price_ratio` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `additional_shipping_cost` decimal(20,2) NOT NULL DEFAULT 0.00,
  `customizable` tinyint(2) NOT NULL DEFAULT 0,
  `uploadable_files` tinyint(4) NOT NULL DEFAULT 0,
  `text_fields` tinyint(4) NOT NULL DEFAULT 0,
  `active` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `redirect_type` enum('','404','301-product','302-product','301-category','302-category') NOT NULL DEFAULT '',
  `id_type_redirected` int(10) unsigned NOT NULL DEFAULT 0,
  `available_for_order` tinyint(1) NOT NULL DEFAULT 1,
  `available_date` date DEFAULT NULL,
  `show_condition` tinyint(1) NOT NULL DEFAULT 1,
  `condition` enum('new','used','refurbished') NOT NULL DEFAULT 'new',
  `show_price` tinyint(1) NOT NULL DEFAULT 1,
  `indexed` tinyint(1) NOT NULL DEFAULT 0,
  `visibility` enum('both','catalog','search','none') NOT NULL DEFAULT 'both',
  `cache_default_attribute` int(10) unsigned DEFAULT NULL,
  `advanced_stock_management` tinyint(1) NOT NULL DEFAULT 0,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `pack_stock_type` int(11) unsigned NOT NULL DEFAULT 3,
  PRIMARY KEY (`id_product`,`id_shop`),
  KEY `id_category_default` (`id_category_default`),
  KEY `date_add` (`date_add`,`active`,`visibility`),
  KEY `indexed` (`indexed`,`active`,`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_product_shop`
--

LOCK TABLES `leanps_product_shop` WRITE;
/*!40000 ALTER TABLE `leanps_product_shop` DISABLE KEYS */;
INSERT INTO `leanps_product_shop` VALUES (1,1,10,1,0,0,0.000000,1,NULL,0,535.000000,0.000000,'1',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00',1,'new',1,0,'both',0,0,'2012-07-27 12:24:16','2020-02-22 22:38:05',0),(11,1,2,1,1,0,0.000000,1,NULL,0,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2012-07-28 20:26:14','2020-07-16 20:58:25',0),(14,1,29,1,0,0,0.000000,1,NULL,0,0.500000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,0,'both',0,0,'2012-07-30 11:40:48','2016-07-01 10:58:46',3),(15,1,29,0,0,0,0.000000,1,NULL,0,290.000000,0.000000,'',0.000000,5.00,0,0,0,1,'301-category',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2012-07-30 11:42:08','2024-03-24 20:57:21',0),(16,1,11,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,NULL,0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-30 14:52:37','2013-07-15 17:53:21',3),(17,1,11,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,NULL,0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-30 14:54:32','2013-07-15 17:53:32',3),(18,1,11,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,NULL,0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-30 14:55:48','2013-07-15 17:53:39',3),(19,1,11,1,0,0,0.000000,1,NULL,0,26.400000,0.000000,'12',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-30 14:56:16','2013-07-13 20:49:42',3),(20,1,11,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-30 14:57:28','2012-07-30 14:57:28',3),(21,1,11,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-30 14:58:40','2012-07-30 14:58:40',3),(22,1,11,1,0,0,0.000000,1,NULL,0,830.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-30 15:07:09','2012-07-30 15:09:47',3),(27,1,18,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-31 17:42:50','2012-08-01 11:50:52',3),(28,1,18,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-31 17:46:49','2012-08-01 11:51:19',3),(29,1,18,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-07-31 17:48:03','2012-08-01 11:51:58',3),(35,1,11,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-08-01 10:59:59','2012-08-01 11:43:24',3),(37,1,19,1,0,0,0.000000,1,NULL,0,25.000000,0.000000,NULL,0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-08-03 09:30:42','2013-07-19 16:56:24',3),(38,1,25,1,0,0,0.000000,1,NULL,0,25.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2012-08-03 09:32:27','2019-08-16 10:06:58',0),(39,1,19,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,NULL,0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-08-03 09:33:20','2013-07-19 16:56:10',3),(40,1,22,0,0,0,0.000000,1,NULL,0,27.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-08-03 09:33:48','2013-08-22 09:27:24',3),(41,1,19,0,0,0,0.000000,1,NULL,0,0.000000,0.000000,NULL,0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2012-08-03 09:44:36','2013-07-19 10:54:53',3),(42,1,10,1,0,0,0.000000,1,NULL,0,240.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-07-15 17:43:27','2014-09-08 10:55:02',3),(43,1,22,1,0,0,0.000000,1,NULL,0,93.000000,40.000000,'100',2.384615,0.00,0,0,0,1,'404',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2013-07-25 10:40:31','2020-09-06 17:09:54',0),(44,1,7,1,0,0,0.000000,1,NULL,0,25.000000,25.000000,'10',1.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2013-07-30 10:23:53','2019-08-17 19:06:24',0),(45,1,1,1,0,0,0.000000,1,NULL,0,55.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-07-30 18:40:43','2019-07-26 15:44:24',3),(47,1,7,1,0,0,0.000000,1,NULL,0,270.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-08-02 21:32:08','2018-11-17 10:49:01',3),(48,1,2,1,0,0,0.000000,1,NULL,0,240.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2013-08-02 21:49:31','2019-08-19 17:36:54',0),(50,1,8,1,0,0,0.000000,1,NULL,0,295.000000,0.000000,'',0.000000,0.00,0,0,0,1,'404',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2013-10-07 10:25:43','2020-02-22 22:34:49',0),(51,1,1,1,0,0,0.000000,1,NULL,0,890.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-10-08 09:26:11','2018-11-16 09:52:05',3),(52,1,1,1,0,0,0.000000,1,NULL,0,50.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-10-11 09:47:19','2013-10-15 14:44:33',3),(53,1,22,0,0,0,0.000000,1,NULL,0,27.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-10-11 11:18:28','2014-09-07 22:32:52',3),(55,1,1,1,0,0,0.000000,1,NULL,0,27.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-10-14 13:45:12','2013-10-14 13:49:59',3),(56,1,1,1,0,0,0.000000,1,NULL,0,27.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-10-14 13:50:32','2013-10-14 13:50:56',3),(57,1,1,1,0,0,0.000000,1,NULL,0,50.000000,0.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-10-15 14:24:45','2013-10-15 14:33:10',3),(58,1,22,0,0,0,0.000000,1,NULL,0,27.000000,0.000000,NULL,0.000000,0.00,0,0,0,0,'404',0,1,NULL,1,'new',1,1,'both',0,0,'2013-10-28 10:50:29','2013-10-28 10:50:29',3),(59,1,9,1,0,0,0.000000,1,NULL,0,90.000000,90.000000,'',0.000000,0.00,0,0,0,0,'404',0,1,'0000-00-00',1,'new',1,1,'both',0,0,'2013-10-30 10:16:52','2024-03-24 16:34:52',3),(61,1,23,0,1,0,0.000000,1,NULL,0,17.150000,0.000000,'',0.000000,0.00,0,0,0,1,'301-category',0,1,'0000-00-00',1,'new',1,0,'both',0,0,'2017-08-25 15:49:34','2024-03-24 16:58:27',0);
/*!40000 ALTER TABLE `leanps_product_shop` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-01 21:35:52
