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 2017/02/07 19:28:22 UTC
sentry git commit: SENTRY-1487: Renaming SQL script for HMSPaths
persistence (Kalyan Kumar Kalvagadda, Reviewed by: Hao Hao)
Repository: sentry
Updated Branches:
refs/heads/sentry-ha-redesign 5d17ebb17 -> 9f09f305a
SENTRY-1487: Renaming SQL script for HMSPaths persistence (Kalyan Kumar Kalvagadda, Reviewed by: Hao Hao)
Change-Id: I6265d62e0fb94cfe31fff608a32d5623c723ce6d
Project: http://git-wip-us.apache.org/repos/asf/sentry/repo
Commit: http://git-wip-us.apache.org/repos/asf/sentry/commit/9f09f305
Tree: http://git-wip-us.apache.org/repos/asf/sentry/tree/9f09f305
Diff: http://git-wip-us.apache.org/repos/asf/sentry/diff/9f09f305
Branch: refs/heads/sentry-ha-redesign
Commit: 9f09f305afd7abbabea0ecfc1a1d0b8edc2922bc
Parents: 5d17ebb
Author: hahao <ha...@cloudera.com>
Authored: Tue Feb 7 11:27:08 2017 -0800
Committer: hahao <ha...@cloudera.com>
Committed: Tue Feb 7 11:27:08 2017 -0800
----------------------------------------------------------------------
.../main/resources/007-SENTRY-1365.derby.sql | 30 ++++++++++++++++++++
.../main/resources/007-SENTRY-1365.mysql.sql | 27 ++++++++++++++++++
.../main/resources/007-SENTRY-1365.oracle.sql | 29 +++++++++++++++++++
.../main/resources/007-SENTRY-1365.postgres.sql | 27 ++++++++++++++++++
.../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 ------------------
.../sentry-upgrade-db2-1.7.0-to-1.8.0.sql | 4 +--
.../sentry-upgrade-derby-1.7.0-to-1.8.0.sql | 4 +--
.../sentry-upgrade-mysql-1.7.0-to-1.8.0.sql | 4 +--
.../sentry-upgrade-oracle-1.7.0-to-1.8.0.sql | 4 +--
.../sentry-upgrade-postgres-1.7.0-to-1.8.0.sql | 4 +--
13 files changed, 123 insertions(+), 123 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/sentry/blob/9f09f305/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.derby.sql
new file mode 100644
index 0000000..1883626
--- /dev/null
+++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.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/9f09f305/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.mysql.sql
new file mode 100644
index 0000000..1829e2f
--- /dev/null
+++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.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/9f09f305/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.oracle.sql
new file mode 100644
index 0000000..7de9751
--- /dev/null
+++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.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/9f09f305/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.postgres.sql
new file mode 100644
index 0000000..adf5f1f
--- /dev/null
+++ b/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-1365.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/9f09f305/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
deleted file mode 100644
index 1883626..0000000
--- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.derby.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- 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/9f09f305/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
deleted file mode 100644
index 1829e2f..0000000
--- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.mysql.sql
+++ /dev/null
@@ -1,27 +0,0 @@
--- 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/9f09f305/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
deleted file mode 100644
index 7de9751..0000000
--- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.oracle.sql
+++ /dev/null
@@ -1,29 +0,0 @@
--- 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/9f09f305/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
deleted file mode 100644
index adf5f1f..0000000
--- a/sentry-provider/sentry-provider-db/src/main/resources/007-SENTRY-872.postgres.sql
+++ /dev/null
@@ -1,27 +0,0 @@
--- 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/9f09f305/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 92d0e33..3657377 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,7 +27,7 @@ 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
+-- 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);
@@ -47,4 +47,4 @@ ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN
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
+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/9f09f305/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 6302210..5d88887 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,5 +1,5 @@
RUN '006-SENTRY-711.derby.sql';
-RUN '007-SENTRY-872.derby.sql';
+RUN '007-SENTRY-1365.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
+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/9f09f305/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 c349057..b6108e7 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,7 +1,7 @@
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;
+SOURCE 007-SENTRY-1365.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 ' ';
\ No newline at end of file
+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/9f09f305/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 1b4d66d..d5b7d6e 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,7 +1,7 @@
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;
+@007-SENTRY-1365.oracle.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' AS Status from dual;
\ No newline at end of file
+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/9f09f305/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 0da9567..f0c8cfb 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,7 +1,7 @@
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;
+\i 007-SENTRY-1365.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';
\ No newline at end of file
+SELECT 'Finished upgrading Sentry store schema from 1.7.0 to 1.8.0';