MAS 模块化应用支撑平台 ​

----------------------------------------cos_admin_tenant_info
ALTER TABLE cos_admin_tenant_info RENAME TO fbp_admin_tenant_info;
CREATE SEQUENCE if not exists fbp_admin_tenant_info_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_tenant_info_c_id_seq', (select max(c_id) from fbp_admin_tenant_info));
alter table fbp_admin_tenant_info alter column "c_id" set default nextval('fbp_admin_tenant_info_c_id_seq');


----------------------------------------cos_admin_site_group_info
ALTER TABLE cos_admin_site_group_info RENAME TO fbp_admin_site_group_info;
CREATE SEQUENCE if not exists fbp_admin_site_group_info_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_site_group_info_c_id_seq', (select max(c_id) from fbp_admin_site_group_info));
alter table fbp_admin_site_group_info alter column "c_id" set default nextval('fbp_admin_site_group_info_c_id_seq');


---------------------------------------cos_admin_site_info
ALTER TABLE cos_admin_site_info RENAME TO fbp_admin_site_info;
CREATE SEQUENCE if not exists fbp_admin_site_info_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_site_info_c_id_seq', (select max(c_id) from fbp_admin_site_info));
alter table fbp_admin_site_info alter column "c_id" set default nextval('fbp_admin_site_info_c_id_seq');


---------------------------------------cos_admin_account_info
ALTER TABLE cos_admin_account_info RENAME TO fbp_admin_account_info;
CREATE SEQUENCE if not exists fbp_admin_account_info_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_account_info_c_id_seq', (select max(c_id) from fbp_admin_account_info));
alter table fbp_admin_account_info alter column "c_id" set default nextval('fbp_admin_account_info_c_id_seq');

----------------------------------------cos_admin_account_tenant
ALTER TABLE cos_admin_account_tenant RENAME TO fbp_admin_account_tenant;
CREATE SEQUENCE if not exists fbp_admin_account_tenant_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_account_tenant_c_id_seq', (select max(c_id) from fbp_admin_account_tenant));
alter table fbp_admin_account_tenant alter column "c_id" set default nextval('fbp_admin_account_tenant_c_id_seq');

-----------------------------------------cos_admin_role_info
ALTER TABLE cos_admin_role_info RENAME TO fbp_admin_role_info;
CREATE SEQUENCE if not exists fbp_admin_role_info_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_role_info_c_id_seq', (select max(c_id) from fbp_admin_role_info));
alter table fbp_admin_role_info alter column "c_id" set default nextval('fbp_admin_role_info_c_id_seq');

-----------------------------------------cos_admin_role_mapping
ALTER TABLE cos_admin_role_mapping RENAME TO fbp_admin_role_mapping;
CREATE SEQUENCE if not exists fbp_admin_role_mapping_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_role_mapping_c_id_seq', (select max(c_id) from fbp_admin_role_mapping));
alter table fbp_admin_role_mapping alter column "c_id" set default nextval('fbp_admin_role_mapping_c_id_seq');

-----------------------------------------cos_admin_init_menu
ALTER TABLE cos_admin_init_menu RENAME TO fbp_admin_init_menu;
CREATE SEQUENCE if not exists fbp_admin_init_menu_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_init_menu_c_id_seq', (select max(c_id) from fbp_admin_init_menu));
alter table fbp_admin_init_menu alter column "c_id" set default nextval('fbp_admin_init_menu_c_id_seq');

-----------------------------------------cos_portal_diy_menu
ALTER TABLE cos_portal_diy_menu RENAME TO fbp_portal_diy_menu;
CREATE SEQUENCE if not exists fbp_portal_diy_menu_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_portal_diy_menu_c_id_seq', (select max(c_id) from fbp_portal_diy_menu));
alter table fbp_portal_diy_menu alter column "c_id" set default nextval('fbp_portal_diy_menu_c_id_seq');

-----------------------------------------cos_portal_component
ALTER TABLE cos_portal_component RENAME TO fbp_portal_component;
CREATE SEQUENCE if not exists fbp_portal_component_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_portal_component_c_id_seq', (select max(c_id) from fbp_portal_component));
alter table fbp_portal_component alter column "c_id" set default nextval('fbp_portal_component_c_id_seq');

------------------------------------------cos_portal_component_grant
ALTER TABLE cos_portal_component_grant RENAME TO fbp_portal_component_grant;
CREATE SEQUENCE if not exists fbp_portal_component_grant_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_portal_component_grant_c_id_seq', (select max(c_id) from fbp_portal_component_grant));
alter table fbp_portal_component_grant alter column "c_id" set default nextval('fbp_portal_component_grant_c_id_seq');

-------------------------------------------cos_portal_import_record
ALTER TABLE cos_portal_import_record RENAME TO fbp_portal_import_record;
CREATE SEQUENCE if not exists fbp_portal_import_record_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_portal_import_record_c_id_seq', (select max(c_id) from fbp_portal_import_record));
alter table fbp_portal_import_record alter column "c_id" set default nextval('fbp_portal_import_record_c_id_seq');

-------------------------------------------cos_site_component_grant
ALTER TABLE cos_site_component_grant RENAME TO fbp_site_component_grant;

CREATE SEQUENCE if not exists fbp_site_component_grant_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_site_component_grant_c_id_seq', (select max(c_id) from fbp_site_component_grant));
alter table fbp_site_component_grant alter column "c_id" set default nextval('fbp_site_component_grant_c_id_seq');

-------------------------------------------cos_app_publish_log
ALTER TABLE cos_app_publish_log RENAME TO fbp_app_publish_log;
CREATE SEQUENCE if not exists fbp_app_publish_log_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_app_publish_log_c_id_seq', (select max(c_id) from fbp_app_publish_log));
alter table fbp_app_publish_log alter column "c_id" set default nextval('fbp_app_publish_log_c_id_seq');

--------------------------------------------cos_portal_app_version
ALTER TABLE cos_portal_app_version RENAME TO fbp_portal_app_version;
CREATE SEQUENCE if not exists fbp_portal_app_version_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_portal_app_version_c_id_seq', (select max(c_id) from fbp_portal_app_version));
alter table fbp_portal_app_version alter column "c_id" set default nextval('fbp_portal_app_version_c_id_seq');

--------------------------------------------cos_portal_diy_app_version
ALTER TABLE cos_portal_diy_app_version RENAME TO fbp_portal_diy_app_version;
CREATE SEQUENCE if not exists fbp_portal_diy_app_version_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_portal_diy_app_version_c_id_seq', (select max(c_id) from fbp_portal_diy_app_version));
alter table fbp_portal_diy_app_version alter column "c_id" set default nextval('fbp_portal_diy_app_version_c_id_seq');

-------------------------------------------cos_admin_maintain_log
ALTER TABLE cos_admin_maintain_log RENAME TO fbp_admin_maintain_log;
CREATE SEQUENCE if not exists fbp_admin_maintain_log_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_admin_maintain_log_c_id_seq', (select max(c_id) from fbp_admin_maintain_log));
alter table fbp_admin_maintain_log alter column "c_id" set default nextval('fbp_admin_maintain_log_c_id_seq');

-------------------------------------------t_app_catalog_mapping
ALTER TABLE t_app_catalog_mapping RENAME TO fbp_app_catalog_mapping;
CREATE SEQUENCE if not exists fbp_app_catalog_mapping_c_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 999999999
START 1
CACHE 1;
select setval('fbp_app_catalog_mapping_c_id_seq', (select max(c_id) from fbp_app_catalog_mapping));
alter table fbp_app_catalog_mapping alter column "c_id" set default nextval('fbp_app_catalog_mapping_c_id_seq');

-- ----------------------------
-- Table structure for feign_redirect_record
-- ----------------------------
DROP TABLE IF EXISTS "feign_redirect_record";
CREATE TABLE "feign_redirect_record" (
  "c_id" serial8 NOT NULL,
  "c_origin_service_name" varchar(200) ,
  "c_new_service_name" varchar(200) ,
  "c_origin_url" varchar(2000) ,
  "c_new_url" varchar(2000),
  CONSTRAINT "feign_redirect_record_pkey" PRIMARY KEY ("c_id")
);

DROP TABLE IF EXISTS "fbp_ops_notice";
CREATE TABLE "fbp_ops_notice" (
  "c_id" serial8 NOT NULL,
  "c_msg" varchar(4000) ,
  "c_publish_time" timestamp(6),
  "c_over_time" timestamp(6),
  "c_keep_days" int4,
  "c_creator" varchar(50) ,
	"c_creator_id" int8,
  "c_create_time" timestamp(6),
  "c_status" varchar(4),
  CONSTRAINT "fbp_ops_notice_pkey" PRIMARY KEY ("c_id")
);
COMMENT ON COLUMN "fbp_ops_notice"."c_msg" IS '公告内容';
COMMENT ON COLUMN "fbp_ops_notice"."c_publish_time" IS '发布时间';
COMMENT ON COLUMN "fbp_ops_notice"."c_over_time" IS '过期时间';
COMMENT ON COLUMN "fbp_ops_notice"."c_keep_days" IS '保持天数';
COMMENT ON COLUMN "fbp_ops_notice"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_ops_notice"."c_creator_id" IS '创建人Id';
COMMENT ON COLUMN "fbp_ops_notice"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_ops_notice"."c_status" IS '是否发布：1已发布0未发布';

DROP TABLE IF EXISTS "fbp_ops_notice_recieved";
CREATE TABLE "fbp_ops_notice_recieved" (
  "c_id" serial8 NOT NULL,
  "c_msg_id" int8 ,
  "c_reciever_time" timestamp(6),
  "c_reciever_id" int8,
  "c_reciever" varchar(100),
  CONSTRAINT "fbp_ops_notice_recieved_pkey" PRIMARY KEY ("c_id")
);
COMMENT ON COLUMN "fbp_ops_notice_recieved"."c_msg_id" IS '公告id';
COMMENT ON COLUMN "fbp_ops_notice_recieved"."c_reciever_time" IS '签收时间';
COMMENT ON COLUMN "fbp_ops_notice_recieved"."c_reciever_id" IS '签收人id';
COMMENT ON COLUMN "fbp_ops_notice_recieved"."c_reciever" IS '签收人';


DROP TABLE IF EXISTS "fbp_admin_login_log";
CREATE TABLE "fbp_admin_login_log" (
  "c_id" serial8 NOT NULL,
  "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_operation_type" int4,
  "c_login_name" varchar(32) ,
  "c_result" bit(1),
  "c_login_type" int4,
  "c_session_id" varchar(200) ,
  "c_operation_client_ip" varchar(64) ,
  "c_operation_client_mac" varchar(64) ,
  "c_operation_user_agent" varchar(500) ,
  "c_result_message" varchar(4000) ,
  "c_site_id" int8,
  "c_site_group_id" int8,
  CONSTRAINT "fbp_admin_login_log_pkey" PRIMARY KEY ("c_id")
);
COMMENT ON COLUMN "fbp_admin_login_log"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_login_log"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_login_log"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_login_log"."c_creator" IS '创建人（登录人）';
COMMENT ON COLUMN "fbp_admin_login_log"."c_create_time" IS '创建时间（登录时间）';
COMMENT ON COLUMN "fbp_admin_login_log"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_login_log"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_login_log"."c_operation_type" IS '操作类型：1 登录  2 登出  3 其它';
COMMENT ON COLUMN "fbp_admin_login_log"."c_login_name" IS '登录账号';
COMMENT ON COLUMN "fbp_admin_login_log"."c_result" IS '操作结果 true 成功 false 失败';
COMMENT ON COLUMN "fbp_admin_login_log"."c_login_type" IS '登陆方式 1账号密码登录  2浙政钉扫码  3 浙政钉免登  4 钉钉扫码  5 平台fbp单点登录  6 钉钉免登';
COMMENT ON COLUMN "fbp_admin_login_log"."c_session_id" IS '会话id';
COMMENT ON COLUMN "fbp_admin_login_log"."c_operation_client_ip" IS '访问客户端IP';
COMMENT ON COLUMN "fbp_admin_login_log"."c_operation_client_mac" IS '访问客户端MAC';
COMMENT ON COLUMN "fbp_admin_login_log"."c_operation_user_agent" IS '访问浏览器user-agent';
COMMENT ON COLUMN "fbp_admin_login_log"."c_result_message" IS '报错信息';
COMMENT ON COLUMN "fbp_admin_login_log"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_login_log"."c_site_group_id" IS '站群id';

CREATE TABLE "fbp_events" (
  "c_id" serial8 NOT NULL,
  "c_creator" varchar(50),
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_tenant_id" int8,
  "c_app_code" varchar(100),
  "c_event_code" varchar(100),
  "c_path" varchar(200)
);
COMMENT ON COLUMN "fbp_events"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_events"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_events"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_events"."c_sort_number" IS '排序好';
COMMENT ON COLUMN "fbp_events"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_events"."c_app_code" IS '应用标识';
COMMENT ON COLUMN "fbp_events"."c_event_code" IS '事件标识';
COMMENT ON COLUMN "fbp_events"."c_path" IS '事件响应服务（函数）path';
COMMENT ON TABLE "fbp_events" IS 'fbp服务事件表';

-- ----------------------------
-- Table structure for fbp_app_catalog
-- ----------------------------
DROP TABLE IF EXISTS "fbp_app_catalog";
CREATE TABLE "fbp_app_catalog" (
  "c_id" serial8 NOT NULL,
  "c_catalog_code" varchar(50) ,
  "c_catalog_name" varchar(500),
  CONSTRAINT "fbp_app_catalog_pkey" PRIMARY KEY ("c_id")
);
COMMENT ON COLUMN "fbp_app_catalog"."c_catalog_code" IS '分类code';
COMMENT ON COLUMN "fbp_app_catalog"."c_catalog_name" IS '分类名';

------------------
-- 调整表结构
------------------

ALTER TABLE fbp_admin_maintain_log 
ADD COLUMN c_site_id int8,
ADD COLUMN c_site_group_id int8;
COMMENT ON COLUMN "fbp_admin_maintain_log"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_admin_maintain_log"."c_site_group_id" IS '站群ID';

ALTER TABLE fbp_portal_component ADD COLUMN c_is_login varchar(2) DEFAULT '0';
COMMENT ON COLUMN "fbp_portal_component"."c_is_login" IS '是否是登录应用 0 否 1 是';

ALTER TABLE fbp_admin_site_group_info 
ADD COLUMN "c_config" text,
ADD COLUMN "c_desc" varchar(2000);
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_config" IS '站群设置';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_desc" IS '站群备注';

UPDATE fbp_admin_site_group_info 
SET c_config = '{"pwd":{"algorithm":"bcrypt","secretKey":"3c25d38f657ba55ab909996d6eb0e2ed","check":{"complexity":"0.75","rule":"^(?![a-zA-z]+$)(?!\\d+$)(?![!@#$%^&*]+$)[a-zA-Z\\d!@#$%^&*]{8,}$","msg":"密码须包含字母、数字、特殊字符!@#$%^&*且至少8位"},"tipModify":{"enable":false,"cycle":90}},"defaultPassword":"Zktx%13579","sensitiveInfo":{"encode":false,"sm4Key":"f8ffdfe06a1ddcdb38028d66be8d25e0","sm4Iv":"3c25d38f657ba55ab909996d6eb0e2ed"},"login":{"scanDoubleValid":false,"pwdDbVaild":false,"inputError":{"limit":5,"locked":10},"checkInitFm":false}}' ;
	
--清理待升级版本的应用数据
delete from fbp_portal_app_version where c_app_code in ('mas-explorer',lc-syscachemng','lc-userpwdlogin','lc-modify-pwd','lc-unlocklogin',theme-vertical-blue','lc-fbppdsm','lc-pcache','lc-pstorage',locar','locas');
delete from fbp_app_publish_log where c_app_code in ('mas-explorer',lc-syscachemng','lc-userpwdlogin','lc-modify-pwd','lc-unlocklogin','theme-vertical-blue','lc-fbppdsm','lc-pcache','lc-pstorage',locar','locas');
delete from fbp_portal_component where c_code in ('mas-explorer',lc-syscachemng','lc-userpwdlogin','lc-modify-pwd','lc-unlocklogin','theme-vertical-blue','lc-fbppdsm','lc-pcache','lc-pstorage',locar','locas');

-- 清理所有站点原管理应用的授权
delete from fbp_site_component_grant where c_app_code like 'mas-ops-%' or c_app_code like 'mas-admin-%';

-- 清理平台系统管理站点原管理应用的授权
delete from fbp_site_component_grant where c_site_id = (select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage' ) and (c_app_code like 'mas-ops-%' or c_app_code like 'mas-admin-%' or c_app_code = 'locas');

-- 清理平台站点原管理应用的授权
delete from fbp_site_component_grant where c_site_id = (select c_id from fbp_admin_site_info where c_code = 'sys' ) and (c_app_code like 'mas-ops-%' or c_app_code like 'mas-admin-%' or c_app_code = 'locas');

-- 清理平台系统站点菜单数据
delete from fbp_admin_init_menu where c_site_id = (select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage');

-- 清理平台运维站点菜单数据
delete from fbp_admin_init_menu where c_site_id = (select c_id from fbp_admin_site_info where c_code = 'sys');

---初始化lc-ops
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-ops','v1.0.0.5');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-ops-v1.0.0.5.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-ops','v1.0.0.5');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-ops','v1.0.0.5','平台运维',0,0,'["app","page","print"]',now());

---初始化lc-admin
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-admin','v1.1.0.12');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-admin-v1.1.0.12.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-admin','v1.1.0.12');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-admin','v1.1.0.12','系统管理',0,0,'["app","page","print"]',now());

---初始化mas-explorer
insert into fbp_portal_app_version(c_app_code,c_app_version) values('mas-explorer','5.14.11');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'mas-explorer-5.14.11.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('mas-explorer','5.14.11');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','mas-explorer','5.14.11','PC资源管理',0,0,'["app","page","print"]',now());

---初始化locar
insert into fbp_portal_app_version(c_app_code,c_app_version) values('locar','2.8.9');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'locar-2.8.9.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('locar','2.8.9');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','locar','2.8.9','页面引擎',0,0,'["app","page","print","mobile"]',now());

---初始化lc-userpwdlogin
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-userpwdlogin','v1.1.0.14');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-userpwdlogin-v1.1.0.14.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-userpwdlogin','v1.1.0.14');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time,c_is_login) values('中科天翔','lc-userpwdlogin','v1.1.0.14','账号密码登录',0,0,'["app","page","print"]',now(),'1');

---初始化lc-modify-pwd
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-modify-pwd','v1.0.0.7');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-modify-pwd-v1.0.0.7.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-modify-pwd','v1.0.0.7');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-modify-pwd','v1.0.0.7','修改密码',0,0,'["app","page","print"]',now());

---初始化lc-unlocklogin
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-unlocklogin','v1.1.0.2');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-unlocklogin-v1.1.0.2.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-unlocklogin','v1.1.0.2');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-unlocklogin','v1.1.0.2','解锁',0,0,'["app","page","print"]',now());

---初始化lc-syscachemng
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-syscachemng','v1.1.0.2');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-syscachemng-v1.1.0.2.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-syscachemng','v1.1.0.2');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-syscachemng','v1.1.0.2','缓存清理',0,0,'["app","page","print"]',now());

---初始化theme-vertical-blue
insert into fbp_portal_app_version(c_app_code,c_app_version) values('theme-vertical-blue','5.14.11');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'theme-vertical-blue-5.14.11.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('theme-vertical-blue','5.14.11');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','theme-vertical-blue','5.14.11','纵向导航主题',0,0,'["app","page","print"]',now());

----初始化lc-fbppdsm
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-fbppdsm','v1.1.0.2');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-fbppdsm-v1.1.0.2.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-fbppdsm','v1.1.0.2');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-fbppdsm','v1.1.0.2','数据源(平台)',0,0,'["app","page","print"]',now());

----初始化lc-pstorage
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-pstorage','v1.1.0.2');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-pstorage-v1.1.0.2.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-pstorage','v1.1.0.2');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-pstorage','v1.1.0.2','存储(平台)',0,0,'["app","page","print"]',now());

----初始化lc-pcache
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-pcache','v1.1.0.2');
insert into fbp_portal_import_record(c_tenant_id,c_result,c_file_name) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),0,'lc-pcache-v1.1.0.2.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-pcache','v1.1.0.2');
insert into fbp_portal_component(c_auth_name,c_code,c_version,c_text,c_is_auth,c_app_type,c_modes,c_create_time) values('中科天翔','lc-pcache','v1.1.0.2','缓存(平台)',0,0,'["app","page","print"]',now());

---授权应用到sys租户
insert into fbp_portal_component_grant(c_tenant_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),'lc-ops');
insert into fbp_portal_component_grant(c_tenant_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),'lc-admin');
insert into fbp_portal_component_grant(c_tenant_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),'theme-vertical-blue');
insert into fbp_portal_component_grant(c_tenant_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),'lc-modify-pwd');
insert into fbp_portal_component_grant(c_tenant_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),'lc-unlocklogin');

--- 应用授权到租户sys下的平台站点（sys）
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys'),'lc-ops');
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys'),'lc-admin');
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys'),'lc-modify-pwd');
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys'),'lc-unlocklogin');

--- 应用授权到租户sys下的管理站点（sys_sg_manage）
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage'),'lc-admin');
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage'),'theme-vertical-blue');
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage'),'lc-modify-pwd');
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) values((select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage'),'lc-unlocklogin');

----------------
-- 初始化系统管理站菜单
---------------
INSERT INTO "fbp_admin_init_menu"("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_site_id", "c_tenant_id", "c_navs") VALUES (1, now(), 1, now(),  (select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage'), (select c_id from fbp_admin_tenant_info where c_code = 'sys'), '[{"path":"/lc-syscachemng/page/cachemain","isDyn":"1","auth":"r.default","icon":"el-icon-s-open","id":1725444706700,"text":"缓存清理","title":"缓存清理","parentId":109,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/zdgl/site-set","isDyn":"1","auth":"r.default","icon":"el-icon-s-tools","id":1725521367602,"text":"站点设置","title":"站点设置","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/zhgl/account-management","isDyn":"1","auth":"r.default","icon":"el-icon-s-ticket","id":1725521367602,"text":"账号管理","title":"账号管理","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/zdgl/site-list","isDyn":"1","auth":"r.default","icon":"el-icon-s-home","id":1725521367602,"text":"站点管理","title":"站点管理","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/zdgl/site-group-set","isDyn":"1","auth":"r.default","icon":"el-icon-s-operation","id":1725521367602,"text":"站群设置","title":"系统设置","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/main/3f856ec241d67b94402699ed313d714f","auth":"r.default","icon":"el-icon-s-custom","title":"角色管理","isDiy":"1","hidden":false,"isLeaf":false,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"anonymous":false,"easyvUrl":"","easyvKey":"","children":[{"path":"/lc-admin/jsgl/role-list","isDyn":"1","auth":"r.default","icon":"el-icon-s-custom","id":1725521367602,"text":"角色管理","title":"角色维护","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/jsgl/role-grant-list","isDyn":"1","auth":"r.default","icon":"el-icon-s-check","id":1725521367602,"text":"角色授权","title":"角色授权","parentId":107}]},{"path":"/lc-admin/cdgl/init-menu","isDyn":"1","auth":"r.default","icon":"el-icon-s-grid","id":1725521367602,"text":"菜单管理","title":"菜单管理","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/lc-admin115","isDyn":"1","auth":"r.default","children":[{"path":"/lc-admin/czrz/mas_admin_log","isDyn":"1","auth":"r.default","icon":"el-icon-place","id":1725521367708,"text":"登录日志","title":"登录日志","parentId":115,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/glrz/manage-log","isDyn":"1","auth":"r.default","icon":"el-icon-toilet-paper","id":1725521367708,"text":"管理日志","title":"管理日志","parentId":115,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}],"icon":"el-icon-s-order","id":115,"title":"系统日志","parentId":0,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}]');

----------------
-- 初始化平台管理站菜单
---------------
INSERT INTO "fbp_admin_init_menu"("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_site_id", "c_tenant_id", "c_navs") VALUES (1, now(), 1, now(),  (select c_id from fbp_admin_site_info where c_code = 'sys'), (select c_id from fbp_admin_tenant_info where c_code = 'sys'), '[{"path":"/lc-syscachemng/page/cachemain","isDyn":"1","auth":"r.default","icon":"el-icon-s-open","id":1725444706700,"text":"缓存清理","title":"缓存清理","parentId":109,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/main/4c8fe6632cd172418095149bbe33bd21","auth":"r.default","icon":"el-icon-s-cooperation","title":"DSC管理","isDiy":"1","hidden":false,"isLeaf":false,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"anonymous":false,"easyvUrl":"","easyvKey":"","children":[{"path":"/lc-fbppdsm/datasource/datasource-list","isDyn":"1","auth":"r.default","icon":"el-icon-coin","id":1721112387738,"text":"数据源管理","title":"数据源管理","parentId":86,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-pstorage/ccgl/list","isDyn":"1","auth":"r.default","icon":"el-icon-wallet","id":1721112439891,"text":"存储管理","title":"存储管理","parentId":88,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-pcache/hcgl/cache-list","isDyn":"1","auth":"r.default","icon":"el-icon-cloudy","id":1721112413455,"text":"缓存管理","title":"缓存管理","parentId":93,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}]},{"path":"/main/4805c385a630dc2302a24e54b27b16a8","auth":"r.default","icon":"el-icon-s-goods","title":"应用管理","isDiy":"1","hidden":false,"isLeaf":false,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"anonymous":false,"easyvUrl":"","easyvKey":"","children":[{"path":"/lc-ops/yysj/appinstall","isDyn":"1","auth":"r.default","icon":"el-icon-s-operation","id":1725428354640,"text":"应用管理","title":"应用上架","parentId":108,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-ops/yyflgl/appcataloglist","isDyn":"1","auth":"r.default","icon":"el-icon-s-grid","id":1725428354640,"text":"应用分类","title":"应用分类","parentId":108,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}]},{"path":"/lc-ops/zhgl/tenant-management","isDyn":"1","auth":"r.default","icon":"el-icon-discount","id":1725428354640123,"text":"租户管理","title":"租户管理","parentId":100,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-ops/zqgl/site-group-list","isDyn":"1","auth":"r.default","icon":"el-icon-office-building","id":1725428354640456,"text":"站群管理","title":"站群管理","parentId":101,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/zdgl/site-list","isDyn":"1","auth":"r.default","icon":"el-icon-s-home","id":1725521367602,"text":"站点管理","title":"站点管理","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/lc-admin115","isDyn":"1","auth":"r.default","children":[{"path":"/lc-admin/czrz/mas_admin_log","isDyn":"1","auth":"r.default","icon":"el-icon-place","id":1725521367708,"text":"登录日志","title":"登录日志","parentId":115,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/glrz/manage-log","isDyn":"1","auth":"r.default","icon":"el-icon-toilet-paper","id":1725521367708,"text":"管理日志","title":"管理日志","parentId":115,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}],"icon":"el-icon-s-order","id":115,"title":"系统日志","parentId":0,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-ops/ywgg/devops-notice-list","isDyn":"1","auth":"r.default","icon":"el-icon-message-solid","id":1725428354640,"text":"公告管理","title":"运维公告","parentId":108,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}]');

-- 将原应用分类数据从数据字典迁移到新表
insert into fbp_app_catalog(c_catalog_code,c_catalog_name) select c_code,c_value from cos_basicdata_dictionary_item where c_site_id = (select c_id from fbp_admin_site_info where c_code = 'sys') and c_dic_key = 'appCategory';

-- 将新应用关联分类
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ( '1', 'lc-ops');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ( '1', 'lc-admin');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ( '1', 'lc-modify-pwd');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('1', 'lc-unlocklogin');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('1', 'theme-vertical-blue');

--  将管理站点授权lc-admin应用
insert into fbp_site_component_grant(c_tenant_id,c_site_id,c_app_code) select c_tenant_id,c_id as c_site_id,'lc-admin' as c_app_code from fbp_admin_site_info where c_is_manage_site = 1 and c_code not in ('sys','sys_sg_manage');

-- 清理其它管理站点菜单数据
delete from fbp_admin_init_menu  where c_site_id in (select c_id from fbp_admin_site_info where c_is_manage_site = 1 and c_code not in ('sys','sys_sg_manage'));

-- 初始化管理站点系统默认菜单
INSERT INTO fbp_admin_init_menu("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_site_id", "c_tenant_id", "c_navs") select 1 as c_last_modifier,now() as  c_last_modifier,1 as c_creator,now() as  c_create_time,c_id as c_site_id,c_tenant_id,'[{"path":"/lc-syscachemng/page/cachemain","isDyn":"1","auth":"r.default","icon":"el-icon-s-open","id":1725444706700,"text":"缓存清理","title":"缓存清理","parentId":109,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/site-set","isDyn":"1","auth":"r.default","icon":"el-icon-s-tools","id":1725521367602,"text":"站点设置","title":"站点设置","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/account-management","isDyn":"1","auth":"r.default","icon":"el-icon-s-ticket","id":1725521367602,"text":"账号管理","title":"账号管理","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/site-list","isDyn":"1","auth":"r.default","icon":"el-icon-s-home","id":1725521367602,"text":"站点管理","title":"站点管理","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/site-group-set","isDyn":"1","auth":"r.default","icon":"el-icon-s-operation","id":1725521367602,"text":"站群设置","title":"系统设置","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/main/3f856ec241d67b94402699ed313d714f","auth":"r.default","icon":"el-icon-s-custom","title":"角色管理","isDiy":"1","hidden":false,"isLeaf":false,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"anonymous":false,"easyvUrl":"","easyvKey":"","children":[{"path":"/lc-admin/role-list","isDyn":"1","auth":"r.default","icon":"el-icon-s-custom","id":1725521367602,"text":"角色管理","title":"角色维护","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/role-grant-list","isDyn":"1","auth":"r.default","icon":"el-icon-s-check","id":1725521367602,"text":"角色授权","title":"角色授权","parentId":107}]},{"path":"/lc-admin/init-menu","isDyn":"1","auth":"r.default","icon":"el-icon-s-grid","id":1725521367602,"text":"菜单管理","title":"菜单管理","parentId":107,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/lc-admin115","isDyn":"1","auth":"r.default","children":[{"path":"/lc-admin/mas_admin_log","isDyn":"1","auth":"r.default","icon":"el-icon-place","id":1725521367708,"text":"登录日志","title":"登录日志","parentId":115,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/manage-log","isDyn":"1","auth":"r.default","icon":"el-icon-toilet-paper","id":1725521367708,"text":"管理日志","title":"管理日志","parentId":115,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}],"icon":"el-icon-s-order","id":115,"title":"系统日志","parentId":0,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""}]' as c_navs from fbp_admin_site_info where c_is_manage_site = 1 and c_code not in ('sys','sys_sg_manage');