/*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_stock_available`
--

DROP TABLE IF EXISTS `leanps_stock_available`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_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=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_stock_available`
--

LOCK TABLES `leanps_stock_available` WRITE;
/*!40000 ALTER TABLE `leanps_stock_available` DISABLE KEYS */;
INSERT INTO `leanps_stock_available` VALUES (1,1,0,1,0,26,30,4,0,0,''),(3,11,0,1,0,-5,0,5,0,0,''),(4,29,0,1,0,0,0,0,0,2,''),(5,28,0,1,0,0,0,0,0,2,''),(7,27,0,1,0,0,0,0,0,2,''),(8,16,0,1,0,0,0,0,0,2,''),(9,14,0,1,0,-1,-1,0,0,2,''),(10,15,0,1,0,-3,13,16,0,0,''),(11,17,0,1,0,0,0,0,0,2,''),(12,18,0,1,0,0,0,0,0,2,''),(13,19,0,1,0,0,0,0,0,2,''),(14,20,0,1,0,0,0,0,0,2,''),(15,21,0,1,0,0,0,0,0,2,''),(16,22,0,1,0,2,2,0,0,2,''),(20,41,0,1,0,0,0,0,0,2,''),(21,39,0,1,0,0,0,0,0,2,''),(22,40,0,1,0,0,0,0,0,2,''),(23,35,0,1,0,0,0,0,0,2,''),(24,37,0,1,0,0,0,0,0,2,''),(25,38,0,1,0,0,0,0,0,0,''),(26,42,0,1,0,0,0,0,0,2,''),(27,43,0,1,0,996,1071,75,0,0,''),(28,44,0,1,0,50,52,2,0,0,''),(29,45,0,1,0,0,0,0,0,2,''),(31,47,0,1,0,20,20,0,0,2,''),(32,48,0,1,0,-1,0,1,0,0,''),(34,50,0,1,0,1,4,3,0,0,''),(35,51,0,1,0,-4,0,4,0,2,''),(36,52,0,1,0,0,0,0,0,2,''),(37,53,0,1,0,0,0,0,0,2,''),(39,55,0,1,0,0,0,0,0,2,''),(40,56,0,1,0,0,0,0,0,2,''),(41,57,0,1,0,0,0,0,0,2,''),(42,58,0,1,0,0,0,0,0,2,''),(43,59,0,1,0,10,11,1,0,2,''),(45,61,0,1,0,3,8,5,0,0,'');
/*!40000 ALTER TABLE `leanps_stock_available` 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:54
