Skip to content
本页目录

Locas 低代码开发平台

Locas 低代码开发平台是一个强大的低代码开发平台,旨在帮助开发者快速构建、部署和管理复杂的企业级应用程序。通过项目模式管理,您可以轻松地组织和管理多个项目,并通过图形化拖拽方式实现前端页面配置及后端服务设置。此外,我们还提供了丰富的模板库,支持快速创建各种类型的应用程序。

功能范围

  • 项目管理与项目空间
  • 页面设计器
  • 服务设计器
  • 微应用应用发布
  • 项目备份与还原
  • 页面模板库
  • 项目模板库
  • 接口、状态设计器

版本

v2.8.32,于2025年4月3日发布

操作手册

  • 项目空间页面、功能优化(新的页面编辑器、支持页面、接口、状态多tab编辑;项目类型调整为:业务类、前端部件、主题、服务部件等)
  • 接入AI辅助
  • 项目开发时,以测试/业务站用户身份调试页面、接口
  • FBP服务提供服务端事件监听响应功能
  • 统一低代码平台表前缀为:fbpl_
  • 项目支持参数设置

更新内容

新增

  • 事件发布Task
  • 站点级DSC在项目开发中的使用
  • 项目参数设置
  • AI开发辅助
  • 开发站使用测试站/业务站数据(身份)进行业务开发
  • 接口的统一管理

修复或修改

  • 项目类型调整为:业务开发、前端部件、后端部件、主题,优化开发人员对项目空间功能的使用;
  • 低代码平台表前缀统一为fbpl_
  • 页面编辑器改版升级
  • 页面、接口、状态、查找替换支持多tab模式(需对历史项目进行升级)
  • 平台级数据源、站点级数据源管理应用调整为只需维护:url、驱动类、用户、密码,方便后期扩展其它类型数据源
  • 项目页面、接口、状态树调成单根结构

优化

更新资料获取

如何获取微服务镜像?

所有镜像可到容器仓库通过 docker pull 拉取

  • 武汉公司内网:192.168.1.10:5000/tangram/[微服务名]:[版本号]
  • 阿里云:registry.cn-hangzhou.aliyuncs.com/tangram/[微服务名]:[版本号]

如何获取微服务jar包?

所有正式发布版本可到私服仓库下载

  • 下载地址:http://nps.zktx-soft.com:19098/repository/maven-public/com/gsoft/[平台:mas|locas]/[应用名]/[版本号]/[应用名]-[版本号].jar

例:http://nps.zktx-soft.com:19098/repository/maven-public/com/gsoft/mas/mas-admin//mas-admin-.jar

如何获取微应用tgz包?

所有安装包可到阿里云OSS仓库下载

  • 路径:oss://foa5-oss/deploy/release/[平台:mas/locas]/[应用名称]/[版本号]/[应用名称]-[版本号].tgz 如:oss://foa5-oss/deploy/release/locas//2.8.32/locas-2.8.32.tgz

基于MAS平台版本

Locas 基于 MAS v5.14.30

微服务版本明细

序号微应用Code版本号说明
1低代码引擎locas-service2.8.2
2新低代码引擎locas-fbp2.8.3

微应用版本明细

序号微应用Code版本号更新说明
1Locas低代码设计器locas2.8.32原maui-pages,对应locas-service
2PC基础组件lc-system-toolsv1.0.0.20获取地址:oss://foa5-oss/deploy/fbp_locas_hold/
3低代码项目管理lc-project-workspacev5.1.0.61获取地址:oss://foa5-oss/deploy/fbp_locas_hold/

2.7升级至2.8.32

1、调整表前缀(在locas-service服务连的库中执行)

点击查看
sql
----------------------------fbp_dcs_setting
ALTER TABLE fbp_dcs_setting RENAME TO fbpl_dcs_setting;
CREATE SEQUENCE IF NOT EXISTS fbpl_dcs_setting_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_dcs_setting_c_id_seq', (SELECT MAX ( c_id ) FROM fbpl_dcs_setting));
ALTER TABLE fbpl_dcs_setting ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_dcs_setting_c_id_seq');

----------------------------fbp_service
ALTER TABLE fbp_service RENAME TO fbpl_service;
CREATE SEQUENCE IF NOT EXISTS fbpl_service_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_service_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_service ) );
ALTER TABLE fbpl_service ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_service_c_id_seq' );

----------------------------fbp_tree_json
ALTER TABLE fbp_tree_json RENAME TO fbpl_tree_json;
CREATE SEQUENCE IF NOT EXISTS fbpl_tree_json_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_tree_json_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_tree_json ) );
ALTER TABLE fbpl_tree_json ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_tree_json_c_id_seq' );

----------------------------fbp_state
ALTER TABLE fbp_state RENAME TO fbpl_state;
CREATE SEQUENCE IF NOT EXISTS fbpl_state_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_state_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_state ) );
ALTER TABLE fbpl_state ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_state_c_id_seq');

----------------------------fbp_lock_record
ALTER TABLE fbp_lock_record RENAME TO fbpl_lock_record;
CREATE SEQUENCE IF NOT EXISTS fbpl_lock_record_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_lock_record_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_lock_record ) );
ALTER TABLE fbpl_lock_record ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_lock_record_c_id_seq' );

----------------------------t_backup_record
ALTER TABLE t_backup_record RENAME TO fbpl_backup_record;
CREATE SEQUENCE IF NOT EXISTS fbpl_backup_record_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_backup_record_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_backup_record ) );
ALTER TABLE fbpl_backup_record ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_backup_record_c_id_seq' );

----------------------------t_libapp_publish_record
ALTER TABLE t_libapp_publish_record RENAME TO fbpl_libapp_publish_record;
CREATE SEQUENCE IF NOT EXISTS fbpl_libapp_publish_record_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_libapp_publish_record_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_libapp_publish_record ) );
ALTER TABLE fbpl_libapp_publish_record ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_libapp_publish_record_c_id_seq' );

----------------------------t_page_template
ALTER TABLE t_page_template RENAME TO fbpl_page_template;
CREATE SEQUENCE IF NOT EXISTS fbpl_page_template_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_page_template_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_page_template ) );
ALTER TABLE fbpl_page_template ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_page_template_c_id_seq' );

----------------------------t_project_app_events
ALTER TABLE t_project_app_events RENAME TO fbpl_project_app_events;
CREATE SEQUENCE IF NOT EXISTS fbpl_project_app_events_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_project_app_events_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_project_app_events ) );
ALTER TABLE fbpl_project_app_events ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_project_app_events_c_id_seq' );

----------------------------t_project_app_file_info
ALTER TABLE t_project_app_file_info RENAME TO fbpl_project_app_file_info;
CREATE SEQUENCE IF NOT EXISTS fbpl_project_app_file_info_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_project_app_file_info_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_project_app_file_info ) );
ALTER TABLE fbpl_project_app_file_info ALTER COLUMN "c_id" 
SET DEFAULT nextval( 'fbpl_project_app_file_info_c_id_seq' );

----------------------------t_project_app_info
ALTER TABLE t_project_app_info RENAME TO fbpl_project_app_info;
CREATE SEQUENCE IF NOT EXISTS fbpl_project_app_info_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_project_app_info_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_project_app_info ) );
ALTER TABLE fbpl_project_app_info ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_project_app_info_c_id_seq' );

----------------------------t_project_app_methods
ALTER TABLE t_project_app_methods RENAME TO fbpl_project_app_methods;
CREATE SEQUENCE IF NOT EXISTS fbpl_project_app_methods_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_project_app_methods_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_project_app_methods ) );
ALTER TABLE fbpl_project_app_methods ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_project_app_methods_c_id_seq' );

----------------------------t_project_info
ALTER TABLE t_project_info RENAME TO fbpl_project_info;
CREATE SEQUENCE IF NOT EXISTS fbpl_project_info_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_project_info_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_project_info ) );
ALTER TABLE fbpl_project_info ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_project_info_c_id_seq' );

----------------------------t_project_member
ALTER TABLE t_project_member RENAME TO fbpl_project_member;
CREATE SEQUENCE IF NOT EXISTS fbpl_project_member_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_project_member_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_project_member ) );
ALTER TABLE fbpl_project_member ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_project_member_c_id_seq' );

----------------------------t_project_template
ALTER TABLE t_project_template RENAME TO fbpl_project_template;
CREATE SEQUENCE IF NOT EXISTS fbpl_project_template_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_project_template_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_project_template ) );
ALTER TABLE fbpl_project_template ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_project_template_c_id_seq' );

----------------------------t_restore_record
ALTER TABLE t_restore_record RENAME TO fbpl_restore_record;
CREATE SEQUENCE IF NOT EXISTS fbpl_restore_record_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_restore_record_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_restore_record ) );
ALTER TABLE fbpl_restore_record ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_restore_record_c_id_seq' );

----------------------------t_template_category
ALTER TABLE t_template_category RENAME TO fbpl_template_category;
CREATE SEQUENCE IF NOT EXISTS fbpl_template_category_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_template_category_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_template_category ) );
ALTER TABLE fbpl_template_category ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_template_category_c_id_seq' );

----------------------------t_version_record
ALTER TABLE t_version_record RENAME TO fbpl_version_record;
CREATE SEQUENCE IF NOT EXISTS fbpl_version_record_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_version_record_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_version_record ) );
ALTER TABLE fbpl_version_record ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_version_record_c_id_seq' );

----------------------------t_app_menu_catalog
ALTER TABLE t_app_menu_catalog RENAME TO fbpl_app_menu_catalog;
CREATE SEQUENCE IF NOT EXISTS fbpl_app_menu_catalog_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_app_menu_catalog_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_app_menu_catalog ) );
ALTER TABLE fbpl_app_menu_catalog ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_app_menu_catalog_c_id_seq');

----------------------------t_app_menu_pages
ALTER TABLE t_app_menu_pages RENAME TO fbpl_app_menu_pages;
CREATE SEQUENCE IF NOT EXISTS fbpl_app_menu_pages_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_app_menu_pages_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_app_menu_pages ) );
ALTER TABLE fbpl_app_menu_pages ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_app_menu_pages_c_id_seq');


----------------------------t_app_card_catalog
ALTER TABLE t_app_card_catalog RENAME TO  fbpl_app_card_catalog;
CREATE SEQUENCE IF NOT EXISTS fbpl_app_card_catalog_c_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 999999999 START 1 CACHE 1;
SELECT setval( 'fbpl_app_card_catalog_c_id_seq', ( SELECT MAX ( c_id ) FROM fbpl_app_card_catalog ) );
ALTER TABLE fbpl_app_card_catalog ALTER COLUMN "c_id" SET DEFAULT nextval( 'fbpl_app_card_catalog_c_id_seq');

2、新增表、调整表结构(在locas-service服务连的库中执行)

点击查看
sql
-- ----------------------------
-- Table structure for fbpl_page
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_page";
CREATE TABLE "fbpl_page" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_tenant_id" int8,
  "c_path" varchar(500) ,
  "c_config" text ,
  "c_settings" text ,
  "c_type" varchar(20) ,
  "c_project" varchar(32) ,
  "c_version" varchar(10) ,
  "c_bg_url" varchar(500) ,
  "c_depens" text ,
  "c_code" varchar(255)
);
COMMENT ON COLUMN "fbpl_page"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_page"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbpl_page"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbpl_page"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbpl_page"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbpl_page"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbpl_page"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbpl_page"."c_path" IS '页面路径';
COMMENT ON COLUMN "fbpl_page"."c_config" IS '页面配置';
COMMENT ON COLUMN "fbpl_page"."c_settings" IS '页面设置';
COMMENT ON COLUMN "fbpl_page"."c_type" IS '页面类型';
COMMENT ON COLUMN "fbpl_page"."c_project" IS '项目标识';
COMMENT ON COLUMN "fbpl_page"."c_version" IS '版本';
COMMENT ON COLUMN "fbpl_page"."c_bg_url" IS '页面背景图片';
COMMENT ON COLUMN "fbpl_page"."c_depens" IS '依赖信息';
COMMENT ON COLUMN "fbpl_page"."c_code" IS '依赖信息';
COMMENT ON TABLE "fbpl_page" IS '页面表';

-- ----------------------------
-- Table structure for fbpl_page_history
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_page_history";
CREATE TABLE "fbpl_page_history" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_tenant_id" int8,
  "c_path" varchar(500) ,
  "c_config" text ,
  "c_settings" text ,
  "c_type" varchar(20) ,
  "c_project" varchar(20) ,
  "c_version" varchar(10) ,
  "c_user_name" varchar(255),
  "c_remark" varchar(500),
  "c_is_auto"  varchar(1) DEFAULT '0'
);
COMMENT ON COLUMN "fbpl_page_history"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_page_history"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbpl_page_history"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbpl_page_history"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbpl_page_history"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbpl_page_history"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbpl_page_history"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbpl_page_history"."c_path" IS '页面路径';
COMMENT ON COLUMN "fbpl_page_history"."c_config" IS '配置json';
COMMENT ON COLUMN "fbpl_page_history"."c_remark" IS '备注说明';
COMMENT ON COLUMN "fbpl_page_history"."c_is_auto" IS '状态 0 自动保存 1 手工保存';
COMMENT ON TABLE "fbpl_page_history" IS '页面版本表';

-- ----------------------------
-- Table structure for fbpl_app_snippet_catalog
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_app_snippet_catalog";
CREATE TABLE "fbpl_app_snippet_catalog" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_tenant_id" int8,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int8,
  "c_text" varchar(50) ,
  "c_icon" varchar(150) ,
  "c_project" varchar(50) ,
  "c_version" varchar(20) ,
  "c_cascade_id" varchar(20) ,
  "c_parent_id" int8,
  "c_type" varchar(20) DEFAULT 'snippet'
);
COMMENT ON COLUMN "fbpl_app_snippet_catalog"."c_text" IS '分类名称';
COMMENT ON COLUMN "fbpl_app_snippet_catalog"."c_icon" IS '分类图标';
COMMENT ON COLUMN "fbpl_app_snippet_catalog"."c_project" IS '项目code';
COMMENT ON COLUMN "fbpl_app_snippet_catalog"."c_version" IS '项目版本';
COMMENT ON COLUMN "fbpl_app_snippet_catalog"."c_cascade_id" IS '级联id';
COMMENT ON COLUMN "fbpl_app_snippet_catalog"."c_parent_id" IS '父id';
COMMENT ON COLUMN "fbpl_app_snippet_catalog"."c_type" IS '部件类型: snippet mobile-snippet print-snippet';
COMMENT ON TABLE "fbpl_app_snippet_catalog" IS '项目应用部件分类表';

-- ----------------------------
-- Table structure for fbpl_app_snippet_pages
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_app_snippet_pages";
CREATE TABLE "fbpl_app_snippet_pages" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_tenant_id" int8,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int8,
  "c_name" varchar(500) ,
  "c_path" varchar(500) ,
  "c_category_id" varchar(500) ,
  "c_project" varchar(20) ,
  "c_version" varchar(10)
);
COMMENT ON COLUMN "fbpl_app_snippet_pages"."c_path" IS '页面路径';
COMMENT ON COLUMN "fbpl_app_snippet_pages"."c_category_id" IS '分类id';
COMMENT ON COLUMN "fbpl_app_snippet_pages"."c_project" IS '项目code';
COMMENT ON COLUMN "fbpl_app_snippet_pages"."c_version" IS '项目版本';
COMMENT ON TABLE "fbpl_app_snippet_pages" IS '项目应用部件页面表';

-- ----------------------------
-- Table structure for fbpl_project_app_setting
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_project_app_setting";
CREATE TABLE "fbpl_project_app_setting" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_theme" varchar(200),
  "c_apps" text ,
  "c_project" varchar(200),
  "c_version" varchar(200),
  "c_tenant_id" int8,
  "c_site_id" int8,
  "c_mobile_theme" varchar(200)
);
COMMENT ON COLUMN "fbpl_project_app_setting"."c_mobile_theme" IS '移动主题';
COMMENT ON TABLE "fbpl_project_app_setting" IS '项目应用配置信息表';

-- ----------------------------
-- Table structure for fbpl_project_component_grant
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_project_component_grant";
CREATE TABLE "fbpl_project_component_grant" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_tenant_id" int8 NOT NULL,
  "c_project_code" VARCHAR(200) ,
  "c_version" varchar(200) ,
  "c_app_code" varchar(200)  NOT NULL
);
COMMENT ON COLUMN "fbpl_project_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_project_code" IS '项目code';
COMMENT ON COLUMN "fbpl_project_component_grant"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbpl_project_component_grant" IS '部件授权项目信息表';
COMMENT ON TABLE "fbpl_project_component_grant" IS '项目部件授权表';

-- ----------------------------
-- Table structure for fbpl_project_diy_app_version
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_project_diy_app_version";
CREATE TABLE "fbpl_project_diy_app_version" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_app_code" varchar(200),
  "c_app_version" varchar(200),
  "c_project_code"varchar(200),
  "c_project_version" varchar(200),
  "c_tenant_id" int8,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_app_version" IS '应用版本';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbpl_project_diy_app_version"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbpl_project_diy_app_version" IS '项目应用自定义版本记录表';
COMMENT ON TABLE "fbpl_project_diy_app_version" IS '项目自定义应用版本表';

DROP TABLE IF EXISTS "fbpl_project_env_info";
CREATE TABLE "fbpl_project_env_info" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp,
  "c_creator" int8,
  "c_create_time" timestamp,
  "c_sort_number" int4,
  "c_tenant_id" int8 NOT NULL,
  "c_code" VARCHAR(100) ,
  "c_name" VARCHAR(200) ,
  "c_remark" VARCHAR(500) ,
  "c_exec_site" VARCHAR(200) ,
  "c_exec_site_name" VARCHAR(200) ,
  "c_project_code" VARCHAR(100) ,
  "c_version" VARCHAR(20) ,
  "c_account_id" VARCHAR(50) ,
  "c_account_name" VARCHAR(100)
);
COMMENT ON COLUMN "fbpl_project_env_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_project_env_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbpl_project_env_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbpl_project_env_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbpl_project_env_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbpl_project_env_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbpl_project_env_info"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbpl_project_env_info"."c_project_code" IS '项目code';
COMMENT ON COLUMN "fbpl_project_env_info"."c_version" IS '项目版本';
COMMENT ON COLUMN "fbpl_project_env_info"."c_code" IS '环境标识';
COMMENT ON COLUMN "fbpl_project_env_info"."c_name" IS '环境名称';
COMMENT ON COLUMN "fbpl_project_env_info"."c_remark" IS '备注说明';
COMMENT ON COLUMN "fbpl_project_env_info"."c_exec_site" IS '执行站点';
COMMENT ON COLUMN "fbpl_project_env_info"."c_account_id" IS '登录账号';
COMMENT ON COLUMN "fbpl_project_env_info"."c_account_name" IS '登录账号名';
COMMENT ON COLUMN "fbpl_project_env_info"."c_exec_site_name" IS '执行站点名称';
COMMENT ON TABLE "fbpl_project_env_info" IS '项目环境信息表';

DROP TABLE IF EXISTS "fbpl_project_app_styles";
CREATE TABLE "fbpl_project_app_styles" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp,
  "c_creator" int8,
  "c_create_time" timestamp,
  "c_sort_number" int4,
  "c_tenant_id" int8 NOT NULL,
  "c_project" varchar(100) ,
  "c_version" varchar(100) ,
  "c_code" varchar(100) ,
  "c_name" varchar(200) ,
  "c_css" text,
  "c_type" varchar(1),
  "c_path" varchar(100)
);
COMMENT ON COLUMN "fbpl_project_app_styles"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_project" IS '项目code';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_version" IS '项目版本';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_code" IS '样式code';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_name" IS '样式名称';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_css" IS '样式内容';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_type" IS '类型';
COMMENT ON COLUMN "fbpl_project_app_styles"."c_path" IS '页面路径';
COMMENT ON TABLE "fbpl_project_app_styles" IS '项目样式表';

DROP TABLE IF EXISTS "fbpl_interface_service_path";
CREATE TABLE "fbpl_interface_service_path" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
	"c_creator" varchar(50),
    "c_create_time" timestamp(6),
	"c_type" varchar(50),
	"c_uuid" varchar(500),
	"c_code" varchar(50),
	"c_path" varchar(500),
	"c_name" varchar(100),
	"c_remark" varchar(500),
	"c_method" varchar(50),
	"c_project" varchar(100),
	"c_version" varchar(100),
	"c_tenant_id" int8
);
COMMENT ON COLUMN "fbpl_interface_service_path"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_code" IS '标识';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_path" IS '路径';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_name" IS '名称';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_remark" IS '描述';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_project" IS '项目code';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_version" IS '项目版本';
COMMENT ON COLUMN "fbpl_interface_service_path"."c_type" IS '类型:自动新增1/手动新增2';
COMMENT ON TABLE "fbpl_interface_service_path" IS '项目接口信息表';

DROP TABLE IF EXISTS "fbpl_rel_project_or_app";
CREATE TABLE "fbpl_rel_project_or_app" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_project" varchar(500),
  "c_version" varchar(100),
  "c_rel_code" varchar(500),
  "c_rel_name" varchar(500),
  "c_type" varchar(50),
  "c_tenant_id" int8,
  "c_creator" varchar(50),
  "c_create_time" timestamp(6)
);
COMMENT ON COLUMN "fbpl_rel_project_or_app"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_rel_project_or_app"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbpl_rel_project_or_app"."c_project" IS '当前项目';
COMMENT ON COLUMN "fbpl_rel_project_or_app"."c_version" IS '当前版本';
COMMENT ON COLUMN "fbpl_rel_project_or_app"."c_rel_code" IS '依赖项目或应用code';
COMMENT ON COLUMN "fbpl_rel_project_or_app"."c_rel_name" IS '依赖项目或应用名称';
COMMENT ON COLUMN "fbpl_rel_project_or_app"."c_type" IS '类型:  project/app';
COMMENT ON TABLE "fbpl_rel_project_or_app" IS '项目依赖项目/应用信息表';

DROP TABLE IF EXISTS "fbpl_service_history";
CREATE TABLE "fbpl_service_history" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp,
  "c_creator" int8,
  "c_create_time" timestamp,
  "c_sort_number" int4,
  "c_tenant_id" int8,
  "c_project" varchar(100) ,
  "c_version" varchar(20) ,
  "c_uuid" varchar(100) ,
  "c_bpmn" text ,
  "c_runner" text ,
  "c_document" text ,
  "c_element" text ,
  "c_user_name" varchar(100) ,
  "c_remark" varchar(2000) ,
  "c_type" varchar(10)  
);
COMMENT ON COLUMN "fbpl_service_history"."c_project" IS '项目code';
COMMENT ON COLUMN "fbpl_service_history"."c_version" IS '版本号';
COMMENT ON COLUMN "fbpl_service_history"."c_uuid" IS 'uuid';
COMMENT ON COLUMN "fbpl_service_history"."c_bpmn" IS 'xml配置';
COMMENT ON COLUMN "fbpl_service_history"."c_runner" IS '调试参数实例数据';
COMMENT ON COLUMN "fbpl_service_history"."c_document" IS '文档数据';
COMMENT ON COLUMN "fbpl_service_history"."c_element" IS '当c_bizType值为logic-comp,代表部件,存放部件元素信息';
COMMENT ON COLUMN "fbpl_service_history"."c_user_name" IS '操作用户';
COMMENT ON COLUMN "fbpl_service_history"."c_remark" IS '版本描述';
COMMENT ON COLUMN "fbpl_service_history"."c_type" IS '保存类型 0 自动保存 1 手工保存';
COMMENT ON TABLE "fbpl_service_history" IS '接口服务版本表';

DROP TABLE IF EXISTS "fbpl_state_history";
create table "fbpl_state_history" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp,
  "c_creator" int8,
  "c_create_time" timestamp,
  "c_sort_number" int4,
  "c_tenant_id" int8,
  "c_project" varchar(32) ,
  "c_version" varchar(32) ,
  "c_uuid" varchar(50) ,
  "c_bpmn" text ,
  "c_runner" text ,
  "c_document" text ,
  "c_user_name" varchar(32) ,
  "c_remark" varchar(255) ,
  "c_type" varchar(1) default '0'
);
comment on column "fbpl_state_history"."c_project" is '项目code';
comment on column "fbpl_state_history"."c_version" is '版本号';
comment on column "fbpl_state_history"."c_uuid" is 'uuid';
comment on column "fbpl_state_history"."c_bpmn" is 'xml配置';
comment on column "fbpl_state_history"."c_runner" is '调试实例数据';
comment on column "fbpl_state_history"."c_document" is '文档说明';
comment on column "fbpl_state_history"."c_user_name" is '操作用户';
comment on column "fbpl_state_history"."c_remark" is '版本描述';
comment on column "fbpl_state_history"."c_type" is '保存类型 0 自动保存 1 手工保存';
COMMENT ON TABLE "fbpl_state_history" IS '状态机版本表';

-- ----------------------------
-- Table structure for fbpl_app_card_pages
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_app_card_pages";
CREATE TABLE "fbpl_app_card_pages" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_tenant_id" int8,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int8,
  "c_path" varchar(500) ,
  "c_name" varchar(200) ,
  "c_category_id" varchar(500) ,
  "c_project" varchar(50) ,
  "c_version" varchar(10) 
);
COMMENT ON COLUMN "fbpl_app_card_pages"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_last_modifier" IS '修改人账号id';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_creator" IS '创建人账号id';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_path" IS '页面路径';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_category_id" IS '分类id';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_project" IS '项目code';
COMMENT ON COLUMN "fbpl_app_card_pages"."c_version" IS '项目版本';
COMMENT ON TABLE "fbpl_app_card_pages" IS '项目业务卡片信息表';

DROP TABLE IF EXISTS "fbpl_project_env_account_active";
CREATE TABLE "fbpl_project_env_account_active" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
	"c_project" varchar(500),
	"c_version" varchar(100),
	"c_login_tenant_id" int8,
	"c_login_site_group_id" int8,
	"c_login_site_id" int8,
	"c_login_account_id" int8,
	"c_active_tenant_id" int8,
	"c_active_site_group_id" int8,
	"c_active_site_id" int8,
	"c_active_tenant_code" varchar(100),
	"c_active_site_group_code" varchar(100),
	"c_active_site_code" varchar(100),
	"c_active_site_path" varchar(500),
	"c_active_account_id" int8,
	"c_active_env_id" int8,
	"c_active_account" varchar(100)
);
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_project" IS '项目标识';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_version" IS '项目版本';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_login_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_login_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_login_site_id" IS '站点id';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_login_account_id" IS '登录账号';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_tenant_id" IS '激活租户id';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_site_group_id" IS '激活站群id';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_site_id" IS '激活站点id';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_tenant_code" IS '激活租户code';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_site_group_code" IS '激活站群code';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_site_code" IS '激活站点code';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_site_path" IS '激活站点访问路径';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_account_id" IS '激活账号id';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_account" IS '激活账号';
COMMENT ON COLUMN "fbpl_project_env_account_active"."c_active_env_id" IS '激活环境ID';
COMMENT ON TABLE "fbpl_project_env_account_active" IS '项目环境信息表';

DROP TABLE IF EXISTS "fbpl_project_env_account";
CREATE TABLE "fbpl_project_env_account" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
	"c_project" varchar(500),
	"c_version" varchar(100),
	"c_tenant_id" int8,
	"c_env_id" int8,
	"c_account_id" int8,
	"c_login_account" varchar(100),
	"c_account_name" varchar(100),
	"c_password" varchar(100),
	"c_remark" varchar(1000)
);
COMMENT ON COLUMN "fbpl_project_env_account"."c_id" IS '主键';
COMMENT ON COLUMN "fbpl_project_env_account"."c_project" IS '项目标识';
COMMENT ON COLUMN "fbpl_project_env_account"."c_version" IS '项目版本';
COMMENT ON COLUMN "fbpl_project_env_account"."c_env_id" IS '环境ID';
COMMENT ON COLUMN "fbpl_project_env_account"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbpl_project_env_account"."c_account_id" IS '账号ID';
COMMENT ON COLUMN "fbpl_project_env_account"."c_login_account" IS '登录账号';
COMMENT ON COLUMN "fbpl_project_env_account"."c_account_name" IS '账号名称';
COMMENT ON COLUMN "fbpl_project_env_account"."c_password" IS '密码';
COMMENT ON COLUMN "fbpl_project_env_account"."c_remark" IS '备注';
COMMENT ON TABLE "fbpl_project_env_account" IS '项目环境授权账号表';


-- 调整表结构
ALTER TABLE "fbpl_app_card_catalog" 
ADD COLUMN "c_hidden" varchar(2) ,
ADD COLUMN "c_anonymous" varchar(2) ;
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_hidden" IS '是否隐藏: "0":否  "1":是';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_anonymous" IS '匿名访问: "0":否  "1":是';

ALTER TABLE "fbpl_project_info" 
  ADD COLUMN "c_manager_id" int8,
  ADD COLUMN "c_compatible_service" int2 DEFAULT 0,
  ADD COLUMN "c_status" varchar(1) DEFAULT '0';
COMMENT ON COLUMN "fbpl_project_info"."c_manager_id" IS '项目经理账号id';
COMMENT ON COLUMN "fbpl_project_info"."c_compatible_service" IS '是否兼容老项目0:不兼容  1:兼容';
COMMENT ON COLUMN "fbpl_project_info"."c_status" IS '状态 0 未归档 1 已归档';

ALTER TABLE "fbpl_app_menu_catalog" 
ADD COLUMN "c_type" varchar(20) DEFAULT 'page',
ADD COLUMN "c_slot" varchar(20),
ADD COLUMN "c_handler" text,
ADD COLUMN "c_on_handler" varchar(2) DEFAULT '0';
COMMENT ON COLUMN "fbpl_app_menu_catalog"."c_type" IS '菜单类型 同页面类型';
COMMENT ON COLUMN "fbpl_app_menu_catalog"."c_slot" IS '页面插槽名';
COMMENT ON COLUMN "fbpl_app_menu_catalog"."c_handler" IS 'handler事件';
COMMENT ON COLUMN "fbpl_app_menu_catalog"."c_on_handler" IS 'handler事件是否启用';

ALTER TABLE "fbpl_project_app_info" 
  ADD COLUMN "c_mobile_run_events" text,
  ADD COLUMN "c_print_run_events" text,
  ADD COLUMN "c_is_login" varchar(2) DEFAULT '0',
  ADD COLUMN "c_css" text,
  ADD COLUMN "c_snippets" text,
  ADD COLUMN "c_templates" text,
  ADD COLUMN "c_mobile_snippets" text,
  ADD COLUMN "c_print_snippets" text,
  ADD COLUMN "c_mobile_templates" text,
  ADD COLUMN "c_print_templates" text,
  ADD COLUMN "c_fbp_snippets" text;
COMMENT ON COLUMN "fbpl_project_app_info"."c_mobile_run_events" IS '启动事件-移动';
COMMENT ON COLUMN "fbpl_project_app_info"."c_print_run_events" IS '启动事件-打印';
COMMENT ON COLUMN "fbpl_project_app_info"."c_is_login" IS '是否是登录应用 0 否 1 是';
COMMENT ON COLUMN "fbpl_project_app_info"."c_css" IS '样式内容';
COMMENT ON COLUMN "fbpl_project_app_info"."c_snippets" IS '部件库';
COMMENT ON COLUMN "fbpl_project_app_info"."c_templates" IS '模板库';
COMMENT ON COLUMN "fbpl_project_app_info"."c_mobile_snippets" IS '移动部件库';
COMMENT ON COLUMN "fbpl_project_app_info"."c_print_snippets" IS '打印部件库';
COMMENT ON COLUMN "fbpl_project_app_info"."c_mobile_templates" IS '移动模板库';
COMMENT ON COLUMN "fbpl_project_app_info"."c_print_templates" IS '打印模板库';
COMMENT ON COLUMN "fbpl_project_app_info"."c_fbp_snippets" IS '服务部件库';

ALTER TABLE "fbpl_project_app_events"
ADD COLUMN "c_type" varchar(10) DEFAULT 'pc';
COMMENT ON COLUMN "fbpl_project_app_events"."c_type" IS '类型 pc mobile print';

ALTER TABLE "fbpl_project_app_methods" ADD COLUMN c_type varchar(10) DEFAULT 'pc';
COMMENT ON COLUMN "fbpl_project_app_methods"."c_type" IS '类型 pc mobile print';

ALTER TABLE "fbpl_app_menu_pages"
ADD COLUMN "c_slot" varchar(20),
ADD COLUMN "c_handler" text,
ADD COLUMN "c_on_handler" varchar(2) DEFAULT '0';
COMMENT ON COLUMN "fbpl_app_menu_pages"."c_slot" IS '页面插槽名';
COMMENT ON COLUMN "fbpl_app_menu_pages"."c_handler" IS 'handler事件';
COMMENT ON COLUMN "fbpl_app_menu_pages"."c_on_handler" IS 'handler事件是否启用';

ALTER TABLE fbpl_version_record
ADD COLUMN c_upgrade_version int4 DEFAULT 0;

ALTER TABLE "fbpl_dcs_setting" 
  ADD COLUMN "c_name" varchar(255);
COMMENT ON COLUMN "fbpl_dcs_setting"."c_name" IS '名称';
update fbpl_dcs_setting set c_name = c_desc;

ALTER TABLE fbpl_version_record ALTER COLUMN c_locked TYPE varchar(1);
ALTER TABLE fbpl_version_record ADD COLUMN c_name VARCHAR(500);
COMMENT ON COLUMN "fbpl_version_record"."c_name" IS '版本名称';
COMMENT ON COLUMN "fbpl_version_record"."c_locked" IS '是否锁定该版本:0 否 1 是';

3、在平台上架项目空间升级应用【lc-pwupdate2fbp,获取地址:oss://foa5-oss/deploy/files/lc-pwupdate2fbp-v1.0.0.4.tgz】并授权到有低代码开发的站点上(每个租户下找一个站点即可,项目数据是租户隔离),登录后对租户内的项目进行逐个升级

  • 升级时项目空间里看不到项目时,需在管理站确认角色管理里确认是否有lc_ps_manager(项目空间管理员),并授权账号
  • 不对项目进行升级的话,项目空间将看不到页面数据【升级操作受项目页面历史版本数据、项目版本数据量影响,可能会很慢,如果项目页面历史版本数据不需要就先清理再升级】
sql
-- ?换成对应的租户id和项目code
 delete from t_page_config_history where c_tenant_id = ? and c_project = ?

内部资料,请勿外传