nacos2.2.1 oracle数据源版

/* Navicat Premium Data Transfer Source Server : 105_nacos Source Server Type : Oracle Source Server Version : 110200 Source Host : proxy.outmaneuver.cn:19522 Source Schema : NACOS Target Server Type : Oracle Target Server Version : 110200 File Encoding : 65001 Date: 31/05/2023 16:26:12 */ -- ---------------------------- -- Table structure for CONFIG_INFO -- ---------------------------- DROP TABLE CONFIG_INFO; CREATE TABLE CONFIG_INFO ( ID NUMBER(20) NOT NULL , DATA_ID NVARCHAR2(255) NOT NULL , GROUP_ID NVARCHAR2(128) , CONTENT NCLOB NOT NULL , MD5 NVARCHAR2(32) , GMT_CREATE DATE NOT NULL , GMT_MODIFIED DATE NOT NULL , SRC_USER NCLOB , SRC_IP NVARCHAR2(20) , APP_NAME NVARCHAR2(128) , TENANT_ID NVARCHAR2(128) , C_DESC NVARCHAR2(256) , C_USE NVARCHAR2(64) , EFFECT NVARCHAR2(64) , TYPE NVARCHAR2(64) , C_SCHEMA NCLOB , ENCRYPTED_DATA_KEY NCLOB ) TABLESPACE USERS LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; 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'; -- ---------------------------- -- Records of CONFIG_INFO -- ---------------------------- INSERT INTO CONFIG_INFO VALUES ('28', 'dssd', 'DEFAULT_GROUP', 'ds', '522748524ad010358705b6852b81be4c', TO_DATE('2023-05-31 15:52:55', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2023-05-31 15:52:55', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '127.0.0.1', NULL, 'dev', 'sds', NULL, NULL, 'text', NULL, NULL); INSERT INTO CONFIG_INFO VALUES ('35', 'dd', 'DEFAULT_GROUP', 'ssd', 'd4576b3b305e1df6f8ef4517ec2f9615', TO_DATE('2023-05-31 16:20:03', 'SYYYY-MM-DD HH24:MI:SS'), TO_DATE('2023-05-31 16:20:03', 'SYYYY-MM-DD HH24:MI:SS'), NULL, '127.0.0.1', NULL, NULL, 'ss', NULL, NULL, 'text', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for CONFIG_INFO_AGGR -- ---------------------------- DROP TABLE CONFIG_INFO_AGGR; CREATE TABLE CONFIG_INFO_AGGR ( ID NUMBER(20) NOT NULL , DATA_ID NVARCHAR2(255) NOT NULL , GROUP_ID NVARCHAR2(128) NOT NULL , DATUM_ID NVARCHAR2(255) NOT NULL , CONTENT NCLOB NOT NULL , GMT_MODIFIED DATE NOT NULL , APP_NAME NVARCHAR2(128) , TENANT_ID NVARCHAR2(128) ) TABLESPACE USERS LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; 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 '增加租户字段'; -- ---------------------------- -- Table structure for CONFIG_INFO_BETA -- ---------------------------- DROP TABLE CONFIG_INFO_BETA; CREATE TABLE CONFIG_INFO_BETA ( ID NUMBER(20) NOT NULL , DATA_ID NVARCHAR2(255) NOT NULL , GROUP_ID NVARCHAR2(128) NOT NULL , APP_NAME NVARCHAR2(128) , CONTENT NCLOB NOT NULL , BETA_IPS NCLOB , MD5 NVARCHAR2(32) , GMT_CREATE DATE NOT NULL , GMT_MODIFIED DATE NOT NULL , SRC_USER NCLOB , SRC_IP NVARCHAR2(20) , TENANT_ID NVARCHAR2(128) , ENCRYPTED_DATA_KEY NCLOB NOT NULL ) TABLESPACE USERS LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; 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'; -- ---------------------------- -- Table structure for CONFIG_INFO_TAG -- ---------------------------- DROP TABLE CONFIG_INFO_TAG; CREATE TABLE CONFIG_INFO_TAG ( ID NUMBER(20) NOT NULL , DATA_ID NVARCHAR2(255) NOT NULL , GROUP_ID NVARCHAR2(128) NOT NULL , TENANT_ID NVARCHAR2(128) , TAG_ID NVARCHAR2(128) NOT NULL , APP_NAME NVARCHAR2(128) , CONTENT NCLOB NOT NULL , MD5 NVARCHAR2(32) , GMT_CREATE DATE NOT NULL , GMT_MODIFIED DATE NOT NULL , SRC_USER NCLOB , SRC_IP NVARCHAR2(20) ) TABLESPACE USERS LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; 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'; -- ---------------------------- -- Table structure for CONFIG_TAGS_RELATION -- ---------------------------- DROP TABLE CONFIG_TAGS_RELATION; CREATE TABLE CONFIG_TAGS_RELATION ( ID NUMBER(20) NOT NULL , TAG_NAME NVARCHAR2(128) NOT NULL , TAG_TYPE NVARCHAR2(64) , DATA_ID NVARCHAR2(255) NOT NULL , GROUP_ID NVARCHAR2(128) NOT NULL , TENANT_ID NVARCHAR2(128) , NID NUMBER(20) NOT NULL ) TABLESPACE USERS LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; 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'; -- ---------------------------- -- Table structure for GROUP_CAPACITY -- ---------------------------- DROP TABLE GROUP_CAPACITY; CREATE TABLE GROUP_CAPACITY ( ID NUMBER(20)