Locar 最小化低代码运行环境

Locar 是lower code app runtime的简称，由低代码页面渲染引擎、fbp服务引擎构建的最小化的微应用运行环境；

系统功能、能力

应用中心 (上架、分类)
安全设置 (设置初始密码、错误次数锁定、强制修改密码、账号加密算法、敏感要素保护等)
角色管理
角色授权
参数配置 (DSC映射设置、应用参数设置、事件设置)
地址管理 (设置站点域名：站点独立域名、多站点共用域名等场景)
站点管理 (管理系统并构建业务系统：菜单管理、应用授权、应用版本、访问路径、关联账号、站点设置)
日志管理 (登录日志、管理日志)
运维公告
账号管理 (账号维护、授权站点、关联角色、重置密码等)
系统DSC资源管理（D：datasource 数据源 S：storage 存储 C：cache 缓存）
运行低代码平台开发出来的应用【注意：应用里服务部分必须是fbp服务，不能含有原来的低代码服务；且应用不是系统应用（统一了mas平台系统表命名规则）】

更新内容

新增访问路径管理(调整原站点访问地址拼接租户标识和站点标识为管理设定)
页面效果优化；管理功能及入口调整
优化fbp服务引擎能力
兼容达梦、人大金仓、Postgres、polardb数据库

依赖中间件

redis 【非必须，建议使用redis】
nginx
jdk8

版本

v1.0.1，于2025年02月14日发布

特别提示

Locar为低代码运行时，只支持低代码平台开发的应用在次系统中运行（只支持FBP服务，不支持locas-service开发的服务，不支持微服务） Locar基于Mas平台5.14的系统表结构运行，与系统相关的管理应用（如lc-czuom）需要升级适配514表结构后才可运行达梦数据库实例化时需要忽略大小写

部署

文件获取地址：oss://foa5-oss/deploy/locar/v1.0.1/Mas-FBP-Server.zip

本文以fbp服务本地部署、数据库使用polardb；fbp服务使用端口3333，nginx使用端口6455来说明服务存放在：/data/softs/min_locar目录下服务目录结构：

/data/softs/min_locar/Mas-FBP-Server    // 服务主目录
                          |- bin        // 服务启动目录
                          |- conf       // 配置目录
                          |- lib        // 系统库目录
                          |- logs       // 日志目录
                          |- tmp        // 临时目录
                          |- data       // 数据目录 
                               |- apps       // 应用目录
                               |- html       // 系统静态文件

1、在库中执行建表语句：根据数据库类型选择对应的sql脚本建表

Polardb

sql

-- ----------------------------
-- Table structure for fbp_datasource
-- ----------------------------
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 fbp_storages
-- ----------------------------
DROP TABLE IF EXISTS "fbp_storages";
CREATE TABLE "fbp_storages" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_code" varchar(255) ,
  "c_name" varchar(255) ,
  "c_type" varchar(50),
  "c_site_group_id" int8,
  "c_endpoint" varchar(1000) ,
  "c_root_path" varchar(255) ,
  "c_access_key_id" varchar(255) ,
  "c_secret_access_key" varchar(255) ,
  "c_remark" varchar(2000) ,
  "c_bucket_name" varchar(500) ,
  "c_level" int2
);
COMMENT ON COLUMN "fbp_storages"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_storages"."c_code" IS '存储标识';
COMMENT ON COLUMN "fbp_storages"."c_name" IS '存储标识名称';
COMMENT ON COLUMN "fbp_storages"."c_type" IS '类型，local-本地存储，oss-OSS存储';
COMMENT ON COLUMN "fbp_storages"."c_endpoint" IS 'OSS域';
COMMENT ON COLUMN "fbp_storages"."c_root_path" IS '端口';
COMMENT ON COLUMN "fbp_storages"."c_access_key_id" IS 'Oss账号id';
COMMENT ON COLUMN "fbp_storages"."c_secret_access_key" IS 'Oss账号密钥';
COMMENT ON COLUMN "fbp_storages"."c_remark" IS '备注';
COMMENT ON COLUMN "fbp_storages"."c_bucket_name" IS 'Oss存储桶';
COMMENT ON COLUMN "fbp_storages"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_storages"."c_level" IS '数据源级别，1-平台级，2-站点级';
COMMENT ON COLUMN "fbp_storages"."c_site_group_id" IS '所属站群id（站点级）';
COMMENT ON TABLE "fbp_storages" IS '存储信息表';


-- ----------------------------
-- Table structure for fbp_cache_pools
-- ----------------------------
DROP TABLE IF EXISTS "fbp_cache_pools";
CREATE TABLE "fbp_cache_pools" (
  "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_site_group_id" int8,
  "c_code" varchar(50),
  "c_name" varchar(100),
  "c_remark" varchar(500),
  "c_level" int2,
  "c_type" varchar(50),   
  "c_expire_seconds" int8,
  "c_maximum_size" int8, 
  "c_second_expire_seconds" int8, 
  "c_url" varchar(50), 
  "c_password" varchar(50) DEFAULT null,
  "c_database" int4,
   "c_port" int4
);
COMMENT ON COLUMN "fbp_cache_pools"."c_code" IS '代码';
COMMENT ON COLUMN "fbp_cache_pools"."c_name" IS '名字';
COMMENT ON COLUMN "fbp_cache_pools"."c_level" IS '缓存级别：1平台，2站点';
COMMENT ON COLUMN "fbp_cache_pools"."c_site_group_id" IS '所属站群id（站点级）';
COMMENT ON COLUMN "fbp_cache_pools"."c_type" IS '类型：jvm/redis/level2';
COMMENT ON COLUMN "fbp_cache_pools"."c_expire_seconds" IS '过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_maximum_size" IS 'jvm最大缓存';
COMMENT ON COLUMN "fbp_cache_pools"."c_second_expire_seconds" IS '二级缓存过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_url" IS '连接url';
COMMENT ON COLUMN "fbp_cache_pools"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_cache_pools"."c_database" IS '连接库';
COMMENT ON COLUMN "fbp_cache_pools"."c_port" IS '端口';
COMMENT ON TABLE "fbp_cache_pools" IS '缓存信息表';

-- ----------------------------
-- Table structure for fbp_admin_tenant_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_tenant_info";
CREATE TABLE "fbp_admin_tenant_info" (
  "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_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(20) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_tenant_domain" varchar(100) ,
  "c_inited" int2 DEFAULT 0,
  "c_tenant_id" int8,
  "c_tenant_setting" varchar(2000) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_xzjb" int4
);
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_name" IS '租户名称';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_domain" IS '租户域名';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_setting" IS '租户配置';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_key" IS '钉钉唯一标识key';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_secret" IS '钉钉唯一密钥';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_xzjb" IS '所属行政级别：1：升级 2：市级 3：区县';
COMMENT ON TABLE "fbp_admin_tenant_info" IS '租户表';

  -- ----------------------------
-- Table structure for fbp_admin_site_group_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_site_group_info";
CREATE TABLE "fbp_admin_site_group_info" (
  "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,
  "c_tenant_code" varchar(32) ,
  "c_code" varchar(32) ,
  "c_name" varchar(32) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_config" text,
  "c_desc" varchar(2000)
);
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_code" IS '站群代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_name" IS '站群名称';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_config" IS '站群配置';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_desc" IS '站群描述';
COMMENT ON TABLE "fbp_admin_site_group_info" IS '站群表';

-- ----------------------------
-- Table structure for fbp_admin_site_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_site_info";
CREATE TABLE "fbp_admin_site_info" (
  "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_site_type" int4,
  "c_title" varchar(200) ,
  "c_theme" varchar(100) ,
  "c_logo" varchar(100) ,
  "c_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(50) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_site_domain" varchar(100) ,
  "c_inited" int2 DEFAULT 0,
  "c_tenant_id" int8,
  "c_site_setting" text ,
  "c_tenant_code" varchar(32) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_manage_sites" varchar(100) ,
  "c_site_group_id" int8,
  "c_is_manage_site" int2 DEFAULT 0 ,
  "c_site_group_code" varchar(50)
);
COMMENT ON COLUMN "fbp_admin_site_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_type" IS '站点类型:0 pc 1移动';
COMMENT ON COLUMN "fbp_admin_site_info"."c_title" IS '标题';
COMMENT ON COLUMN "fbp_admin_site_info"."c_code" IS '站点代码';
COMMENT ON COLUMN "fbp_admin_site_info"."c_name" IS '名称';
COMMENT ON COLUMN "fbp_admin_site_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_site_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_domain" IS '站点域名';
COMMENT ON COLUMN "fbp_admin_site_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_setting" IS '站点配置';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_site_info"."c_is_manage_site" IS '是否是管理站点';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_code" IS '站群标识';
COMMENT ON TABLE "fbp_admin_site_info" IS '站点信息表';

-- ----------------------------
-- Table structure for fbp_admin_account_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_account_info";
CREATE TABLE "fbp_admin_account_info" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_granted_apis" varchar(255) ,
  "c_account_expired" varchar(1) ,
  "c_account_locked" varchar(1) ,
  "c_credentials_expired" varchar(1) ,
  "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,
  "c_login_name" varchar(32) ,
  "c_login_dingding" varchar(32) ,
  "c_login_phone" varchar(100) ,
  "c_login_email" varchar(50) ,
  "c_status" int2 DEFAULT 1,
  "c_password_policy" int4,
  "c_password" varchar(255) ,
  "c_mobile_device" varchar(255) ,
  "c_allow_mobile_access" varchar(1) ,
  "c_last_login_time" timestamp(6),
  "c_last_login_client_ip" varchar(50) ,
  "c_last_login_failed" timestamp(6),
  "c_default_tenant" varchar(11) ,
  "c_account_source" int8,
  "c_account_type" int4,
  "c_full_name" varchar(50) ,
  "c_tag" varchar(1000) ,
  "c_theme" varchar(500) ,
  "c_avatar" varchar(50) ,
  "c_account_uuid" varchar(100) ,
  "c_login_alias" varchar(200),
  "c_site_group_id" int8,
  "c_identity_code" varchar(100),
  "c_user_code" varchar(100),
  "c_identity_desc" varchar(500)
);
COMMENT ON COLUMN "fbp_admin_account_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_info"."c_granted_apis" IS 'API访问权限项';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_expired" IS 'spring security 账号是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_locked" IS 'spring security 账号是否锁定';
COMMENT ON COLUMN "fbp_admin_account_info"."c_credentials_expired" IS 'spring security 用户证书是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_name" IS '登录账号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_dingding" IS '登录钉钉号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_phone" IS '登录手机号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_email" IS '登录邮箱';
COMMENT ON COLUMN "fbp_admin_account_info"."c_status" IS '状态 0 停用 1 启用';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password_policy" IS '密码策略';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_mobile_device" IS '移动设备标识';
COMMENT ON COLUMN "fbp_admin_account_info"."c_allow_mobile_access" IS '是否允许移动访问';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_time" IS '上次正常登录时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_client_ip" IS '上次登录IP';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_failed" IS '上次失败时间登录';
COMMENT ON COLUMN "fbp_admin_account_info"."c_default_tenant" IS '默认租户代码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_source" IS '账号来源';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_type" IS '账号类型';
COMMENT ON COLUMN "fbp_admin_account_info"."c_full_name" IS '姓名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tag" IS '标签';
COMMENT ON COLUMN "fbp_admin_account_info"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_info"."c_avatar" IS '头像';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_uuid" IS '账号uuid';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_alias" IS '登录别名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_code" IS '身份编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_user_code" IS '用户编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_desc" IS '用户身份描述';
COMMENT ON TABLE "fbp_admin_account_info" IS '账号表';

-- ----------------------------
-- Table structure for fbp_admin_account_tenant
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_account_tenant";
CREATE TABLE "fbp_admin_account_tenant" (
  "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,
  "c_site_id" int8,
  "c_theme" VARCHAR(100),
  "c_site_group_id" int8
);
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_group_id" IS '站群id';
COMMENT ON TABLE "fbp_admin_account_tenant" IS '账号授权表';

-- ----------------------------
-- Table structure for fbp_admin_role_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_role_info";
CREATE TABLE "fbp_admin_role_info" (
  "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,
  "c_role_code" varchar(20) ,
  "c_role_name" varchar(50) ,
  "c_power_code" varchar(2000) ,
  "c_power_name" varchar(2000) ,
  "c_version" varchar(100) ,
  "c_role_type" int4,
  "c_portal_component_code" varchar(50) ,
  "c_site_id" int8,
  "c_site_group_id" int8,
  "c_tag" varchar(2000) 
);
COMMENT ON COLUMN "fbp_admin_role_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_code" IS '角色code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_name" IS '角色名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_code" IS '权限项code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_name" IS '权限项名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_type" IS '角色类型 0 系统角色 1 租户自定义角色';
COMMENT ON COLUMN "fbp_admin_role_info"."c_portal_component_code" IS '部件编码';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tag" IS '标签';
COMMENT ON TABLE "fbp_admin_role_info" IS '角色信息表';


-- ----------------------------
-- Table structure for fbp_admin_role_mapping
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_role_mapping";
CREATE TABLE "fbp_admin_role_mapping" (
  "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,
  "c_role_id" int8,
  "c_account_id" int8,
  "c_org_id" int8,
  "c_site_id" int8,
  "c_site_group_id" int8
);
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_role_id" IS '角色id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_org_id" IS '机构id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_group_id" IS '站群ID';
COMMENT ON TABLE "fbp_admin_role_mapping" IS '账号角色关系表';
COMMENT ON TABLE "fbp_admin_role_mapping" IS '角色授权表';

-- ----------------------------
-- Table structure for fbp_admin_init_menu
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_init_menu";
CREATE TABLE "fbp_admin_init_menu" (
  "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_navs" varchar(80000) ,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_admin_init_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_navs" IS '导航json';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_admin_init_menu" IS '初始化菜单信息表';

-- ----------------------------
-- Table structure for fbp_portal_diy_menu
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_diy_menu";
CREATE TABLE "fbp_portal_diy_menu" (
  "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,
  "c_navs" varchar(50000) ,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_navs" IS '导航路径json';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_menu" IS '个性化菜单表';


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


DROP TABLE IF EXISTS "fbp_app_catalog_mapping";
CREATE TABLE "fbp_app_catalog_mapping" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "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_catalog_id" int8,
  "c_app_code" varchar(50)
);
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_catalog_id" IS '应用分类id';
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_app_catalog_mapping" IS '应用分类关联表';


-- ----------------------------
-- Table structure for fbp_portal_component
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_component";
CREATE TABLE "fbp_portal_component" (
  "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_code" varchar(50) ,
  "c_text" varchar(255) ,
  "c_status" varchar(2) ,
  "c_is_auth" varchar(2) ,
  "c_version" varchar(100) ,
  "c_descri" varchar(255) ,
  "c_auth_name" varchar(255) ,
  "c_changelog" text ,
  "c_depends" text ,
  "c_category" varchar(500) ,
  "c_is_sys" varchar(255) ,
  "c_roles_json" varchar(4000) ,
  "c_permissions_json" varchar(4000) ,
  "c_app_type" varchar(10) ,
  "c_modes" varchar(500) ,
  "c_ref_id" varchar(200),
  "c_setting" text,
  "c_is_login" varchar(2) DEFAULT '0'
);
COMMENT ON COLUMN "fbp_portal_component"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component"."c_code" IS '部件编码';
COMMENT ON COLUMN "fbp_portal_component"."c_text" IS '部件名';
COMMENT ON COLUMN "fbp_portal_component"."c_status" IS '状态0停用1启用';
COMMENT ON COLUMN "fbp_portal_component"."c_is_auth" IS '认证0未认证1已认证';
COMMENT ON COLUMN "fbp_portal_component"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_portal_component"."c_descri" IS '说明';
COMMENT ON COLUMN "fbp_portal_component"."c_auth_name" IS '认证签名';
COMMENT ON COLUMN "fbp_portal_component"."c_changelog" IS '更新日志';
COMMENT ON COLUMN "fbp_portal_component"."c_depends" IS '依赖应用';
COMMENT ON COLUMN "fbp_portal_component"."c_category" IS '分类';
COMMENT ON COLUMN "fbp_portal_component"."c_is_sys" IS '是否为系统应用';
COMMENT ON COLUMN "fbp_portal_component"."c_roles_json" IS '部件内置所有角色json';
COMMENT ON COLUMN "fbp_portal_component"."c_permissions_json" IS '部件内置所有权限项json';
COMMENT ON COLUMN "fbp_portal_component"."c_app_type" IS '应用类型 0 PC 1 移动端';
COMMENT ON COLUMN "fbp_portal_component"."c_ref_id" IS '应用文件id';
COMMENT ON COLUMN "fbp_portal_component"."c_setting" IS '应用dsc设置';
COMMENT ON COLUMN "fbp_portal_component"."c_is_login" IS '是否是登录应用 0 否 1 是';
COMMENT ON TABLE "fbp_portal_component" IS '应用信息表';


-- ----------------------------
-- Table structure for fbp_portal_component_grant
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_component_grant";
CREATE TABLE "fbp_portal_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_app_code" varchar(200)  NOT NULL
);
COMMENT ON COLUMN "fbp_portal_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_portal_component_grant" IS '应用租户授权表';

-- ----------------------------
-- Table structure for fbp_portal_import_record
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_import_record";
CREATE TABLE "fbp_portal_import_record" (
  "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,
  "c_result" varchar(2) ,
  "c_file_name" varchar(100) ,
  "c_file_alias" varchar(100) ,
  "c_fail_reason" text ,
  "c_app_code" varchar(100)
);
COMMENT ON COLUMN "fbp_portal_import_record"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_import_record"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_import_record"."c_result" IS '结果0成功1失败';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_name" IS '导入路径';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_alias" IS '文件refenid';
COMMENT ON COLUMN "fbp_portal_import_record"."c_fail_reason" IS '失败原因';
COMMENT ON TABLE "fbp_portal_import_record" IS '应用上架记录表';


-- ----------------------------
-- Table structure for fbp_site_component_grant
-- ----------------------------
DROP TABLE IF EXISTS "fbp_site_component_grant";
CREATE TABLE "fbp_site_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_app_code" varchar(200)  NOT NULL,
  "c_site_id" int8,
  "c_setting" text
);
COMMENT ON COLUMN "fbp_site_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_site_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_site_component_grant"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_site_component_grant"."c_setting" IS '应用dsc配置';
COMMENT ON TABLE "fbp_site_component_grant" IS '应用站点授权表';

-- ----------------------------
-- Table structure for fbp_app_publish_log
-- ----------------------------
DROP TABLE IF EXISTS "fbp_app_publish_log";
CREATE TABLE "fbp_app_publish_log" (
  "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(50) ,
  "c_app_version" varchar(20) 
);
COMMENT ON COLUMN "fbp_app_publish_log"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_app_publish_log" IS '应用版本发布记录表';

-- ----------------------------
-- Table structure for fbp_portal_app_version
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_app_version";
CREATE TABLE "fbp_portal_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(50) ,
  "c_app_version" varchar(20) 
);
COMMENT ON COLUMN "fbp_portal_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_portal_app_version" IS '应用版本记录表';

-- ----------------------------
-- Table structure for fbp_portal_diy_app_version
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_diy_app_version";
CREATE TABLE "fbp_portal_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(50) ,
  "c_app_version" varchar(20) ,
  "c_tenant_id" int8,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_version" IS '应用版本';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_app_version" IS '应用自定义版本记录表';

-- ----------------------------
-- 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 '登录日志表';

-----
/**
DROP TABLE IF EXISTS "fbp_admin_manage_log";
CREATE TABLE "fbp_admin_manage_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_module_name" varchar(255) ,
   "c_operation" varchar(255) ,
   "c_description" varchar(255) ,
   "c_account_id" int8,
   "c_operation_client_ip" varchar(255) ,
   "c_operation_user_agent" varchar(255) ,
   CONSTRAINT "fbp_admin_manage_log_pkey" PRIMARY KEY ("c_id")
);
COMMENT ON COLUMN "fbp_admin_manage_log"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_account_id" IS '操作账号id';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_module_name" IS '模块名';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_operation" IS '操作';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_description" IS '描述';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_operation_client_ip" IS '访问客户端IP';
COMMENT ON COLUMN "fbp_admin_manage_log"."c_operation_user_agent" IS '访问浏览器user-agent';
**/
----


DROP TABLE IF EXISTS "fbp_admin_maintain_log";
  CREATE TABLE "fbp_admin_maintain_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_module_name" varchar(255) ,
     "c_operation" varchar(255) ,
     "c_description" clob ,
     "c_account_id" int8,
     "c_login_name" varchar(255) ,
     "c_full_name" varchar(255) ,
	 "c_site_id" int8,
	 "c_site_group_id" int8
  );
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_id" IS '主键';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modifier" IS '修改人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modify_time" IS '修改时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_creator" IS '创建人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_create_time" IS '创建时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_sort_number" IS '排序号';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_tenant_id" IS '租户ID';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_account_id" IS '操作账号id';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_login_name" IS '操作账号登录名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_full_name" IS '操作账号中文名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_module_name" IS '模块名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_operation" IS '操作';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_description" IS '描述';
  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';
  COMMENT ON TABLE "fbp_admin_maintain_log" IS '管理日志表';
 

DROP TABLE IF EXISTS "fbp_events";
CREATE TABLE "fbp_events" (
  "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_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 '服务事件表';


---===========================新增表信息---------------------

-- ----------------------------
-- Table structure for fbp_path
-- ----------------------------
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(50),
	"c_value" varchar(50),
	"c_name" varchar(255),
	"c_desc" varchar(500),
	"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 '应用参数配置表';

达梦数据

sql

-- ----------------------------
-- Table structure for fbp_datasource
-- ----------------------------
DROP TABLE IF EXISTS "fbp_datasource";
CREATE TABLE "fbp_datasource" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_name" varchar(255) ,
  "c_type" int,
  "c_url" varchar(1000) ,
  "c_user" varchar(255) ,
  "c_password" varchar(255) ,
  "c_remark" varchar(255) ,
  "c_code" varchar(255) ,
  "c_level" int,
  "c_site_group_id" int,
  "c_initialsize" int,
  "c_minidle" int,
  "c_maxsize" int,
  "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 fbp_storages
-- ----------------------------
CREATE TABLE "fbp_storages" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_code" varchar(255) ,
  "c_name" varchar(255) ,
  "c_type" varchar(50),
  "c_endpoint" varchar(1000) ,
  "c_root_path" varchar(255) ,
  "c_access_key_id" varchar(255) ,
  "c_secret_access_key" varchar(255) ,
  "c_remark" varchar(2000) ,
  "c_bucket_name" varchar(500) ,
  "c_site_group_id" int,
  "c_level" int
);
COMMENT ON COLUMN "fbp_storages"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_storages"."c_code" IS '存储标识';
COMMENT ON COLUMN "fbp_storages"."c_name" IS '存储标识名称';
COMMENT ON COLUMN "fbp_storages"."c_type" IS '类型，local-本地存储，oss-OSS存储';
COMMENT ON COLUMN "fbp_storages"."c_endpoint" IS 'OSS域';
COMMENT ON COLUMN "fbp_storages"."c_root_path" IS '端口';
COMMENT ON COLUMN "fbp_storages"."c_access_key_id" IS 'Oss账号id';
COMMENT ON COLUMN "fbp_storages"."c_secret_access_key" IS 'Oss账号密钥';
COMMENT ON COLUMN "fbp_storages"."c_remark" IS '备注';
COMMENT ON COLUMN "fbp_storages"."c_bucket_name" IS 'Oss存储桶';
COMMENT ON COLUMN "fbp_storages"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_storages"."c_level" IS '数据源级别，1-平台级，2-站点级';
COMMENT ON TABLE "fbp_storages" IS '存储信息';




-- ----------------------------
-- Table structure for fbp_cache_pools
-- ----------------------------
CREATE TABLE "fbp_cache_pools" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_site_group_id" int,
  "c_code" varchar(50),
  "c_name" varchar(100),
  "c_remark" varchar(500),
  "c_level" int,
  "c_type" varchar(50),   
  "c_expire_seconds" int,
  "c_maximum_size" int, 
  "c_second_expire_seconds" int, 
  "c_url" varchar(50), 
  "c_password" varchar(50) DEFAULT null,
  "c_database" int,
   "c_port" int
);
COMMENT ON COLUMN "fbp_cache_pools"."c_code" IS '代码';
COMMENT ON COLUMN "fbp_cache_pools"."c_name" IS '名字';
COMMENT ON COLUMN "fbp_cache_pools"."c_level" IS '缓存级别：1平台，2站点';
COMMENT ON COLUMN "fbp_cache_pools"."c_type" IS '类型：jvm/redis/level2';
COMMENT ON COLUMN "fbp_cache_pools"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_cache_pools"."c_expire_seconds" IS '过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_maximum_size" IS 'jvm最大缓存';
COMMENT ON COLUMN "fbp_cache_pools"."c_second_expire_seconds" IS '二级缓存过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_url" IS '连接url';
COMMENT ON COLUMN "fbp_cache_pools"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_cache_pools"."c_database" IS '连接库';
COMMENT ON COLUMN "fbp_cache_pools"."c_port" IS '端口';
COMMENT ON TABLE "fbp_cache_pools" IS 'fbp缓存表';


-- ----------------------------
-- Table structure for fbp_admin_tenant_info
-- ----------------------------
CREATE TABLE "fbp_admin_tenant_info" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(20) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_tenant_domain" varchar(100) ,
  "c_inited" TINYINT DEFAULT 0,
  "c_tenant_id" int,
  "c_tenant_setting" varchar(2000) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_xzjb" int
);
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_name" IS '租户名称';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_domain" IS '租户域名';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_setting" IS '租户配置';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_key" IS '钉钉唯一标识key';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_secret" IS '钉钉唯一密钥';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_xzjb" IS '所属行政级别：1：升级 2：市级 3：区县';
COMMENT ON TABLE "fbp_admin_tenant_info" IS '租户信息表';

  -- ----------------------------
-- Table structure for fbp_admin_site_group_info
-- ----------------------------
CREATE TABLE "fbp_admin_site_group_info" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_tenant_code" varchar(32) ,
  "c_code" varchar(32) ,
  "c_name" varchar(32) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_config" text,
  "c_desc" varchar(2000)
);
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_code" IS '站群代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_name" IS '站群名称';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_config" IS '站群配置';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_desc" IS '站群备注说明';
COMMENT ON TABLE "fbp_admin_site_group_info" IS '站群信息表';

-- ----------------------------
-- Table structure for fbp_admin_site_info
-- ----------------------------
CREATE TABLE "fbp_admin_site_info" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_site_type" int,
  "c_title" varchar(200) ,
  "c_theme" varchar(100) ,
  "c_logo" varchar(100) ,
  "c_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(50) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_site_domain" varchar(100) ,
  "c_inited" TINYINT DEFAULT 0,
  "c_tenant_id" int,
  "c_site_setting" text ,
  "c_tenant_code" varchar(32) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_manage_sites" varchar(100) ,
  "c_site_group_id" int,
  "c_is_manage_site" TINYINT DEFAULT 0 ,
  "c_site_group_code" varchar(50) 
);
COMMENT ON COLUMN "fbp_admin_site_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_type" IS '站点类型';
COMMENT ON COLUMN "fbp_admin_site_info"."c_title" IS '标题';
COMMENT ON COLUMN "fbp_admin_site_info"."c_code" IS '站点代码';
COMMENT ON COLUMN "fbp_admin_site_info"."c_name" IS '名称';
COMMENT ON COLUMN "fbp_admin_site_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_site_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_domain" IS '站点域名';
COMMENT ON COLUMN "fbp_admin_site_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_setting" IS '站点配置';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_site_info"."c_is_manage_site" IS '是否是管理站点';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_code" IS '站群标识';
COMMENT ON TABLE "fbp_admin_site_info" IS '站点信息表';

-- ----------------------------
-- Table structure for fbp_admin_account_info
-- ----------------------------
CREATE TABLE "fbp_admin_account_info" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_granted_apis" varchar(255) ,
  "c_account_expired" varchar(1) ,
  "c_account_locked" varchar(1) ,
  "c_credentials_expired" varchar(1) ,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_login_name" varchar(32) ,
  "c_login_dingding" varchar(32) ,
  "c_login_phone" varchar(100) ,
  "c_login_email" varchar(50) ,
  "c_status" TINYINT default 1,
  "c_password_policy" int,
  "c_password" varchar(255) ,
  "c_mobile_device" varchar(255) ,
  "c_allow_mobile_access" varchar(1) ,
  "c_last_login_time" timestamp(6),
  "c_last_login_client_ip" varchar(50) ,
  "c_last_login_failed" timestamp(6),
  "c_default_tenant" varchar(11) ,
  "c_account_source" int,
  "c_account_type" int,
  "c_full_name" varchar(50) ,
  "c_tag" varchar(1000) ,
  "c_theme" varchar(500) ,
  "c_avatar" varchar(50) ,
  "c_account_uuid" varchar(100) ,
  "c_login_alias" varchar(200),
  "c_site_group_id" int,
  "c_identity_code" varchar(100),
  "c_user_code" varchar(100),
  "c_identity_desc" varchar(500)
);
COMMENT ON COLUMN "fbp_admin_account_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_info"."c_granted_apis" IS 'API访问权限项';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_expired" IS 'spring security 账号是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_locked" IS 'spring security 账号是否锁定';
COMMENT ON COLUMN "fbp_admin_account_info"."c_credentials_expired" IS 'spring security 用户证书是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_name" IS '登录账号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_dingding" IS '登录钉钉号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_phone" IS '登录手机号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_email" IS '登录邮箱';
COMMENT ON COLUMN "fbp_admin_account_info"."c_status" IS '状态 0 停用 1 启用';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password_policy" IS '密码策略';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_mobile_device" IS '移动设备标识';
COMMENT ON COLUMN "fbp_admin_account_info"."c_allow_mobile_access" IS '是否允许移动访问';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_time" IS '上次正常登录时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_client_ip" IS '上次登录IP';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_failed" IS '上次失败时间登录';
COMMENT ON COLUMN "fbp_admin_account_info"."c_default_tenant" IS '默认租户代码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_source" IS '账号来源';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_type" IS '账号类型';
COMMENT ON COLUMN "fbp_admin_account_info"."c_full_name" IS '姓名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tag" IS '标签';
COMMENT ON COLUMN "fbp_admin_account_info"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_info"."c_avatar" IS '头像';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_uuid" IS '账号uuid';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_alias" IS '登录别名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_code" IS '身份编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_user_code" IS '用户编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_desc" IS '用户身份描述';
COMMENT ON TABLE "fbp_admin_account_info" IS '账号信息表';


-- ----------------------------
-- Table structure for fbp_admin_account_tenant
-- ----------------------------
CREATE TABLE "fbp_admin_account_tenant" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_account_id" int,
  "c_site_id" int,
  "c_theme" VARCHAR(100),
  "c_site_group_id" int
);
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_group_id" IS '站群id';
COMMENT ON TABLE "fbp_admin_account_tenant" IS '账号站点授权关联表';



-- ----------------------------
-- Table structure for fbp_admin_role_info
-- ----------------------------
CREATE TABLE "fbp_admin_role_info" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_role_code" varchar(20) ,
  "c_role_name" varchar(50) ,
  "c_power_code" varchar(2000) ,
  "c_power_name" varchar(2000) ,
  "c_version" varchar(100) ,
  "c_role_type" int,
  "c_portal_component_code" varchar(50) ,
  "c_site_id" int,
  "c_site_group_id" int,
  "c_tag" varchar(4000) 
);
COMMENT ON COLUMN "fbp_admin_role_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_code" IS '角色code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_name" IS '角色名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_code" IS '权限项code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_name" IS '权限项名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_type" IS '角色类型 0 系统角色 1 租户自定义角色';
COMMENT ON COLUMN "fbp_admin_role_info"."c_portal_component_code" IS '部件编码';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tag" IS '标签';
COMMENT ON TABLE "fbp_admin_role_info" IS '角色信息表';

-- ----------------------------
-- Table structure for fbp_admin_role_mapping
-- ----------------------------
CREATE TABLE "fbp_admin_role_mapping" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_role_id" int,
  "c_account_id" int,
  "c_org_id" int,
  "c_site_id" int,
  "c_site_group_id" int
);
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_role_id" IS '角色id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_org_id" IS '机构id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_group_id" IS '站群ID';
COMMENT ON TABLE "fbp_admin_role_mapping" IS '账号角色关系表';


-- ----------------------------
-- Table structure for fbp_admin_init_menu
-- ----------------------------
CREATE TABLE "fbp_admin_init_menu" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_navs" text ,
  "c_site_id" int
);
COMMENT ON COLUMN "fbp_admin_init_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_navs" IS '导航json';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_admin_init_menu" IS '初始化菜单信息表';

-- ----------------------------
-- Table structure for fbp_portal_diy_menu
-- ----------------------------
CREATE TABLE "fbp_portal_diy_menu" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_account_id" int,
  "c_navs" text ,
  "c_site_id" int
);
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_navs" IS '导航路径json';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_menu" IS '个性化菜单表';


-- ----------------------------
-- Table structure for fbp_app_catalog
-- ----------------------------
CREATE TABLE "fbp_app_catalog" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_catalog_code" varchar(50) ,
  "c_catalog_name" varchar(500)
);
COMMENT ON COLUMN "fbp_app_catalog"."c_catalog_code" IS '分类code';
COMMENT ON COLUMN "fbp_app_catalog"."c_catalog_name" IS '分类名';
COMMENT ON TABLE "fbp_app_catalog" IS '应用分类表';

CREATE TABLE "fbp_app_catalog_mapping" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "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_catalog_id" int,
  "c_app_code" varchar(50)
);
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_catalog_id" IS '应用分类id';
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_app_catalog_mapping" IS '应用分类关联表';


-- ----------------------------
-- Table structure for fbp_portal_component
-- ----------------------------
CREATE TABLE "fbp_portal_component" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_code" varchar(50) ,
  "c_text" varchar(255) ,
  "c_status" varchar(2) ,
  "c_is_auth" varchar(2) ,
  "c_version" varchar(100) ,
  "c_descri" varchar(255) ,
  "c_auth_name" varchar(255) ,
  "c_changelog" text ,
  "c_depends" text ,
  "c_category" varchar(500) ,
  "c_is_sys" varchar(255) ,
  "c_roles_json" varchar(4000) ,
  "c_permissions_json" varchar(4000) ,
  "c_app_type" varchar(10) ,
  "c_modes" varchar(500) ,
  "c_ref_id" varchar(200),
  "c_setting" text,
  "c_is_login" varchar(2) DEFAULT '0'
);
COMMENT ON COLUMN "fbp_portal_component"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component"."c_code" IS '部件编码';
COMMENT ON COLUMN "fbp_portal_component"."c_text" IS '部件名';
COMMENT ON COLUMN "fbp_portal_component"."c_status" IS '状态0停用1启用';
COMMENT ON COLUMN "fbp_portal_component"."c_is_auth" IS '认证0未认证1已认证';
COMMENT ON COLUMN "fbp_portal_component"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_portal_component"."c_descri" IS '说明';
COMMENT ON COLUMN "fbp_portal_component"."c_auth_name" IS '认证签名';
COMMENT ON COLUMN "fbp_portal_component"."c_changelog" IS '更新日志';
COMMENT ON COLUMN "fbp_portal_component"."c_depends" IS '依赖应用';
COMMENT ON COLUMN "fbp_portal_component"."c_category" IS '分类';
COMMENT ON COLUMN "fbp_portal_component"."c_is_sys" IS '是否为系统应用';
COMMENT ON COLUMN "fbp_portal_component"."c_roles_json" IS '部件内置所有角色json';
COMMENT ON COLUMN "fbp_portal_component"."c_permissions_json" IS '部件内置所有权限项json';
COMMENT ON COLUMN "fbp_portal_component"."c_app_type" IS '应用类型 0 PC 1 移动端';
COMMENT ON COLUMN "fbp_portal_component"."c_ref_id" IS '应用文件id';
COMMENT ON COLUMN "fbp_portal_component"."c_setting" IS '应用dsc设置';
COMMENT ON COLUMN "fbp_portal_component"."c_is_login" IS '是否是登录应用 0 否 1 是';
COMMENT ON TABLE "fbp_portal_component" IS '部件信息表';


-- ----------------------------
-- Table structure for fbp_portal_component_grant
-- ----------------------------
CREATE TABLE "fbp_portal_component_grant" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int NOT NULL,
  "c_app_code" varchar(200)  NOT NULL
);
COMMENT ON COLUMN "fbp_portal_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_portal_component_grant" IS '部件授权租户信息表';

-- ----------------------------
-- Table structure for fbp_portal_import_record
-- ----------------------------
CREATE TABLE "fbp_portal_import_record" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_result" varchar(2) ,
  "c_file_name" varchar(100) ,
  "c_file_alias" varchar(100) ,
  "c_fail_reason" text ,
  "c_app_code" varchar(100)
);
COMMENT ON COLUMN "fbp_portal_import_record"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_import_record"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_import_record"."c_result" IS '结果0成功1失败';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_name" IS '导入路径';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_alias" IS '文件refenid';
COMMENT ON COLUMN "fbp_portal_import_record"."c_fail_reason" IS '失败原因';
COMMENT ON TABLE "fbp_portal_import_record" IS '应用上架记录表';



-- ----------------------------
-- Table structure for fbp_site_component_grant
-- ----------------------------
CREATE TABLE "fbp_site_component_grant" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int NOT NULL,
  "c_app_code" varchar(200)  NOT NULL,
  "c_site_id" int,
  "c_setting" text
);
COMMENT ON COLUMN "fbp_site_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_site_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_site_component_grant"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_site_component_grant"."c_setting" IS '应用dsc配置';
COMMENT ON TABLE "fbp_site_component_grant" IS '部件授权租户信息表';


-- ----------------------------
-- Table structure for fbp_app_publish_log
-- ----------------------------
CREATE TABLE "fbp_app_publish_log" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_app_code" varchar(50) ,
  "c_app_version" varchar(20)
);
COMMENT ON COLUMN "fbp_app_publish_log"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_app_publish_log" IS '应用版本发布记录表';


-- ----------------------------
-- Table structure for fbp_portal_app_version
-- ----------------------------
CREATE TABLE "fbp_portal_app_version" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_app_code" varchar(50) ,
  "c_app_version" varchar(20)
);
COMMENT ON COLUMN "fbp_portal_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_portal_app_version" IS '应用授权版本记录表';

-- ----------------------------
-- Table structure for fbp_portal_diy_app_version
-- ----------------------------
CREATE TABLE "fbp_portal_diy_app_version" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" int,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_app_code" varchar(50) ,
  "c_app_version" varchar(20) ,
  "c_tenant_id" int,
  "c_site_id" int
);
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_version" IS '应用版本';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_app_version" IS '应用自定义版本记录表';



-- ----------------------------
-- Table structure for fbp_ops_notice
-- ----------------------------
CREATE TABLE "fbp_ops_notice" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_msg" varchar(4000) ,
  "c_publish_time" timestamp(6),
  "c_over_time" timestamp(6),
  "c_keep_days" int,
  "c_creator" varchar(50) ,
  "c_creator_id" int,
  "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 'fbp运维通知表';

-- ----------------------------
-- Table structure for fbp_ops_notice_recieved
-- ----------------------------
CREATE TABLE "fbp_ops_notice_recieved" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_msg_id" int ,
  "c_reciever_time" timestamp(6),
  "c_reciever_id" int,
  "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 'fbp运维通知签收表';



---------
--登录日志
--------
-- ----------------------------
-- Table structure for fbp_admin_login_log
-- ----------------------------
CREATE TABLE "fbp_admin_login_log" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_operation_type" int,
  "c_login_name" varchar(32) ,
  "c_result" TINYINT DEFAULT 0,
  "c_login_type" int,
  "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" int,
  "c_site_group_id" int
);
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 'fbp登录日志表';


  CREATE TABLE "fbp_admin_maintain_log" (
     "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
     "c_last_modifier" int,
     "c_last_modify_time" timestamp(6),
     "c_creator" varchar(50) ,
     "c_create_time" timestamp(6),
     "c_sort_number" int,
     "c_tenant_id" int,
     "c_module_name" varchar(255) ,
     "c_operation" varchar(255) ,
     "c_description" text,
     "c_account_id" int,
     "c_login_name" varchar(255) ,
     "c_full_name" varchar(255) ,
	 "c_site_id" int,
     "c_site_group_id" int
  );
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_id" IS '主键';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modifier" IS '修改人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modify_time" IS '修改时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_creator" IS '创建人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_create_time" IS '创建时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_sort_number" IS '排序号';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_tenant_id" IS '租户ID';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_account_id" IS '操作账号id';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_login_name" IS '操作账号登录名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_full_name" IS '操作账号中文名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_module_name" IS '模块名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_operation" IS '操作';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_description" IS '描述';
  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';
  COMMENT ON TABLE "fbp_admin_maintain_log" IS 'fbp管理日志表';

  CREATE TABLE "fbp_events" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_creator" varchar(50),
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "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_path
-- ----------------------------
DROP TABLE IF EXISTS "fbp_path";
CREATE TABLE "fbp_path" (
  "c_id" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_tenant_code" varchar(32) ,
  "c_site_id" int,
  "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" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_last_modifier" int,
  "c_last_modify_time" timestamp(6),
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "c_tenant_id" int,
  "c_account_id" int
);
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" INT identity(1, 1) NOT NULL PRIMARY KEY,
  "c_creator" varchar(50) ,
  "c_create_time" timestamp(6),
  "c_sort_number" int,
  "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" INT identity(1, 1) NOT NULL PRIMARY KEY,
	"c_key" varchar(50),
	"c_value" varchar(50),
	"c_name" varchar(255),
	"c_desc" varchar(500),
	"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" int,
	"c_site_group_id" int,
	"c_site_id" int
);
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 '应用参数配置表';

人大金仓数据库

sql

-- ----------------------------
-- Table structure for fbp_datasource
-- ----------------------------
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 fbp_storages
-- ----------------------------
DROP TABLE IF EXISTS "fbp_storages";
CREATE TABLE "fbp_storages" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_code" varchar(255) ,
  "c_name" varchar(255) ,
  "c_type" varchar(50),
  "c_site_group_id" int8,
  "c_endpoint" varchar(1000) ,
  "c_root_path" varchar(255) ,
  "c_access_key_id" varchar(255) ,
  "c_secret_access_key" varchar(255) ,
  "c_remark" varchar(2000) ,
  "c_bucket_name" varchar(500) ,
  "c_level" int2
);
COMMENT ON COLUMN "fbp_storages"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_storages"."c_code" IS '存储标识';
COMMENT ON COLUMN "fbp_storages"."c_name" IS '存储标识名称';
COMMENT ON COLUMN "fbp_storages"."c_type" IS '类型，local-本地存储，oss-OSS存储';
COMMENT ON COLUMN "fbp_storages"."c_endpoint" IS 'OSS域';
COMMENT ON COLUMN "fbp_storages"."c_root_path" IS '端口';
COMMENT ON COLUMN "fbp_storages"."c_access_key_id" IS 'Oss账号id';
COMMENT ON COLUMN "fbp_storages"."c_secret_access_key" IS 'Oss账号密钥';
COMMENT ON COLUMN "fbp_storages"."c_remark" IS '备注';
COMMENT ON COLUMN "fbp_storages"."c_bucket_name" IS 'Oss存储桶';
COMMENT ON COLUMN "fbp_storages"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_storages"."c_level" IS '数据源级别，1-平台级，2-站点级';
COMMENT ON COLUMN "fbp_storages"."c_site_group_id" IS '所属站群id（站点级）';
COMMENT ON TABLE "fbp_storages" IS '存储信息表';


-- ----------------------------
-- Table structure for fbp_cache_pools
-- ----------------------------
DROP TABLE IF EXISTS "fbp_cache_pools";
CREATE TABLE "fbp_cache_pools" (
  "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_site_group_id" int8,
  "c_code" varchar(50),
  "c_name" varchar(100),
  "c_remark" varchar(500),
  "c_level" int2,
  "c_type" varchar(50),   
  "c_expire_seconds" int8,
  "c_maximum_size" int8, 
  "c_second_expire_seconds" int8, 
  "c_url" varchar(50), 
  "c_password" varchar(50) DEFAULT null,
  "c_database" int4,
   "c_port" int4
);
COMMENT ON COLUMN "fbp_cache_pools"."c_code" IS '代码';
COMMENT ON COLUMN "fbp_cache_pools"."c_name" IS '名字';
COMMENT ON COLUMN "fbp_cache_pools"."c_level" IS '缓存级别：1平台，2站点';
COMMENT ON COLUMN "fbp_cache_pools"."c_site_group_id" IS '所属站群id（站点级）';
COMMENT ON COLUMN "fbp_cache_pools"."c_type" IS '类型：jvm/redis/level2';
COMMENT ON COLUMN "fbp_cache_pools"."c_expire_seconds" IS '过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_maximum_size" IS 'jvm最大缓存';
COMMENT ON COLUMN "fbp_cache_pools"."c_second_expire_seconds" IS '二级缓存过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_url" IS '连接url';
COMMENT ON COLUMN "fbp_cache_pools"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_cache_pools"."c_database" IS '连接库';
COMMENT ON COLUMN "fbp_cache_pools"."c_port" IS '端口';
COMMENT ON TABLE "fbp_cache_pools" IS '缓存信息表';

-- ----------------------------
-- Table structure for fbp_admin_tenant_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_tenant_info";
CREATE TABLE "fbp_admin_tenant_info" (
  "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_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(20) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_tenant_domain" varchar(100) ,
  "c_inited" int2 DEFAULT 0,
  "c_tenant_id" int8,
  "c_tenant_setting" varchar(2000) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_xzjb" int4
);
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_name" IS '租户名称';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_domain" IS '租户域名';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_setting" IS '租户配置';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_key" IS '钉钉唯一标识key';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_secret" IS '钉钉唯一密钥';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_xzjb" IS '所属行政级别：1：升级 2：市级 3：区县';
COMMENT ON TABLE "fbp_admin_tenant_info" IS '租户表';

  -- ----------------------------
-- Table structure for fbp_admin_site_group_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_site_group_info";
CREATE TABLE "fbp_admin_site_group_info" (
  "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,
  "c_tenant_code" varchar(32) ,
  "c_code" varchar(32) ,
  "c_name" varchar(32) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_config" text,
  "c_desc" varchar(2000)
);
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_code" IS '站群代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_name" IS '站群名称';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_config" IS '站群配置';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_desc" IS '站群描述';
COMMENT ON TABLE "fbp_admin_site_group_info" IS '站群表';

-- ----------------------------
-- Table structure for fbp_admin_site_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_site_info";
CREATE TABLE "fbp_admin_site_info" (
  "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_site_type" int4,
  "c_title" varchar(200) ,
  "c_theme" varchar(100) ,
  "c_logo" varchar(100) ,
  "c_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(50) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_site_domain" varchar(100) ,
  "c_inited" int2 DEFAULT 0,
  "c_tenant_id" int8,
  "c_site_setting" text ,
  "c_tenant_code" varchar(32) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_manage_sites" varchar(100) ,
  "c_site_group_id" int8,
  "c_is_manage_site" int2 DEFAULT 0 ,
  "c_site_group_code" varchar(50)
);
COMMENT ON COLUMN "fbp_admin_site_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_type" IS '站点类型:0 pc 1移动';
COMMENT ON COLUMN "fbp_admin_site_info"."c_title" IS '标题';
COMMENT ON COLUMN "fbp_admin_site_info"."c_code" IS '站点代码';
COMMENT ON COLUMN "fbp_admin_site_info"."c_name" IS '名称';
COMMENT ON COLUMN "fbp_admin_site_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_site_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_domain" IS '站点域名';
COMMENT ON COLUMN "fbp_admin_site_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_setting" IS '站点配置';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_site_info"."c_is_manage_site" IS '是否是管理站点';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_code" IS '站群标识';
COMMENT ON TABLE "fbp_admin_site_info" IS '站点信息表';

-- ----------------------------
-- Table structure for fbp_admin_account_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_account_info";
CREATE TABLE "fbp_admin_account_info" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_granted_apis" varchar(255) ,
  "c_account_expired" varchar(1) ,
  "c_account_locked" varchar(1) ,
  "c_credentials_expired" varchar(1) ,
  "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,
  "c_login_name" varchar(32) ,
  "c_login_dingding" varchar(32) ,
  "c_login_phone" varchar(100) ,
  "c_login_email" varchar(50) ,
  "c_status" int2 DEFAULT 1,
  "c_password_policy" int4,
  "c_password" varchar(255) ,
  "c_mobile_device" varchar(255) ,
  "c_allow_mobile_access" varchar(1) ,
  "c_last_login_time" timestamp(6),
  "c_last_login_client_ip" varchar(50) ,
  "c_last_login_failed" timestamp(6),
  "c_default_tenant" varchar(11) ,
  "c_account_source" int8,
  "c_account_type" int4,
  "c_full_name" varchar(50) ,
  "c_tag" varchar(1000) ,
  "c_theme" varchar(500) ,
  "c_avatar" varchar(50) ,
  "c_account_uuid" varchar(100) ,
  "c_login_alias" varchar(200),
  "c_site_group_id" int8,
  "c_identity_code" varchar(100),
  "c_user_code" varchar(100),
  "c_identity_desc" varchar(500)
);
COMMENT ON COLUMN "fbp_admin_account_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_info"."c_granted_apis" IS 'API访问权限项';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_expired" IS 'spring security 账号是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_locked" IS 'spring security 账号是否锁定';
COMMENT ON COLUMN "fbp_admin_account_info"."c_credentials_expired" IS 'spring security 用户证书是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_name" IS '登录账号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_dingding" IS '登录钉钉号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_phone" IS '登录手机号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_email" IS '登录邮箱';
COMMENT ON COLUMN "fbp_admin_account_info"."c_status" IS '状态 0 停用 1 启用';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password_policy" IS '密码策略';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_mobile_device" IS '移动设备标识';
COMMENT ON COLUMN "fbp_admin_account_info"."c_allow_mobile_access" IS '是否允许移动访问';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_time" IS '上次正常登录时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_client_ip" IS '上次登录IP';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_failed" IS '上次失败时间登录';
COMMENT ON COLUMN "fbp_admin_account_info"."c_default_tenant" IS '默认租户代码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_source" IS '账号来源';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_type" IS '账号类型';
COMMENT ON COLUMN "fbp_admin_account_info"."c_full_name" IS '姓名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tag" IS '标签';
COMMENT ON COLUMN "fbp_admin_account_info"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_info"."c_avatar" IS '头像';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_uuid" IS '账号uuid';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_alias" IS '登录别名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_code" IS '身份编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_user_code" IS '用户编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_desc" IS '用户身份描述';
COMMENT ON TABLE "fbp_admin_account_info" IS '账号表';

-- ----------------------------
-- Table structure for fbp_admin_account_tenant
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_account_tenant";
CREATE TABLE "fbp_admin_account_tenant" (
  "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,
  "c_site_id" int8,
  "c_theme" VARCHAR(100),
  "c_site_group_id" int8
);
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_group_id" IS '站群id';
COMMENT ON TABLE "fbp_admin_account_tenant" IS '账号授权表';

-- ----------------------------
-- Table structure for fbp_admin_role_info
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_role_info";
CREATE TABLE "fbp_admin_role_info" (
  "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,
  "c_role_code" varchar(20) ,
  "c_role_name" varchar(50) ,
  "c_power_code" varchar(2000) ,
  "c_power_name" varchar(2000) ,
  "c_version" varchar(100) ,
  "c_role_type" int4,
  "c_portal_component_code" varchar(50) ,
  "c_site_id" int8,
  "c_site_group_id" int8,
  "c_tag" varchar(2000) 
);
COMMENT ON COLUMN "fbp_admin_role_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_code" IS '角色code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_name" IS '角色名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_code" IS '权限项code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_name" IS '权限项名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_type" IS '角色类型 0 系统角色 1 租户自定义角色';
COMMENT ON COLUMN "fbp_admin_role_info"."c_portal_component_code" IS '部件编码';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tag" IS '标签';
COMMENT ON TABLE "fbp_admin_role_info" IS '角色信息表';


-- ----------------------------
-- Table structure for fbp_admin_role_mapping
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_role_mapping";
CREATE TABLE "fbp_admin_role_mapping" (
  "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,
  "c_role_id" int8,
  "c_account_id" int8,
  "c_org_id" int8,
  "c_site_id" int8,
  "c_site_group_id" int8
);
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_role_id" IS '角色id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_org_id" IS '机构id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_group_id" IS '站群ID';
COMMENT ON TABLE "fbp_admin_role_mapping" IS '账号角色关系表';
COMMENT ON TABLE "fbp_admin_role_mapping" IS '角色授权表';

-- ----------------------------
-- Table structure for fbp_admin_init_menu
-- ----------------------------
DROP TABLE IF EXISTS "fbp_admin_init_menu";
CREATE TABLE "fbp_admin_init_menu" (
  "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_navs" varchar(80000) ,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_admin_init_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_navs" IS '导航json';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_admin_init_menu" IS '初始化菜单信息表';

-- ----------------------------
-- Table structure for fbp_portal_diy_menu
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_diy_menu";
CREATE TABLE "fbp_portal_diy_menu" (
  "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,
  "c_navs" varchar(50000) ,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_navs" IS '导航路径json';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_menu" IS '个性化菜单表';


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


DROP TABLE IF EXISTS "fbp_app_catalog_mapping";
CREATE TABLE "fbp_app_catalog_mapping" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "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_catalog_id" int8,
  "c_app_code" varchar(50)
);
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_catalog_id" IS '应用分类id';
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_app_catalog_mapping" IS '应用分类关联表';


-- ----------------------------
-- Table structure for fbp_portal_component
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_component";
CREATE TABLE "fbp_portal_component" (
  "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_code" varchar(50) ,
  "c_text" varchar(255) ,
  "c_status" varchar(2) ,
  "c_is_auth" varchar(2) ,
  "c_version" varchar(100) ,
  "c_descri" varchar(255) ,
  "c_auth_name" varchar(255) ,
  "c_changelog" text ,
  "c_depends" text ,
  "c_category" varchar(500) ,
  "c_is_sys" varchar(255) ,
  "c_roles_json" varchar(4000) ,
  "c_permissions_json" varchar(4000) ,
  "c_app_type" varchar(10) ,
  "c_modes" varchar(500) ,
  "c_ref_id" varchar(200),
  "c_setting" text,
  "c_is_login" varchar(2) DEFAULT '0'
);
COMMENT ON COLUMN "fbp_portal_component"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component"."c_code" IS '部件编码';
COMMENT ON COLUMN "fbp_portal_component"."c_text" IS '部件名';
COMMENT ON COLUMN "fbp_portal_component"."c_status" IS '状态0停用1启用';
COMMENT ON COLUMN "fbp_portal_component"."c_is_auth" IS '认证0未认证1已认证';
COMMENT ON COLUMN "fbp_portal_component"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_portal_component"."c_descri" IS '说明';
COMMENT ON COLUMN "fbp_portal_component"."c_auth_name" IS '认证签名';
COMMENT ON COLUMN "fbp_portal_component"."c_changelog" IS '更新日志';
COMMENT ON COLUMN "fbp_portal_component"."c_depends" IS '依赖应用';
COMMENT ON COLUMN "fbp_portal_component"."c_category" IS '分类';
COMMENT ON COLUMN "fbp_portal_component"."c_is_sys" IS '是否为系统应用';
COMMENT ON COLUMN "fbp_portal_component"."c_roles_json" IS '部件内置所有角色json';
COMMENT ON COLUMN "fbp_portal_component"."c_permissions_json" IS '部件内置所有权限项json';
COMMENT ON COLUMN "fbp_portal_component"."c_app_type" IS '应用类型 0 PC 1 移动端';
COMMENT ON COLUMN "fbp_portal_component"."c_ref_id" IS '应用文件id';
COMMENT ON COLUMN "fbp_portal_component"."c_setting" IS '应用dsc设置';
COMMENT ON COLUMN "fbp_portal_component"."c_is_login" IS '是否是登录应用 0 否 1 是';
COMMENT ON TABLE "fbp_portal_component" IS '应用信息表';


-- ----------------------------
-- Table structure for fbp_portal_component_grant
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_component_grant";
CREATE TABLE "fbp_portal_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_app_code" varchar(200)  NOT NULL
);
COMMENT ON COLUMN "fbp_portal_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_portal_component_grant" IS '应用租户授权表';

-- ----------------------------
-- Table structure for fbp_portal_import_record
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_import_record";
CREATE TABLE "fbp_portal_import_record" (
  "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,
  "c_result" varchar(2) ,
  "c_file_name" varchar(100) ,
  "c_file_alias" varchar(100) ,
  "c_fail_reason" text ,
  "c_app_code" varchar(100)
);
COMMENT ON COLUMN "fbp_portal_import_record"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_import_record"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_import_record"."c_result" IS '结果0成功1失败';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_name" IS '导入路径';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_alias" IS '文件refenid';
COMMENT ON COLUMN "fbp_portal_import_record"."c_fail_reason" IS '失败原因';
COMMENT ON TABLE "fbp_portal_import_record" IS '应用上架记录表';

-- ----------------------------
-- Table structure for fbp_site_component_grant
-- ----------------------------
DROP TABLE IF EXISTS "fbp_site_component_grant";
CREATE TABLE "fbp_site_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_app_code" varchar(200)  NOT NULL,
  "c_site_id" int8,
  "c_setting" text
);
COMMENT ON COLUMN "fbp_site_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_site_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_site_component_grant"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_site_component_grant"."c_setting" IS '应用dsc配置';
COMMENT ON TABLE "fbp_site_component_grant" IS '应用站点授权表';

-- ----------------------------
-- Table structure for fbp_app_publish_log
-- ----------------------------
DROP TABLE IF EXISTS "fbp_app_publish_log";
CREATE TABLE "fbp_app_publish_log" (
  "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(50) ,
  "c_app_version" varchar(20) 
);
COMMENT ON COLUMN "fbp_app_publish_log"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_app_publish_log" IS '应用版本发布记录表';

-- ----------------------------
-- Table structure for fbp_portal_app_version
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_app_version";
CREATE TABLE "fbp_portal_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(50) ,
  "c_app_version" varchar(20) 
);
COMMENT ON COLUMN "fbp_portal_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_portal_app_version" IS '应用版本记录表';

-- ----------------------------
-- Table structure for fbp_portal_diy_app_version
-- ----------------------------
DROP TABLE IF EXISTS "fbp_portal_diy_app_version";
CREATE TABLE "fbp_portal_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(50) ,
  "c_app_version" varchar(20) ,
  "c_tenant_id" int8,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_version" IS '应用版本';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_app_version" IS '应用自定义版本记录表';

-- ----------------------------
-- 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 '登录日志表';

DROP TABLE IF EXISTS "fbp_admin_maintain_log";
  CREATE TABLE "fbp_admin_maintain_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_module_name" varchar(255) ,
     "c_operation" varchar(255) ,
     "c_description" clob ,
     "c_account_id" int8,
     "c_login_name" varchar(255) ,
     "c_full_name" varchar(255) ,
	 "c_site_id" int8,
	 "c_site_group_id" int8
  );
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_id" IS '主键';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modifier" IS '修改人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modify_time" IS '修改时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_creator" IS '创建人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_create_time" IS '创建时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_sort_number" IS '排序号';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_tenant_id" IS '租户ID';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_account_id" IS '操作账号id';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_login_name" IS '操作账号登录名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_full_name" IS '操作账号中文名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_module_name" IS '模块名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_operation" IS '操作';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_description" IS '描述';
  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';
  COMMENT ON TABLE "fbp_admin_maintain_log" IS '管理日志表';
 

DROP TABLE IF EXISTS "fbp_events";
CREATE TABLE "fbp_events" (
  "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_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 '服务事件表';

-- ----------------------------
-- Table structure for fbp_path
-- ----------------------------
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(50),
	"c_value" varchar(50),
	"c_name" varchar(255),
	"c_desc" varchar(500),
	"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 '应用参数配置表';

Postgress数据库

sql

-- ----------------------------
-- Table structure for fbp_datasource
-- ----------------------------
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 fbp_storages
-- ----------------------------
CREATE TABLE "fbp_storages" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_code" varchar(255) ,
  "c_name" varchar(255) ,
  "c_type" varchar(50),
  "c_site_group_id" int8,
  "c_endpoint" varchar(1000) ,
  "c_root_path" varchar(255) ,
  "c_access_key_id" varchar(255) ,
  "c_secret_access_key" varchar(255) ,
  "c_remark" varchar(2000) ,
  "c_bucket_name" varchar(500) ,
  "c_level" int2
);
COMMENT ON COLUMN "fbp_storages"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_storages"."c_code" IS '存储标识';
COMMENT ON COLUMN "fbp_storages"."c_name" IS '存储标识名称';
COMMENT ON COLUMN "fbp_storages"."c_type" IS '类型，local-本地存储，oss-OSS存储';
COMMENT ON COLUMN "fbp_storages"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_storages"."c_endpoint" IS 'OSS域';
COMMENT ON COLUMN "fbp_storages"."c_root_path" IS '端口';
COMMENT ON COLUMN "fbp_storages"."c_access_key_id" IS 'Oss账号id';
COMMENT ON COLUMN "fbp_storages"."c_secret_access_key" IS 'Oss账号密钥';
COMMENT ON COLUMN "fbp_storages"."c_remark" IS '备注';
COMMENT ON COLUMN "fbp_storages"."c_bucket_name" IS 'Oss存储桶';
COMMENT ON COLUMN "fbp_storages"."c_level" IS '数据源级别，1-平台级，2-站点级';
COMMENT ON TABLE "fbp_storages" IS '存储信息';




-- ----------------------------
-- Table structure for fbp_cache_pools
-- ----------------------------
CREATE TABLE "fbp_cache_pools" (
  "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_site_group_id" int8,
  "c_code" varchar(50),
  "c_name" varchar(100),
  "c_remark" varchar(500),
  "c_level" int2,
  "c_type" varchar(50),   
  "c_expire_seconds" int8,
  "c_maximum_size" int8, 
  "c_second_expire_seconds" int8, 
  "c_url" varchar(50), 
  "c_password" varchar(50) DEFAULT null,
  "c_database" int4,
   "c_port" int4
);
COMMENT ON COLUMN "fbp_cache_pools"."c_code" IS '代码';
COMMENT ON COLUMN "fbp_cache_pools"."c_name" IS '名字';
COMMENT ON COLUMN "fbp_cache_pools"."c_level" IS '缓存级别：1平台，2站点';
COMMENT ON COLUMN "fbp_cache_pools"."c_type" IS '类型：jvm/redis/level2';
COMMENT ON COLUMN "fbp_cache_pools"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_cache_pools"."c_expire_seconds" IS '过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_maximum_size" IS 'jvm最大缓存';
COMMENT ON COLUMN "fbp_cache_pools"."c_second_expire_seconds" IS '二级缓存过期时间';
COMMENT ON COLUMN "fbp_cache_pools"."c_url" IS '连接url';
COMMENT ON COLUMN "fbp_cache_pools"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_cache_pools"."c_database" IS '连接库';
COMMENT ON COLUMN "fbp_cache_pools"."c_port" IS '端口';
COMMENT ON TABLE "fbp_cache_pools" IS 'fbp缓存表';


----------------
---基础数据表
----------------

-- ----------------------------
-- Table structure for fbp_admin_tenant_info
-- ----------------------------
CREATE TABLE "fbp_admin_tenant_info" (
  "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_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(20) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_tenant_domain" varchar(100) ,
  "c_inited" int2 DEFAULT 0,
  "c_tenant_id" int8,
  "c_tenant_setting" varchar(2000) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_xzjb" int4
);
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_name" IS '租户名称';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_domain" IS '租户域名';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_tenant_setting" IS '租户配置';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_key" IS '钉钉唯一标识key';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_app_secret" IS '钉钉唯一密钥';
COMMENT ON COLUMN "fbp_admin_tenant_info"."c_xzjb" IS '所属行政级别：1：升级 2：市级 3：区县';
COMMENT ON TABLE "fbp_admin_tenant_info" IS '租户信息表';

  -- ----------------------------
-- Table structure for fbp_admin_site_group_info
-- ----------------------------
CREATE TABLE "fbp_admin_site_group_info" (
  "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,
  "c_tenant_code" varchar(32) ,
  "c_code" varchar(32) ,
  "c_name" varchar(32) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_config" text,
  "c_desc" varchar(2000)
);
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_tenant_code" IS '租户代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_code" IS '站群代码';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_name" IS '站群名称';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_config" IS '站群配置';
COMMENT ON COLUMN "fbp_admin_site_group_info"."c_desc" IS '站群备注说明';
COMMENT ON TABLE "fbp_admin_site_group_info" IS '站群信息表';

-- ----------------------------
-- Table structure for fbp_admin_site_info
-- ----------------------------
CREATE TABLE "fbp_admin_site_info" (
  "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_site_type" int4,
  "c_title" varchar(200) ,
  "c_theme" varchar(100) ,
  "c_logo" varchar(100) ,
  "c_code" varchar(20) ,
  "c_name" varchar(100) ,
  "c_contact" varchar(50) ,
  "c_mobile" varchar(11) ,
  "c_email" varchar(100) ,
  "c_activate_time" timestamp(6),
  "c_invalid_time" timestamp(6),
  "c_site_domain" varchar(100) ,
  "c_inited" int2 DEFAULT 0,
  "c_tenant_id" int8,
  "c_site_setting" text ,
  "c_tenant_code" varchar(32) ,
  "c_app_key" varchar(255) ,
  "c_app_secret" varchar(255) ,
  "c_manage_sites" varchar(100) ,
  "c_site_group_id" int8,
  "c_is_manage_site" int2 DEFAULT 0,
  "c_site_group_code" varchar(50) 
);
COMMENT ON COLUMN "fbp_admin_site_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_site_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_type" IS '站点类型';
COMMENT ON COLUMN "fbp_admin_site_info"."c_title" IS '标题';
COMMENT ON COLUMN "fbp_admin_site_info"."c_code" IS '站点代码';
COMMENT ON COLUMN "fbp_admin_site_info"."c_name" IS '名称';
COMMENT ON COLUMN "fbp_admin_site_info"."c_contact" IS '联系人账号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_mobile" IS '联系人手机号';
COMMENT ON COLUMN "fbp_admin_site_info"."c_email" IS '联系人邮箱';
COMMENT ON COLUMN "fbp_admin_site_info"."c_activate_time" IS '生效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_invalid_time" IS '失效时间';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_domain" IS '站点域名';
COMMENT ON COLUMN "fbp_admin_site_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_setting" IS '站点配置';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_site_info"."c_is_manage_site" IS '是否是管理站点';
COMMENT ON COLUMN "fbp_admin_site_info"."c_site_group_code" IS '站群标识';
COMMENT ON TABLE "fbp_admin_site_info" IS '站点信息表';

-- ----------------------------
-- Table structure for fbp_admin_account_info
-- ----------------------------
CREATE TABLE "fbp_admin_account_info" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "c_granted_apis" varchar(255) ,
  "c_account_expired" varchar(1) ,
  "c_account_locked" varchar(1) ,
  "c_credentials_expired" varchar(1) ,
  "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,
  "c_login_name" varchar(32) ,
  "c_login_dingding" varchar(32) ,
  "c_login_phone" varchar(100) ,
  "c_login_email" varchar(50) ,
  "c_status" int2 DEFAULT 1,
  "c_password_policy" int4,
  "c_password" varchar(255) ,
  "c_mobile_device" varchar(255) ,
  "c_allow_mobile_access" varchar(1) ,
  "c_last_login_time" timestamp(6),
  "c_last_login_client_ip" varchar(50) ,
  "c_last_login_failed" timestamp(6),
  "c_default_tenant" varchar(11) ,
  "c_account_source" int8,
  "c_account_type" int4,
  "c_full_name" varchar(50) ,
  "c_tag" varchar(1000) ,
  "c_theme" varchar(500) ,
  "c_avatar" varchar(50) ,
  "c_account_uuid" varchar(100) ,
  "c_login_alias" varchar(200),
  "c_site_group_id" int8,
  "c_identity_code" varchar(100),
  "c_user_code" varchar(100),
  "c_identity_desc" varchar(500)
);
COMMENT ON COLUMN "fbp_admin_account_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_info"."c_granted_apis" IS 'API访问权限项';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_expired" IS 'spring security 账号是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_locked" IS 'spring security 账号是否锁定';
COMMENT ON COLUMN "fbp_admin_account_info"."c_credentials_expired" IS 'spring security 用户证书是否过期';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_name" IS '登录账号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_dingding" IS '登录钉钉号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_phone" IS '登录手机号';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_email" IS '登录邮箱';
COMMENT ON COLUMN "fbp_admin_account_info"."c_status" IS '状态 0 停用 1 启用';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password_policy" IS '密码策略';
COMMENT ON COLUMN "fbp_admin_account_info"."c_password" IS '密码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_mobile_device" IS '移动设备标识';
COMMENT ON COLUMN "fbp_admin_account_info"."c_allow_mobile_access" IS '是否允许移动访问';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_time" IS '上次正常登录时间';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_client_ip" IS '上次登录IP';
COMMENT ON COLUMN "fbp_admin_account_info"."c_last_login_failed" IS '上次失败时间登录';
COMMENT ON COLUMN "fbp_admin_account_info"."c_default_tenant" IS '默认租户代码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_source" IS '账号来源';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_type" IS '账号类型';
COMMENT ON COLUMN "fbp_admin_account_info"."c_full_name" IS '姓名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_tag" IS '标签';
COMMENT ON COLUMN "fbp_admin_account_info"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_info"."c_avatar" IS '头像';
COMMENT ON COLUMN "fbp_admin_account_info"."c_account_uuid" IS '账号uuid';
COMMENT ON COLUMN "fbp_admin_account_info"."c_login_alias" IS '登录别名';
COMMENT ON COLUMN "fbp_admin_account_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_code" IS '身份编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_user_code" IS '用户编码';
COMMENT ON COLUMN "fbp_admin_account_info"."c_identity_desc" IS '用户身份描述';
COMMENT ON TABLE "fbp_admin_account_info" IS '账号信息表';


-- ----------------------------
-- Table structure for fbp_admin_account_tenant
-- ----------------------------
CREATE TABLE "fbp_admin_account_tenant" (
  "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,
  "c_site_id" int8,
  "c_theme" VARCHAR(100),
  "c_site_group_id" int8
);
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_theme" IS '自定义主题';
COMMENT ON COLUMN "fbp_admin_account_tenant"."c_site_group_id" IS '站群id';
COMMENT ON TABLE "fbp_admin_account_tenant" IS '账号站点授权关联表';



-- ----------------------------
-- Table structure for fbp_admin_role_info
-- ----------------------------
CREATE TABLE "fbp_admin_role_info" (
  "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,
  "c_role_code" varchar(20) ,
  "c_role_name" varchar(50) ,
  "c_power_code" varchar(2000) ,
  "c_power_name" varchar(2000) ,
  "c_version" varchar(100) ,
  "c_role_type" int4,
  "c_portal_component_code" varchar(50) ,
  "c_site_id" int8,
  "c_site_group_id" int8,
  "c_tag" varchar(4000) 
);
COMMENT ON COLUMN "fbp_admin_role_info"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_code" IS '角色code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_name" IS '角色名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_code" IS '权限项code';
COMMENT ON COLUMN "fbp_admin_role_info"."c_power_name" IS '权限项名称';
COMMENT ON COLUMN "fbp_admin_role_info"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_admin_role_info"."c_role_type" IS '角色类型 0 系统角色 1 租户自定义角色';
COMMENT ON COLUMN "fbp_admin_role_info"."c_portal_component_code" IS '部件编码';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_id" IS '站点id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_site_group_id" IS '站群id';
COMMENT ON COLUMN "fbp_admin_role_info"."c_tag" IS '标签';
COMMENT ON TABLE "fbp_admin_role_info" IS '角色信息表';

-- ----------------------------
-- Table structure for fbp_admin_role_mapping
-- ----------------------------
CREATE TABLE "fbp_admin_role_mapping" (
  "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,
  "c_role_id" int8,
  "c_account_id" int8,
  "c_org_id" int8,
  "c_site_id" int8,
  "c_site_group_id" int8
);
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_role_id" IS '角色id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_org_id" IS '机构id';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_id" IS '站点ID';
COMMENT ON COLUMN "fbp_admin_role_mapping"."c_site_group_id" IS '站群ID';
COMMENT ON TABLE "fbp_admin_role_mapping" IS '账号角色关系表';


-- ----------------------------
-- Table structure for fbp_admin_init_menu
-- ----------------------------
CREATE TABLE "fbp_admin_init_menu" (
  "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_navs" varchar(80000) ,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_admin_init_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_navs" IS '导航json';
COMMENT ON COLUMN "fbp_admin_init_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_admin_init_menu" IS '初始化菜单信息表';

-- ----------------------------
-- Table structure for fbp_portal_diy_menu
-- ----------------------------
CREATE TABLE "fbp_portal_diy_menu" (
  "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,
  "c_navs" varchar(50000) ,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_account_id" IS '账号id';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_navs" IS '导航路径json';
COMMENT ON COLUMN "fbp_portal_diy_menu"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_menu" IS '个性化菜单表';


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

CREATE TABLE "fbp_app_catalog_mapping" (
  "c_id" serial8 NOT NULL PRIMARY KEY,
  "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_catalog_id" int8,
  "c_app_code" varchar(50)
);
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_catalog_id" IS '应用分类id';
COMMENT ON COLUMN "fbp_app_catalog_mapping"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_app_catalog_mapping" IS '应用分类关联表';


-- ----------------------------
-- Table structure for fbp_portal_component
-- ----------------------------
CREATE TABLE "fbp_portal_component" (
  "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_code" varchar(50) ,
  "c_text" varchar(255) ,
  "c_status" varchar(2) ,
  "c_is_auth" varchar(2) ,
  "c_version" varchar(100) ,
  "c_descri" varchar(255) ,
  "c_auth_name" varchar(255) ,
  "c_changelog" text ,
  "c_depends" text ,
  "c_category" varchar(500) ,
  "c_is_sys" varchar(255) ,
  "c_roles_json" varchar(4000) ,
  "c_permissions_json" varchar(4000) ,
  "c_app_type" varchar(10) ,
  "c_modes" varchar(500) ,
  "c_ref_id" varchar(200),
  "c_setting" text,
  "c_is_login" varchar(2) DEFAULT '0'
);
COMMENT ON COLUMN "fbp_portal_component"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component"."c_code" IS '部件编码';
COMMENT ON COLUMN "fbp_portal_component"."c_text" IS '部件名';
COMMENT ON COLUMN "fbp_portal_component"."c_status" IS '状态0停用1启用';
COMMENT ON COLUMN "fbp_portal_component"."c_is_auth" IS '认证0未认证1已认证';
COMMENT ON COLUMN "fbp_portal_component"."c_version" IS '版本号';
COMMENT ON COLUMN "fbp_portal_component"."c_descri" IS '说明';
COMMENT ON COLUMN "fbp_portal_component"."c_auth_name" IS '认证签名';
COMMENT ON COLUMN "fbp_portal_component"."c_changelog" IS '更新日志';
COMMENT ON COLUMN "fbp_portal_component"."c_depends" IS '依赖应用';
COMMENT ON COLUMN "fbp_portal_component"."c_category" IS '分类';
COMMENT ON COLUMN "fbp_portal_component"."c_is_sys" IS '是否为系统应用';
COMMENT ON COLUMN "fbp_portal_component"."c_roles_json" IS '部件内置所有角色json';
COMMENT ON COLUMN "fbp_portal_component"."c_permissions_json" IS '部件内置所有权限项json';
COMMENT ON COLUMN "fbp_portal_component"."c_app_type" IS '应用类型 0 PC 1 移动端';
COMMENT ON COLUMN "fbp_portal_component"."c_ref_id" IS '应用文件id';
COMMENT ON COLUMN "fbp_portal_component"."c_setting" IS '应用dsc设置';
COMMENT ON COLUMN "fbp_portal_component"."c_is_login" IS '是否是登录应用 0 否 1 是';
COMMENT ON TABLE "fbp_portal_component" IS '部件信息表';


-- ----------------------------
-- Table structure for fbp_portal_component_grant
-- ----------------------------
CREATE TABLE "fbp_portal_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_app_code" varchar(200)  NOT NULL
);
COMMENT ON COLUMN "fbp_portal_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_portal_component_grant"."c_app_code" IS '应用code';
COMMENT ON TABLE "fbp_portal_component_grant" IS '部件授权租户信息表';

-- ----------------------------
-- Table structure for fbp_portal_import_record
-- ----------------------------
CREATE TABLE "fbp_portal_import_record" (
  "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,
  "c_result" varchar(2) ,
  "c_file_name" varchar(100) ,
  "c_file_alias" varchar(100) ,
  "c_fail_reason" text ,
  "c_app_code" varchar(100)
);
COMMENT ON COLUMN "fbp_portal_import_record"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_import_record"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_import_record"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_import_record"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "fbp_portal_import_record"."c_result" IS '结果0成功1失败';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_name" IS '导入路径';
COMMENT ON COLUMN "fbp_portal_import_record"."c_file_alias" IS '文件refenid';
COMMENT ON COLUMN "fbp_portal_import_record"."c_fail_reason" IS '失败原因';
COMMENT ON TABLE "fbp_portal_import_record" IS '应用上架记录表';



-- ----------------------------
-- Table structure for fbp_site_component_grant
-- ----------------------------
CREATE TABLE "fbp_site_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_app_code" varchar(200)  NOT NULL,
  "c_site_id" int8,
  "c_setting" text
);
COMMENT ON COLUMN "fbp_site_component_grant"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_site_component_grant"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_site_component_grant"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_site_component_grant"."c_tenant_id" IS '授权ID: 租户ID';
COMMENT ON COLUMN "fbp_site_component_grant"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_site_component_grant"."c_setting" IS '应用dsc配置';
COMMENT ON TABLE "fbp_site_component_grant" IS '部件授权租户信息表';


-- ----------------------------
-- Table structure for fbp_app_publish_log
-- ----------------------------
CREATE TABLE "fbp_app_publish_log" (
  "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(50) ,
  "c_app_version" varchar(20)
);
COMMENT ON COLUMN "fbp_app_publish_log"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_app_publish_log"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_app_publish_log"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_code" IS '应用code';
COMMENT ON COLUMN "fbp_app_publish_log"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_app_publish_log" IS '应用版本发布记录表';


-- ----------------------------
-- Table structure for fbp_portal_app_version
-- ----------------------------
CREATE TABLE "fbp_portal_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(50) ,
  "c_app_version" varchar(20)
);
COMMENT ON COLUMN "fbp_portal_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_app_version"."c_app_version" IS '应用版本';
COMMENT ON TABLE "fbp_portal_app_version" IS '应用授权版本记录表';

-- ----------------------------
-- Table structure for fbp_portal_diy_app_version
-- ----------------------------
CREATE TABLE "fbp_portal_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(50) ,
  "c_app_version" varchar(20) ,
  "c_tenant_id" int8,
  "c_site_id" int8
);
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_id" IS '主键';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_creator" IS '创建人';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_code" IS '安装应用code';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_app_version" IS '应用版本';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_tenant_id" IS '租户id';
COMMENT ON COLUMN "fbp_portal_diy_app_version"."c_site_id" IS '站点id';
COMMENT ON TABLE "fbp_portal_diy_app_version" IS '应用自定义版本记录表';



-- ----------------------------
-- Table structure for 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 'fbp运维通知表';

-- ----------------------------
-- Table structure for 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 'fbp运维通知签收表';



---------
--登录日志
--------
-- ----------------------------
-- Table structure for 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 '操作结果 1 成功 0/null 失败';
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 'fbp登录日志表';


  CREATE TABLE "fbp_admin_maintain_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_module_name" varchar(255) ,
     "c_operation" varchar(255) ,
     "c_description" text,
     "c_account_id" int8,
     "c_login_name" varchar(255) ,
     "c_full_name" varchar(255) ,
	 "c_site_id" int8,
     "c_site_group_id" int8
  );
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_id" IS '主键';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modifier" IS '修改人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_last_modify_time" IS '修改时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_creator" IS '创建人';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_create_time" IS '创建时间';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_sort_number" IS '排序号';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_tenant_id" IS '租户ID';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_account_id" IS '操作账号id';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_login_name" IS '操作账号登录名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_full_name" IS '操作账号中文名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_module_name" IS '模块名';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_operation" IS '操作';
  COMMENT ON COLUMN "fbp_admin_maintain_log"."c_description" IS '描述';
  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';
  COMMENT ON TABLE "fbp_admin_maintain_log" IS 'fbp管理日志表';

  CREATE TABLE "fbp_events" (
  "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_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_path
-- ----------------------------
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(50),
	"c_value" varchar(50),
	"c_name" varchar(255),
	"c_desc" varchar(500),
	"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 '应用参数配置表';

2、在库中执行初始化系统基本功能语句

初始化语句

sql

-------------------------------------------------------
-- 初始化系统管理站（sys_manage）、系统管理员（sys_admin），系统管理站访问地址：http://ip:port/admin  账号：sys_admin
------------------------------------------------------
-- 初始化平台租户(sys)
INSERT INTO "fbp_admin_tenant_info"("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_sort_number", "c_code", "c_name", "c_contact", "c_mobile", "c_email", "c_activate_time", "c_invalid_time", "c_tenant_domain", "c_inited", "c_tenant_id", "c_tenant_setting", "c_app_key", "c_app_secret") VALUES (1, NULL, 1, NULL, 1, 'sys', '系统租户', NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, '{"systemName":"中科天翔系统管理平台","logo":"/apps/img/sys/lQDPJxTtrlxmczTMyMzIsKlS3LZESh2yA4tJP_LAggA_200_200.jpg","theme":"maui-explorer.default","shortName":"管理平台","loginImage":"/apps/img/sys/login.jpg"}', NULL, NULL);

-- 初始化平台站群(sys_sg)
INSERT INTO "fbp_admin_site_group_info"("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_sort_number", "c_tenant_id", "c_tenant_code", "c_code", "c_name", "c_activate_time", "c_invalid_time","c_config") VALUES (1, now(), 3, now(), (select c_id from fbp_admin_tenant_info where c_code = 'sys'), 1, 'sys', 'sys_sg', '默认站群', NULL, NULL,'{"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}}');

--初始化系统管理站点（sys_manage）
INSERT INTO "fbp_admin_site_info"("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_sort_number", "c_site_type", "c_code", "c_name", "c_contact","c_tenant_id", "c_site_setting", "c_tenant_code", "c_site_group_id", "c_is_manage_site", "c_site_group_code") VALUES (1, now() , 1, now(), 1, 0,  'sys_manage', '系统管理', 'sys_admin',  (select c_id from fbp_admin_tenant_info where c_code = 'sys'), '{"appKey":"","appSecret":"","systemName":"系统管理","shortName":"系统管理","theme": "theme-vertical-blue.default"}', 'sys', (select c_id from fbp_admin_site_group_info WHERE c_code = 'sys_sg'), 1, 'sys_sg');

--初始化系统管理员账号（sys_admin）
INSERT INTO "fbp_admin_account_info"("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_sort_number", "c_tenant_id", "c_site_group_id","c_login_name","c_status", "c_password",  "c_default_tenant", "c_account_type", "c_full_name") VALUES (1, now(), 1, now(), 1, (select c_id from fbp_admin_tenant_info where c_code = 'sys'),(select c_id from fbp_admin_site_group_info WHERE c_code = 'sys_sg'), 'sys_admin', '1', '$2a$10$7B1jfrju3iOGFd8F5dfZzuCgReqJBqasvSPyO0oYtNCP3n2h69Q8C', 'sys',  0, '系统管理员');

--将管理员账号授权到管理站点
INSERT INTO "fbp_admin_account_tenant"("c_last_modifier", "c_last_modify_time", "c_creator", "c_create_time", "c_tenant_id", "c_account_id", "c_site_id","c_site_group_id") VALUES (1, now(), 1, now(),  (select c_id from fbp_admin_tenant_info where c_code = 'sys'), (select c_id from fbp_admin_account_info where c_login_name = 'sys_admin'), (select c_id from fbp_admin_site_info where c_code = 'sys_manage'),(select c_id from fbp_admin_site_group_info WHERE c_code = 'sys_sg'));


-----------------------------------
--初始化平台基础应用及授权数据
----------------------------------
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-ops','v1.1.0.30');
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.1.0.30.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-ops','v1.1.0.30');
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.1.0.30','系统管理',0,0,'["app","page","print"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-admin','v1.2.0.44');
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.2.0.44.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-admin','v1.2.0.44');
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.2.0.44','系统管理',0,0,'["app","page","print"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-sm2','v1.0.0.1');
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-sm2-v1.0.0.1.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-sm2','v1.0.0.1');
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-sm2','v1.0.0.1','国密2',0,0,'["app","page","print","mobile"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('mas-explorer','5.14.18');
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.18.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('mas-explorer','5.14.18');
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.18','PC资源管理',0,0,'["app","page","print"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('locar','2.8.18');
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.18.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('locar','2.8.18');
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.18','页面引擎',0,0,'["app","page","print","mobile"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-userpwdlogin','v1.1.0.17');
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.17.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-userpwdlogin','v1.1.0.17');
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.17','账号密码登录',0,0,'["app","mobile","page","print"]',now(),'1');

insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-modify-pwd','v1.0.0.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,'lc-modify-pwd-v1.0.0.9.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-modify-pwd','v1.0.0.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,c_is_login) values('中科天翔','lc-modify-pwd','v1.0.0.9','修改密码',0,0,'["app","page","print"]',now(),'0');

insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-unlocklogin','v1.1.0.4');
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.4.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-unlocklogin','v1.1.0.4');
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.4','解锁',0,0,'["app","page","print"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('theme-vertical-blue','5.14.18');
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.18.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('theme-vertical-blue','5.14.18');
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.18','纵向导航主题',0,0,'["app","page","print"]',now());

----------------------
-- DSC应用
-----------------------
insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-fbppdsm','v1.1.0.18');
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.18.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-fbppdsm','v1.1.0.18');
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.18','数据源(平台)',0,0,'["app","page","print"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-pstorage','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-pstorage-v1.1.0.14.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-pstorage','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) values('中科天翔','lc-pstorage','v1.1.0.14','存储(平台)',0,0,'["app","page","print"]',now());

insert into fbp_portal_app_version(c_app_code,c_app_version) values('lc-pcache','v1.1.0.15');
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.15.tgz');
insert into fbp_app_publish_log(c_app_code,c_app_version) values('lc-pcache','v1.1.0.15');
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.15','缓存(平台)',0,0,'["app","page","print"]',now());

-------------
--- 应用授权
--------------
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'),'mas-explorer');
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'),'lc-userpwdlogin');
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-sm2');
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'),'locar');
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-fbppdsm');
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-pstorage');
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-pcache');
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');

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_manage'),'mas-explorer');
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_manage'),'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_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_manage'),'lc-userpwdlogin');
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_manage'),'lc-sm2');
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_manage'),'locar');
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_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_manage'),'lc-fbppdsm');
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_manage'),'lc-pstorage');
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_manage'),'lc-pcache');
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_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_manage'),'lc-unlocklogin');
------------------------
--初始化应用分类
------------------------
INSERT INTO fbp_app_catalog(c_catalog_name,c_catalog_code) VALUES ('系统管理','1');
INSERT INTO fbp_app_catalog(c_catalog_name,c_catalog_code) VALUES ('运行支撑','2');
INSERT INTO fbp_app_catalog(c_catalog_name,c_catalog_code) VALUES ('主题','3');
INSERT INTO fbp_app_catalog(c_catalog_name,c_catalog_code) VALUES ('JS库','4');
INSERT INTO fbp_app_catalog(c_catalog_name,c_catalog_code) VALUES ('其它','5');

-------------------
-- 应用关联分类
-------------------
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 ( '2', 'mas-explorer');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'lc-syscachemng');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'lc-modify-pwd');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'lc-userpwdlogin');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'lc-unlocklogin');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'locar');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('4', 'lc-sm2');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'lc-fbppdsm');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'lc-pstorage');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('2', 'lc-pcache');
insert into fbp_app_catalog_mapping(c_catalog_id, c_app_code) values ('3', 'theme-vertical-blue');

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_manage'), 'sys_manage', '/admin', '系统管理');

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_manage'), (select c_id from fbp_admin_tenant_info where c_code = 'sys'), '[{"path":"/lc-ops/yysj/appinstall-single","isDyn":"1","auth":"r.default","icon":"el-icon-present","id":1725428354640,"text":"应用管理","title":"应用中心","parentId":108,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/zdgl/safesetting","isDyn":"1","auth":"r.default","icon":"el-icon-guide","id":2725428354640,"text":"安全设置","title":"安全设置","parentId":108,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/zdgl/site-list","isDyn":"1","icon":"el-icon-office-building","onHandler":"0","id":1734428219329,"title":" 站点管理","parentId":99},{"path":"/lc-admin/zhgl/account-management","isDyn":"1","icon":"el-icon-user","onHandler":"0","id":1734428219329,"title":"账号管理","parentId":99},{"path":"/lc-admin/jsgl/role-list","isDyn":"1","icon":"el-icon-medal","onHandler":"0","id":1734428219329,"title":"角色管理","parentId":99,"auth":"","linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-admin/jsgl/role-grant-list","isDyn":"1","icon":"el-icon-coordinate","onHandler":"0","id":1734428219329,"title":"角色授权","parentId":99},{"path":"/lc-ops/dzgl/path-manager","isDyn":"1","icon":"el-icon-coordinate","onHandler":"0","id":17344282193291,"title":"地址管理","parentId":99},{"path":"/lc-ops/param/setting","isDyn":"1","icon":"el-icon-setting","onHandler":"0","id":1734428219329,"title":"参数设置","parentId":99,"auth":"","linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"hidden":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/main/46b37582c67f820bdcd91a9dad4b4781","auth":"r.default","icon":"el-icon-notebook-1","title":"日志管理","isDiy":"1","hidden":false,"isLeaf":false,"children":[{"path":"/lc-admin/czrz/login-log","isDyn":"1","icon":"el-icon-tickets","onHandler":"0","id":1734428219329,"title":"登录日志","parentId":99},{"path":"/lc-admin/glrz/manage-log","isDyn":"1","icon":"el-icon-document-copy","onHandler":"0","id":1734428219329,"title":"管理日志","parentId":99}],"deleted":2,"linkUrl":"","isLink":false,"needSso":false,"isEasyv":false,"isOauth2":false,"anonymous":false,"easyvUrl":"","easyvKey":""},{"path":"/lc-ops/ywgg/devops-notice-list","isDyn":"1","icon":"el-icon-chat-line-square","onHandler":"0","id":1734428179524,"title":"运维公告","parentId":100},{"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":""}]}]');

3、将系统程序文件Mas-FBP-Server.zip解压后文件放入/data/softs/min_locar下

4、修改bin目录里run.sh文件，主要指定jdk目录（要求jdk至少为jdk8）、设置内存大小【修改文件开头这几个变量值：JDK_HOME、JVM_XMS、JVM_XMX、JVM_XSS】

注意：JVM_XSS的值是单个线程的堆栈大小，不要设置过大，且单位为：k

#!/bin/bash
JDK_HOME=/opt/softs/jdk1.8.0_241
JVM_XMS=256M
JVM_XMX=256M
JVM_XSS=512K

5、修改conf目录里的application-prod.properties文件

主要修改服务端口、数据库连接信息、redis连接信息【非必须，不开启redis将会使用jvm缓存】、oss连接信息【非必须，默认使用本地存储】、授权码（需配置好数据库连接信息后，启动服务从日志（/data/softs/min_locar/Mas-FBP-Server/bin/nohup.out）中获取机器码【MachineCode:xxxxx】发给公司来获取授权码）

[server]
ssl = false
port = 80
license = xxxxxxxxxxxxxxxxxxx

[nacos]
enabled = false
service = fbp
server-addr = xxxx:8848
username = nacos
password = nacos

[boot]
namespace = boot
version = 1.1.1

[redis]
#host = 127.0.0.1
#port = 6377
#password = xxxx
#database = 0
#expireSeconds = 240000


[file]
# local / oss
type = local

[oss]
endpoint = oss-cn-hangzhou.aliyuncs.com
accessId = xxxxxxxxx
accessKey = xxxxxxxxxxx
bucket = xxxxx
rootDir = xxxxxxxxx

[db]
# polardb
driver-class-name = com.aliyun.polardb.Driver
url = jdbc:polardb://xxxx.rwlb.polardb-pg-public.rds.aliyuncs.com:1521/fbp_test?currentSchema=public&stringtype=unspecified
username = foa5
password = FOA5!0726


# postgresql
#driver-class-name = org.postgresql.Driver
#url = jdbc:postgresql://127.0.0.1:5432/xxxx?currentSchema=tmp&stringtype=unspecified
#username = postgres
#password = xxxx

#DM
#driver-class-name = dm.jdbc.driver.DmDriver
#url = jdbc:dm://127.0.0.1:5236/xxxx?schema=xxx
#username = xxxx
#password = xxxx

# kingbase
#driver-class-name = com.kingbase8.Driver
#url = jdbc:kingbase8://127.0.0.1:54321/xxxx?currentSchema=xxxxx
#username = xxxx
#password = xxxx


[datasource]
initial-size = 1
min-idle = 1
max-active = 20
max-wait = 60000
time-between-eviction-runs-millis = 60000
min-evictable-idle-time-millis = 300000
validation-query = SELECT 1
test-while-idle = true
test-on-borrow = false
test-on-return = false
pool-prepared-statements = false
max-pool-prepared-statement-per-connection-size = 20

6、进入/data/softs/min_locar/Mas-FBP-Server/bin目录，将mas.sh、run.sh文件授予可执行权限

chmod +x mas.sh
chmod +x run.sh

7、安装nginx（略），配置nginx将前端请求代理到fbp服务

因为服务目录在/data/softs/min_locar/Mas-FBP-Server，前端文件在其下的html里，所以需要将/代理指向到/data/softs/min_locar/Mas-FBP-Server/data/html

location / {
	root   /data/softs/min_locar/Mas-FBP-Server/data/html;
	index  index.html index.htm;
	try_files $uri $uri/ /index.html;
    }

应用文件在其下的apps里，所以需要将/apps/代理指向到/data/softs/min_locar/Mas-FBP-Server/data/apps/

location /apps/ {               
	    alias /data/softs/min_locar/Mas-FBP-Server/data/apps/;
	}

将前端请求代理到fbp服务

location /api/fbp/ {
        proxy_pass   http://192.168.1.96:3333/;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    }

将websocket请求代理到fbp服务

location /ws {
        proxy_pass http://192.168.1.96:3333;
        proxy_http_version 1.1;
        proxy_set_header Upgrade websocket;
        proxy_set_header Connection upgrade;
    }

完整示例：

server {
    listen       6455;

    #主机名称：其后可以跟多个主机名称，开始处理一个HTTP请求时，nginx会取出header头中的Host，与每个server中的server_name进行匹配，以此决定到底由那一个server来处理这个请求。有可能一个Host与多个server块中的server_name都匹配，这时会根据匹配优先级来选择实际处理的server块。server_name与Host的匹配优先级见文末。
    server_name  localhost;

    client_max_body_size 200M;
    proxy_read_timeout 300s;

    add_header X-Frame-Options SAMEORIGIN always;
    add_header Content-Security-Policy "default-src *;style-src 'self' 'unsafe-inline';script-src 'self' 'unsafe-inline' 'unsafe-eval';img-src * data:;worker-src * blob:;font-src 'self' data:;";    

    
    #禁用get、post以外的请求
    if ($request_method !~ ^(GET|POST)$ ){
        return 405;
    }

    location / {
	root   /data/softs/min_locar/Mas-FBP-Server/data/html;
	index  index.html index.htm;
	try_files $uri $uri/ /index.html;
    }
	
    #本地应用代理
	location /apps/ {               
	    alias /data/softs/min_locar/Mas-FBP-Server/data/apps/;
	}

    #前端请求代理到fbp服务
    location /api/fbp/ {
        proxy_pass   http://192.168.1.96:3333/;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    }

    #websocket代理
    location /ws {
        proxy_pass http://192.168.1.96:3333;
        proxy_http_version 1.1;
        proxy_set_header Upgrade websocket;
        proxy_set_header Connection upgrade;
    }

	
    error_page 404 = @tempdown;

    location @tempdown {
         rewrite ^(.*)$ /index.html break;
    }

    # redirect server error pages to the static page /50x.html
    error_page   500 502 503 504  /50x.html;
    location = /50x.html {
        root   /usr/share/nginx/html;
    }

  }

9、进入/data/softs/min_locar/Mas-FBP-Server/bin目录，运行./run.sh启动服务

cd /data/softs/min_locar/Mas-FBP-Server/bin
    ./run.sh

10、fbp服务启动、nginx启动后，访问：http://ip:port/admin 【如：http://192.168.1.96:6455/admin 】登录账号：sys_admin

登录后可进入站点设置，为系统管理站点设置域名

Locar 最小化低代码运行环境 ​

系统功能、能力 ​

更新内容 ​

依赖中间件 ​

版本 ​

部署 ​

Locar 最小化低代码运行环境

系统功能、能力

更新内容

依赖中间件

版本

部署