This is an automated email from the ASF dual-hosted git repository.
pradeep pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ranger.git
The following commit(s) were added to refs/heads/master by this push:
new 2a6dd3d RANGER-2550: Increase sort_order field length of all the
tables
2a6dd3d is described below
commit 2a6dd3d078c52cc1314af581f7b8e6c8cdab933a
Author: Pradeep <[email protected]>
AuthorDate: Sun Aug 25 14:25:16 2019 +0530
RANGER-2550: Increase sort_order field length of all the tables
---
.../optimized/current/ranger_core_db_mysql.sql | 26 +++++++++++-----------
.../db/mysql/patches/009-updated_schema.sql | 24 ++++++++++----------
.../016-updated-schema-for-tag-based-policy.sql | 2 +-
.../db/mysql/patches/020-datamask-policy.sql | 2 +-
.../optimized/current/ranger_core_db_oracle.sql | 20 ++++++++---------
.../db/oracle/patches/009-updated_schema.sql | 24 ++++++++++----------
.../016-updated-schema-for-tag-based-policy.sql | 2 +-
.../db/oracle/patches/020-datamask-policy.sql | 2 +-
.../optimized/current/ranger_core_db_postgres.sql | 26 +++++++++++-----------
.../016-updated-schema-for-tag-based-policy.sql | 2 +-
.../db/postgres/patches/020-datamask-policy.sql | 2 +-
.../current/ranger_core_db_sqlanywhere.sql | 26 +++++++++++-----------
.../016-updated-schema-for-tag-based-policy.sql | 2 +-
.../db/sqlanywhere/patches/020-datamask-policy.sql | 2 +-
.../optimized/current/ranger_core_db_sqlserver.sql | 22 +++++++++---------
.../016-updated-schema-for-tag-based-policy.sql | 2 +-
.../db/sqlserver/patches/020-datamask-policy.sql | 2 +-
.../sqlserver/patches/041-create-role-schema.sql | 2 +-
18 files changed, 95 insertions(+), 95 deletions(-)
diff --git a/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
b/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
index 377e61f..399fd8a 100644
--- a/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
+++ b/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql
@@ -713,7 +713,7 @@ CREATE TABLE `x_service_config_def` (
`rb_key_label` varchar(1024) DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
`rb_key_validation_message` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_service_config_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`),
CONSTRAINT `x_service_config_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -747,7 +747,7 @@ CREATE TABLE `x_resource_def` (
`rb_key_label` varchar(1024) DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
`rb_key_validation_message` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
`datamask_options` varchar(1024) NULL DEFAULT NULL,
`rowfilter_options` varchar(1024) NULL DEFAULT NULL,
primary key (`id`),
@@ -770,7 +770,7 @@ CREATE TABLE `x_access_type_def` (
`name` varchar(1024) DEFAULT NULL,
`label` varchar(1024) DEFAULT NULL,
`rb_key_label` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
`datamask_options` varchar(1024) NULL DEFAULT NULL,
`rowfilter_options` varchar(1024) NULL DEFAULT NULL,
primary key (`id`) ,
@@ -814,7 +814,7 @@ CREATE TABLE `x_policy_condition_def` (
`rb_key_label` varchar(1024) DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
`rb_key_validation_message` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`) ,
CONSTRAINT `x_policy_condition_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`),
CONSTRAINT `x_policy_condition_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -833,7 +833,7 @@ CREATE TABLE `x_context_enricher_def` (
`name` varchar(1024) DEFAULT NULL,
`enricher` varchar(1024) DEFAULT NULL,
`enricher_options` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`) ,
CONSTRAINT `x_context_enricher_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`),
CONSTRAINT `x_context_enricher_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -869,7 +869,7 @@ CREATE TABLE `x_enum_element_def` (
`name` varchar(1024) DEFAULT NULL,
`label` varchar(1024) DEFAULT NULL,
`rb_key_label` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_enum_element_def_FK_defid` FOREIGN KEY (`enum_def_id`)
REFERENCES `x_enum_def` (`id`),
CONSTRAINT `x_enum_element_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -919,7 +919,7 @@ CREATE TABLE `x_policy_resource_map` (
`upd_by_id` bigint(20) DEFAULT NULL,
`resource_id` bigint(20) NOT NULL,
`value` varchar(1024) DEFAULT NULL,
-`sort_order` INT DEFAULT 0,
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_policy_resource_map_FK_resource_id` FOREIGN KEY (`resource_id`)
REFERENCES `x_policy_resource` (`id`),
CONSTRAINT `x_policy_resource_map_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -935,7 +935,7 @@ CREATE TABLE `x_policy_item` (
`upd_by_id` bigint(20) DEFAULT NULL,
`policy_id` bigint(20) NOT NULL,
`delegate_admin` tinyint(1) NOT NULL DEFAULT '0',
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
`item_type` INT DEFAULT 0 NOT NULL,
`is_enabled` TINYINT(1) NOT NULL DEFAULT '1',
`comments` VARCHAR(255) DEFAULT NULL NULL,
@@ -955,7 +955,7 @@ CREATE TABLE `x_policy_item_access` (
`policy_item_id` bigint(20) NOT NULL,
`type` bigint(20) NOT NULL,
`is_allowed` tinyint(11) NOT NULL DEFAULT '0',
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (id),
CONSTRAINT `x_policy_item_access_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_access_FK_atd_id` FOREIGN KEY (`type`) REFERENCES
`x_access_type_def` (`id`),
@@ -973,7 +973,7 @@ CREATE TABLE `x_policy_item_condition` (
`policy_item_id` bigint(20) NOT NULL,
`type` bigint(20) NOT NULL,
`value` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (id),
CONSTRAINT `x_policy_item_condition_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_condition_FK_pcd_id` FOREIGN KEY (`type`) REFERENCES
`x_policy_condition_def` (`id`),
@@ -990,7 +990,7 @@ CREATE TABLE `x_policy_item_user_perm` (
`upd_by_id` bigint(20) DEFAULT NULL,
`policy_item_id` bigint(20) NOT NULL,
`user_id` bigint(20) NULL DEFAULT NULL,
-`sort_order` INT DEFAULT 0,
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_policy_item_user_perm_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_user_perm_FK_user_id` FOREIGN KEY (`user_id`)
REFERENCES `x_user` (`id`),
@@ -1007,7 +1007,7 @@ CREATE TABLE `x_policy_item_group_perm` (
`upd_by_id` bigint(20) DEFAULT NULL,
`policy_item_id` bigint(20) NOT NULL,
`group_id` bigint(20) NULL DEFAULT NULL,
-`sort_order` INT DEFAULT 0,
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_policy_item_group_perm_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_group_perm_FK_group_id` FOREIGN KEY (`group_id`)
REFERENCES `x_group` (`id`),
@@ -1186,7 +1186,7 @@ CREATE TABLE `x_datamask_type_def` (
`datamask_options` varchar(1024) NULL DEFAULT NULL,
`rb_key_label` varchar(1024) NULL DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_datamask_type_def_FK_def_id` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`) ,
CONSTRAINT `x_datamask_type_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
diff --git a/security-admin/db/mysql/patches/009-updated_schema.sql
b/security-admin/db/mysql/patches/009-updated_schema.sql
index 085c50d..9899e8c 100644
--- a/security-admin/db/mysql/patches/009-updated_schema.sql
+++ b/security-admin/db/mysql/patches/009-updated_schema.sql
@@ -136,7 +136,7 @@ CREATE TABLE `x_service_config_def` (
`rb_key_label` varchar(1024) DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
`rb_key_validation_message` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_service_config_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`),
CONSTRAINT `x_service_config_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -170,7 +170,7 @@ CREATE TABLE `x_resource_def` (
`rb_key_label` varchar(1024) DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
`rb_key_validation_message` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
KEY `x_resource_def_FK_parent` (`parent`),
CONSTRAINT `x_resource_def_FK_parent` FOREIGN KEY (`parent`) REFERENCES
`x_resource_def` (`id`) ,
@@ -191,7 +191,7 @@ CREATE TABLE `x_access_type_def` (
`name` varchar(1024) DEFAULT NULL,
`label` varchar(1024) DEFAULT NULL,
`rb_key_label` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`) ,
CONSTRAINT `x_access_type_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`),
CONSTRAINT `x_access_type_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -233,7 +233,7 @@ CREATE TABLE `x_policy_condition_def` (
`rb_key_label` varchar(1024) DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
`rb_key_validation_message` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`) ,
CONSTRAINT `x_policy_condition_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`),
CONSTRAINT `x_policy_condition_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -252,7 +252,7 @@ CREATE TABLE `x_context_enricher_def` (
`name` varchar(1024) DEFAULT NULL,
`enricher` varchar(1024) DEFAULT NULL,
`enricher_options` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`) ,
CONSTRAINT `x_context_enricher_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`),
CONSTRAINT `x_context_enricher_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -288,7 +288,7 @@ CREATE TABLE `x_enum_element_def` (
`name` varchar(1024) DEFAULT NULL,
`label` varchar(1024) DEFAULT NULL,
`rb_key_label` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_enum_element_def_FK_defid` FOREIGN KEY (`enum_def_id`)
REFERENCES `x_enum_def` (`id`),
CONSTRAINT `x_enum_element_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -338,7 +338,7 @@ CREATE TABLE `x_policy_resource_map` (
`upd_by_id` bigint(20) DEFAULT NULL,
`resource_id` bigint(20) NOT NULL,
`value` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_policy_resource_map_FK_resource_id` FOREIGN KEY (`resource_id`)
REFERENCES `x_policy_resource` (`id`),
CONSTRAINT `x_policy_resource_map_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -354,7 +354,7 @@ CREATE TABLE `x_policy_item` (
`upd_by_id` bigint(20) DEFAULT NULL,
`policy_id` bigint(20) NOT NULL,
`delegate_admin` tinyint(1) NOT NULL DEFAULT '0',
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_policy_item_FK_policy_id` FOREIGN KEY (`policy_id`) REFERENCES
`x_policy` (`id`),
CONSTRAINT `x_policy_item_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
@@ -371,7 +371,7 @@ CREATE TABLE `x_policy_item_access` (
`policy_item_id` bigint(20) NOT NULL,
`type` bigint(20) NOT NULL,
`is_allowed` tinyint(11) NOT NULL DEFAULT '0',
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (id),
CONSTRAINT `x_policy_item_access_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_access_FK_atd_id` FOREIGN KEY (`type`) REFERENCES
`x_access_type_def` (`id`),
@@ -389,7 +389,7 @@ CREATE TABLE `x_policy_item_condition` (
`policy_item_id` bigint(20) NOT NULL,
`type` bigint(20) NOT NULL,
`value` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (id),
CONSTRAINT `x_policy_item_condition_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_condition_FK_pcd_id` FOREIGN KEY (`type`) REFERENCES
`x_policy_condition_def` (`id`),
@@ -406,7 +406,7 @@ CREATE TABLE `x_policy_item_user_perm` (
`upd_by_id` bigint(20) DEFAULT NULL,
`policy_item_id` bigint(20) NOT NULL,
`user_id` bigint(20) NULL DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_policy_item_user_perm_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_user_perm_FK_user_id` FOREIGN KEY (`user_id`)
REFERENCES `x_user` (`id`),
@@ -423,7 +423,7 @@ CREATE TABLE `x_policy_item_group_perm` (
`upd_by_id` bigint(20) DEFAULT NULL,
`policy_item_id` bigint(20) NOT NULL,
`group_id` bigint(20) NULL DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_policy_item_group_perm_FK_pi_id` FOREIGN KEY (`policy_item_id`)
REFERENCES `x_policy_item` (`id`) ,
CONSTRAINT `x_policy_item_group_perm_FK_group_id` FOREIGN KEY (`group_id`)
REFERENCES `x_group` (`id`),
diff --git
a/security-admin/db/mysql/patches/016-updated-schema-for-tag-based-policy.sql
b/security-admin/db/mysql/patches/016-updated-schema-for-tag-based-policy.sql
index 86b17bc..c06f1c5 100644
---
a/security-admin/db/mysql/patches/016-updated-schema-for-tag-based-policy.sql
+++
b/security-admin/db/mysql/patches/016-updated-schema-for-tag-based-policy.sql
@@ -181,7 +181,7 @@ CREATE TABLE IF NOT EXISTS `x_service_resource_element_val`
(
`upd_by_id` BIGINT(20) NULL DEFAULT NULL,
`res_element_id` BIGINT(20) NOT NULL,
`value` VARCHAR(1024) NOT NULL,
-`sort_order` tinyint(3) NULL DEFAULT '0',
+`sort_order` int DEFAULT 0,
PRIMARY KEY (`id`),
KEY `x_srvc_res_el_val_IDX_resel_id` (`res_element_id`),
KEY `x_srvc_res_el_val_IDX_addby_id` (`added_by_id`),
diff --git a/security-admin/db/mysql/patches/020-datamask-policy.sql
b/security-admin/db/mysql/patches/020-datamask-policy.sql
index 2ec2909..0597536 100644
--- a/security-admin/db/mysql/patches/020-datamask-policy.sql
+++ b/security-admin/db/mysql/patches/020-datamask-policy.sql
@@ -70,7 +70,7 @@ CREATE TABLE `x_datamask_type_def` (
`datamask_options` varchar(1024) NULL DEFAULT NULL,
`rb_key_label` varchar(1024) NULL DEFAULT NULL,
`rb_key_description` varchar(1024) DEFAULT NULL,
-`sort_order` tinyint(3) DEFAULT '0',
+`sort_order` int DEFAULT 0,
primary key (`id`),
CONSTRAINT `x_datamask_type_def_FK_def_id` FOREIGN KEY (`def_id`) REFERENCES
`x_service_def` (`id`) ,
CONSTRAINT `x_datamask_type_def_FK_added_by_id` FOREIGN KEY (`added_by_id`)
REFERENCES `x_portal_user` (`id`),
diff --git
a/security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
b/security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
index bd5c6a4..73b9173 100644
--- a/security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
+++ b/security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
@@ -813,7 +813,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_service_conf_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
CONSTRAINT x_service_conf_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -847,7 +847,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rowfilter_options VARCHAR(1024) DEFAULT NULL NULL,
primary key (id),
@@ -869,7 +869,7 @@ item_id NUMBER(20) NOT NULL,
name VARCHAR(1024) DEFAULT NULL NULL,
label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rowfilter_options VARCHAR(1024) DEFAULT NULL NULL,
primary key (id),
@@ -913,7 +913,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_policy_cond_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
CONSTRAINT x_policy_cond_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -932,7 +932,7 @@ item_id NUMBER(20) NOT NULL,
name varchar(1024) DEFAULT NULL NULL,
enricher varchar(1024) DEFAULT NULL NULL,
enricher_options varchar(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_cont_enr_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
CONSTRAINT x_cont_enr_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -968,7 +968,7 @@ item_id NUMBER(20) NOT NULL,
name VARCHAR(1024) DEFAULT NULL NULL,
label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_enum_element_def_FK_defid FOREIGN KEY (enum_def_id) REFERENCES
x_enum_def (id),
CONSTRAINT x_enum_element_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -1034,7 +1034,7 @@ added_by_id NUMBER(20) DEFAULT NULL NULL,
upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_id NUMBER(20) NOT NULL,
delegate_admin NUMBER(1) DEFAULT '0' NOT NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
item_type NUMBER(10) DEFAULT 0 NOT NULL,
is_enabled NUMBER(1) DEFAULT 1 NOT NULL,
comments VARCHAR(255) DEFAULT NULL NULL,
@@ -1054,7 +1054,7 @@ upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_item_id NUMBER(20) NOT NULL,
type NUMBER(20) NOT NULL,
is_allowed NUMBER(3) DEFAULT '0' NOT NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_plc_item_access_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES
x_policy_item (id),
CONSTRAINT x_plc_item_access_FK_atd_id FOREIGN KEY (type) REFERENCES
x_access_type_def (id),
@@ -1072,7 +1072,7 @@ upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_item_id NUMBER(20) NOT NULL,
type NUMBER(20) NOT NULL,
value VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_plc_item_cond_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES
x_policy_item (id),
CONSTRAINT x_plc_item_cond_FK_pcd_id FOREIGN KEY (type) REFERENCES
x_policy_condition_def (id),
@@ -1260,7 +1260,7 @@ transformer VARCHAR(1024) DEFAULT NULL NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_dm_type_def_FK_def_id FOREIGN KEY (def_id) REFERENCES
x_service_def(id),
CONSTRAINT x_dm_type_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES
x_portal_user(id),
diff --git a/security-admin/db/oracle/patches/009-updated_schema.sql
b/security-admin/db/oracle/patches/009-updated_schema.sql
index 2f0996c..59b56e5 100644
--- a/security-admin/db/oracle/patches/009-updated_schema.sql
+++ b/security-admin/db/oracle/patches/009-updated_schema.sql
@@ -182,7 +182,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_service_conf_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
CONSTRAINT x_service_conf_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -216,7 +216,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_resource_def_FK_parent FOREIGN KEY (parent) REFERENCES
x_resource_def (id),
CONSTRAINT x_resource_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
@@ -236,7 +236,7 @@ item_id NUMBER(20) NOT NULL,
name VARCHAR(1024) DEFAULT NULL NULL,
label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_access_type_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
CONSTRAINT x_access_type_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -278,7 +278,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_policy_cond_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
CONSTRAINT x_policy_cond_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -297,7 +297,7 @@ item_id NUMBER(20) NOT NULL,
name varchar(1024) DEFAULT NULL NULL,
enricher varchar(1024) DEFAULT NULL NULL,
enricher_options varchar(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_cont_enr_def_FK_defid FOREIGN KEY (def_id) REFERENCES
x_service_def (id),
CONSTRAINT x_cont_enr_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -333,7 +333,7 @@ item_id NUMBER(20) NOT NULL,
name VARCHAR(1024) DEFAULT NULL NULL,
label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_enum_element_def_FK_defid FOREIGN KEY (enum_def_id) REFERENCES
x_enum_def (id),
CONSTRAINT x_enum_element_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -383,7 +383,7 @@ added_by_id NUMBER(20) DEFAULT NULL NULL,
upd_by_id NUMBER(20) DEFAULT NULL NULL,
resource_id NUMBER(20) NOT NULL,
value VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_policy_res_map_FK_res_id FOREIGN KEY (resource_id) REFERENCES
x_policy_resource (id),
CONSTRAINT x_policy_res_map_FK_added_by FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -399,7 +399,7 @@ added_by_id NUMBER(20) DEFAULT NULL NULL,
upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_id NUMBER(20) NOT NULL,
delegate_admin NUMBER(1) DEFAULT '0' NOT NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_policy_item_FK_policy_id FOREIGN KEY (policy_id) REFERENCES
x_policy (id),
CONSTRAINT x_policy_item_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
@@ -416,7 +416,7 @@ upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_item_id NUMBER(20) NOT NULL,
type NUMBER(20) NOT NULL,
is_allowed NUMBER(3) DEFAULT '0' NOT NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_plc_item_access_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES
x_policy_item (id),
CONSTRAINT x_plc_item_access_FK_atd_id FOREIGN KEY (type) REFERENCES
x_access_type_def (id),
@@ -434,7 +434,7 @@ upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_item_id NUMBER(20) NOT NULL,
type NUMBER(20) NOT NULL,
value VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_plc_item_cond_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES
x_policy_item (id),
CONSTRAINT x_plc_item_cond_FK_pcd_id FOREIGN KEY (type) REFERENCES
x_policy_condition_def (id),
@@ -451,7 +451,7 @@ added_by_id NUMBER(20) DEFAULT NULL NULL,
upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_item_id NUMBER(20) NOT NULL,
user_id NUMBER(20) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_plc_itm_usr_perm_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES
x_policy_item (id),
CONSTRAINT x_plc_itm_usr_perm_FK_user_id FOREIGN KEY (user_id) REFERENCES
x_user (id),
@@ -468,7 +468,7 @@ added_by_id NUMBER(20) DEFAULT NULL NULL,
upd_by_id NUMBER(20) DEFAULT NULL NULL,
policy_item_id NUMBER(20) NOT NULL,
group_id NUMBER(20) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_plc_itm_grp_perm_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES
x_policy_item (id),
CONSTRAINT x_plc_itm_grp_perm_FK_group_id FOREIGN KEY (group_id) REFERENCES
x_group (id),
diff --git
a/security-admin/db/oracle/patches/016-updated-schema-for-tag-based-policy.sql
b/security-admin/db/oracle/patches/016-updated-schema-for-tag-based-policy.sql
index f5b03c1..b46928c 100644
---
a/security-admin/db/oracle/patches/016-updated-schema-for-tag-based-policy.sql
+++
b/security-admin/db/oracle/patches/016-updated-schema-for-tag-based-policy.sql
@@ -203,7 +203,7 @@ added_by_id NUMBER(20) DEFAULT NULL NULL,
upd_by_id NUMBER(20) DEFAULT NULL NULL,
res_element_id NUMBER(20) NOT NULL,
value VARCHAR(1024) NOT NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_srvc_res_el_val_FK_res_el_id FOREIGN KEY (res_element_id)
REFERENCES x_service_resource_element (id),
CONSTRAINT x_srvc_res_el_val_FK_add_by_id FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
diff --git a/security-admin/db/oracle/patches/020-datamask-policy.sql
b/security-admin/db/oracle/patches/020-datamask-policy.sql
index 489fd3a..ebf691c 100644
--- a/security-admin/db/oracle/patches/020-datamask-policy.sql
+++ b/security-admin/db/oracle/patches/020-datamask-policy.sql
@@ -60,7 +60,7 @@ transformer VARCHAR(1024) DEFAULT NULL NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
-sort_order NUMBER(3) DEFAULT '0' NULL,
+sort_order NUMBER(10) DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_dm_type_def_FK_def_id FOREIGN KEY (def_id) REFERENCES
x_service_def(id),
CONSTRAINT x_dm_type_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES
x_portal_user(id),
diff --git
a/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
b/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
index 9a863e2..0e8fd9c 100644
--- a/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
+++ b/security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
@@ -642,7 +642,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_service_conf_def_FK_defid FOREIGN KEY(def_id) REFERENCES
x_service_def(id),
CONSTRAINT x_service_conf_def_FK_added_by FOREIGN KEY(added_by_id) REFERENCES
x_portal_user(id),
@@ -677,7 +677,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rowfilter_options VARCHAR(1024) DEFAULT NULL NULL,
primary key(id),
@@ -700,7 +700,7 @@ item_id BIGINT NOT NULL,
name VARCHAR(1024) DEFAULT NULL NULL,
label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rowfilter_options VARCHAR(1024) DEFAULT NULL NULL,
primary key(id),
@@ -746,7 +746,7 @@ description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
rb_key_validation_message VARCHAR(1024) DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_policy_cond_def_FK_defid FOREIGN KEY(def_id) REFERENCES
x_service_def(id),
CONSTRAINT x_policy_cond_def_FK_added_by FOREIGN KEY(added_by_id) REFERENCES
x_portal_user(id),
@@ -766,7 +766,7 @@ item_id BIGINT NOT NULL,
name VARCHAR(1024) DEFAULT NULL NULL,
enricher VARCHAR(1024) DEFAULT NULL NULL,
enricher_options VARCHAR(1024) DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_context_enricher_def_FK_defid FOREIGN KEY(def_id) REFERENCES
x_service_def(id),
CONSTRAINT x_context_enricher_def_FK_added_by_id FOREIGN KEY(added_by_id)
REFERENCES x_portal_user(id),
@@ -804,7 +804,7 @@ item_id BIGINT NOT NULL,
name VARCHAR(1024) DEFAULT NULL NULL,
label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_enum_element_def_FK_defid FOREIGN KEY(enum_def_id) REFERENCES
x_enum_def(id),
CONSTRAINT x_enum_element_def_FK_added_by FOREIGN KEY(added_by_id) REFERENCES
x_portal_user(id),
@@ -857,7 +857,7 @@ added_by_id BIGINT DEFAULT NULL NULL,
upd_by_id BIGINT DEFAULT NULL NULL,
resource_id BIGINT NOT NULL,
value VARCHAR(1024) DEFAULT NULL NULL,
-sort_order INT,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_policy_res_map_FK_res_id FOREIGN KEY(resource_id) REFERENCES
x_policy_resource(id),
CONSTRAINT x_policy_res_map_FK_added_by FOREIGN KEY(added_by_id) REFERENCES
x_portal_user(id),
@@ -874,7 +874,7 @@ added_by_id BIGINT DEFAULT NULL NULL,
upd_by_id BIGINT DEFAULT NULL NULL,
policy_id BIGINT NOT NULL,
delegate_admin BOOLEAN DEFAULT '0' NOT NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
item_type INT DEFAULT 0 NOT NULL,
is_enabled BOOLEAN DEFAULT '1' NOT NULL,
comments VARCHAR(255) DEFAULT NULL NULL,
@@ -895,7 +895,7 @@ upd_by_id BIGINT DEFAULT NULL NULL,
policy_item_id BIGINT NOT NULL,
type BIGINT NOT NULL,
is_allowed BOOLEAN DEFAULT '0' NOT NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_plc_item_access_FK_pi_id FOREIGN KEY(policy_item_id) REFERENCES
x_policy_item(id),
CONSTRAINT x_plc_item_access_FK_atd_id FOREIGN KEY(type) REFERENCES
x_access_type_def(id),
@@ -914,7 +914,7 @@ upd_by_id BIGINT DEFAULT NULL NULL,
policy_item_id BIGINT NOT NULL,
type BIGINT NOT NULL,
value VARCHAR(1024) DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_plc_item_cond_FK_pi_id FOREIGN KEY(policy_item_id) REFERENCES
x_policy_item(id),
CONSTRAINT x_plc_item_cond_FK_pcd_id FOREIGN KEY(type) REFERENCES
x_policy_condition_def(id),
@@ -932,7 +932,7 @@ added_by_id BIGINT DEFAULT NULL NULL,
upd_by_id BIGINT DEFAULT NULL NULL,
policy_item_id BIGINT NOT NULL,
user_id BIGINT DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_plc_itm_usr_perm_FK_pi_id FOREIGN KEY(policy_item_id) REFERENCES
x_policy_item(id),
CONSTRAINT x_plc_itm_usr_perm_FK_user_id FOREIGN KEY(user_id) REFERENCES
x_user(id),
@@ -950,7 +950,7 @@ added_by_id BIGINT DEFAULT NULL NULL,
upd_by_id BIGINT DEFAULT NULL NULL,
policy_item_id BIGINT NOT NULL,
group_id BIGINT DEFAULT NULL NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key(id),
CONSTRAINT x_plc_itm_grp_perm_FK_pi_id FOREIGN KEY(policy_item_id) REFERENCES
x_policy_item(id),
CONSTRAINT x_plc_itm_grp_perm_FK_group_id FOREIGN KEY(group_id) REFERENCES
x_group(id),
@@ -1113,7 +1113,7 @@ CREATE TABLE x_datamask_type_def (
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
- sort_order SMALLINT DEFAULT '0' NULL,
+ sort_order INT DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_datamask_type_def_FK_def_id FOREIGN KEY (def_id) REFERENCES
x_service_def (id) ,
CONSTRAINT x_datamask_type_def_FK_added_by_id FOREIGN KEY (added_by_id)
REFERENCES x_portal_user (id),
diff --git
a/security-admin/db/postgres/patches/016-updated-schema-for-tag-based-policy.sql
b/security-admin/db/postgres/patches/016-updated-schema-for-tag-based-policy.sql
index 59aec91..093b5b2 100644
---
a/security-admin/db/postgres/patches/016-updated-schema-for-tag-based-policy.sql
+++
b/security-admin/db/postgres/patches/016-updated-schema-for-tag-based-policy.sql
@@ -187,7 +187,7 @@ added_by_id BIGINT DEFAULT NULL NULL,
upd_by_id BIGINT DEFAULT NULL NULL,
res_element_id BIGINT NOT NULL,
value VARCHAR(1024) NOT NULL,
-sort_order SMALLINT DEFAULT '0' NULL,
+sort_order INT DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_srvc_res_el_val_FK_res_el_id FOREIGN KEY (res_element_id)
REFERENCES x_service_resource_element (id),
CONSTRAINT x_srvc_res_el_val_FK_add_by_id FOREIGN KEY (added_by_id) REFERENCES
x_portal_user (id),
diff --git a/security-admin/db/postgres/patches/020-datamask-policy.sql
b/security-admin/db/postgres/patches/020-datamask-policy.sql
index 79a509b..ea5b2ab 100644
--- a/security-admin/db/postgres/patches/020-datamask-policy.sql
+++ b/security-admin/db/postgres/patches/020-datamask-policy.sql
@@ -35,7 +35,7 @@ CREATE TABLE x_datamask_type_def (
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rb_key_label VARCHAR(1024) DEFAULT NULL NULL,
rb_key_description VARCHAR(1024) DEFAULT NULL NULL,
- sort_order SMALLINT DEFAULT '0' NULL,
+ sort_order INT DEFAULT '0' NULL,
primary key (id),
CONSTRAINT x_datamask_type_def_FK_def_id FOREIGN KEY (def_id) REFERENCES
x_service_def (id) ,
CONSTRAINT x_datamask_type_def_FK_added_by_id FOREIGN KEY (added_by_id)
REFERENCES x_portal_user (id),
diff --git
a/security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
b/security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
index 5ec62fb..5d37f08 100644
---
a/security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
+++
b/security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
@@ -589,7 +589,7 @@ create table dbo.x_service_config_def (
rb_key_label varchar(1024) DEFAULT NULL NULL,
rb_key_description varchar(1024) DEFAULT NULL NULL,
rb_key_validation_message varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_service_config_def_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -620,7 +620,7 @@ create table dbo.x_resource_def (
rb_key_label varchar(1024) DEFAULT NULL NULL,
rb_key_description varchar(1024) DEFAULT NULL NULL,
rb_key_validation_message varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rowfilter_options VARCHAR(1024) DEFAULT NULL NULL,
CONSTRAINT x_resource_def_PK_id PRIMARY KEY CLUSTERED(id)
@@ -638,7 +638,7 @@ create table dbo.x_access_type_def (
name varchar(1024) DEFAULT NULL NULL,
label varchar(1024) DEFAULT NULL NULL,
rb_key_label varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
datamask_options VARCHAR(1024) DEFAULT NULL NULL,
rowfilter_options VARCHAR(1024) DEFAULT NULL NULL,
CONSTRAINT x_access_type_def_PK_id PRIMARY KEY CLUSTERED(id)
@@ -676,7 +676,7 @@ create table dbo.x_policy_condition_def (
rb_key_label varchar(1024) DEFAULT NULL NULL,
rb_key_description varchar(1024) DEFAULT NULL NULL,
rb_key_validation_message varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_policy_condition_def_grants_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -692,7 +692,7 @@ create table dbo.x_context_enricher_def(
name varchar(1024) DEFAULT NULL NULL,
enricher varchar(1024) DEFAULT NULL NULL,
enricher_options varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_context_enricher_def_grants_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -722,7 +722,7 @@ create table dbo.x_enum_element_def (
name varchar(1024) DEFAULT NULL NULL,
label varchar(1024) DEFAULT NULL NULL,
rb_key_label varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_enum_element_def_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -762,7 +762,7 @@ create table dbo.x_policy_resource_map (
upd_by_id bigint DEFAULT NULL NULL,
resource_id bigint NOT NULL,
value varchar(1024) DEFAULT NULL NULL,
- sort_order INT DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_policy_resource_map_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -775,7 +775,7 @@ create table dbo.x_policy_item (
upd_by_id bigint DEFAULT NULL NULL,
policy_id bigint NOT NULL,
delegate_admin tinyint DEFAULT 0 NOT NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
item_type int DEFAULT 0 NOT NULL,
is_enabled tinyint DEFAULT 1 NOT NULL,
comments varchar(255) DEFAULT NULL NULL,
@@ -792,7 +792,7 @@ create table dbo.x_policy_item_access (
policy_item_id bigint NOT NULL,
type bigint NOT NULL,
is_allowed tinyint DEFAULT 0 NOT NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_policy_item_access_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -806,7 +806,7 @@ create table dbo.x_policy_item_condition (
policy_item_id bigint NOT NULL,
type bigint NOT NULL,
value varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_policy_item_condition_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -819,7 +819,7 @@ create table dbo.x_policy_item_user_perm (
upd_by_id bigint DEFAULT NULL NULL,
policy_item_id bigint NOT NULL,
user_id bigint DEFAULT NULL NULL,
- sort_order INT DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_policy_item_user_perm_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -832,7 +832,7 @@ create table dbo.x_policy_item_group_perm (
upd_by_id bigint DEFAULT NULL NULL,
policy_item_id bigint NOT NULL,
group_id bigint DEFAULT NULL NULL,
- sort_order INT DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_policy_item_group_perm_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
@@ -966,7 +966,7 @@ CREATE TABLE dbo.x_datamask_type_def(
datamask_options varchar(1024) DEFAULT NULL NULL,
rb_key_label varchar(1024) DEFAULT NULL NULL,
rb_key_description varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_datamask_type_def_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
diff --git
a/security-admin/db/sqlanywhere/patches/016-updated-schema-for-tag-based-policy.sql
b/security-admin/db/sqlanywhere/patches/016-updated-schema-for-tag-based-policy.sql
index a1c2f51..e6246ec 100644
---
a/security-admin/db/sqlanywhere/patches/016-updated-schema-for-tag-based-policy.sql
+++
b/security-admin/db/sqlanywhere/patches/016-updated-schema-for-tag-based-policy.sql
@@ -153,7 +153,7 @@ CREATE TABLE dbo.x_service_resource_element_val(
upd_by_id bigint DEFAULT NULL NULL,
res_element_id bigint NOT NULL,
value varchar(1024) NOT NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_srvc_res_el_val_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
diff --git a/security-admin/db/sqlanywhere/patches/020-datamask-policy.sql
b/security-admin/db/sqlanywhere/patches/020-datamask-policy.sql
index 3cc0447..8c17481 100644
--- a/security-admin/db/sqlanywhere/patches/020-datamask-policy.sql
+++ b/security-admin/db/sqlanywhere/patches/020-datamask-policy.sql
@@ -57,7 +57,7 @@ CREATE TABLE dbo.x_datamask_type_def(
datamask_options varchar(1024) DEFAULT NULL NULL,
rb_key_label varchar(1024) DEFAULT NULL NULL,
rb_key_description varchar(1024) DEFAULT NULL NULL,
- sort_order tinyint DEFAULT 0 NULL,
+ sort_order int DEFAULT 0 NULL,
CONSTRAINT x_datamask_type_def_PK_id PRIMARY KEY CLUSTERED(id)
)
GO
diff --git
a/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
b/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
index ee41452..16600e0 100644
--- a/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
+++ b/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
@@ -1489,7 +1489,7 @@ CREATE TABLE [dbo].[x_service_config_def] (
[rb_key_label] [varchar](1024) DEFAULT NULL NULL,
[rb_key_description] [varchar](1024) DEFAULT NULL NULL,
[rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
@@ -1525,7 +1525,7 @@ CREATE TABLE [dbo].[x_resource_def] (
[rb_key_label] [varchar](1024) DEFAULT NULL NULL,
[rb_key_description] [varchar](1024) DEFAULT NULL NULL,
[rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
[datamask_options] [varchar](1024) DEFAULT NULL NULL,
[rowfilter_options] [varchar](1024) DEFAULT NULL NULL,
PRIMARY KEY CLUSTERED
@@ -1548,7 +1548,7 @@ CREATE TABLE [dbo].[x_access_type_def] (
[name] [varchar](1024) DEFAULT NULL NULL,
[label] [varchar](1024) DEFAULT NULL NULL,
[rb_key_label] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
[datamask_options] [varchar](1024) DEFAULT NULL NULL,
[rowfilter_options] [varchar](1024) DEFAULT NULL NULL,
PRIMARY KEY CLUSTERED
@@ -1596,7 +1596,7 @@ CREATE TABLE [dbo].[x_policy_condition_def] (
[rb_key_label] [varchar](1024) DEFAULT NULL NULL,
[rb_key_description] [varchar](1024) DEFAULT NULL NULL,
[rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
@@ -1614,7 +1614,7 @@ CREATE TABLE [dbo].[x_context_enricher_def](
[name] [varchar](1024) DEFAULT NULL NULL,
[enricher] [varchar](1024) DEFAULT NULL NULL,
[enricher_options] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
@@ -1654,7 +1654,7 @@ CREATE TABLE [dbo].[x_enum_element_def] (
[name] [varchar](1024) DEFAULT NULL NULL,
[label] [varchar](1024) DEFAULT NULL NULL,
[rb_key_label] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
@@ -1727,7 +1727,7 @@ CREATE TABLE [dbo].[x_policy_item] (
[upd_by_id] [bigint] DEFAULT NULL NULL,
[policy_id] [bigint] NOT NULL,
[delegate_admin] [tinyint] DEFAULT 0 NOT NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
[item_type] [int] DEFAULT 0 NOT NULL,
[is_enabled] [tinyint] DEFAULT 1 NOT NULL,
[comments] [varchar](255) DEFAULT NULL NULL,
@@ -1749,7 +1749,7 @@ CREATE TABLE [dbo].[x_policy_item_access] (
[policy_item_id] [bigint] NOT NULL,
[type] [bigint] NOT NULL,
[is_allowed] [tinyint] DEFAULT 0 NOT NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
@@ -1768,7 +1768,7 @@ CREATE TABLE [dbo].[x_policy_item_condition] (
[policy_item_id] [bigint] NOT NULL,
[type] [bigint] NOT NULL,
[value] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
@@ -1998,7 +1998,7 @@ CREATE TABLE [dbo].[x_datamask_type_def](
[datamask_options] [varchar](1024) DEFAULT NULL NULL,
[rb_key_label] [varchar](1024) DEFAULT NULL NULL,
[rb_key_description] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
@@ -2440,7 +2440,7 @@ CREATE TABLE [dbo].[x_role](
[name] [varchar](255) NOT NULL,
[description] [varchar](1024) DEFAULT NULL NULL,
[role_options] [varchar](4000) DEFAULT NULL NULL,
-[role_text] [int] DEFAULT NULL NULL,
+[role_text] [nvarchar](max) DEFAULT NULL NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
diff --git
a/security-admin/db/sqlserver/patches/016-updated-schema-for-tag-based-policy.sql
b/security-admin/db/sqlserver/patches/016-updated-schema-for-tag-based-policy.sql
index c00bab1..561915f 100644
---
a/security-admin/db/sqlserver/patches/016-updated-schema-for-tag-based-policy.sql
+++
b/security-admin/db/sqlserver/patches/016-updated-schema-for-tag-based-policy.sql
@@ -364,7 +364,7 @@ CREATE TABLE [dbo].[x_service_resource_element_val](
[upd_by_id] [bigint] DEFAULT NULL NULL,
[res_element_id] [bigint] NOT NULL,
[value] [varchar](1024) NOT NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
diff --git a/security-admin/db/sqlserver/patches/020-datamask-policy.sql
b/security-admin/db/sqlserver/patches/020-datamask-policy.sql
index bd658e5..b67f3ae 100644
--- a/security-admin/db/sqlserver/patches/020-datamask-policy.sql
+++ b/security-admin/db/sqlserver/patches/020-datamask-policy.sql
@@ -101,7 +101,7 @@ CREATE TABLE [dbo].[x_datamask_type_def](
[datamask_options] [varchar](1024) DEFAULT NULL NULL,
[rb_key_label] [varchar](1024) DEFAULT NULL NULL,
[rb_key_description] [varchar](1024) DEFAULT NULL NULL,
- [sort_order] [tinyint] DEFAULT 0 NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
diff --git a/security-admin/db/sqlserver/patches/041-create-role-schema.sql
b/security-admin/db/sqlserver/patches/041-create-role-schema.sql
index a404281..d506a43 100644
--- a/security-admin/db/sqlserver/patches/041-create-role-schema.sql
+++ b/security-admin/db/sqlserver/patches/041-create-role-schema.sql
@@ -54,7 +54,7 @@ CREATE TABLE [dbo].[x_role](
[name] [varchar](255) NOT NULL,
[description] [varchar](1024) DEFAULT NULL NULL,
[role_options] [varchar](4000) DEFAULT NULL NULL,
-[role_text] [int] DEFAULT NULL NULL,
+[role_text] [nvarchar](max) DEFAULT NULL NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
