Repository: sentry Updated Branches: refs/heads/sentry-ha-redesign 1b3535ea4 -> c8d0f24a2
http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql new file mode 100644 index 0000000..0189724 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-2.0.0.sql @@ -0,0 +1,286 @@ +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You 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. + + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +CREATE TABLE `SENTRY_DB_PRIVILEGE` ( + `DB_PRIVILEGE_ID` BIGINT NOT NULL, + `PRIVILEGE_SCOPE` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `SERVER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `DB_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `TABLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `COLUMN_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `URI` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `ACTION` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `CREATE_TIME` BIGINT NOT NULL, + `WITH_GRANT_OPTION` CHAR(1) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE `SENTRY_ROLE` ( + `ROLE_ID` BIGINT NOT NULL, + `ROLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `CREATE_TIME` BIGINT NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE `SENTRY_GROUP` ( + `GROUP_ID` BIGINT NOT NULL, + `GROUP_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `CREATE_TIME` BIGINT NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ( + `ROLE_ID` BIGINT NOT NULL, + `DB_PRIVILEGE_ID` BIGINT NOT NULL, + `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE `SENTRY_ROLE_GROUP_MAP` ( + `ROLE_ID` BIGINT NOT NULL, + `GROUP_ID` BIGINT NOT NULL, + `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `SENTRY_VERSION` ( + `VER_ID` BIGINT NOT NULL, + `SCHEMA_VERSION` VARCHAR(127) NOT NULL, + `VERSION_COMMENT` VARCHAR(255) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +ALTER TABLE `SENTRY_DB_PRIVILEGE` + ADD CONSTRAINT `SENTRY_DB_PRIV_PK` PRIMARY KEY (`DB_PRIVILEGE_ID`); + +ALTER TABLE `SENTRY_ROLE` + ADD CONSTRAINT `SENTRY_ROLE_PK` PRIMARY KEY (`ROLE_ID`); + +ALTER TABLE `SENTRY_GROUP` + ADD CONSTRAINT `SENTRY_GROUP_PK` PRIMARY KEY (`GROUP_ID`); + +ALTER TABLE `SENTRY_VERSION` + ADD CONSTRAINT `SENTRY_VERSION` PRIMARY KEY (`VER_ID`); + +ALTER TABLE `SENTRY_DB_PRIVILEGE` + ADD UNIQUE `SENTRY_DB_PRIV_PRIV_NAME_UNIQ` (`SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`URI`(250),`ACTION`,`WITH_GRANT_OPTION`); + +ALTER TABLE `SENTRY_DB_PRIVILEGE` + ADD INDEX `SENTRY_PRIV_SERV_IDX` (`SERVER_NAME`); + +ALTER TABLE `SENTRY_DB_PRIVILEGE` + ADD INDEX `SENTRY_PRIV_DB_IDX` (`DB_NAME`); + +ALTER TABLE `SENTRY_DB_PRIVILEGE` + ADD INDEX `SENTRY_PRIV_TBL_IDX` (`TABLE_NAME`); + +ALTER TABLE `SENTRY_DB_PRIVILEGE` + ADD INDEX `SENTRY_PRIV_COL_IDX` (`COLUMN_NAME`); + +ALTER TABLE `SENTRY_DB_PRIVILEGE` + ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`); + +ALTER TABLE `SENTRY_ROLE` + ADD CONSTRAINT `SENTRY_ROLE_ROLE_NAME_UNIQUE` UNIQUE (`ROLE_NAME`); + +ALTER TABLE `SENTRY_GROUP` + ADD CONSTRAINT `SENTRY_GRP_GRP_NAME_UNIQUE` UNIQUE (`GROUP_NAME`); + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` + ADD CONSTRAINT `SENTRY_ROLE_DB_PRIVILEGE_MAP_PK` PRIMARY KEY (`ROLE_ID`,`DB_PRIVILEGE_ID`); + +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` + ADD CONSTRAINT `SENTRY_ROLE_GROUP_MAP_PK` PRIMARY KEY (`ROLE_ID`,`GROUP_ID`); + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` + ADD CONSTRAINT `SEN_RLE_DB_PRV_MAP_SN_RLE_FK` + FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); + +ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` + ADD CONSTRAINT `SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK` + FOREIGN KEY (`DB_PRIVILEGE_ID`) REFERENCES `SENTRY_DB_PRIVILEGE`(`DB_PRIVILEGE_ID`); + +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` + ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_ROLE_FK` + FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); + +ALTER TABLE `SENTRY_ROLE_GROUP_MAP` + ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_GRP_FK` + FOREIGN KEY (`GROUP_ID`) REFERENCES `SENTRY_GROUP`(`GROUP_ID`); + +INSERT INTO SENTRY_VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '2.0.0', 'Sentry release version 2.0.0'); + +-- Generic Model +-- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] +CREATE TABLE `SENTRY_GM_PRIVILEGE` +( + `GM_PRIVILEGE_ID` BIGINT NOT NULL, + `ACTION` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `COMPONENT_NAME` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `CREATE_TIME` BIGINT NOT NULL, + `WITH_GRANT_OPTION` CHAR(1) NOT NULL, + `RESOURCE_NAME_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `RESOURCE_NAME_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `RESOURCE_NAME_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `RESOURCE_NAME_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `RESOURCE_TYPE_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `RESOURCE_TYPE_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `RESOURCE_TYPE_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `RESOURCE_TYPE_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', + `SCOPE` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `SERVICE_NAME` VARCHAR(64) BINARY CHARACTER SET utf8 COLLATE utf8_bin NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD CONSTRAINT `SENTRY_GM_PRIVILEGE_PK` PRIMARY KEY (`GM_PRIVILEGE_ID`); +-- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD UNIQUE `GM_PRIVILEGE_UNIQUE` (`COMPONENT_NAME`,`SERVICE_NAME`,`RESOURCE_NAME_0`,`RESOURCE_TYPE_0`,`RESOURCE_NAME_1`,`RESOURCE_TYPE_1`,`RESOURCE_NAME_2`,`RESOURCE_TYPE_2`,`RESOURCE_NAME_3`,`RESOURCE_TYPE_3`,`ACTION`,`WITH_GRANT_OPTION`); + +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD INDEX `SENTRY_GM_PRIV_COMP_IDX` (`COMPONENT_NAME`); + +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD INDEX `SENTRY_GM_PRIV_SERV_IDX` (`SERVICE_NAME`); + +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD INDEX `SENTRY_GM_PRIV_RES0_IDX` (`RESOURCE_NAME_0`,`RESOURCE_TYPE_0`); + +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD INDEX `SENTRY_GM_PRIV_RES1_IDX` (`RESOURCE_NAME_1`,`RESOURCE_TYPE_1`); + +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD INDEX `SENTRY_GM_PRIV_RES2_IDX` (`RESOURCE_NAME_2`,`RESOURCE_TYPE_2`); + +ALTER TABLE `SENTRY_GM_PRIVILEGE` + ADD INDEX `SENTRY_GM_PRIV_RES3_IDX` (`RESOURCE_NAME_3`,`RESOURCE_TYPE_3`); + +-- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship +CREATE TABLE `SENTRY_ROLE_GM_PRIVILEGE_MAP` +( + `ROLE_ID` BIGINT NOT NULL, + `GM_PRIVILEGE_ID` BIGINT NOT NULL +) ENGINE=INNODB DEFAULT CHARSET=utf8; + +ALTER TABLE `SENTRY_ROLE_GM_PRIVILEGE_MAP` + ADD CONSTRAINT `SENTRY_ROLE_GM_PRIVILEGE_MAP_PK` PRIMARY KEY (`ROLE_ID`,`GM_PRIVILEGE_ID`); + +-- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP +ALTER TABLE `SENTRY_ROLE_GM_PRIVILEGE_MAP` + ADD CONSTRAINT `SEN_RLE_GM_PRV_MAP_SN_RLE_FK` + FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); + +ALTER TABLE `SENTRY_ROLE_GM_PRIVILEGE_MAP` + ADD CONSTRAINT `SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK` + FOREIGN KEY (`GM_PRIVILEGE_ID`) REFERENCES `SENTRY_GM_PRIVILEGE`(`GM_PRIVILEGE_ID`); + +CREATE TABLE `SENTRY_USER` ( + `USER_ID` BIGINT NOT NULL, + `USER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `CREATE_TIME` BIGINT NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +ALTER TABLE `SENTRY_USER` + ADD CONSTRAINT `SENTRY_USER_PK` PRIMARY KEY (`USER_ID`); + +ALTER TABLE `SENTRY_USER` + ADD CONSTRAINT `SENTRY_USER_USER_NAME_UNIQUE` UNIQUE (`USER_NAME`); + +CREATE TABLE `SENTRY_ROLE_USER_MAP` ( + `ROLE_ID` BIGINT NOT NULL, + `USER_ID` BIGINT NOT NULL, + `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +ALTER TABLE `SENTRY_ROLE_USER_MAP` + ADD CONSTRAINT `SENTRY_ROLE_USER_MAP_PK` PRIMARY KEY (`ROLE_ID`,`USER_ID`); + +ALTER TABLE `SENTRY_ROLE_USER_MAP` + ADD CONSTRAINT `SEN_ROLE_USER_MAP_SEN_ROLE_FK` + FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); + +ALTER TABLE `SENTRY_ROLE_USER_MAP` + ADD CONSTRAINT `SEN_ROLE_USER_MAP_SEN_USER_FK` + FOREIGN KEY (`USER_ID`) REFERENCES `SENTRY_USER`(`USER_ID`); + +-- Table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] +CREATE TABLE `AUTHZ_PATHS_SNAPSHOT_ID` +( + `AUTHZ_SNAPSHOT_ID` BIGINT NOT NULL, + CONSTRAINT `AUTHZ_SNAPSHOT_ID_PK` PRIMARY KEY (`AUTHZ_SNAPSHOT_ID`) +)ENGINE=INNODB; + +-- Table `AUTHZ_PATHS_MAPPING` for classes [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] +CREATE TABLE `AUTHZ_PATHS_MAPPING` +( + `AUTHZ_OBJ_ID` BIGINT NOT NULL AUTO_INCREMENT, + `AUTHZ_OBJ_NAME` VARCHAR(384) BINARY NULL, + `CREATE_TIME_MS` BIGINT NOT NULL, + `AUTHZ_SNAPSHOT_ID` BIGINT NOT NULL, + CONSTRAINT `AUTHZ_PATHS_MAPPING_PK` PRIMARY KEY (`AUTHZ_OBJ_ID`) +) ENGINE=INNODB; + +-- Constraints for table `AUTHZ_PATHS_MAPPING` for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] +CREATE UNIQUE INDEX `AUTHZOBJNAME` ON `AUTHZ_PATHS_MAPPING` (`AUTHZ_OBJ_NAME`); + +-- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] +CREATE TABLE `AUTHZ_PATH` ( + `PATH_ID` BIGINT NOT NULL, + `PATH_NAME` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin, + `AUTHZ_OBJ_ID` BIGINT +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- Constraints for table `AUTHZ_PATH` +ALTER TABLE `AUTHZ_PATH` + ADD CONSTRAINT `AUTHZ_PATH_PK` PRIMARY KEY (`PATH_ID`); + +ALTER TABLE `AUTHZ_PATH` + ADD CONSTRAINT `AUTHZ_PATH_FK` + FOREIGN KEY (`AUTHZ_OBJ_ID`) REFERENCES `AUTHZ_PATHS_MAPPING`(`AUTHZ_OBJ_ID`); + +-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange] +CREATE TABLE `SENTRY_PERM_CHANGE` +( + `CHANGE_ID` BIGINT NOT NULL, + `CREATE_TIME_MS` BIGINT NOT NULL, + `PERM_CHANGE` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + CONSTRAINT `SENTRY_PERM_CHANGE_PK` PRIMARY KEY (`CHANGE_ID`) +) ENGINE=INNODB; + +-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange] +CREATE TABLE `SENTRY_PATH_CHANGE` +( + `CHANGE_ID` BIGINT NOT NULL, + `NOTIFICATION_ID` BIGINT NOT NULL, + `CREATE_TIME_MS` BIGINT NOT NULL, + `PATH_CHANGE` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + CONSTRAINT `SENTRY_PATH_CHANGE_PK` PRIMARY KEY (`CHANGE_ID`) +) ENGINE=INNODB; + +-- Constraints for table SENTRY_PATH_CHANGE for class [org.apache.sentry.provider.db.service.model.MSentryPathChange] +CREATE UNIQUE INDEX `NOTIFICATIONID` ON `SENTRY_PATH_CHANGE` (`NOTIFICATION_ID`); + +-- Table SENTRY_HMS_NOTIFICATION_ID for classes [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] +CREATE TABLE `SENTRY_HMS_NOTIFICATION_ID` +( + `NOTIFICATION_ID` BIGINT NOT NULL, + CONSTRAINT `SENTRY_NOTIFICATION_PK` PRIMARY KEY (`NOTIFICATION_ID`) +)ENGINE=INNODB; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql deleted file mode 100644 index b02294a..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql +++ /dev/null @@ -1,269 +0,0 @@ ---Licensed to the Apache Software Foundation (ASF) under one or more ---contributor license agreements. See the NOTICE file distributed with ---this work for additional information regarding copyright ownership. ---The ASF licenses this file to You 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 TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "PRIVILEGE_SCOPE" VARCHAR2(32) NOT NULL, - "SERVER_NAME" VARCHAR2(128) NOT NULL, - "DB_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "TABLE_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "COLUMN_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "URI" VARCHAR2(4000) DEFAULT '__NULL__', - "ACTION" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" NUMBER NOT NULL, - "ROLE_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" NUMBER NOT NULL, - "GROUP_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GROUP_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" NUMBER NOT NULL, - "SCHEMA_VERSION" VARCHAR(127) NOT NULL, - "VERSION_COMMENT" VARCHAR(255) NOT NULL -); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI","ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_SERV_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("SERVER_NAME"); - -CREATE INDEX "SENTRY_DB_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("DB_NAME"); - -CREATE INDEX "SENTRY_TBL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("TABLE_NAME"); - -CREATE INDEX "SENTRY_COL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_URI_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("URI"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") INITIALLY DEFERRED; - -INSERT INTO SENTRY_VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '1.8.0', 'Sentry release version 1.8.0'); - --- Generic Model --- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -CREATE TABLE "SENTRY_GM_PRIVILEGE" ( - "GM_PRIVILEGE_ID" NUMBER NOT NULL, - "COMPONENT_NAME" VARCHAR2(32) NOT NULL, - "SERVICE_NAME" VARCHAR2(64) NOT NULL, - "RESOURCE_NAME_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" VARCHAR2(64) DEFAULT '__NULL__', - "ACTION" VARCHAR2(32) NOT NULL, - "SCOPE" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -ALTER TABLE "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); --- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -ALTER TABLE "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", - "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GM_PRIVILEGE_ID" NUMBER NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") INITIALLY DEFERRED; - -CREATE TABLE "SENTRY_USER" ( - "USER_ID" NUMBER NOT NULL, - "USER_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -ALTER TABLE "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_PK" PRIMARY KEY ("USER_ID"); - -ALTER TABLE "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_USER_NAME_UNIQUE" UNIQUE ("USER_NAME"); - -CREATE TABLE "SENTRY_ROLE_USER_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "USER_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SENTRY_ROLE_USER_MAP_PK" PRIMARY KEY ("ROLE_ID","USER_ID"); - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_USER_FK" - FOREIGN KEY ("USER_ID") REFERENCES "SENTRY_USER"("USER_ID") INITIALLY DEFERRED; - --- Table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] -CREATE TABLE "AUTHZ_PATHS_SNAPSHOT_ID" -( - "AUTHZ_SNAPSHOT_ID" NUMBER NOT NULL -); - --- Constraints for table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] -ALTER TABLE "AUTHZ_PATHS_SNAPSHOT_ID" ADD CONSTRAINT "AUTHZ_SNAPSHOT_ID_PK" PRIMARY KEY ("AUTHZ_SNAPSHOT_ID"); - --- Table AUTHZ_PATHS_MAPPING for classes [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE TABLE AUTHZ_PATHS_MAPPING -( - AUTHZ_OBJ_ID NUMBER NOT NULL, - AUTHZ_OBJ_NAME VARCHAR2(384) NULL, - CREATE_TIME_MS NUMBER NOT NULL, - "AUTHZ_SNAPSHOT_ID" NUMBER NOT NULL -); - -ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); - --- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX AUTHZOBJNAME ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME); - --- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] -CREATE TABLE AUTHZ_PATH - ( - PATH_ID NUMBER NOT NULL, - PATH_NAME VARCHAR(4000), - AUTHZ_OBJ_ID NUMBER -); - --- Constraints for table `AUTHZ_PATH` -ALTER TABLE AUTHZ_PATH - ADD CONSTRAINT AUTHZ_PATH_PK PRIMARY KEY (PATH_ID); - -ALTER TABLE AUTHZ_PATH - ADD CONSTRAINT AUTHZ_PATH_FK - FOREIGN KEY (AUTHZ_OBJ_ID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID); - - --- Table "SENTRY_PERM_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange] -CREATE TABLE "SENTRY_PERM_CHANGE" -( - "CHANGE_ID" NUMBER NOT NULL, - "CREATE_TIME_MS" NUMBER NOT NULL, - "PERM_CHANGE" VARCHAR2(4000) NOT NULL -); - -ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID"); - --- Table "SENTRY_PATH_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange] -CREATE TABLE "SENTRY_PATH_CHANGE" -( - "CHANGE_ID" NUMBER NOT NULL, - "NOTIFICATION_ID" NUMBER NOT NULL, - "CREATE_TIME_MS" NUMBER NOT NULL, - "PATH_CHANGE" VARCHAR2(4000) NOT NULL -); - --- Constraints for table SENTRY_PATH_CHANGE for class [org.apache.sentry.provider.db.service.model.MSentryPathChange] -CREATE UNIQUE INDEX "NOTIFICATIONID" ON "SENTRY_PATH_CHANGE" ("NOTIFICATION_ID"); -ALTER TABLE "SENTRY_PATH_CHANGE" ADD CONSTRAINT SENTRY_PATH_CHANGE_PK PRIMARY KEY ("CHANGE_ID"); - --- Table SENTRY_HMS_NOTIFICATION_ID for classes [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] -CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" -( - "NOTIFICATION_ID" NUMBER NOT NULL -); - --- Constraints for table SENTRY_HMS_NOTIFICATION_ID for class [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] -ALTER TABLE "SENTRY_HMS_NOTIFICATION_ID" ADD CONSTRAINT "NOTIFICATION_PRIVILEGE_PK" PRIMARY KEY ("NOTIFICATION_ID"); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql new file mode 100644 index 0000000..ecb76fc --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-2.0.0.sql @@ -0,0 +1,269 @@ +--Licensed to the Apache Software Foundation (ASF) under one or more +--contributor license agreements. See the NOTICE file distributed with +--this work for additional information regarding copyright ownership. +--The ASF licenses this file to You 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 TABLE "SENTRY_DB_PRIVILEGE" ( + "DB_PRIVILEGE_ID" NUMBER NOT NULL, + "PRIVILEGE_SCOPE" VARCHAR2(32) NOT NULL, + "SERVER_NAME" VARCHAR2(128) NOT NULL, + "DB_NAME" VARCHAR2(128) DEFAULT '__NULL__', + "TABLE_NAME" VARCHAR2(128) DEFAULT '__NULL__', + "COLUMN_NAME" VARCHAR2(128) DEFAULT '__NULL__', + "URI" VARCHAR2(4000) DEFAULT '__NULL__', + "ACTION" VARCHAR2(128) NOT NULL, + "CREATE_TIME" NUMBER NOT NULL, + "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL +); + +CREATE TABLE "SENTRY_ROLE" ( + "ROLE_ID" NUMBER NOT NULL, + "ROLE_NAME" VARCHAR2(128) NOT NULL, + "CREATE_TIME" NUMBER NOT NULL +); + +CREATE TABLE "SENTRY_GROUP" ( + "GROUP_ID" NUMBER NOT NULL, + "GROUP_NAME" VARCHAR2(128) NOT NULL, + "CREATE_TIME" NUMBER NOT NULL +); + +CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( + "ROLE_ID" NUMBER NOT NULL, + "DB_PRIVILEGE_ID" NUMBER NOT NULL, + "GRANTOR_PRINCIPAL" VARCHAR2(128) +); + +CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( + "ROLE_ID" NUMBER NOT NULL, + "GROUP_ID" NUMBER NOT NULL, + "GRANTOR_PRINCIPAL" VARCHAR2(128) +); + +CREATE TABLE "SENTRY_VERSION" ( + "VER_ID" NUMBER NOT NULL, + "SCHEMA_VERSION" VARCHAR(127) NOT NULL, + "VERSION_COMMENT" VARCHAR(255) NOT NULL +); + +ALTER TABLE "SENTRY_DB_PRIVILEGE" + ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); + +ALTER TABLE "SENTRY_ROLE" + ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); + +ALTER TABLE "SENTRY_GROUP" + ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); + +ALTER TABLE "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); + +ALTER TABLE "SENTRY_DB_PRIVILEGE" + ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI","ACTION","WITH_GRANT_OPTION"); + +CREATE INDEX "SENTRY_SERV_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("SERVER_NAME"); + +CREATE INDEX "SENTRY_DB_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("DB_NAME"); + +CREATE INDEX "SENTRY_TBL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("TABLE_NAME"); + +CREATE INDEX "SENTRY_COL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("COLUMN_NAME"); + +CREATE INDEX "SENTRY_URI_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("URI"); + +ALTER TABLE "SENTRY_ROLE" + ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); + +ALTER TABLE "SENTRY_GROUP" + ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); + +ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RLE_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); + +ALTER TABLE "SENTRY_ROLE_GROUP_MAP" + ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); + +ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; + +ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" + FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") INITIALLY DEFERRED; + +ALTER TABLE "SENTRY_ROLE_GROUP_MAP" + ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; + +ALTER TABLE "SENTRY_ROLE_GROUP_MAP" + ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" + FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") INITIALLY DEFERRED; + +INSERT INTO SENTRY_VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '2.0.0', 'Sentry release version 2.0.0'); + +-- Generic Model +-- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] +CREATE TABLE "SENTRY_GM_PRIVILEGE" ( + "GM_PRIVILEGE_ID" NUMBER NOT NULL, + "COMPONENT_NAME" VARCHAR2(32) NOT NULL, + "SERVICE_NAME" VARCHAR2(64) NOT NULL, + "RESOURCE_NAME_0" VARCHAR2(64) DEFAULT '__NULL__', + "RESOURCE_NAME_1" VARCHAR2(64) DEFAULT '__NULL__', + "RESOURCE_NAME_2" VARCHAR2(64) DEFAULT '__NULL__', + "RESOURCE_NAME_3" VARCHAR2(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_0" VARCHAR2(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_1" VARCHAR2(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_2" VARCHAR2(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_3" VARCHAR2(64) DEFAULT '__NULL__', + "ACTION" VARCHAR2(32) NOT NULL, + "SCOPE" VARCHAR2(128) NOT NULL, + "CREATE_TIME" NUMBER NOT NULL, + "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL +); + +ALTER TABLE "SENTRY_GM_PRIVILEGE" + ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); +-- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] +ALTER TABLE "SENTRY_GM_PRIVILEGE" + ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", + "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); + +CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" ("COMPONENT_NAME"); + +CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" ("SERVICE_NAME"); + +CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); + +CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); + +CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); + +CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); + +-- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship +CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( + "ROLE_ID" NUMBER NOT NULL, + "GM_PRIVILEGE_ID" NUMBER NOT NULL +); + +ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RLE_GM_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); + +-- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP +ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; + +ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" + FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") INITIALLY DEFERRED; + +CREATE TABLE "SENTRY_USER" ( + "USER_ID" NUMBER NOT NULL, + "USER_NAME" VARCHAR2(128) NOT NULL, + "CREATE_TIME" NUMBER NOT NULL +); + +ALTER TABLE "SENTRY_USER" + ADD CONSTRAINT "SENTRY_USER_PK" PRIMARY KEY ("USER_ID"); + +ALTER TABLE "SENTRY_USER" + ADD CONSTRAINT "SENTRY_USER_USER_NAME_UNIQUE" UNIQUE ("USER_NAME"); + +CREATE TABLE "SENTRY_ROLE_USER_MAP" ( + "ROLE_ID" NUMBER NOT NULL, + "USER_ID" NUMBER NOT NULL, + "GRANTOR_PRINCIPAL" VARCHAR2(128) +); + +ALTER TABLE "SENTRY_ROLE_USER_MAP" + ADD CONSTRAINT "SENTRY_ROLE_USER_MAP_PK" PRIMARY KEY ("ROLE_ID","USER_ID"); + +ALTER TABLE "SENTRY_ROLE_USER_MAP" + ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_ROLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; + +ALTER TABLE "SENTRY_ROLE_USER_MAP" + ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_USER_FK" + FOREIGN KEY ("USER_ID") REFERENCES "SENTRY_USER"("USER_ID") INITIALLY DEFERRED; + +-- Table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] +CREATE TABLE "AUTHZ_PATHS_SNAPSHOT_ID" +( + "AUTHZ_SNAPSHOT_ID" NUMBER NOT NULL +); + +-- Constraints for table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] +ALTER TABLE "AUTHZ_PATHS_SNAPSHOT_ID" ADD CONSTRAINT "AUTHZ_SNAPSHOT_ID_PK" PRIMARY KEY ("AUTHZ_SNAPSHOT_ID"); + +-- Table AUTHZ_PATHS_MAPPING for classes [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] +CREATE TABLE AUTHZ_PATHS_MAPPING +( + AUTHZ_OBJ_ID NUMBER NOT NULL, + AUTHZ_OBJ_NAME VARCHAR2(384) NULL, + CREATE_TIME_MS NUMBER NOT NULL, + "AUTHZ_SNAPSHOT_ID" NUMBER NOT NULL +); + +ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] +CREATE UNIQUE INDEX AUTHZOBJNAME ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME); + +-- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] +CREATE TABLE AUTHZ_PATH + ( + PATH_ID NUMBER NOT NULL, + PATH_NAME VARCHAR(4000), + AUTHZ_OBJ_ID NUMBER +); + +-- Constraints for table `AUTHZ_PATH` +ALTER TABLE AUTHZ_PATH + ADD CONSTRAINT AUTHZ_PATH_PK PRIMARY KEY (PATH_ID); + +ALTER TABLE AUTHZ_PATH + ADD CONSTRAINT AUTHZ_PATH_FK + FOREIGN KEY (AUTHZ_OBJ_ID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID); + + +-- Table "SENTRY_PERM_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange] +CREATE TABLE "SENTRY_PERM_CHANGE" +( + "CHANGE_ID" NUMBER NOT NULL, + "CREATE_TIME_MS" NUMBER NOT NULL, + "PERM_CHANGE" VARCHAR2(4000) NOT NULL +); + +ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID"); + +-- Table "SENTRY_PATH_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange] +CREATE TABLE "SENTRY_PATH_CHANGE" +( + "CHANGE_ID" NUMBER NOT NULL, + "NOTIFICATION_ID" NUMBER NOT NULL, + "CREATE_TIME_MS" NUMBER NOT NULL, + "PATH_CHANGE" VARCHAR2(4000) NOT NULL +); + +-- Constraints for table SENTRY_PATH_CHANGE for class [org.apache.sentry.provider.db.service.model.MSentryPathChange] +CREATE UNIQUE INDEX "NOTIFICATIONID" ON "SENTRY_PATH_CHANGE" ("NOTIFICATION_ID"); +ALTER TABLE "SENTRY_PATH_CHANGE" ADD CONSTRAINT SENTRY_PATH_CHANGE_PK PRIMARY KEY ("CHANGE_ID"); + +-- Table SENTRY_HMS_NOTIFICATION_ID for classes [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] +CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" +( + "NOTIFICATION_ID" NUMBER NOT NULL +); + +-- Constraints for table SENTRY_HMS_NOTIFICATION_ID for class [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] +ALTER TABLE "SENTRY_HMS_NOTIFICATION_ID" ADD CONSTRAINT "NOTIFICATION_PRIVILEGE_PK" PRIMARY KEY ("NOTIFICATION_ID"); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.8.0.sql deleted file mode 100644 index f325eb6..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.8.0.sql +++ /dev/null @@ -1,276 +0,0 @@ ---Licensed to the Apache Software Foundation (ASF) under one or more ---contributor license agreements. See the NOTICE file distributed with ---this work for additional information regarding copyright ownership. ---The ASF licenses this file to You 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. - -START TRANSACTION; - -SET statement_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = off; -SET check_function_bodies = false; -SET client_min_messages = warning; -SET escape_string_warning = off; -SET search_path = public, pg_catalog; -SET default_tablespace = ''; -SET default_with_oids = false; - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "PRIVILEGE_SCOPE" character varying(32) NOT NULL, - "SERVER_NAME" character varying(128) NOT NULL, - "DB_NAME" character varying(128) DEFAULT '__NULL__', - "TABLE_NAME" character varying(128) DEFAULT '__NULL__', - "COLUMN_NAME" character varying(128) DEFAULT '__NULL__', - "URI" character varying(4000) DEFAULT '__NULL__', - "ACTION" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" BIGINT NOT NULL, - "ROLE_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" BIGINT NOT NULL, - "GROUP_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GROUP_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" bigint, - "SCHEMA_VERSION" character varying(127) NOT NULL, - "VERSION_COMMENT" character varying(255) NOT NULL -); - - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI", "ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_PRIV_SERV_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("SERVER_NAME"); - -CREATE INDEX "SENTRY_PRIV_DB_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("DB_NAME"); - -CREATE INDEX "SENTRY_PRIV_TBL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("TABLE_NAME"); - -CREATE INDEX "SENTRY_PRIV_COL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_PRIV_URI_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("URI"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_DB_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") DEFERRABLE; - -INSERT INTO "SENTRY_VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '1.8.0', 'Sentry release version 1.8.0'); - --- Generic Model --- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -CREATE TABLE "SENTRY_GM_PRIVILEGE" ( - "GM_PRIVILEGE_ID" BIGINT NOT NULL, - "COMPONENT_NAME" character varying(32) NOT NULL, - "SERVICE_NAME" character varying(64) NOT NULL, - "RESOURCE_NAME_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" character varying(64) DEFAULT '__NULL__', - "ACTION" character varying(32) NOT NULL, - "SCOPE" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); --- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", - "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GM_PRIVILEGE_ID" BIGINT NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GM_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") DEFERRABLE; - -CREATE TABLE "SENTRY_USER" ( - "USER_ID" BIGINT NOT NULL, - "USER_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -ALTER TABLE ONLY "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_PK" PRIMARY KEY ("USER_ID"); - -ALTER TABLE ONLY "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_USER_NAME_UNIQUE" UNIQUE ("USER_NAME"); - -CREATE TABLE "SENTRY_ROLE_USER_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "USER_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SENTRY_ROLE_USER_MAP_PK" PRIMARY KEY ("ROLE_ID","USER_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_USER_FK" - FOREIGN KEY ("USER_ID") REFERENCES "SENTRY_USER"("USER_ID") DEFERRABLE; - --- Table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] -CREATE TABLE "AUTHZ_PATHS_SNAPSHOT_ID" -( - "AUTHZ_SNAPSHOT_ID" bigint NOT NULL, - CONSTRAINT "AUTHZ_SNAPSHOT_ID_PK" PRIMARY KEY ("AUTHZ_SNAPSHOT_ID") -); - --- Table "AUTHZ_PATHS_MAPPING" for classes [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE TABLE "AUTHZ_PATHS_MAPPING" -( - "AUTHZ_OBJ_ID" SERIAL, - "AUTHZ_OBJ_NAME" varchar(384) NULL, - "CREATE_TIME_MS" int8 NOT NULL, - "AUTHZ_SNAPSHOT_ID" bigint NOT NULL, - CONSTRAINT "AUTHZ_PATHS_MAPPING_PK" PRIMARY KEY ("AUTHZ_OBJ_ID") -); - --- Constraints for table "AUTHZ_PATHS_MAPPING" for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] -CREATE UNIQUE INDEX "AUTHZOBJNAME" ON "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_NAME"); - --- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] -CREATE TABLE "AUTHZ_PATH" - ( - "PATH_ID" BIGINT NOT NULL, - "PATH_NAME" varchar(4000), - "AUTHZ_OBJ_ID" BIGINT -); - --- Constraints for table `AUTHZ_PATH` -ALTER TABLE "AUTHZ_PATH" - ADD CONSTRAINT "AUTHZ_PATH_PK" PRIMARY KEY ("PATH_ID"); - -ALTER TABLE "AUTHZ_PATH" - ADD CONSTRAINT "AUTHZ_PATH_FK" - FOREIGN KEY ("AUTHZ_OBJ_ID") REFERENCES "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_ID") DEFERRABLE; - --- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange] -CREATE TABLE "SENTRY_PERM_CHANGE" -( - "CHANGE_ID" bigint NOT NULL, - "CREATE_TIME_MS" bigint NOT NULL, - "PERM_CHANGE" VARCHAR(4000) NOT NULL, - CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID") -); - --- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange] -CREATE TABLE "SENTRY_PATH_CHANGE" -( - "CHANGE_ID" bigint NOT NULL, - "NOTIFICATION_ID" bigint NOT NULL, - "CREATE_TIME_MS" bigint NOT NULL, - "PATH_CHANGE" VARCHAR(4000) NOT NULL, - CONSTRAINT "SENTRY_PATH_CHANGE_PK" PRIMARY KEY ("CHANGE_ID") -); - --- Constraints for table SENTRY_PATH_CHANGE for class [org.apache.sentry.provider.db.service.model.MSentryPathChange] -CREATE UNIQUE INDEX "NOTIFICATIONID" ON "SENTRY_PATH_CHANGE" ("NOTIFICATION_ID"); - --- Table SENTRY_HMS_NOTIFICATION_ID for classes [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] -CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" -( - "NOTIFICATION_ID" bigint NOT NULL, - CONSTRAINT "NOTIFICATION_PRIVILEGE_PK" PRIMARY KEY ("NOTIFICATION_ID") -); - -COMMIT; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql new file mode 100644 index 0000000..3e5d554 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-2.0.0.sql @@ -0,0 +1,276 @@ +--Licensed to the Apache Software Foundation (ASF) under one or more +--contributor license agreements. See the NOTICE file distributed with +--this work for additional information regarding copyright ownership. +--The ASF licenses this file to You 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. + +START TRANSACTION; + +SET statement_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = off; +SET check_function_bodies = false; +SET client_min_messages = warning; +SET escape_string_warning = off; +SET search_path = public, pg_catalog; +SET default_tablespace = ''; +SET default_with_oids = false; + +CREATE TABLE "SENTRY_DB_PRIVILEGE" ( + "DB_PRIVILEGE_ID" BIGINT NOT NULL, + "PRIVILEGE_SCOPE" character varying(32) NOT NULL, + "SERVER_NAME" character varying(128) NOT NULL, + "DB_NAME" character varying(128) DEFAULT '__NULL__', + "TABLE_NAME" character varying(128) DEFAULT '__NULL__', + "COLUMN_NAME" character varying(128) DEFAULT '__NULL__', + "URI" character varying(4000) DEFAULT '__NULL__', + "ACTION" character varying(128) NOT NULL, + "CREATE_TIME" BIGINT NOT NULL, + "WITH_GRANT_OPTION" CHAR(1) NOT NULL +); + +CREATE TABLE "SENTRY_ROLE" ( + "ROLE_ID" BIGINT NOT NULL, + "ROLE_NAME" character varying(128) NOT NULL, + "CREATE_TIME" BIGINT NOT NULL +); + +CREATE TABLE "SENTRY_GROUP" ( + "GROUP_ID" BIGINT NOT NULL, + "GROUP_NAME" character varying(128) NOT NULL, + "CREATE_TIME" BIGINT NOT NULL +); + +CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( + "ROLE_ID" BIGINT NOT NULL, + "DB_PRIVILEGE_ID" BIGINT NOT NULL, + "GRANTOR_PRINCIPAL" character varying(128) +); + +CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( + "ROLE_ID" BIGINT NOT NULL, + "GROUP_ID" BIGINT NOT NULL, + "GRANTOR_PRINCIPAL" character varying(128) +); + +CREATE TABLE "SENTRY_VERSION" ( + "VER_ID" bigint, + "SCHEMA_VERSION" character varying(127) NOT NULL, + "VERSION_COMMENT" character varying(255) NOT NULL +); + + +ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" + ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); + +ALTER TABLE ONLY "SENTRY_ROLE" + ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); + +ALTER TABLE ONLY "SENTRY_GROUP" + ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); + +ALTER TABLE ONLY "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); + +ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" + ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI", "ACTION","WITH_GRANT_OPTION"); + +CREATE INDEX "SENTRY_PRIV_SERV_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("SERVER_NAME"); + +CREATE INDEX "SENTRY_PRIV_DB_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("DB_NAME"); + +CREATE INDEX "SENTRY_PRIV_TBL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("TABLE_NAME"); + +CREATE INDEX "SENTRY_PRIV_COL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("COLUMN_NAME"); + +CREATE INDEX "SENTRY_PRIV_URI_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("URI"); + +ALTER TABLE ONLY "SENTRY_ROLE" + ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); + +ALTER TABLE ONLY "SENTRY_GROUP" + ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); + +ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" + ADD CONSTRAINT "SENTRY_ROLE_DB_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); + +ALTER TABLE "SENTRY_ROLE_GROUP_MAP" + ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); + +ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; + +ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" + FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") DEFERRABLE; + +ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" + ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; + +ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" + ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" + FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") DEFERRABLE; + +INSERT INTO "SENTRY_VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '2.0.0', 'Sentry release version 2.0.0'); + +-- Generic Model +-- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] +CREATE TABLE "SENTRY_GM_PRIVILEGE" ( + "GM_PRIVILEGE_ID" BIGINT NOT NULL, + "COMPONENT_NAME" character varying(32) NOT NULL, + "SERVICE_NAME" character varying(64) NOT NULL, + "RESOURCE_NAME_0" character varying(64) DEFAULT '__NULL__', + "RESOURCE_NAME_1" character varying(64) DEFAULT '__NULL__', + "RESOURCE_NAME_2" character varying(64) DEFAULT '__NULL__', + "RESOURCE_NAME_3" character varying(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_0" character varying(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_1" character varying(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_2" character varying(64) DEFAULT '__NULL__', + "RESOURCE_TYPE_3" character varying(64) DEFAULT '__NULL__', + "ACTION" character varying(32) NOT NULL, + "SCOPE" character varying(128) NOT NULL, + "CREATE_TIME" BIGINT NOT NULL, + "WITH_GRANT_OPTION" CHAR(1) NOT NULL +); +ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" + ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); +-- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] +ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" + ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", + "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); + +CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("COMPONENT_NAME"); + +CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("SERVICE_NAME"); + +CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); + +CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); + +CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); + +CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); + +-- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship +CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( + "ROLE_ID" BIGINT NOT NULL, + "GM_PRIVILEGE_ID" BIGINT NOT NULL +); + +ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" + ADD CONSTRAINT "SENTRY_ROLE_GM_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); + +-- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP +ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; + +ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" + ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" + FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") DEFERRABLE; + +CREATE TABLE "SENTRY_USER" ( + "USER_ID" BIGINT NOT NULL, + "USER_NAME" character varying(128) NOT NULL, + "CREATE_TIME" BIGINT NOT NULL +); + +ALTER TABLE ONLY "SENTRY_USER" + ADD CONSTRAINT "SENTRY_USER_PK" PRIMARY KEY ("USER_ID"); + +ALTER TABLE ONLY "SENTRY_USER" + ADD CONSTRAINT "SENTRY_USER_USER_NAME_UNIQUE" UNIQUE ("USER_NAME"); + +CREATE TABLE "SENTRY_ROLE_USER_MAP" ( + "ROLE_ID" BIGINT NOT NULL, + "USER_ID" BIGINT NOT NULL, + "GRANTOR_PRINCIPAL" character varying(128) +); + +ALTER TABLE "SENTRY_ROLE_USER_MAP" + ADD CONSTRAINT "SENTRY_ROLE_USER_MAP_PK" PRIMARY KEY ("ROLE_ID","USER_ID"); + +ALTER TABLE ONLY "SENTRY_ROLE_USER_MAP" + ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_ROLE_FK" + FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; + +ALTER TABLE ONLY "SENTRY_ROLE_USER_MAP" + ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_USER_FK" + FOREIGN KEY ("USER_ID") REFERENCES "SENTRY_USER"("USER_ID") DEFERRABLE; + +-- Table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] +CREATE TABLE "AUTHZ_PATHS_SNAPSHOT_ID" +( + "AUTHZ_SNAPSHOT_ID" bigint NOT NULL, + CONSTRAINT "AUTHZ_SNAPSHOT_ID_PK" PRIMARY KEY ("AUTHZ_SNAPSHOT_ID") +); + +-- Table "AUTHZ_PATHS_MAPPING" for classes [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] +CREATE TABLE "AUTHZ_PATHS_MAPPING" +( + "AUTHZ_OBJ_ID" SERIAL, + "AUTHZ_OBJ_NAME" varchar(384) NULL, + "CREATE_TIME_MS" int8 NOT NULL, + "AUTHZ_SNAPSHOT_ID" bigint NOT NULL, + CONSTRAINT "AUTHZ_PATHS_MAPPING_PK" PRIMARY KEY ("AUTHZ_OBJ_ID") +); + +-- Constraints for table "AUTHZ_PATHS_MAPPING" for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] +CREATE UNIQUE INDEX "AUTHZOBJNAME" ON "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_NAME"); + +-- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] +CREATE TABLE "AUTHZ_PATH" + ( + "PATH_ID" BIGINT NOT NULL, + "PATH_NAME" varchar(4000), + "AUTHZ_OBJ_ID" BIGINT +); + +-- Constraints for table `AUTHZ_PATH` +ALTER TABLE "AUTHZ_PATH" + ADD CONSTRAINT "AUTHZ_PATH_PK" PRIMARY KEY ("PATH_ID"); + +ALTER TABLE "AUTHZ_PATH" + ADD CONSTRAINT "AUTHZ_PATH_FK" + FOREIGN KEY ("AUTHZ_OBJ_ID") REFERENCES "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_ID") DEFERRABLE; + +-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange] +CREATE TABLE "SENTRY_PERM_CHANGE" +( + "CHANGE_ID" bigint NOT NULL, + "CREATE_TIME_MS" bigint NOT NULL, + "PERM_CHANGE" VARCHAR(4000) NOT NULL, + CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID") +); + +-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange] +CREATE TABLE "SENTRY_PATH_CHANGE" +( + "CHANGE_ID" bigint NOT NULL, + "NOTIFICATION_ID" bigint NOT NULL, + "CREATE_TIME_MS" bigint NOT NULL, + "PATH_CHANGE" VARCHAR(4000) NOT NULL, + CONSTRAINT "SENTRY_PATH_CHANGE_PK" PRIMARY KEY ("CHANGE_ID") +); + +-- Constraints for table SENTRY_PATH_CHANGE for class [org.apache.sentry.provider.db.service.model.MSentryPathChange] +CREATE UNIQUE INDEX "NOTIFICATIONID" ON "SENTRY_PATH_CHANGE" ("NOTIFICATION_ID"); + +-- Table SENTRY_HMS_NOTIFICATION_ID for classes [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] +CREATE TABLE "SENTRY_HMS_NOTIFICATION_ID" +( + "NOTIFICATION_ID" bigint NOT NULL, + CONSTRAINT "NOTIFICATION_PRIVILEGE_PK" PRIMARY KEY ("NOTIFICATION_ID") +); + +COMMIT; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-1.8.0.sql deleted file mode 100644 index 8cb8eeb..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,103 +0,0 @@ --- SENTRY-711 -CREATE TABLE SENTRY_USER -( - USER_ID BIGINT NOT NULL generated always as identity (start with 1), - CREATE_TIME BIGINT NOT NULL, - USER_NAME VARCHAR(128) -); - -ALTER TABLE SENTRY_USER ADD CONSTRAINT SENTRY_USER_PK PRIMARY KEY (USER_ID); - -CREATE UNIQUE INDEX SENTRYUSERNAME ON SENTRY_USER (USER_NAME); - -CREATE TABLE SENTRY_ROLE_USER_MAP -( - USER_ID BIGINT NOT NULL, - ROLE_ID BIGINT NOT NULL, - GRANTOR_PRINCIPAL VARCHAR(128) -); - -ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_PK PRIMARY KEY (USER_ID,ROLE_ID); - -CREATE INDEX SENTRY_ROLE_USER_MAP_N49 ON SENTRY_ROLE_USER_MAP (USER_ID); - -CREATE INDEX SENTRY_ROLE_USER_MAP_N50 ON SENTRY_ROLE_USER_MAP (ROLE_ID); - -ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK2 FOREIGN KEY (ROLE_ID) REFERENCES SENTRY_ROLE (ROLE_ID) ; - -ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN KEY (USER_ID) REFERENCES SENTRY_USER (USER_ID) ; - --- SENTRY-1805 --- Table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] -CREATE TABLE AUTHZ_PATHS_SNAPSHOT_ID -( - AUTHZ_SNAPSHOT_ID bigint NOT NULL -); - --- Constraints for table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] -ALTER TABLE AUTHZ_PATHS_SNAPSHOT_ID ADD CONSTRAINT AUTHZ_SNAPSHOT_ID_PK PRIMARY KEY (AUTHZ_SNAPSHOT_ID); - --- SENTRY-1365 --- Table AUTHZ_PATHS_MAPPING for classes [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] - CREATE TABLE AUTHZ_PATHS_MAPPING( - AUTHZ_OBJ_ID BIGINT NOT NULL generated always as identity (start with 1), - AUTHZ_OBJ_NAME VARCHAR(384), - CREATE_TIME_MS BIGINT NOT NULL, - AUTHZ_SNAPSHOT_ID BIGINT NOT NULL -); - - ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHSCO7K_PK PRIMARY KEY (AUTHZ_OBJ_ID); - --- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] - CREATE UNIQUE INDEX AUTHZOBJNAME ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME); - --- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] -CREATE TABLE AUTHZ_PATH - ( - PATH_ID BIGINT NOT NULL, - PATH_NAME VARCHAR(4000), - AUTHZ_OBJ_ID BIGINT -); - --- Constraints for table `AUTHZ_PATH` -ALTER TABLE AUTHZ_PATH - ADD CONSTRAINT AUTHZ_PATH_PK PRIMARY KEY (PATH_ID); - -ALTER TABLE AUTHZ_PATH - ADD CONSTRAINT AUTHZ_PATH_FK - FOREIGN KEY (AUTHZ_OBJ_ID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID); - --- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange] -CREATE TABLE "SENTRY_PERM_CHANGE" -( - "CHANGE_ID" bigint NOT NULL, - "CREATE_TIME_MS" bigint NOT NULL, - "PERM_CHANGE" VARCHAR(4000) NOT NULL -); - -ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID"); - --- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange] -CREATE TABLE SENTRY_PATH_CHANGE -( - CHANGE_ID bigint NOT NULL, - NOTIFICATION_ID bigint NOT NULL, - CREATE_TIME_MS bigint NOT NULL, - PATH_CHANGE VARCHAR(4000) NOT NULL -); - --- Constraints for table SENTRY_PATH_CHANGE for class [org.apache.sentry.provider.db.service.model.MSentryPathChange] -ALTER TABLE SENTRY_PATH_CHANGE ADD CONSTRAINT SENTRY_PATH_CHANGE_PK PRIMARY KEY (CHANGE_ID); -CREATE UNIQUE INDEX NOTIFICATIONID ON SENTRY_PATH_CHANGE (NOTIFICATION_ID); - --- Table SENTRY_HMS_NOTIFICATION_ID for classes [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] -CREATE TABLE SENTRY_HMS_NOTIFICATION_ID -( - NOTIFICATION_ID bigint NOT NULL -); - --- Constraints for table SENTRY_HMS_NOTIFICATION_ID for class [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] -ALTER TABLE SENTRY_HMS_NOTIFICATION_ID ADD CONSTRAINT NOTIFICATION_PRIVILEGE_PK PRIMARY KEY (NOTIFICATION_ID); - --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.8.0', VERSION_COMMENT='Sentry release version 1.8.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-2.0.0.sql new file mode 100644 index 0000000..ac85968 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-2.0.0.sql @@ -0,0 +1,103 @@ +-- SENTRY-711 +CREATE TABLE SENTRY_USER +( + USER_ID BIGINT NOT NULL generated always as identity (start with 1), + CREATE_TIME BIGINT NOT NULL, + USER_NAME VARCHAR(128) +); + +ALTER TABLE SENTRY_USER ADD CONSTRAINT SENTRY_USER_PK PRIMARY KEY (USER_ID); + +CREATE UNIQUE INDEX SENTRYUSERNAME ON SENTRY_USER (USER_NAME); + +CREATE TABLE SENTRY_ROLE_USER_MAP +( + USER_ID BIGINT NOT NULL, + ROLE_ID BIGINT NOT NULL, + GRANTOR_PRINCIPAL VARCHAR(128) +); + +ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_PK PRIMARY KEY (USER_ID,ROLE_ID); + +CREATE INDEX SENTRY_ROLE_USER_MAP_N49 ON SENTRY_ROLE_USER_MAP (USER_ID); + +CREATE INDEX SENTRY_ROLE_USER_MAP_N50 ON SENTRY_ROLE_USER_MAP (ROLE_ID); + +ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK2 FOREIGN KEY (ROLE_ID) REFERENCES SENTRY_ROLE (ROLE_ID) ; + +ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN KEY (USER_ID) REFERENCES SENTRY_USER (USER_ID) ; + +-- SENTRY-1805 +-- Table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] +CREATE TABLE AUTHZ_PATHS_SNAPSHOT_ID +( + AUTHZ_SNAPSHOT_ID bigint NOT NULL +); + +-- Constraints for table AUTHZ_PATHS_SNAPSHOT_ID for class [org.apache.sentry.provider.db.service.model.MAuthzPathsSnapshotId] +ALTER TABLE AUTHZ_PATHS_SNAPSHOT_ID ADD CONSTRAINT AUTHZ_SNAPSHOT_ID_PK PRIMARY KEY (AUTHZ_SNAPSHOT_ID); + +-- SENTRY-1365 +-- Table AUTHZ_PATHS_MAPPING for classes [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] + CREATE TABLE AUTHZ_PATHS_MAPPING( + AUTHZ_OBJ_ID BIGINT NOT NULL generated always as identity (start with 1), + AUTHZ_OBJ_NAME VARCHAR(384), + CREATE_TIME_MS BIGINT NOT NULL, + AUTHZ_SNAPSHOT_ID BIGINT NOT NULL +); + + ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHSCO7K_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Constraints for table AUTHZ_PATHS_MAPPING for class(es) [org.apache.sentry.provider.db.service.model.MAuthzPathsMapping] + CREATE UNIQUE INDEX AUTHZOBJNAME ON AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_NAME); + +-- Table `AUTHZ_PATH` for classes [org.apache.sentry.provider.db.service.model.MPath] +CREATE TABLE AUTHZ_PATH + ( + PATH_ID BIGINT NOT NULL, + PATH_NAME VARCHAR(4000), + AUTHZ_OBJ_ID BIGINT +); + +-- Constraints for table `AUTHZ_PATH` +ALTER TABLE AUTHZ_PATH + ADD CONSTRAINT AUTHZ_PATH_PK PRIMARY KEY (PATH_ID); + +ALTER TABLE AUTHZ_PATH + ADD CONSTRAINT AUTHZ_PATH_FK + FOREIGN KEY (AUTHZ_OBJ_ID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID); + +-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange] +CREATE TABLE "SENTRY_PERM_CHANGE" +( + "CHANGE_ID" bigint NOT NULL, + "CREATE_TIME_MS" bigint NOT NULL, + "PERM_CHANGE" VARCHAR(4000) NOT NULL +); + +ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID"); + +-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange] +CREATE TABLE SENTRY_PATH_CHANGE +( + CHANGE_ID bigint NOT NULL, + NOTIFICATION_ID bigint NOT NULL, + CREATE_TIME_MS bigint NOT NULL, + PATH_CHANGE VARCHAR(4000) NOT NULL +); + +-- Constraints for table SENTRY_PATH_CHANGE for class [org.apache.sentry.provider.db.service.model.MSentryPathChange] +ALTER TABLE SENTRY_PATH_CHANGE ADD CONSTRAINT SENTRY_PATH_CHANGE_PK PRIMARY KEY (CHANGE_ID); +CREATE UNIQUE INDEX NOTIFICATIONID ON SENTRY_PATH_CHANGE (NOTIFICATION_ID); + +-- Table SENTRY_HMS_NOTIFICATION_ID for classes [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] +CREATE TABLE SENTRY_HMS_NOTIFICATION_ID +( + NOTIFICATION_ID bigint NOT NULL +); + +-- Constraints for table SENTRY_HMS_NOTIFICATION_ID for class [org.apache.sentry.provider.db.service.model.MSentryHmsNotification] +ALTER TABLE SENTRY_HMS_NOTIFICATION_ID ADD CONSTRAINT NOTIFICATION_PRIVILEGE_PK PRIMARY KEY (NOTIFICATION_ID); + +-- Version update +UPDATE SENTRY_VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Sentry release version 2.0.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-1.8.0.sql deleted file mode 100644 index 30397f7..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,7 +0,0 @@ -RUN '006-SENTRY-711.derby.sql'; -RUN '007-SENTRY-1365.derby.sql'; -RUN '008-SENTRY-1569.derby.sql'; -RUN '009-SENTRY-1805.derby.sql'; - --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.8.0', VERSION_COMMENT='Sentry release version 1.8.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-2.0.0.sql new file mode 100644 index 0000000..65f78b4 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-2.0.0.sql @@ -0,0 +1,7 @@ +RUN '006-SENTRY-711.derby.sql'; +RUN '007-SENTRY-1365.derby.sql'; +RUN '008-SENTRY-1569.derby.sql'; +RUN '009-SENTRY-1805.derby.sql'; + +-- Version update +UPDATE SENTRY_VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Sentry release version 2.0.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-1.8.0.sql deleted file mode 100644 index 0a95571..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,9 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0' AS ' '; -SOURCE 006-SENTRY-711.mysql.sql; -SOURCE 007-SENTRY-1365.mysql.sql; -SOURCE 008-SENTRY-1569.mysql.sql; -SOURCE 009-SENTRY-1805.mysql.sql; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.8.0', VERSION_COMMENT='Sentry release version 1.8.0' WHERE VER_ID=1; - -SELECT 'Finish upgrading Sentry store schema from 1.7.0 to 1.8.0' AS ' '; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-2.0.0.sql new file mode 100644 index 0000000..b6d9d05 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-2.0.0.sql @@ -0,0 +1,9 @@ +SELECT 'Upgrading Sentry store schema from 1.7.0 to 2.0.0' AS ' '; +SOURCE 006-SENTRY-711.mysql.sql; +SOURCE 007-SENTRY-1365.mysql.sql; +SOURCE 008-SENTRY-1569.mysql.sql; +SOURCE 009-SENTRY-1805.mysql.sql; + +UPDATE SENTRY_VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Sentry release version 2.0.0' WHERE VER_ID=1; + +SELECT 'Finish upgrading Sentry store schema from 1.7.0 to 2.0.0' AS ' '; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-1.8.0.sql deleted file mode 100644 index 3241ef9..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,9 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0' AS Status from dual; [email protected]; [email protected]; [email protected]; [email protected]; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.8.0', VERSION_COMMENT='Sentry release version 1.8.0' WHERE VER_ID=1; - -SELECT 'Finished upgrading Sentry store schema from 1.7.0 to 1.8.0' AS Status from dual; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-2.0.0.sql new file mode 100644 index 0000000..bf4754f --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-2.0.0.sql @@ -0,0 +1,9 @@ +SELECT 'Upgrading Sentry store schema from 1.7.0 to 2.0.0' AS Status from dual; [email protected]; [email protected]; [email protected]; [email protected]; + +UPDATE SENTRY_VERSION SET SCHEMA_VERSION='2.0.0', VERSION_COMMENT='Sentry release version 2.0.0' WHERE VER_ID=1; + +SELECT 'Finished upgrading Sentry store schema from 1.7.0 to 2.0.0' AS Status from dual; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-1.8.0.sql deleted file mode 100644 index af362f6..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,9 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0'; -\i 006-SENTRY-711.postgres.sql; -\i 007-SENTRY-1365.postgres.sql; -\i 008-SENTRY-1569.postgres.sql; -\i 009-SENTRY-1805.postgres.sql; - -UPDATE "SENTRY_VERSION" SET "SCHEMA_VERSION"='1.8.0', "VERSION_COMMENT"='Sentry release version 1.8.0' WHERE "VER_ID"=1; - -SELECT 'Finished upgrading Sentry store schema from 1.7.0 to 1.8.0'; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-2.0.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-2.0.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-2.0.0.sql new file mode 100644 index 0000000..6f4c606 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-2.0.0.sql @@ -0,0 +1,9 @@ +SELECT 'Upgrading Sentry store schema from 1.7.0 to 2.0.0'; +\i 006-SENTRY-711.postgres.sql; +\i 007-SENTRY-1365.postgres.sql; +\i 008-SENTRY-1569.postgres.sql; +\i 009-SENTRY-1805.postgres.sql; + +UPDATE "SENTRY_VERSION" SET "SCHEMA_VERSION"='2.0.0', "VERSION_COMMENT"='Sentry release version 2.0.0' WHERE "VER_ID"=1; + +SELECT 'Finished upgrading Sentry store schema from 1.7.0 to 2.0.0'; http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 index 8da8c9c..91f7667 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 +++ b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 @@ -1,4 +1,4 @@ 1.4.0-to-1.5.0 1.5.0-to-1.6.0 1.6.0-to-1.7.0 -1.7.0-to-1.8.0 +1.7.0-to-2.0.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby index 8da8c9c..91f7667 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby +++ b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby @@ -1,4 +1,4 @@ 1.4.0-to-1.5.0 1.5.0-to-1.6.0 1.6.0-to-1.7.0 -1.7.0-to-1.8.0 +1.7.0-to-2.0.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql index 8da8c9c..91f7667 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql +++ b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql @@ -1,4 +1,4 @@ 1.4.0-to-1.5.0 1.5.0-to-1.6.0 1.6.0-to-1.7.0 -1.7.0-to-1.8.0 +1.7.0-to-2.0.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle index 8da8c9c..91f7667 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle +++ b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle @@ -1,4 +1,4 @@ 1.4.0-to-1.5.0 1.5.0-to-1.6.0 1.6.0-to-1.7.0 -1.7.0-to-1.8.0 +1.7.0-to-2.0.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres index 8da8c9c..91f7667 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres +++ b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres @@ -1,4 +1,4 @@ 1.4.0-to-1.5.0 1.5.0-to-1.6.0 1.6.0-to-1.7.0 -1.7.0-to-1.8.0 +1.7.0-to-2.0.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html b/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html index 9eb5f0e..9f52a8e 100644 --- a/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html +++ b/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html @@ -54,7 +54,7 @@ limitations under the License. <footer class="footer"> <div class="container"> - <p class="text-muted">SENTRY 1.8.0-SNAPSHOT</p> + <p class="text-muted">SENTRY 2.0.0-SNAPSHOT</p> </div> </footer> </body> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-provider/sentry-provider-file/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-file/pom.xml b/sentry-provider/sentry-provider-file/pom.xml index 04f38d8..ae14c84 100644 --- a/sentry-provider/sentry-provider-file/pom.xml +++ b/sentry-provider/sentry-provider-file/pom.xml @@ -21,7 +21,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry-provider</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>sentry-provider-file</artifactId> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-solr/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-solr/pom.xml b/sentry-solr/pom.xml index 1231f7e..133ea60 100644 --- a/sentry-solr/pom.xml +++ b/sentry-solr/pom.xml @@ -22,7 +22,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>sentry-solr</artifactId> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-solr/solr-sentry-core/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-solr/solr-sentry-core/pom.xml b/sentry-solr/solr-sentry-core/pom.xml index 584a5c8..e788262 100644 --- a/sentry-solr/solr-sentry-core/pom.xml +++ b/sentry-solr/solr-sentry-core/pom.xml @@ -22,7 +22,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry-solr</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>solr-sentry-core</artifactId> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-solr/solr-sentry-handlers/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-solr/solr-sentry-handlers/pom.xml b/sentry-solr/solr-sentry-handlers/pom.xml index 4073359..5b024db 100644 --- a/sentry-solr/solr-sentry-handlers/pom.xml +++ b/sentry-solr/solr-sentry-handlers/pom.xml @@ -22,7 +22,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry-solr</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>solr-sentry-handlers</artifactId> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-tests/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-tests/pom.xml b/sentry-tests/pom.xml index 2c68fde..1909dae 100644 --- a/sentry-tests/pom.xml +++ b/sentry-tests/pom.xml @@ -20,7 +20,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>sentry-tests</artifactId> <name>Sentry Tests</name> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-tests/sentry-tests-hive-v2/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-tests/sentry-tests-hive-v2/pom.xml b/sentry-tests/sentry-tests-hive-v2/pom.xml index c9e4dd7..d648ba4 100644 --- a/sentry-tests/sentry-tests-hive-v2/pom.xml +++ b/sentry-tests/sentry-tests-hive-v2/pom.xml @@ -21,7 +21,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry-tests</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>sentry-tests-hive-v2</artifactId> <name>Sentry Hive Tests v2</name> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-tests/sentry-tests-hive/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-tests/sentry-tests-hive/pom.xml b/sentry-tests/sentry-tests-hive/pom.xml index 9d5b8b5..da75abd 100644 --- a/sentry-tests/sentry-tests-hive/pom.xml +++ b/sentry-tests/sentry-tests-hive/pom.xml @@ -21,7 +21,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry-tests</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>sentry-tests-hive</artifactId> <name>Sentry Hive Tests</name> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-tests/sentry-tests-kafka/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-tests/sentry-tests-kafka/pom.xml b/sentry-tests/sentry-tests-kafka/pom.xml index 5a3374c..56a3ef1 100644 --- a/sentry-tests/sentry-tests-kafka/pom.xml +++ b/sentry-tests/sentry-tests-kafka/pom.xml @@ -21,7 +21,7 @@ limitations under the License. <parent> <artifactId>sentry-tests</artifactId> <groupId>org.apache.sentry</groupId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <modelVersion>4.0.0</modelVersion> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-tests/sentry-tests-solr/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-tests/sentry-tests-solr/pom.xml b/sentry-tests/sentry-tests-solr/pom.xml index de9f04f..c704768 100644 --- a/sentry-tests/sentry-tests-solr/pom.xml +++ b/sentry-tests/sentry-tests-solr/pom.xml @@ -22,7 +22,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry-tests</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>sentry-tests-solr</artifactId> http://git-wip-us.apache.org/repos/asf/sentry/blob/c8d0f24a/sentry-tests/sentry-tests-sqoop/pom.xml ---------------------------------------------------------------------- diff --git a/sentry-tests/sentry-tests-sqoop/pom.xml b/sentry-tests/sentry-tests-sqoop/pom.xml index c494b5a..74ec670 100644 --- a/sentry-tests/sentry-tests-sqoop/pom.xml +++ b/sentry-tests/sentry-tests-sqoop/pom.xml @@ -22,7 +22,7 @@ limitations under the License. <parent> <groupId>org.apache.sentry</groupId> <artifactId>sentry-tests</artifactId> - <version>1.8.0-SNAPSHOT</version> + <version>2.0.0-SNAPSHOT</version> </parent> <artifactId>sentry-tests-sqoop</artifactId>
