yvjia/db/b2c_warehouse.sql

/**
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')
;