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 <[email protected]> Authored: Tue Feb 7 11:27:08 2017 -0800 Committer: hahao <[email protected]> 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; [email protected]; [email protected]; 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';
