You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sentry.apache.org by ak...@apache.org on 2017/03/06 21:18:23 UTC
sentry git commit: SENTRY-1569: Upgrading SQL scripts for persist
Perm/Path change - added missing files (Kalyan Kumar Kalvagadda,
Reviewed by: Hao Hao)
Repository: sentry
Updated Branches:
refs/heads/sentry-ha-redesign e35d36cd2 -> 48ec01dd7
SENTRY-1569: Upgrading SQL scripts for persist Perm/Path change - added missing files (Kalyan Kumar Kalvagadda, Reviewed by: Hao Hao)
Project: http://git-wip-us.apache.org/repos/asf/sentry/repo
Commit: http://git-wip-us.apache.org/repos/asf/sentry/commit/48ec01dd
Tree: http://git-wip-us.apache.org/repos/asf/sentry/tree/48ec01dd
Diff: http://git-wip-us.apache.org/repos/asf/sentry/diff/48ec01dd
Branch: refs/heads/sentry-ha-redesign
Commit: 48ec01dd7db3d345976db9a3ea8c60162c72501e
Parents: e35d36c
Author: Alexander Kolbasov <ak...@cloudera.com>
Authored: Mon Mar 6 13:18:07 2017 -0800
Committer: Alexander Kolbasov <ak...@cloudera.com>
Committed: Mon Mar 6 13:18:07 2017 -0800
----------------------------------------------------------------------
.../main/resources/008-SENTRY-1569.mysql.sql | 17 +++++++++++++++
.../main/resources/008-SENTRY-1569.oracle.sql | 19 ++++++++++++++++
.../main/resources/008-SENTRY-1569.postgres.sql | 17 +++++++++++++++
.../src/main/resources/sentry-db2-1.8.0.sql | 23 +++++++++++++++++++-
.../src/main/resources/sentry-derby-1.8.0.sql | 23 +++++++++++++++++++-
.../src/main/resources/sentry-mysql-1.8.0.sql | 18 +++++++++++++++
.../src/main/resources/sentry-oracle-1.8.0.sql | 22 ++++++++++++++++++-
.../main/resources/sentry-postgres-1.8.0.sql | 18 +++++++++++++++
.../sentry-upgrade-db2-1.7.0-to-1.8.0.sql | 22 ++++++++++++++++++-
.../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 +
13 files changed, 179 insertions(+), 4 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql
new file mode 100644
index 0000000..6986550
--- /dev/null
+++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.mysql.sql
@@ -0,0 +1,17 @@
+-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE `SENTRY_PERM_CHANGE`
+(
+ `CHANGE_ID` BIGINT NOT NULL,
+ `CREATE_TIME_MS` BIGINT NOT NULL,
+ `PERM_CHANGE` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+ CONSTRAINT `SENTRY_PERM_CHANGE_PK` PRIMARY KEY (`CHANGE_ID`)
+) ENGINE=INNODB;
+
+-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE `SENTRY_PATH_CHANGE`
+(
+ `CHANGE_ID` BIGINT NOT NULL,
+ `CREATE_TIME_MS` BIGINT NOT NULL,
+ `PATH_CHANGE` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+ CONSTRAINT `SENTRY_PATH_CHANGE_PK` PRIMARY KEY (`CHANGE_ID`)
+) ENGINE=INNODB;
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql
new file mode 100644
index 0000000..6a438ea
--- /dev/null
+++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.oracle.sql
@@ -0,0 +1,19 @@
+-- Table "SENTRY_PERM_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE "SENTRY_PERM_CHANGE"
+(
+ "CHANGE_ID" NUMBER NOT NULL,
+ "CREATE_TIME_MS" NUMBER NOT NULL,
+ "PERM_CHANGE" VARCHAR2(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID");
+
+-- Table "SENTRY_PATH_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE "SENTRY_PATH_CHANGE"
+(
+ "CHANGE_ID" NUMBER NOT NULL,
+ "CREATE_TIME_MS" NUMBER NOT NULL,
+ "PATH_CHANGE" VARCHAR2(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PATH_CHANGE" ADD CONSTRAINT SENTRY_PATH_CHANGE_PK PRIMARY KEY ("CHANGE_ID");
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql
----------------------------------------------------------------------
diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql
new file mode 100644
index 0000000..a9b7e2c
--- /dev/null
+++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.postgres.sql
@@ -0,0 +1,17 @@
+-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE "SENTRY_PERM_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PERM_CHANGE" VARCHAR(4000) NOT NULL,
+ CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID")
+);
+
+-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE "SENTRY_PATH_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PATH_CHANGE" VARCHAR(4000) NOT NULL,
+ CONSTRAINT "SENTRY_PATH_CHANGE_PK" PRIMARY KEY ("CHANGE_ID")
+);
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 0606116..547bbe8 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
@@ -198,4 +198,25 @@ 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
+CREATE INDEX MAUTHZPATHS184_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID);
+
+-- Table SENTRY_PERM_CHANGE for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE "SENTRY_PERM_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PERM_CHANGE" VARCHAR(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID");
+
+-- Table SENTRY_PATH_CHANGE for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE "SENTRY_PATH_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PATH_CHANGE" VARCHAR(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PATH_CHANGE" ADD CONSTRAINT "SENTRY_PATH_CHANGE_PK" PRIMARY KEY ("CHANGE_ID");
+~
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 be9a33e..6474389 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
@@ -207,4 +207,25 @@ 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
+ALTER TABLE MAUTHZPATHSMAPPING_PATHS ADD CONSTRAINT MAUTHZPATHSMAPPING_PATHS_FK1 FOREIGN KEY (AUTHZ_OBJ_ID_OID) REFERENCES AUTHZ_PATHS_MAPPING (AUTHZ_OBJ_ID) ;
+
+-- Table SENTRY_PERM_CHANGE for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE SENTRY_PERM_CHANGE
+(
+ CHANGE_ID BIGINT NOT NULL,
+ CREATE_TIME_MS BIGINT NOT NULL,
+ PERM_CHANGE VARCHAR(4000) NOT NULL
+);
+
+ALTER TABLE SENTRY_PERM_CHANGE ADD CONSTRAINT SENTRY_PERM_CHANGE_PK PRIMARY KEY (CHANGE_ID);
+
+-- Table SENTRY_PATH_CHANGE for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE SENTRY_PATH_CHANGE
+(
+ CHANGE_ID BIGINT NOT NULL,
+ CREATE_TIME_MS BIGINT NOT NULL,
+ PATH_CHANGE VARCHAR(4000) NOT NULL
+);
+
+ALTER TABLE SENTRY_PATH_CHANGE ADD CONSTRAINT SENTRY_PATH_CHANGE_PK PRIMARY KEY (CHANGE_ID);
+
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 1c8848c..1ab8343 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
@@ -245,3 +245,21 @@ CREATE UNIQUE INDEX `AUTHZOBJNAME` ON `AUTHZ_PATHS_MAPPING` (`AUTHZ_OBJ_NAME`);
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`) ;
+
+-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE `SENTRY_PERM_CHANGE`
+(
+ `CHANGE_ID` BIGINT NOT NULL,
+ `CREATE_TIME_MS` BIGINT NOT NULL,
+ `PERM_CHANGE` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+ CONSTRAINT `SENTRY_PERM_CHANGE_PK` PRIMARY KEY (`CHANGE_ID`)
+) ENGINE=INNODB;
+
+-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE `SENTRY_PATH_CHANGE`
+(
+ `CHANGE_ID` BIGINT NOT NULL,
+ `CREATE_TIME_MS` BIGINT NOT NULL,
+ `PATH_CHANGE` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
+ CONSTRAINT `SENTRY_PATH_CHANGE_PK` PRIMARY KEY (`CHANGE_ID`)
+) ENGINE=INNODB;
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 fc7b53f..0418b29 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
@@ -221,4 +221,24 @@ 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
+CREATE INDEX MAUTHZPATHSMAPPING_PATHS_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID);
+
+-- Table "SENTRY_PERM_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE "SENTRY_PERM_CHANGE"
+(
+ "CHANGE_ID" NUMBER NOT NULL,
+ "CREATE_TIME_MS" NUMBER NOT NULL,
+ "PERM_CHANGE" VARCHAR2(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID");
+
+-- Table "SENTRY_PATH_CHANGE" for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE "SENTRY_PATH_CHANGE"
+(
+ "CHANGE_ID" NUMBER NOT NULL,
+ "CREATE_TIME_MS" NUMBER NOT NULL,
+ "PATH_CHANGE" VARCHAR2(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PATH_CHANGE" ADD CONSTRAINT SENTRY_PATH_CHANGE_PK PRIMARY KEY ("CHANGE_ID");
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 ce807a5..68d2c8d 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
@@ -233,4 +233,22 @@ ALTER TABLE "MAUTHZPATHSMAPPING_PATHS" ADD CONSTRAINT "MAUTHZPATHSMAPPING_PATHS_
CREATE INDEX "MAUTHZPATHSMAPPING_PATHS_N49" ON "MAUTHZPATHSMAPPING_PATHS" ("AUTHZ_OBJ_ID_OID");
+-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE "SENTRY_PERM_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PERM_CHANGE" VARCHAR(4000) NOT NULL,
+ CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID")
+);
+
+-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE "SENTRY_PATH_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PATH_CHANGE" VARCHAR(4000) NOT NULL,
+ CONSTRAINT "SENTRY_PATH_CHANGE_PK" PRIMARY KEY ("CHANGE_ID")
+);
+
COMMIT;
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 3657377..5376c16 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
@@ -44,7 +44,27 @@ ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN
-- 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);
+CREATE INDEX MAUTHZPATHS184_N49 ON MAUTHZPATHSMAPPING_PATHS (AUTHZ_OBJ_ID_OID);
+
+-- Table `SENTRY_PERM_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPermChange]
+CREATE TABLE "SENTRY_PERM_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PERM_CHANGE" VARCHAR(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PERM_CHANGE" ADD CONSTRAINT "SENTRY_PERM_CHANGE_PK" PRIMARY KEY ("CHANGE_ID");
+
+-- Table `SENTRY_PATH_CHANGE` for classes [org.apache.sentry.provider.db.service.model.MSentryPathChange]
+CREATE TABLE "SENTRY_PATH_CHANGE"
+(
+ "CHANGE_ID" bigint NOT NULL,
+ "CREATE_TIME_MS" bigint NOT NULL,
+ "PATH_CHANGE" VARCHAR(4000) NOT NULL
+);
+
+ALTER TABLE "SENTRY_PATH_CHANGE" ADD CONSTRAINT "SENTRY_PATH_CHANGE_PK" PRIMARY KEY ("CHANGE_ID");
-- Version update
UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.8.0', VERSION_COMMENT='Sentry release version 1.8.0' WHERE VER_ID=1;
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 5d88887..dc3021a 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,6 @@
RUN '006-SENTRY-711.derby.sql';
RUN '007-SENTRY-1365.derby.sql';
+RUN '008-SENTRY-1569.derby.sql';
-- Version update
UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.8.0', VERSION_COMMENT='Sentry release version 1.8.0' WHERE VER_ID=1;
http://git-wip-us.apache.org/repos/asf/sentry/blob/48ec01dd/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 b6108e7..ef1c651 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,6 +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-1365.mysql.sql;
+SOURCE 008-SENTRY-1569.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/48ec01dd/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 d5b7d6e..f4a50de 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,6 +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-1365.oracle.sql;
+@008-SENTRY-1569.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/48ec01dd/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 f0c8cfb..db010bc 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,6 +1,7 @@
SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0';
\i 006-SENTRY-711.postgres.sql;
\i 007-SENTRY-1365.postgres.sql;
+\i 008-SENTRY-1569.postgres.sql;
UPDATE "SENTRY_VERSION" SET "SCHEMA_VERSION"='1.8.0', "VERSION_COMMENT"='Sentry release version 1.8.0' WHERE "VER_ID"=1;