Repository: sentry Updated Branches: refs/heads/sentry-ha-redesign 1b65698cd -> de7c26a8a
SENTRY-1365: Upgrading SQL script for HMSPaths persistence (Hao Hao, Reviewed by: Anne Yu and Sravya Tirukkovalur) Change-Id: I92f7c60ecb031ec2053352de1e898461bd20ae7d Project: http://git-wip-us.apache.org/repos/asf/sentry/repo Commit: http://git-wip-us.apache.org/repos/asf/sentry/commit/de7c26a8 Tree: http://git-wip-us.apache.org/repos/asf/sentry/tree/de7c26a8 Diff: http://git-wip-us.apache.org/repos/asf/sentry/diff/de7c26a8 Branch: refs/heads/sentry-ha-redesign Commit: de7c26a8a13bdf102fd713a4fd3903ade0f1e835 Parents: 1b65698 Author: hahao <[email protected]> Authored: Mon Jul 11 13:35:26 2016 -0700 Committer: hahao <[email protected]> Committed: Mon Jul 11 13:35:26 2016 -0700 ---------------------------------------------------------------------- .../src/main/resources/007-SENTRY-872.derby.sql | 30 ++++++++++++++++++++ .../src/main/resources/007-SENTRY-872.mysql.sql | 27 ++++++++++++++++++ .../main/resources/007-SENTRY-872.oracle.sql | 29 +++++++++++++++++++ .../main/resources/007-SENTRY-872.postgres.sql | 27 ++++++++++++++++++ .../src/main/resources/sentry-db2-1.8.0.sql | 20 ++++++++++++- .../src/main/resources/sentry-derby-1.8.0.sql | 26 +++++++++++++++++ .../src/main/resources/sentry-mysql-1.8.0.sql | 24 ++++++++++++++++ .../src/main/resources/sentry-oracle-1.8.0.sql | 27 ++++++++++++++++++ .../main/resources/sentry-postgres-1.8.0.sql | 25 ++++++++++++++++ .../sentry-upgrade-db2-1.7.0-to-1.8.0.sql | 19 +++++++++++++ .../sentry-upgrade-derby-1.7.0-to-1.8.0.sql | 1 + .../sentry-upgrade-mysql-1.7.0-to-1.8.0.sql | 1 + .../sentry-upgrade-oracle-1.7.0-to-1.8.0.sql | 1 + .../sentry-upgrade-postgres-1.7.0-to-1.8.0.sql | 1 + 14 files changed, 257 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.derby.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.derby.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.derby.sql new file mode 100644 index 0000000..1883626 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.derby.sql @@ -0,0 +1,30 @@ +-- 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 +); + +ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Table MAUTHZPATHSMAPPING_PATHS for join relationship +CREATE TABLE MAUTHZPATHSMAPPING_PATHS +( + AUTHZ_OBJ_ID_OID BIGINT NOT NULL, + PATHS VARCHAR(4000) NOT NULL +); + +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_PK PRIMARY KEY (AUTHZ_OBJ_ID_OID,PATHS); + +-- 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); + + +-- Constraints for table MAUTHZPATHSMAPPING_PATHS +CREATE INDEX MAUTHZPATHSMAPPING_PATHS_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID); + +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_FK1 FOREIGN KEY (AUTHZ_OBJ_ID_OID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID) ; + +------------------------------------------------------------------ +-- Sequences and SequenceTables \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.mysql.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.mysql.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.mysql.sql new file mode 100644 index 0000000..1829e2f --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.mysql.sql @@ -0,0 +1,27 @@ +-- 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, + CONSTRAINT `AUTHZ_PATHS_MAPPING_PK` PRIMARY KEY (`AUTHZ_OBJ_ID`) +) ENGINE=INNODB; + +-- Table `MAUTHZPATHSMAPPING_PATHS` for join relationship +CREATE TABLE `MAUTHZPATHSMAPPING_PATHS` +( + `AUTHZ_OBJ_ID_OID` BIGINT NOT NULL, + `PATHS` VARCHAR(4000) BINARY NOT NULL, + CONSTRAINT `MAUTHZPATHSMAPPING_PATHS_PK` PRIMARY KEY (`AUTHZ_OBJ_ID_OID`,`PATHS`) +) 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`); + +-- Constraints for table `MAUTHZPATHSMAPPING_PATHS` +CREATE INDEX `MAUTHZPATHSMAPPING_PATHS_N49` ON `MAUTHZPATHSMAPPING_PATHS` (`AUTHZ_OBJ_ID_OID`); + +ALTER TABLE `MAUTHZPATHSMAPPING_PATHS` ADD CONSTRAINT `MAUTHZPATHSMAPPING_PATHS_FK1` FOREIGN KEY (`AUTHZ_OBJ_ID_OID`) REFERENCES `AUTHZ_PATHS_MAPPING` (`AUTHZ_OBJ_ID`) ; + +------------------------------------------------------------------ +-- Sequences and SequenceTables \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.oracle.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.oracle.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.oracle.sql new file mode 100644 index 0000000..7de9751 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.oracle.sql @@ -0,0 +1,29 @@ +-- 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 +); + +ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Table MAUTHZPATHSMAPPING_PATHS for join relationship +CREATE TABLE MAUTHZPATHSMAPPING_PATHS +( + AUTHZ_OBJ_ID_OID NUMBER NOT NULL, + PATHS VARCHAR2(4000) NOT NULL +); + +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_PK PRIMARY KEY (AUTHZ_OBJ_ID_OID,PATHS); + +-- 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); + +-- Constraints for table MAUTHZPATHSMAPPING_PATHS +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_FK1 FOREIGN KEY (AUTHZ_OBJ_ID_OID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID) INITIALLY DEFERRED ; + +CREATE INDEX MAUTHZPATHSMAPPING_PATHS_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID); + +------------------------------------------------------------------ +-- Sequences and SequenceTables \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.postgres.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.postgres.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.postgres.sql new file mode 100644 index 0000000..adf5f1f --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.postgres.sql @@ -0,0 +1,27 @@ +-- 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, + CONSTRAINT "AUTHZ_PATHS_MAPPING_PK" PRIMARY KEY ("AUTHZ_OBJ_ID") +); + +-- Table "MAUTHZPATHSMAPPING_PATHS" for join relationship +CREATE TABLE "MAUTHZPATHSMAPPING_PATHS" +( + "AUTHZ_OBJ_ID_OID" int8 NOT NULL, + "PATHS" varchar(4000) NOT NULL, + CONSTRAINT "MAUTHZPATHSMAPPING_PATHS_PK" PRIMARY KEY ("AUTHZ_OBJ_ID_OID","PATHS") +); + +-- 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"); + +-- Constraints for table "MAUTHZPATHSMAPPING_PATHS" +ALTER TABLE "MAUTHZPATHSMAPPING_PATHS" ADD CONSTRAINT "MAUTHZPATHSMAPPING_PATHS_FK1" FOREIGN KEY ("AUTHZ_OBJ_ID_OID") REFERENCES "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_ID") INITIALLY DEFERRED ; + +CREATE INDEX "MAUTHZPATHSMAPPING_PATHS_N49" ON "MAUTHZPATHSMAPPING_PATHS" ("AUTHZ_OBJ_ID_OID"); + +------------------------------------------------------------------ +-- Sequences and SequenceTables \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-1.8.0.sql index 6d08b5c..0606116 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-1.8.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-db2-1.8.0.sql @@ -180,4 +180,22 @@ 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) ; \ No newline at end of file +ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN KEY (USER_ID) REFERENCES SENTRY_USER (USER_ID) ; + +-- 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); + +ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHSCO7K_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Table MAUTHZPATHSMAPPING_PATHS for join relationship +CREATE TABLE MAUTHZPATHSMAPPING_PATHS(AUTHZ_OBJ_ID_OID BIGINT NOT NULL,PATHS VARCHAR(4000) NOT NULL); + +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSS184_PK PRIMARY KEY (AUTHZ_OBJ_ID_OID,PATHS); + +-- 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); + +-- Constraints for table MAUTHZPATHSMAPPING_PATHS +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHS184_FK1 FOREIGN KEY (AUTHZ_OBJ_ID_OID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID) ; + +CREATE INDEX MAUTHZPATHS184_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-1.8.0.sql index d522026..be9a33e 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-1.8.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-derby-1.8.0.sql @@ -182,3 +182,29 @@ ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK2 FOREIGN ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN KEY (USER_ID) REFERENCES SENTRY_USER (USER_ID) ; +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 +); + +ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Table MAUTHZPATHSMAPPING_PATHS for join relationship +CREATE TABLE MAUTHZPATHSMAPPING_PATHS +( + AUTHZ_OBJ_ID_OID BIGINT NOT NULL, + PATHS VARCHAR(4000) NOT NULL +); + +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_PK PRIMARY KEY (AUTHZ_OBJ_ID_OID,PATHS); + +-- 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); + + +-- Constraints for table MAUTHZPATHSMAPPING_PATHS +CREATE INDEX MAUTHZPATHSMAPPING_PATHS_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID); + +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_FK1 FOREIGN KEY (AUTHZ_OBJ_ID_OID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID) ; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql index d27d7b9..1c8848c 100644 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql +++ b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql @@ -221,3 +221,27 @@ 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_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, + CONSTRAINT `AUTHZ_PATHS_MAPPING_PK` PRIMARY KEY (`AUTHZ_OBJ_ID`) +) ENGINE=INNODB; + +-- Table `MAUTHZPATHSMAPPING_PATHS` for join relationship +CREATE TABLE `MAUTHZPATHSMAPPING_PATHS` +( + `AUTHZ_OBJ_ID_OID` BIGINT NOT NULL, + `PATHS` VARCHAR(4000) BINARY NOT NULL, + CONSTRAINT `MAUTHZPATHSMAPPING_PATHS_PK` PRIMARY KEY (`AUTHZ_OBJ_ID_OID`,`PATHS`) +) 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`); + +-- Constraints for table `MAUTHZPATHSMAPPING_PATHS` +CREATE INDEX `MAUTHZPATHSMAPPING_PATHS_N49` ON `MAUTHZPATHSMAPPING_PATHS` (`AUTHZ_OBJ_ID_OID`); + +ALTER TABLE `MAUTHZPATHSMAPPING_PATHS` ADD CONSTRAINT `MAUTHZPATHSMAPPING_PATHS_FK1` FOREIGN KEY (`AUTHZ_OBJ_ID_OID`) REFERENCES `AUTHZ_PATHS_MAPPING` (`AUTHZ_OBJ_ID`) ; http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/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 index ced5c31..fc7b53f 100644 --- 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 @@ -195,3 +195,30 @@ ALTER TABLE "SENTRY_ROLE_USER_MAP" 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_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 +); + +ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHS_MAPPING_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Table MAUTHZPATHSMAPPING_PATHS for join relationship +CREATE TABLE MAUTHZPATHSMAPPING_PATHS +( + AUTHZ_OBJ_ID_OID NUMBER NOT NULL, + PATHS VARCHAR2(4000) NOT NULL +); + +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_PK PRIMARY KEY (AUTHZ_OBJ_ID_OID,PATHS); + +-- 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); + +-- Constraints for table MAUTHZPATHSMAPPING_PATHS +ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_FK1 FOREIGN KEY (AUTHZ_OBJ_ID_OID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID) INITIALLY DEFERRED ; + +CREATE INDEX MAUTHZPATHSMAPPING_PATHS_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/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 index 6d56332..ce807a5 100644 --- 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 @@ -208,4 +208,29 @@ 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_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, + CONSTRAINT "AUTHZ_PATHS_MAPPING_PK" PRIMARY KEY ("AUTHZ_OBJ_ID") +); + +-- Table "MAUTHZPATHSMAPPING_PATHS" for join relationship +CREATE TABLE "MAUTHZPATHSMAPPING_PATHS" +( + "AUTHZ_OBJ_ID_OID" int8 NOT NULL, + "PATHS" varchar(4000) NOT NULL, + CONSTRAINT "MAUTHZPATHSMAPPING_PATHS_PK" PRIMARY KEY ("AUTHZ_OBJ_ID_OID","PATHS") +); + +-- 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"); + +-- Constraints for table "MAUTHZPATHSMAPPING_PATHS" +ALTER TABLE "MAUTHZPATHSMAPPING_PATHS" ADD CONSTRAINT "MAUTHZPATHSMAPPING_PATHS_FK1" FOREIGN KEY ("AUTHZ_OBJ_ID_OID") REFERENCES "AUTHZ_PATHS_MAPPING" ("AUTHZ_OBJ_ID") INITIALLY DEFERRED ; + +CREATE INDEX "MAUTHZPATHSMAPPING_PATHS_N49" ON "MAUTHZPATHSMAPPING_PATHS" ("AUTHZ_OBJ_ID_OID"); + COMMIT; http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/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 index 927f302..92d0e33 100644 --- 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 @@ -27,5 +27,24 @@ ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK2 FOREIGN ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN KEY (USER_ID) REFERENCES SENTRY_USER (USER_ID) ; +-- SENTRY-872 +-- 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); + + ALTER TABLE AUTHZ_PATHS_MAPPING ADD CONSTRAINT AUTHZ_PATHSCO7K_PK PRIMARY KEY (AUTHZ_OBJ_ID); + +-- Table MAUTHZPATHSMAPPING_PATHS for join relationship + CREATE TABLE MAUTHZPATHSMAPPING_PATHS(AUTHZ_OBJ_ID_OID BIGINT NOT NULL,PATHS VARCHAR(4000) NOT NULL); + + ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSS184_PK PRIMARY KEY (AUTHZ_OBJ_ID_OID,PATHS); + +-- 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); + +-- Constraints for table MAUTHZPATHSMAPPING_PATHS + ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHS184_FK1 FOREIGN KEY (AUTHZ_OBJ_ID_OID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID) ; + + CREATE INDEX MAUTHZPATHS184_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID); + -- Version update UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.8.0', VERSION_COMMENT='Sentry release version 1.8.0' WHERE VER_ID=1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/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 index fbe2dc8..6302210 100644 --- 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 @@ -1,4 +1,5 @@ RUN '006-SENTRY-711.derby.sql'; +RUN '007-SENTRY-872.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; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/de7c26a8/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 index f0df187..c349057 100644 --- 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 @@ -1,5 +1,6 @@ SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0' AS ' '; SOURCE 006-SENTRY-711.mysql.sql; +SOURCE 007-SENTRY-872.mysql.sql; 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/de7c26a8/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 index f1666be..1b4d66d 100644 --- 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 @@ -1,5 +1,6 @@ SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0' AS Status from dual; @006-SENTRY-711.oracle.sql; [email protected]; 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/de7c26a8/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 index b39292d..0da9567 100644 --- 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 @@ -1,5 +1,6 @@ SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0'; \i 006-SENTRY-711.postgres.sql; +\i 007-SENTRY-872.postgres.sql; UPDATE "SENTRY_VERSION" SET "SCHEMA_VERSION"='1.8.0', "VERSION_COMMENT"='Sentry release version 1.8.0' WHERE "VER_ID"=1;
