· 3 years ago · Jan 24, 2022, 02:40 PM
1DROP TABLE IF EXISTS `inventory_items`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!50503 SET character_set_client = utf8mb4 */;
4CREATE TABLE `inventory_items` (
5 `id` int NOT NULL AUTO_INCREMENT,
6 `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
7 `updated_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
8 `deleted_at` datetime(6) DEFAULT NULL,
9 `immutable_data` json DEFAULT NULL,
10 `condition` enum('new','used_as_new','used_very_good','used_good','used_acceptable') NOT NULL,
11 `enabled` tinyint NOT NULL DEFAULT '1',
12 `price` int NOT NULL DEFAULT 0,
13 `quantity` int NOT NULL DEFAULT 0,
14 `book_id` int DEFAULT NULL,
15 `library_id` int DEFAULT NULL,
16 `created_by_id` int DEFAULT NULL,
17 `updated_by_id` int DEFAULT NULL,
18 `dispatch_template_id` int DEFAULT NULL,
19 `condition_notes` TEXT DEFAULT NULL,
20 `sku` varchar(128) NOT NULL,
21 PRIMARY KEY (`id`),
22 KEY `FK_inventory_items-books_book_id` (`book_id`),
23 KEY `FK_inventory_items-libraries_library_id` (`library_id`),
24 KEY `FK_inventory_items-sellers_created_by_id` (`created_by_id`),
25 KEY `FK_inventory_items-sellers_updated_by_id` (`updated_by_id`),
26 KEY `FK_inventory_items-dispatch_templates_dispatch_template_id` (`dispatch_template_id`),
27 CONSTRAINT `FK_inventory_items-books_book_id` FOREIGN KEY (`book_id`) REFERENCES `books` (`id`),
28 CONSTRAINT `FK_inventory_items-dispatch_templates_dispatch_template_id` FOREIGN KEY (`dispatch_template_id`) REFERENCES `dispatch_templates` (`id`),
29 CONSTRAINT `FK_inventory_items-libraries_library_id` FOREIGN KEY (`library_id`) REFERENCES `libraries` (`id`),
30 CONSTRAINT `FK_inventory_items-sellers_created_by_id` FOREIGN KEY (`created_by_id`) REFERENCES `sellers` (`id`),
31 CONSTRAINT `FK_inventory_items-sellers_updated_by_id` FOREIGN KEY (`updated_by_id`) REFERENCES `sellers` (`id`)
32) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `inventory_items`
37--
38
39LOCK TABLES `inventory_items` WRITE;
40/*!40000 ALTER TABLE `inventory_items` DISABLE KEYS */;
41INSERT INTO `inventory_items` VALUES (1,'2022-01-13 10:55:59.403348','2022-01-24 08:50:37.660228',NULL,NULL,'new',1,1099,10,1,1,NULL,NULL,1,NULL,'sku1'),(2,'2022-01-13 11:09:56.702290','2022-01-20 11:18:46.037273',NULL,NULL,'used_as_new',1,999,5,1,1,NULL,NULL,NULL,NULL,'sku2'),(3,'2022-01-13 11:09:56.709428','2022-01-20 11:18:46.048348',NULL,NULL,'used_very_good',1,899,4,1,1,NULL,NULL,NULL,NULL,'sku3'),(4,'2022-01-13 11:09:56.719770','2022-01-20 11:18:46.041848',NULL,NULL,'used_as_new',1,799,8,1,1,NULL,NULL,NULL,NULL,'sku4'),(5,'2022-01-13 11:09:56.736014','2022-01-24 09:59:09.838952',NULL,NULL,'used_acceptable',1,699,3,1,2,NULL,NULL,NULL,NULL,'sku5'),(6,'2022-01-24 10:24:13.994725','2022-01-24 10:24:13.994725',NULL,NULL,'used_good',1,69,4,1,1,1,1,1,'Mancano circa la metà delle pagine','DESTROYEDBOOK1'),(7,'2022-01-24 10:25:06.949423','2022-01-24 10:25:06.949423',NULL,NULL,'used_good',1,69,12,1,1,1,1,1,'Mancano circa la metà delle pagine','DESTROYEDBOOK2'),(8,'2022-01-24 10:25:56.045658','2022-01-24 10:25:56.045658',NULL,NULL,'used_good',1,69,1,1,1,1,1,1,'Mancano circa la metà delle pagine','DESTROYEDBOOK3'),(9,'2022-01-24 10:57:22.382588','2022-01-24 10:57:22.382588',NULL,NULL,'used_good',1,69,1,1,1,1,1,1,'Mancano circa la metà delle pagine','DESTROYEDBOOK4');
42/*!40000 ALTER TABLE `inventory_items` ENABLE KEYS */;