INSERT INTO blade_menu(id, parent_id, code, name, alias, path, source, sort,
|
category, action, is_open, remark, is_deleted, belong_application, keep_alive)
|
VALUES (1123598815738675201, 0, 'desk', '工作台', 'desk', '/console/desk', 'iconfont saber-gongzuotai', 1, 0, 0, 1,
|
NULL, 0, 'CPS', 1);
|
|
DROP TABLE IF EXISTS "blade_workbench";
|
CREATE TABLE "blade_workbench"
|
(
|
"id" BIGINT NOT NULL,
|
"status" TINYINT,
|
"is_deleted" INT,
|
"create_user" VARCHAR(255),
|
"create_dept" BIGINT,
|
"create_time" TIMESTAMP(0),
|
"update_user" BIGINT,
|
"update_time" TIMESTAMP(0),
|
"tenant_id" VARCHAR(12) DEFAULT '0',
|
"name" VARCHAR(128),
|
"sort" INT,
|
"picture_link" VARCHAR(255),
|
"is_system" INT DEFAULT 0,
|
"user_name" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("id")
|
) STORAGE(ON "MAIN", CLUSTERBTR);
|
|
COMMENT
|
ON TABLE "blade_workbench" IS '工作台';
|
COMMENT
|
ON COLUMN "blade_workbench"."create_dept" IS '创建部门';
|
COMMENT
|
ON COLUMN "blade_workbench"."create_time" IS '创建时间';
|
COMMENT
|
ON COLUMN "blade_workbench"."create_user" IS '创建人';
|
COMMENT
|
ON COLUMN "blade_workbench"."id" IS '主键';
|
COMMENT
|
ON COLUMN "blade_workbench"."is_deleted" IS '删除';
|
COMMENT
|
ON COLUMN "blade_workbench"."is_system" IS '是否自动生成';
|
COMMENT
|
ON COLUMN "blade_workbench"."name" IS '工作台名称';
|
COMMENT
|
ON COLUMN "blade_workbench"."picture_link" IS '图片展示';
|
COMMENT
|
ON COLUMN "blade_workbench"."sort" IS '排序';
|
COMMENT
|
ON COLUMN "blade_workbench"."status" IS '状态';
|
COMMENT
|
ON COLUMN "blade_workbench"."tenant_id" IS '租户';
|
COMMENT
|
ON COLUMN "blade_workbench"."update_time" IS '更新时间';
|
COMMENT
|
ON COLUMN "blade_workbench"."update_user" IS '更新人';
|
COMMENT
|
ON COLUMN "blade_workbench"."user_name" IS '创建人姓名';
|
|
|
DROP TABLE IF EXISTS "blade_workbench_card";
|
CREATE TABLE "blade_workbench_card"
|
(
|
"id" BIGINT NOT NULL,
|
"status" INT,
|
"is_deleted" INT,
|
"create_user" BIGINT,
|
"create_dept" BIGINT,
|
"create_time" TIMESTAMP(0),
|
"update_user" BIGINT,
|
"update_time" TIMESTAMP(0),
|
"tenant_id" VARCHAR(12),
|
"workbench_id" BIGINT,
|
"card_length" VARCHAR(64),
|
"card_wide" VARCHAR(64),
|
"x_coordinate" VARCHAR(64),
|
"y_coordinate" VARCHAR(64),
|
"card_key" VARCHAR(64),
|
"api_resource" TEXT,
|
"text_content" TEXT,
|
NOT CLUSTER PRIMARY KEY("id"),
|
CHECK ("status" >= 0)
|
) STORAGE(ON "MAIN", CLUSTERBTR);
|
|
COMMENT
|
ON TABLE "blade_workbench_card" IS '工作台卡片';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."api_resource" IS '接口api';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."card_key" IS '卡片key';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."card_length" IS '长';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."card_wide" IS '宽';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."create_dept" IS '创建部门';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."create_time" IS '创建时间';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."create_user" IS '创建人';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."id" IS '主键';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."status" IS '状态';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."tenant_id" IS '所属租户';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."text_content" IS '文本内容';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."update_time" IS '更新时间';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."update_user" IS '更新人';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."workbench_id" IS '工作台id';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."x_coordinate" IS 'x轴坐标';
|
COMMENT
|
ON COLUMN "blade_workbench_card"."y_coordinate" IS 'y轴坐标';
|
|
|
DROP TABLE IF EXISTS "blade_workbench_template";
|
CREATE TABLE "blade_workbench_template"
|
(
|
"id" BIGINT NOT NULL,
|
"name" VARCHAR(128),
|
"sort" INT,
|
"picture_link" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")
|
) STORAGE(ON "MAIN", CLUSTERBTR);
|
|
COMMENT
|
ON TABLE "blade_workbench_template" IS '工作台模板';
|
COMMENT
|
ON COLUMN "blade_workbench_template"."id" IS '主键';
|
COMMENT
|
ON COLUMN "blade_workbench_template"."name" IS '工作台名称';
|
COMMENT
|
ON COLUMN "blade_workbench_template"."picture_link" IS '图片展示';
|
COMMENT
|
ON COLUMN "blade_workbench_template"."sort" IS '排序';
|
|
|
DROP TABLE IF EXISTS "blade_workbench_template_card";
|
CREATE TABLE "blade_workbench_template_card"
|
(
|
"id" BIGINT NOT NULL,
|
"workbench_id" BIGINT,
|
"card_length" VARCHAR(255),
|
"card_wide" VARCHAR(255),
|
"x_coordinate" VARCHAR(255),
|
"y_coordinate" VARCHAR(255),
|
"card_key" VARCHAR(255),
|
"api_resource" TEXT,
|
NOT CLUSTER PRIMARY KEY("ID")
|
) STORAGE(ON "MAIN", CLUSTERBTR);
|
|
COMMENT
|
ON TABLE "blade_workbench_template_card" IS '工作台模板卡片';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."api_resource" IS '接口api';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."card_key" IS '卡片key';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."card_length" IS '长';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."card_wide" IS '宽';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."id" IS '主键';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."workbench_id" IS '工作台模板';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."x_coordinate" IS 'x轴坐标';
|
COMMENT
|
ON COLUMN "blade_workbench_template_card"."y_coordinate" IS 'y轴坐标';
|
|
|
INSERT INTO blade_workbench_template
|
VALUES (1506904783898030081, '欢迎使用', 1, NULL);
|
|
INSERT INTO blade_workbench_card(id, status, is_deleted, create_user, create_dept,
|
create_time, update_user, update_time, tenant_id,
|
workbench_id, card_length, card_wide, x_coordinate,
|
y_coordinate, card_key, api_resource, text_content)
|
VALUES (1508346412835901442, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-28 15:33:03', 1123598821738675201,
|
'2022-03-28 15:33:03', '000000', 1506904783898030081, '5', '3', '0', '0', 'Access', '', ''),
|
(1508346412848484354, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-28 15:33:03', 1123598821738675201,
|
'2022-03-28 15:33:03', '000000', 1506904783898030081, '5', '6', '3', '0', 'deskNotice', '', ''),
|
(1508346412852678657, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-28 15:33:03', 1123598821738675201,
|
'2022-03-28 15:33:03', '000000', 1506904783898030081, '5', '3', '9', '7', 'Entrance', '', ''),
|
(1508346412856872961, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-28 15:33:03', 1123598821738675201,
|
'2022-03-28 15:33:03', '000000', 1506904783898030081, '7', '3', '9', '0', 'Weather', '', ''),
|
(1508346412861067266, 1, 0, 1123598821738675201, 1123598813738675201, '2022-03-28 15:33:03', 1123598821738675201,
|
'2022-03-28 15:33:03', '000000', 1506904783898030081, '7', '9', '0', '5', 'Guide', '', '');
|
INSERT INTO blade_workbench(id, status, is_deleted, create_user, create_dept, create_time, update_user,
|
update_time, tenant_id, name, sort, picture_link, is_system, user_name)
|
VALUES (1506904783898030081, 1, 0, '1123598821738675201', 1123598813738675201, '2022-03-24 16:04:32', NULL, NULL,
|
'000000', '欢迎使用', 1, NULL, 1, '系统创建');
|
|
INSERT INTO blade_workbench_template_card
|
VALUES (1507258432602804225, 1506904783898030081, '5', '3', '0', '0', 'Access', NULL),
|
(1507258432602804226, 1506904783898030081, '5', '6', '3', '0', 'deskNotice', NULL),
|
(1507258432602804227, 1506904783898030081, '5', '3', '9', '7', 'Entrance', NULL),
|
(1507258432602804228, 1506904783898030081, '7', '9', '0', '5', 'Guide', NULL),
|
(1507258432665718785, 1506904783898030081, '7', '3', '9', '0', 'Weather', NULL);
|
