process_id 模版ID
流程实例ID
任务ID


--clear
truncate table sys_log_access;
truncate table sys_log_login;
truncate table res;
truncate table res_action_item;
truncate table res_allocate;
truncate table res_allocate_item
truncate table res_change_item;
truncate table res_history;
truncate table res_inventory;
truncate table res_inventory_item;
truncate table res_inventory_item_s;
truncate table res_inventory_user;
truncate table res_repair;
truncate table res_repair_file;
truncate table res_repair_item;
truncate table sys_feedback;
truncate table res_scrape;
truncate table res_scrape_item;
truncate table res_inout;
truncate table res_inout_item;

update sys_user_info set pwd='oracle'

res_inventory 新增cnt
res，res_inventory_item，res_inventory_item_s 新增字段lastinventorytime


CREATE DATABASE IF NOT EXISTS dtdev2 default charset utf8 COLLATE utf8_general_ci;
set names utf8;
use dtdev2;
source dt.sql


CREATE DATABASE IF NOT EXISTS dt default charset utf8 COLLATE utf8_general_ci;
set names utf8;
use dt;
source dt.sql