http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.5.0.sql deleted file mode 100644 index fb26770..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.5.0.sql +++ /dev/null @@ -1,182 +0,0 @@ ---Licensed to the Apache Software Foundation (ASF) under one or more ---contributor license agreements. See the NOTICE file distributed with ---this work for additional information regarding copyright ownership. ---The ASF licenses this file to You under the Apache License, Version 2.0 ---(the "License"); you may not use this file except in compliance with ---the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- ---Unless required by applicable law or agreed to in writing, software ---distributed under the License is distributed on an "AS IS" BASIS, ---WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. ---See the License for the specific language governing permissions and ---limitations under the License. - -START TRANSACTION; - -SET statement_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = off; -SET check_function_bodies = false; -SET client_min_messages = warning; -SET escape_string_warning = off; -SET search_path = public, pg_catalog; -SET default_tablespace = ''; -SET default_with_oids = false; - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "PRIVILEGE_SCOPE" character varying(32) NOT NULL, - "SERVER_NAME" character varying(128) NOT NULL, - "DB_NAME" character varying(128) DEFAULT '__NULL__', - "TABLE_NAME" character varying(128) DEFAULT '__NULL__', - "COLUMN_NAME" character varying(128) DEFAULT '__NULL__', - "URI" character varying(4000) DEFAULT '__NULL__', - "ACTION" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" BIGINT NOT NULL, - "ROLE_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" BIGINT NOT NULL, - "GROUP_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GROUP_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" bigint, - "SCHEMA_VERSION" character varying(127) NOT NULL, - "VERSION_COMMENT" character varying(255) NOT NULL -); - - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI", "ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_PRIV_SERV_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("SERVER_NAME"); - -CREATE INDEX "SENTRY_PRIV_DB_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("DB_NAME"); - -CREATE INDEX "SENTRY_PRIV_TBL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("TABLE_NAME"); - -CREATE INDEX "SENTRY_PRIV_COL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_PRIV_URI_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("URI"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_DB_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") DEFERRABLE; - -INSERT INTO "SENTRY_VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '1.5.0', 'Sentry release version 1.5.0'); - --- Generic Model --- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -CREATE TABLE "SENTRY_GM_PRIVILEGE" ( - "GM_PRIVILEGE_ID" BIGINT NOT NULL, - "COMPONENT_NAME" character varying(32) NOT NULL, - "SERVICE_NAME" character varying(64) NOT NULL, - "RESOURCE_NAME_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" character varying(64) DEFAULT '__NULL__', - "ACTION" character varying(32) NOT NULL, - "SCOPE" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); --- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", - "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GM_PRIVILEGE_ID" BIGINT NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GM_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") DEFERRABLE; - -COMMIT;
http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.6.0.sql deleted file mode 100644 index 62edf3e..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.6.0.sql +++ /dev/null @@ -1,182 +0,0 @@ ---Licensed to the Apache Software Foundation (ASF) under one or more ---contributor license agreements. See the NOTICE file distributed with ---this work for additional information regarding copyright ownership. ---The ASF licenses this file to You under the Apache License, Version 2.0 ---(the "License"); you may not use this file except in compliance with ---the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- ---Unless required by applicable law or agreed to in writing, software ---distributed under the License is distributed on an "AS IS" BASIS, ---WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. ---See the License for the specific language governing permissions and ---limitations under the License. - -START TRANSACTION; - -SET statement_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = off; -SET check_function_bodies = false; -SET client_min_messages = warning; -SET escape_string_warning = off; -SET search_path = public, pg_catalog; -SET default_tablespace = ''; -SET default_with_oids = false; - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "PRIVILEGE_SCOPE" character varying(32) NOT NULL, - "SERVER_NAME" character varying(128) NOT NULL, - "DB_NAME" character varying(128) DEFAULT '__NULL__', - "TABLE_NAME" character varying(128) DEFAULT '__NULL__', - "COLUMN_NAME" character varying(128) DEFAULT '__NULL__', - "URI" character varying(4000) DEFAULT '__NULL__', - "ACTION" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" BIGINT NOT NULL, - "ROLE_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" BIGINT NOT NULL, - "GROUP_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GROUP_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" bigint, - "SCHEMA_VERSION" character varying(127) NOT NULL, - "VERSION_COMMENT" character varying(255) NOT NULL -); - - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI", "ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_PRIV_SERV_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("SERVER_NAME"); - -CREATE INDEX "SENTRY_PRIV_DB_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("DB_NAME"); - -CREATE INDEX "SENTRY_PRIV_TBL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("TABLE_NAME"); - -CREATE INDEX "SENTRY_PRIV_COL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_PRIV_URI_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("URI"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_DB_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") DEFERRABLE; - -INSERT INTO "SENTRY_VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '1.6.0', 'Sentry release version 1.6.0'); - --- Generic Model --- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -CREATE TABLE "SENTRY_GM_PRIVILEGE" ( - "GM_PRIVILEGE_ID" BIGINT NOT NULL, - "COMPONENT_NAME" character varying(32) NOT NULL, - "SERVICE_NAME" character varying(64) NOT NULL, - "RESOURCE_NAME_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" character varying(64) DEFAULT '__NULL__', - "ACTION" character varying(32) NOT NULL, - "SCOPE" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); --- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", - "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GM_PRIVILEGE_ID" BIGINT NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GM_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") DEFERRABLE; - -COMMIT; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql deleted file mode 100644 index 9f4f85b..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.7.0.sql +++ /dev/null @@ -1,182 +0,0 @@ ---Licensed to the Apache Software Foundation (ASF) under one or more ---contributor license agreements. See the NOTICE file distributed with ---this work for additional information regarding copyright ownership. ---The ASF licenses this file to You under the Apache License, Version 2.0 ---(the "License"); you may not use this file except in compliance with ---the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- ---Unless required by applicable law or agreed to in writing, software ---distributed under the License is distributed on an "AS IS" BASIS, ---WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. ---See the License for the specific language governing permissions and ---limitations under the License. - -START TRANSACTION; - -SET statement_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = off; -SET check_function_bodies = false; -SET client_min_messages = warning; -SET escape_string_warning = off; -SET search_path = public, pg_catalog; -SET default_tablespace = ''; -SET default_with_oids = false; - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "PRIVILEGE_SCOPE" character varying(32) NOT NULL, - "SERVER_NAME" character varying(128) NOT NULL, - "DB_NAME" character varying(128) DEFAULT '__NULL__', - "TABLE_NAME" character varying(128) DEFAULT '__NULL__', - "COLUMN_NAME" character varying(128) DEFAULT '__NULL__', - "URI" character varying(4000) DEFAULT '__NULL__', - "ACTION" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" BIGINT NOT NULL, - "ROLE_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" BIGINT NOT NULL, - "GROUP_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GROUP_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" bigint, - "SCHEMA_VERSION" character varying(127) NOT NULL, - "VERSION_COMMENT" character varying(255) NOT NULL -); - - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI", "ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_PRIV_SERV_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("SERVER_NAME"); - -CREATE INDEX "SENTRY_PRIV_DB_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("DB_NAME"); - -CREATE INDEX "SENTRY_PRIV_TBL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("TABLE_NAME"); - -CREATE INDEX "SENTRY_PRIV_COL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_PRIV_URI_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("URI"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_DB_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") DEFERRABLE; - -INSERT INTO "SENTRY_VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '1.7.0', 'Sentry release version 1.7.0'); - --- Generic Model --- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -CREATE TABLE "SENTRY_GM_PRIVILEGE" ( - "GM_PRIVILEGE_ID" BIGINT NOT NULL, - "COMPONENT_NAME" character varying(32) NOT NULL, - "SERVICE_NAME" character varying(64) NOT NULL, - "RESOURCE_NAME_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" character varying(64) DEFAULT '__NULL__', - "ACTION" character varying(32) NOT NULL, - "SCOPE" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); --- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", - "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GM_PRIVILEGE_ID" BIGINT NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GM_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") DEFERRABLE; - -COMMIT; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/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 deleted file mode 100644 index 6d56332..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.8.0.sql +++ /dev/null @@ -1,211 +0,0 @@ ---Licensed to the Apache Software Foundation (ASF) under one or more ---contributor license agreements. See the NOTICE file distributed with ---this work for additional information regarding copyright ownership. ---The ASF licenses this file to You under the Apache License, Version 2.0 ---(the "License"); you may not use this file except in compliance with ---the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- ---Unless required by applicable law or agreed to in writing, software ---distributed under the License is distributed on an "AS IS" BASIS, ---WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. ---See the License for the specific language governing permissions and ---limitations under the License. - -START TRANSACTION; - -SET statement_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = off; -SET check_function_bodies = false; -SET client_min_messages = warning; -SET escape_string_warning = off; -SET search_path = public, pg_catalog; -SET default_tablespace = ''; -SET default_with_oids = false; - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "PRIVILEGE_SCOPE" character varying(32) NOT NULL, - "SERVER_NAME" character varying(128) NOT NULL, - "DB_NAME" character varying(128) DEFAULT '__NULL__', - "TABLE_NAME" character varying(128) DEFAULT '__NULL__', - "COLUMN_NAME" character varying(128) DEFAULT '__NULL__', - "URI" character varying(4000) DEFAULT '__NULL__', - "ACTION" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" BIGINT NOT NULL, - "ROLE_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" BIGINT NOT NULL, - "GROUP_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "DB_PRIVILEGE_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GROUP_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" bigint, - "SCHEMA_VERSION" character varying(127) NOT NULL, - "VERSION_COMMENT" character varying(255) NOT NULL -); - - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE ONLY "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("SERVER_NAME","DB_NAME","TABLE_NAME","COLUMN_NAME","URI", "ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_PRIV_SERV_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("SERVER_NAME"); - -CREATE INDEX "SENTRY_PRIV_DB_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("DB_NAME"); - -CREATE INDEX "SENTRY_PRIV_TBL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("TABLE_NAME"); - -CREATE INDEX "SENTRY_PRIV_COL_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_PRIV_URI_IDX" ON "SENTRY_DB_PRIVILEGE" USING btree ("URI"); - -ALTER TABLE ONLY "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE ONLY "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_DB_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GROUP_MAP_PK" PRIMARY KEY ("ROLE_ID","GROUP_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_DB_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("DB_PRIVILEGE_ID") REFERENCES "SENTRY_DB_PRIVILEGE"("DB_PRIVILEGE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") DEFERRABLE; - -INSERT INTO "SENTRY_VERSION" ("VER_ID", "SCHEMA_VERSION", "VERSION_COMMENT") VALUES (1, '1.8.0', 'Sentry release version 1.8.0'); - --- Generic Model --- Table SENTRY_GM_PRIVILEGE for classes [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -CREATE TABLE "SENTRY_GM_PRIVILEGE" ( - "GM_PRIVILEGE_ID" BIGINT NOT NULL, - "COMPONENT_NAME" character varying(32) NOT NULL, - "SERVICE_NAME" character varying(64) NOT NULL, - "RESOURCE_NAME_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" character varying(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" character varying(64) DEFAULT '__NULL__', - "ACTION" character varying(32) NOT NULL, - "SCOPE" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) NOT NULL -); -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PK" PRIMARY KEY ("GM_PRIVILEGE_ID"); --- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -ALTER TABLE ONLY "SENTRY_GM_PRIVILEGE" - ADD CONSTRAINT "SENTRY_GM_PRIV_PRIV_NAME_UNIQ" UNIQUE ("COMPONENT_NAME","SERVICE_NAME","RESOURCE_NAME_0","RESOURCE_NAME_1","RESOURCE_NAME_2", - "RESOURCE_NAME_3","RESOURCE_TYPE_0","RESOURCE_TYPE_1","RESOURCE_TYPE_2","RESOURCE_TYPE_3","ACTION","WITH_GRANT_OPTION"); - -CREATE INDEX "SENTRY_GM_PRIV_COMP_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" USING btree ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GM_PRIVILEGE_ID" BIGINT NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SENTRY_ROLE_GM_PRIVILEGE_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RL_GM_PRV_MAP_SN_DB_PRV_FK" - FOREIGN KEY ("GM_PRIVILEGE_ID") REFERENCES "SENTRY_GM_PRIVILEGE"("GM_PRIVILEGE_ID") DEFERRABLE; - -CREATE TABLE "SENTRY_USER" ( - "USER_ID" BIGINT NOT NULL, - "USER_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL -); - -ALTER TABLE ONLY "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_PK" PRIMARY KEY ("USER_ID"); - -ALTER TABLE ONLY "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_USER_NAME_UNIQUE" UNIQUE ("USER_NAME"); - -CREATE TABLE "SENTRY_ROLE_USER_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "USER_ID" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) -); - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SENTRY_ROLE_USER_MAP_PK" PRIMARY KEY ("ROLE_ID","USER_ID"); - -ALTER TABLE ONLY "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") DEFERRABLE; - -ALTER TABLE ONLY "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_USER_FK" - FOREIGN KEY ("USER_ID") REFERENCES "SENTRY_USER"("USER_ID") DEFERRABLE; - -COMMIT; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql deleted file mode 100644 index 26721c9..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.4.0-to-1.5.0.sql +++ /dev/null @@ -1,61 +0,0 @@ --- SENTRY-327 -ALTER TABLE SENTRY_DB_PRIVILEGE ADD WITH_GRANT_OPTION CHAR(1) NOT NULL; - --- SENTRY-339 -DROP INDEX SENTRYPRIVILEGENAME; -CREATE UNIQUE INDEX SENTRYPRIVILEGENAME ON SENTRY_DB_PRIVILEGE ("SERVER_NAME",DB_NAME,"TABLE_NAME",URI,"ACTION",WITH_GRANT_OPTION); -ALTER TABLE SENTRY_DB_PRIVILEGE DROP PRIVILEGE_NAME; - --- SENTRY-380 -ALTER TABLE `SENTRY_DB_PRIVILEGE` DROP `GRANTOR_PRINCIPAL`; -ALTER TABLE `SENTRY_ROLE` DROP `GRANTOR_PRINCIPAL`; -ALTER TABLE `SENTRY_GROUP` DROP `GRANTOR_PRINCIPAL`; - -ALTER TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128); -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` ADD `GRANTOR_PRINCIPAL` VARCHAR(128); - --- SENTRY-74 -ALTER TABLE `SENTRY_DB_PRIVILEGE` ADD `COLUMN_NAME` CHAR(4000); -DROP INDEX SENTRYPRIVILEGENAME; -CREATE UNIQUE INDEX SENTRYPRIVILEGENAME ON SENTRY_DB_PRIVILEGE ("SERVER_NAME",DB_NAME,"TABLE_NAME","COLUMN_NAME",URI,"ACTION",WITH_GRANT_OPTION); - --- SENTRY-398 -CREATE TABLE SENTRY_GM_PRIVILEGE -( - GM_PRIVILEGE_ID BIGINT NOT NULL, - "ACTION" VARCHAR(40), - COMPONENT_NAME VARCHAR(400), - CREATE_TIME BIGINT NOT NULL, - WITH_GRANT_OPTION CHAR(1), - RESOURCE_NAME_0 VARCHAR(400), - RESOURCE_NAME_1 VARCHAR(400), - RESOURCE_NAME_2 VARCHAR(400), - RESOURCE_NAME_3 VARCHAR(400), - RESOURCE_TYPE_0 VARCHAR(400), - RESOURCE_TYPE_1 VARCHAR(400), - RESOURCE_TYPE_2 VARCHAR(400), - RESOURCE_TYPE_3 VARCHAR(400), - "SCOPE" VARCHAR(40), - SERVICE_NAME VARCHAR(400) -); -ALTER TABLE SENTRY_GM_PRIVILEGE ADD CONSTRAINT SENTRY_GM_PRIVILEGE_PK PRIMARY KEY (GM_PRIVILEGE_ID); - -CREATE UNIQUE INDEX GM_PRIVILEGE_INDEX ON SENTRY_GM_PRIVILEGE (COMPONENT_NAME,SERVICE_NAME,RESOURCE_NAME_0,RESOURCE_TYPE_0,RESOURCE_NAME_1,RESOURCE_TYPE_1,RESOURCE_NAME_2,RESOURCE_TYPE_2,RESOURCE_NAME_3,RESOURCE_TYPE_3,"ACTION",WITH_GRANT_OPTION); - -CREATE TABLE SENTRY_ROLE_GM_PRIVILEGE_MAP -( - ROLE_ID BIGINT NOT NULL, - GM_PRIVILEGE_ID BIGINT NOT NULL -); -ALTER TABLE SENTRY_ROLE_GM_PRIVILEGE_MAP ADD CONSTRAINT SENTRY_ROLE_GM_PRIVILEGE_MAP_PK PRIMARY KEY (ROLE_ID,GM_PRIVILEGE_ID); - -CREATE INDEX SENTRY_ROLE_GM_PRIVILEGE_MAP_N50 ON SENTRY_ROLE_GM_PRIVILEGE_MAP (ROLE_ID); - -CREATE INDEX SENTRY_ROLE_GM_PRIVILEGE_MAP_N49 ON SENTRY_ROLE_GM_PRIVILEGE_MAP (GM_PRIVILEGE_ID); - -ALTER TABLE SENTRY_ROLE_GM_PRIVILEGE_MAP ADD CONSTRAINT SENTRY_ROLE_GM_PRIVILEGE_MAP_FK2 FOREIGN KEY (GM_PRIVILEGE_ID) REFERENCES SENTRY_GM_PRIVILEGE (GM_PRIVILEGE_ID); - -ALTER TABLE SENTRY_ROLE_GM_PRIVILEGE_MAP ADD CONSTRAINT SENTRY_ROLE_GM_PRIVILEGE_MAP_FK1 FOREIGN KEY (ROLE_ID) REFERENCES SENTRY_ROLE (ROLE_ID); - --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.5.0-to-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.5.0-to-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.5.0-to-1.6.0.sql deleted file mode 100644 index 5560d9f..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.5.0-to-1.6.0.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.6.0', VERSION_COMMENT='Sentry release version 1.6.0' WHERE VER_ID=1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.6.0-to-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.6.0-to-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.6.0-to-1.7.0.sql deleted file mode 100644 index e2494a2..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.6.0-to-1.7.0.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.7.0', VERSION_COMMENT='Sentry release version 1.7.0' WHERE VER_ID=1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/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 deleted file mode 100644 index 927f302..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-db2-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,31 +0,0 @@ --- SENTRY-711 -CREATE TABLE SENTRY_USER -( - USER_ID BIGINT NOT NULL generated always as identity (start with 1), - CREATE_TIME BIGINT NOT NULL, - USER_NAME VARCHAR(128) -); - -ALTER TABLE SENTRY_USER ADD CONSTRAINT SENTRY_USER_PK PRIMARY KEY (USER_ID); - -CREATE UNIQUE INDEX SENTRYUSERNAME ON SENTRY_USER (USER_NAME); - -CREATE TABLE SENTRY_ROLE_USER_MAP -( - USER_ID BIGINT NOT NULL, - ROLE_ID BIGINT NOT NULL, - GRANTOR_PRINCIPAL VARCHAR(128) -); - -ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_PK PRIMARY KEY (USER_ID,ROLE_ID); - -CREATE INDEX SENTRY_ROLE_USER_MAP_N49 ON SENTRY_ROLE_USER_MAP (USER_ID); - -CREATE INDEX SENTRY_ROLE_USER_MAP_N50 ON SENTRY_ROLE_USER_MAP (ROLE_ID); - -ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK2 FOREIGN KEY (ROLE_ID) REFERENCES SENTRY_ROLE (ROLE_ID) ; - -ALTER TABLE SENTRY_ROLE_USER_MAP ADD CONSTRAINT SENTRY_ROLE_USER_MAP_FK1 FOREIGN KEY (USER_ID) REFERENCES SENTRY_USER (USER_ID) ; - --- 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 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql deleted file mode 100644 index bc06849..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.4.0-to-1.5.0.sql +++ /dev/null @@ -1,8 +0,0 @@ -RUN '001-SENTRY-327.derby.sql'; -RUN '002-SENTRY-339.derby.sql'; -RUN '003-SENTRY-380.derby.sql'; -RUN '004-SENTRY-74.derby.sql'; -RUN '005-SENTRY-398.derby.sql'; - --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.5.0-to-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.5.0-to-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.5.0-to-1.6.0.sql deleted file mode 100644 index 5560d9f..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.5.0-to-1.6.0.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.6.0', VERSION_COMMENT='Sentry release version 1.6.0' WHERE VER_ID=1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.6.0-to-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.6.0-to-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.6.0-to-1.7.0.sql deleted file mode 100644 index e2494a2..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.6.0-to-1.7.0.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Version update -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.7.0', VERSION_COMMENT='Sentry release version 1.7.0' WHERE VER_ID=1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/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 deleted file mode 100644 index fbe2dc8..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-derby-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,4 +0,0 @@ -RUN '006-SENTRY-711.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 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql deleted file mode 100644 index a7bc9d0..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.4.0-to-1.5.0.sql +++ /dev/null @@ -1,10 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.4.0 to 1.5.0' AS ' '; -SOURCE 001-SENTRY-327.mysql.sql; -SOURCE 002-SENTRY-339.mysql.sql; -SOURCE 003-SENTRY-380.mysql.sql; -SOURCE 004-SENTRY-74.mysql.sql; -SOURCE 005-SENTRY-398.mysql.sql; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; -SELECT 'Finish upgrading Sentry store schema from 1.4.0 to 1.5.0' AS ' '; - http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.5.0-to-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.5.0-to-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.5.0-to-1.6.0.sql deleted file mode 100644 index 352332c..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.5.0-to-1.6.0.sql +++ /dev/null @@ -1,5 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.5.0 to 1.6.0' AS ' '; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.6.0', VERSION_COMMENT='Sentry release version 1.6.0' WHERE VER_ID=1; - -SELECT 'Finish upgrading Sentry store schema from 1.5.0 to 1.6.0' AS ' '; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.6.0-to-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.6.0-to-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.6.0-to-1.7.0.sql deleted file mode 100644 index 3413ede..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.6.0-to-1.7.0.sql +++ /dev/null @@ -1,5 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.6.0 to 1.7.0' AS ' '; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.7.0', VERSION_COMMENT='Sentry release version 1.7.0' WHERE VER_ID=1; - -SELECT 'Finish upgrading Sentry store schema from 1.6.0 to 1.7.0' AS ' '; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/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 deleted file mode 100644 index f0df187..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-mysql-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0' AS ' '; -SOURCE 006-SENTRY-711.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 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql deleted file mode 100644 index 9526366..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.4.0-to-1.5.0.sql +++ /dev/null @@ -1,9 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.4.0 to 1.5.0' AS Status from dual; [email protected]; [email protected]; [email protected]; [email protected]; [email protected]; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.5.0', VERSION_COMMENT='Sentry release version 1.5.0' WHERE VER_ID=1; -SELECT 'Finished upgrading Sentry store schema from 1.4.0 to 1.5.0' AS Status from dual; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.5.0-to-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.5.0-to-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.5.0-to-1.6.0.sql deleted file mode 100644 index 3437075..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.5.0-to-1.6.0.sql +++ /dev/null @@ -1,5 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.5.0 to 1.6.0' AS Status from dual; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.6.0', VERSION_COMMENT='Sentry release version 1.6.0' WHERE VER_ID=1; - -SELECT 'Finished upgrading Sentry store schema from 1.5.0 to 1.6.0' AS Status from dual; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.6.0-to-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.6.0-to-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.6.0-to-1.7.0.sql deleted file mode 100644 index fa82c87..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.6.0-to-1.7.0.sql +++ /dev/null @@ -1,5 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.6.0 to 1.7.0' AS Status from dual; - -UPDATE SENTRY_VERSION SET SCHEMA_VERSION='1.7.0', VERSION_COMMENT='Sentry release version 1.7.0' WHERE VER_ID=1; - -SELECT 'Finished upgrading Sentry store schema from 1.6.0 to 1.7.0' AS Status from dual; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/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 deleted file mode 100644 index f1666be..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-oracle-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0' AS Status from dual; [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 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql deleted file mode 100644 index 2f03d5e..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.4.0-to-1.5.0.sql +++ /dev/null @@ -1,9 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.4.0 to 1.5.0'; -\i 001-SENTRY-327.postgres.sql; -\i 002-SENTRY-339.postgres.sql; -\i 003-SENTRY-380.postgres.sql; -\i 004-SENTRY-74.postgres.sql; -\i 005-SENTRY-398.postgres.sql; - -UPDATE "SENTRY_VERSION" SET "SCHEMA_VERSION"='1.5.0', "VERSION_COMMENT"='Sentry release version 1.5.0' WHERE "VER_ID"=1; -SELECT 'Finished upgrading Sentry store schema from 1.4.0 to 1.5.0'; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.5.0-to-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.5.0-to-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.5.0-to-1.6.0.sql deleted file mode 100644 index 5982596..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.5.0-to-1.6.0.sql +++ /dev/null @@ -1,5 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.5.0 to 1.6.0'; - -UPDATE "SENTRY_VERSION" SET "SCHEMA_VERSION"='1.6.0', "VERSION_COMMENT"='Sentry release version 1.6.0' WHERE "VER_ID"=1; - -SELECT 'Finished upgrading Sentry store schema from 1.5.0 to 1.6.0'; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.6.0-to-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.6.0-to-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.6.0-to-1.7.0.sql deleted file mode 100644 index ff10e10..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.6.0-to-1.7.0.sql +++ /dev/null @@ -1,5 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.6.0 to 1.7.0'; - -UPDATE "SENTRY_VERSION" SET "SCHEMA_VERSION"='1.7.0', "VERSION_COMMENT"='Sentry release version 1.7.0' WHERE "VER_ID"=1; - -SELECT 'Finished upgrading Sentry store schema from 1.6.0 to 1.7.0'; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/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 deleted file mode 100644 index b39292d..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-upgrade-postgres-1.7.0-to-1.8.0.sql +++ /dev/null @@ -1,6 +0,0 @@ -SELECT 'Upgrading Sentry store schema from 1.7.0 to 1.8.0'; -\i 006-SENTRY-711.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 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 deleted file mode 100644 index 8da8c9c..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.db2 +++ /dev/null @@ -1,4 +0,0 @@ -1.4.0-to-1.5.0 -1.5.0-to-1.6.0 -1.6.0-to-1.7.0 -1.7.0-to-1.8.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby deleted file mode 100644 index 8da8c9c..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.derby +++ /dev/null @@ -1,4 +0,0 @@ -1.4.0-to-1.5.0 -1.5.0-to-1.6.0 -1.6.0-to-1.7.0 -1.7.0-to-1.8.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql deleted file mode 100644 index 8da8c9c..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.mysql +++ /dev/null @@ -1,4 +0,0 @@ -1.4.0-to-1.5.0 -1.5.0-to-1.6.0 -1.6.0-to-1.7.0 -1.7.0-to-1.8.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle deleted file mode 100644 index 8da8c9c..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.oracle +++ /dev/null @@ -1,4 +0,0 @@ -1.4.0-to-1.5.0 -1.5.0-to-1.6.0 -1.6.0-to-1.7.0 -1.7.0-to-1.8.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres b/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres deleted file mode 100644 index 8da8c9c..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/upgrade.order.postgres +++ /dev/null @@ -1,4 +0,0 @@ -1.4.0-to-1.5.0 -1.5.0-to-1.6.0 -1.6.0-to-1.7.0 -1.7.0-to-1.8.0 http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html b/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html deleted file mode 100644 index 9eb5f0e..0000000 --- a/sentry-provider/sentry-provider-db/src/main/webapp/SentryService.html +++ /dev/null @@ -1,61 +0,0 @@ -<!-- -Licensed to the Apache Software Foundation (ASF) under one or more -contributor license agreements. See the NOTICE file distributed with -this work for additional information regarding copyright ownership. -The ASF licenses this file to You under the Apache License, Version 2.0 -(the "License"); you may not use this file except in compliance with -the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - -Unless required by applicable law or agreed to in writing, software -distributed under the License is distributed on an "AS IS" BASIS, -WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -See the License for the specific language governing permissions and -limitations under the License. ---> -<!DOCTYPE HTML> -<html lang="en"> - <head> - <meta charset="utf-8"> - <title>Sentry Service</title> - <meta name="viewport" content="width=device-width, initial-scale=1.0"> - <meta name="description" content=""> - <link href="css/bootstrap.min.css" rel="stylesheet"> - <link href="css/bootstrap-theme.min.css" rel="stylesheet"> - <link href="css/sentry.css" rel="stylesheet"> - </head> - - <body> - <nav class="navbar navbar-default navbar-fixed-top"> - <div class="container"> - <div class="navbar-header"> - <a class="navbar-brand" href="#"><img src="sentry.png" alt="Sentry Logo"/></a> - </div> - <div class="collapse navbar-collapse"> - <ul class="nav navbar-nav"> - <li class="active"><a href="#">Home</a></li> - <li><a href="/metrics?pretty=true">Metrics</a></li> - <li><a href="/threads">Threads</a></li> - <li><a href="/conf">Configuration</a></li> - </ul> - </div> - </div> - </nav> - - <div class="container"> - <div class="page-header"><h2>Sentry Service</h2></div> - <ul> - <li><a href="/metrics?pretty=true">Metrics</a></li> - <li><a href="/threads">Threads</a></li> - <li><a href="/conf">Configuration</a></li> - </ul> - </div> - - <footer class="footer"> - <div class="container"> - <p class="text-muted">SENTRY 1.8.0-SNAPSHOT</p> - </div> - </footer> - </body> -</html> http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/webapp/css/bootstrap-theme.min.css ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/webapp/css/bootstrap-theme.min.css b/sentry-provider/sentry-provider-db/src/main/webapp/css/bootstrap-theme.min.css deleted file mode 100644 index c31428b..0000000 --- a/sentry-provider/sentry-provider-db/src/main/webapp/css/bootstrap-theme.min.css +++ /dev/null @@ -1,10 +0,0 @@ -/*! - * Bootstrap v3.0.0 - * - * Copyright 2013 Twitter, Inc - * Licensed under the Apache License v2.0 - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Designed and built with all the love in the world by @mdo and @fat. - */ -.btn-default,.btn-primary,.btn-success,.btn-info,.btn-warning,.btn-danger{text-shadow:0 -1px 0 rgba(0,0,0,0.2);-webkit-box-shadow:inset 0 1px 0 rgba(255,255,255,0.15),0 1px 1px rgba(0,0,0,0.075);box-shadow:inset 0 1px 0 rgba(255,255,255,0.15),0 1px 1px rgba(0,0,0,0.075)}.btn-default:active,.btn-primary:active,.btn-success:active,.btn-info:active,.btn-warning:active,.btn-danger:active,.btn-default.active,.btn-primary.active,.btn-success.active,.btn-info.active,.btn-warning.active,.btn-danger.active{-webkit-box-shadow:inset 0 3px 5px rgba(0,0,0,0.125);box-shadow:inset 0 3px 5px rgba(0,0,0,0.125)}.btn:active,.btn.active{background-image:none}.btn-default{text-shadow:0 1px 0 #fff;background-image:-webkit-gradient(linear,left 0,left 100%,from(#fff),to(#e6e6e6));background-image:-webkit-linear-gradient(top,#fff,0%,#e6e6e6,100%);background-image:-moz-linear-gradient(top,#fff 0,#e6e6e6 100%);background-image:linear-gradient(to bottom,#fff 0,#e6e6e6 100%);background-repeat:repeat-x;border-co lor:#e0e0e0;border-color:#ccc;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffffffff',endColorstr='#ffe6e6e6',GradientType=0)}.btn-default:active,.btn-default.active{background-color:#e6e6e6;border-color:#e0e0e0}.btn-primary{background-image:-webkit-gradient(linear,left 0,left 100%,from(#428bca),to(#3071a9));background-image:-webkit-linear-gradient(top,#428bca,0%,#3071a9,100%);background-image:-moz-linear-gradient(top,#428bca 0,#3071a9 100%);background-image:linear-gradient(to bottom,#428bca 0,#3071a9 100%);background-repeat:repeat-x;border-color:#2d6ca2;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff428bca',endColorstr='#ff3071a9',GradientType=0)}.btn-primary:active,.btn-primary.active{background-color:#3071a9;border-color:#2d6ca2}.btn-success{background-image:-webkit-gradient(linear,left 0,left 100%,from(#5cb85c),to(#449d44));background-image:-webkit-linear-gradient(top,#5cb85c,0%,#449d44,100%);background-image:-moz-linear-gradient(top,#5cb 85c 0,#449d44 100%);background-image:linear-gradient(to bottom,#5cb85c 0,#449d44 100%);background-repeat:repeat-x;border-color:#419641;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff5cb85c',endColorstr='#ff449d44',GradientType=0)}.btn-success:active,.btn-success.active{background-color:#449d44;border-color:#419641}.btn-warning{background-image:-webkit-gradient(linear,left 0,left 100%,from(#f0ad4e),to(#ec971f));background-image:-webkit-linear-gradient(top,#f0ad4e,0%,#ec971f,100%);background-image:-moz-linear-gradient(top,#f0ad4e 0,#ec971f 100%);background-image:linear-gradient(to bottom,#f0ad4e 0,#ec971f 100%);background-repeat:repeat-x;border-color:#eb9316;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#fff0ad4e',endColorstr='#ffec971f',GradientType=0)}.btn-warning:active,.btn-warning.active{background-color:#ec971f;border-color:#eb9316}.btn-danger{background-image:-webkit-gradient(linear,left 0,left 100%,from(#d9534f),to(#c9302c));background-i mage:-webkit-linear-gradient(top,#d9534f,0%,#c9302c,100%);background-image:-moz-linear-gradient(top,#d9534f 0,#c9302c 100%);background-image:linear-gradient(to bottom,#d9534f 0,#c9302c 100%);background-repeat:repeat-x;border-color:#c12e2a;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffd9534f',endColorstr='#ffc9302c',GradientType=0)}.btn-danger:active,.btn-danger.active{background-color:#c9302c;border-color:#c12e2a}.btn-info{background-image:-webkit-gradient(linear,left 0,left 100%,from(#5bc0de),to(#31b0d5));background-image:-webkit-linear-gradient(top,#5bc0de,0%,#31b0d5,100%);background-image:-moz-linear-gradient(top,#5bc0de 0,#31b0d5 100%);background-image:linear-gradient(to bottom,#5bc0de 0,#31b0d5 100%);background-repeat:repeat-x;border-color:#2aabd2;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff5bc0de',endColorstr='#ff31b0d5',GradientType=0)}.btn-info:active,.btn-info.active{background-color:#31b0d5;border-color:#2aabd2}.thumbnail,.img- thumbnail{-webkit-box-shadow:0 1px 2px rgba(0,0,0,0.075);box-shadow:0 1px 2px rgba(0,0,0,0.075)}.dropdown-menu>li>a:hover,.dropdown-menu>li>a:focus,.dropdown-menu>.active>a,.dropdown-menu>.active>a:hover,.dropdown-menu>.active>a:focus{background-color:#357ebd;background-image:-webkit-gradient(linear,left 0,left 100%,from(#428bca),to(#357ebd));background-image:-webkit-linear-gradient(top,#428bca,0%,#357ebd,100%);background-image:-moz-linear-gradient(top,#428bca 0,#357ebd 100%);background-image:linear-gradient(to bottom,#428bca 0,#357ebd 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff428bca',endColorstr='#ff357ebd',GradientType=0)}.navbar{background-image:-webkit-gradient(linear,left 0,left 100%,from(#fff),to(#f8f8f8));background-image:-webkit-linear-gradient(top,#fff,0%,#f8f8f8,100%);background-image:-moz-linear-gradient(top,#fff 0,#f8f8f8 100%);background-image:linear-gradient(to bottom,#fff 0,#f8f8f8 100%);background-repeat:repe at-x;border-radius:4px;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffffffff',endColorstr='#fff8f8f8',GradientType=0);-webkit-box-shadow:inset 0 1px 0 rgba(255,255,255,0.15),0 1px 5px rgba(0,0,0,0.075);box-shadow:inset 0 1px 0 rgba(255,255,255,0.15),0 1px 5px rgba(0,0,0,0.075)}.navbar .navbar-nav>.active>a{background-color:#f8f8f8}.navbar-brand,.navbar-nav>li>a{text-shadow:0 1px 0 rgba(255,255,255,0.25)}.navbar-inverse{background-image:-webkit-gradient(linear,left 0,left 100%,from(#3c3c3c),to(#222));background-image:-webkit-linear-gradient(top,#3c3c3c,0%,#222,100%);background-image:-moz-linear-gradient(top,#3c3c3c 0,#222 100%);background-image:linear-gradient(to bottom,#3c3c3c 0,#222 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff3c3c3c',endColorstr='#ff222222',GradientType=0)}.navbar-inverse .navbar-nav>.active>a{background-color:#222}.navbar-inverse .navbar-brand,.navbar-inverse .navbar-nav>li>a{text-shadow :0 -1px 0 rgba(0,0,0,0.25)}.navbar-static-top,.navbar-fixed-top,.navbar-fixed-bottom{border-radius:0}.alert{text-shadow:0 1px 0 rgba(255,255,255,0.2);-webkit-box-shadow:inset 0 1px 0 rgba(255,255,255,0.25),0 1px 2px rgba(0,0,0,0.05);box-shadow:inset 0 1px 0 rgba(255,255,255,0.25),0 1px 2px rgba(0,0,0,0.05)}.alert-success{background-image:-webkit-gradient(linear,left 0,left 100%,from(#dff0d8),to(#c8e5bc));background-image:-webkit-linear-gradient(top,#dff0d8,0%,#c8e5bc,100%);background-image:-moz-linear-gradient(top,#dff0d8 0,#c8e5bc 100%);background-image:linear-gradient(to bottom,#dff0d8 0,#c8e5bc 100%);background-repeat:repeat-x;border-color:#b2dba1;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffdff0d8',endColorstr='#ffc8e5bc',GradientType=0)}.alert-info{background-image:-webkit-gradient(linear,left 0,left 100%,from(#d9edf7),to(#b9def0));background-image:-webkit-linear-gradient(top,#d9edf7,0%,#b9def0,100%);background-image:-moz-linear-gradient(top,#d9edf7 0,#b9 def0 100%);background-image:linear-gradient(to bottom,#d9edf7 0,#b9def0 100%);background-repeat:repeat-x;border-color:#9acfea;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffd9edf7',endColorstr='#ffb9def0',GradientType=0)}.alert-warning{background-image:-webkit-gradient(linear,left 0,left 100%,from(#fcf8e3),to(#f8efc0));background-image:-webkit-linear-gradient(top,#fcf8e3,0%,#f8efc0,100%);background-image:-moz-linear-gradient(top,#fcf8e3 0,#f8efc0 100%);background-image:linear-gradient(to bottom,#fcf8e3 0,#f8efc0 100%);background-repeat:repeat-x;border-color:#f5e79e;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#fffcf8e3',endColorstr='#fff8efc0',GradientType=0)}.alert-danger{background-image:-webkit-gradient(linear,left 0,left 100%,from(#f2dede),to(#e7c3c3));background-image:-webkit-linear-gradient(top,#f2dede,0%,#e7c3c3,100%);background-image:-moz-linear-gradient(top,#f2dede 0,#e7c3c3 100%);background-image:linear-gradient(to bottom,#f2dede 0, #e7c3c3 100%);background-repeat:repeat-x;border-color:#dca7a7;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#fff2dede',endColorstr='#ffe7c3c3',GradientType=0)}.progress{background-image:-webkit-gradient(linear,left 0,left 100%,from(#ebebeb),to(#f5f5f5));background-image:-webkit-linear-gradient(top,#ebebeb,0%,#f5f5f5,100%);background-image:-moz-linear-gradient(top,#ebebeb 0,#f5f5f5 100%);background-image:linear-gradient(to bottom,#ebebeb 0,#f5f5f5 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffebebeb',endColorstr='#fff5f5f5',GradientType=0)}.progress-bar{background-image:-webkit-gradient(linear,left 0,left 100%,from(#428bca),to(#3071a9));background-image:-webkit-linear-gradient(top,#428bca,0%,#3071a9,100%);background-image:-moz-linear-gradient(top,#428bca 0,#3071a9 100%);background-image:linear-gradient(to bottom,#428bca 0,#3071a9 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient (startColorstr='#ff428bca',endColorstr='#ff3071a9',GradientType=0)}.progress-bar-success{background-image:-webkit-gradient(linear,left 0,left 100%,from(#5cb85c),to(#449d44));background-image:-webkit-linear-gradient(top,#5cb85c,0%,#449d44,100%);background-image:-moz-linear-gradient(top,#5cb85c 0,#449d44 100%);background-image:linear-gradient(to bottom,#5cb85c 0,#449d44 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff5cb85c',endColorstr='#ff449d44',GradientType=0)}.progress-bar-info{background-image:-webkit-gradient(linear,left 0,left 100%,from(#5bc0de),to(#31b0d5));background-image:-webkit-linear-gradient(top,#5bc0de,0%,#31b0d5,100%);background-image:-moz-linear-gradient(top,#5bc0de 0,#31b0d5 100%);background-image:linear-gradient(to bottom,#5bc0de 0,#31b0d5 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff5bc0de',endColorstr='#ff31b0d5',GradientType=0)}.progress-bar-warning{backg round-image:-webkit-gradient(linear,left 0,left 100%,from(#f0ad4e),to(#ec971f));background-image:-webkit-linear-gradient(top,#f0ad4e,0%,#ec971f,100%);background-image:-moz-linear-gradient(top,#f0ad4e 0,#ec971f 100%);background-image:linear-gradient(to bottom,#f0ad4e 0,#ec971f 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#fff0ad4e',endColorstr='#ffec971f',GradientType=0)}.progress-bar-danger{background-image:-webkit-gradient(linear,left 0,left 100%,from(#d9534f),to(#c9302c));background-image:-webkit-linear-gradient(top,#d9534f,0%,#c9302c,100%);background-image:-moz-linear-gradient(top,#d9534f 0,#c9302c 100%);background-image:linear-gradient(to bottom,#d9534f 0,#c9302c 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffd9534f',endColorstr='#ffc9302c',GradientType=0)}.list-group{border-radius:4px;-webkit-box-shadow:0 1px 2px rgba(0,0,0,0.075);box-shadow:0 1px 2px rgba(0,0,0,0.075)}.li st-group-item.active,.list-group-item.active:hover,.list-group-item.active:focus{text-shadow:0 -1px 0 #3071a9;background-image:-webkit-gradient(linear,left 0,left 100%,from(#428bca),to(#3278b3));background-image:-webkit-linear-gradient(top,#428bca,0%,#3278b3,100%);background-image:-moz-linear-gradient(top,#428bca 0,#3278b3 100%);background-image:linear-gradient(to bottom,#428bca 0,#3278b3 100%);background-repeat:repeat-x;border-color:#3278b3;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff428bca',endColorstr='#ff3278b3',GradientType=0)}.panel{-webkit-box-shadow:0 1px 2px rgba(0,0,0,0.05);box-shadow:0 1px 2px rgba(0,0,0,0.05)}.panel-default>.panel-heading{background-image:-webkit-gradient(linear,left 0,left 100%,from(#f5f5f5),to(#e8e8e8));background-image:-webkit-linear-gradient(top,#f5f5f5,0%,#e8e8e8,100%);background-image:-moz-linear-gradient(top,#f5f5f5 0,#e8e8e8 100%);background-image:linear-gradient(to bottom,#f5f5f5 0,#e8e8e8 100%);background-repeat:repeat-x ;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#fff5f5f5',endColorstr='#ffe8e8e8',GradientType=0)}.panel-primary>.panel-heading{background-image:-webkit-gradient(linear,left 0,left 100%,from(#428bca),to(#357ebd));background-image:-webkit-linear-gradient(top,#428bca,0%,#357ebd,100%);background-image:-moz-linear-gradient(top,#428bca 0,#357ebd 100%);background-image:linear-gradient(to bottom,#428bca 0,#357ebd 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ff428bca',endColorstr='#ff357ebd',GradientType=0)}.panel-success>.panel-heading{background-image:-webkit-gradient(linear,left 0,left 100%,from(#dff0d8),to(#d0e9c6));background-image:-webkit-linear-gradient(top,#dff0d8,0%,#d0e9c6,100%);background-image:-moz-linear-gradient(top,#dff0d8 0,#d0e9c6 100%);background-image:linear-gradient(to bottom,#dff0d8 0,#d0e9c6 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffdff0d8 ',endColorstr='#ffd0e9c6',GradientType=0)}.panel-info>.panel-heading{background-image:-webkit-gradient(linear,left 0,left 100%,from(#d9edf7),to(#c4e3f3));background-image:-webkit-linear-gradient(top,#d9edf7,0%,#c4e3f3,100%);background-image:-moz-linear-gradient(top,#d9edf7 0,#c4e3f3 100%);background-image:linear-gradient(to bottom,#d9edf7 0,#c4e3f3 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffd9edf7',endColorstr='#ffc4e3f3',GradientType=0)}.panel-warning>.panel-heading{background-image:-webkit-gradient(linear,left 0,left 100%,from(#fcf8e3),to(#faf2cc));background-image:-webkit-linear-gradient(top,#fcf8e3,0%,#faf2cc,100%);background-image:-moz-linear-gradient(top,#fcf8e3 0,#faf2cc 100%);background-image:linear-gradient(to bottom,#fcf8e3 0,#faf2cc 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#fffcf8e3',endColorstr='#fffaf2cc',GradientType=0)}.panel-danger>.panel-heading{backgro und-image:-webkit-gradient(linear,left 0,left 100%,from(#f2dede),to(#ebcccc));background-image:-webkit-linear-gradient(top,#f2dede,0%,#ebcccc,100%);background-image:-moz-linear-gradient(top,#f2dede 0,#ebcccc 100%);background-image:linear-gradient(to bottom,#f2dede 0,#ebcccc 100%);background-repeat:repeat-x;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#fff2dede',endColorstr='#ffebcccc',GradientType=0)}.well{background-image:-webkit-gradient(linear,left 0,left 100%,from(#e8e8e8),to(#f5f5f5));background-image:-webkit-linear-gradient(top,#e8e8e8,0%,#f5f5f5,100%);background-image:-moz-linear-gradient(top,#e8e8e8 0,#f5f5f5 100%);background-image:linear-gradient(to bottom,#e8e8e8 0,#f5f5f5 100%);background-repeat:repeat-x;border-color:#dcdcdc;filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffe8e8e8',endColorstr='#fff5f5f5',GradientType=0);-webkit-box-shadow:inset 0 1px 3px rgba(0,0,0,0.05),0 1px 0 rgba(255,255,255,0.1);box-shadow:inset 0 1px 3px rgba(0 ,0,0,0.05),0 1px 0 rgba(255,255,255,0.1)} \ No newline at end of file
