Repository: sentry Updated Branches: refs/heads/sentry-ha-redesign af5c004b6 -> e35d36cd2
SENTRY-1569: Upgrading SQL scripts for persist Perm/Path change (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/e35d36cd Tree: http://git-wip-us.apache.org/repos/asf/sentry/tree/e35d36cd Diff: http://git-wip-us.apache.org/repos/asf/sentry/diff/e35d36cd Branch: refs/heads/sentry-ha-redesign Commit: e35d36cd278dcb496cbf0da142a637d3c2c0034f Parents: af5c004 Author: Alexander Kolbasov <[email protected]> Authored: Mon Mar 6 13:03:23 2017 -0800 Committer: Alexander Kolbasov <[email protected]> Committed: Mon Mar 6 13:03:23 2017 -0800 ---------------------------------------------------------------------- .../src/main/resources/008-SENTRY-1569.derby.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/sentry/blob/e35d36cd/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.sql new file mode 100644 index 0000000..84b7903 --- /dev/null +++ b/sentry-provider/sentry-provider-db/src/main/resources/008-SENTRY-1569.derby.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 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);
