From 5894a4a94bd415e6219a5852b05f127fd03e3aba Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 14 七月 2025 16:47:15 +0800
Subject: [PATCH] 支持https协议
---
docker/postgis/init/init.sql | 551 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 551 insertions(+), 0 deletions(-)
diff --git a/docker/postgis/init/init.sql b/docker/postgis/init/init.sql
new file mode 100644
index 0000000..26be114
--- /dev/null
+++ b/docker/postgis/init/init.sql
@@ -0,0 +1,551 @@
+/*
+ * Copyright 1999-2018 Alibaba Group Holding Ltd.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+-- ----------------------------
+-- create extension
+-- ----------------------------
+create extension if not exists postgis cascade;
+
+create extension if not exists "uuid-ossp";
+
+
+-- ----------------------------
+-- Table structure for config_info_gray
+-- ----------------------------
+DROP TABLE IF EXISTS "config_info_gray";
+CREATE TABLE "config_info_gray" (
+ "id" bigserial NOT NULL,
+ "data_id" varchar(255) NOT NULL,
+ "group_id" varchar(128) NOT NULL,
+ "content" text NOT NULL,
+ "md5" varchar(32),
+ "src_user" text,
+ "src_ip" varchar(100) NOT NULL,
+ "gmt_create" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "gmt_modified" timestamp(6) NOT NULL,
+ "app_name" varchar(128) DEFAULT NULL::character varying,
+ "tenant_id" varchar(128) DEFAULT ''::character varying,
+ "gray_name" varchar(128) NOT NULL,
+ "gray_rule" text NOT NULL,
+ "encrypted_data_key" varchar(256) NOT NULL
+);
+COMMENT ON COLUMN "config_info_gray"."id" IS '鑷ID';
+COMMENT ON COLUMN "config_info_gray"."data_id" IS 'data_id';
+COMMENT ON COLUMN "config_info_gray"."group_id" IS 'group_id';
+COMMENT ON COLUMN "config_info_gray"."content" IS 'content';
+COMMENT ON COLUMN "config_info_gray"."md5" IS 'md5';
+COMMENT ON COLUMN "config_info_gray"."src_user" IS 'src_user';
+COMMENT ON COLUMN "config_info_gray"."src_ip" IS 'src_ip';
+COMMENT ON COLUMN "config_info_gray"."gmt_create" IS 'gmt_create';
+COMMENT ON COLUMN "config_info_gray"."gmt_modified" IS 'gmt_modified';
+COMMENT ON COLUMN "config_info_gray"."app_name" IS 'app_name';
+COMMENT ON COLUMN "config_info_gray"."tenant_id" IS 'tenant_id';
+COMMENT ON COLUMN "config_info_gray"."gray_name" IS 'gray_name';
+COMMENT ON COLUMN "config_info_gray"."gray_rule" IS 'gray_rule';
+COMMENT ON COLUMN "config_info_gray"."encrypted_data_key" IS 'encrypted_data_key';
+
+-- ----------------------------
+-- Primary Key structure for table config_info_gray
+-- ----------------------------
+ALTER TABLE "config_info_gray" ADD CONSTRAINT "config_info_gray_pkey" PRIMARY KEY ("id");
+
+
+-- ----------------------------
+-- Table structure for config_info
+-- ----------------------------
+DROP TABLE IF EXISTS "config_info";
+CREATE TABLE "config_info" (
+ "id" bigserial NOT NULL,
+ "data_id" varchar(255) NOT NULL,
+ "group_id" varchar(255) ,
+ "content" text NOT NULL,
+ "md5" varchar(32) ,
+ "gmt_create" timestamp(6) NOT NULL,
+ "gmt_modified" timestamp(6) NOT NULL,
+ "src_user" text ,
+ "src_ip" varchar(20) ,
+ "app_name" varchar(128) ,
+ "tenant_id" varchar(128) ,
+ "c_desc" varchar(256) ,
+ "c_use" varchar(64) ,
+ "effect" varchar(64) ,
+ "type" varchar(64) ,
+ "c_schema" text ,
+ "encrypted_data_key" text NOT NULL
+)
+;
+
+COMMENT ON COLUMN "config_info"."id" IS 'id';
+COMMENT ON COLUMN "config_info"."data_id" IS 'data_id';
+COMMENT ON COLUMN "config_info"."content" IS 'content';
+COMMENT ON COLUMN "config_info"."md5" IS 'md5';
+COMMENT ON COLUMN "config_info"."gmt_create" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "config_info"."gmt_modified" IS '淇敼鏃堕棿';
+COMMENT ON COLUMN "config_info"."src_user" IS 'source user';
+COMMENT ON COLUMN "config_info"."src_ip" IS 'source ip';
+COMMENT ON COLUMN "config_info"."tenant_id" IS '绉熸埛瀛楁';
+COMMENT ON COLUMN "config_info"."encrypted_data_key" IS '绉橀挜';
+COMMENT ON TABLE "config_info" IS 'config_info';
+
+
+-- ----------------------------
+-- Table structure for config_info_aggr
+-- ----------------------------
+DROP TABLE IF EXISTS "config_info_aggr";
+CREATE TABLE "config_info_aggr" (
+ "id" bigserial NOT NULL,
+ "data_id" varchar(255) NOT NULL,
+ "group_id" varchar(255) NOT NULL,
+ "datum_id" varchar(255) NOT NULL,
+ "content" text NOT NULL,
+ "gmt_modified" timestamp(6) NOT NULL,
+ "app_name" varchar(128) ,
+ "tenant_id" varchar(128)
+)
+;
+COMMENT ON COLUMN "config_info_aggr"."id" IS 'id';
+COMMENT ON COLUMN "config_info_aggr"."data_id" IS 'data_id';
+COMMENT ON COLUMN "config_info_aggr"."group_id" IS 'group_id';
+COMMENT ON COLUMN "config_info_aggr"."datum_id" IS 'datum_id';
+COMMENT ON COLUMN "config_info_aggr"."content" IS '鍐呭';
+COMMENT ON COLUMN "config_info_aggr"."gmt_modified" IS '淇敼鏃堕棿';
+COMMENT ON COLUMN "config_info_aggr"."tenant_id" IS '绉熸埛瀛楁';
+COMMENT ON TABLE "config_info_aggr" IS '澧炲姞绉熸埛瀛楁';
+
+-- ----------------------------
+-- Records of config_info_aggr
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for config_info_beta
+-- ----------------------------
+DROP TABLE IF EXISTS "config_info_beta";
+CREATE TABLE "config_info_beta" (
+ "id" bigserial NOT NULL,
+ "data_id" varchar(255) NOT NULL,
+ "group_id" varchar(128) NOT NULL,
+ "app_name" varchar(128) ,
+ "content" text NOT NULL,
+ "beta_ips" varchar(1024) ,
+ "md5" varchar(32) ,
+ "gmt_create" timestamp(6) NOT NULL,
+ "gmt_modified" timestamp(6) NOT NULL,
+ "src_user" text ,
+ "src_ip" varchar(20) ,
+ "tenant_id" varchar(128) ,
+ "encrypted_data_key" text NOT NULL
+)
+;
+COMMENT ON COLUMN "config_info_beta"."id" IS 'id';
+COMMENT ON COLUMN "config_info_beta"."data_id" IS 'data_id';
+COMMENT ON COLUMN "config_info_beta"."group_id" IS 'group_id';
+COMMENT ON COLUMN "config_info_beta"."app_name" IS 'app_name';
+COMMENT ON COLUMN "config_info_beta"."content" IS 'content';
+COMMENT ON COLUMN "config_info_beta"."beta_ips" IS 'betaIps';
+COMMENT ON COLUMN "config_info_beta"."md5" IS 'md5';
+COMMENT ON COLUMN "config_info_beta"."gmt_create" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "config_info_beta"."gmt_modified" IS '淇敼鏃堕棿';
+COMMENT ON COLUMN "config_info_beta"."src_user" IS 'source user';
+COMMENT ON COLUMN "config_info_beta"."src_ip" IS 'source ip';
+COMMENT ON COLUMN "config_info_beta"."tenant_id" IS '绉熸埛瀛楁';
+COMMENT ON COLUMN "config_info_beta"."encrypted_data_key" IS '绉橀挜';
+COMMENT ON TABLE "config_info_beta" IS 'config_info_beta';
+
+-- ----------------------------
+-- Records of config_info_beta
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for config_info_tag
+-- ----------------------------
+DROP TABLE IF EXISTS "config_info_tag";
+CREATE TABLE "config_info_tag" (
+ "id" bigserial NOT NULL,
+ "data_id" varchar(255) NOT NULL,
+ "group_id" varchar(128) NOT NULL,
+ "tenant_id" varchar(128) ,
+ "tag_id" varchar(128) NOT NULL,
+ "app_name" varchar(128) ,
+ "content" text NOT NULL,
+ "md5" varchar(32) ,
+ "gmt_create" timestamp(6) NOT NULL,
+ "gmt_modified" timestamp(6) NOT NULL,
+ "src_user" text ,
+ "src_ip" varchar(20)
+)
+;
+COMMENT ON COLUMN "config_info_tag"."id" IS 'id';
+COMMENT ON COLUMN "config_info_tag"."data_id" IS 'data_id';
+COMMENT ON COLUMN "config_info_tag"."group_id" IS 'group_id';
+COMMENT ON COLUMN "config_info_tag"."tenant_id" IS 'tenant_id';
+COMMENT ON COLUMN "config_info_tag"."tag_id" IS 'tag_id';
+COMMENT ON COLUMN "config_info_tag"."app_name" IS 'app_name';
+COMMENT ON COLUMN "config_info_tag"."content" IS 'content';
+COMMENT ON COLUMN "config_info_tag"."md5" IS 'md5';
+COMMENT ON COLUMN "config_info_tag"."gmt_create" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "config_info_tag"."gmt_modified" IS '淇敼鏃堕棿';
+COMMENT ON COLUMN "config_info_tag"."src_user" IS 'source user';
+COMMENT ON COLUMN "config_info_tag"."src_ip" IS 'source ip';
+COMMENT ON TABLE "config_info_tag" IS 'config_info_tag';
+
+-- ----------------------------
+-- Records of config_info_tag
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for config_tags_relation
+-- ----------------------------
+DROP TABLE IF EXISTS "config_tags_relation";
+CREATE TABLE "config_tags_relation" (
+ "id" bigserial NOT NULL,
+ "tag_name" varchar(128) NOT NULL,
+ "tag_type" varchar(64) ,
+ "data_id" varchar(255) NOT NULL,
+ "group_id" varchar(128) NOT NULL,
+ "tenant_id" varchar(128) ,
+ "nid" bigserial NOT NULL
+)
+;
+COMMENT ON COLUMN "config_tags_relation"."id" IS 'id';
+COMMENT ON COLUMN "config_tags_relation"."tag_name" IS 'tag_name';
+COMMENT ON COLUMN "config_tags_relation"."tag_type" IS 'tag_type';
+COMMENT ON COLUMN "config_tags_relation"."data_id" IS 'data_id';
+COMMENT ON COLUMN "config_tags_relation"."group_id" IS 'group_id';
+COMMENT ON COLUMN "config_tags_relation"."tenant_id" IS 'tenant_id';
+COMMENT ON TABLE "config_tags_relation" IS 'config_tag_relation';
+
+-- ----------------------------
+-- Records of config_tags_relation
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for group_capacity
+-- ----------------------------
+DROP TABLE IF EXISTS "group_capacity";
+CREATE TABLE "group_capacity" (
+ "id" bigserial NOT NULL,
+ "group_id" varchar(128) NOT NULL,
+ "quota" int4 NOT NULL,
+ "usage" int4 NOT NULL,
+ "max_size" int4 NOT NULL,
+ "max_aggr_count" int4 NOT NULL,
+ "max_aggr_size" int4 NOT NULL,
+ "max_history_count" int4 NOT NULL,
+ "gmt_create" timestamp(6) NOT NULL,
+ "gmt_modified" timestamp(6) NOT NULL
+)
+;
+COMMENT ON COLUMN "group_capacity"."id" IS '涓婚敭ID';
+COMMENT ON COLUMN "group_capacity"."group_id" IS 'Group ID锛岀┖瀛楃琛ㄧず鏁翠釜闆嗙兢';
+COMMENT ON COLUMN "group_capacity"."quota" IS '閰嶉锛�0琛ㄧず浣跨敤榛樿鍊�';
+COMMENT ON COLUMN "group_capacity"."usage" IS '浣跨敤閲�';
+COMMENT ON COLUMN "group_capacity"."max_size" IS '鍗曚釜閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�';
+COMMENT ON COLUMN "group_capacity"."max_aggr_count" IS '鑱氬悎瀛愰厤缃渶澶т釜鏁帮紝锛�0琛ㄧず浣跨敤榛樿鍊�';
+COMMENT ON COLUMN "group_capacity"."max_aggr_size" IS '鍗曚釜鑱氬悎鏁版嵁鐨勫瓙閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�';
+COMMENT ON COLUMN "group_capacity"."max_history_count" IS '鏈�澶у彉鏇村巻鍙叉暟閲�';
+COMMENT ON COLUMN "group_capacity"."gmt_create" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "group_capacity"."gmt_modified" IS '淇敼鏃堕棿';
+COMMENT ON TABLE "group_capacity" IS '闆嗙兢銆佸悇Group瀹归噺淇℃伅琛�';
+
+-- ----------------------------
+-- Records of group_capacity
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for his_config_info
+-- ----------------------------
+DROP TABLE IF EXISTS "his_config_info";
+CREATE TABLE "his_config_info" (
+ "id" int8 NOT NULL,
+ "nid" bigserial NOT NULL,
+ "data_id" varchar(255) NOT NULL,
+ "group_id" varchar(128) NOT NULL,
+ "app_name" varchar(128) ,
+ "content" text NOT NULL,
+ "md5" varchar(32) ,
+ "gmt_create" timestamp(6) NOT NULL DEFAULT '2010-05-05 00:00:00',
+ "gmt_modified" timestamp(6) NOT NULL,
+ "src_user" text ,
+ "src_ip" varchar(20) ,
+ "op_type" char(10) ,
+ "tenant_id" varchar(128) ,
+ "encrypted_data_key" text NOT NULL,
+ "publish_type" varchar(50) DEFAULT 'formal',
+ "gray_name" varchar(50),
+ "ext_info" text
+)
+;
+COMMENT ON COLUMN "his_config_info"."app_name" IS 'app_name';
+COMMENT ON COLUMN "his_config_info"."tenant_id" IS '绉熸埛瀛楁';
+COMMENT ON COLUMN "his_config_info"."encrypted_data_key" IS '绉橀挜';
+COMMENT ON TABLE "his_config_info" IS '澶氱鎴锋敼閫�';
+COMMENT ON COLUMN "his_config_info"."publish_type" IS 'publish type gray or formal';
+COMMENT ON COLUMN "his_config_info"."gray_name" IS 'gray name';
+COMMENT ON COLUMN "his_config_info"."ext_info" IS 'ext_info';
+
+
+-- ----------------------------
+-- Table structure for permissions
+-- ----------------------------
+DROP TABLE IF EXISTS "permissions";
+CREATE TABLE "permissions" (
+ "role" varchar(50) NOT NULL,
+ "resource" varchar(512) NOT NULL,
+ "action" varchar(8) NOT NULL
+)
+;
+
+-- ----------------------------
+-- Records of permissions
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for roles
+-- ----------------------------
+DROP TABLE IF EXISTS "roles";
+CREATE TABLE "roles" (
+ "username" varchar(50) NOT NULL,
+ "role" varchar(50) NOT NULL
+)
+;
+
+-- ----------------------------
+-- Records of roles
+-- ----------------------------
+BEGIN;
+INSERT INTO "roles" VALUES ('nacos', 'ROLE_ADMIN');
+COMMIT;
+
+-- ----------------------------
+-- Table structure for tenant_capacity
+-- ----------------------------
+DROP TABLE IF EXISTS "tenant_capacity";
+CREATE TABLE "tenant_capacity" (
+ "id" bigserial NOT NULL,
+ "tenant_id" varchar(128) NOT NULL,
+ "quota" int4 NOT NULL,
+ "usage" int4 NOT NULL,
+ "max_size" int4 NOT NULL,
+ "max_aggr_count" int4 NOT NULL,
+ "max_aggr_size" int4 NOT NULL,
+ "max_history_count" int4 NOT NULL,
+ "gmt_create" timestamp(6) NOT NULL,
+ "gmt_modified" timestamp(6) NOT NULL
+)
+;
+COMMENT ON COLUMN "tenant_capacity"."id" IS '涓婚敭ID';
+COMMENT ON COLUMN "tenant_capacity"."tenant_id" IS 'Tenant ID';
+COMMENT ON COLUMN "tenant_capacity"."quota" IS '閰嶉锛�0琛ㄧず浣跨敤榛樿鍊�';
+COMMENT ON COLUMN "tenant_capacity"."usage" IS '浣跨敤閲�';
+COMMENT ON COLUMN "tenant_capacity"."max_size" IS '鍗曚釜閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�';
+COMMENT ON COLUMN "tenant_capacity"."max_aggr_count" IS '鑱氬悎瀛愰厤缃渶澶т釜鏁�';
+COMMENT ON COLUMN "tenant_capacity"."max_aggr_size" IS '鍗曚釜鑱氬悎鏁版嵁鐨勫瓙閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�';
+COMMENT ON COLUMN "tenant_capacity"."max_history_count" IS '鏈�澶у彉鏇村巻鍙叉暟閲�';
+COMMENT ON COLUMN "tenant_capacity"."gmt_create" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "tenant_capacity"."gmt_modified" IS '淇敼鏃堕棿';
+COMMENT ON TABLE "tenant_capacity" IS '绉熸埛瀹归噺淇℃伅琛�';
+
+-- ----------------------------
+-- Records of tenant_capacity
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for tenant_info
+-- ----------------------------
+DROP TABLE IF EXISTS "tenant_info";
+CREATE TABLE "tenant_info" (
+ "id" bigserial NOT NULL,
+ "kp" varchar(128) NOT NULL,
+ "tenant_id" varchar(128) ,
+ "tenant_name" varchar(128) ,
+ "tenant_desc" varchar(256) ,
+ "create_source" varchar(32) ,
+ "gmt_create" int8 NOT NULL,
+ "gmt_modified" int8 NOT NULL
+)
+;
+COMMENT ON COLUMN "tenant_info"."id" IS 'id';
+COMMENT ON COLUMN "tenant_info"."kp" IS 'kp';
+COMMENT ON COLUMN "tenant_info"."tenant_id" IS 'tenant_id';
+COMMENT ON COLUMN "tenant_info"."tenant_name" IS 'tenant_name';
+COMMENT ON COLUMN "tenant_info"."tenant_desc" IS 'tenant_desc';
+COMMENT ON COLUMN "tenant_info"."create_source" IS 'create_source';
+COMMENT ON COLUMN "tenant_info"."gmt_create" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "tenant_info"."gmt_modified" IS '淇敼鏃堕棿';
+COMMENT ON TABLE "tenant_info" IS 'tenant_info';
+
+-- ----------------------------
+-- Records of tenant_info
+-- ----------------------------
+BEGIN;
+COMMIT;
+
+-- ----------------------------
+-- Table structure for users
+-- ----------------------------
+DROP TABLE IF EXISTS "users";
+CREATE TABLE "users" (
+ "username" varchar(50) NOT NULL,
+ "password" varchar(500) NOT NULL,
+ "enabled" boolean NOT NULL
+)
+;
+
+-- ----------------------------
+-- Records of users > nAcos_!9#_admIn
+-- ----------------------------
+BEGIN;
+-- INSERT INTO "users" VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', TRUE);
+INSERT INTO users (username, password, enabled) VALUES ('nacos', '$2a$10$LnJDlPeP.XbQnr6iabc65OI6kM4LLS/BRLwPHEtRSERErvnmlKkBu', TRUE);
+COMMIT;
+
+-- ----------------------------
+-- Indexes structure for table config_info
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_configinfo_datagrouptenant" ON "config_info" ("data_id","group_id","tenant_id");
+
+-- ----------------------------
+-- Primary Key structure for table config_info
+-- ----------------------------
+ALTER TABLE "config_info" ADD CONSTRAINT "config_info_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table config_info_aggr
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_configinfoaggr_datagrouptenantdatum" ON "config_info_aggr" USING btree ("data_id","group_id","tenant_id","datum_id");
+
+-- ----------------------------
+-- Primary Key structure for table config_info_aggr
+-- ----------------------------
+ALTER TABLE "config_info_aggr" ADD CONSTRAINT "config_info_aggr_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table config_info_beta
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_configinfobeta_datagrouptenant" ON "config_info_beta" USING btree ("data_id","group_id","tenant_id");
+
+-- ----------------------------
+-- Primary Key structure for table config_info_beta
+-- ----------------------------
+ALTER TABLE "config_info_beta" ADD CONSTRAINT "config_info_beta_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table config_info_tag
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_configinfotag_datagrouptenanttag" ON "config_info_tag" USING btree ("data_id","group_id","tenant_id","tag_id");
+
+-- ----------------------------
+-- Primary Key structure for table config_info_tag
+-- ----------------------------
+ALTER TABLE "config_info_tag" ADD CONSTRAINT "config_info_tag_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table config_tags_relation
+-- ----------------------------
+CREATE INDEX "idx_tenant_id" ON "config_tags_relation" USING btree (
+ "tenant_id"
+);
+CREATE UNIQUE INDEX "uk_configtagrelation_configidtag" ON "config_tags_relation" USING btree (
+ "id",
+ "tag_name",
+ "tag_type"
+);
+
+-- ----------------------------
+-- Primary Key structure for table config_tags_relation
+-- ----------------------------
+ALTER TABLE "config_tags_relation" ADD CONSTRAINT "config_tags_relation_pkey" PRIMARY KEY ("nid");
+
+-- ----------------------------
+-- Indexes structure for table group_capacity
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_group_id" ON "group_capacity" USING btree (
+ "group_id"
+);
+
+-- ----------------------------
+-- Primary Key structure for table group_capacity
+-- ----------------------------
+ALTER TABLE "group_capacity" ADD CONSTRAINT "group_capacity_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table his_config_info
+-- ----------------------------
+CREATE INDEX "idx_did" ON "his_config_info" USING btree (
+ "data_id"
+);
+CREATE INDEX "idx_gmt_create" ON "his_config_info" USING btree (
+ "gmt_create"
+);
+CREATE INDEX "idx_gmt_modified" ON "his_config_info" USING btree (
+ "gmt_modified"
+);
+
+-- ----------------------------
+-- Primary Key structure for table his_config_info
+-- ----------------------------
+ALTER TABLE "his_config_info" ADD CONSTRAINT "his_config_info_pkey" PRIMARY KEY ("nid");
+
+-- ----------------------------
+-- Indexes structure for table permissions
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_role_permission" ON "permissions" USING btree (
+ "role",
+ "resource",
+ "action"
+);
+
+-- ----------------------------
+-- Indexes structure for table roles
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_username_role" ON "roles" USING btree (
+ "username",
+ "role"
+);
+
+-- ----------------------------
+-- Indexes structure for table tenant_capacity
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_tenant_id" ON "tenant_capacity" USING btree (
+ "tenant_id"
+);
+
+-- ----------------------------
+-- Primary Key structure for table tenant_capacity
+-- ----------------------------
+ALTER TABLE "tenant_capacity" ADD CONSTRAINT "tenant_capacity_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table tenant_info
+-- ----------------------------
+CREATE UNIQUE INDEX "uk_tenant_info_kptenantid" ON "tenant_info" USING btree (
+ "kp",
+ "tenant_id"
+);
--
Gitblit v1.9.3