cus-wms-supervise2.0/src/sql/emt-record-time-2.0.sql

use wms_data;
DELETE FROM emt_record_time;
-- 企业库存信息
INSERT INTO emt_record_time (data_type, last_time, this_time, creater_sn, create_time, moder_sn, mod_time) VALUES (
  'ACQ_INVENTORY_INFO', '2018-02-02 00:00:00', '2018-02-02 00:00:00', '1', now(), '1', now()
);
-- 企业货物上下架信息
-- 上架
INSERT INTO emt_record_time (data_type, last_time, this_time, creater_sn, create_time, moder_sn, mod_time) VALUES (
  'ACQ_SHELF_LOAD', '2018-02-02 00:00:00', '2018-02-02 00:00:00', '1', now(), '1', now()
);
-- 下架
INSERT INTO emt_record_time (data_type, last_time, this_time, creater_sn, create_time, moder_sn, mod_time) VALUES (
  'ACQ_SHELF_LOAD_DOWN', '2018-02-02 00:00:00', '2018-02-02 00:00:00', '1', now(), '1', now()
);
-- 企业货物在仓库的移动信息
-- 上架
INSERT INTO emt_record_time (data_type, last_time, this_time, creater_sn, create_time, moder_sn, mod_time) VALUES (
  'ACQ_GOODS_MOVE_UP', '2018-02-02 00:00:00', '2018-02-02 00:00:00', '1', now(), '1', now()
);
-- 下架
INSERT INTO emt_record_time (data_type, last_time, this_time, creater_sn, create_time, moder_sn, mod_time) VALUES (
  'ACQ_GOODS_MOVE_DOWN', '2018-02-02 00:00:00', '2018-02-02 00:00:00', '1', now(), '1', now()
);
-- 库位上的货物信息
INSERT INTO emt_record_time (data_type, last_time, this_time, creater_sn, create_time, moder_sn, mod_time) VALUES (
  'ACQ_GOODS_ON_SEAT', '2018-02-02 00:00:00', '2018-02-02 00:00:00', '1', now(), '1', now()
);