Diagram Report

Project
Diagram	Noname2
Company
Author
Version
Created	7/6/2005 11:10:00 PM
Last modified	7/6/2005 11:10:00 PM

Database Description
Database Annotation	<%DBAnnotation%>

Database Name	Database_1
Database Character Set
Database Collate
Comment
Database Create SQL	CREATE DATABASE IF NOT EXISTS `Database_1`; USE `Database_1`;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
campaignid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(255)	NO	YES	NO
redirecturl	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	campaignid

Table Create SQL

CREATE TABLE `swadcampaigns` (
  `campaignid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `redirecturl` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`campaignid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
hitlogid	int(10)	YES	YES	YES	UNSIGNED
campaignid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
referrer	varchar(255)	NO	YES	NO
browser	varchar(255)	NO	YES	NO
platform	varchar(255)	NO	YES	NO
ipaddress	varchar(32)	NO	YES	NO

IndexName	Columns
PRIMARY	hitlogid
FKIndex1	campaignid

Table Create SQL

CREATE TABLE `swadhitlogs` (
  `hitlogid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `campaignid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `referrer` varchar(255) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `ipaddress` varchar(32) NOT NULL,
  PRIMARY KEY(`hitlogid`),
  INDEX `FKIndex1`(`campaignid`),
  CONSTRAINT `Reference_01` FOREIGN KEY (`campaignid`)
    REFERENCES `swadcampaigns`(`campaignid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
searchqueryid	int(10)	YES	YES	YES	UNSIGNED
campaignid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
enginename	varchar(255)	NO	YES	NO
searchquery	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	searchqueryid
FKIndex1	campaignid

Table Create SQL

CREATE TABLE `swadsearchqueries` (
  `searchqueryid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `campaignid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `enginename` varchar(255) NOT NULL,
  `searchquery` varchar(255) NOT NULL,
  PRIMARY KEY(`searchqueryid`),
  INDEX `FKIndex1`(`campaignid`),
  CONSTRAINT `Reference_02` FOREIGN KEY (`campaignid`)
    REFERENCES `swadcampaigns`(`campaignid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
alertactionid	int(10)	YES	YES	YES	UNSIGNED
alertruleid	int(10)	NO	YES	NO	UNSIGNED	0
actiontype	smallint(3)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	alertactionid
alertactions1	actiontype
FKIndex1	alertruleid

Table Create SQL

CREATE TABLE `swalertactions` (
  `alertactionid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `alertruleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `actiontype` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`alertactionid`),
  INDEX `alertactions1`(`actiontype`),
  INDEX `FKIndex1`(`alertruleid`),
  CONSTRAINT `Reference_04` FOREIGN KEY (`alertruleid`)
    REFERENCES `swalertrules`(`alertruleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
alertruleid	int(10)	YES	YES	YES	UNSIGNED
alertscope	smallint(1)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
priorityid	int(10)	NO	YES	NO	UNSIGNED	0
ticketstatusid	int(10)	NO	YES	NO	UNSIGNED	0
alerttype	smallint(1)	NO	YES	NO	UNSIGNED	0
execassign	smallint(1)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	alertruleid
alertrules1	alertscope,staffid
FKIndex1	departmentid
FKIndex2	staffid
FKIndex3	priorityid
FKIndex4	ticketstatusid

Table Create SQL

CREATE TABLE `swalertrules` (
  `alertruleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `alertscope` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `priorityid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `alerttype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `execassign` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  PRIMARY KEY(`alertruleid`),
  INDEX `alertrules1`(`alertscope`, `staffid`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `FKIndex2`(`staffid`),
  INDEX `FKIndex3`(`priorityid`),
  INDEX `FKIndex4`(`ticketstatusid`),
  CONSTRAINT `Reference_27` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_73` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_122` FOREIGN KEY (`priorityid`)
    REFERENCES `swticketpriorities`(`priorityid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_136` FOREIGN KEY (`ticketstatusid`)
    REFERENCES `swticketstatus`(`ticketstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
chunkid	int(10)	YES	YES	YES	UNSIGNED
attachmentid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumblob	NO	YES	NO

IndexName	Columns
PRIMARY	chunkid
FKIndex1	attachmentid

Table Create SQL

CREATE TABLE `swattachmentchunks` (
  `chunkid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `attachmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumblob NOT NULL,
  PRIMARY KEY(`chunkid`),
  INDEX `FKIndex1`(`attachmentid`),
  CONSTRAINT `Reference_05` FOREIGN KEY (`attachmentid`)
    REFERENCES `swattachments`(`attachmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
attachmentid	int(10)	YES	YES	YES	UNSIGNED
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
ticketpostid	int(10)	NO	YES	NO	UNSIGNED	0
downloaditemid	int(10)	NO	YES	NO	UNSIGNED	0
filename	varchar(255)	NO	YES	NO
filesize	int(10)	NO	YES	NO	UNSIGNED	0
filetype	varchar(150)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
attachmenttype	smallint(1)	NO	YES	NO	UNSIGNED	0
storefilename	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	attachmentid
FKIndex1	downloaditemid
attachments1	ticketpostid
FKIndex3	ticketid

Table Create SQL

CREATE TABLE `swattachments` (
  `attachmentid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketpostid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `downloaditemid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `filename` varchar(255) NOT NULL,
  `filesize` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `filetype` varchar(150) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `attachmenttype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `storefilename` varchar(255) NOT NULL,
  PRIMARY KEY(`attachmentid`),
  INDEX `FKIndex1`(`downloaditemid`),
  INDEX `attachments1`(`ticketpostid`),
  INDEX `FKIndex3`(`ticketid`),
  CONSTRAINT `Reference_40` FOREIGN KEY (`downloaditemid`)
    REFERENCES `swdownloaditems`(`downloaditemid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_119` FOREIGN KEY (`ticketpostid`)
    REFERENCES `swticketposts`(`ticketpostid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_128` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
attachmenttypeid	int(10)	YES	YES	YES	UNSIGNED
extension	varchar(10)	NO	YES	NO
maxsize	int(10)	NO	YES	NO	UNSIGNED	0
mimetype	varchar(150)	NO	YES	NO

IndexName	Columns
PRIMARY	attachmenttypeid

Table Create SQL

CREATE TABLE `swattachmenttypes` (
  `attachmenttypeid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `extension` varchar(10) NOT NULL,
  `maxsize` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `mimetype` varchar(150) NOT NULL,
  PRIMARY KEY(`attachmenttypeid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
auditlogid	int(10)	YES	YES	YES	UNSIGNED
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
userid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
logtype	smallint(3)	NO	YES	NO	UNSIGNED	0
actiontype	smallint(3)	NO	YES	NO	UNSIGNED	0
actionmsg	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	auditlogid
FKIndex1	departmentid
FKIndex2	staffid
auditlogs1	ticketid
FKIndex4	userid

Table Create SQL

CREATE TABLE `swauditlogs` (
  `auditlogid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `logtype` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `actiontype` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `actionmsg` varchar(255) NOT NULL,
  PRIMARY KEY(`auditlogid`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `FKIndex2`(`staffid`),
  INDEX `auditlogs1`(`ticketid`),
  INDEX `FKIndex4`(`userid`),
  CONSTRAINT `Reference_28` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_74` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_129` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_149` FOREIGN KEY (`userid`)
    REFERENCES `swusers`(`userid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
breaklineid	int(10)	YES	YES	YES	UNSIGNED
breakline	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	breaklineid

Table Create SQL

CREATE TABLE `swbreaklines` (
  `breaklineid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `breakline` varchar(255) NOT NULL,
  PRIMARY KEY(`breaklineid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
calendarcategoryid	int(10)	YES	YES	YES	UNSIGNED
categorytype	smallint(1)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	calendarcategoryid
calendarcategories1	categorytype

Table Create SQL

CREATE TABLE `swcalendarcategories` (
  `calendarcategoryid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `categorytype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`calendarcategoryid`),
  INDEX `calendarcategories1`(`categorytype`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
calendardataid	int(10)	YES	YES	YES	UNSIGNED
datatype	smallint(1)	NO	YES	NO	UNSIGNED	0
typeid	int(10)	NO	YES	NO	UNSIGNED	0
contents	text	NO	YES	NO

IndexName	Columns
PRIMARY	calendardataid
calendardata1	datatype,typeid

Table Create SQL

CREATE TABLE `swcalendardata` (
  `calendardataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `datatype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` text NOT NULL,
  PRIMARY KEY(`calendardataid`),
  INDEX `calendardata1`(`datatype`, `typeid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
calendareventid	int(10)	YES	YES	YES	UNSIGNED
eventtype	enum('public','private')	NO	YES	NO		public
ownerstaffid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
isalldayevent	smallint(1)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
subject	varchar(255)	NO	YES	NO
startdateline	int(10)	NO	YES	NO	UNSIGNED	0
duration	int(10)	NO	YES	NO	UNSIGNED	0
enddateline	int(10)	NO	YES	NO	UNSIGNED	0
activitytype	smallint(1)	NO	YES	NO	UNSIGNED	0
location	varchar(255)	NO	YES	NO
calendarstatusid	int(10)	NO	YES	NO	UNSIGNED	0
calendarlabelid	int(10)	NO	YES	NO	UNSIGNED	0
calendarcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
lastupdate	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	calendareventid
calendarevent1	eventtype,staffid,startdateline
FKIndex1	calendarcategoryid
FKIndex2	calendarlabelid
FKIndex3	calendarstatusid
FKIndex4	staffid

Table Create SQL

CREATE TABLE `swcalendarevents` (
  `calendareventid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `eventtype` enum('public','private') NOT NULL DEFAULT 'public',
  `ownerstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `isalldayevent` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL,
  `startdateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `duration` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `enddateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `activitytype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `location` varchar(255) NOT NULL,
  `calendarstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `calendarlabelid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `calendarcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastupdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`calendareventid`),
  INDEX `calendarevent1`(`eventtype`, `staffid`, `startdateline`),
  INDEX `FKIndex1`(`calendarcategoryid`),
  INDEX `FKIndex2`(`calendarlabelid`),
  INDEX `FKIndex3`(`calendarstatusid`),
  INDEX `FKIndex4`(`staffid`),
  CONSTRAINT `Reference_06` FOREIGN KEY (`calendarcategoryid`)
    REFERENCES `swcalendarcategories`(`calendarcategoryid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_08` FOREIGN KEY (`calendarlabelid`)
    REFERENCES `swcalendarlabels`(`calendarlabelid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_11` FOREIGN KEY (`calendarstatusid`)
    REFERENCES `swcalendarstatus`(`calendarstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_75` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
calendarlabelid	int(10)	YES	YES	YES	UNSIGNED
labeltype	smallint(1)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
labelcolorcode	varchar(20)	NO	YES	NO		#FFFFFF
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	calendarlabelid
calendarlabels1	labeltype

Table Create SQL

CREATE TABLE `swcalendarlabels` (
  `calendarlabelid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `labeltype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `labelcolorcode` varchar(20) NOT NULL DEFAULT '#FFFFFF',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`calendarlabelid`),
  INDEX `calendarlabels1`(`labeltype`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
linktype	smallint(1)	YES	YES	NO	UNSIGNED	0
entryid	varchar(50)	YES	YES	NO
typeid	int(10)	YES	YES	NO	UNSIGNED	0
guidid	int(10)	YES	YES	NO	UNSIGNED	0
lastupdate	int(10)	NO	YES	NO	UNSIGNED	0
lastswiftupdate	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	linktype,entryid,typeid,guidid
linktype	linktype,entryid,typeid,guidid
calendarlinks1	entryid
calendarlinks2	guidid

Table Create SQL

CREATE TABLE `swcalendarlinks` (
  `linktype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `entryid` varchar(50) NOT NULL,
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `guidid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastupdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastswiftupdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`linktype`, `entryid`, `typeid`, `guidid`),
  UNIQUE INDEX `linktype`(`linktype`, `entryid`, `typeid`, `guidid`),
  INDEX `calendarlinks1`(`entryid`),
  INDEX `calendarlinks2`(`guidid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
calendarpriorityid	int(10)	YES	YES	YES	UNSIGNED
prioritytype	smallint(1)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
prioritycolorcode	varchar(20)	NO	YES	NO		#FFFFFF
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	calendarpriorityid
calendarpriorities1	prioritytype

Table Create SQL

CREATE TABLE `swcalendarpriorities` (
  `calendarpriorityid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `prioritytype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `prioritycolorcode` varchar(20) NOT NULL DEFAULT '#FFFFFF',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`calendarpriorityid`),
  INDEX `calendarpriorities1`(`prioritytype`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
calendarstatusid	int(10)	YES	YES	YES	UNSIGNED
statustype	smallint(1)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
statuscolorcode	varchar(20)	NO	YES	NO		#FFFFFF
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	calendarstatusid
calendarstatus1	statustype

Table Create SQL

CREATE TABLE `swcalendarstatus` (
  `calendarstatusid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `statustype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `statuscolorcode` varchar(20) NOT NULL DEFAULT '#FFFFFF',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`calendarstatusid`),
  INDEX `calendarstatus1`(`statustype`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
calendartaskid	int(10)	YES	YES	YES	UNSIGNED
ownerstaffid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
duedate	int(10)	NO	YES	NO	UNSIGNED	0
startdate	int(10)	NO	YES	NO	UNSIGNED	0
contactid	int(10)	NO	YES	NO	UNSIGNED	0
completepercent	int(3)	NO	YES	NO	UNSIGNED	0
iscomplete	smallint(1)	NO	YES	NO	UNSIGNED	0
tasktype	enum('public','private')	NO	YES	NO		public
subject	varchar(255)	NO	YES	NO
calendarlabelid	int(10)	NO	YES	NO	UNSIGNED	0
calendarstatusid	int(10)	NO	YES	NO	UNSIGNED	0
calendarpriorityid	int(10)	NO	YES	NO	UNSIGNED	0
lastupdate	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	calendartaskid
calendartasks1	ownerstaffid,duedate
calendartasks2	tasktype,staffid
FKIndex1	calendarlabelid
FKIndex2	calendarpriorityid
FKIndex3	calendarstatusid
FKIndex4	contactid
FKIndex5	staffid

Table Create SQL

CREATE TABLE `swcalendartasks` (
  `calendartaskid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ownerstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `duedate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `startdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contactid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `completepercent` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `iscomplete` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `tasktype` enum('public','private') NOT NULL DEFAULT 'public',
  `subject` varchar(255) NOT NULL,
  `calendarlabelid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `calendarstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `calendarpriorityid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastupdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`calendartaskid`),
  INDEX `calendartasks1`(`ownerstaffid`, `duedate`),
  INDEX `calendartasks2`(`tasktype`, `staffid`),
  INDEX `FKIndex1`(`calendarlabelid`),
  INDEX `FKIndex2`(`calendarpriorityid`),
  INDEX `FKIndex3`(`calendarstatusid`),
  INDEX `FKIndex4`(`contactid`),
  INDEX `FKIndex5`(`staffid`),
  CONSTRAINT `Reference_09` FOREIGN KEY (`calendarlabelid`)
    REFERENCES `swcalendarlabels`(`calendarlabelid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_10` FOREIGN KEY (`calendarpriorityid`)
    REFERENCES `swcalendarpriorities`(`calendarpriorityid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_12` FOREIGN KEY (`calendarstatusid`)
    REFERENCES `swcalendarstatus`(`calendarstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_20` FOREIGN KEY (`contactid`)
    REFERENCES `swcontacts`(`contactid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_76` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
cannedcategoryid	int(10)	YES	YES	YES	UNSIGNED
parentcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
categorytype	smallint(1)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	cannedcategoryid
cannedcategories1	parentcategoryid
cannedcategories2	categorytype,staffid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swcannedcategories` (
  `cannedcategoryid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parentcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `categorytype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  PRIMARY KEY(`cannedcategoryid`),
  INDEX `cannedcategories1`(`parentcategoryid`),
  INDEX `cannedcategories2`(`categorytype`, `staffid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_77` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
cannedresponsedataid	int(10)	YES	YES	YES	UNSIGNED
cannedresponseid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	cannedresponsedataid
cannedresponsesdata1	cannedresponseid

Table Create SQL

CREATE TABLE `swcannedresponsedata` (
  `cannedresponsedataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cannedresponseid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`cannedresponsedataid`),
  INDEX `cannedresponsesdata1`(`cannedresponseid`),
  CONSTRAINT `Reference_14` FOREIGN KEY (`cannedresponseid`)
    REFERENCES `swcannedresponses`(`cannedresponseid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
cannedresponseid	int(10)	YES	YES	YES	UNSIGNED
cannedcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
responsetype	varchar(20)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	cannedresponseid
cannedresponses1	cannedcategoryid
cannedresponses2	staffid

Table Create SQL

CREATE TABLE `swcannedresponses` (
  `cannedresponseid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cannedcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `responsetype` varchar(20) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`cannedresponseid`),
  INDEX `cannedresponses1`(`cannedcategoryid`),
  INDEX `cannedresponses2`(`staffid`),
  CONSTRAINT `Reference_13` FOREIGN KEY (`cannedcategoryid`)
    REFERENCES `swcannedcategories`(`cannedcategoryid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_78` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
catchallruleid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(255)	NO	YES	NO
ruleexpr	varchar(255)	NO	YES	NO
emailqueueid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
sortorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	catchallruleid
FKIndex1	emailqueueid

Table Create SQL

CREATE TABLE `swcatchallrules` (
  `catchallruleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `ruleexpr` varchar(255) NOT NULL,
  `emailqueueid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sortorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`catchallruleid`),
  INDEX `FKIndex1`(`emailqueueid`),
  CONSTRAINT `Reference_42` FOREIGN KEY (`emailqueueid`)
    REFERENCES `swemailqueues`(`emailqueueid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	HEAP
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
chatchildid	varchar(32)	YES	YES	NO
chatobjectid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	chatchildid
staffid	chatobjectid,staffid
FKIndex1	chatobjectid
FKIndex2	staffid

Table Create SQL

CREATE TABLE `swchatchilds` (
  `chatchildid` varchar(32) NOT NULL,
  `chatobjectid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`chatchildid`),
  INDEX `staffid`(`chatobjectid`, `staffid`),
  INDEX `FKIndex1`(`chatobjectid`),
  INDEX `FKIndex2`(`staffid`),
  CONSTRAINT `Reference_16` FOREIGN KEY (`chatobjectid`)
    REFERENCES `swchatobjects`(`chatobjectid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_79` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=HEAP
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
chatdataid	int(10)	YES	YES	YES	UNSIGNED
chatobjectid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	chatdataid
cobjid	chatobjectid

Table Create SQL

CREATE TABLE `swchatdata` (
  `chatdataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `chatobjectid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`chatdataid`),
  INDEX `cobjid`(`chatobjectid`),
  CONSTRAINT `Reference_17` FOREIGN KEY (`chatobjectid`)
    REFERENCES `swchatobjects`(`chatobjectid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
chatobjectid	int(10)	YES	YES	YES	UNSIGNED
visitorsessionid	varchar(32)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
lastpostactivity	int(10)	NO	YES	NO	UNSIGNED	0
userpostactivity	int(10)	NO	YES	NO	UNSIGNED	0
staffpostactivity	int(10)	NO	YES	NO	UNSIGNED	0
userid	int(10)	NO	YES	NO	UNSIGNED	0
userfullname	varchar(150)	NO	YES	NO
useremail	varchar(255)	NO	YES	NO
staffid	int(10)	NO	YES	NO	UNSIGNED	0
staffname	varchar(150)	NO	YES	NO
chatstatus	smallint(5)	NO	YES	NO	UNSIGNED	0
transferfromid	int(10)	NO	YES	NO	UNSIGNED	0
transfertoid	int(10)	NO	YES	NO	UNSIGNED	0
transferstatus	smallint(1)	NO	YES	NO	UNSIGNED	0
transfertimeline	int(10)	NO	YES	NO	UNSIGNED	0
roundrobintimeline	int(10)	NO	YES	NO	UNSIGNED	0
roundrobinhits	int(10)	NO	YES	NO	UNSIGNED	0
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
departmenttitle	varchar(100)	NO	YES	NO
chattype	smallint(5)	NO	YES	NO	UNSIGNED	0
ipaddress	varchar(50)	NO	YES	NO
isproactive	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	chatobjectid
chatobjects1	chatstatus,staffid
chatobjects2	chatstatus,chattype
chatobjects6	ipaddress
chatobjects7	departmentid,dateline
chatobjects8	useremail
FKIndex1	departmentid
chatobjects4	staffid
chatobjects5	userid
chatobjects3	visitorsessionid

Table Create SQL

CREATE TABLE `swchatobjects` (
  `chatobjectid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `visitorsessionid` varchar(32) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastpostactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userpostactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffpostactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userfullname` varchar(150) NOT NULL,
  `useremail` varchar(255) NOT NULL,
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffname` varchar(150) NOT NULL,
  `chatstatus` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `transferfromid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `transfertoid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `transferstatus` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `transfertimeline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `roundrobintimeline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `roundrobinhits` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmenttitle` varchar(100) NOT NULL,
  `chattype` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `ipaddress` varchar(50) NOT NULL,
  `isproactive` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`chatobjectid`),
  INDEX `chatobjects1`(`chatstatus`, `staffid`),
  INDEX `chatobjects2`(`chatstatus`, `chattype`),
  INDEX `chatobjects6`(`ipaddress`),
  INDEX `chatobjects7`(`departmentid`, `dateline`),
  INDEX `chatobjects8`(`useremail`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `chatobjects4`(`staffid`),
  INDEX `chatobjects5`(`userid`),
  INDEX `chatobjects3`(`visitorsessionid`),
  CONSTRAINT `Reference_29` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_80` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_150` FOREIGN KEY (`userid`)
    REFERENCES `swusers`(`userid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_157` FOREIGN KEY (`visitorsessionid`)
    REFERENCES `swvisitorpulls`(`visitorsessionid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
commentdataid	int(10)	YES	YES	YES	UNSIGNED
commentid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	commentdataid
commentdata1	commentid

Table Create SQL

CREATE TABLE `swcommentdata` (
  `commentdataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `commentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`commentdataid`),
  INDEX `commentdata1`(`commentid`),
  CONSTRAINT `Reference_19` FOREIGN KEY (`commentid`)
    REFERENCES `swcomments`(`commentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
commentid	int(10)	YES	YES	YES	UNSIGNED
typeid	int(10)	NO	YES	NO	UNSIGNED	0
commenttype	smallint(2)	NO	YES	NO	UNSIGNED	0
fullname	varchar(255)	NO	YES	NO
email	varchar(255)	NO	YES	NO
isapproved	smallint(1)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	commentid
comments1	commenttype,isapproved,typeid

Table Create SQL

CREATE TABLE `swcomments` (
  `commentid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `commenttype` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
  `fullname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `isapproved` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`commentid`),
  INDEX `comments1`(`commenttype`, `isapproved`, `typeid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
contactid	int(10)	YES	YES	YES	UNSIGNED
contacttype	enum('public','private')	NO	YES	NO		public
staffid	int(10)	NO	YES	NO	UNSIGNED	0
fullname	varchar(255)	NO	YES	NO
jobtitle	varchar(255)	NO	YES	NO
initials	varchar(5)	NO	YES	NO
calendarcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
email1address	varchar(255)	NO	YES	NO
email2address	varchar(255)	NO	YES	NO
email3address	varchar(255)	NO	YES	NO
customerid	varchar(100)	NO	YES	NO
mobiletelephonenumber	varchar(255)	NO	YES	NO
cartelephonenumber	varchar(255)	NO	YES	NO
pagernumber	varchar(255)	NO	YES	NO
othertelephonenumber	varchar(255)	NO	YES	NO
imaddress	varchar(100)	NO	YES	NO
companyname	varchar(255)	NO	YES	NO
department	varchar(255)	NO	YES	NO
officelocation	varchar(255)	NO	YES	NO
businessaddress	varchar(255)	NO	YES	NO
businesstelephonenumber	varchar(255)	NO	YES	NO
business2telephonenumber	varchar(255)	NO	YES	NO
businessfaxnumber	varchar(255)	NO	YES	NO
businesshomepage	varchar(255)	NO	YES	NO
homeaddress	varchar(255)	NO	YES	NO
hometelephonenumber	varchar(255)	NO	YES	NO
home2telephonenumber	varchar(255)	NO	YES	NO
homefaxnumber	varchar(255)	NO	YES	NO
birthdaydateline	int(10)	NO	YES	NO	UNSIGNED	0
anniversarydateline	int(10)	NO	YES	NO	UNSIGNED	0
mailingaddress	varchar(255)	NO	YES	NO
otheraddress	varchar(255)	NO	YES	NO
webpage	varchar(255)	NO	YES	NO
assistantname	varchar(255)	NO	YES	NO
assistanttelephonenumber	varchar(255)	NO	YES	NO
lastupdate	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	contactid
contacts1	contacttype,staffid
FKIndex1	calendarcategoryid
FKIndex2	staffid

Table Create SQL

CREATE TABLE `swcontacts` (
  `contactid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `contacttype` enum('public','private') NOT NULL DEFAULT 'public',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fullname` varchar(255) NOT NULL,
  `jobtitle` varchar(255) NOT NULL,
  `initials` varchar(5) NOT NULL,
  `calendarcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `email1address` varchar(255) NOT NULL,
  `email2address` varchar(255) NOT NULL,
  `email3address` varchar(255) NOT NULL,
  `customerid` varchar(100) NOT NULL,
  `mobiletelephonenumber` varchar(255) NOT NULL,
  `cartelephonenumber` varchar(255) NOT NULL,
  `pagernumber` varchar(255) NOT NULL,
  `othertelephonenumber` varchar(255) NOT NULL,
  `imaddress` varchar(100) NOT NULL,
  `companyname` varchar(255) NOT NULL,
  `department` varchar(255) NOT NULL,
  `officelocation` varchar(255) NOT NULL,
  `businessaddress` varchar(255) NOT NULL,
  `businesstelephonenumber` varchar(255) NOT NULL,
  `business2telephonenumber` varchar(255) NOT NULL,
  `businessfaxnumber` varchar(255) NOT NULL,
  `businesshomepage` varchar(255) NOT NULL,
  `homeaddress` varchar(255) NOT NULL,
  `hometelephonenumber` varchar(255) NOT NULL,
  `home2telephonenumber` varchar(255) NOT NULL,
  `homefaxnumber` varchar(255) NOT NULL,
  `birthdaydateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `anniversarydateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `mailingaddress` varchar(255) NOT NULL,
  `otheraddress` varchar(255) NOT NULL,
  `webpage` varchar(255) NOT NULL,
  `assistantname` varchar(255) NOT NULL,
  `assistanttelephonenumber` varchar(255) NOT NULL,
  `lastupdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`contactid`),
  INDEX `contacts1`(`contacttype`, `staffid`),
  INDEX `FKIndex1`(`calendarcategoryid`),
  INDEX `FKIndex2`(`staffid`),
  CONSTRAINT `Reference_07` FOREIGN KEY (`calendarcategoryid`)
    REFERENCES `swcalendarcategories`(`calendarcategoryid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_81` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ip_from	double(15,3)	NO	YES	NO		0
ip_to	double(15,3)	NO	YES	NO		0
country_code2	char(2)	NO	YES	NO
country_code3	char(3)	NO	YES	NO
country_name	varchar(50)	NO	YES	NO

IndexName	Columns
ips	ip_from,ip_to

Table Create SQL

CREATE TABLE `swcountryinfo` (
  `ip_from` double(15,3) NOT NULL DEFAULT '0',
  `ip_to` double(15,3) NOT NULL DEFAULT '0',
  `country_code2` char(2) NOT NULL,
  `country_code3` char(3) NOT NULL,
  `country_name` varchar(50) NOT NULL,
  INDEX `ips`(`ip_from`, `ip_to`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
cronid	int(10)	YES	YES	YES	UNSIGNED
nextrun	int(10)	NO	YES	NO	UNSIGNED	0
lastrun	int(10)	NO	YES	NO	UNSIGNED	0
chour	int(11)	NO	YES	NO		0
cminute	int(11)	NO	YES	NO		0
cday	int(11)	NO	YES	NO		0
module	varchar(120)	NO	YES	NO
action	varchar(120)	NO	YES	NO
autorun	smallint(1)	NO	YES	NO	UNSIGNED	0
name	varchar(150)	NO	YES	NO

IndexName	Columns
PRIMARY	cronid

Table Create SQL

CREATE TABLE `swcron` (
  `cronid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nextrun` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastrun` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `chour` int(11) NOT NULL DEFAULT '0',
  `cminute` int(11) NOT NULL DEFAULT '0',
  `cday` int(11) NOT NULL DEFAULT '0',
  `module` varchar(120) NOT NULL,
  `action` varchar(120) NOT NULL,
  `autorun` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL,
  PRIMARY KEY(`cronid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
cronlogid	int(10)	YES	YES	YES	UNSIGNED
cronid	int(10)	NO	YES	NO	UNSIGNED	0
crontitle	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
description	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	cronlogid
FKIndex1	cronid

Table Create SQL

CREATE TABLE `swcronlogs` (
  `cronlogid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `cronid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `crontitle` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `description` varchar(255) NOT NULL,
  PRIMARY KEY(`cronlogid`),
  INDEX `FKIndex1`(`cronid`),
  CONSTRAINT `Reference_21` FOREIGN KEY (`cronid`)
    REFERENCES `swcron`(`cronid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
customfieldgroupid	int(10)	YES	YES	NO	UNSIGNED	0
departmentid	int(10)	YES	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	customfieldgroupid,departmentid
customfieldgroupid	customfieldgroupid,departmentid

Table Create SQL

CREATE TABLE `swcustomfielddeplinks` (
  `customfieldgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`customfieldgroupid`, `departmentid`),
  UNIQUE INDEX `customfieldgroupid`(`customfieldgroupid`, `departmentid`)
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
customfieldgroupid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(200)	NO	YES	NO
grouptype	smallint(2)	NO	YES	NO	UNSIGNED	0
displayorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	customfieldgroupid
customfieldgroups1	grouptype

Table Create SQL

CREATE TABLE `swcustomfieldgroups` (
  `customfieldgroupid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `grouptype` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`customfieldgroupid`),
  INDEX `customfieldgroups1`(`grouptype`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
customfieldlinkid	int(10)	YES	YES	YES	UNSIGNED
linktype	smallint(1)	NO	YES	NO	UNSIGNED	0
typeid	int(10)	NO	YES	NO	UNSIGNED	0
customfieldgroupid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	customfieldlinkid
linktype	linktype,typeid,customfieldgroupid
FKIndex1	customfieldgroupid

Table Create SQL

CREATE TABLE `swcustomfieldlinks` (
  `customfieldlinkid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `linktype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `customfieldgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`customfieldlinkid`),
  UNIQUE INDEX `linktype`(`linktype`, `typeid`, `customfieldgroupid`),
  INDEX `FKIndex1`(`customfieldgroupid`),
  CONSTRAINT `Reference_22` FOREIGN KEY (`customfieldgroupid`)
    REFERENCES `swcustomfieldgroups`(`customfieldgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
customfieldoptionid	int(10)	YES	YES	YES	UNSIGNED
customfieldid	int(10)	NO	YES	NO	UNSIGNED	0
optionvalue	varchar(255)	NO	YES	NO
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
isselected	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	customfieldoptionid
customfieldoptions1	customfieldid

Table Create SQL

CREATE TABLE `swcustomfieldoptions` (
  `customfieldoptionid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `customfieldid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `optionvalue` varchar(255) NOT NULL,
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `isselected` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`customfieldoptionid`),
  INDEX `customfieldoptions1`(`customfieldid`),
  CONSTRAINT `Reference_24` FOREIGN KEY (`customfieldid`)
    REFERENCES `swcustomfields`(`customfieldid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
customfieldid	int(10)	YES	YES	YES	UNSIGNED
customfieldgroupid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
fieldtype	smallint(2)	NO	YES	NO	UNSIGNED	0
fieldname	varchar(100)	NO	YES	NO
defaultvalue	varchar(255)	NO	YES	NO
isrequired	smallint(1)	NO	YES	NO	UNSIGNED	0
usereditable	smallint(1)	NO	YES	NO	UNSIGNED	0
staffeditable	smallint(1)	NO	YES	NO	UNSIGNED	0
regexpvalidate	varchar(255)	NO	YES	NO
displayorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	customfieldid
customfields1	customfieldgroupid

Table Create SQL

CREATE TABLE `swcustomfields` (
  `customfieldid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `customfieldgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `fieldtype` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
  `fieldname` varchar(100) NOT NULL,
  `defaultvalue` varchar(255) NOT NULL,
  `isrequired` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `usereditable` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffeditable` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `regexpvalidate` varchar(255) NOT NULL,
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`customfieldid`),
  INDEX `customfields1`(`customfieldgroupid`),
  CONSTRAINT `Reference_23` FOREIGN KEY (`customfieldgroupid`)
    REFERENCES `swcustomfieldgroups`(`customfieldgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
customfieldvalueid	int(10)	YES	YES	YES	UNSIGNED
customfieldid	int(10)	NO	YES	NO	UNSIGNED	0
typeid	int(10)	NO	YES	NO	UNSIGNED	0
fieldvalue	varchar(255)	NO	YES	NO
isserialized	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	customfieldvalueid
customfieldvalues1	customfieldid,typeid
FKIndex1	customfieldid

Table Create SQL

CREATE TABLE `swcustomfieldvalues` (
  `customfieldvalueid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `customfieldid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fieldvalue` varchar(255) NOT NULL,
  `isserialized` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`customfieldvalueid`),
  INDEX `customfieldvalues1`(`customfieldid`, `typeid`),
  INDEX `FKIndex1`(`customfieldid`),
  CONSTRAINT `Reference_25` FOREIGN KEY (`customfieldid`)
    REFERENCES `swcustomfields`(`customfieldid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
departmentid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(100)	NO	YES	NO
departmenttype	enum('public','private')	NO	YES	NO		public
departmentmodule	enum('tickets','bugs','livesupport','knowledgebase')	NO	YES	NO		tickets
isdefault	int(1)	NO	YES	NO	UNSIGNED	0
displayorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	departmentid
departments1	departmentmodule

Table Create SQL

CREATE TABLE `swdepartments` (
  `departmentid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `departmenttype` enum('public','private') NOT NULL DEFAULT 'public',
  `departmentmodule` enum('tickets','bugs','livesupport','knowledgebase') NOT NULL DEFAULT 'tickets',
  `isdefault` int(1) UNSIGNED NOT NULL DEFAULT '0',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`departmentid`),
  INDEX `departments1`(`departmentmodule`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
downloadcategoryid	int(10)	YES	YES	YES	UNSIGNED
parentcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
totalitems	int(10)	NO	YES	NO	UNSIGNED	0
categorytype	varchar(20)	NO	YES	NO		public
displayorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	downloadcategoryid
downloadcategories1	parentcategoryid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swdownloadcategories` (
  `downloadcategoryid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parentcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `totalitems` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `categorytype` varchar(20) NOT NULL DEFAULT 'public',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`downloadcategoryid`),
  INDEX `downloadcategories1`(`parentcategoryid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_82` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
downloaddescid	int(10)	YES	YES	YES	UNSIGNED
downloaditemid	int(10)	NO	YES	NO	UNSIGNED	0
description	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	downloaddescid
downloaddesc1	downloaditemid

Table Create SQL

CREATE TABLE `swdownloaddesc` (
  `downloaddescid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `downloaditemid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `description` mediumtext NOT NULL,
  PRIMARY KEY(`downloaddescid`),
  INDEX `downloaddesc1`(`downloaditemid`),
  CONSTRAINT `Reference_41` FOREIGN KEY (`downloaditemid`)
    REFERENCES `swdownloaditems`(`downloaditemid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
downloaditemid	int(10)	YES	YES	YES	UNSIGNED
downloadcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
downloadmaskid	varchar(100)	NO	YES	NO
title	varchar(255)	NO	YES	NO
version	varchar(50)	NO	YES	NO
filelink	varchar(255)	NO	YES	NO
filename	varchar(255)	NO	YES	NO
storedfilename	varchar(255)	NO	YES	NO
filesize	int(10)	NO	YES	NO	UNSIGNED	0
filetype	varchar(150)	NO	YES	NO
totaldownloads	int(10)	NO	YES	NO	UNSIGNED	0
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
updatedateline	int(10)	NO	YES	NO	UNSIGNED	0
itempassword	varchar(50)	NO	YES	NO
totalcomments	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	downloaditemid
downloaditems2	downloadmaskid
downloaditems1	downloadcategoryid

Table Create SQL

CREATE TABLE `swdownloaditems` (
  `downloaditemid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `downloadcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `downloadmaskid` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `version` varchar(50) NOT NULL,
  `filelink` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `storedfilename` varchar(255) NOT NULL,
  `filesize` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `filetype` varchar(150) NOT NULL,
  `totaldownloads` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `updatedateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `itempassword` varchar(50) NOT NULL,
  `totalcomments` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`downloaditemid`),
  INDEX `downloaditems2`(`downloadmaskid`),
  INDEX `downloaditems1`(`downloadcategoryid`),
  CONSTRAINT `Reference_39` FOREIGN KEY (`downloadcategoryid`)
    REFERENCES `swdownloadcategories`(`downloadcategoryid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
emailqueueid	int(10)	YES	YES	YES	UNSIGNED
email	varchar(255)	NO	YES	NO
type	enum('tickets','bugs')	NO	YES	NO		tickets
fetchtype	enum('pipe','pop3','pop3ssl','imap','imapssl')	NO	YES	NO		pipe
host	varchar(255)	NO	YES	NO
port	varchar(10)	NO	YES	NO
username	varchar(255)	NO	YES	NO
userpassword	varchar(255)	NO	YES	NO
customfromname	varchar(200)	NO	YES	NO
customfromemail	varchar(255)	NO	YES	NO
priorityid	int(10)	NO	YES	NO	UNSIGNED	0
ticketstatusid	int(10)	NO	YES	NO	UNSIGNED	0
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
prefix	varchar(30)	NO	YES	NO
ticketautoresponder	smallint(1)	NO	YES	NO	UNSIGNED	0
replyautoresponder	smallint(1)	NO	YES	NO	UNSIGNED	0
registrationrequired	smallint(1)	NO	YES	NO	UNSIGNED	0
tgroupid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	emailqueueid
FKIndex1	departmentid
FKIndex2	tgroupid
FKIndex3	priorityid
FKIndex4	ticketstatusid

Table Create SQL

CREATE TABLE `swemailqueues` (
  `emailqueueid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `type` enum('tickets','bugs') NOT NULL DEFAULT 'tickets',
  `fetchtype` enum('pipe','pop3','pop3ssl','imap','imapssl') NOT NULL DEFAULT 'pipe',
  `host` varchar(255) NOT NULL,
  `port` varchar(10) NOT NULL,
  `username` varchar(255) NOT NULL,
  `userpassword` varchar(255) NOT NULL,
  `customfromname` varchar(200) NOT NULL,
  `customfromemail` varchar(255) NOT NULL,
  `priorityid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `prefix` varchar(30) NOT NULL,
  `ticketautoresponder` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `replyautoresponder` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `registrationrequired` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `tgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`emailqueueid`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `FKIndex2`(`tgroupid`),
  INDEX `FKIndex3`(`priorityid`),
  INDEX `FKIndex4`(`ticketstatusid`),
  CONSTRAINT `Reference_30` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_110` FOREIGN KEY (`tgroupid`)
    REFERENCES `swtemplategroups`(`tgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_123` FOREIGN KEY (`priorityid`)
    REFERENCES `swticketpriorities`(`priorityid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_137` FOREIGN KEY (`ticketstatusid`)
    REFERENCES `swticketstatus`(`ticketstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
escalationruleid	int(10)	YES	YES	YES	UNSIGNED
slaplanid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
priorityid	int(10)	NO	YES	NO	UNSIGNED	0
ticketstatusid	int(10)	NO	YES	NO	UNSIGNED	0
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	escalationruleid
FKIndex1	departmentid
escalationrules1	slaplanid
FKIndex3	staffid
FKIndex4	priorityid
FKIndex5	ticketstatusid

Table Create SQL

CREATE TABLE `swescalationrules` (
  `escalationruleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slaplanid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `priorityid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`escalationruleid`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `escalationrules1`(`slaplanid`),
  INDEX `FKIndex3`(`staffid`),
  INDEX `FKIndex4`(`priorityid`),
  INDEX `FKIndex5`(`ticketstatusid`),
  CONSTRAINT `Reference_31` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_66` FOREIGN KEY (`slaplanid`)
    REFERENCES `swslaplans`(`slaplanid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_83` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_124` FOREIGN KEY (`priorityid`)
    REFERENCES `swticketpriorities`(`priorityid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_138` FOREIGN KEY (`ticketstatusid`)
    REFERENCES `swticketstatus`(`ticketstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
groupassignid	int(10)	YES	YES	YES	UNSIGNED
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
staffgroupid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	groupassignid
departmentid	departmentid,staffgroupid
groupassigns2	departmentid
groupassigns1	staffgroupid

Table Create SQL

CREATE TABLE `swgroupassigns` (
  `groupassignid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`groupassignid`),
  UNIQUE INDEX `departmentid`(`departmentid`, `staffgroupid`),
  INDEX `groupassigns2`(`departmentid`),
  INDEX `groupassigns1`(`staffgroupid`),
  CONSTRAINT `Reference_32` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_106` FOREIGN KEY (`staffgroupid`)
    REFERENCES `swstaffgroup`(`staffgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
kbarticledataid	int(10)	YES	YES	YES	UNSIGNED
kbarticleid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	kbarticledataid
kbarticledata1	kbarticleid

Table Create SQL

CREATE TABLE `swkbarticledata` (
  `kbarticledataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `kbarticleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`kbarticledataid`),
  INDEX `kbarticledata1`(`kbarticleid`),
  CONSTRAINT `Reference_47` FOREIGN KEY (`kbarticleid`)
    REFERENCES `swkbarticles`(`kbarticleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
kbarticlefileid	int(10)	YES	YES	YES	UNSIGNED
kbarticleid	int(10)	NO	YES	NO	UNSIGNED	0
filename	varchar(255)	NO	YES	NO
storedfilename	varchar(255)	NO	YES	NO
filesize	int(10)	NO	YES	NO	UNSIGNED	0
filetype	varchar(150)	NO	YES	NO
totaldownloads	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	kbarticlefileid
kbarticlefiles1	kbarticleid

Table Create SQL

CREATE TABLE `swkbarticlefiles` (
  `kbarticlefileid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `kbarticleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `filename` varchar(255) NOT NULL,
  `storedfilename` varchar(255) NOT NULL,
  `filesize` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `filetype` varchar(150) NOT NULL,
  `totaldownloads` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`kbarticlefileid`),
  INDEX `kbarticlefiles1`(`kbarticleid`),
  CONSTRAINT `Reference_48` FOREIGN KEY (`kbarticleid`)
    REFERENCES `swkbarticles`(`kbarticleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
kbarticlelinkid	int(10)	YES	YES	YES	UNSIGNED
kbcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
kbarticleid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	kbarticlelinkid
kbcategoryid	kbcategoryid,kbarticleid
kbarticlelinks1	kbarticleid
FKIndex2	kbcategoryid

Table Create SQL

CREATE TABLE `swkbarticlelinks` (
  `kbarticlelinkid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `kbcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `kbarticleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`kbarticlelinkid`),
  UNIQUE INDEX `kbcategoryid`(`kbcategoryid`, `kbarticleid`),
  INDEX `kbarticlelinks1`(`kbarticleid`),
  INDEX `FKIndex2`(`kbcategoryid`),
  CONSTRAINT `Reference_49` FOREIGN KEY (`kbarticleid`)
    REFERENCES `swkbarticles`(`kbarticleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_50` FOREIGN KEY (`kbcategoryid`)
    REFERENCES `swkbcategories`(`kbcategoryid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
kbarticleid	int(10)	YES	YES	YES	UNSIGNED
staffid	int(10)	NO	YES	NO	UNSIGNED	0
subject	varchar(255)	NO	YES	NO
isedited	smallint(1)	NO	YES	NO	UNSIGNED	0
editeddateline	int(10)	NO	YES	NO	UNSIGNED	0
editedstaffid	int(10)	NO	YES	NO	UNSIGNED	0
views	int(10)	NO	YES	NO	UNSIGNED	0
totalcomments	int(10)	NO	YES	NO	UNSIGNED	0
hasattachments	smallint(1)	NO	YES	NO	UNSIGNED	1
dateline	int(10)	NO	YES	NO	UNSIGNED	0
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
articlestatus	enum('published','draft','private')	NO	YES	NO		published
articlerating	float(9,3)	NO	YES	NO	UNSIGNED	0
ratinghits	int(10)	NO	YES	NO	UNSIGNED	0
ratingcount	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	kbarticleid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swkbarticles` (
  `kbarticleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL,
  `isedited` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `editeddateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `editedstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `totalcomments` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `hasattachments` smallint(1) UNSIGNED NOT NULL DEFAULT '1',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `articlestatus` enum('published','draft','private') NOT NULL DEFAULT 'published',
  `articlerating` float(9,3) UNSIGNED NOT NULL DEFAULT '0',
  `ratinghits` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ratingcount` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`kbarticleid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_84` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
kbcategoryid	int(10)	YES	YES	YES	UNSIGNED
parentcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
totalarticles	int(10)	NO	YES	NO	UNSIGNED	0
categorytype	enum('public','private')	NO	YES	NO		public
displayorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	kbcategoryid
kbcategories1	parentcategoryid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swkbcategories` (
  `kbcategoryid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parentcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `totalarticles` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `categorytype` enum('public','private') NOT NULL DEFAULT 'public',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`kbcategoryid`),
  INDEX `kbcategories1`(`parentcategoryid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_85` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
phraseid	int(10)	YES	YES	YES	UNSIGNED
languageid	int(10)	NO	YES	NO	UNSIGNED	0
section	varchar(100)	NO	YES	NO
code	varchar(100)	NO	YES	NO
sectioncode	varchar(255)	NO	YES	NO
contents	text	NO	YES	NO

IndexName	Columns
PRIMARY	phraseid
languageid	languageid,code
FKIndex1	languageid

Table Create SQL

CREATE TABLE `swlanguagephrases` (
  `phraseid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `languageid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `section` varchar(100) NOT NULL,
  `code` varchar(100) NOT NULL,
  `sectioncode` varchar(255) NOT NULL,
  `contents` text NOT NULL,
  PRIMARY KEY(`phraseid`),
  UNIQUE INDEX `languageid`(`languageid`, `code`),
  INDEX `FKIndex1`(`languageid`),
  CONSTRAINT `Reference_51` FOREIGN KEY (`languageid`)
    REFERENCES `swlanguages`(`languageid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
languageid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(100)	NO	YES	NO
languagecode	varchar(20)	NO	YES	NO
charset	varchar(200)	NO	YES	NO
author	varchar(120)	NO	YES	NO
textdirection	enum('ltr','rtl')	NO	YES	NO		ltr
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0
isdefault	smallint(1)	NO	YES	NO	UNSIGNED	0
displayorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	languageid
languages1	languagecode

Table Create SQL

CREATE TABLE `swlanguages` (
  `languageid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `languagecode` varchar(20) NOT NULL,
  `charset` varchar(200) NOT NULL,
  `author` varchar(120) NOT NULL,
  `textdirection` enum('ltr','rtl') NOT NULL DEFAULT 'ltr',
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `isdefault` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`languageid`),
  INDEX `languages1`(`languagecode`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
mailqueuedataid	int(10)	YES	YES	YES	UNSIGNED
toemail	varchar(255)	NO	YES	NO
fromemail	varchar(255)	NO	YES	NO
fromname	varchar(255)	NO	YES	NO
subject	varchar(255)	NO	YES	NO
datatext	mediumtext	NO	YES	NO
datahtml	mediumtext	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
ishtml	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	mailqueuedataid

Table Create SQL

CREATE TABLE `swmailqueuedata` (
  `mailqueuedataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `toemail` varchar(255) NOT NULL,
  `fromemail` varchar(255) NOT NULL,
  `fromname` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `datatext` mediumtext NOT NULL,
  `datahtml` mediumtext NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ishtml` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`mailqueuedataid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
messagedataid	int(10)	YES	YES	YES	UNSIGNED
messageid	int(10)	NO	YES	NO	UNSIGNED	0
contenttype	smallint(1)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	messagedataid
messagedata1	messageid

Table Create SQL

CREATE TABLE `swmessagedata` (
  `messagedataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `messageid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contenttype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`messagedataid`),
  INDEX `messagedata1`(`messageid`),
  CONSTRAINT `Reference_54` FOREIGN KEY (`messageid`)
    REFERENCES `swmessages`(`messageid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
messagequeueid	int(10)	YES	YES	YES	UNSIGNED
chatobjectid	int(10)	NO	YES	NO	UNSIGNED	0
chatchildid	varchar(32)	NO	YES	NO
staffid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(150)	NO	YES	NO
contents	mediumtext	NO	YES	NO
msgtype	varchar(10)	NO	YES	NO

IndexName	Columns
PRIMARY	messagequeueid
messagequeue1	chatobjectid,chatchildid
messagequeue2	dateline
FKIndex1	chatchildid
FKIndex2	chatobjectid
FKIndex3	staffid

Table Create SQL

CREATE TABLE `swmessagequeue` (
  `messagequeueid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `chatobjectid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `chatchildid` varchar(32) NOT NULL,
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL,
  `contents` mediumtext NOT NULL,
  `msgtype` varchar(10) NOT NULL,
  PRIMARY KEY(`messagequeueid`),
  INDEX `messagequeue1`(`chatobjectid`, `chatchildid`),
  INDEX `messagequeue2`(`dateline`),
  INDEX `FKIndex1`(`chatchildid`),
  INDEX `FKIndex2`(`chatobjectid`),
  INDEX `FKIndex3`(`staffid`),
  CONSTRAINT `Reference_15` FOREIGN KEY (`chatchildid`)
    REFERENCES `swchatchilds`(`chatchildid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_18` FOREIGN KEY (`chatobjectid`)
    REFERENCES `swchatobjects`(`chatobjectid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_86` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
messageid	int(10)	YES	YES	YES	UNSIGNED
dateline	int(10)	NO	YES	NO	UNSIGNED	0
replydateline	int(10)	NO	YES	NO	UNSIGNED	0
fullname	varchar(150)	NO	YES	NO
email	varchar(150)	NO	YES	NO
subject	varchar(255)	NO	YES	NO
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
messagestatus	smallint(1)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	messageid
messages1	departmentid,messagestatus
FKIndex1	departmentid
messages2	staffid

Table Create SQL

CREATE TABLE `swmessages` (
  `messageid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `replydateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fullname` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `messagestatus` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`messageid`),
  INDEX `messages1`(`departmentid`, `messagestatus`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `messages2`(`staffid`),
  CONSTRAINT `Reference_33` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_87` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
newsid	int(10)	YES	YES	YES	UNSIGNED
tgroupid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
newstype	enum('public','private')	NO	YES	NO		public
subject	varchar(255)	NO	YES	NO
emailsubject	varchar(255)	NO	YES	NO
description	text	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
expiry	int(10)	NO	YES	NO	UNSIGNED	0
edited	smallint(1)	NO	YES	NO	UNSIGNED	0
editedstaffid	int(10)	NO	YES	NO	UNSIGNED	0
editeddateline	int(10)	NO	YES	NO	UNSIGNED	0
totalcomments	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	newsid
news1	tgroupid,newstype,expiry,dateline
FKIndex1	staffid
FKIndex2	tgroupid

Table Create SQL

CREATE TABLE `swnews` (
  `newsid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `newstype` enum('public','private') NOT NULL DEFAULT 'public',
  `subject` varchar(255) NOT NULL,
  `emailsubject` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `expiry` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `edited` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `editedstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `editeddateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `totalcomments` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`newsid`),
  INDEX `news1`(`tgroupid`, `newstype`, `expiry`, `dateline`),
  INDEX `FKIndex1`(`staffid`),
  INDEX `FKIndex2`(`tgroupid`),
  CONSTRAINT `Reference_88` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_111` FOREIGN KEY (`tgroupid`)
    REFERENCES `swtemplategroups`(`tgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
newsdataid	int(10)	YES	YES	YES	UNSIGNED
newsid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	newsdataid
newsdata1	newsid

Table Create SQL

CREATE TABLE `swnewsdata` (
  `newsdataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `newsid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`newsdataid`),
  INDEX `newsdata1`(`newsid`),
  CONSTRAINT `Reference_55` FOREIGN KEY (`newsid`)
    REFERENCES `swnews`(`newsid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
newssubscriberid	int(10)	YES	YES	YES	UNSIGNED
tgroupid	int(10)	NO	YES	NO	UNSIGNED	0
userid	int(10)	NO	YES	NO	UNSIGNED	0
email	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
validated	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	newssubscriberid
email	email
newssubscribers1	tgroupid,validated
FKIndex1	tgroupid
FKIndex2	userid

Table Create SQL

CREATE TABLE `swnewssubscribers` (
  `newssubscriberid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `validated` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`newssubscriberid`),
  UNIQUE INDEX `email`(`email`),
  INDEX `newssubscribers1`(`tgroupid`, `validated`),
  INDEX `FKIndex1`(`tgroupid`),
  INDEX `FKIndex2`(`userid`),
  CONSTRAINT `Reference_112` FOREIGN KEY (`tgroupid`)
    REFERENCES `swtemplategroups`(`tgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_151` FOREIGN KEY (`userid`)
    REFERENCES `swusers`(`userid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
newsverihashid	varchar(32)	YES	YES	NO
newssubscriberid	int(10)	NO	YES	NO	UNSIGNED	0
hash	varchar(50)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	newsverihashid
newsverihash2	hash
newsverihash1	newssubscriberid

Table Create SQL

CREATE TABLE `swnewsverihash` (
  `newsverihashid` varchar(32) NOT NULL,
  `newssubscriberid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `hash` varchar(50) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`newsverihashid`),
  INDEX `newsverihash2`(`hash`),
  INDEX `newsverihash1`(`newssubscriberid`),
  CONSTRAINT `Reference_56` FOREIGN KEY (`newssubscriberid`)
    REFERENCES `swnewssubscribers`(`newssubscriberid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
parserbanid	int(10)	YES	YES	YES	UNSIGNED
email	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	parserbanid
email	email
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swparserbans` (
  `parserbanid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`parserbanid`),
  UNIQUE INDEX `email`(`email`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_89` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
parserlogdataid	int(10)	YES	YES	YES	UNSIGNED
parserlogid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	parserlogdataid
FKIndex1	parserlogid

Table Create SQL

CREATE TABLE `swparserlogdata` (
  `parserlogdataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parserlogid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`parserlogdataid`),
  INDEX `FKIndex1`(`parserlogid`),
  CONSTRAINT `Reference_57` FOREIGN KEY (`parserlogid`)
    REFERENCES `swparserlogs`(`parserlogid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
parserlogid	int(10)	YES	YES	YES	UNSIGNED
typeid	int(10)	NO	YES	NO	UNSIGNED	0
ticketmaskid	varchar(20)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
emailqueueid	int(10)	NO	YES	NO	UNSIGNED	0
logtype	enum('failure','success')	NO	YES	NO		failure
subject	varchar(255)	NO	YES	NO
fromemail	varchar(255)	NO	YES	NO
toemail	varchar(255)	NO	YES	NO
size	int(10)	NO	YES	NO	UNSIGNED	0
description	varchar(255)	NO	YES	NO
parsetimetaken	float(9,3)	NO	YES	NO	UNSIGNED	0
responsetype	enum('ticket','reply','bug')	NO	YES	NO		ticket
ticketpostid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	parserlogid
FKIndex1	emailqueueid
parserlogs2	ticketpostid

Table Create SQL

CREATE TABLE `swparserlogs` (
  `parserlogid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketmaskid` varchar(20) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `emailqueueid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `logtype` enum('failure','success') NOT NULL DEFAULT 'failure',
  `subject` varchar(255) NOT NULL,
  `fromemail` varchar(255) NOT NULL,
  `toemail` varchar(255) NOT NULL,
  `size` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `description` varchar(255) NOT NULL,
  `parsetimetaken` float(9,3) UNSIGNED NOT NULL DEFAULT '0',
  `responsetype` enum('ticket','reply','bug') NOT NULL DEFAULT 'ticket',
  `ticketpostid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`parserlogid`),
  INDEX `FKIndex1`(`emailqueueid`),
  INDEX `parserlogs2`(`ticketpostid`),
  CONSTRAINT `Reference_43` FOREIGN KEY (`emailqueueid`)
    REFERENCES `swemailqueues`(`emailqueueid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_120` FOREIGN KEY (`ticketpostid`)
    REFERENCES `swticketposts`(`ticketpostid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
parserruleid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
sortorder	int(10)	NO	YES	NO	UNSIGNED	0
ruletype	smallint(1)	NO	YES	NO	UNSIGNED	0
matchtype	smallint(1)	NO	YES	NO	UNSIGNED	0
stopprocessing	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	parserruleid

Table Create SQL

CREATE TABLE `swparserrules` (
  `parserruleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sortorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ruletype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `matchtype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `stopprocessing` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`parserruleid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
predefinedcategoryid	int(10)	YES	YES	YES	UNSIGNED
parentcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
categorytype	smallint(1)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	predefinedcategoryid
predefinedcategory1	parentcategoryid
predefinedcategory2	categorytype,staffid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swpredefinedcategories` (
  `predefinedcategoryid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parentcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `categorytype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  PRIMARY KEY(`predefinedcategoryid`),
  INDEX `predefinedcategory1`(`parentcategoryid`),
  INDEX `predefinedcategory2`(`categorytype`, `staffid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_90` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
predefinedreplyid	int(10)	YES	YES	YES	UNSIGNED
predefinedcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
subject	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	predefinedreplyid
predefinedreply1	predefinedcategoryid
predefinedreply2	staffid

Table Create SQL

CREATE TABLE `swpredefinedreplies` (
  `predefinedreplyid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `predefinedcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`predefinedreplyid`),
  INDEX `predefinedreply1`(`predefinedcategoryid`),
  INDEX `predefinedreply2`(`staffid`),
  CONSTRAINT `Reference_60` FOREIGN KEY (`predefinedcategoryid`)
    REFERENCES `swpredefinedcategories`(`predefinedcategoryid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_91` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
predefinedreplydataid	int(10)	YES	YES	YES	UNSIGNED
predefinedreplyid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	predefinedreplydataid
predefinedreplydata1	predefinedreplyid

Table Create SQL

CREATE TABLE `swpredefinedreplydata` (
  `predefinedreplydataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `predefinedreplyid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`predefinedreplydataid`),
  INDEX `predefinedreplydata1`(`predefinedreplyid`),
  CONSTRAINT `Reference_61` FOREIGN KEY (`predefinedreplyid`)
    REFERENCES `swpredefinedreplies`(`predefinedreplyid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
privatemessagedataid	int(10)	YES	YES	YES	UNSIGNED
privatemessageid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	privatemessagedataid
privatemessagedata1	privatemessageid

Table Create SQL

CREATE TABLE `swprivatemessagedata` (
  `privatemessagedataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `privatemessageid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`privatemessagedataid`),
  INDEX `privatemessagedata1`(`privatemessageid`),
  CONSTRAINT `Reference_62` FOREIGN KEY (`privatemessageid`)
    REFERENCES `swprivatemessages`(`privatemessageid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
privatemessageid	int(10)	YES	YES	YES	UNSIGNED
fromstaffid	int(10)	NO	YES	NO	UNSIGNED	0
tostaffid	int(10)	NO	YES	NO	UNSIGNED	0
subject	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
msgtype	smallint(1)	NO	YES	NO	UNSIGNED	0
msgstatus	smallint(1)	NO	YES	NO	UNSIGNED	0
readdate	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	privatemessageid
privatemessages1	tostaffid,msgtype,msgstatus
privatemessages2	fromstaffid,msgtype,msgstatus

Table Create SQL

CREATE TABLE `swprivatemessages` (
  `privatemessageid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `fromstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tostaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `msgtype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `msgstatus` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `readdate` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`privatemessageid`),
  INDEX `privatemessages1`(`tostaffid`, `msgtype`, `msgstatus`),
  INDEX `privatemessages2`(`fromstaffid`, `msgtype`, `msgstatus`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
queuesignatureid	int(10)	YES	YES	YES	UNSIGNED
dateline	int(10)	NO	YES	NO	UNSIGNED	0
emailqueueid	int(10)	NO	YES	NO	UNSIGNED	0
contents	text	NO	YES	NO

IndexName	Columns
PRIMARY	queuesignatureid
FKIndex1	emailqueueid

Table Create SQL

CREATE TABLE `swqueuesignatures` (
  `queuesignatureid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `emailqueueid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` text NOT NULL,
  PRIMARY KEY(`queuesignatureid`),
  INDEX `FKIndex1`(`emailqueueid`),
  CONSTRAINT `Reference_44` FOREIGN KEY (`emailqueueid`)
    REFERENCES `swemailqueues`(`emailqueueid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
vkey	varchar(50)	YES	YES	NO
data	mediumtext	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
isvolatile	smallint(5)	NO	YES	NO	UNSIGNED	0
datasize	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	vkey

Table Create SQL

CREATE TABLE `swregistry` (
  `vkey` varchar(50) NOT NULL,
  `data` mediumtext NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `isvolatile` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `datasize` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`vkey`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ruleactionid	int(10)	YES	YES	YES	UNSIGNED
parserruleid	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(100)	NO	YES	NO
typeid	int(10)	NO	YES	NO	UNSIGNED	0
typedata	mediumtext	NO	YES	NO
typechar	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	ruleactionid
ruleactions1	parserruleid

Table Create SQL

CREATE TABLE `swruleactions` (
  `ruleactionid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parserruleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `typedata` mediumtext NOT NULL,
  `typechar` varchar(255) NOT NULL,
  PRIMARY KEY(`ruleactionid`),
  INDEX `ruleactions1`(`parserruleid`),
  CONSTRAINT `Reference_58` FOREIGN KEY (`parserruleid`)
    REFERENCES `swparserrules`(`parserruleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
rulecriteriaid	int(10)	YES	YES	YES	UNSIGNED
parserruleid	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(100)	NO	YES	NO
ruleop	smallint(2)	NO	YES	NO	UNSIGNED	0
rulematch	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	rulecriteriaid
rulecriteria1	parserruleid

Table Create SQL

CREATE TABLE `swrulecriteria` (
  `rulecriteriaid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parserruleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `ruleop` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
  `rulematch` varchar(255) NOT NULL,
  PRIMARY KEY(`rulecriteriaid`),
  INDEX `rulecriteria1`(`parserruleid`),
  CONSTRAINT `Reference_59` FOREIGN KEY (`parserruleid`)
    REFERENCES `swparserrules`(`parserruleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	HEAP
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
sessionid	varchar(32)	YES	YES	NO
ipaddress	varchar(30)	NO	YES	NO
lastactivity	int(10)	NO	YES	NO	UNSIGNED	0
useragent	varchar(60)	NO	YES	NO		0
isloggedin	smallint(1)	NO	YES	NO	UNSIGNED	0
sessiontype	int(10)	NO	YES	NO	UNSIGNED	0
typeid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
status	smallint(6)	NO	YES	NO		0
captcha	varchar(10)	NO	YES	NO
iswinapp	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	sessionid
sessions1	sessiontype,lastactivity,status
typeid	typeid

Table Create SQL

CREATE TABLE `swsessions` (
  `sessionid` varchar(32) NOT NULL,
  `ipaddress` varchar(30) NOT NULL,
  `lastactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `useragent` varchar(60) NOT NULL DEFAULT '0',
  `isloggedin` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `sessiontype` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `status` smallint(6) NOT NULL DEFAULT '0',
  `captcha` varchar(10) NOT NULL,
  `iswinapp` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`sessionid`),
  INDEX `sessions1`(`sessiontype`, `lastactivity`, `status`),
  INDEX `typeid`(`typeid`)
)
TYPE=HEAP
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
settingid	int(10)	YES	YES	YES	UNSIGNED
section	varchar(50)	NO	YES	NO
vkey	varchar(50)	NO	YES	NO
data	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	settingid
sections	section,vkey
FKIndex1	vkey

Table Create SQL

CREATE TABLE `swsettings` (
  `settingid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `section` varchar(50) NOT NULL,
  `vkey` varchar(50) NOT NULL,
  `data` mediumtext NOT NULL,
  PRIMARY KEY(`settingid`),
  INDEX `sections`(`section`, `vkey`),
  INDEX `FKIndex1`(`vkey`),
  CONSTRAINT `Reference_63` FOREIGN KEY (`vkey`)
    REFERENCES `swregistry`(`vkey`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
sfieldid	int(10)	YES	YES	YES	UNSIGNED
sgroupid	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(200)	NO	YES	NO
customvalue	mediumtext	NO	YES	NO
iscustom	int(1)	NO	YES	NO	UNSIGNED	0
settingtype	varchar(100)	NO	YES	NO		text
module	varchar(100)	NO	YES	NO
displayorder	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	sfieldid
FKIndex1	sgroupid

Table Create SQL

CREATE TABLE `swsettingsfields` (
  `sfieldid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL,
  `customvalue` mediumtext NOT NULL,
  `iscustom` int(1) UNSIGNED NOT NULL DEFAULT '0',
  `settingtype` varchar(100) NOT NULL DEFAULT 'text',
  `module` varchar(100) NOT NULL,
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`sfieldid`),
  INDEX `FKIndex1`(`sgroupid`),
  CONSTRAINT `Reference_65` FOREIGN KEY (`sgroupid`)
    REFERENCES `swsettingsgroups`(`sgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
sgroupid	int(10)	YES	YES	YES	UNSIGNED
name	varchar(100)	NO	YES	NO
module	varchar(100)	NO	YES	NO
displayorder	int(5)	NO	YES	NO		0
ishidden	int(1)	NO	YES	NO		0

IndexName	Columns
PRIMARY	sgroupid

Table Create SQL

CREATE TABLE `swsettingsgroups` (
  `sgroupid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `module` varchar(100) NOT NULL,
  `displayorder` int(5) NOT NULL DEFAULT '0',
  `ishidden` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY(`sgroupid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
signatureid	int(10)	YES	YES	YES	UNSIGNED
dateline	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
signature	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	signatureid
signatures1	staffid

Table Create SQL

CREATE TABLE `swsignatures` (
  `signatureid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `signature` mediumtext NOT NULL,
  PRIMARY KEY(`signatureid`),
  INDEX `signatures1`(`staffid`),
  CONSTRAINT `Reference_92` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
planprioritylinkid	int(10)	YES	YES	YES	UNSIGNED
slaplanid	int(10)	NO	YES	NO	UNSIGNED	0
priorityid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	planprioritylinkid
slaplanid	slaplanid,priorityid
FKIndex1	slaplanid
FKIndex2	priorityid

Table Create SQL

CREATE TABLE `swslaplanprioritylink` (
  `planprioritylinkid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slaplanid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `priorityid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`planprioritylinkid`),
  UNIQUE INDEX `slaplanid`(`slaplanid`, `priorityid`),
  INDEX `FKIndex1`(`slaplanid`),
  INDEX `FKIndex2`(`priorityid`),
  CONSTRAINT `Reference_67` FOREIGN KEY (`slaplanid`)
    REFERENCES `swslaplans`(`slaplanid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_125` FOREIGN KEY (`priorityid`)
    REFERENCES `swticketpriorities`(`priorityid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
slaplanid	int(10)	YES	YES	YES	UNSIGNED
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
slascheduleid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
overduehrs	int(3)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	slaplanid
slaplans1	departmentid
slaplans2	slascheduleid

Table Create SQL

CREATE TABLE `swslaplans` (
  `slaplanid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `slascheduleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `overduehrs` int(3) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`slaplanid`),
  INDEX `slaplans1`(`departmentid`),
  INDEX `slaplans2`(`slascheduleid`),
  CONSTRAINT `Reference_34` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_72` FOREIGN KEY (`slascheduleid`)
    REFERENCES `swslaschedules`(`slascheduleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
planstatuslinkid	int(10)	YES	YES	YES	UNSIGNED
slaplanid	int(10)	NO	YES	NO	UNSIGNED	0
ticketstatusid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	planstatuslinkid
slaplanid	slaplanid,ticketstatusid
FKIndex1	slaplanid
FKIndex2	ticketstatusid

Table Create SQL

CREATE TABLE `swslaplanstatuslink` (
  `planstatuslinkid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slaplanid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`planstatuslinkid`),
  UNIQUE INDEX `slaplanid`(`slaplanid`, `ticketstatusid`),
  INDEX `FKIndex1`(`slaplanid`),
  INDEX `FKIndex2`(`ticketstatusid`),
  CONSTRAINT `Reference_68` FOREIGN KEY (`slaplanid`)
    REFERENCES `swslaplans`(`slaplanid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_139` FOREIGN KEY (`ticketstatusid`)
    REFERENCES `swticketstatus`(`ticketstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
slascheduleid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(255)	NO	YES	NO
sunday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
sunday_open	varchar(6)	NO	YES	NO		00:00
sunday_close	varchar(6)	NO	YES	NO		00:00
monday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
monday_open	varchar(6)	NO	YES	NO		00:00
monday_close	varchar(6)	NO	YES	NO		00:00
tuesday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
tuesday_open	varchar(6)	NO	YES	NO		00:00
tuesday_close	varchar(6)	NO	YES	NO		00:00
wednesday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
wednesday_open	varchar(6)	NO	YES	NO		00:00
wednesday_close	varchar(6)	NO	YES	NO		00:00
thursday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
thursday_open	varchar(6)	NO	YES	NO		00:00
thursday_close	varchar(6)	NO	YES	NO		00:00
friday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
friday_open	varchar(6)	NO	YES	NO		00:00
friday_close	varchar(6)	NO	YES	NO		00:00
saturday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
saturday_open	varchar(6)	NO	YES	NO		00:00
saturday_close	varchar(6)	NO	YES	NO		00:00
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	slascheduleid

Table Create SQL

CREATE TABLE `swslaschedules` (
  `slascheduleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `sunday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `sunday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `sunday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `monday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `monday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `monday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `tuesday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `tuesday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `tuesday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `wednesday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `wednesday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `wednesday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `thursday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `thursday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `thursday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `friday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `friday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `friday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `saturday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `saturday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `saturday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`slascheduleid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
staffid	int(10)	YES	YES	YES	UNSIGNED
fullname	varchar(100)	NO	YES	NO
username	varchar(30)	NO	YES	NO
password	varchar(32)	NO	YES	NO
staffgroupid	int(10)	NO	YES	NO	UNSIGNED	0
email	varchar(150)	NO	YES	NO
mobilenumber	varchar(20)	NO	YES	NO
lastvisit	int(10)	NO	YES	NO	UNSIGNED	0
lastvisit2	int(10)	NO	YES	NO	UNSIGNED	0
lastactivity	int(10)	NO	YES	NO	UNSIGNED	0
timezoneoffset	varchar(10)	NO	YES	NO		0
enabledst	smallint(1)	NO	YES	NO	UNSIGNED	0
startofweek	int(10)	NO	YES	NO	UNSIGNED	1
pmunread	int(10)	NO	YES	NO	UNSIGNED	0
groupassigns	smallint(1)	NO	YES	NO	UNSIGNED	1
enablepmalerts	smallint(1)	NO	YES	NO	UNSIGNED	1
enablepmjsalerts	smallint(1)	NO	YES	NO	UNSIGNED	1
ticketviewid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	staffid
staff1	staffgroupid
FKIndex2	ticketviewid

Table Create SQL

CREATE TABLE `swstaff` (
  `staffid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `fullname` varchar(100) NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(32) NOT NULL,
  `staffgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `email` varchar(150) NOT NULL,
  `mobilenumber` varchar(20) NOT NULL,
  `lastvisit` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastvisit2` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `timezoneoffset` varchar(10) NOT NULL DEFAULT '0',
  `enabledst` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `startofweek` int(10) UNSIGNED NOT NULL DEFAULT '1',
  `pmunread` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `groupassigns` smallint(1) UNSIGNED NOT NULL DEFAULT '1',
  `enablepmalerts` smallint(1) UNSIGNED NOT NULL DEFAULT '1',
  `enablepmjsalerts` smallint(1) UNSIGNED NOT NULL DEFAULT '1',
  `ticketviewid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`staffid`),
  INDEX `staff1`(`staffgroupid`),
  INDEX `FKIndex2`(`ticketviewid`),
  CONSTRAINT `Reference_107` FOREIGN KEY (`staffgroupid`)
    REFERENCES `swstaffgroup`(`staffgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_142` FOREIGN KEY (`ticketviewid`)
    REFERENCES `swticketviews`(`ticketviewid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
staffassignid	int(10)	YES	YES	YES	UNSIGNED
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	staffassignid
departmentid	departmentid,staffid
staffassigns2	departmentid
staffassigns1	staffid

Table Create SQL

CREATE TABLE `swstaffassigns` (
  `staffassignid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`staffassignid`),
  UNIQUE INDEX `departmentid`(`departmentid`, `staffid`),
  INDEX `staffassigns2`(`departmentid`),
  INDEX `staffassigns1`(`staffid`),
  CONSTRAINT `Reference_35` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_93` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
staffgroupid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(100)	NO	YES	NO
isadmin	smallint(1)	NO	YES	NO		0

IndexName	Columns
PRIMARY	staffgroupid
staffgroup1	isadmin

Table Create SQL

CREATE TABLE `swstaffgroup` (
  `staffgroupid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `isadmin` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY(`staffgroupid`),
  INDEX `staffgroup1`(`isadmin`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
sgroupsettingid	int(10)	YES	YES	YES	UNSIGNED
staffgroupid	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(100)	NO	YES	NO
value	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	sgroupsettingid
staffgroupid	staffgroupid,name
staffgroupsettings1	staffgroupid

Table Create SQL

CREATE TABLE `swstaffgroupsettings` (
  `sgroupsettingid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `staffgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY(`sgroupsettingid`),
  UNIQUE INDEX `staffgroupid`(`staffgroupid`, `name`),
  INDEX `staffgroupsettings1`(`staffgroupid`),
  CONSTRAINT `Reference_108` FOREIGN KEY (`staffgroupid`)
    REFERENCES `swstaffgroup`(`staffgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
staffscheduleid	int(10)	YES	YES	YES	UNSIGNED
staffid	int(10)	NO	YES	NO	UNSIGNED	0
sunday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
sunday_open	varchar(6)	NO	YES	NO		00:00
sunday_close	varchar(6)	NO	YES	NO		00:00
monday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
monday_open	varchar(6)	NO	YES	NO		00:00
monday_close	varchar(6)	NO	YES	NO		00:00
tuesday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
tuesday_open	varchar(6)	NO	YES	NO		00:00
tuesday_close	varchar(6)	NO	YES	NO		00:00
wednesday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
wednesday_open	varchar(6)	NO	YES	NO		00:00
wednesday_close	varchar(6)	NO	YES	NO		00:00
thursday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
thursday_open	varchar(6)	NO	YES	NO		00:00
thursday_close	varchar(6)	NO	YES	NO		00:00
friday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
friday_open	varchar(6)	NO	YES	NO		00:00
friday_close	varchar(6)	NO	YES	NO		00:00
saturday_enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
saturday_open	varchar(6)	NO	YES	NO		00:00
saturday_close	varchar(6)	NO	YES	NO		00:00

IndexName	Columns
PRIMARY	staffscheduleid
staffschedules1	staffid

Table Create SQL

CREATE TABLE `swstaffschedules` (
  `staffscheduleid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sunday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `sunday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `sunday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `monday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `monday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `monday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `tuesday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `tuesday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `tuesday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `wednesday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `wednesday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `wednesday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `thursday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `thursday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `thursday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `friday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `friday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `friday_close` varchar(6) NOT NULL DEFAULT '00:00',
  `saturday_enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `saturday_open` varchar(6) NOT NULL DEFAULT '00:00',
  `saturday_close` varchar(6) NOT NULL DEFAULT '00:00',
  PRIMARY KEY(`staffscheduleid`),
  INDEX `staffschedules1`(`staffid`),
  CONSTRAINT `Reference_94` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
synclogid	int(10)	YES	YES	YES	UNSIGNED
synctype	smallint(1)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
syncstatus	smallint(1)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
deviceinformation	varchar(255)	NO	YES	NO		0

IndexName	Columns
PRIMARY	synclogid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swsynclog` (
  `synclogid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `synctype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `syncstatus` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `deviceinformation` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY(`synclogid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_95` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
guidid	int(10)	YES	YES	YES	UNSIGNED
swguid	varchar(50)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	guidid
syncworksguid	swguid

Table Create SQL

CREATE TABLE `swsyncworksguid` (
  `guidid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `swguid` varchar(50) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`guidid`),
  INDEX `syncworksguid`(`swguid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tempfileid	int(10)	YES	YES	YES	UNSIGNED
filename	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	tempfileid

Table Create SQL

CREATE TABLE `swtempfiles` (
  `tempfileid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`tempfileid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tcategoryid	int(10)	YES	YES	YES	UNSIGNED
tgroupid	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(60)	NO	YES	NO
description	varchar(255)	NO	YES	NO
module	varchar(100)	NO	YES	NO

IndexName	Columns
PRIMARY	tcategoryid
templatecategories1	tgroupid

Table Create SQL

CREATE TABLE `swtemplatecategories` (
  `tcategoryid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(60) NOT NULL,
  `description` varchar(255) NOT NULL,
  `module` varchar(100) NOT NULL,
  PRIMARY KEY(`tcategoryid`),
  INDEX `templatecategories1`(`tgroupid`),
  CONSTRAINT `Reference_113` FOREIGN KEY (`tgroupid`)
    REFERENCES `swtemplategroups`(`tgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
templatedataid	int(10)	YES	YES	YES	UNSIGNED
templateid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO
contentsdefault	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	templatedataid
templatedata1	templateid

Table Create SQL

CREATE TABLE `swtemplatedata` (
  `templatedataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `templateid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  `contentsdefault` mediumtext NOT NULL,
  PRIMARY KEY(`templatedataid`),
  INDEX `templatedata1`(`templateid`),
  CONSTRAINT `Reference_117` FOREIGN KEY (`templateid`)
    REFERENCES `swtemplates`(`templateid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tgroupid	int(10)	YES	YES	YES	UNSIGNED
languageid	int(10)	NO	YES	NO	UNSIGNED	0
guestusergroupid	int(10)	NO	YES	NO	UNSIGNED	0
regusergroupid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(60)	NO	YES	NO
description	varchar(255)	NO	YES	NO
companyname	varchar(255)	NO	YES	NO
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0
grouppassword	varchar(32)	NO	YES	NO		0
restrictgroups	smallint(1)	NO	YES	NO	UNSIGNED	0
isdefault	smallint(1)	NO	YES	NO	UNSIGNED	0
loginapi_moduleid	int(10)	NO	YES	NO	UNSIGNED	0
ticketstatusid	int(10)	NO	YES	NO	UNSIGNED	0
priorityid	int(10)	NO	YES	NO	UNSIGNED	0
departmentid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	tgroupid
FKIndex1	departmentid
FKIndex2	languageid
FKIndex3	priorityid
FKIndex4	ticketstatusid

Table Create SQL

CREATE TABLE `swtemplategroups` (
  `tgroupid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `languageid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `guestusergroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `regusergroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL,
  `description` varchar(255) NOT NULL,
  `companyname` varchar(255) NOT NULL,
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `grouppassword` varchar(32) NOT NULL DEFAULT '0',
  `restrictgroups` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `isdefault` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `loginapi_moduleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `priorityid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`tgroupid`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `FKIndex2`(`languageid`),
  INDEX `FKIndex3`(`priorityid`),
  INDEX `FKIndex4`(`ticketstatusid`),
  CONSTRAINT `Reference_36` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_52` FOREIGN KEY (`languageid`)
    REFERENCES `swlanguages`(`languageid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_126` FOREIGN KEY (`priorityid`)
    REFERENCES `swticketpriorities`(`priorityid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_140` FOREIGN KEY (`ticketstatusid`)
    REFERENCES `swticketstatus`(`ticketstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
templateid	int(10)	YES	YES	YES	UNSIGNED
tgroupid	int(10)	NO	YES	NO	UNSIGNED	0
tcategoryid	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(60)	NO	YES	NO
templatelength	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
modified	enum('user','upgrade','notmodified')	NO	YES	NO		notmodified
contentshash	varchar(32)	NO	YES	NO
contentsdefaulthash	varchar(32)	NO	YES	NO

IndexName	Columns
PRIMARY	templateid
templates1	tgroupid,name
templates2	tcategoryid
FKIndex2	tgroupid

Table Create SQL

CREATE TABLE `swtemplates` (
  `templateid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tcategoryid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(60) NOT NULL,
  `templatelength` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modified` enum('user','upgrade','notmodified') NOT NULL DEFAULT 'notmodified',
  `contentshash` varchar(32) NOT NULL,
  `contentsdefaulthash` varchar(32) NOT NULL,
  PRIMARY KEY(`templateid`),
  INDEX `templates1`(`tgroupid`, `name`),
  INDEX `templates2`(`tcategoryid`),
  INDEX `FKIndex2`(`tgroupid`),
  CONSTRAINT `Reference_109` FOREIGN KEY (`tcategoryid`)
    REFERENCES `swtemplatecategories`(`tcategoryid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_114` FOREIGN KEY (`tgroupid`)
    REFERENCES `swtemplategroups`(`tgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
tgroupassignid	int(10)	YES	YES	YES	UNSIGNED
toassignid	int(10)	NO	YES	NO	UNSIGNED	0
type	smallint(5)	NO	YES	NO	UNSIGNED	0
tgroupid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	tgroupassignid
tgroupassigns1	tgroupid,type
tgroupassigns2	toassignid,type,tgroupid
FKIndex1	tgroupid

Table Create SQL

CREATE TABLE `swtgroupassigns` (
  `tgroupassignid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `toassignid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `tgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`tgroupassignid`),
  INDEX `tgroupassigns1`(`tgroupid`, `type`),
  INDEX `tgroupassigns2`(`toassignid`, `type`, `tgroupid`),
  INDEX `FKIndex1`(`tgroupid`),
  CONSTRAINT `Reference_115` FOREIGN KEY (`tgroupid`)
    REFERENCES `swtemplategroups`(`tgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketdraftid	int(10)	YES	YES	YES	UNSIGNED
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	ticketdraftid
ticketdrafts1	ticketid

Table Create SQL

CREATE TABLE `swticketdrafts` (
  `ticketdraftid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`ticketdraftid`),
  INDEX `ticketdrafts1`(`ticketid`),
  CONSTRAINT `Reference_130` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketemailid	int(10)	YES	YES	YES	UNSIGNED
email	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	ticketemailid
ticketemails1	email

Table Create SQL

CREATE TABLE `swticketemails` (
  `ticketemailid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY(`ticketemailid`),
  UNIQUE INDEX `ticketemails1`(`email`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
mergelogid	int(10)	YES	YES	YES	UNSIGNED
oldticketid	int(10)	NO	YES	NO	UNSIGNED	0
oldticketmaskid	varchar(20)	NO	YES	NO
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	mergelogid
ticketmergelog1	oldticketid
ticketmergelog2	oldticketmaskid
FKIndex1	staffid
FKIndex2	ticketid

Table Create SQL

CREATE TABLE `swticketmergelog` (
  `mergelogid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `oldticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `oldticketmaskid` varchar(20) NOT NULL,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`mergelogid`),
  INDEX `ticketmergelog1`(`oldticketid`),
  INDEX `ticketmergelog2`(`oldticketmaskid`),
  INDEX `FKIndex1`(`staffid`),
  INDEX `FKIndex2`(`ticketid`),
  CONSTRAINT `Reference_96` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_131` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketmessageid	int(10)	YES	YES	YES	UNSIGNED
messageid	varchar(15)	NO	YES	NO
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
ticketpostid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	ticketmessageid
ticketmessageids1	messageid,ticketid
ticketmessageids2	dateline
FKIndex1	ticketpostid
FKIndex2	ticketid

Table Create SQL

CREATE TABLE `swticketmessageids` (
  `ticketmessageid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `messageid` varchar(15) NOT NULL,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketpostid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`ticketmessageid`),
  INDEX `ticketmessageids1`(`messageid`, `ticketid`),
  INDEX `ticketmessageids2`(`dateline`),
  INDEX `FKIndex1`(`ticketpostid`),
  INDEX `FKIndex2`(`ticketid`),
  CONSTRAINT `Reference_121` FOREIGN KEY (`ticketpostid`)
    REFERENCES `swticketposts`(`ticketpostid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_132` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketnoteid	int(10)	YES	YES	YES	UNSIGNED
typeid	int(10)	NO	YES	NO	UNSIGNED	0
notetype	smallint(1)	NO	YES	NO	UNSIGNED	0
forstaffid	int(10)	NO	YES	NO	UNSIGNED	0
bystaffid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
notes	text	NO	YES	NO

IndexName	Columns
PRIMARY	ticketnoteid
ticketnotes1	typeid,notetype

Table Create SQL

CREATE TABLE `swticketnotes` (
  `ticketnoteid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `typeid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `notetype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `forstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `bystaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `notes` text NOT NULL,
  PRIMARY KEY(`ticketnoteid`),
  INDEX `ticketnotes1`(`typeid`, `notetype`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketwordid	int(10)	YES	YES	NO	UNSIGNED	0
ticketpostid	int(10)	YES	YES	NO	UNSIGNED	0
insubject	smallint(1)	YES	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	ticketwordid,ticketpostid,insubject
ticketpostindex	ticketwordid,ticketpostid,insubject

Table Create SQL

CREATE TABLE `swticketpostindex` (
  `ticketwordid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketpostid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `insubject` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`ticketwordid`, `ticketpostid`, `insubject`),
  UNIQUE INDEX `ticketpostindex`(`ticketwordid`, `ticketpostid`, `insubject`)
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketpostid	int(10)	YES	YES	YES	UNSIGNED
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
userid	int(10)	NO	YES	NO	UNSIGNED	0
fullname	varchar(255)	NO	YES	NO
email	varchar(255)	NO	YES	NO
emailto	varchar(255)	NO	YES	NO
subject	varchar(255)	NO	YES	NO
ipaddress	varchar(255)	NO	YES	NO
hasattachments	smallint(1)	NO	YES	NO		0
edited	smallint(1)	NO	YES	NO	UNSIGNED	0
editedbystaffid	int(10)	NO	YES	NO	UNSIGNED	0
editeddateline	int(10)	NO	YES	NO	UNSIGNED	0
creator	smallint(1)	NO	YES	NO		0
ishtml	smallint(1)	NO	YES	NO	UNSIGNED	0
isemailed	smallint(1)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO
contenthash	varchar(32)	NO	YES	NO
subjecthash	varchar(32)	NO	YES	NO

IndexName	Columns
PRIMARY	ticketpostid
ticketposts2	email,subjecthash
FKIndex1	staffid
ticketposts1	ticketid
FKIndex3	userid

Table Create SQL

CREATE TABLE `swticketposts` (
  `ticketpostid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fullname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `emailto` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `ipaddress` varchar(255) NOT NULL,
  `hasattachments` smallint(1) NOT NULL DEFAULT '0',
  `edited` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `editedbystaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `editeddateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `creator` smallint(1) NOT NULL DEFAULT '0',
  `ishtml` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `isemailed` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  `contenthash` varchar(32) NOT NULL,
  `subjecthash` varchar(32) NOT NULL,
  PRIMARY KEY(`ticketpostid`),
  INDEX `ticketposts2`(`email`, `subjecthash`),
  INDEX `FKIndex1`(`staffid`),
  INDEX `ticketposts1`(`ticketid`),
  INDEX `FKIndex3`(`userid`),
  CONSTRAINT `Reference_97` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_133` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_152` FOREIGN KEY (`userid`)
    REFERENCES `swusers`(`userid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
priorityid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(255)	NO	YES	NO
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
type	enum('public','private')	NO	YES	NO		public
frcolorcode	varchar(100)	NO	YES	NO
bgcolorcode	varchar(100)	NO	YES	NO
iscustom	smallint(1)	NO	YES	NO	UNSIGNED	1

IndexName	Columns
PRIMARY	priorityid

Table Create SQL

CREATE TABLE `swticketpriorities` (
  `priorityid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('public','private') NOT NULL DEFAULT 'public',
  `frcolorcode` varchar(100) NOT NULL,
  `bgcolorcode` varchar(100) NOT NULL,
  `iscustom` smallint(1) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY(`priorityid`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
recipientid	int(10)	YES	YES	YES	UNSIGNED
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
ticketemailid	int(10)	NO	YES	NO	UNSIGNED	0
recipienttype	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	recipientid
ticketrecipients	ticketid,ticketemailid
FKIndex1	ticketemailid
FKIndex2	ticketid

Table Create SQL

CREATE TABLE `swticketrecipients` (
  `recipientid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketemailid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `recipienttype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`recipientid`),
  UNIQUE INDEX `ticketrecipients`(`ticketid`, `ticketemailid`),
  INDEX `FKIndex1`(`ticketemailid`),
  INDEX `FKIndex2`(`ticketid`),
  CONSTRAINT `Reference_118` FOREIGN KEY (`ticketemailid`)
    REFERENCES `swticketemails`(`ticketemailid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_134` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketid	int(10)	YES	YES	YES	UNSIGNED
ticketmaskid	varchar(20)	NO	YES	NO
departmentid	int(10)	NO	YES	NO	UNSIGNED	0
ticketstatusid	int(10)	NO	YES	NO	UNSIGNED	0
priorityid	int(10)	NO	YES	NO	UNSIGNED	0
emailqueueid	int(10)	NO	YES	NO	UNSIGNED	0
userid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
ownerstaffid	int(10)	NO	YES	NO	UNSIGNED	0
assignstatus	smallint(1)	NO	YES	NO	UNSIGNED	0
fullname	varchar(255)	NO	YES	NO
email	varchar(180)	NO	YES	NO
lastreplier	varchar(255)	NO	YES	NO
replyto	varchar(255)	NO	YES	NO
subject	varchar(160)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
lastactivity	int(10)	NO	YES	NO	UNSIGNED	0
laststaffreplytime	int(10)	NO	YES	NO	UNSIGNED	0
slaplanid	int(10)	NO	YES	NO	UNSIGNED	0
ticketslaplanid	int(10)	NO	YES	NO	UNSIGNED	0
duetime	int(10)	NO	YES	NO	UNSIGNED	0
totalreplies	int(10)	NO	YES	NO	UNSIGNED	0
ipaddress	varchar(120)	NO	YES	NO
flagtype	smallint(1)	NO	YES	NO	UNSIGNED	0
hasnotes	smallint(1)	NO	YES	NO	UNSIGNED	0
hasattachments	smallint(1)	NO	YES	NO	UNSIGNED	0
isemailed	smallint(1)	NO	YES	NO	UNSIGNED	0
edited	smallint(1)	NO	YES	NO	UNSIGNED	0
editedbystaffid	int(10)	NO	YES	NO	UNSIGNED	0
editeddateline	int(10)	NO	YES	NO	UNSIGNED	0
creator	smallint(1)	NO	YES	NO		0
charset	varchar(100)	NO	YES	NO
transferencoding	varchar(50)	NO	YES	NO
timeworked	int(10)	NO	YES	NO	UNSIGNED	0
dateicon	int(10)	NO	YES	NO	UNSIGNED	0
lastpostid	int(10)	NO	YES	NO	UNSIGNED	0
firstpostid	int(10)	NO	YES	NO	UNSIGNED	0
tgroupid	int(10)	NO	YES	NO	UNSIGNED	0
messageid	varchar(15)	NO	YES	NO
escalationruleid	int(10)	NO	YES	NO	UNSIGNED	0
hasdraft	smallint(1)	NO	YES	NO	UNSIGNED	0
hasbilling	smallint(1)	NO	YES	NO	UNSIGNED	0
isphonecall	smallint(1)	NO	YES	NO	UNSIGNED	0
isescalated	smallint(1)	NO	YES	NO	UNSIGNED	0
phoneno	varchar(255)	NO	YES	NO
autoclosetimeline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	ticketid
ticketcount	departmentid,ticketstatusid,ownerstaffid
tickets2	slaplanid,duetime,isescalated
tickets3	departmentid,ticketstatusid,lastactivity
tickets4	email,subject
FKIndex1	departmentid
FKIndex2	emailqueueid
FKIndex3	escalationruleid
FKIndex4	slaplanid
FKIndex5	staffid
FKIndex6	tgroupid
FKIndex7	priorityid
FKIndex8	ticketstatusid
tickets1	userid

Table Create SQL

CREATE TABLE `swtickets` (
  `ticketid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketmaskid` varchar(20) NOT NULL,
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketstatusid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `priorityid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `emailqueueid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ownerstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `assignstatus` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `fullname` varchar(255) NOT NULL,
  `email` varchar(180) NOT NULL,
  `lastreplier` varchar(255) NOT NULL,
  `replyto` varchar(255) NOT NULL,
  `subject` varchar(160) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `laststaffreplytime` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `slaplanid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketslaplanid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `duetime` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `totalreplies` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ipaddress` varchar(120) NOT NULL,
  `flagtype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `hasnotes` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `hasattachments` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `isemailed` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `edited` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `editedbystaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `editeddateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `creator` smallint(1) NOT NULL DEFAULT '0',
  `charset` varchar(100) NOT NULL,
  `transferencoding` varchar(50) NOT NULL,
  `timeworked` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateicon` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastpostid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `firstpostid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `tgroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `messageid` varchar(15) NOT NULL,
  `escalationruleid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `hasdraft` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `hasbilling` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `isphonecall` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `isescalated` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `phoneno` varchar(255) NOT NULL,
  `autoclosetimeline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`ticketid`),
  INDEX `ticketcount`(`departmentid`, `ticketstatusid`, `ownerstaffid`),
  INDEX `tickets2`(`slaplanid`, `duetime`, `isescalated`),
  INDEX `tickets3`(`departmentid`, `ticketstatusid`, `lastactivity`),
  INDEX `tickets4`(`email`, `subject`),
  INDEX `FKIndex1`(`departmentid`),
  INDEX `FKIndex2`(`emailqueueid`),
  INDEX `FKIndex3`(`escalationruleid`),
  INDEX `FKIndex4`(`slaplanid`),
  INDEX `FKIndex5`(`staffid`),
  INDEX `FKIndex6`(`tgroupid`),
  INDEX `FKIndex7`(`priorityid`),
  INDEX `FKIndex8`(`ticketstatusid`),
  INDEX `tickets1`(`userid`),
  CONSTRAINT `Reference_37` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_45` FOREIGN KEY (`emailqueueid`)
    REFERENCES `swemailqueues`(`emailqueueid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_46` FOREIGN KEY (`escalationruleid`)
    REFERENCES `swescalationrules`(`escalationruleid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_69` FOREIGN KEY (`slaplanid`)
    REFERENCES `swslaplans`(`slaplanid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_98` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_116` FOREIGN KEY (`tgroupid`)
    REFERENCES `swtemplategroups`(`tgroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_127` FOREIGN KEY (`priorityid`)
    REFERENCES `swticketpriorities`(`priorityid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_141` FOREIGN KEY (`ticketstatusid`)
    REFERENCES `swticketstatus`(`ticketstatusid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_153` FOREIGN KEY (`userid`)
    REFERENCES `swusers`(`userid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketsearchid	int(10)	YES	YES	YES	UNSIGNED
staffid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
keywords	varchar(255)	NO	YES	NO
resultscount	int(10)	NO	YES	NO	UNSIGNED	0
timetaken	float(9,3)	NO	YES	NO	UNSIGNED	0
ticketidlist	mediumtext	NO	YES	NO
rejectedwords	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	ticketsearchid
ticketsearches1	dateline
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swticketsearches` (
  `ticketsearchid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `keywords` varchar(255) NOT NULL,
  `resultscount` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `timetaken` float(9,3) UNSIGNED NOT NULL DEFAULT '0',
  `ticketidlist` mediumtext NOT NULL,
  `rejectedwords` varchar(255) NOT NULL,
  PRIMARY KEY(`ticketsearchid`),
  INDEX `ticketsearches1`(`dateline`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_99` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketstatusid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(255)	NO	YES	NO
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
iscustom	smallint(1)	NO	YES	NO	UNSIGNED	1
displayinmainlist	smallint(1)	NO	YES	NO	UNSIGNED	0
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0
statustype	smallint(1)	NO	YES	NO	UNSIGNED	0
displaycount	smallint(1)	NO	YES	NO	UNSIGNED	0
statuscolor	varchar(50)	NO	YES	NO
departmentid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	ticketstatusid
FKIndex1	departmentid

Table Create SQL

CREATE TABLE `swticketstatus` (
  `ticketstatusid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `iscustom` smallint(1) UNSIGNED NOT NULL DEFAULT '1',
  `displayinmainlist` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `statustype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `displaycount` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `statuscolor` varchar(50) NOT NULL,
  `departmentid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`ticketstatusid`),
  INDEX `FKIndex1`(`departmentid`),
  CONSTRAINT `Reference_38` FOREIGN KEY (`departmentid`)
    REFERENCES `swdepartments`(`departmentid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
timetrackid	int(10)	YES	YES	YES	UNSIGNED
ticketid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
creatorstaffid	int(10)	NO	YES	NO	UNSIGNED	0
timespent	int(10)	NO	YES	NO	UNSIGNED	0
timebillable	int(10)	NO	YES	NO	UNSIGNED	0
forstaffid	int(10)	NO	YES	NO	UNSIGNED	0
notes	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	timetrackid
tickettimetrack	ticketid

Table Create SQL

CREATE TABLE `swtickettimetrack` (
  `timetrackid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `creatorstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `timespent` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `timebillable` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `forstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `notes` mediumtext NOT NULL,
  PRIMARY KEY(`timetrackid`),
  INDEX `tickettimetrack`(`ticketid`),
  CONSTRAINT `Reference_135` FOREIGN KEY (`ticketid`)
    REFERENCES `swtickets`(`ticketid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketviewfieldid	int(10)	YES	YES	YES	UNSIGNED
ticketviewid	int(10)	NO	YES	NO	UNSIGNED	0
ticketviewfieldtype	smallint(1)	NO	YES	NO	UNSIGNED	0
customfieldid	int(10)	NO	YES	NO	UNSIGNED	0
fieldlinkid	smallint(3)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	ticketviewfieldid
FKIndex1	customfieldid
ticketviewfields1	ticketviewid

Table Create SQL

CREATE TABLE `swticketviewfields` (
  `ticketviewfieldid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ticketviewid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketviewfieldtype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `customfieldid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fieldlinkid` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`ticketviewfieldid`),
  INDEX `FKIndex1`(`customfieldid`),
  INDEX `ticketviewfields1`(`ticketviewid`),
  CONSTRAINT `Reference_26` FOREIGN KEY (`customfieldid`)
    REFERENCES `swcustomfields`(`customfieldid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_143` FOREIGN KEY (`ticketviewid`)
    REFERENCES `swticketviews`(`ticketviewid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketviewid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(255)	NO	YES	NO
viewtype	smallint(1)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
viewalltickets	smallint(1)	NO	YES	NO	UNSIGNED	0
viewunassigned	smallint(1)	NO	YES	NO	UNSIGNED	0
viewassigned	smallint(1)	NO	YES	NO	UNSIGNED	0
sortby	smallint(3)	NO	YES	NO	UNSIGNED	0
sortorder	smallint(1)	NO	YES	NO	UNSIGNED	0
ismaster	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
ticketsperpage	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	ticketviewid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swticketviews` (
  `ticketviewid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `viewtype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `viewalltickets` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `viewunassigned` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `viewassigned` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `sortby` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `sortorder` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `ismaster` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ticketsperpage` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`ticketviewid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_100` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ticketwordid	int(10)	YES	YES	YES	UNSIGNED
contents	char(50)	NO	YES	NO

IndexName	Columns
PRIMARY	ticketwordid
ticketwords	contents

Table Create SQL

CREATE TABLE `swticketwords` (
  `ticketwordid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `contents` char(50) NOT NULL,
  PRIMARY KEY(`ticketwordid`),
  UNIQUE INDEX `ticketwords`(`contents`)
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
troubleshootercatid	int(10)	YES	YES	YES	UNSIGNED
staffid	int(10)	NO	YES	NO	UNSIGNED	0
title	varchar(255)	NO	YES	NO
description	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
views	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	troubleshootercatid
FKIndex1	staffid

Table Create SQL

CREATE TABLE `swtroubleshootercat` (
  `troubleshootercatid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`troubleshootercatid`),
  INDEX `FKIndex1`(`staffid`),
  CONSTRAINT `Reference_101` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
troubleshooterdataid	int(10)	YES	YES	YES	UNSIGNED
troubleshooterid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	troubleshooterdataid
troubleshooterdata1	troubleshooterid

Table Create SQL

CREATE TABLE `swtroubleshooterdata` (
  `troubleshooterdataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `troubleshooterid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`troubleshooterdataid`),
  INDEX `troubleshooterdata1`(`troubleshooterid`),
  CONSTRAINT `Reference_146` FOREIGN KEY (`troubleshooterid`)
    REFERENCES `swtroubleshootersteps`(`troubleshooterid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	FIXED
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
troubleshooterlinkid	int(10)	YES	YES	YES	UNSIGNED
troubleshootercatid	int(10)	NO	YES	NO	UNSIGNED	0
parenttroubleshooterid	int(10)	NO	YES	NO	UNSIGNED	0
childtroubleshooterid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	troubleshooterlinkid
troubleshootercatid	troubleshootercatid,parenttroubleshooterid,childtroubleshooterid
FKIndex1	troubleshootercatid

Table Create SQL

CREATE TABLE `swtroubleshooterlinks` (
  `troubleshooterlinkid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `troubleshootercatid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `parenttroubleshooterid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `childtroubleshooterid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`troubleshooterlinkid`),
  UNIQUE INDEX `troubleshootercatid`(`troubleshootercatid`, `parenttroubleshooterid`, `childtroubleshooterid`),
  INDEX `FKIndex1`(`troubleshootercatid`),
  CONSTRAINT `Reference_144` FOREIGN KEY (`troubleshootercatid`)
    REFERENCES `swtroubleshootercat`(`troubleshootercatid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=fixed;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
troubleshooterid	int(10)	YES	YES	YES	UNSIGNED
troubleshootercatid	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
subject	varchar(255)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
edited	smallint(1)	NO	YES	NO	UNSIGNED	0
editedstaffid	int(10)	NO	YES	NO	UNSIGNED	0
displayorder	int(10)	NO	YES	NO	UNSIGNED	0
views	int(10)	NO	YES	NO	UNSIGNED	0
totalcomments	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	troubleshooterid
FKIndex1	staffid
troubleshootersteps1	troubleshootercatid

Table Create SQL

CREATE TABLE `swtroubleshootersteps` (
  `troubleshooterid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `troubleshootercatid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `subject` varchar(255) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `edited` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `editedstaffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `totalcomments` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`troubleshooterid`),
  INDEX `FKIndex1`(`staffid`),
  INDEX `troubleshootersteps1`(`troubleshootercatid`),
  CONSTRAINT `Reference_102` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_145` FOREIGN KEY (`troubleshootercatid`)
    REFERENCES `swtroubleshootercat`(`troubleshootercatid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
twdeletelogid	int(10)	YES	YES	YES	UNSIGNED
entrytype	smallint(1)	NO	YES	NO	UNSIGNED	0
entryid	varchar(50)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	twdeletelogid
twdeletelog1	dateline

Table Create SQL

CREATE TABLE `swtwdeletelog` (
  `twdeletelogid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `entrytype` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `entryid` varchar(50) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`twdeletelogid`),
  INDEX `twdeletelog1`(`dateline`)
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
useremailid	int(10)	YES	YES	YES	UNSIGNED
userid	int(10)	NO	YES	NO	UNSIGNED	0
email	varchar(255)	NO	YES	NO
isprimary	smallint(1)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	useremailid
email	email
usersemail2	email
usersemail1	userid

Table Create SQL

CREATE TABLE `swuseremails` (
  `useremailid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL,
  `isprimary` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`useremailid`),
  UNIQUE INDEX `email`(`email`),
  INDEX `usersemail2`(`email`),
  INDEX `usersemail1`(`userid`),
  CONSTRAINT `Reference_154` FOREIGN KEY (`userid`)
    REFERENCES `swusers`(`userid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
usergroupid	int(10)	YES	YES	YES	UNSIGNED
title	varchar(100)	NO	YES	NO
grouptype	enum('guest','registered','custom')	NO	YES	NO		custom
ismaster	smallint(1)	NO	YES	NO	UNSIGNED	0
slaplanid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	usergroupid
usergroups1	grouptype
FKIndex1	slaplanid

Table Create SQL

CREATE TABLE `swusergroups` (
  `usergroupid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `grouptype` enum('guest','registered','custom') NOT NULL DEFAULT 'custom',
  `ismaster` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `slaplanid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`usergroupid`),
  INDEX `usergroups1`(`grouptype`),
  INDEX `FKIndex1`(`slaplanid`),
  CONSTRAINT `Reference_70` FOREIGN KEY (`slaplanid`)
    REFERENCES `swslaplans`(`slaplanid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
ugroupsettingid	int(10)	YES	YES	YES	UNSIGNED
usergroupid	int(10)	NO	YES	NO	UNSIGNED	0
name	varchar(100)	NO	YES	NO
value	varchar(255)	NO	YES	NO

IndexName	Columns
PRIMARY	ugroupsettingid
usergroupid	usergroupid,name
usergroupsettings1	usergroupid

Table Create SQL

CREATE TABLE `swusergroupsettings` (
  `ugroupsettingid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `usergroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY(`ugroupsettingid`),
  UNIQUE INDEX `usergroupid`(`usergroupid`, `name`),
  INDEX `usergroupsettings1`(`usergroupid`),
  CONSTRAINT `Reference_147` FOREIGN KEY (`usergroupid`)
    REFERENCES `swusergroups`(`usergroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
userid	int(10)	YES	YES	YES	UNSIGNED
usergroupid	int(10)	NO	YES	NO	UNSIGNED	0
fullname	varchar(200)	NO	YES	NO
phone	varchar(200)	NO	YES	NO
userpassword	varchar(50)	NO	YES	NO
userpasswordtxt	varchar(50)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
lastvisit	int(10)	NO	YES	NO	UNSIGNED	0
lastactivity	int(10)	NO	YES	NO	UNSIGNED	0
enabled	smallint(1)	NO	YES	NO	UNSIGNED	0
loginapi_moduleid	int(10)	NO	YES	NO	UNSIGNED	1
loginapi_userid	varchar(100)	NO	YES	NO
languageid	int(10)	NO	YES	NO	UNSIGNED	0
timezoneoffset	varchar(10)	NO	YES	NO		0
enabledst	smallint(1)	NO	YES	NO	UNSIGNED	0
useremailcount	int(10)	NO	YES	NO	UNSIGNED	0
allowemail	smallint(1)	NO	YES	NO	UNSIGNED	0
slaplanid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	userid
users3	loginapi_moduleid,loginapi_userid
users4	enabled,dateline
FKIndex1	languageid
FKIndex2	slaplanid
users1	usergroupid

Table Create SQL

CREATE TABLE `swusers` (
  `userid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `usergroupid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fullname` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `userpassword` varchar(50) NOT NULL,
  `userpasswordtxt` varchar(50) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastvisit` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `enabled` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `loginapi_moduleid` int(10) UNSIGNED NOT NULL DEFAULT '1',
  `loginapi_userid` varchar(100) NOT NULL,
  `languageid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `timezoneoffset` varchar(10) NOT NULL DEFAULT '0',
  `enabledst` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `useremailcount` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `allowemail` smallint(1) UNSIGNED NOT NULL DEFAULT '0',
  `slaplanid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`userid`),
  INDEX `users3`(`loginapi_moduleid`, `loginapi_userid`),
  INDEX `users4`(`enabled`, `dateline`),
  INDEX `FKIndex1`(`languageid`),
  INDEX `FKIndex2`(`slaplanid`),
  INDEX `users1`(`usergroupid`),
  CONSTRAINT `Reference_53` FOREIGN KEY (`languageid`)
    REFERENCES `swlanguages`(`languageid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_71` FOREIGN KEY (`slaplanid`)
    REFERENCES `swslaplans`(`slaplanid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_148` FOREIGN KEY (`usergroupid`)
    REFERENCES `swusergroups`(`usergroupid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
userverifyhashid	varchar(50)	YES	YES	NO		0
userid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	userverifyhashid
FKIndex1	userid

Table Create SQL

CREATE TABLE `swuserverifyhash` (
  `userverifyhashid` varchar(50) NOT NULL DEFAULT '0',
  `userid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`userverifyhashid`),
  INDEX `FKIndex1`(`userid`),
  CONSTRAINT `Reference_155` FOREIGN KEY (`userid`)
    REFERENCES `swusers`(`userid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
visitorbanid	int(10)	YES	YES	YES	UNSIGNED
ipaddress	varchar(50)	NO	YES	NO		0.0.0.0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	visitorbanid
ipaddress	ipaddress
visitorbans1	ipaddress
visitorbans2	staffid

Table Create SQL

CREATE TABLE `swvisitorbans` (
  `visitorbanid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ipaddress` varchar(50) NOT NULL DEFAULT '0.0.0.0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`visitorbanid`),
  UNIQUE INDEX `ipaddress`(`ipaddress`),
  INDEX `visitorbans1`(`ipaddress`),
  INDEX `visitorbans2`(`staffid`),
  CONSTRAINT `Reference_103` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	HEAP
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
sessionid	varchar(32)	NO	YES	NO
pageurl	varchar(255)	NO	YES	NO
pagehash	varchar(32)	NO	YES	NO
pagetitle	varchar(255)	NO	YES	NO
country	varchar(255)	NO	YES	NO
countrycode	char(2)	NO	YES	NO
dateline	int(10)	NO	YES	NO	UNSIGNED	0
lastactivity	int(10)	NO	YES	NO	UNSIGNED	0
ipaddress	varchar(80)	NO	YES	NO		0.0.0.0
hostname	varchar(80)	NO	YES	NO
referrer	varchar(255)	NO	YES	NO
resolution	varchar(30)	NO	YES	NO
colordepth	varchar(20)	NO	YES	NO
appversion	varchar(150)	NO	YES	NO
operatingsys	varchar(20)	NO	YES	NO
browsername	varchar(150)	NO	YES	NO
browserversion	varchar(150)	NO	YES	NO
browsercode	char(2)	NO	YES	NO
searchenginename	varchar(20)	NO	YES	NO
searchstring	varchar(255)	NO	YES	NO
searchengineurl	varchar(200)	NO	YES	NO
platform	varchar(150)	NO	YES	NO
rowbgcolor	varchar(7)	NO	YES	NO
rowfrcolor	varchar(7)	NO	YES	NO
hasnote	smallint(5)	NO	YES	NO	UNSIGNED	0
topull	smallint(5)	NO	YES	NO	UNSIGNED	0
campaignid	int(10)	NO	YES	NO	UNSIGNED	0
campaigntitle	varchar(255)	NO	YES	NO

IndexName	Columns
sessionid	sessionid,pagehash
lastactivity	lastactivity
FKIndex1	campaignid
FKIndex2	sessionid

Table Create SQL

CREATE TABLE `swvisitorfootprints` (
  `sessionid` varchar(32) NOT NULL,
  `pageurl` varchar(255) NOT NULL,
  `pagehash` varchar(32) NOT NULL,
  `pagetitle` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `countrycode` char(2) NOT NULL,
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `lastactivity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `ipaddress` varchar(80) NOT NULL DEFAULT '0.0.0.0',
  `hostname` varchar(80) NOT NULL,
  `referrer` varchar(255) NOT NULL,
  `resolution` varchar(30) NOT NULL,
  `colordepth` varchar(20) NOT NULL,
  `appversion` varchar(150) NOT NULL,
  `operatingsys` varchar(20) NOT NULL,
  `browsername` varchar(150) NOT NULL,
  `browserversion` varchar(150) NOT NULL,
  `browsercode` char(2) NOT NULL,
  `searchenginename` varchar(20) NOT NULL,
  `searchstring` varchar(255) NOT NULL,
  `searchengineurl` varchar(200) NOT NULL,
  `platform` varchar(150) NOT NULL,
  `rowbgcolor` varchar(7) NOT NULL,
  `rowfrcolor` varchar(7) NOT NULL,
  `hasnote` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `topull` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `campaignid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `campaigntitle` varchar(255) NOT NULL,
  INDEX `sessionid`(`sessionid`, `pagehash`),
  INDEX `lastactivity`(`lastactivity`),
  INDEX `FKIndex1`(`campaignid`),
  INDEX `FKIndex2`(`sessionid`),
  CONSTRAINT `Reference_03` FOREIGN KEY (`campaignid`)
    REFERENCES `swadcampaigns`(`campaignid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
  CONSTRAINT `Reference_64` FOREIGN KEY (`sessionid`)
    REFERENCES `swsessions`(`sessionid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=HEAP
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
visitornotedataid	int(10)	YES	YES	YES	UNSIGNED
visitornoteid	int(10)	NO	YES	NO	UNSIGNED	0
contents	mediumtext	NO	YES	NO

IndexName	Columns
PRIMARY	visitornotedataid
visitornotedata1	visitornoteid

Table Create SQL

CREATE TABLE `swvisitornotedata` (
  `visitornotedataid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `visitornoteid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `contents` mediumtext NOT NULL,
  PRIMARY KEY(`visitornotedataid`),
  INDEX `visitornotedata1`(`visitornoteid`),
  CONSTRAINT `Reference_156` FOREIGN KEY (`visitornoteid`)
    REFERENCES `swvisitornotes`(`visitornoteid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	MYISAM
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
visitornoteid	int(10)	YES	YES	YES	UNSIGNED
ipaddress	varchar(50)	NO	YES	NO		0.0.0.0
dateline	int(10)	NO	YES	NO	UNSIGNED	0
staffid	int(10)	NO	YES	NO	UNSIGNED	0
staffname	varchar(150)	NO	YES	NO

IndexName	Columns
PRIMARY	visitornoteid
visitornotes1	ipaddress
visitornotes2	staffid

Table Create SQL

CREATE TABLE `swvisitornotes` (
  `visitornoteid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ipaddress` varchar(50) NOT NULL DEFAULT '0.0.0.0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `staffname` varchar(150) NOT NULL,
  PRIMARY KEY(`visitornoteid`),
  INDEX `visitornotes1`(`ipaddress`),
  INDEX `visitornotes2`(`staffid`),
  CONSTRAINT `Reference_104` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=MYISAM
ROW_FORMAT=dynamic;

Table Description
Table Annotation

Param Name	Param Value
Table Type	HEAP
Row Format	DYNAMIC
Temporary	NO
Row Checksum	NO

Column Name	Data Type	Primary Key	Not Null	AutoInc	Flags	Default Value	Comment
visitorsessionid	varchar(32)	YES	YES	NO
staffid	int(10)	NO	YES	NO	UNSIGNED	0
dateline	int(10)	NO	YES	NO	UNSIGNED	0

IndexName	Columns
PRIMARY	visitorsessionid
visitorpulls1	staffid

Table Create SQL

CREATE TABLE `swvisitorpulls` (
  `visitorsessionid` varchar(32) NOT NULL,
  `staffid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY(`visitorsessionid`),
  INDEX `visitorpulls1`(`staffid`),
  CONSTRAINT `Reference_105` FOREIGN KEY (`staffid`)
    REFERENCES `swstaff`(`staffid`)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION
)
TYPE=HEAP
ROW_FORMAT=dynamic;

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swadcampaigns	swadhitlogs	NO ACTION	NO ACTION	campaignid=campaignid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swadcampaigns	swadsearchqueries	NO ACTION	NO ACTION	campaignid=campaignid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swadcampaigns	swvisitorfootprints	NO ACTION	NO ACTION	campaignid=campaignid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swalertrules	swalertactions	NO ACTION	NO ACTION	alertruleid=alertruleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swattachments	swattachmentchunks	NO ACTION	NO ACTION	attachmentid=attachmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcalendarcategories	swcalendarevents	NO ACTION	NO ACTION	calendarcategoryid=calendarcategoryid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcalendarcategories	swcontacts	NO ACTION	NO ACTION	calendarcategoryid=calendarcategoryid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcalendarlabels	swcalendarevents	NO ACTION	NO ACTION	calendarlabelid=calendarlabelid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcalendarlabels	swcalendartasks	NO ACTION	NO ACTION	calendarlabelid=calendarlabelid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcalendarpriorities	swcalendartasks	NO ACTION	NO ACTION	calendarpriorityid=calendarpriorityid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcalendarstatus	swcalendarevents	NO ACTION	NO ACTION	calendarstatusid=calendarstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcalendarstatus	swcalendartasks	NO ACTION	NO ACTION	calendarstatusid=calendarstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcannedcategories	swcannedresponses	NO ACTION	NO ACTION	cannedcategoryid=cannedcategoryid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcannedresponses	swcannedresponsedata	NO ACTION	NO ACTION	cannedresponseid=cannedresponseid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swchatchilds	swmessagequeue	NO ACTION	NO ACTION	chatchildid=chatchildid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swchatobjects	swchatchilds	NO ACTION	NO ACTION	chatobjectid=chatobjectid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swchatobjects	swchatdata	NO ACTION	NO ACTION	chatobjectid=chatobjectid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swchatobjects	swmessagequeue	NO ACTION	NO ACTION	chatobjectid=chatobjectid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcomments	swcommentdata	NO ACTION	NO ACTION	commentid=commentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcontacts	swcalendartasks	NO ACTION	NO ACTION	contactid=contactid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcron	swcronlogs	NO ACTION	NO ACTION	cronid=cronid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcustomfieldgroups	swcustomfieldlinks	NO ACTION	NO ACTION	customfieldgroupid=customfieldgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcustomfieldgroups	swcustomfields	NO ACTION	NO ACTION	customfieldgroupid=customfieldgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcustomfields	swcustomfieldoptions	NO ACTION	NO ACTION	customfieldid=customfieldid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcustomfields	swcustomfieldvalues	NO ACTION	NO ACTION	customfieldid=customfieldid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swcustomfields	swticketviewfields	NO ACTION	NO ACTION	customfieldid=customfieldid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swalertrules	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swauditlogs	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swchatobjects	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swemailqueues	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swescalationrules	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swgroupassigns	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swmessages	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swslaplans	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swstaffassigns	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swtemplategroups	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swtickets	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdepartments	swticketstatus	NO ACTION	NO ACTION	departmentid=departmentid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdownloadcategories	swdownloaditems	NO ACTION	NO ACTION	downloadcategoryid=downloadcategoryid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdownloaditems	swattachments	NO ACTION	NO ACTION	downloaditemid=downloaditemid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swdownloaditems	swdownloaddesc	NO ACTION	NO ACTION	downloaditemid=downloaditemid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swemailqueues	swcatchallrules	NO ACTION	NO ACTION	emailqueueid=emailqueueid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swemailqueues	swparserlogs	NO ACTION	NO ACTION	emailqueueid=emailqueueid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swemailqueues	swqueuesignatures	NO ACTION	NO ACTION	emailqueueid=emailqueueid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swemailqueues	swtickets	NO ACTION	NO ACTION	emailqueueid=emailqueueid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swescalationrules	swtickets	NO ACTION	NO ACTION	escalationruleid=escalationruleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swkbarticles	swkbarticledata	NO ACTION	NO ACTION	kbarticleid=kbarticleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swkbarticles	swkbarticlefiles	NO ACTION	NO ACTION	kbarticleid=kbarticleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swkbarticles	swkbarticlelinks	NO ACTION	NO ACTION	kbarticleid=kbarticleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swkbcategories	swkbarticlelinks	NO ACTION	NO ACTION	kbcategoryid=kbcategoryid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swlanguages	swlanguagephrases	NO ACTION	NO ACTION	languageid=languageid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swlanguages	swtemplategroups	NO ACTION	NO ACTION	languageid=languageid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swlanguages	swusers	NO ACTION	NO ACTION	languageid=languageid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swmessages	swmessagedata	NO ACTION	NO ACTION	messageid=messageid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swnews	swnewsdata	NO ACTION	NO ACTION	newsid=newsid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swnewssubscribers	swnewsverihash	NO ACTION	NO ACTION	newssubscriberid=newssubscriberid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swparserlogs	swparserlogdata	NO ACTION	NO ACTION	parserlogid=parserlogid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swparserrules	swruleactions	NO ACTION	NO ACTION	parserruleid=parserruleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swparserrules	swrulecriteria	NO ACTION	NO ACTION	parserruleid=parserruleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swpredefinedcategories	swpredefinedreplies	NO ACTION	NO ACTION	predefinedcategoryid=predefinedcategoryid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swpredefinedreplies	swpredefinedreplydata	NO ACTION	NO ACTION	predefinedreplyid=predefinedreplyid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swprivatemessages	swprivatemessagedata	NO ACTION	NO ACTION	privatemessageid=privatemessageid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swregistry	swsettings	NO ACTION	NO ACTION	vkey=vkey

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swsessions	swvisitorfootprints	NO ACTION	NO ACTION	sessionid=sessionid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swsettingsgroups	swsettingsfields	NO ACTION	NO ACTION	sgroupid=sgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swslaplans	swescalationrules	NO ACTION	NO ACTION	slaplanid=slaplanid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swslaplans	swslaplanprioritylink	NO ACTION	NO ACTION	slaplanid=slaplanid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swslaplans	swslaplanstatuslink	NO ACTION	NO ACTION	slaplanid=slaplanid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swslaplans	swtickets	NO ACTION	NO ACTION	slaplanid=slaplanid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swslaplans	swusergroups	NO ACTION	NO ACTION	slaplanid=slaplanid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swslaplans	swusers	NO ACTION	NO ACTION	slaplanid=slaplanid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swslaschedules	swslaplans	NO ACTION	NO ACTION	slascheduleid=slascheduleid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swalertrules	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swauditlogs	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swcalendarevents	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swcalendartasks	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swcannedcategories	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swcannedresponses	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swchatchilds	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swchatobjects	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swcontacts	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swdownloadcategories	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swescalationrules	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swkbarticles	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swkbcategories	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swmessagequeue	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swmessages	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swnews	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swparserbans	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swpredefinedcategories	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swpredefinedreplies	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swsignatures	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swstaffassigns	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swstaffschedules	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swsynclog	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swticketmergelog	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swticketposts	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swtickets	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swticketsearches	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swticketviews	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swtroubleshootercat	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swtroubleshootersteps	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swvisitorbans	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swvisitornotes	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaff	swvisitorpulls	NO ACTION	NO ACTION	staffid=staffid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaffgroup	swgroupassigns	NO ACTION	NO ACTION	staffgroupid=staffgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaffgroup	swstaff	NO ACTION	NO ACTION	staffgroupid=staffgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swstaffgroup	swstaffgroupsettings	NO ACTION	NO ACTION	staffgroupid=staffgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplatecategories	swtemplates	NO ACTION	NO ACTION	tcategoryid=tcategoryid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplategroups	swemailqueues	NO ACTION	NO ACTION	tgroupid=tgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplategroups	swnews	NO ACTION	NO ACTION	tgroupid=tgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplategroups	swnewssubscribers	NO ACTION	NO ACTION	tgroupid=tgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplategroups	swtemplatecategories	NO ACTION	NO ACTION	tgroupid=tgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplategroups	swtemplates	NO ACTION	NO ACTION	tgroupid=tgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplategroups	swtgroupassigns	NO ACTION	NO ACTION	tgroupid=tgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplategroups	swtickets	NO ACTION	NO ACTION	tgroupid=tgroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtemplates	swtemplatedata	NO ACTION	NO ACTION	templateid=templateid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketemails	swticketrecipients	NO ACTION	NO ACTION	ticketemailid=ticketemailid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketposts	swattachments	NO ACTION	NO ACTION	ticketpostid=ticketpostid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketposts	swparserlogs	NO ACTION	NO ACTION	ticketpostid=ticketpostid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketposts	swticketmessageids	NO ACTION	NO ACTION	ticketpostid=ticketpostid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketpriorities	swalertrules	NO ACTION	NO ACTION	priorityid=priorityid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketpriorities	swemailqueues	NO ACTION	NO ACTION	priorityid=priorityid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketpriorities	swescalationrules	NO ACTION	NO ACTION	priorityid=priorityid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketpriorities	swslaplanprioritylink	NO ACTION	NO ACTION	priorityid=priorityid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketpriorities	swtemplategroups	NO ACTION	NO ACTION	priorityid=priorityid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketpriorities	swtickets	NO ACTION	NO ACTION	priorityid=priorityid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swattachments	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swauditlogs	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swticketdrafts	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swticketmergelog	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swticketmessageids	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swticketposts	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swticketrecipients	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtickets	swtickettimetrack	NO ACTION	NO ACTION	ticketid=ticketid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketstatus	swalertrules	NO ACTION	NO ACTION	ticketstatusid=ticketstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketstatus	swemailqueues	NO ACTION	NO ACTION	ticketstatusid=ticketstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketstatus	swescalationrules	NO ACTION	NO ACTION	ticketstatusid=ticketstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketstatus	swslaplanstatuslink	NO ACTION	NO ACTION	ticketstatusid=ticketstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketstatus	swtemplategroups	NO ACTION	NO ACTION	ticketstatusid=ticketstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketstatus	swtickets	NO ACTION	NO ACTION	ticketstatusid=ticketstatusid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketviews	swstaff	NO ACTION	NO ACTION	ticketviewid=ticketviewid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swticketviews	swticketviewfields	NO ACTION	NO ACTION	ticketviewid=ticketviewid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtroubleshootercat	swtroubleshooterlinks	NO ACTION	NO ACTION	troubleshootercatid=troubleshootercatid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtroubleshootercat	swtroubleshootersteps	NO ACTION	NO ACTION	troubleshootercatid=troubleshootercatid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swtroubleshootersteps	swtroubleshooterdata	NO ACTION	NO ACTION	troubleshooterid=troubleshooterid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusergroups	swusergroupsettings	NO ACTION	NO ACTION	usergroupid=usergroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusergroups	swusers	NO ACTION	NO ACTION	usergroupid=usergroupid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusers	swauditlogs	NO ACTION	NO ACTION	userid=userid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusers	swchatobjects	NO ACTION	NO ACTION	userid=userid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusers	swnewssubscribers	NO ACTION	NO ACTION	userid=userid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusers	swticketposts	NO ACTION	NO ACTION	userid=userid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusers	swtickets	NO ACTION	NO ACTION	userid=userid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusers	swuseremails	NO ACTION	NO ACTION	userid=userid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swusers	swuserverifyhash	NO ACTION	NO ACTION	userid=userid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swvisitornotes	swvisitornotedata	NO ACTION	NO ACTION	visitornoteid=visitornoteid

Reference Description
Reference Annotation

Source Table	Target Table	Delete Action	Update Action	Link
swvisitorpulls	swchatobjects	NO ACTION	NO ACTION	visitorsessionid=visitorsessionid