src/main/resources/data.sql

-- ----------------------------
-- Records of t_dictionary(dicttype,dicttypename,dictval,dictcaption)
-- ----------------------------
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (4, '厂商名称', 'XKP', '新开普');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (5, '操作员状态', '0', '正常');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (5, '操作员状态', '1', '注销');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (2, '操作标志', 'A', '增加');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (2, '操作标志', 'U', '换卡');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (2, '操作标志', 'D', '删除');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (2, '操作标志', 'L', '挂失');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (2, '操作标志', 'C', '注销');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (1, 'operator', 'S', '系统管理员');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (3, '同步状态', 'N', '未同步');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (3, '同步状态', 'Y', '同步');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (8, '设备类型', 'C', '控制器');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (8, '设备类型', 'R', '读头');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (9, '平台IP,发送请求用', 'http://localhost:8080/door', '平台IP地址');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (14, '正常刷卡状态', '17', '正常刷卡状态');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (15, '检测无流水设备时间段', '3', '单位:天');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (16, '设备使用类别', 'MJ', '门禁');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (17, '刷卡不通过重下名单', '1', '1打开,0关闭');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (20, '流水状态', '15', '复位');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (20, '流水状态', '12', '企图开门');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (20, '流水状态', '11', '正常开门');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (20, '流水状态', '14', '按键开门');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (20, '流水状态', '13', '异常开门');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (22, '海康平台地址', 'IP', 'http://172.28.201.105');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (1, 'operator', 'H', '区域管理员');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (1, 'operator', 'P', '超级管理员');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (6, '区域级别', '1', '一级');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (6, '区域级别', '2', '二级');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (6, '区域级别', '3', '三级');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (1, 'operator', 'L', '楼栋管理员');
INSERT INTO t_dictionary(dicttype,dicttypename,dictval,dictcaption) VALUES (13, '抓拍服务地址', 'http://172.28.43.158:8088/door', '抓拍服务地址');

-- ----------------------------
-- Records of t_keys
-- ----------------------------
INSERT INTO "t_keys"(factoryid,keyval,ip,factoryname,queueflag) VALUES ('XKP', '618441D41CCE47DBCFD9BED6E5FF64E6', 'http://localhost:8099/door', '新开普', '10000000');

-- ----------------------------
-- Records of t_timedeventqueue
-- ----------------------------
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (1, 1, '自动分析任务', NULL, NULL, 2, -1, '0 0/2 * * * ?', '20190221170800', 1, 0);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (2, 2, '名单删除任务', NULL, NULL, 2, -1, '0 0/1 * * * ?', '20190221170902', 1, 0);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (3, 3, '换卡同步任务', NULL, NULL, 2, -1, '0/50 * * * * ?', '20190221170951', 1, 0);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (4, 4, '销户同步任务', NULL, NULL, 2, -1, '0/90 * * * * ?', '20190221170901', 1, 0);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (6, 6, '发卡分析任务', NULL, NULL, 2, -1, '0 0/4 * * * ?', '20190221100930', 1, 1);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (9, 9, '挂失卡任务', NULL, NULL, 2, -1, '0/20 * * * * ?', '20190221170940', 1, 0);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (10, 10, '解挂卡任务', NULL, NULL, 2, -1, '0/40 * * * * ?', '20190221170940', 1, 0);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (11, 11, '新开普终端信息采集', NULL, NULL, 2, -1, '0 0/1 * * * ?', '20190516171300', 1, 1);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (12, 12, '同步客户信息到缓存', NULL, NULL, 2, -1, '0 0 0/13 * * ?', '20190516170001', 1, 1);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (0, 0, '自动分析cardver表', NULL, NULL, 2, -1, '0 0/2 * * * ?', '20190606152801', 1, 1);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (7, 7, '新开普设备时间段同步', NULL, NULL, 2, -1, '0 0/2 * * * ?', '20190606152801', 1, 1);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (5, 5, '下发卡名单', NULL, NULL, 2, -1, '0/50 * * * * ?', '20190606152900', 1, 1);
INSERT INTO t_timedeventqueue(timedeventqueue_id,event_type,event_name,queue_time,scheduled_time,recurring_event,object_id,crontrigger,analysistime,removeable,isenable) VALUES (8, 8, '新开普信息返回平台', NULL, NULL, 2, -1, '0/30 * * * * ?', '20190606152901', 1, 1);

-- ----------------------------
-- Records of tb_apiclient
-- ----------------------------
INSERT INTO "tb_apiclient"(appid,roles,secret,status) VALUES ('100001', 'ROLE_THIRD_ADMIN', 'oUw2NmA09ficiVWD4TUQLDOkPyzQa3VzbjjsW0B2qTk=', 'normal');

-- ----------------------------
-- Records of tb_oper_role
-- ----------------------------
INSERT INTO tb_oper_role(id,operid,roleid) VALUES ('1', '0000', 'abcdefghijklmnopqrstuvwxyz012345');

-- ----------------------------
-- Records of tb_function
-- ----------------------------
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (1, NULL, 0, NULL, 'layui-icon-home', '#', '主页', 1, -1,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (2, NULL, 1, NULL, 'layui-icon-home', '/home/console', '控制台', 2, 1,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (3, NULL, 0, NULL, 'layui-icon-set', '#', '系统中心', 10, -1,2);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (4, NULL, 1, NULL, 'layui-icon-set', '/role/index', '角色管理', 11, 3,2);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (5, NULL, 1, NULL, 'layui-icon-set', '/operator/operatorindex', '操作员管理', 12, 3,2);
/*INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (6, NULL, 1, NULL, 'layui-icon-username', '/function/index', '功能管理', 13, 3,1);*/
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (7, NULL, 1, NULL, 'layui-icon-app', '/system/regionindex', '区域管理', 14, 3,2);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (8, NULL, 1, NULL, 'layui-icon-app', '/system/buildingindex', '楼栋管理', 15, 3,2);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (9, NULL, 0, NULL, 'layui-icon-engine', '#', '门控中心', 20, -1,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (10, NULL, 1, NULL, 'layui-icon-engine', '/ncmgr/devindex', '设备管理', 21, 9,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (11, NULL, 1, NULL, 'layui-icon-engine', '/ncmgr/timeindex', '时间段管理', 22, 9,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (12, NULL, 1, NULL, 'layui-icon-engine', '/ncmgr/timegrpindex', '时间组管理', 23, 9,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (13, NULL, 1, NULL, 'layui-icon-engine', '/ncmgr/weektimeindex', '时间周管理', 24, 9,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (14, NULL, 1, NULL, 'layui-icon-engine', '/ncmgr/devweek', '设备时间周管理', 25, 9,3);
/*INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (15, NULL, 0, NULL, 'layui-icon-app', '#', '集控中心', 30, -1,1);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (16, NULL, 1, NULL, 'layui-icon-app', '/system/dictionary', '数据字典管理', 31, 15,1);*/
/*INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (17, NULL, 1, NULL, 'layui-icon-app', '/system/queue', '任务调度管理', 32, 15,1);*/
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (18, NULL, 0, NULL, 'layui-icon-username', '#', '人员中心', 40, -1,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (19, NULL, 1, NULL, 'layui-icon-username', '/doorlistMgr/impCustomerlistindex', '导入人员名单', 41, 18,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (20, NULL, 1, NULL, 'layui-icon-username', '/doorlistMgr/downDoorList', '下发门禁名单', 42, 18,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (21, NULL, 1, NULL, 'layui-icon-username', '/doorlistMgr/deleteDoorList', '删除门禁名单', 43, 18,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (22, NULL, 0, NULL, 'layui-icon-chart-screen', '#', '数据中心', 50, -1,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (23, NULL, 1, NULL, 'layui-icon-chart-screen', '/doorlistMgr/searchDoorlist', '设备名单查询', 51, 22,3);
INSERT INTO tb_function(id,createtime,isleaf,lastsaved,menuicon,menuurl,name,ordernum,parentid,grade) VALUES (24, NULL, 1, NULL, 'layui-icon-chart-screen', '/query/tdoorstream', '流水信息查询', 52, 22,3);





-- ----------------------------
-- Records of tb_operator
-- ----------------------------
INSERT INTO tb_operator(operid,closedate,email,mobile,opendate,opercode,opername,operpwd,opertype,sex,status,foperid,regionid,realname) VALUES ('0000', '20500101', NULL, NULL, '20190101', 'system', '系统管理员', '$2a$10$Ex9xp11.vCaD8D0a7ahiUOKqDij1TcCUBwRAmrqXeDvAkmzLibn4.', 'S', NULL, 'normal', NULL, NULL, '系统');

-- ----------------------------
-- Records of tb_region
-- ----------------------------
INSERT INTO tb_region(regionid,address,level,parentid,regionname,remarks,parentname,flag) VALUES ('0', NULL, 0, '-1', '根区域', NULL, NULL, 1);

-- ----------------------------
-- Records of tb_role
-- ----------------------------
INSERT INTO tb_role(roleid,createtime,editflag,lastsaved,rolecode,roledesc,rolename,operid) VALUES ('abcdefghijklmnopqrstuvwxyz012345', '20190101000000', 0, NULL, 'ROLE_ADMIN', '超级管理员', '超级管理角色','0000');
INSERT INTO tb_role(roleid,createtime,editflag,lastsaved,rolecode,roledesc,rolename,operid) VALUES ('abcdefghijklmnopqrstuvwxyz012346', '20190101000000', 0, NULL, 'ROLE_ADMIN', '推荐区域管理角色', '区域管理角色','0000');

-- ----------------------------
-- Records of tb_role_function
-- ----------------------------
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23800000', 1, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23840001', 2, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23850002', 3, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23850006', 4, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23860007', 5, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
/*INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23860008', 6, NULL, 'abcdefghijklmnopqrstuvwxyz012345');*/
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee2386000a', 7, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee2386000b', 8, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee2387000c', 9, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee2387000d', 10, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee2387000e', 11, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee2387000f', 12, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23880010', 13, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23880011', 14, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23880012', 18, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23880013', 19, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23880014', 20, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23880015', 21, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23880016', 22, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890017', 23, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890018', 24, NULL, 'abcdefghijklmnopqrstuvwxyz012345');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890019', 1, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890020', 2, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890021', 3, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890022', 4, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890023', 5, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890024', 7, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890025', 8, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890026', 9, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890027', 10, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890028', 11, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890029', 12, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890030', 13, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890031', 14, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890032', 18, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890033', 19, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890034', 20, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890035', 21, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890036', 22, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890037', 23, NULL, 'abcdefghijklmnopqrstuvwxyz012346');
INSERT INTO tb_role_function(id,functionid,permissions,roleid) VALUES ('297eec826b97ecf8016b97ee23890038', 24, NULL, 'abcdefghijklmnopqrstuvwxyz012346');

-- ----------------------------
-- Records of tb_systemparam
-- ----------------------------
INSERT INTO tb_systemparam(param_key,param_value,param_desc,param_flag) VALUES ('IMPCUSTOME_FIRST_FLAG','0','0：名单未导入 1：名单导入数据未同步过 2：数据同步过','1');
INSERT INTO tb_systemparam(param_key,param_value,param_desc,param_flag) VALUES ('LAST_SYNC_TIME','','上次数据同步时间','1');
INSERT INTO tb_systemparam(param_key,param_value,param_desc,param_flag) VALUES ('IMPCUSTOME_FIRST_TIME','','第一次名单导入时间','1');