From 4b86cf6bbe5a7204a801169398fa836e8e06c109 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Wed, 14 Dec 2022 17:04:36 +0800
Subject: [PATCH] Merge remote-tracking branch 'refs/remotes/origin/master'
---
doc/sql/update/bladex-update-postgresql-3.0.0~3.0.1.sql | 171 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 171 insertions(+), 0 deletions(-)
diff --git a/doc/sql/update/bladex-update-postgresql-3.0.0~3.0.1.sql b/doc/sql/update/bladex-update-postgresql-3.0.0~3.0.1.sql
new file mode 100644
index 0000000..ffec8c2
--- /dev/null
+++ b/doc/sql/update/bladex-update-postgresql-3.0.0~3.0.1.sql
@@ -0,0 +1,171 @@
+-- -----------------------------------
+-- 给代码生成添加字段
+-- -----------------------------------
+ALTER TABLE "blade_code" RENAME COLUMN "datasource_id" TO "model_id";
+COMMENT ON COLUMN "blade_code"."model_id" IS '数据模型主键';
+
+-- -----------------------------------
+-- 新增 代码生成表字段类型
+-- -----------------------------------
+ALTER TABLE "blade_code"
+ ADD COLUMN "template_type" varchar(32),
+ ADD COLUMN "author" varchar(32),
+ ADD COLUMN "sub_model_id" varchar(32),
+ ADD COLUMN "sub_fk_id" varchar(32),
+ ADD COLUMN "tree_id" varchar(32),
+ ADD COLUMN "tree_pid" varchar(32),
+ ADD COLUMN "tree_name" varchar(64);
+
+COMMENT ON COLUMN "blade_code"."template_type" IS '模版类型';
+
+COMMENT ON COLUMN "blade_code"."author" IS '作者信息';
+
+COMMENT ON COLUMN "blade_code"."sub_model_id" IS '子表模型主键';
+
+COMMENT ON COLUMN "blade_code"."sub_fk_id" IS '子表绑定外键';
+
+COMMENT ON COLUMN "blade_code"."tree_id" IS '树主键字段';
+
+COMMENT ON COLUMN "blade_code"."tree_pid" IS '树父主键字段';
+
+COMMENT ON COLUMN "blade_code"."tree_name" IS '树名称字段';
+
+
+-- -----------------------------------
+-- 新增模型设计菜单
+-- -----------------------------------
+INSERT INTO "blade_menu"("id", "parent_id", "code", "name", "alias", "path", "source", "sort", "category", "action", "is_open", "component", "remark", "is_deleted") VALUES (1161272593873321996, 1123598815738675217, 'model', '数据模型设计', 'menu', '/tool/model', 'iconfont icon-biaodan', 3, 1, 0, 1, '', '', 0);
+
+-- -----------------------------------
+-- 新增 数据模型表
+-- -----------------------------------
+CREATE TABLE "blade_model" (
+ "id" int8 NOT NULL,
+ "datasource_id" int8,
+ "model_name" varchar(50) COLLATE "pg_catalog"."default",
+ "model_code" varchar(50) COLLATE "pg_catalog"."default",
+ "model_table" varchar(100) COLLATE "pg_catalog"."default",
+ "model_class" varchar(100) COLLATE "pg_catalog"."default",
+ "model_remark" varchar(500) COLLATE "pg_catalog"."default",
+ "create_user" int8,
+ "create_dept" int8,
+ "create_time" timestamp(6),
+ "update_user" int8,
+ "update_time" timestamp(6),
+ "status" int4,
+ "is_deleted" int4,
+ PRIMARY KEY ("id")
+)
+;
+
+COMMENT ON COLUMN "blade_model"."id" IS '主键';
+
+COMMENT ON COLUMN "blade_model"."datasource_id" IS '数据源主键';
+
+COMMENT ON COLUMN "blade_model"."model_name" IS '模型名称';
+
+COMMENT ON COLUMN "blade_model"."model_code" IS '模型编号';
+
+COMMENT ON COLUMN "blade_model"."model_table" IS '物理表名';
+
+COMMENT ON COLUMN "blade_model"."model_class" IS '模型类名';
+
+COMMENT ON COLUMN "blade_model"."model_remark" IS '模型备注';
+
+COMMENT ON COLUMN "blade_model"."create_user" IS '创建人';
+
+COMMENT ON COLUMN "blade_model"."create_dept" IS '创建部门';
+
+COMMENT ON COLUMN "blade_model"."create_time" IS '创建时间';
+
+COMMENT ON COLUMN "blade_model"."update_user" IS '修改人';
+
+COMMENT ON COLUMN "blade_model"."update_time" IS '修改时间';
+
+COMMENT ON COLUMN "blade_model"."status" IS '状态';
+
+COMMENT ON COLUMN "blade_model"."is_deleted" IS '是否已删除';
+
+COMMENT ON TABLE "blade_model" IS '数据模型表';
+
+-- -----------------------------------
+-- 新增 数据原型表
+-- -----------------------------------
+CREATE TABLE "blade_model_prototype" (
+ "id" int8 NOT NULL,
+ "model_id" int8,
+ "jdbc_name" varchar(50) COLLATE "pg_catalog"."default",
+ "jdbc_type" varchar(20) COLLATE "pg_catalog"."default",
+ "comment" varchar(500) COLLATE "pg_catalog"."default",
+ "property_type" varchar(20) COLLATE "pg_catalog"."default",
+ "property_entity" varchar(500) COLLATE "pg_catalog"."default",
+ "property_name" varchar(50) COLLATE "pg_catalog"."default",
+ "is_list" int4,
+ "is_form" int4,
+ "is_row" int4,
+ "component_type" varchar(50) COLLATE "pg_catalog"."default",
+ "dict_code" varchar(50) COLLATE "pg_catalog"."default",
+ "is_required" int4,
+ "validate_type" varchar(50) COLLATE "pg_catalog"."default",
+ "is_query" int4,
+ "query_type" varchar(50) COLLATE "pg_catalog"."default",
+ "create_user" int8,
+ "create_dept" int8,
+ "create_time" timestamp(6),
+ "update_user" int8,
+ "update_time" timestamp(6),
+ "status" int4,
+ "is_deleted" int4,
+ PRIMARY KEY ("id")
+)
+;
+
+COMMENT ON COLUMN "blade_model_prototype"."id" IS '主键';
+
+COMMENT ON COLUMN "blade_model_prototype"."model_id" IS '模型主键';
+
+COMMENT ON COLUMN "blade_model_prototype"."jdbc_name" IS '物理列名';
+
+COMMENT ON COLUMN "blade_model_prototype"."jdbc_type" IS '物理类型';
+
+COMMENT ON COLUMN "blade_model_prototype"."comment" IS '注释说明';
+
+COMMENT ON COLUMN "blade_model_prototype"."property_type" IS '实体类型';
+
+COMMENT ON COLUMN "blade_model_prototype"."property_entity" IS '实体类型引用';
+
+COMMENT ON COLUMN "blade_model_prototype"."property_name" IS '实体列名';
+
+COMMENT ON COLUMN "blade_model_prototype"."is_list" IS '列表显示';
+
+COMMENT ON COLUMN "blade_model_prototype"."is_form" IS '表单显示';
+
+COMMENT ON COLUMN "blade_model_prototype"."is_row" IS '独占一行';
+
+COMMENT ON COLUMN "blade_model_prototype"."component_type" IS '组件类型';
+
+COMMENT ON COLUMN "blade_model_prototype"."dict_code" IS '字典编码';
+
+COMMENT ON COLUMN "blade_model_prototype"."is_required" IS '是否必填';
+
+COMMENT ON COLUMN "blade_model_prototype"."validate_type" IS '验证类型';
+
+COMMENT ON COLUMN "blade_model_prototype"."is_query" IS '查询配置';
+
+COMMENT ON COLUMN "blade_model_prototype"."query_type" IS '查询类型';
+
+COMMENT ON COLUMN "blade_model_prototype"."create_user" IS '创建人';
+
+COMMENT ON COLUMN "blade_model_prototype"."create_dept" IS '创建部门';
+
+COMMENT ON COLUMN "blade_model_prototype"."create_time" IS '创建时间';
+
+COMMENT ON COLUMN "blade_model_prototype"."update_user" IS '修改人';
+
+COMMENT ON COLUMN "blade_model_prototype"."update_time" IS '修改时间';
+
+COMMENT ON COLUMN "blade_model_prototype"."status" IS '状态';
+
+COMMENT ON COLUMN "blade_model_prototype"."is_deleted" IS '是否已删除';
+
+COMMENT ON TABLE "blade_model_prototype" IS '数据原型表';
--
Gitblit v1.9.3