/** Source Server Version: 8.0.31 Source Database: backendsys Date: 2023/08/18 12:51:10 */ DROP TABLE IF EXISTS `b2c_warehouse`; CREATE TABLE `b2c_warehouse` ( PRIMARY KEY (`id`), `id` BIGINT AUTO_INCREMENT COMMENT 'ID', `warehouse_type` TINYINT(1) NOT NULL COMMENT '仓库类型 (1正常, 2预订, 3有缺陷, 4丢失)', `warehouse_name` VARCHAR(20) NOT NULL COMMENT '仓库名称', `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='仓库表'; INSERT INTO b2c_warehouse(warehouse_type, warehouse_name) VALUES (1, 'WH1'), (1, 'WH2'), (2, 'Reservation'), (3, 'Defective'), (4, 'Missing') ;