testjava8/src/test/resources/insert.sql · yidujun/example

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 23

yidujun/example

forked from sanri1993/example

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (1)

管理

master

该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。

项目仓库所选许可证以仓库主分支所使用许可证为准

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 1

标签 0

example

testjava8

src

test

resources

insert.sql

insert.sql 26.96 KB

INSERT INTO "uam"."visitor_info" ("visitor_id", "visitor_type", "visitor_name", "visitor_sex", "identity_type", "identity_no", "phone_no", "company_name", "visit_reason", "visit_count", "target_user_id", "target_user_name", "visitor_car_no", "visit_org_id", "visit_org_name", "checkin_time", "visit_start_time", "visit_end_time", "visit_state", "deposit_amt", "deposit_flag", "remark", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('daedc82e6c214357a90e5bf5f3e358bf', '0', '数据迁移测试人员3', '1', '', '', '13765454545', '测试', '测试', '1', '', '测试', '', '', NULL, '2020年09月29日 16:41:59.488', '2020年09月29日 00:00:00', '2020年10月01日 00:00:00', '1', NULL, '1', '来访', '2020年09月29日 16:41:59.488', '2020年09月29日 16:41:59.488', '测试用户test(系统联调用 不能删除)', 'test', '1', '7b4bfc3216424db390618ee349f84bb7');

INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('0247371b6b1f4eab94e35edf6e78a564', '0247371b6b1f4eab94e35edf6e78a564', '数据迁移测试1', '0', '', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 10:26:14.142', '2020年09月29日 10:26:14.142', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '0');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('fbc51aa9d0714507850129fed35e7c8f', 'fbc51aa9d0714507850129fed35e7c8f', '数据迁移测试2', '0', '', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 10:26:30.788', '2020年09月29日 10:26:30.788', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '0');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('27ad988e97f9454eab4019d482a241c2', '27ad988e97f9454eab4019d482a241c2', '数据迁移多卡门禁', '1', '', '', '1', '3', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 16:33:45.539', '2020年09月29日 16:33:45.539', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('8f513295c84143bfb433cff1c977269b', '8f513295c84143bfb433cff1c977269b', '数据迁移首卡门禁', '1', '', '', '1', '2', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 16:34:02.831', '2020年09月29日 16:34:02.831', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('62557c8475d2441f9be55d30f88a3140', '62557c8475d2441f9be55d30f88a3140', '数据迁移测试3', '0', '', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 16:43:10.754', '2020年09月29日 16:43:10.754', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '0');

INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C2867E630001', '2', '2', '0247371b6b1f4eab94e35edf6e78a564', '101520090090C2867E63', '四门门禁222', '30160090C2867E630001', '222门禁1号门', '0', '0', '1', '2020年09月29日 16:30:11.142', '2020年09月29日 16:30:11.142', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C28675160001', '2', '2', '8f513295c84143bfb433cff1c977269b', '101520090090C2867516', '双门控制器221', '30160090C28675160001', '双门221控制器1号读头', '0', '2', '1', '2020年09月29日 16:37:11.141', '2020年09月29日 16:37:11.141', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C28675160002', '2', '2', '27ad988e97f9454eab4019d482a241c2', '101520090090C2867516', '双门控制器221', '30160090C28675160002', '双门221控制器2号读头', '0', '3', '1', '2020年09月29日 16:37:19.725', '2020年09月29日 16:37:19.725', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C2867E630002', '2', '2', 'fbc51aa9d0714507850129fed35e7c8f', '101520090090C2867E63', '四门门禁222', '30160090C2867E630002', '222门禁2号门', '0', '0', '1', '2020年09月29日 16:43:31.215', '2020年09月29日 16:43:31.215', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C2867E630003', '2', '2', '62557c8475d2441f9be55d30f88a3140', '101520090090C2867E63', '四门门禁222', '30160090C2867E630003', '222门禁3号门', '0', '0', '1', '2020年09月29日 16:43:37.46', '2020年09月29日 16:43:37.46', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('6620d35d25314ba6899e2ee4e0d53b99', '数据迁移测试1组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 10:26:58.511', '2020年09月29日 16:49:09.842', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);
INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('22ad298ba0de4a7bae9883f64beb25a0', '数据迁移测试2组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 10:27:16.178', '2020年09月29日 16:49:14.026', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);
INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('e99f20a1c888455693608ce453b09ffe', '数据迁移测试3组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 16:49:27.749', '2020年09月29日 16:49:27.749', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);
INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('21ad7a62568446089c4626c81f429a71', '数据迁移测试4组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020年09月29日 16:49:35.608', '2020年09月29日 16:49:35.608', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);

INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('1fd3c39a6fa54cbab2ba57e8c9b2b3fc', '27ad988e97f9454eab4019d482a241c2', '2020年09月29日 16:33:45.566', '2020年09月29日 16:33:45.566', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('a8a374661f8c4101a9083e17ad37cb66', '8f513295c84143bfb433cff1c977269b', '2020年09月29日 16:34:02.865', '2020年09月29日 16:34:02.865', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('6620d35d25314ba6899e2ee4e0d53b99', '0247371b6b1f4eab94e35edf6e78a564', '2020年09月29日 10:27:57.383', '2020年09月29日 10:27:57.383', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('22ad298ba0de4a7bae9883f64beb25a0', 'fbc51aa9d0714507850129fed35e7c8f', '2020年09月29日 10:27:39.054', '2020年09月29日 10:27:39.054', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('e99f20a1c888455693608ce453b09ffe', '62557c8475d2441f9be55d30f88a3140', '2020年09月29日 16:49:40.951', '2020年09月29日 16:49:40.951', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('21ad7a62568446089c4626c81f429a71', 'e354424736af47568699dabc7acbbe19', '2020年09月29日 16:49:46.782', '2020年09月29日 16:49:46.782', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('d01657eb081f4b7485a168c1e67e5069', '1fd3c39a6fa54cbab2ba57e8c9b2b3fc', '1', '2020年09月29日 16:33:45.593', NULL, NULL, NULL, NULL, '2020年09月29日 16:33:45.593', '2020年09月29日 16:33:45.593', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('b4e01a59ac434faa9d71f8a9fe8dab6f', 'a8a374661f8c4101a9083e17ad37cb66', '1', '2020年09月29日 16:34:02.9', NULL, NULL, NULL, NULL, '2020年09月29日 16:34:02.9', '2020年09月29日 16:34:02.9', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('4933b47df01b4c7cbeb2bad71a955315', 'a8a374661f8c4101a9083e17ad37cb66', '1', '2020年09月29日 16:34:02.906', NULL, NULL, NULL, NULL, '2020年09月29日 16:34:02.906', '2020年09月29日 16:34:02.906', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('c21de8edb5764789a102337a1f51ea85', '6620d35d25314ba6899e2ee4e0d53b99', '1', '2020年09月29日 16:45:02.516', NULL, NULL, NULL, '', '2020年09月29日 16:45:02.516', '2020年09月29日 16:45:02.516', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('c21de8edb5764789a102337a1f51ea85', '22ad298ba0de4a7bae9883f64beb25a0', '1', '2020年09月29日 16:45:10.509', NULL, NULL, NULL, '508439e89a6749b28f649c5612435a8f', '2020年09月29日 16:45:10.509', '2020年09月29日 16:45:10.509', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('d01657eb081f4b7485a168c1e67e5069', '1', '数据迁移多卡门禁_多卡用户组', NULL, '1', '1', '0', '3', '2020年09月29日 16:33:45.58', '2020年09月29日 16:33:45.58', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '3');
INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('b4e01a59ac434faa9d71f8a9fe8dab6f', '1', '数据迁移首卡门禁_首卡用户组', NULL, '1', '1', '0', '2', '2020年09月29日 16:34:02.884', '2020年09月29日 16:34:02.884', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('4933b47df01b4c7cbeb2bad71a955315', '1', '数据迁移首卡门禁_首卡普通用户组', NULL, '1', '1', '0', '0', '2020年09月29日 16:34:02.889', '2020年09月29日 16:34:02.889', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('c21de8edb5764789a102337a1f51ea85', '1', '数据迁移测试用户组', '', '1', '1', '0', '0', '2020年09月29日 16:35:21.304', '2020年09月29日 16:35:21.304', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);

INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('c21de8edb5764789a102337a1f51ea85', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020年09月29日 16:47:57.046', '2020年09月29日 16:47:57.046', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('d01657eb081f4b7485a168c1e67e5069', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020年09月29日 16:52:12.918', '2020年09月29日 16:52:12.918', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('d01657eb081f4b7485a168c1e67e5069', '677b0a2f5c7748a78346a4a41abf4562', '2020年09月29日 16:52:56.469', '2020年09月29日 16:52:56.469', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('b4e01a59ac434faa9d71f8a9fe8dab6f', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020年09月29日 16:53:06.781', '2020年09月29日 16:53:06.781', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('4933b47df01b4c7cbeb2bad71a955315', '677b0a2f5c7748a78346a4a41abf4562', '2020年09月29日 16:53:10.231', '2020年09月29日 16:53:10.231', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('4933b47df01b4c7cbeb2bad71a955315', '2f017477e62d476faa3e296735640154', '2020年09月30日 10:08:38.818', '2020年09月30日 10:08:38.818', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."cm_card_info" ("card_id", "card_sn", "card_no", "card_type", "card_state", "close_type", "close_flag", "valid_start_time", "valid_end_time", "enter_time", "close_time", "bind_sn", "user_id", "last_bind_time", "last_unbind_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('6561FB42', '6561FB42', '007E414B', '2', '3', '0', '0', '2020年08月19日 00:00:00', '2050年01月01日 00:00:00', '2020年08月19日 15:40:16.274', NULL, '1018', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020年09月29日 16:46:16.818', '2020年09月29日 16:21:40.534', '2020年08月19日 15:40:10.662198', '2020年09月29日 16:46:10.364216', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_info" ("card_id", "card_sn", "card_no", "card_type", "card_state", "close_type", "close_flag", "valid_start_time", "valid_end_time", "enter_time", "close_time", "bind_sn", "user_id", "last_bind_time", "last_unbind_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('655C4912', '655C4912', '0063E56C', '2', '3', '0', '0', '2020年08月19日 00:00:00', '2050年01月01日 00:00:00', '2020年08月19日 15:40:36.696', NULL, '1015', '677b0a2f5c7748a78346a4a41abf4562', '2020年09月29日 16:46:30.985', '2020年08月21日 15:24:35.974', '2020年08月19日 15:40:31.036245', '2020年09月29日 16:46:24.456778', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_info" ("card_id", "card_sn", "card_no", "card_type", "card_state", "close_type", "close_flag", "valid_start_time", "valid_end_time", "enter_time", "close_time", "bind_sn", "user_id", "last_bind_time", "last_unbind_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('656392E2', '656392E2', '0042A3E3', '2', '3', '0', '0', '2020年08月19日 00:00:00', '2050年01月01日 00:00:00', '2020年08月19日 15:41:15.641', NULL, '1017', 'daedc82e6c214357a90e5bf5f3e358bf', '2020年09月29日 16:46:41.223', '2020年09月29日 16:21:47.624', '2020年08月19日 15:41:09.89066', '2020年09月29日 16:46:34.671704', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."cm_card_bind" ("card_id", "card_no", "card_type", "bind_state", "bind_sn", "apply_sn", "apply_time", "user_id", "bind_time", "unbind_time", "unbind_reason_type", "unbind_remark", "p_user_type", "p_user_name", "p_user_sex", "p_employ_id", "p_dept_id", "p_dept_name", "p_company_name", "p_phone_no", "p_iden_type", "p_iden_num", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('6561FB42', '007E414B', '2', '3', '1018', 'd70f08aec4f24998b545426e99315ff6', '2020年09月29日 16:46:13.732', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020年09月29日 16:46:16.818', NULL, NULL, NULL, '2', '数据迁移测试人员1', '1', '123654', 'b16e28c4303f4b0798d7eec182f4b36d', '测试', '测试', '13666666666', NULL, NULL, '2020年09月29日 16:46:13.732', '2020年09月29日 16:46:10.364216', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_bind" ("card_id", "card_no", "card_type", "bind_state", "bind_sn", "apply_sn", "apply_time", "user_id", "bind_time", "unbind_time", "unbind_reason_type", "unbind_remark", "p_user_type", "p_user_name", "p_user_sex", "p_employ_id", "p_dept_id", "p_dept_name", "p_company_name", "p_phone_no", "p_iden_type", "p_iden_num", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('655C4912', '0063E56C', '2', '3', '1015', '7447a2157c7145018e4426f08f3221f3', '2020年09月29日 16:46:27.833', '677b0a2f5c7748a78346a4a41abf4562', '2020年09月29日 16:46:30.985', NULL, NULL, NULL, '2', '数据迁移测试人员2', '1', '132987', 'b16e28c4303f4b0798d7eec182f4b36d', '测试', '测试', '13888888888', NULL, NULL, '2020年09月29日 16:46:27.833', '2020年09月29日 16:46:24.456778', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_bind" ("card_id", "card_no", "card_type", "bind_state", "bind_sn", "apply_sn", "apply_time", "user_id", "bind_time", "unbind_time", "unbind_reason_type", "unbind_remark", "p_user_type", "p_user_name", "p_user_sex", "p_employ_id", "p_dept_id", "p_dept_name", "p_company_name", "p_phone_no", "p_iden_type", "p_iden_num", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('656392E2', '0042A3E3', '2', '3', '1017', 'e22d598971a940cd8a8c59ba79e82c52', '2020年09月29日 16:46:38.077', 'daedc82e6c214357a90e5bf5f3e358bf', '2020年09月29日 16:46:41.223', NULL, NULL, NULL, '4', '数据迁移测试人员3', '1', NULL, NULL, NULL, '测试', '13765454545', '', '', '2020年09月29日 16:46:38.077', '2020年09月29日 16:46:34.671704', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_time_template" ("template_id", "template_type", "template_name", "template_remark", "date_type", "update_sn", "shift_days", "time_segments", "valid_flag", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('508439e89a6749b28f649c5612435a8f', '0', '数据迁移测试时效组', NULL, '1', '1000', NULL, '[{"endDay":"2020年09月30日","startDay":"2020年09月28日","week8SegList":["1000","1400"]}]', '1', '2020年09月29日 16:38:58.086629', '2020年09月29日 16:38:58.086629', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_time_template_device_mp" ("template_id", "bind_device_id", "bind_device_type", "bind_sn", "gateway_id", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "read_result_code", "read_value", "read_last_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('508439e89a6749b28f649c5612435a8f', '101520090090C2867E63', '1', '1', '2', '101520090090C2867E63', '四门门禁222', NULL, NULL, '0', NULL, NULL, '2020年09月29日 16:45:04.209066', '2020年09月29日 16:45:04.209066', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

一键复制编辑原始数据按行查看历史

sanri1993 提交于 2020年10月13日 11:47 +08:00 . 解释 redis 分布式锁为什么要用 lua 脚本

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65

INSERT INTO "uam"."visitor_info" ("visitor_id", "visitor_type", "visitor_name", "visitor_sex", "identity_type", "identity_no", "phone_no", "company_name", "visit_reason", "visit_count", "target_user_id", "target_user_name", "visitor_car_no", "visit_org_id", "visit_org_name", "checkin_time", "visit_start_time", "visit_end_time", "visit_state", "deposit_amt", "deposit_flag", "remark", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('daedc82e6c214357a90e5bf5f3e358bf', '0', '数据迁移测试人员3', '1', '', '', '13765454545', '测试', '测试', '1', '', '测试', '', '', NULL, '2020-09-29 16:41:59.488', '2020-09-29 00:00:00', '2020-10-01 00:00:00', '1', NULL, '1', '来访', '2020-09-29 16:41:59.488', '2020-09-29 16:41:59.488', '测试用户test(系统联调用 不能删除)', 'test', '1', '7b4bfc3216424db390618ee349f84bb7');


INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('0247371b6b1f4eab94e35edf6e78a564', '0247371b6b1f4eab94e35edf6e78a564', '数据迁移测试1', '0', '', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 10:26:14.142', '2020-09-29 10:26:14.142', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '0');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('fbc51aa9d0714507850129fed35e7c8f', 'fbc51aa9d0714507850129fed35e7c8f', '数据迁移测试2', '0', '', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 10:26:30.788', '2020-09-29 10:26:30.788', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '0');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('27ad988e97f9454eab4019d482a241c2', '27ad988e97f9454eab4019d482a241c2', '数据迁移多卡门禁', '1', '', '', '1', '3', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 16:33:45.539', '2020-09-29 16:33:45.539', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('8f513295c84143bfb433cff1c977269b', '8f513295c84143bfb433cff1c977269b', '数据迁移首卡门禁', '1', '', '', '1', '2', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 16:34:02.831', '2020-09-29 16:34:02.831', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_door_info" ("door_id", "door_no", "door_name", "door_type", "door_remark", "door_address", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "card_num") VALUES ('62557c8475d2441f9be55d30f88a3140', '62557c8475d2441f9be55d30f88a3140', '数据迁移测试3', '0', '', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 16:43:10.754', '2020-09-29 16:43:10.754', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '0');


INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C2867E630001', '2', '2', '0247371b6b1f4eab94e35edf6e78a564', '101520090090C2867E63', '四门门禁222', '30160090C2867E630001', '222门禁1号门', '0', '0', '1', '2020-09-29 16:30:11.142', '2020-09-29 16:30:11.142', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C28675160001', '2', '2', '8f513295c84143bfb433cff1c977269b', '101520090090C2867516', '双门控制器221', '30160090C28675160001', '双门221控制器1号读头', '0', '2', '1', '2020-09-29 16:37:11.141', '2020-09-29 16:37:11.141', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C28675160002', '2', '2', '27ad988e97f9454eab4019d482a241c2', '101520090090C2867516', '双门控制器221', '30160090C28675160002', '双门221控制器2号读头', '0', '3', '1', '2020-09-29 16:37:19.725', '2020-09-29 16:37:19.725', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C2867E630002', '2', '2', 'fbc51aa9d0714507850129fed35e7c8f', '101520090090C2867E63', '四门门禁222', '30160090C2867E630002', '222门禁2号门', '0', '0', '1', '2020-09-29 16:43:31.215', '2020-09-29 16:43:31.215', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_device_bind_door" ("bind_device_id", "bind_device_type", "gateway_id", "door_no", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "pass_type", "verify_mode", "cad_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('30160090C2867E630003', '2', '2', '62557c8475d2441f9be55d30f88a3140', '101520090090C2867E63', '四门门禁222', '30160090C2867E630003', '222门禁3号门', '0', '0', '1', '2020-09-29 16:43:37.46', '2020-09-29 16:43:37.46', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');


INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('6620d35d25314ba6899e2ee4e0d53b99', '数据迁移测试1组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 10:26:58.511', '2020-09-29 16:49:09.842', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);
INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('22ad298ba0de4a7bae9883f64beb25a0', '数据迁移测试2组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 10:27:16.178', '2020-09-29 16:49:14.026', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);
INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('e99f20a1c888455693608ce453b09ffe', '数据迁移测试3组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 16:49:27.749', '2020-09-29 16:49:27.749', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);
INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('21ad7a62568446089c4626c81f429a71', '数据迁移测试4组', '', '1', '0', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 16:49:35.608', '2020-09-29 16:49:35.608', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);

INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('1fd3c39a6fa54cbab2ba57e8c9b2b3fc', '数据迁移多卡门禁_多卡门禁组', NULL, '1', '3', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 16:33:45.561', '2020-09-29 16:33:45.561', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '3');


INSERT INTO "uam"."uam_doorgroup_info" ("doorgroup_id", "doorgroup_name", "doorgroup_remark", "valid_flag", "open_type", "org_type", "org_id", "org_name", "level0_id", "level1_id", "level2_id", "level3_id", "level4_id", "level5_id", "level6_id", "level7_id", "level8_id", "level9_id", "level10_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('a8a374661f8c4101a9083e17ad37cb66', '数据迁移首卡门禁_首卡门禁组', NULL, '1', '2', '1', '54ec868a3e6b4d3794aa08340b11f39f', '海花岛', 'c69aeede4f63sthhd721e28988hengda', '54ec868a3e6b4d3794aa08340b11f39f', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-09-29 16:34:02.862', '2020-09-29 16:34:02.862', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');

INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('1fd3c39a6fa54cbab2ba57e8c9b2b3fc', '27ad988e97f9454eab4019d482a241c2', '2020-09-29 16:33:45.566', '2020-09-29 16:33:45.566', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('a8a374661f8c4101a9083e17ad37cb66', '8f513295c84143bfb433cff1c977269b', '2020-09-29 16:34:02.865', '2020-09-29 16:34:02.865', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('6620d35d25314ba6899e2ee4e0d53b99', '0247371b6b1f4eab94e35edf6e78a564', '2020-09-29 10:27:57.383', '2020-09-29 10:27:57.383', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('22ad298ba0de4a7bae9883f64beb25a0', 'fbc51aa9d0714507850129fed35e7c8f', '2020-09-29 10:27:39.054', '2020-09-29 10:27:39.054', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('e99f20a1c888455693608ce453b09ffe', '62557c8475d2441f9be55d30f88a3140', '2020-09-29 16:49:40.951', '2020-09-29 16:49:40.951', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_doorgroup_door_mp" ("doorgroup_id", "door_no", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('21ad7a62568446089c4626c81f429a71', 'e354424736af47568699dabc7acbbe19', '2020-09-29 16:49:46.782', '2020-09-29 16:49:46.782', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('d01657eb081f4b7485a168c1e67e5069', '1fd3c39a6fa54cbab2ba57e8c9b2b3fc', '1', '2020-09-29 16:33:45.593', NULL, NULL, NULL, NULL, '2020-09-29 16:33:45.593', '2020-09-29 16:33:45.593', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('b4e01a59ac434faa9d71f8a9fe8dab6f', 'a8a374661f8c4101a9083e17ad37cb66', '1', '2020-09-29 16:34:02.9', NULL, NULL, NULL, NULL, '2020-09-29 16:34:02.9', '2020-09-29 16:34:02.9', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('4933b47df01b4c7cbeb2bad71a955315', 'a8a374661f8c4101a9083e17ad37cb66', '1', '2020-09-29 16:34:02.906', NULL, NULL, NULL, NULL, '2020-09-29 16:34:02.906', '2020-09-29 16:34:02.906', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('c21de8edb5764789a102337a1f51ea85', '6620d35d25314ba6899e2ee4e0d53b99', '1', '2020-09-29 16:45:02.516', NULL, NULL, NULL, '', '2020-09-29 16:45:02.516', '2020-09-29 16:45:02.516', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_doorgroup_mp" ("usergroup_id", "doorgroup_id", "grant_flag", "grant_time", "revoke_time", "auth_start_time", "auth_end_time", "time_template_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('c21de8edb5764789a102337a1f51ea85', '22ad298ba0de4a7bae9883f64beb25a0', '1', '2020-09-29 16:45:10.509', NULL, NULL, NULL, '508439e89a6749b28f649c5612435a8f', '2020-09-29 16:45:10.509', '2020-09-29 16:45:10.509', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');


INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('d01657eb081f4b7485a168c1e67e5069', '1', '数据迁移多卡门禁_多卡用户组', NULL, '1', '1', '0', '3', '2020-09-29 16:33:45.58', '2020-09-29 16:33:45.58', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '3');
INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('b4e01a59ac434faa9d71f8a9fe8dab6f', '1', '数据迁移首卡门禁_首卡用户组', NULL, '1', '1', '0', '2', '2020-09-29 16:34:02.884', '2020-09-29 16:34:02.884', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('4933b47df01b4c7cbeb2bad71a955315', '1', '数据迁移首卡门禁_首卡普通用户组', NULL, '1', '1', '0', '0', '2020-09-29 16:34:02.889', '2020-09-29 16:34:02.889', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', '2');
INSERT INTO "uam"."uam_usergroup_info" ("usergroup_id", "usergroup_type", "usergroup_name", "usergroup_remark", "usergroup_flag", "valid_flag", "imt_user_type", "open_type", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid", "spec_flag") VALUES ('c21de8edb5764789a102337a1f51ea85', '1', '数据迁移测试用户组', '', '1', '1', '0', '0', '2020-09-29 16:35:21.304', '2020-09-29 16:35:21.304', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64', NULL);


INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('c21de8edb5764789a102337a1f51ea85', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020-09-29 16:47:57.046', '2020-09-29 16:47:57.046', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('d01657eb081f4b7485a168c1e67e5069', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020-09-29 16:52:12.918', '2020-09-29 16:52:12.918', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('d01657eb081f4b7485a168c1e67e5069', '677b0a2f5c7748a78346a4a41abf4562', '2020-09-29 16:52:56.469', '2020-09-29 16:52:56.469', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('b4e01a59ac434faa9d71f8a9fe8dab6f', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020-09-29 16:53:06.781', '2020-09-29 16:53:06.781', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('4933b47df01b4c7cbeb2bad71a955315', '677b0a2f5c7748a78346a4a41abf4562', '2020-09-29 16:53:10.231', '2020-09-29 16:53:10.231', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."uam_usergroup_user_mp" ("usergroup_id", "user_id", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('4933b47df01b4c7cbeb2bad71a955315', '2f017477e62d476faa3e296735640154', '2020-09-30 10:08:38.818', '2020-09-30 10:08:38.818', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."cm_card_info" ("card_id", "card_sn", "card_no", "card_type", "card_state", "close_type", "close_flag", "valid_start_time", "valid_end_time", "enter_time", "close_time", "bind_sn", "user_id", "last_bind_time", "last_unbind_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('6561FB42', '6561FB42', '007E414B', '2', '3', '0', '0', '2020-08-19 00:00:00', '2050-01-01 00:00:00', '2020-08-19 15:40:16.274', NULL, '1018', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020-09-29 16:46:16.818', '2020-09-29 16:21:40.534', '2020-08-19 15:40:10.662198', '2020-09-29 16:46:10.364216', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_info" ("card_id", "card_sn", "card_no", "card_type", "card_state", "close_type", "close_flag", "valid_start_time", "valid_end_time", "enter_time", "close_time", "bind_sn", "user_id", "last_bind_time", "last_unbind_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('655C4912', '655C4912', '0063E56C', '2', '3', '0', '0', '2020-08-19 00:00:00', '2050-01-01 00:00:00', '2020-08-19 15:40:36.696', NULL, '1015', '677b0a2f5c7748a78346a4a41abf4562', '2020-09-29 16:46:30.985', '2020-08-21 15:24:35.974', '2020-08-19 15:40:31.036245', '2020-09-29 16:46:24.456778', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_info" ("card_id", "card_sn", "card_no", "card_type", "card_state", "close_type", "close_flag", "valid_start_time", "valid_end_time", "enter_time", "close_time", "bind_sn", "user_id", "last_bind_time", "last_unbind_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('656392E2', '656392E2', '0042A3E3', '2', '3', '0', '0', '2020-08-19 00:00:00', '2050-01-01 00:00:00', '2020-08-19 15:41:15.641', NULL, '1017', 'daedc82e6c214357a90e5bf5f3e358bf', '2020-09-29 16:46:41.223', '2020-09-29 16:21:47.624', '2020-08-19 15:41:09.89066', '2020-09-29 16:46:34.671704', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."cm_card_bind" ("card_id", "card_no", "card_type", "bind_state", "bind_sn", "apply_sn", "apply_time", "user_id", "bind_time", "unbind_time", "unbind_reason_type", "unbind_remark", "p_user_type", "p_user_name", "p_user_sex", "p_employ_id", "p_dept_id", "p_dept_name", "p_company_name", "p_phone_no", "p_iden_type", "p_iden_num", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('6561FB42', '007E414B', '2', '3', '1018', 'd70f08aec4f24998b545426e99315ff6', '2020-09-29 16:46:13.732', 'ee7962e2d22245bfa77f1fee72fffbc1', '2020-09-29 16:46:16.818', NULL, NULL, NULL, '2', '数据迁移测试人员1', '1', '123654', 'b16e28c4303f4b0798d7eec182f4b36d', '测试', '测试', '13666666666', NULL, NULL, '2020-09-29 16:46:13.732', '2020-09-29 16:46:10.364216', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_bind" ("card_id", "card_no", "card_type", "bind_state", "bind_sn", "apply_sn", "apply_time", "user_id", "bind_time", "unbind_time", "unbind_reason_type", "unbind_remark", "p_user_type", "p_user_name", "p_user_sex", "p_employ_id", "p_dept_id", "p_dept_name", "p_company_name", "p_phone_no", "p_iden_type", "p_iden_num", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('655C4912', '0063E56C', '2', '3', '1015', '7447a2157c7145018e4426f08f3221f3', '2020-09-29 16:46:27.833', '677b0a2f5c7748a78346a4a41abf4562', '2020-09-29 16:46:30.985', NULL, NULL, NULL, '2', '数据迁移测试人员2', '1', '132987', 'b16e28c4303f4b0798d7eec182f4b36d', '测试', '测试', '13888888888', NULL, NULL, '2020-09-29 16:46:27.833', '2020-09-29 16:46:24.456778', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');
INSERT INTO "uam"."cm_card_bind" ("card_id", "card_no", "card_type", "bind_state", "bind_sn", "apply_sn", "apply_time", "user_id", "bind_time", "unbind_time", "unbind_reason_type", "unbind_remark", "p_user_type", "p_user_name", "p_user_sex", "p_employ_id", "p_dept_id", "p_dept_name", "p_company_name", "p_phone_no", "p_iden_type", "p_iden_num", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('656392E2', '0042A3E3', '2', '3', '1017', 'e22d598971a940cd8a8c59ba79e82c52', '2020-09-29 16:46:38.077', 'daedc82e6c214357a90e5bf5f3e358bf', '2020-09-29 16:46:41.223', NULL, NULL, NULL, '4', '数据迁移测试人员3', '1', NULL, NULL, NULL, '测试', '13765454545', '', '', '2020-09-29 16:46:38.077', '2020-09-29 16:46:34.671704', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_time_template" ("template_id", "template_type", "template_name", "template_remark", "date_type", "update_sn", "shift_days", "time_segments", "valid_flag", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('508439e89a6749b28f649c5612435a8f', '0', '数据迁移测试时效组', NULL, '1', '1000', NULL, '[{"endDay":"2020-09-30","startDay":"2020-09-28","week8SegList":["1000","1400"]}]', '1', '2020-09-29 16:38:58.086629', '2020-09-29 16:38:58.086629', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');

INSERT INTO "uam"."uam_time_template_device_mp" ("template_id", "bind_device_id", "bind_device_type", "bind_sn", "gateway_id", "ctrl_device_id", "ctrl_device_name", "sub_device_id", "sub_device_name", "read_result_code", "read_value", "read_last_time", "create_time", "update_time", "create_user", "update_user", "delete_flag", "court_uuid") VALUES ('508439e89a6749b28f649c5612435a8f', '101520090090C2867E63', '1', '1', '2', '101520090090C2867E63', '四门门禁222', NULL, NULL, '0', NULL, NULL, '2020-09-29 16:45:04.209066', '2020-09-29 16:45:04.209066', 'test', 'test', '1', 'hhdtrailsit201908090a70ab36ccb64');