http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.4.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.4.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.4.0.sql deleted file mode 100644 index 70f4dbb..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.4.0.sql +++ /dev/null @@ -1,126 +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. - - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - -CREATE TABLE `SENTRY_DB_PRIVILEGE` ( - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `PRIVILEGE_NAME` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `PRIVILEGE_SCOPE` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `DB_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `TABLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `URI` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, - `ACTION` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE` ( - `ROLE_ID` BIGINT NOT NULL, - `ROLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_GROUP` ( - `GROUP_ID` BIGINT NOT NULL, - `GROUP_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `DB_PRIVILEGE_ID` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_GROUP_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `GROUP_ID` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE IF NOT EXISTS `SENTRY_VERSION` ( - `VER_ID` BIGINT NOT NULL, - `SCHEMA_VERSION` VARCHAR(127) NOT NULL, - `VERSION_COMMENT` VARCHAR(255) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD CONSTRAINT `SENTRY_DB_PRIV_PK` PRIMARY KEY (`DB_PRIVILEGE_ID`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_PK` PRIMARY KEY (`ROLE_ID`); - -ALTER TABLE `SENTRY_GROUP` - ADD CONSTRAINT `SENTRY_GROUP_PK` PRIMARY KEY (`GROUP_ID`); - -ALTER TABLE `SENTRY_VERSION` - ADD CONSTRAINT `SENTRY_VERSION` PRIMARY KEY (`VER_ID`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_DB_PRIV_PRIV_NAME_UNIQ` (`PRIVILEGE_NAME`(250)); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_SERV_IDX` (`SERVER_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_DB_IDX` (`DB_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_TBL_IDX` (`TABLE_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_ROLE_NAME_UNIQUE` UNIQUE (`ROLE_NAME`); - -ALTER TABLE `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 `SENTRY_ROLE_DB_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_DB_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_ROLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_GRP_FK` - FOREIGN KEY (`GROUP_ID`) REFERENCES `SENTRY_GROUP`(`GROUP_ID`); - -INSERT INTO SENTRY_VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '1.4.0', 'Sentry release version 1.4.0');
http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.5.0.sql deleted file mode 100644 index d5d2e0a..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.5.0.sql +++ /dev/null @@ -1,192 +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. - - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - -CREATE TABLE `SENTRY_DB_PRIVILEGE` ( - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `PRIVILEGE_SCOPE` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `DB_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `TABLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `COLUMN_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `URI` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `ACTION` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE` ( - `ROLE_ID` BIGINT NOT NULL, - `ROLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_GROUP` ( - `GROUP_ID` BIGINT NOT NULL, - `GROUP_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_GROUP_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `GROUP_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE IF NOT EXISTS `SENTRY_VERSION` ( - `VER_ID` BIGINT NOT NULL, - `SCHEMA_VERSION` VARCHAR(127) NOT NULL, - `VERSION_COMMENT` VARCHAR(255) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD CONSTRAINT `SENTRY_DB_PRIV_PK` PRIMARY KEY (`DB_PRIVILEGE_ID`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_PK` PRIMARY KEY (`ROLE_ID`); - -ALTER TABLE `SENTRY_GROUP` - ADD CONSTRAINT `SENTRY_GROUP_PK` PRIMARY KEY (`GROUP_ID`); - -ALTER TABLE `SENTRY_VERSION` - ADD CONSTRAINT `SENTRY_VERSION` PRIMARY KEY (`VER_ID`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD UNIQUE `SENTRY_DB_PRIV_PRIV_NAME_UNIQ` (`SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`URI`(250),`ACTION`,`WITH_GRANT_OPTION`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_SERV_IDX` (`SERVER_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_DB_IDX` (`DB_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_TBL_IDX` (`TABLE_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_COL_IDX` (`COLUMN_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_ROLE_NAME_UNIQUE` UNIQUE (`ROLE_NAME`); - -ALTER TABLE `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 `SENTRY_ROLE_DB_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_DB_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_ROLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_GRP_FK` - FOREIGN KEY (`GROUP_ID`) REFERENCES `SENTRY_GROUP`(`GROUP_ID`); - -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, - `ACTION` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `COMPONENT_NAME` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL, - `RESOURCE_NAME_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `SCOPE` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVICE_NAME` VARCHAR(64) BINARY CHARACTER SET utf8 COLLATE utf8_bin NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD CONSTRAINT `SENTRY_GM_PRIVILEGE_PK` PRIMARY KEY (`GM_PRIVILEGE_ID`); --- Constraints for table SENTRY_GM_PRIVILEGE for class(es) [org.apache.sentry.provider.db.service.model.MSentryGMPrivilege] -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`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_COMP_IDX` (`COMPONENT_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_SERV_IDX` (`SERVICE_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES0_IDX` (`RESOURCE_NAME_0`,`RESOURCE_TYPE_0`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES1_IDX` (`RESOURCE_NAME_1`,`RESOURCE_TYPE_1`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES2_IDX` (`RESOURCE_NAME_2`,`RESOURCE_TYPE_2`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES3_IDX` (`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 -) ENGINE=INNODB DEFAULT CHARSET=utf8; - -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 `SENTRY_ROLE_GM_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_GM_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.6.0.sql deleted file mode 100644 index 1c1bb94..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.6.0.sql +++ /dev/null @@ -1,193 +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. - - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - -CREATE TABLE `SENTRY_DB_PRIVILEGE` ( - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `PRIVILEGE_SCOPE` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `DB_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `TABLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `COLUMN_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `URI` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `ACTION` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE` ( - `ROLE_ID` BIGINT NOT NULL, - `ROLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_GROUP` ( - `GROUP_ID` BIGINT NOT NULL, - `GROUP_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_GROUP_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `GROUP_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE IF NOT EXISTS `SENTRY_VERSION` ( - `VER_ID` BIGINT NOT NULL, - `SCHEMA_VERSION` VARCHAR(127) NOT NULL, - `VERSION_COMMENT` VARCHAR(255) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD CONSTRAINT `SENTRY_DB_PRIV_PK` PRIMARY KEY (`DB_PRIVILEGE_ID`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_PK` PRIMARY KEY (`ROLE_ID`); - -ALTER TABLE `SENTRY_GROUP` - ADD CONSTRAINT `SENTRY_GROUP_PK` PRIMARY KEY (`GROUP_ID`); - -ALTER TABLE `SENTRY_VERSION` - ADD CONSTRAINT `SENTRY_VERSION` PRIMARY KEY (`VER_ID`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD UNIQUE `SENTRY_DB_PRIV_PRIV_NAME_UNIQ` (`SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`URI`(250),`ACTION`,`WITH_GRANT_OPTION`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_SERV_IDX` (`SERVER_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_DB_IDX` (`DB_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_TBL_IDX` (`TABLE_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_COL_IDX` (`COLUMN_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_ROLE_NAME_UNIQUE` UNIQUE (`ROLE_NAME`); - -ALTER TABLE `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 `SENTRY_ROLE_DB_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_DB_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_ROLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_GRP_FK` - FOREIGN KEY (`GROUP_ID`) REFERENCES `SENTRY_GROUP`(`GROUP_ID`); - -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, - `ACTION` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `COMPONENT_NAME` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL, - `RESOURCE_NAME_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `SCOPE` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVICE_NAME` VARCHAR(64) BINARY CHARACTER SET utf8 COLLATE utf8_bin NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD CONSTRAINT `SENTRY_GM_PRIVILEGE_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 `SENTRY_GM_PRIVILEGE` - ADD UNIQUE `GM_PRIVILEGE_UNIQUE` (`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`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_COMP_IDX` (`COMPONENT_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_SERV_IDX` (`SERVICE_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES0_IDX` (`RESOURCE_NAME_0`,`RESOURCE_TYPE_0`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES1_IDX` (`RESOURCE_NAME_1`,`RESOURCE_TYPE_1`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES2_IDX` (`RESOURCE_NAME_2`,`RESOURCE_TYPE_2`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES3_IDX` (`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 -) ENGINE=INNODB DEFAULT CHARSET=utf8; - -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 `SENTRY_ROLE_GM_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_GM_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.7.0.sql deleted file mode 100644 index faff348..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.7.0.sql +++ /dev/null @@ -1,193 +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. - - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - -CREATE TABLE `SENTRY_DB_PRIVILEGE` ( - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `PRIVILEGE_SCOPE` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `DB_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `TABLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `COLUMN_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `URI` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `ACTION` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE` ( - `ROLE_ID` BIGINT NOT NULL, - `ROLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_GROUP` ( - `GROUP_ID` BIGINT NOT NULL, - `GROUP_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_GROUP_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `GROUP_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE IF NOT EXISTS `SENTRY_VERSION` ( - `VER_ID` BIGINT NOT NULL, - `SCHEMA_VERSION` VARCHAR(127) NOT NULL, - `VERSION_COMMENT` VARCHAR(255) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD CONSTRAINT `SENTRY_DB_PRIV_PK` PRIMARY KEY (`DB_PRIVILEGE_ID`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_PK` PRIMARY KEY (`ROLE_ID`); - -ALTER TABLE `SENTRY_GROUP` - ADD CONSTRAINT `SENTRY_GROUP_PK` PRIMARY KEY (`GROUP_ID`); - -ALTER TABLE `SENTRY_VERSION` - ADD CONSTRAINT `SENTRY_VERSION` PRIMARY KEY (`VER_ID`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD UNIQUE `SENTRY_DB_PRIV_PRIV_NAME_UNIQ` (`SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`URI`(250),`ACTION`,`WITH_GRANT_OPTION`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_SERV_IDX` (`SERVER_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_DB_IDX` (`DB_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_TBL_IDX` (`TABLE_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_COL_IDX` (`COLUMN_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_ROLE_NAME_UNIQUE` UNIQUE (`ROLE_NAME`); - -ALTER TABLE `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 `SENTRY_ROLE_DB_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_DB_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_ROLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_GRP_FK` - FOREIGN KEY (`GROUP_ID`) REFERENCES `SENTRY_GROUP`(`GROUP_ID`); - -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, - `ACTION` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `COMPONENT_NAME` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL, - `RESOURCE_NAME_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `SCOPE` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVICE_NAME` VARCHAR(64) BINARY CHARACTER SET utf8 COLLATE utf8_bin NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD CONSTRAINT `SENTRY_GM_PRIVILEGE_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 `SENTRY_GM_PRIVILEGE` - ADD UNIQUE `GM_PRIVILEGE_UNIQUE` (`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`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_COMP_IDX` (`COMPONENT_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_SERV_IDX` (`SERVICE_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES0_IDX` (`RESOURCE_NAME_0`,`RESOURCE_TYPE_0`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES1_IDX` (`RESOURCE_NAME_1`,`RESOURCE_TYPE_1`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES2_IDX` (`RESOURCE_NAME_2`,`RESOURCE_TYPE_2`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES3_IDX` (`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 -) ENGINE=INNODB DEFAULT CHARSET=utf8; - -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 `SENTRY_ROLE_GM_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_GM_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql deleted file mode 100644 index d27d7b9..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-mysql-1.8.0.sql +++ /dev/null @@ -1,223 +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. - - -/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; -/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; -/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!40101 SET NAMES utf8 */; -/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; -/*!40103 SET TIME_ZONE='+00:00' */; -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; - -CREATE TABLE `SENTRY_DB_PRIVILEGE` ( - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `PRIVILEGE_SCOPE` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `DB_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `TABLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `COLUMN_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `URI` VARCHAR(4000) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `ACTION` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE` ( - `ROLE_ID` BIGINT NOT NULL, - `ROLE_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_GROUP` ( - `GROUP_ID` BIGINT NOT NULL, - `GROUP_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_DB_PRIVILEGE_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `DB_PRIVILEGE_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE `SENTRY_ROLE_GROUP_MAP` ( - `ROLE_ID` BIGINT NOT NULL, - `GROUP_ID` BIGINT NOT NULL, - `GRANTOR_PRINCIPAL` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -CREATE TABLE IF NOT EXISTS `SENTRY_VERSION` ( - `VER_ID` BIGINT NOT NULL, - `SCHEMA_VERSION` VARCHAR(127) NOT NULL, - `VERSION_COMMENT` VARCHAR(255) NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD CONSTRAINT `SENTRY_DB_PRIV_PK` PRIMARY KEY (`DB_PRIVILEGE_ID`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_PK` PRIMARY KEY (`ROLE_ID`); - -ALTER TABLE `SENTRY_GROUP` - ADD CONSTRAINT `SENTRY_GROUP_PK` PRIMARY KEY (`GROUP_ID`); - -ALTER TABLE `SENTRY_VERSION` - ADD CONSTRAINT `SENTRY_VERSION` PRIMARY KEY (`VER_ID`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD UNIQUE `SENTRY_DB_PRIV_PRIV_NAME_UNIQ` (`SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`URI`(250),`ACTION`,`WITH_GRANT_OPTION`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_SERV_IDX` (`SERVER_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_DB_IDX` (`DB_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_TBL_IDX` (`TABLE_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_COL_IDX` (`COLUMN_NAME`); - -ALTER TABLE `SENTRY_DB_PRIVILEGE` - ADD INDEX `SENTRY_PRIV_URI_IDX` (`URI`); - -ALTER TABLE `SENTRY_ROLE` - ADD CONSTRAINT `SENTRY_ROLE_ROLE_NAME_UNIQUE` UNIQUE (`ROLE_NAME`); - -ALTER TABLE `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 `SENTRY_ROLE_DB_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_DB_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_ROLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `SENTRY_ROLE_GROUP_MAP` - ADD CONSTRAINT `SEN_ROLE_GROUP_MAP_SEN_GRP_FK` - FOREIGN KEY (`GROUP_ID`) REFERENCES `SENTRY_GROUP`(`GROUP_ID`); - -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, - `ACTION` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `COMPONENT_NAME` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL, - `WITH_GRANT_OPTION` CHAR(1) NOT NULL, - `RESOURCE_NAME_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_NAME_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_0` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_1` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_2` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `RESOURCE_TYPE_3` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '__NULL__', - `SCOPE` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `SERVICE_NAME` VARCHAR(64) BINARY CHARACTER SET utf8 COLLATE utf8_bin NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD CONSTRAINT `SENTRY_GM_PRIVILEGE_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 `SENTRY_GM_PRIVILEGE` - ADD UNIQUE `GM_PRIVILEGE_UNIQUE` (`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`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_COMP_IDX` (`COMPONENT_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_SERV_IDX` (`SERVICE_NAME`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES0_IDX` (`RESOURCE_NAME_0`,`RESOURCE_TYPE_0`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES1_IDX` (`RESOURCE_NAME_1`,`RESOURCE_TYPE_1`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES2_IDX` (`RESOURCE_NAME_2`,`RESOURCE_TYPE_2`); - -ALTER TABLE `SENTRY_GM_PRIVILEGE` - ADD INDEX `SENTRY_GM_PRIV_RES3_IDX` (`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 -) ENGINE=INNODB DEFAULT CHARSET=utf8; - -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 `SENTRY_ROLE_GM_PRIVILEGE_MAP` - ADD CONSTRAINT `SEN_RLE_GM_PRV_MAP_SN_RLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `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`); - -CREATE TABLE `SENTRY_USER` ( - `USER_ID` BIGINT NOT NULL, - `USER_NAME` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `CREATE_TIME` BIGINT NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_USER` - ADD CONSTRAINT `SENTRY_USER_PK` PRIMARY KEY (`USER_ID`); - -ALTER TABLE `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` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `SENTRY_ROLE_USER_MAP` - ADD CONSTRAINT `SENTRY_ROLE_USER_MAP_PK` PRIMARY KEY (`ROLE_ID`,`USER_ID`); - -ALTER TABLE `SENTRY_ROLE_USER_MAP` - ADD CONSTRAINT `SEN_ROLE_USER_MAP_SEN_ROLE_FK` - FOREIGN KEY (`ROLE_ID`) REFERENCES `SENTRY_ROLE`(`ROLE_ID`); - -ALTER TABLE `SENTRY_ROLE_USER_MAP` - ADD CONSTRAINT `SEN_ROLE_USER_MAP_SEN_USER_FK` - FOREIGN KEY (`USER_ID`) REFERENCES `SENTRY_USER`(`USER_ID`); - http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.4.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.4.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.4.0.sql deleted file mode 100644 index 363590e..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.4.0.sql +++ /dev/null @@ -1,110 +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. - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "PRIVILEGE_NAME" VARCHAR2(4000) NOT NULL, - "PRIVILEGE_SCOPE" VARCHAR2(32) NOT NULL, - "SERVER_NAME" VARCHAR2(128) NOT NULL, - "DB_NAME" VARCHAR2(128) NULL, - "TABLE_NAME" VARCHAR2(128) NULL, - "URI" VARCHAR2(4000) NULL, - "ACTION" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR(128) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" NUMBER NOT NULL, - "ROLE_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" NUMBER NOT NULL, - "GROUP_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "DB_PRIVILEGE_ID" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GROUP_ID" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" NUMBER NOT NULL, - "SCHEMA_VERSION" VARCHAR(127) NOT NULL, - "VERSION_COMMENT" VARCHAR(255) NOT NULL -); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PRIV_NAME_UNIQ" UNIQUE ("PRIVILEGE_NAME"); - -CREATE INDEX "SENTRY_SERV_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("SERVER_NAME"); - -CREATE INDEX "SENTRY_DB_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("DB_NAME"); - -CREATE INDEX "SENTRY_TBL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("TABLE_NAME"); - -CREATE INDEX "SENTRY_URI_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("URI"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_PRIV_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 "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") INITIALLY DEFERRED; - -INSERT INTO SENTRY_VERSION (VER_ID, SCHEMA_VERSION, VERSION_COMMENT) VALUES (1, '1.4.0', 'Sentry release version 1.4.0'); - http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.5.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.5.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.5.0.sql deleted file mode 100644 index fe8e93c..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.5.0.sql +++ /dev/null @@ -1,168 +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. - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "PRIVILEGE_SCOPE" VARCHAR2(32) NOT NULL, - "SERVER_NAME" VARCHAR2(128) NOT NULL, - "DB_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "TABLE_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "COLUMN_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "URI" VARCHAR2(4000) DEFAULT '__NULL__', - "ACTION" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" NUMBER NOT NULL, - "ROLE_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" NUMBER NOT NULL, - "GROUP_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GROUP_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" NUMBER NOT NULL, - "SCHEMA_VERSION" VARCHAR(127) NOT NULL, - "VERSION_COMMENT" VARCHAR(255) NOT NULL -); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE "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_SERV_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("SERVER_NAME"); - -CREATE INDEX "SENTRY_DB_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("DB_NAME"); - -CREATE INDEX "SENTRY_TBL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("TABLE_NAME"); - -CREATE INDEX "SENTRY_COL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_URI_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("URI"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_PRIV_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 "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") INITIALLY DEFERRED; - -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" NUMBER NOT NULL, - "COMPONENT_NAME" VARCHAR2(32) NOT NULL, - "SERVICE_NAME" VARCHAR2(64) NOT NULL, - "RESOURCE_NAME_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" VARCHAR2(64) DEFAULT '__NULL__', - "ACTION" VARCHAR2(32) NOT NULL, - "SCOPE" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -ALTER TABLE "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 "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" ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GM_PRIVILEGE_ID" NUMBER NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.6.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.6.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.6.0.sql deleted file mode 100644 index 3a22335..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.6.0.sql +++ /dev/null @@ -1,168 +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. - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "PRIVILEGE_SCOPE" VARCHAR2(32) NOT NULL, - "SERVER_NAME" VARCHAR2(128) NOT NULL, - "DB_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "TABLE_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "COLUMN_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "URI" VARCHAR2(4000) DEFAULT '__NULL__', - "ACTION" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" NUMBER NOT NULL, - "ROLE_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" NUMBER NOT NULL, - "GROUP_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GROUP_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" NUMBER NOT NULL, - "SCHEMA_VERSION" VARCHAR(127) NOT NULL, - "VERSION_COMMENT" VARCHAR(255) NOT NULL -); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE "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_SERV_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("SERVER_NAME"); - -CREATE INDEX "SENTRY_DB_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("DB_NAME"); - -CREATE INDEX "SENTRY_TBL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("TABLE_NAME"); - -CREATE INDEX "SENTRY_COL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_URI_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("URI"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_PRIV_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 "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") INITIALLY DEFERRED; - -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" NUMBER NOT NULL, - "COMPONENT_NAME" VARCHAR2(32) NOT NULL, - "SERVICE_NAME" VARCHAR2(64) NOT NULL, - "RESOURCE_NAME_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" VARCHAR2(64) DEFAULT '__NULL__', - "ACTION" VARCHAR2(32) NOT NULL, - "SCOPE" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -ALTER TABLE "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 "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" ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GM_PRIVILEGE_ID" NUMBER NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.7.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.7.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.7.0.sql deleted file mode 100644 index ae9cd06..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.7.0.sql +++ /dev/null @@ -1,168 +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. - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "PRIVILEGE_SCOPE" VARCHAR2(32) NOT NULL, - "SERVER_NAME" VARCHAR2(128) NOT NULL, - "DB_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "TABLE_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "COLUMN_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "URI" VARCHAR2(4000) DEFAULT '__NULL__', - "ACTION" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" NUMBER NOT NULL, - "ROLE_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" NUMBER NOT NULL, - "GROUP_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GROUP_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" NUMBER NOT NULL, - "SCHEMA_VERSION" VARCHAR(127) NOT NULL, - "VERSION_COMMENT" VARCHAR(255) NOT NULL -); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE "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_SERV_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("SERVER_NAME"); - -CREATE INDEX "SENTRY_DB_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("DB_NAME"); - -CREATE INDEX "SENTRY_TBL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("TABLE_NAME"); - -CREATE INDEX "SENTRY_COL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_URI_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("URI"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_PRIV_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 "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") INITIALLY DEFERRED; - -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" NUMBER NOT NULL, - "COMPONENT_NAME" VARCHAR2(32) NOT NULL, - "SERVICE_NAME" VARCHAR2(64) NOT NULL, - "RESOURCE_NAME_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" VARCHAR2(64) DEFAULT '__NULL__', - "ACTION" VARCHAR2(32) NOT NULL, - "SCOPE" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -ALTER TABLE "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 "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" ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GM_PRIVILEGE_ID" NUMBER NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql deleted file mode 100644 index ced5c31..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-oracle-1.8.0.sql +++ /dev/null @@ -1,197 +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. - -CREATE TABLE "SENTRY_DB_PRIVILEGE" ( - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "PRIVILEGE_SCOPE" VARCHAR2(32) NOT NULL, - "SERVER_NAME" VARCHAR2(128) NOT NULL, - "DB_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "TABLE_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "COLUMN_NAME" VARCHAR2(128) DEFAULT '__NULL__', - "URI" VARCHAR2(4000) DEFAULT '__NULL__', - "ACTION" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" NUMBER NOT NULL, - "ROLE_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" NUMBER NOT NULL, - "GROUP_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "DB_PRIVILEGE_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GROUP_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -CREATE TABLE "SENTRY_VERSION" ( - "VER_ID" NUMBER NOT NULL, - "SCHEMA_VERSION" VARCHAR(127) NOT NULL, - "VERSION_COMMENT" VARCHAR(255) NOT NULL -); - -ALTER TABLE "SENTRY_DB_PRIVILEGE" - ADD CONSTRAINT "SENTRY_DB_PRIV_PK" PRIMARY KEY ("DB_PRIVILEGE_ID"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_PK" PRIMARY KEY ("ROLE_ID"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GROUP_PK" PRIMARY KEY ("GROUP_ID"); - -ALTER TABLE "SENTRY_VERSION" ADD CONSTRAINT "SENTRY_VERSION_PK" PRIMARY KEY ("VER_ID"); - -ALTER TABLE "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_SERV_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("SERVER_NAME"); - -CREATE INDEX "SENTRY_DB_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("DB_NAME"); - -CREATE INDEX "SENTRY_TBL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("TABLE_NAME"); - -CREATE INDEX "SENTRY_COL_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("COLUMN_NAME"); - -CREATE INDEX "SENTRY_URI_PRIV_IDX" ON "SENTRY_DB_PRIVILEGE" ("URI"); - -ALTER TABLE "SENTRY_ROLE" - ADD CONSTRAINT "SENTRY_ROLE_ROLE_NAME_UNIQUE" UNIQUE ("ROLE_NAME"); - -ALTER TABLE "SENTRY_GROUP" - ADD CONSTRAINT "SENTRY_GRP_GRP_NAME_UNIQUE" UNIQUE ("GROUP_NAME"); - -ALTER TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_PRIV_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 "SENTRY_ROLE_DB_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_DB_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_GROUP_MAP" - ADD CONSTRAINT "SEN_ROLE_GROUP_MAP_SEN_GRP_FK" - FOREIGN KEY ("GROUP_ID") REFERENCES "SENTRY_GROUP"("GROUP_ID") INITIALLY DEFERRED; - -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" NUMBER NOT NULL, - "COMPONENT_NAME" VARCHAR2(32) NOT NULL, - "SERVICE_NAME" VARCHAR2(64) NOT NULL, - "RESOURCE_NAME_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_NAME_3" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_0" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_1" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_2" VARCHAR2(64) DEFAULT '__NULL__', - "RESOURCE_TYPE_3" VARCHAR2(64) DEFAULT '__NULL__', - "ACTION" VARCHAR2(32) NOT NULL, - "SCOPE" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL, - "WITH_GRANT_OPTION" CHAR(1) DEFAULT 'N' NOT NULL -); - -ALTER TABLE "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 "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" ("COMPONENT_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_SERV_IDX" ON "SENTRY_GM_PRIVILEGE" ("SERVICE_NAME"); - -CREATE INDEX "SENTRY_GM_PRIV_RES0_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_0","RESOURCE_TYPE_0"); - -CREATE INDEX "SENTRY_GM_PRIV_RES1_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_1","RESOURCE_TYPE_1"); - -CREATE INDEX "SENTRY_GM_PRIV_RES2_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_2","RESOURCE_TYPE_2"); - -CREATE INDEX "SENTRY_GM_PRIV_RES3_IDX" ON "SENTRY_GM_PRIVILEGE" ("RESOURCE_NAME_3","RESOURCE_TYPE_3"); - --- Table SENTRY_ROLE_GM_PRIVILEGE_MAP for join relationship -CREATE TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "GM_PRIVILEGE_ID" NUMBER NOT NULL -); - -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRIV_MAP_PK" PRIMARY KEY ("ROLE_ID","GM_PRIVILEGE_ID"); - --- Constraints for table SENTRY_ROLE_GM_PRIVILEGE_MAP -ALTER TABLE "SENTRY_ROLE_GM_PRIVILEGE_MAP" - ADD CONSTRAINT "SEN_RLE_GM_PRV_MAP_SN_RLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "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") INITIALLY DEFERRED; - -CREATE TABLE "SENTRY_USER" ( - "USER_ID" NUMBER NOT NULL, - "USER_NAME" VARCHAR2(128) NOT NULL, - "CREATE_TIME" NUMBER NOT NULL -); - -ALTER TABLE "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_PK" PRIMARY KEY ("USER_ID"); - -ALTER TABLE "SENTRY_USER" - ADD CONSTRAINT "SENTRY_USER_USER_NAME_UNIQUE" UNIQUE ("USER_NAME"); - -CREATE TABLE "SENTRY_ROLE_USER_MAP" ( - "ROLE_ID" NUMBER NOT NULL, - "USER_ID" NUMBER NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR2(128) -); - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SENTRY_ROLE_USER_MAP_PK" PRIMARY KEY ("ROLE_ID","USER_ID"); - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_ROLE_FK" - FOREIGN KEY ("ROLE_ID") REFERENCES "SENTRY_ROLE"("ROLE_ID") INITIALLY DEFERRED; - -ALTER TABLE "SENTRY_ROLE_USER_MAP" - ADD CONSTRAINT "SEN_ROLE_USER_MAP_SEN_USER_FK" - FOREIGN KEY ("USER_ID") REFERENCES "SENTRY_USER"("USER_ID") INITIALLY DEFERRED; http://git-wip-us.apache.org/repos/asf/sentry/blob/e72e6eac/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.4.0.sql ---------------------------------------------------------------------- diff --git a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.4.0.sql b/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.4.0.sql deleted file mode 100644 index 5dfae03..0000000 --- a/sentry-provider/sentry-provider-db/src/main/resources/sentry-postgres-1.4.0.sql +++ /dev/null @@ -1,124 +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_NAME" character varying(4000) NOT NULL, - "PRIVILEGE_SCOPE" character varying(32) NOT NULL, - "SERVER_NAME" character varying(128) NOT NULL, - "DB_NAME" character varying(128) DEFAULT NULL::character varying, - "TABLE_NAME" character varying(128) DEFAULT NULL::character varying, - "URI" character varying(4000) DEFAULT NULL::character varying, - "ACTION" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" VARCHAR(128) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE" ( - "ROLE_ID" BIGINT NOT NULL, - "ROLE_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) NOT NULL -); - -CREATE TABLE "SENTRY_GROUP" ( - "GROUP_ID" BIGINT NOT NULL, - "GROUP_NAME" character varying(128) NOT NULL, - "CREATE_TIME" BIGINT NOT NULL, - "GRANTOR_PRINCIPAL" character varying(128) NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_DB_PRIVILEGE_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "DB_PRIVILEGE_ID" BIGINT NOT NULL -); - -CREATE TABLE "SENTRY_ROLE_GROUP_MAP" ( - "ROLE_ID" BIGINT NOT NULL, - "GROUP_ID" BIGINT NOT NULL -); - -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 ("PRIVILEGE_NAME"); - -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_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.4.0', 'Sentry release version 1.4.0'); - -COMMIT;
