CREATE TABLE `aggr` (
  `AGGR_ID` int(10) NOT NULL AUTO_INCREMENT,
  `AGGR_NAME` text COLLATE latin1_general_cs NOT NULL,
  `AGGR_STATE` int(1) NOT NULL,
  `AGGR_PRIORITY` int(3) NOT NULL,
  `AGGR_MAILBOXNUMBER` text COLLATE latin1_general_cs,
  `AGGR_WAITINGAREASIZE` int(10) NOT NULL,
  `AGGR_DESCRIPTION` text COLLATE latin1_general_cs,
  `AGGR_ROUTINGMODE` int(1) NOT NULL,
  `AGGR_MAXWAITINGTIME` int(10) DEFAULT NULL,
  `AGGR_POSTCALLWORKMODE` int(1) NOT NULL,
  `AGGR_POSTCALLWORKTIME` int(10) DEFAULT NULL,
  `AGGR_ADDITIONINFO` text COLLATE latin1_general_cs,
  `AGGR_TIMEOUTFORRING` int(5) NOT NULL,
  `AGGR_MAXRECONNECTIONS` int(5) NOT NULL,
  `AGGR_CREATED_DT` varchar(25) COLLATE latin1_general_cs NOT NULL,
  `AGGR_CREATED_BY` text COLLATE latin1_general_cs NOT NULL,
  `AGGR_UPDATED_DT` varchar(25) COLLATE latin1_general_cs DEFAULT NULL,
  `AGGR_UPDATED_BY` text COLLATE latin1_general_cs,
  `AGGR_CALP_ID` int(10) DEFAULT NULL,
  `AGGR_WASIZESCR_ID` int(10) DEFAULT NULL,
  `AGGR_ISCTIGROUP` int(1) NOT NULL,
  `AGGR_AGENTS_REQUIERED` int(4) DEFAULT NULL,
  `AGGR_DISPLAYWA_CTI` int(1) DEFAULT NULL,
  `AGGR_MAXNOANSWER` int(3) DEFAULT NULL,
  `AGGR_MAILADDRESS` text COLLATE latin1_general_cs,
  `AGGR_VCFG_ID` int(10) DEFAULT NULL,
  `AGGR_VOICEBOXTYPE` int(3) DEFAULT NULL,
  `AGGR_MAXTALKTIME` int(5) DEFAULT NULL,
  `AGGR_CADDISPLAYMODE` int(2) DEFAULT NULL,
  `AGGR_REPORT_DAILY` text COLLATE latin1_general_cs,
  `AGGR_REPORT_WEEKLY` text COLLATE latin1_general_cs,
  `AGGR_REPORT_MONTHLY` text COLLATE latin1_general_cs,
  `AGGR_REPORT_YEARLY` text COLLATE latin1_general_cs,
  `AGGR_CTIMONITOR_BY` text COLLATE latin1_general_cs,
  `AGGR_MAIL_MAXWORKTIME` int(5) DEFAULT NULL,
  `AGGR_MAXMAILSPERAGENT` int(4) DEFAULT NULL,
  `AGGR_MAIL_WASIZE` int(10) DEFAULT NULL,
  `AGGR_MAIL_WAMAXTIME` int(10) DEFAULT NULL,
  `AGGR_MAIL_WASIZE_SCRID` int(10) DEFAULT NULL,
  `AGGR_MAIL_ROUTINGMODE` int(2) DEFAULT NULL,
  `AGGR_MAIL_ANSWERTEXT` longtext COLLATE latin1_general_cs,
  `AGGR_MAIL_KEYWORDS` longtext COLLATE latin1_general_cs,
  `AGGR_CTIMONITOR_RIGHTS` text COLLATE latin1_general_cs,
  `AGGR_AGENT_WORKPLACES` text COLLATE latin1_general_cs,
  `AGGR_MAIL_SENDER` text COLLATE latin1_general_cs,
  `AGGR_ALLOWCONFIGURATIONFROM` text COLLATE latin1_general_cs,
  `AGGR_EXTERN_ID` text COLLATE latin1_general_cs,
  `AGGR_LOGDIRINCALLS` int(3) DEFAULT NULL,
  `AGGR_LOGDIROUTCALLS` int(3) DEFAULT NULL,
  `AGGR_NOTAVAIL_REASONS` longtext COLLATE latin1_general_cs,
  `AGGR_HIDEAGENTS_CTI` int(1) DEFAULT NULL,
  `AGGR_DELAYACCEPTCALL` int(1) DEFAULT NULL,
  `AGGR_ONETIMECALLOFFERING` int(1) DEFAULT NULL,
  `AGGR_CAD_SHOW_REDNUM` int(1) DEFAULT NULL,
  `AGGR_CALLATTACHEDDISPLAYINFO` text COLLATE latin1_general_cs,
  `AGGR_DEFAULTFORM` int(10) DEFAULT NULL,
  `AGGR_ANONYMIZE_SETTINGS` text COLLATE latin1_general_cs,
  `AGGR_FORMEXPPATH` text COLLATE latin1_general_cs,
  `AGGR_AGENTANONYMIZE` int(3) DEFAULT NULL,
  `AGGR_RANK` int(4) DEFAULT NULL,
  `AGGR_PREFERIFMAIN` int(1) DEFAULT NULL,
  `AGGR_DC_PROFILE` text COLLATE latin1_general_cs,
  `AGGR_ALLOWBROADCAST` text COLLATE latin1_general_cs,
  `AGGR_CALLBLENDING` int(2) DEFAULT NULL,
  `AGGR_CHAT_MAXANSWERTIME` int(10) DEFAULT NULL,
  `AGGR_MAXAGENTS_ALLOWED` int(10) DEFAULT NULL,
  `AGGR_CHAT_MAXSESSIONS` int(10) DEFAULT NULL,
  `AGGR_CHAT_WELCOMETXT` text COLLATE latin1_general_cs,
  `AGGR_CHAT_WASIZE` int(10) DEFAULT NULL,
  `AGGR_CHAT_WAMAXTIME` int(10) DEFAULT NULL,
  `AGGR_CHAT_WASIZE_SCRID` int(10) DEFAULT NULL,
  `AGGR_AUTOAVAIL_AFTERNOANSW` int(1) DEFAULT NULL,
  `AGGR_OUTBOUND_MODE` int(3) DEFAULT NULL,
  `AGGR_OUTBOUND_PREFIX` text COLLATE latin1_general_cs,
  `AGGR_OUTBOUND_FORMID` int(10) DEFAULT NULL,
  `AGGR_OUTBOUND_POSTCALLWORKMODE` int(3) DEFAULT NULL,
  `AGGR_OUTBOUND_POSTCALLWORKTIME` int(10) DEFAULT NULL,
  `AGGR_MAX_HUNTAGENTCOUNT` int(10) DEFAULT NULL,
  `AGGR_LOSTCALL_CONFIG` longtext COLLATE latin1_general_cs,
  `AGGR_SUPRESS_CALLHISTORY` int(1) DEFAULT NULL,
  `AGGR_CALL_WATRANSFERMUSIC` int(1) DEFAULT NULL,
  `AGGR_EDITINGADMINID` int(10) DEFAULT NULL,
  `AGGR_ORGOBJID` int(10) DEFAULT NULL,
  `AGGR_DELETEFLAG` int(1) DEFAULT NULL,
  `AGGR_TENANTID` int(10) DEFAULT NULL,
  `AGGR_CALLBACK_CONFIG` longtext COLLATE latin1_general_cs,
  `AGGR_DIRECTCALLSETTINGS` text COLLATE latin1_general_cs,
  `AGGR_RECORDING_STATE` int(3) DEFAULT NULL,
  `AGGR_RECORDING_CONTENT` int(3) DEFAULT NULL,
  `AGGR_RECORDING_PARTICIPANT` int(3) DEFAULT NULL,
  `AGGR_RECORDING_FORMAT` int(3) DEFAULT NULL,
  `AGGR_RECORDING_RECYCLETIME` int(10) DEFAULT NULL,
  `AGGR_RECORDING_PATH` text COLLATE latin1_general_cs,
  `AGGR_MAIL_KEEPORIGINALTO` int(1) DEFAULT NULL,
  `AGGR_LOSTACALL_RECORDING` longtext COLLATE latin1_general_cs,
  `AGGR_AUTOLOGON` int(1) DEFAULT NULL,
  `AGGR_PP_INTERVALL` text COLLATE latin1_general_cs,
  `AGGR_MAIL_OPERATIONMODE` int(3) DEFAULT NULL,
  `AGGR_PL_DASHBOARD` longtext COLLATE latin1_general_cs,
  `AGGR_OUT_RECORDINGSTATE` int(3) DEFAULT NULL,
  `AGGR_OUT_REC_PARTICIPANT` int(3) DEFAULT NULL,
  `AGGR_OUT_REC_FORMAT` int(3) DEFAULT NULL,
  `AGGR_OUT_REC_RECYCLETIME` int(10) DEFAULT NULL,
  `AGGR_OUT_REC_PATH` text COLLATE latin1_general_cs,
  `AGGR_OUT_FORMEXPPATH` text COLLATE latin1_general_cs,
  `AGGR_WEB_ACTIVE` int(3) DEFAULT NULL,
  `AGGR_WEB_USER` text COLLATE latin1_general_cs,
  `AGGR_WEB_PASSWD` text COLLATE latin1_general_cs,
  `AGGR_WEB_DYNVXML` int(3) DEFAULT NULL,
  `AGGR_WEB_DYNPHONE` int(3) DEFAULT NULL,
  `AGGR_WEB_DYNWORKTIME` int(3) DEFAULT NULL,
  `AGGR_WEB_DYNOPTIONS` int(3) DEFAULT NULL,
  `AGGR_DYNSETTINGSXML` longtext COLLATE latin1_general_cs,
  `AGGR_MAIL_DISTRIBUTIONGROUPS` text COLLATE latin1_general_cs,
  `AGGR_MAIL_MESSAGEFORMATTING` int(3) DEFAULT NULL,
  `AGGR_MAIL_ESCALATION` text COLLATE latin1_general_cs,
  `AGGR_MAIL_SIG_ID` int(10) DEFAULT NULL,
  `AGGR_MAIL_FOOTER_ID` int(10) DEFAULT NULL,
  `AGGR_OUTBOUNDTARGET` text COLLATE latin1_general_cs,
  PRIMARY KEY (`AGGR_ID`),
  KEY `AGGR_IDX_EDIT` (`AGGR_EDITINGADMINID`,`AGGR_DELETEFLAG`,`AGGR_ORGOBJID`)
) ENGINE=InnoDB AUTO_INCREMENT=65521570 DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs ROW_FORMAT=DYNAMIC