40 lines
2.3 KiB
MySQL
40 lines
2.3 KiB
MySQL
|
-- 空木箱规格、实例状态和仓位锁初始化
|
|||
|
|
CREATE TABLE IF NOT EXISTS wms_boxtype (
|
|||
|
|
id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
|
|||
|
|
material_code VARCHAR(50) NOT NULL COMMENT '木箱规格编码',
|
|||
|
|
material_name VARCHAR(100) NOT NULL COMMENT '木箱规格名称',
|
|||
|
|
lash_num VARCHAR(10) NOT NULL COMMENT '捆扎次数',
|
|||
|
|
box_length VARCHAR(20) NOT NULL COMMENT '长度',
|
|||
|
|
box_width VARCHAR(20) NOT NULL COMMENT '宽度',
|
|||
|
|
box_height VARCHAR(20) NOT NULL COMMENT '高度',
|
|||
|
|
PRIMARY KEY (id),
|
|||
|
|
UNIQUE KEY uk_wms_boxtype_material_code (material_code)
|
|||
|
|
) COMMENT '木箱规格';
|
|||
|
|
|
|||
|
|
ALTER TABLE wmw_boxinfo
|
|||
|
|
ADD COLUMN status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT '状态：0待入库、1在库、2已出库',
|
|||
|
|
ADD COLUMN out_time VARCHAR(25) NULL COMMENT '出库时间',
|
|||
|
|
ADD INDEX idx_wmw_boxinfo_fifo (material_code, status, insert_time);
|
|||
|
|
|
|||
|
|
INSERT INTO system_dict_data
|
|||
|
|
(id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted)
|
|||
|
|
SELECT 2080566516439883785, 8, '木箱入库锁', '8', 'wms_lock_type', 0, 'success', '', '', '1', NOW(), '1', NOW(), b'0'
|
|||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_dict_data WHERE dict_type = 'wms_lock_type' AND value = '8' AND deleted = b'0');
|
|||
|
|
|
|||
|
|
INSERT INTO system_dict_data
|
|||
|
|
(id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted)
|
|||
|
|
SELECT 2080566516439883786, 9, '木箱出库锁', '9', 'wms_lock_type', 0, 'warning', '', '', '1', NOW(), '1', NOW(), b'0'
|
|||
|
|
WHERE NOT EXISTS (SELECT 1 FROM system_dict_data WHERE dict_type = 'wms_lock_type' AND value = '9' AND deleted = b'0');
|
|||
|
|
|
|||
|
|
INSERT INTO base_code_rule
|
|||
|
|
(rule_name, rule_code, segment_config, code_separator, letter_case, total_length,
|
|||
|
|
seq_strategy, status, remark, creator, updater, deleted)
|
|||
|
|
SELECT '木箱编码', 'BOX_CODE',
|
|||
|
|
JSON_ARRAY(
|
|||
|
|
JSON_OBJECT('type', 'PREFIX', 'value', 'BOX'),
|
|||
|
|
JSON_OBJECT('type', 'DATE', 'format', 'yyyyMMdd'),
|
|||
|
|
JSON_OBJECT('type', 'SEQUENCE', 'resetBy', 'DAY', 'startAt', 1,
|
|||
|
|
'maxValue', 9999, 'paddingLen', 4, 'paddingChar', '0')
|
|||
|
|
), '-', 1, 0, 'segment', 0, '空木箱编码', '1', '1', 0
|
|||
|
|
WHERE NOT EXISTS (SELECT 1 FROM base_code_rule WHERE rule_code = 'BOX_CODE' AND deleted = 0);
|