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

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

ALTER TABLE fbp_datasource RENAME  TO fbp_datasource_tmp;

DROP TABLE IF EXISTS "fbp_datasource";
CREATE TABLE "fbp_datasource" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_name" varchar(255) ,
  "c_type" int2,
  "c_url" varchar(1000) ,
  "c_user" varchar(255) ,
  "c_password" varchar(255) ,
  "c_remark" varchar(255) ,
  "c_code" varchar(255) ,
  "c_level" int2,
  "c_site_group_id" int8,
  "c_initialsize" int2,
  "c_minidle" int2,
  "c_maxsize" int2,
  "c_driverclassname" varchar(1000)
);
COMMENT ON COLUMN "fbp_datasource"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_datasource"."c_name" IS '数据源名称';
COMMENT ON COLUMN "fbp_datasource"."c_type" IS '数据源类型，1-MySQL，2-Oracle，3-达梦，4-polardb,5-postgres,6-人大金仓,7-神通';
COMMENT ON COLUMN "fbp_datasource"."c_url" IS '数据源url';
COMMENT ON COLUMN "fbp_datasource"."c_user" IS '用户名';
COMMENT ON COLUMN "fbp_datasource"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_datasource"."c_remark" IS '备注';
COMMENT ON COLUMN "fbp_datasource"."c_code" IS '唯一标识';
COMMENT ON COLUMN "fbp_datasource"."c_level" IS '数据源级别，1-平台级，2-租户级';
COMMENT ON COLUMN "fbp_datasource"."c_site_group_id" IS '所属站群id（站点级）';
COMMENT ON COLUMN "fbp_datasource"."c_initialsize" IS '初始化连接数';
COMMENT ON COLUMN "fbp_datasource"."c_minidle" IS '最小连接数';
COMMENT ON COLUMN "fbp_datasource"."c_maxsize" IS '最大连接数';
COMMENT ON COLUMN "fbp_datasource"."c_driverclassname" IS '数据源驱动类';
COMMENT ON TABLE "fbp_datasource" IS '数据源信息';

-- ----------------------------
-- Table structure for feign_redirect_record
-- ----------------------------
DROP TABLE IF EXISTS "feign_redirect_record";
CREATE TABLE "feign_redirect_record" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_origin_service_name" varchar(200) ,
  "c_new_service_name" varchar(200) ,
  "c_origin_url" varchar(2000) ,
  "c_new_url" varchar(2000)
);
COMMENT ON COLUMN "feign_redirect_record"."c_id" IS '主键id';
COMMENT ON COLUMN "feign_redirect_record"."c_origin_service_name" IS '原微服务名';
COMMENT ON COLUMN "feign_redirect_record"."c_new_service_name" IS '新微服务名';
COMMENT ON COLUMN "feign_redirect_record"."c_origin_url" IS '原服务地址';
COMMENT ON COLUMN "feign_redirect_record"."c_new_url" IS '新服务地址';
COMMENT ON TABLE "feign_redirect_record" IS 'feign转发映射表';

-- ----------------------------
-- Table structure for fbp_ops_notice
-- ----------------------------
DROP TABLE IF EXISTS "fbp_ops_notice";
CREATE TABLE "fbp_ops_notice" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "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)
);
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未发布';
COMMENT ON TABLE "fbp_ops_notice" IS '运维通知表';

-- ----------------------------
-- Table structure for fbp_ops_notice_recieved
-- ----------------------------
DROP TABLE IF EXISTS "fbp_ops_notice_recieved";
CREATE TABLE "fbp_ops_notice_recieved" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_msg_id" int8 ,
  "c_reciever_time" timestamp(6),
  "c_reciever_id" int8,
  "c_reciever" varchar(100)
);
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 '签收人';
COMMENT ON TABLE "fbp_ops_notice_recieved" IS '运维通知签收表';


---------
--登录日志
--------
-- ----------------------------
-- Table structure for fbp_admin_login_log
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_login_log";
CREATE TABLE "fbp_admin_login_log" (
  "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_operation_type" int4,
  "c_login_name" varchar(32) ,
  "c_result" int2 DEFAULT 0,
  "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
);
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';
COMMENT ON TABLE "fbp_admin_login_log" IS '登录日志表';

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服务事件表';


DROP TABLE IF EXISTS "fbp_path";
CREATE TABLE "fbp_path" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_tenant_id" int8,
  "c_tenant_code" varchar(32) ,
  "c_site_id" int4,
  "c_site_code" varchar(32) ,
  "c_path" varchar(255) ,
  "c_remark" varchar(255)
);
COMMENT ON COLUMN "fbp_path"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_path"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_path"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_path"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_path"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_path"."c_tenant_code" IS '租户code';
COMMENT ON COLUMN "fbp_path"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_path"."c_site_code" IS '站点code';
COMMENT ON COLUMN "fbp_path"."c_path" IS '访问路径';
COMMENT ON COLUMN "fbp_path"."c_remark" IS '备注';
COMMENT ON TABLE "fbp_path" IS '站点地址表';


DROP TABLE IF EXISTS "fbp_admin_account_grant";
CREATE TABLE "fbp_admin_account_grant" (
  "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_account_id" int8
);
COMMENT ON COLUMN "fbp_admin_account_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_grant"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_grant"."c_account_id" IS '账号id';
COMMENT ON TABLE "fbp_admin_account_grant" IS '租户管理授权表';


DROP TABLE IF EXISTS "fbp_path_domain";
CREATE TABLE "fbp_path_domain" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_domain" varchar(255)
);
COMMENT ON COLUMN "fbp_path_domain"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_path_domain"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_path_domain"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_path_domain"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_path_domain"."c_domain" IS '域名';
COMMENT ON TABLE "fbp_path_domain" IS '域名黑名单';


DROP TABLE IF EXISTS "fbp_app_param_setting";
CREATE TABLE "fbp_app_param_setting" (
	"c_id" serial8 NOT NULL PRIMARY KEY,
	"c_key" varchar(100),
	"c_value" varchar(2000),
	"c_name" varchar(255),
	"c_desc" varchar(1000),
	"c_type" varchar(10),
	"c_catalog" varchar(10),
	"c_app_code" varchar(100),
	"c_app_name" varchar(255),
	"c_app_version" varchar(100),
	"c_tenant_id" int8,   -- 平台的
	"c_site_group_id" int8,
	"c_site_id" int8
);
COMMENT ON COLUMN "fbp_app_param_setting"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_app_param_setting"."c_tenant_id" IS '租户ID,平台级别的为空';
COMMENT ON COLUMN "fbp_app_param_setting"."c_key" IS '标识';
COMMENT ON COLUMN "fbp_app_param_setting"."c_value" IS '值';
COMMENT ON COLUMN "fbp_app_param_setting"."c_desc" IS '描述';
COMMENT ON COLUMN "fbp_app_param_setting"."c_type" IS '类型：1平台，2站点';
COMMENT ON COLUMN "fbp_app_param_setting"."c_catalog" IS '分类：1数据源，2缓存，3存储，4参数';
COMMENT ON COLUMN "fbp_app_param_setting"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_app_param_setting"."c_app_name" IS '应用名称';
COMMENT ON COLUMN "fbp_app_param_setting"."c_app_version" IS '应用版本';
COMMENT ON COLUMN "fbp_app_param_setting"."c_site_group_id" IS '站群ID,平台级别的为空';
COMMENT ON COLUMN "fbp_app_param_setting"."c_site_id" IS '站点ID,平台级别的为空';
COMMENT ON TABLE "fbp_app_param_setting" IS '应用参数配置表';


-----------------------------
--第三方接入
------------------------------
DROP TABLE IF EXISTS "fbp_third_party_info";
CREATE TABLE "fbp_third_party_info" (
  "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_site_id" int8,
  "c_business_tenant_id" int8,
  "c_business_site_id" int8,
  "c_name" varchar(50) ,
  "c_type" int4,
  "c_description" varchar(255) ,
  "c_access_key" varchar(50) ,
  "c_secret_key" varchar(50) ,
  "c_status" int4
);
COMMENT ON COLUMN "fbp_third_party_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_third_party_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_third_party_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_third_party_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_third_party_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_third_party_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_third_party_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_third_party_info"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_third_party_info"."c_business_tenant_id" IS '接入租户ID';
COMMENT ON COLUMN "fbp_third_party_info"."c_business_site_id" IS '接入站点ID';
COMMENT ON COLUMN "fbp_third_party_info"."c_name" IS '接入方名称';
COMMENT ON COLUMN "fbp_third_party_info"."c_type" IS '类型 0.需要时间戳校验 1.不需要时间戳校验 默认为0';
COMMENT ON COLUMN "fbp_third_party_info"."c_description" IS '描述';
COMMENT ON COLUMN "fbp_third_party_info"."c_access_key" IS 'appId';
COMMENT ON COLUMN "fbp_third_party_info"."c_secret_key" IS 'appSecret';
COMMENT ON COLUMN "fbp_third_party_info"."c_status" IS '状态 1启用0停用';
COMMENT ON TABLE "fbp_third_party_info" IS '第三方接入信息表';

DROP TABLE IF EXISTS "fbp_open_api";
CREATE TABLE "fbp_open_api" (
  "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_site_id" "int8",
  "c_module_name" varchar(255) ,
  "c_name" varchar(255) ,
  "c_path" varchar(255) ,
  "c_description" varchar(255), 
  "c_expression" varchar(500) 
);
COMMENT ON COLUMN "fbp_open_api"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_open_api"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_open_api"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_open_api"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_open_api"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_open_api"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_open_api"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_open_api"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_open_api"."c_module_name" IS '模块名';
COMMENT ON COLUMN "fbp_open_api"."c_name" IS '名称';
COMMENT ON COLUMN "fbp_open_api"."c_path" IS '请求地址';
COMMENT ON COLUMN "fbp_open_api"."c_description" IS '描述';
COMMENT ON COLUMN "fbp_open_api"."c_expression" IS '接口权限表达式（fbp接口xml上需配有p.thirdreq权限才可开放给第三方使用）';
COMMENT ON TABLE "fbp_open_api" IS '授权api信息表';


DROP TABLE IF EXISTS "fbp_third_party_auth";
CREATE TABLE "fbp_third_party_auth" (
  "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_site_id" "int8",
  "c_access_key" varchar(255) ,
  "c_api_id" varchar(255)
);
COMMENT ON COLUMN "fbp_third_party_auth"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_third_party_auth"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_third_party_auth"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_third_party_auth"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_third_party_auth"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_third_party_auth"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_third_party_auth"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_third_party_auth"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_third_party_auth"."c_access_key" IS 'appId';
COMMENT ON COLUMN "fbp_third_party_auth"."c_api_id" IS '开放接口id';
COMMENT ON TABLE "fbp_third_party_auth" IS '第三方接入api授权关联表';


DROP TABLE IF EXISTS "fbp_open_gateway_log";
CREATE TABLE "fbp_open_gateway_log" (
  "c_id" "serial8" NOT NULL PRIMARY KEY,
  "c_create_time" timestamp,
  "c_tenant_id" int8,
  "c_site_id" int8,
  "c_path" VARCHAR(2000) ,
  "c_access_key" varchar(255) ,
  "c_access_timestamp" varchar(255) ,
  "c_sign" varchar(500) ,
  "c_client_ip" varchar(50) ,
  "c_user_agent" varchar(2000) ,
  "c_result" int4,
  "c_result_message" text 
);
COMMENT ON COLUMN "fbp_open_gateway_log"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_create_time" IS '访问时间';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_path" IS '接口地址';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_access_key" IS 'appId';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_access_timestamp" IS '认证时间戳';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_sign" IS '签名';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_client_ip" IS '访问ip';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_user_agent" IS '浏览器信息';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_result" IS '访问状态';
COMMENT ON COLUMN "fbp_open_gateway_log"."c_result_message" IS '错误信息';
COMMENT ON TABLE "fbp_open_gateway_log" 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 '站群备注';

ALTER TABLE fbp_admin_site_info RENAME COLUMN c_inited TO c_inited_tmp;
ALTER TABLE fbp_admin_site_info RENAME COLUMN c_is_manage_site TO c_is_manage_site_tmp;
ALTER TABLE fbp_admin_site_info ADD c_inited int2 NULL DEFAULT 0;
ALTER TABLE fbp_admin_site_info ADD c_is_manage_site int2 NULL DEFAULT 0;
update fbp_admin_site_info set c_is_manage_site = 1 where c_is_manage_site_tmp = true;
ALTER TABLE fbp_admin_site_info DROP COLUMN c_inited_tmp;
ALTER TABLE fbp_admin_site_info DROP COLUMN c_is_manage_site_tmp;

ALTER TABLE fbp_admin_account_info RENAME COLUMN c_status TO c_status_tmp;
ALTER TABLE fbp_admin_account_info ADD c_status int2 NULL DEFAULT 1;
update fbp_admin_account_info set c_status = 0 where c_status_tmp = 'f';
ALTER TABLE fbp_admin_account_info DROP COLUMN c_status_tmp;

ALTER TABLE fbp_admin_tenant_info RENAME COLUMN c_inited TO c_inited_tmp;
ALTER TABLE fbp_admin_tenant_info ADD c_inited int2 NULL DEFAULT 0;
ALTER TABLE fbp_admin_tenant_info DROP COLUMN c_inited_tmp;

ALTER TABLE fbp_storages ADD c_site_group_id int4;
ALTER TABLE fbp_cache_pools ADD c_site_group_id int4;

INSERT INTO "fbp_path" (c_creator,c_create_time,c_tenant_id,c_tenant_code,c_site_id,c_site_code,c_path,c_remark)VALUES (1, now(), (select c_id from fbp_admin_tenant_info where c_code = 'sys'), 'sys', (select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage' and c_tenant_code = 'sys'), 'sys_sg_manage', '/sys/sys_sg_manage', '系统管理');
INSERT INTO "fbp_path" (c_creator,c_create_time,c_tenant_id,c_tenant_code,c_site_id,c_site_code,c_path,c_remark)VALUES (1, now(), (select c_id from fbp_admin_tenant_info where c_code = 'sys'), 'sys', (select c_id from fbp_admin_site_info where c_code = 'sys_sg_manage' and c_tenant_code = 'sys'), 'sys_sg_manage', '/sysadmin', '系统管理');

INSERT INTO "fbp_path" (c_creator,c_create_time,c_tenant_id,c_tenant_code,c_site_id,c_site_code,c_path,c_remark)VALUES (1, now(), (select c_id from fbp_admin_tenant_info where c_code = 'sys'), 'sys', (select c_id from fbp_admin_site_info where c_code = 'sys' and c_tenant_code = 'sys'), 'sys', '/', '平台运维');

update fbp_admin_site_group_info set c_config = '{"pwd":{"algorithm":"bcrypt","secretKey":"","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}}';