-- **************************
-- ********表结构升级********
-- **************************

CREATE TABLE "public"."tk_configuration_content_node" (
  "id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
  "configuration_id" varchar(36) COLLATE "pg_catalog"."default",
  "content_id" varchar(36) COLLATE "pg_catalog"."default",
  "act_json" varchar COLLATE "pg_catalog"."default",
  "data_source_json" varchar COLLATE "pg_catalog"."default",
  "event_json" varchar COLLATE "pg_catalog"."default",
  "tenant_id" varchar(36) COLLATE "pg_catalog"."default",
  "create_time" timestamp(6),
  "creator" varchar(36) COLLATE "pg_catalog"."default",
  "updater" varchar(36) COLLATE "pg_catalog"."default",
  "update_time" timestamp(6),
  "remark" varchar(255) COLLATE "pg_catalog"."default",
  CONSTRAINT "tk_configuration_content_node_pkey" PRIMARY KEY ("id")
)
;

ALTER TABLE "public"."tk_configuration_content_node" OWNER TO "postgres";

COMMENT ON COLUMN "public"."tk_configuration_content_node"."id" IS '主键ID';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."configuration_id" IS '组态中心ID';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."content_id" IS '组态内容ID';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."act_json" IS '组态节点动画效果';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."data_source_json" IS '组态数据源信息';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."event_json" IS '组态数据交互信息';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."tenant_id" IS '租户ID';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."create_time" IS '创建时间';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."creator" IS '创建用户';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."updater" IS '更新用户';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."update_time" IS '更新时间';

COMMENT ON COLUMN "public"."tk_configuration_content_node"."remark" IS '备注';

ALTER TABLE "public"."tk_configuration_datasource" ADD COLUMN "source_option" varchar COLLATE "pg_catalog"."default";

COMMENT ON COLUMN "public"."tk_configuration_datasource"."source_option" IS '数据源配置选项';

ALTER TABLE "public"."tk_device_profile" ALTER COLUMN "create_time" SET NOT NULL;

ALTER TABLE "public"."tk_device_profile" ALTER COLUMN "script_id" TYPE varchar(80) COLLATE "pg_catalog"."default";

COMMENT ON COLUMN "public"."tk_device_profile"."script_id" IS '产品转换脚本ID,多个ID用逗号分隔';

ALTER TABLE "public"."tk_java_script" ALTER COLUMN "convert_js" TYPE varchar COLLATE "pg_catalog"."default";

ALTER TABLE "public"."tk_things_model" ALTER COLUMN "access_mode" TYPE varchar(2) COLLATE "pg_catalog"."default" USING "access_mode"::varchar(2);

COMMENT ON COLUMN "public"."tk_things_model"."access_mode" IS '读写模式："读" r  "读写" rw';











-- **************************
-- ********表数据同步********
-- **************************
INSERT INTO "public"."sys_dict"("id", "dict_name", "dict_code", "description", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('37c6db21-f929-4d15-a71d-6cfaab76b40d', '通知类型', 'notice_type', '通知类型', '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 17:38:13.818527', NULL, NULL);

INSERT INTO "public"."sys_dict"("id", "dict_name", "dict_code", "description", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('80f86144-338d-48f5-80b7-13119e6b12da', '告警级别', 'severity_type', '告警级别', '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 12:01:49.989586', NULL, NULL);

INSERT INTO "public"."sys_dict"("id", "dict_name", "dict_code", "description", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('dad0dcea-2b36-424a-a65b-1078ccc877c9', '消息类型', 'script_message_type', NULL, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-06-16 11:58:17.259612', NULL, NULL);

INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('19d126dc-333e-4b33-bfb6-ce54c0993177', '80f86144-338d-48f5-80b7-13119e6b12da', '危险', 'CRITICAL', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 12:02:18.701095', NULL, NULL);

INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('672e96f0-6c42-4e64-adc5-5e53a1444fb5', '80f86144-338d-48f5-80b7-13119e6b12da', '不确定', 'INDETERMINATE', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 12:03:18.901372', NULL, NULL);

INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('8586d7a9-dfcb-415e-a171-38e3ebb4b7b0', '80f86144-338d-48f5-80b7-13119e6b12da', '警告', 'WARNING', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 12:03:06.567356', NULL, NULL);

INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('9ee858bf-b924-4cc9-b3f7-39f3a460eb57', '37c6db21-f929-4d15-a71d-6cfaab76b40d', '公告', 'NOTICE', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 17:38:29.380841', NULL, NULL);

INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('a603b648-8e8b-4694-bc33-19f10bfc250e', '37c6db21-f929-4d15-a71d-6cfaab76b40d', '会议', 'MEETING', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 17:38:45.07564', '80808080-8080-8080-8080-808080808080', '2023-05-25 17:49:15.424983');

INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('ca248a98-6029-42cb-a7b2-09d62ecffe44', '80f86144-338d-48f5-80b7-13119e6b12da', '次要', 'MINOR', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 12:02:53.655325', NULL, NULL);

INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('d9f19fde-3f4d-4ce4-8c6c-ebdf350e1430', '80f86144-338d-48f5-80b7-13119e6b12da', '重要', 'MAJOR', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2023-05-25 12:02:37.671278', NULL, NULL);

UPDATE "public"."sys_dict_item" SET "dict_id" = '3baecba2-8f43-45a4-bde7-8820219f5f57', "item_text" = '读写', "item_value" = 'rw', "description" = '读写', "sort" = 1, "status" = 1, "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-10-17 17:39:08.907152', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-10-18 09:59:41.816932' WHERE "id" = '1f88aaed-c5a7-42b6-93ef-e053499b42da';

DELETE FROM "public"."sys_menu" WHERE "id" = '1bb5e46d-6ee9-4667-973c-a841d3af86c2';

DELETE FROM "public"."sys_menu" WHERE "id" = '29de73bd-ff21-4829-a36f-bc11e3914bfe';

DELETE FROM "public"."sys_menu" WHERE "id" = '35a5deff-e020-4e3d-b9e9-48daa7b0b681';

DELETE FROM "public"."sys_menu" WHERE "id" = '4a36f0b9-7bc1-42c2-8301-ca93177c28f6';

DELETE FROM "public"."sys_menu" WHERE "id" = '570ba89b-d333-47fb-b1ff-2630c1ec8aa0';

DELETE FROM "public"."sys_menu" WHERE "id" = 'a15854a2-48bf-470e-b89a-ad910b04f002';

DELETE FROM "public"."sys_menu" WHERE "id" = 'be91885d-a74e-4e1b-92ef-c95118b551f9';

DELETE FROM "public"."sys_menu" WHERE "id" = 'cb3cbbe5-74bc-4421-aecf-9e5f27985c03';

INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('014a38d7-8629-46af-bc79-12e5dba0c0af', 'e777f4bf-658f-42c2-ba1a-8b5950724b67', NULL, 'SYSADMIN', 'api:yt:js:update', '80808080-8080-8080-8080-808080808080', '2023-06-08 15:53:05.740445', NULL, NULL, '编辑TCP转换脚本', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"编辑TCP转换脚本","menuType":"2","status":"0"}', 6);

INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('27b7630b-9fce-4346-9609-b411343cc876', 'e777f4bf-658f-42c2-ba1a-8b5950724b67', NULL, 'SYSADMIN', 'api:yt:js:get', '80808080-8080-8080-8080-808080808080', '2023-06-08 15:54:39.727563', NULL, NULL, '详情TCP转换脚本', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"详情TCP转换脚本","menuType":"2","status":"0"}', 10);

INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('795ed0c2-b225-497b-a426-8c4472587e37', 'e777f4bf-658f-42c2-ba1a-8b5950724b67', NULL, 'SYSADMIN', 'api:yt:js:update:status', '80808080-8080-8080-8080-808080808080', '2023-06-08 15:55:13.141284', '80808080-8080-8080-8080-808080808080', '2023-06-08 15:57:40.476282', '修改状态TCP转换脚本', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"修改状态TCP转换脚本","menuType":"2","status":"0"}', 11);

INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('968ff43f-a5e8-47d7-85c9-611a4f3b258a', 'e777f4bf-658f-42c2-ba1a-8b5950724b67', NULL, 'SYSADMIN', 'api:yt:js:post', '80808080-8080-8080-8080-808080808080', '2023-06-08 15:52:36.227169', NULL, NULL, '新增TCP转换脚本', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"新增TCP转换脚本","menuType":"2","status":"0"}', 5);

INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('b34d0619-e9c0-49f5-ac8f-aa3a23da107c', 'e777f4bf-658f-42c2-ba1a-8b5950724b67', NULL, 'SYSADMIN', 'api:yt:js:test', '80808080-8080-8080-8080-808080808080', '2023-06-08 15:54:07.848961', NULL, NULL, '测试TCP转换脚本', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"测试TCP转换脚本","menuType":"2","status":"0"}', 9);

INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('eb7c5093-cb14-409e-8e78-f1f35744b417', 'e777f4bf-658f-42c2-ba1a-8b5950724b67', NULL, 'SYSADMIN', 'api:yt:js:delete', '80808080-8080-8080-8080-808080808080', '2023-06-08 15:53:46.390391', NULL, NULL, '删除TCP转换脚本', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"删除TCP转换脚本","menuType":"2","status":"0"}', 7);

UPDATE "public"."sys_menu" SET "parent_id" = '6beed0bb-df31-43c4-ae38-66c1a24de993', "path" = '/visual/board/detail/:boardId/:boardName?', "type" = 'SYSADMIN', "permission" = 'data:board:detail:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-08-30 10:11:53.247675', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-08-30 10:12:59.054', "name" = '看板详情', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/visual/board/detail/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:radar-chart-outlined","title":"看板详情","isLink":false,"menuType":"1","ignoreKeepAlive":false,"hideMenu":true,"status":"0"}', "sort" = 3 WHERE "id" = '23502e3a-0917-48d2-b100-444588415b0e';

UPDATE "public"."sys_menu" SET "parent_id" = 'a80f41f1-6f23-4eae-a49b-619bd809931b', "path" = '/device/localtion', "type" = 'SYSADMIN', "permission" = 'deviceManager:deviceLocation:list', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2021-11-19 14:50:45.468049', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2021-11-19 14:52:06.081274', "name" = 'routes.common.alarm.geographicPosition', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/device/localtion/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:environment-outlined","title":"routes.common.alarm.geographicPosition","isLink":false,"menuType":"1","hideMenu":false,"status":"0"}', "sort" = 2 WHERE "id" = '43ec2fff-7942-4b18-b384-b30843a0b315';

UPDATE "public"."sys_menu" SET "parent_id" = NULL, "path" = '/task', "type" = 'SYSADMIN', "permission" = 'task:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2023-04-10 10:46:17.668834', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2023-04-10 10:46:51.699475', "name" = '任务中心', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:tags-outlined","title":"任务中心","isLink":false,"menuType":"0","hideMenu":false,"status":"0"}', "sort" = 3 WHERE "id" = '57bf4ad7-7469-41a1-a484-e0480ee20de9';

UPDATE "public"."sys_menu" SET "parent_id" = '6beed0bb-df31-43c4-ae38-66c1a24de993', "path" = '/visual/board', "type" = 'SYSADMIN', "permission" = 'data:board:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-08-29 09:29:52.200649', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-08-29 09:30:16.538692', "name" = '看板', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/visual/board/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:pie-chart-outlined","title":"看板","isLink":false,"menuType":"1","ignoreKeepAlive":true,"hideMenu":false,"status":"0"}', "sort" = 2 WHERE "id" = '667ef6aa-42c2-4590-9dc1-13ecc78090ed';

UPDATE "public"."sys_menu" SET "parent_id" = NULL, "path" = '/data', "type" = 'SYSADMIN', "permission" = 'visual:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-08-29 09:28:17.629823', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-08-29 09:29:00.204536', "name" = '可视化', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:dashboard-outlined","title":"可视化","isLink":false,"menuType":"0","hideMenu":false,"status":"0"}', "sort" = 0 WHERE "id" = '6beed0bb-df31-43c4-ae38-66c1a24de993';

UPDATE "public"."sys_menu" SET "parent_id" = NULL, "path" = '/report', "type" = 'SYSADMIN', "permission" = 'statement:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-07-25 17:07:51.812462', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-07-25 17:08:24.429698', "name" = '数据中心', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:bar-chart-outlined","title":"数据中心","isLink":false,"menuType":"0","hideMenu":false,"status":"0"}', "sort" = 4 WHERE "id" = '87553028-14bc-416c-add2-7d334b9f5040';

UPDATE "public"."sys_menu" SET "parent_id" = '6beed0bb-df31-43c4-ae38-66c1a24de993', "path" = '/dataview', "type" = 'SYSADMIN', "permission" = 'dataview:center:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2023-02-28 09:34:28.486475', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2023-02-28 10:16:15.279581', "name" = '大屏', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/dataview/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:fund-view-outlined","title":"大屏","isLink":true,"menuType":"1","ignoreKeepAlive":false,"hideMenu":false,"status":"0"}', "sort" = 0 WHERE "id" = '8abc0f43-6284-456e-9bb7-4d912525ab89';

UPDATE "public"."sys_menu" SET "parent_id" = 'a80f41f1-6f23-4eae-a49b-619bd809931b', "path" = '/operation/onlinerecord:deviceName?', "type" = 'SYSADMIN', "permission" = 'online:offline:record:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-12-22 15:02:20.087218', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-12-23 15:53:27.212377', "name" = '上下线记录', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/operation/onlinerecord/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:rise-outlined","title":"上下线记录","isLink":false,"menuType":"1","ignoreKeepAlive":false,"hideMenu":false,"status":"0"}', "sort" = 1 WHERE "id" = '96f869c9-ac69-46d5-a8d2-ee68591d4088';

UPDATE "public"."sys_menu" SET "parent_id" = NULL, "path" = '/operation', "type" = 'SYSADMIN', "permission" = 'operation:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-10-25 16:31:17.708456', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-10-25 16:31:25.896932', "name" = '监控运维', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:mac-command-outlined","title":"监控运维","isLink":false,"menuType":"0","hideMenu":false,"status":"0"}', "sort" = 38 WHERE "id" = 'a80f41f1-6f23-4eae-a49b-619bd809931b';

UPDATE "public"."sys_menu" SET "parent_id" = 'a8ffa8c5-637e-471b-a9e6-b60cebe95713', "path" = '/log', "type" = 'SYSADMIN', "permission" = 'log:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-06-15 09:16:58.176757', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-06-16 14:17:05.65042', "name" = '日志管理', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/system/log/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:file-text-outlined","title":"日志管理","isLink":false,"menuType":"1","ignoreKeepAlive":false,"hideMenu":false,"status":"0"}', "sort" = 10 WHERE "id" = 'aeaf0364-8a4b-4ced-8751-a652b6173fa4';

UPDATE "public"."sys_menu" SET "parent_id" = 'a8ffa8c5-637e-471b-a9e6-b60cebe95713', "path" = '/stationnotification', "type" = 'SYSADMIN', "permission" = 'platform:notice:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2021-12-14 10:09:25.680135', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2021-12-27 09:49:28.572994', "name" = 'routes.common.notice.webSiteNotice', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:notification-outlined","title":"routes.common.notice.webSiteNotice","isLink":false,"menuType":"0","hideMenu":false,"status":"0"}', "sort" = 0 WHERE "id" = 'b9a65fb9-4930-49d7-94de-b25cce41aba4';

UPDATE "public"."sys_menu" SET "parent_id" = 'a80f41f1-6f23-4eae-a49b-619bd809931b', "path" = '/config', "type" = 'SYSADMIN', "permission" = 'message:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2021-09-27 14:15:48.087676', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2021-09-28 14:44:41.051908', "name" = 'routes.common.message.messageManagement', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = '', "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:message-outlined","title":"routes.common.message.messageManagement","menuType":"0","status":"0"}', "sort" = 4 WHERE "id" = 'c8e31d1f-81b2-4e70-9017-4a6d0c15e364';

UPDATE "public"."sys_menu" SET "parent_id" = NULL, "path" = '/camera', "type" = 'SYSADMIN', "permission" = 'video:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-04-19 18:48:40.098735', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-04-19 18:49:14.494104', "name" = '视频中心', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:video-camera-outlined","title":"视频中心","isLink":false,"menuType":"0","hideMenu":false,"status":"0"}', "sort" = 5 WHERE "id" = 'e1ac7fdb-1ff4-43a0-a59e-6d51d7e0d2d5';

UPDATE "public"."sys_menu" SET "parent_id" = 'b4b531c1-17a6-4fb9-b7cc-023b5b55fc45', "path" = '/rule/script', "type" = 'SYSADMIN', "permission" = 'mqtt:conversion:function', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-02-21 11:53:46.366348', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-02-24 11:08:25.525194', "name" = '脚本管理', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/rule/script/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:code-outlined","title":"脚本管理","isLink":false,"menuType":"1","ignoreKeepAlive":false,"hideMenu":false,"status":"0"}', "sort" = 3 WHERE "id" = 'e777f4bf-658f-42c2-ba1a-8b5950724b67';

UPDATE "public"."sys_menu" SET "parent_id" = 'a80f41f1-6f23-4eae-a49b-619bd809931b', "path" = '/alarm', "type" = 'SYSADMIN', "permission" = 'alarm:management:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2021-11-09 15:17:13.35272', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2021-11-09 15:17:32.549274', "name" = 'routes.common.alarm.alarmManagement', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = 'LAYOUT', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:alert-outlined","title":"routes.common.alarm.alarmManagement","isLink":false,"menuType":"1","hideMenu":false,"status":"0"}', "sort" = 0 WHERE "id" = 'ea0ce7af-87ff-4020-8891-9b57c8c305b4';

UPDATE "public"."sys_menu" SET "parent_id" = 'a80f41f1-6f23-4eae-a49b-619bd809931b', "path" = '/operation/ota', "type" = 'SYSADMIN', "permission" = 'ota:upgrade:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-10-25 16:32:05.955303', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-10-25 16:35:10.814092', "name" = 'OTA升级', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/operation/ota/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:reconciliation-outlined","title":"OTA升级","isLink":false,"menuType":"1","ignoreKeepAlive":false,"hideMenu":false,"status":"0"}', "sort" = 3 WHERE "id" = 'f0e67448-afae-4d67-8025-9f0e7103cdbb';

UPDATE "public"."sys_menu" SET "parent_id" = '6beed0bb-df31-43c4-ae38-66c1a24de993', "path" = '/configuration/center', "type" = 'SYSADMIN', "permission" = 'configuration:center:view', "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2022-04-06 10:16:07.12519', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2022-04-06 10:17:20.832043', "name" = '组态', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "component" = '/configuration/center/index', "redirect" = NULL, "alias" = NULL, "case_sensitive" = NULL, "meta" = '{"icon":"ant-design:fund-projection-screen-outlined","title":"组态","isLink":false,"menuType":"1","ignoreKeepAlive":false,"hideMenu":false,"status":"0"}', "sort" = 1 WHERE "id" = 'f20f14a3-3b01-414d-831f-63d0f5bab337';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = '1bb5e46d-6ee9-4667-973c-a841d3af86c2';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = '29de73bd-ff21-4829-a36f-bc11e3914bfe';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = '35a5deff-e020-4e3d-b9e9-48daa7b0b681';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = '4a36f0b9-7bc1-42c2-8301-ca93177c28f6';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = '570ba89b-d333-47fb-b1ff-2630c1ec8aa0';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = 'a15854a2-48bf-470e-b89a-ad910b04f002';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = 'be91885d-a74e-4e1b-92ef-c95118b551f9';

DELETE FROM "public"."sys_role_menu" WHERE "role_id" = '0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc' AND "menu_id" = 'cb3cbbe5-74bc-4421-aecf-9e5f27985c03';

INSERT INTO "public"."sys_role_menu"("role_id", "menu_id") VALUES ('0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc', '014a38d7-8629-46af-bc79-12e5dba0c0af');

INSERT INTO "public"."sys_role_menu"("role_id", "menu_id") VALUES ('0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc', '27b7630b-9fce-4346-9609-b411343cc876');

INSERT INTO "public"."sys_role_menu"("role_id", "menu_id") VALUES ('0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc', '795ed0c2-b225-497b-a426-8c4472587e37');

INSERT INTO "public"."sys_role_menu"("role_id", "menu_id") VALUES ('0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc', '968ff43f-a5e8-47d7-85c9-611a4f3b258a');

INSERT INTO "public"."sys_role_menu"("role_id", "menu_id") VALUES ('0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc', 'b34d0619-e9c0-49f5-ac8f-aa3a23da107c');

INSERT INTO "public"."sys_role_menu"("role_id", "menu_id") VALUES ('0644c9e0-0e03-42c5-9a7f-bc2eea2b13dc', 'eb7c5093-cb14-409e-8e78-f1f35744b417');

INSERT INTO "public"."sys_role_menu"("role_id", "menu_id") VALUES ('81818181-8181-8181-8181-818181818181', 'a80f41f1-6f23-4eae-a49b-619bd809931b');

INSERT INTO "public"."tk_data_view_interface"("id", "interface_name", "request_content_type", "request_origin_url", "request_http_type", "request_url", "request_params", "state", "creator", "create_time", "updater", "update_time", "tenant_id", "remark", "interface_type", "filter") VALUES ('3a358c23-5486-4ca7-a075-acaab6000ea5', '设备占比（脚本适合饼图）', 0, 'localhost', 'GET', '/api/yt/homepage/left/top', '{"requestSQLContent":{},"Params":[],"Header":[{"key":"ContentType","value":"none","required":false}]}', 1, '80808080-8080-8080-8080-808080808080', '2023-07-06 18:13:38.225479', '80808080-8080-8080-8080-808080808080', '2023-07-07 21:29:49.530185', '13814000-1dd2-11b2-8080-808080808080', NULL, 'SYSTEM', '//获取设备信息
const {
  deviceInfo
} = res
const dimensions = ["product", "data"]

//排除keys
const excludeKeys = [
  "sumCount",
  "gateWay",
  "directConnection",
  "sensor",
  "todayAdd",
]


excludeKeys.forEach((item)=> {
  for (let i in deviceInfo) {
    if (item === i) {
      Reflect.deleteProperty(deviceInfo, i)
    }
  }
})

//格式化成中文
const transText = (value)=> {
  return value === ''onLine'' ?''在线'': value === ''offLine''? ''离线'': ''待激活''
}

const source = Object.keys(deviceInfo).map((item)=> {
  return {
    product: transText(item),
    data: deviceInfo[item]
  }
})

//返回图表所需要的格式
return {
  dimensions,
  source
}');

INSERT INTO "public"."tk_data_view_interface"("id", "interface_name", "request_content_type", "request_origin_url", "request_http_type", "request_url", "request_params", "state", "creator", "create_time", "updater", "update_time", "tenant_id", "remark", "interface_type", "filter") VALUES ('3cf86107-5973-4246-b915-2eda1f3e7cf6', '实时单属性值(适合自定义文字)', 2, 'localhost', NULL, '/api/ws/plugins/telemetry', '{"requestSQLContent":{},"Params":[{"key":"deviceProfileId,organizationId,entityId,keys","value":"","mores":null,"editDisabled":true,"required":true}]}', 1, '80808080-8080-8080-8080-808080808080', '2023-07-08 10:27:53.643059', '80808080-8080-8080-8080-808080808080', '2023-07-08 10:33:29.088113', '13814000-1dd2-11b2-8080-808080808080', NULL, 'SYSTEM', 'const {
  data
} = res

//只有一个属性的脚本编写

//获取服务端返回的keys,比如温度等
const keys = Object.keys(data)

//把二维数组转化为对象
const transObj = Object.fromEntries(data[keys[0]])

const key = Object.keys(transObj)

return transObj[key[0]]');

INSERT INTO "public"."tk_data_view_interface"("id", "interface_name", "request_content_type", "request_origin_url", "request_http_type", "request_url", "request_params", "state", "creator", "create_time", "updater", "update_time", "tenant_id", "remark", "interface_type", "filter") VALUES ('67bc0c86-f966-47d3-a649-0ffba5103bf6', '实时数据（脚本适合实时折线图）', 2, 'localhost', NULL, '/api/ws/plugins/telemetry', '{"requestSQLContent":{},"Params":[{"key":"deviceProfileId,organizationId,entityId,keys","value":"","mores":null,"editDisabled":true,"required":true}]}', 1, '80808080-8080-8080-8080-808080808080', '2023-07-06 17:29:11.834974', '80808080-8080-8080-8080-808080808080', '2023-07-08 11:16:27.534735', '13814000-1dd2-11b2-8080-808080808080', NULL, 'SYSTEM', '//获取服务端返回的数据
const getData = res.data

//将二维数组成转数组对象
const transResToObj = Object.keys(getData).reduce((prev, item) => {
  const getObj = Object.fromEntries(getData[item])
  const transObj = Object.keys(getObj).map(item => ({
    ts: item, value: getObj[item]
  }))
  return {
    ...prev,
    [item]: transObj
  }
}, {})

//时间戳转日期
const formatDate = (value)=> {
  let date = new Date(value);

  let y = date.getFullYear(),
  m = date.getMonth() + 1,
  d = date.getDate(),
  h = date.getHours(),
  i = date.getMinutes(),
  s = date.getSeconds();

  if (m < 10) {
    m = ''0'' + m;

  }
  if (d < 10) {
    d = ''0'' + d;

  }
  if (h < 10) {
    h = ''0'' + h;

  }
  if (i < 10) {
    i = ''0'' + i;

  }
  if (s < 10) {
    s = ''0'' + s;

  }
  let t = y + ''-'' + m + ''-'' + d + '' '' + h + '':'' + i + '':'' + s;

  return t;

}

const keys = Object.keys(transResToObj)

//获取图表通用的dimensions
const dimensions = [''ts'', ...keys]

//获取图表x轴数据
const xAxis = [...keys.reduce((prev, next) => [...prev, ...transResToObj[next].map(item => item.ts)], [])].sort(
  (a, b) => a - b
)

//获取图表source
const source = xAxis.map(ts => {
  const record = keys.reduce((prev, next) => {
    const value = transResToObj[next].find(item => item.ts === ts)
    return {
      ...prev, [next]: value?.value || null
    }
  }, {})
  return {
    ts: formatDate(Number(ts)),
    ...record
  }
})

//返回图表需要的格式
return {
  dimensions,
  source
}');

INSERT INTO "public"."tk_data_view_interface"("id", "interface_name", "request_content_type", "request_origin_url", "request_http_type", "request_url", "request_params", "state", "creator", "create_time", "updater", "update_time", "tenant_id", "remark", "interface_type", "filter") VALUES ('e2d4af49-88c3-4d6a-9626-cdb2e0f5c214', '获取设备属性历史数据（脚本适合折线图）', 0, 'localhost', 'GET', '/api/plugins/telemetry/{entityType}/{entityId}/values/timeseries{?agg,endTs,interval,keys,limit,orderBy,startTs,endTs,useStrictDataTypes}', '{"requestSQLContent":{},"Params":[{"key":"scope","value":"entityType","mores":null,"editDisabled":false,"required":true},{"key":"date_range","value":"startTs,endTs","mores":true,"editDisabled":true,"required":false},{"key":"deviceProfileId,organizationId,entityId,keys","value":"","mores":null,"editDisabled":true,"required":false}],"Header":[{"key":"ContentType","value":"none","required":false}]}', 1, '80808080-8080-8080-8080-808080808080', '2023-07-06 17:28:20.870127', '80808080-8080-8080-8080-808080808080', '2023-07-07 21:30:00.604516', '13814000-1dd2-11b2-8080-808080808080', NULL, 'SYSTEM', '//res为服务端返回的数据
const keys = Object.keys(res)

//获取图表dimensions
const dimensions = [''ts'', ...keys]

//获取图表x轴
const xAxis = [...new Set(keys.reduce((prev, next) => [...prev, ...res[next].map(item => item.ts)], []))].sort((a, b) => a - b)

//时间戳转日期
const formatDate = (value)=> {
  let date = new Date(value);

  let y = date.getFullYear(),
  m = date.getMonth() + 1,
  d = date.getDate(),
  h = date.getHours(),
  i = date.getMinutes(),
  s = date.getSeconds();

  if (m < 10) {
    m = ''0'' + m;

  }
  if (d < 10) {
    d = ''0'' + d;

  }
  if (h < 10) {
    h = ''0'' + h;

  }
  if (i < 10) {
    i = ''0'' + i;

  }
  if (s < 10) {
    s = ''0'' + s;

  }
  let t = y + ''-'' + m + ''-'' + d + '' '' + h + '':'' + i + '':'' + s;

  return t;

}

//获取图表source
const source = xAxis.map(ts => {
  const record = keys.reduce((prev, next) => {
    const value = res[next].find(item => item.ts === ts)
    return {
      ...prev, [next]: String(Number(value.value).toFixed(2)) || null
    }
  }, {})

  return {
    ts: formatDate(ts),
    ...record
  }
})

//返回图表需要的数据格式
return {
  dimensions,
  source
}');

INSERT INTO "public"."tk_java_script"("id", "name", "convert_js", "tenant_id", "create_time", "creator", "updater", "update_time", "status", "description", "data_type", "save_original_data", "script_type") VALUES ('117de211-9cc8-43ab-b22c-c665f3dea11c', '数据携带modbus网关设备默认脚本(令牌长度20)', '/*网关上行脚本*/
var teleData = {};
/*物模型数据(可选)：原始数据*/
teleData.source = params;
/*网关设备：slaveDevice是网关子设备的“设备标识”*/
slaveDevice = params.substr(2*20, 2);
teleData[slaveDevice] = params;
out.datas = teleData;
out.telemetry = true;
/*必填：true表示设备上报的遥测数据，false表示命令下发的响应数据*/', '13814000-1dd2-11b2-8080-808080808080', NULL, '75729a93-0fc9-4e91-ace4-50eb083257ca', '13814000-1dd2-11b2-8080-808080808080', NULL, 1, '', NULL, 'f', 'TRANSPORT_TCP_UP');

INSERT INTO "public"."tk_java_script"("id", "name", "convert_js", "tenant_id", "create_time", "creator", "updater", "update_time", "status", "description", "data_type", "save_original_data", "script_type") VALUES ('a524234c-6e03-427a-b9d9-adc47f497ed8', '数据携带直连、网关子设备默认采集脚本(令牌长度20)', '/*params为TCP上报的标准ModBus数据,实际使用或测试时请删除*/
var teleData = {};
/*物模型数据(可选)：原始数据*/
teleData.source = params;
/*直连设备：tempVal是产品物模型中所定义属性的标识符*/
tempVal = params.substr(2*20);
teleData.data = tempVal;
/*物模型温度标识符*/
teleData.temperature = (parseInt(''0x''+tempVal.substr(10, 4))*0.1).toFixed(2);
/*物模型湿度标识符*/
teleData.humidity = (parseInt(''0x''+tempVal.substr(6, 4))*0.1).toFixed(2);
out.datas = teleData;
/*必填：true表示设备上报的遥测数据，false表示命令下发的响应数据*/
out.telemetry = true;', '13814000-1dd2-11b2-8080-808080808080', NULL, '75729a93-0fc9-4e91-ace4-50eb083257ca', '13814000-1dd2-11b2-8080-808080808080', NULL, 1, '', NULL, 'f', 'TRANSPORT_TCP_UP');

INSERT INTO "public"."tk_java_script"("id", "name", "convert_js", "tenant_id", "create_time", "creator", "updater", "update_time", "status", "description", "data_type", "save_original_data", "script_type") VALUES ('c59b6bca-d026-4fb4-9d9c-e106b74ca215', '数据携带默认鉴权(令牌长度20)', '/*必填：设备的访问令牌*/
var val = "";
for (var i = 0;
  i < 20;
  i++) {
  val += String.fromCharCode(parseInt(params.substr(i*2, 2), 16));
}
out.password = val;
/*选填：设备鉴权成功后响应给设备的信息
out.success = params;
*/', '13814000-1dd2-11b2-8080-808080808080', NULL, '75729a93-0fc9-4e91-ace4-50eb083257ca', '13814000-1dd2-11b2-8080-808080808080', NULL, 1, '', NULL, 'f', 'TRANSPORT_TCP_AUTH');









-- ****************************
-- ********业务功能升级********
-- ****************************



------------------------------------------------------------------------------------
---------【租户角色对应菜单同步】---------------------------------------------------------------
------------------------------------------------------------------------------------
-- 租户角色不能分配超级管理员的权限