use text instead of varchar(66536) for iam2/ticket schema
@@ -44,7 +44,7 @@ CREATE TABLE `RoleVO` (
CREATE TABLE `RolePolicyStatementVO` (
`uuid` VARCHAR(32) NOT NULL,
`roleUuid` VARCHAR(32) NOT NULL,
- `statement` VARCHAR(65535) NOT NULL,
+ `statement` text NOT NULL,
`lastOpDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`createDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`uuid`)
@@ -207,7 +207,7 @@ CREATE TABLE `IAM2ProjectTemplateVO` (
`uuid` VARCHAR(32) NOT NULL,
`name` VARCHAR(255) NOT NULL UNIQUE,
`description` VARCHAR(2048) DEFAULT NULL,
- `template` VARCHAR(65535) NOT NULL,
+ `template` text NOT NULL,
`lastOpDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`createDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`uuid`)
@@ -223,7 +223,7 @@ CREATE TABLE `TicketFlowVO` (
`description` VARCHAR(2048) DEFAULT NULL,
`collectionUuid` VARCHAR(32) NOT NULL,
`parentFlowUuid` VARCHAR(32) DEFAULT NULL,
- `flowContext` VARCHAR(65535) NOT NULL,
+ `flowContext` text NOT NULL,
`flowContextType` VARCHAR(255) NOT NULL,
`lastOpDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`createDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -245,10 +245,10 @@ CREATE TABLE `TicketStatusHistoryVO` (
`ticketUuid` VARCHAR(32) NOT NULL,
`fromStatus` VARCHAR(255) NOT NULL,
`toStatus` VARCHAR(255) NOT NULL,
- `comment` VARCHAR(65535) DEFAULT NULL,
+ `comment` text DEFAULT NULL,
`operatorUuid` VARCHAR(32) NOT NULL,
`operatorType` VARCHAR(255) NOT NULL,
- `operationContext` VARCHAR(65535) DEFAULT NULL,
+ `operationContext` text DEFAULT NULL,
`operationContextType` VARCHAR(255) DEFAULT NULL,
`lastOpDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`createDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -258,11 +258,11 @@ CREATE TABLE `TicketStatusHistoryVO` (
CREATE TABLE `TicketVO` (
`uuid` VARCHAR(32) NOT NULL,
`name` VARCHAR(255) DEFAULT NULL,
- `description` VARCHAR(65535) DEFAULT NULL,
+ `description` text DEFAULT NULL,
`status` VARCHAR(255) NOT NULL,
`accountSystemType` VARCHAR(255) NOT NULL,
- `accountSystemContext` VARCHAR(65535) DEFAULT NULL,
- `requests` VARCHAR(65535) NOT NULL,
+ `accountSystemContext` text DEFAULT NULL,
+ `requests` text NOT NULL,
`flowCollectionUuid` VARCHAR(32) NOT NULL,
`currentFlowUuid` VARCHAR(32) DEFAULT NULL,
`lastOpDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
