thingsKit_1.4.2_1.4.3.sql
2.33 KB
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
--组态内容节点,增加一个字段
alter table tk_configuration_content_node add configuration_node_id varchar(32);
COMMENT ON COLUMN "public"."tk_configuration_content_node"."configuration_node_id" IS '组态内容节点ID';
--更新已存在的数据
update tk_configuration_content_node set configuration_node_id = id;
--更新组态内容节点表的主键ID为uuid
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
update tk_configuration_content_node set id = uuid_generate_v4();
--添加3d组件的新表
DROP TABLE IF EXISTS "public"."tk_3d_component";
CREATE TABLE "public"."tk_3d_component" (
"id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
"creator" varchar(36) COLLATE "pg_catalog"."default",
"updater" varchar(36) COLLATE "pg_catalog"."default",
"tenant_id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
"create_time" timestamp(6),
"update_time" timestamp(6),
"name" varchar(128) COLLATE "pg_catalog"."default",
"state" int2,
"image_url" varchar(255) COLLATE "pg_catalog"."default",
"json_path" varchar(1024) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."tk_3d_component"."id" IS '主建';
COMMENT ON COLUMN "public"."tk_3d_component"."creator" IS '创建用户';
COMMENT ON COLUMN "public"."tk_3d_component"."updater" IS '更新用户';
COMMENT ON COLUMN "public"."tk_3d_component"."tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."tk_3d_component"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."tk_3d_component"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."tk_3d_component"."name" IS '名称';
COMMENT ON COLUMN "public"."tk_3d_component"."state" IS '状态:0创建，1发布';
COMMENT ON COLUMN "public"."tk_3d_component"."image_url" IS '图标';
-- ----------------------------
-- Primary Key structure for table tk_3d_component
-- ----------------------------
ALTER TABLE "public"."tk_3d_component" ADD CONSTRAINT "tk_3d_component_pkey" PRIMARY KEY ("id");