sentry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ak...@apache.org
Subject sentry git commit: SENTRY-1569: Upgrading SQL scripts for persist Perm/Path change - added missing files (Kalyan Kumar Kalvagadda, Reviewed by: Hao Hao)
Date Mon, 06 Mar 2017 21:18:23 GMT
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 <akolb@cloudera.com>
Authored: Mon Mar 6 13:18:07 2017 -0800
Committer: Alexander Kolbasov <akolb@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;
 


Mime
View raw message