You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by ha...@apache.org on 2016/07/11 20:36:54 UTC
sentry git commit: SENTRY-1365: Upgrading SQL script for HMSPaths
persistence (Hao Hao, Reviewed by: Anne Yu and Sravya Tirukkovalur)
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 <ha...@cloudera.com>
Authored: Mon Jul 11 13:35:26 2016 -0700
Committer: hahao <ha...@cloudera.com>
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;
+@007-SENTRY-872.oracle.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-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;