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:03:41 UTC

sentry git commit: SENTRY-1569: Upgrading SQL scripts for persist Perm/Path change (Kalyan Kumar Kalvagadda, Reviewed by: Hao Hao)

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 <ak...@cloudera.com>
Authored: Mon Mar 6 13:03:23 2017 -0800
Committer: Alexander Kolbasov <ak...@cloudera.com>
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);