Locas 低代码开发平台

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

功能范围

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

版本

v2.8.9，于2024年11月12日发布

FBP接口新增切换身份调试（解决开发站缺乏业务系统基础数据，在开发站以业务系统站里的数据运行）
FBP服务提供服务端事件监听响应功能，提供发布事件task，项目空间项目上配置监听
项目空间页面开发实现多tab编辑
统一低代码平台表前缀为：fbpl_
项目结构调整

更新内容

新增

新增事件发布Task

修复或修改

项目类型调整为：业务开发、前端部件、后端部件、主题，优化开发人员对项目空间功能的使用；
低代码平台表前缀统一为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.9/locas-2.8.9.tgz

基于MAS平台版本

Locas 基于 MAS v5.14.11

微服务版本明细

序号	微应用	Code	版本号	说明
1	低代码引擎	locas-service	2.8.1
2	新低代码引擎	locas-fbp	2.8.1

微应用版本明细

序号	微应用	Code	版本号	更新说明
1	Locas低代码设计器	locas	2.8.9	原maui-pages，对应locas-service
2	PC基础组件	lc-system-tools	v1.0.0.20	获取地址：oss://foa5-oss/deploy/locas/lc-system-tools/
3	低代码项目管理	lc-project-workspace	v5.0.0.34	获取地址：oss://foa5-oss/deploy/locas/lc-project-workspace/

2.7升级至2.8.9

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

sql

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

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

----------------------------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');

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

sql

-- ----------------------------
-- 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,
  "c_tenant_id" numeric(11),
  "c_last_modifier" numeric(20),
  "c_last_modify_time" timestamp(6),
  "c_creator" numeric(20),
  "c_create_time" timestamp(6),
  "c_sort_number" numeric(11),
  "c_text" varchar(50) ,
  "c_icon" varchar(150) ,
  "c_project" varchar(50) ,
  "c_version" varchar(20) ,
  "c_cascade_id" varchar(20) ,
  "c_parent_id" numeric(11),
  "c_type" varchar(20) DEFAULT 'snippet',
	CONSTRAINT "fbpl_app_snippet_catalog_pkey" PRIMARY KEY ("c_id")
);
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';

-- ----------------------------
-- 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,
  "c_tenant_id" numeric(11),
  "c_last_modifier" numeric(20),
  "c_last_modify_time" timestamp(6),
  "c_creator" numeric(20),
  "c_create_time" timestamp(6),
  "c_sort_number" numeric(11),
  "c_name" varchar(500) ,
  "c_path" varchar(500) ,
  "c_category_id" varchar(500) ,
  "c_project" varchar(20) ,
  "c_version" varchar(10),
  CONSTRAINT "fbpl_app_snippet_pages_pkey" PRIMARY KEY ("c_id")
);
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 '项目版本';

-- ----------------------------
-- 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,
  "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),
   CONSTRAINT "fbpl_project_app_setting_pkey" PRIMARY KEY ("c_id")
);
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,
  "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,
  CONSTRAINT "fbpl_project_component_grant_pkey" PRIMARY KEY ("c_id")
);
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 '部件授权项目信息表';

-- ----------------------------
-- 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,
  "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,
  CONSTRAINT "fbpl_project_diy_app_version_pkey" PRIMARY KEY ("c_id")
);
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 '项目应用自定义版本记录表';

-- ----------------------------
-- Table structure for fbpl_app_card_catalog
-- ----------------------------
DROP TABLE IF EXISTS "fbpl_app_card_catalog";
CREATE TABLE "fbpl_app_card_catalog" (
  "c_id" serial8 NOT NULL,
  "c_tenant_id" numeric(11),
  "c_last_modifier" numeric(20),
  "c_last_modify_time" timestamp(6),
  "c_creator" numeric(20),
  "c_create_time" timestamp(6),
  "c_sort_number" numeric(11),
  "c_app_id" numeric(11),
  "c_catalog_id" numeric(11),
  "c_code" varchar(50) ,
  "c_text" varchar(50) ,
  "c_icon" varchar(150) ,
  "c_project" varchar(50) ,
  "c_version" varchar(20) ,
  "c_cascade_id" varchar(20) ,
  "c_parent_id" numeric(11),
  "c_auth" varchar(50) ,
  "c_hidden" varchar(2) ,
  "c_anonymous" varchar(2),
  CONSTRAINT "fbpl_app_card_catalog_pkey" PRIMARY KEY ("c_id")
);
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_app_id" IS '应用id';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_code" IS '分类code';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_text" IS '分类名称';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_icon" IS '分类图标';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_project" IS '项目code';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_version" IS '项目版本';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_cascade_id" IS '级联id';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_parent_id" IS '父id';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_auth" IS '权限规则';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_hidden" IS '是否隐藏';
COMMENT ON COLUMN "fbpl_app_card_catalog"."c_anonymous" IS '匿名访问';

-- 调整表结构
ALTER TABLE "fbpl_project_info" ADD COLUMN "c_manager_id" int8;
COMMENT ON COLUMN "fbpl_project_info"."c_manager_id" IS '项目经理账号id';

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';
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 是';

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_pages"
ADD COLUMN "c_code" varchar(255);
COMMENT ON COLUMN "fbpl_pages"."c_code" IS '页面标识';

-- 项目页面升级用的字段
ALTER TABLE fbpl_version_record
ADD COLUMN c_upgrade_version int4 DEFAULT 0;

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 = ?

Locas 低代码开发平台 ​

功能范围 ​

版本 ​

更新内容 ​

新增 ​

修复或修改 ​

优化 ​

更新资料获取 ​

基于MAS平台版本 ​

微服务版本明细 ​

微应用版本明细 ​

2.7升级至2.8.9 ​

初始化安装 ​