cus-wms-supervise2.0/src/sql/emt-record-time-2.1初始时间为2019年.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', '2019-01-01 00:00:00', '2019-01-01 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', '2019-01-01 00:00:00', '2019-01-01 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', '2019-01-01 00:00:00', '2019-01-01 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', '2019-01-01 00:00:00', '2019-01-01 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', '2019-01-01 00:00:00', '2019-01-01 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', '2019-01-01 00:00:00', '2019-01-01 00:00:00', '1', now(), '1', now()
);