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 <[email protected]> Authored: Mon Mar 6 13:18:07 2017 -0800 Committer: Alexander Kolbasov <[email protected]> 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; [email protected]; 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;
