sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ha...@apache.org
Subject sentry git commit: SENTRY-1487: Renaming SQL script for HMSPaths persistence (Kalyan Kumar Kalvagadda, Reviewed by: Hao Hao)
Date Tue, 07 Feb 2017 19:28:22 GMT
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 <hao.hao@cloudera.com>
Authored: Tue Feb 7 11:27:08 2017 -0800
Committer: hahao <hao.hao@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';


Mime
View raw message