• swalertactions

• swalertrules

• swattachmentchunks

• swattachments

• swbayescategories

• swbayeswords

• swbayeswordsfreqs

• swbenchmarkresults

• swbenchmarks

• swbreaklines

• swcalls

• swcannedcategories

• swcannedresponsedata

• swcannedresponses

• swcatchallrules

• swchatchilds

• swchatdata

• swchathits

• swchatobjects

• swchatskilllinks

• swchatskills

• swchattextdata

• swchatvariables

• swcommentdata

• swcomments

• swcron

• swcronlogs

• swcustomfielddeplinks

• swcustomfieldgrouppermissions

• swcustomfieldgroups

• swcustomfieldlinks

• swcustomfieldoptionlinks

• swcustomfieldoptions

• swcustomfields

• swcustomfieldvalues

• swdepartments

• swemailqueues

• swerrorlogs

• swescalationnotifications

• swescalationpaths

• swescalationrules

• swfiles

• swgeoipcities

• swgeoipcityblocks1

• swgeoipcityblocks10

• swgeoipcityblocks2

• swgeoipcityblocks3

• swgeoipcityblocks4

• swgeoipcityblocks5

• swgeoipcityblocks6

• swgeoipcityblocks7

• swgeoipcityblocks8

• swgeoipcityblocks9

• swgeoipisp1

• swgeoipisp10

• swgeoipisp2

• swgeoipisp3

• swgeoipisp4

• swgeoipisp5

• swgeoipisp6

• swgeoipisp7

• swgeoipisp8

• swgeoipisp9

• swgeoipnetspeed1

• swgeoipnetspeed10

• swgeoipnetspeed2

• swgeoipnetspeed3

• swgeoipnetspeed4

• swgeoipnetspeed5

• swgeoipnetspeed6

• swgeoipnetspeed7

• swgeoipnetspeed8

• swgeoipnetspeed9

• swgeoiporganization1

• swgeoiporganization10

• swgeoiporganization2

• swgeoiporganization3

• swgeoiporganization4

• swgeoiporganization5

• swgeoiporganization6

• swgeoiporganization7

• swgeoiporganization8

• swgeoiporganization9

• swgroupassigns

• swimportlogs

• swimportregistry

• swjobqueuemessagelogs

• swjobqueuemessagepackets

• swjobqueuemessages

• swkbarticledata

• swkbarticlelinks

• swkbarticles

• swkbarticlesubscribers

• swkbcategories

• swlanguagephrases

• swlanguages

• swmacrocategories

• swmacroreplies

• swmacroreplydata

• swmailqueuedata

• swmessagedata

• swmessagequeue

• swmessagerouting

• swmessages

• swnewscategories

• swnewscategorylinks

• swnewsitemdata

• swnewsitems

• swnewssubscriberhash

• swnewssubscribers

• swnotificationactions

• swnotificationcriteria

• swnotificationpool

• swnotificationrules

• swonsitesessions

• swparserbans

• swparserlogdata

• swparserlogs

• swparserloopblocks

• swparserloophits

• swparserlooprules

• swparserruleactions

• swparserrulecriteria

• swparserrules

• swqueuesignatures

• swregistry

• swreportcriteria

• swreportfields

• swreportfolders

• swreportfunctions

• swreportgroupfields

• swreports

• swreportsortfields

• swsearchenginequeue

• swsearchstoredata

• swsearchstores

• swsearchtextinstances

• swsearchtextngrams

• swsearchtextvariables

• swsessions

• swsettings

• swsettingsfields

• swsettingsgroups

• swsignatures

• swslaholidaylinks

• swslaholidays

• swslaplans

• swslarulecriteria

• swslaschedules

• swslascheduletable

• swstaff

• swstaffactivitylog

• swstaffassigns

• swstaffgroup

• swstaffgrouplinks

• swstaffgroupsettings

• swstaffloginlog

• swstaffprofileimages

• swstaffsettings

• swtaglinks

• swtags

• swtemplatecategories

• swtemplatedata

• swtemplategroups

• swtemplatehistory

• swtemplates

• swticketauditlogs

• swticketdrafts

• swticketemails

• swticketfiletypes

• swticketfilterfields

• swticketfilters

• swticketfollowups

• swticketlabels

• swticketlinkchains

• swticketlinkedtables

• swticketlinks

• swticketlinktypes

• swticketlocks

• swticketmergelog

• swticketmessageids

• swticketnotes

• swticketpostlocks

• swticketposts

• swticketpriorities

• swticketrecipients

• swticketrecurrences

• swtickets

• swticketstatus

• swtickettimetracknotes

• swtickettimetracks

• swtickettypes

• swticketviewfields

• swticketviewlinks

• swticketviews

• swticketwatchers

• swticketworkflowactions

• swticketworkflowcriteria

• swticketworkflownotifications

• swticketworkflows

• swtroubleshootercategories

• swtroubleshooterdata

• swtroubleshooterlinks

• swtroubleshootersteps

• swuseremails

• swusergroupassigns

• swusergroups

• swusergroupsettings

• swusernotedata

• swusernotes

• swuserorganizations

• swuserprofileimages

• swusers

• swusersettings

• swuserverifyhash

• swvisitorbans

• swvisitordata

• swvisitorfootprints

• swvisitorgroups

• swvisitornotedata

• swvisitornotes

• swvisitorpulls

• swvisitorpulls2

• swvisitorruleactions

• swvisitorrulecriteria

• swvisitorrules

• swwidgets

 

swalertactions

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
alertactionid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
alertruleid	int(11)	(NULL)	NO		0		select,insert,update,references
actiontype	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swalertactions	0	PRIMARY	1	alertactionid	A	0	(NULL)	(NULL)		BTREE
swalertactions	1	alertactions1	1	actiontype	A	0	(NULL)	(NULL)		BTREE

Back

 

swalertrules

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
alertruleid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
alertscope	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
staffid	int(11)	(NULL)	NO		0		select,insert,update,references
departmentid	int(11)	(NULL)	NO		0		select,insert,update,references
priorityid	int(11)	(NULL)	NO		0		select,insert,update,references
ticketstatusid	int(11)	(NULL)	NO		0		select,insert,update,references
alerttype	smallint(6)	(NULL)	NO		0		select,insert,update,references
execassign	smallint(6)	(NULL)	NO		0		select,insert,update,references
title	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swalertrules	0	PRIMARY	1	alertruleid	A	0	(NULL)	(NULL)		BTREE
swalertrules	1	alertrules1	1	alertscope	A	0	(NULL)	(NULL)		BTREE
swalertrules	1	alertrules1	2	staffid	A	0	(NULL)	(NULL)		BTREE

Back

 

swattachmentchunks

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chunkid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
attachmentid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
contents	mediumblob	(NULL)	NO		(NULL)		select,insert,update,references
notbase64	smallint(6)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swattachmentchunks	0	PRIMARY	1	chunkid	A	0	(NULL)	(NULL)		BTREE
swattachmentchunks	1	attachmentchunks1	1	attachmentid	A	0	(NULL)	(NULL)		BTREE

Back

 

swattachments

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
attachmentid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
linktype	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
linktypeid	int(11)	(NULL)	NO		0		select,insert,update,references
downloaditemid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
ticketid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
filename	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
filesize	int(11)	(NULL)	NO		0		select,insert,update,references
filetype	varchar(150)	utf8_unicode_ci	NO				select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references
attachmenttype	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
storefilename	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swattachments	0	PRIMARY	1	attachmentid	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments1	1	linktype	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments1	2	linktypeid	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments2	1	attachmenttype	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments3	1	downloaditemid	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments4	1	ticketid	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments4	2	linktype	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments4	3	linktypeid	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments5	1	linktype	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments5	2	ticketid	A	0	(NULL)	(NULL)		BTREE
swattachments	1	attachments5	3	linktypeid	A	0	(NULL)	(NULL)		BTREE

Back

 

swbayescategories

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
bayescategoryid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
category	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
probability	decimal(10,0)	(NULL)	NO		0		select,insert,update,references
wordcount	bigint(20)	(NULL)	NO		0		select,insert,update,references
categoryweight	smallint(6)	(NULL)	NO		0		select,insert,update,references
ismaster	smallint(6)	(NULL)	NO		0		select,insert,update,references
categorytype	smallint(6)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swbayescategories	0	PRIMARY	1	bayescategoryid	A	2	(NULL)	(NULL)		BTREE

Back

 

swbayeswords

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
bayeswordid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
word	varchar(255)	utf8_unicode_ci	NO	UNI			select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swbayeswords	0	PRIMARY	1	bayeswordid	A	0	(NULL)	(NULL)		BTREE
swbayeswords	0	bayeswords1	1	word	A	0	(NULL)	(NULL)		BTREE

Back

 

swbayeswordsfreqs

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
bayeswordid	int(11)	(NULL)	NO	PRI	0		select,insert,update,references
bayescategoryid	int(11)	(NULL)	NO	PRI	0		select,insert,update,references
wordcount	bigint(20)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swbayeswordsfreqs	0	bayeswordsfreqs1	1	bayeswordid	A	0	(NULL)	(NULL)		BTREE
swbayeswordsfreqs	0	bayeswordsfreqs1	2	bayescategoryid	A	0	(NULL)	(NULL)		BTREE

Back

 

swbenchmarkresults

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
benchmarkresultid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references
typeid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
benchmarkid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
benchmarkresult	double	(NULL)	NO		0		select,insert,update,references
creatorid	int(11)	(NULL)	NO		0		select,insert,update,references
creatortype	smallint(6)	(NULL)	NO		0		select,insert,update,references
isedited	smallint(6)	(NULL)	NO		0		select,insert,update,references
editorid	int(11)	(NULL)	NO		0		select,insert,update,references
editortype	smallint(6)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swbenchmarkresults	0	PRIMARY	1	benchmarkresultid	A	0	(NULL)	(NULL)		BTREE
swbenchmarkresults	1	benchmarkresults1	1	benchmarkid	A	0	(NULL)	(NULL)		BTREE
swbenchmarkresults	1	benchmarkresults2	1	typeid	A	0	(NULL)	(NULL)		BTREE
swbenchmarkresults	1	benchmarkresults2	2	benchmarkid	A	0	(NULL)	(NULL)		BTREE

Back

 

swbenchmarks

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
benchmarkid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references
departmentid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
displayorder	int(11)	(NULL)	NO		0		select,insert,update,references
benchmarkscale	smallint(6)	(NULL)	NO		0		select,insert,update,references
benchmarkvisibility	varchar(100)	utf8_unicode_ci	NO		private		select,insert,update,references
benchmarktype	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
staffvisibilitycustom	smallint(6)	(NULL)	NO		0		select,insert,update,references
uservisibilitycustom	smallint(6)	(NULL)	NO		0		select,insert,update,references
iseditable	smallint(6)	(NULL)	NO		0		select,insert,update,references
isclientonly	smallint(6)	(NULL)	NO		0		select,insert,update,references
benchmarktitle	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swbenchmarks	0	PRIMARY	1	benchmarkid	A	1	(NULL)	(NULL)		BTREE
swbenchmarks	1	benchmarks1	1	benchmarktype	A	1	(NULL)	(NULL)		BTREE
swbenchmarks	1	benchmarks1	2	departmentid	A	1	(NULL)	(NULL)		BTREE
swbenchmarks	1	benchmarks2	1	departmentid	A	1	(NULL)	(NULL)		BTREE

Back

 

swbreaklines

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
breaklineid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
breakline	varchar(255)	utf8_unicode_ci	NO	MUL	0		select,insert,update,references
isregexp	smallint(6)	(NULL)	NO		0		select,insert,update,references
sortorder	int(11)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swbreaklines	0	PRIMARY	1	breaklineid	A	5	(NULL)	(NULL)		BTREE
swbreaklines	1	breaklines1	1	breakline	A	5	(NULL)	(NULL)		BTREE

Back

 

swcalls

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
callid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
phonenumber	varchar(255)	utf8_unicode_ci	NO	MUL			select,insert,update,references
callguid	varchar(255)	utf8_unicode_ci	NO	MUL			select,insert,update,references
userid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
userfullname	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
useremail	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
staffid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
stafffullname	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
chatobjectid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
departmentid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
dateline	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
enddateline	int(11)	(NULL)	NO		0		select,insert,update,references
lastactivity	int(11)	(NULL)	NO		0		select,insert,update,references
duration	int(11)	(NULL)	NO		0		select,insert,update,references
isclicktocall	smallint(6)	(NULL)	NO		0		select,insert,update,references
callstatus	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
calltype	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swcalls	0	PRIMARY	1	callid	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls1	1	phonenumber	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls1	2	userid	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls2	1	userid	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls3	1	staffid	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls4	1	dateline	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls5	1	callstatus	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls6	1	departmentid	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls7	1	chatobjectid	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls8	1	callguid	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls9	1	calltype	A	0	(NULL)	(NULL)		BTREE
swcalls	1	calls9	2	callstatus	A	0	(NULL)	(NULL)		BTREE

Back

 

swcannedcategories

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
cannedcategoryid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
parentcategoryid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
categorytype	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
staffid	int(11)	(NULL)	NO		0		select,insert,update,references
title	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swcannedcategories	0	PRIMARY	1	cannedcategoryid	A	0	(NULL)	(NULL)		BTREE
swcannedcategories	1	cannedcategories1	1	parentcategoryid	A	0	(NULL)	(NULL)		BTREE
swcannedcategories	1	cannedcategories2	1	categorytype	A	0	(NULL)	(NULL)		BTREE
swcannedcategories	1	cannedcategories2	2	staffid	A	0	(NULL)	(NULL)		BTREE

Back

 

swcannedresponsedata

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
cannedresponsedataid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
cannedresponseid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
contents	longtext	utf8_unicode_ci	YES		(NULL)		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swcannedresponsedata	0	PRIMARY	1	cannedresponsedataid	A	0	(NULL)	(NULL)		BTREE
swcannedresponsedata	1	cannedresponsedata1	1	cannedresponseid	A	0	(NULL)	(NULL)		BTREE

Back

 

swcannedresponses

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
cannedresponseid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
cannedcategoryid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
staffid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
title	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
urldata	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
imagedata	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
responsetype	smallint(6)	(NULL)	NO		0		select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swcannedresponses	0	PRIMARY	1	cannedresponseid	A	0	(NULL)	(NULL)		BTREE
swcannedresponses	1	cannedresponses1	1	cannedcategoryid	A	0	(NULL)	(NULL)		BTREE
swcannedresponses	1	cannedresponses2	1	staffid	A	0	(NULL)	(NULL)		BTREE

Back

 

swcatchallrules

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
catchallruleid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
title	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
ruleexpr	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
emailqueueid	int(11)	(NULL)	NO		0		select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references
sortorder	int(11)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swcatchallrules	0	PRIMARY	1	catchallruleid	A	0	(NULL)	(NULL)		BTREE

Back

 

swchatchilds

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chatchildid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
chatobjectid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
staffid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
isinvite	smallint(6)	(NULL)	NO		0		select,insert,update,references
isobserver	smallint(6)	(NULL)	NO		0		select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swchatchilds	0	PRIMARY	1	chatchildid	(NULL)	0	(NULL)	(NULL)		HASH
swchatchilds	1	chatchilds1	1	chatobjectid	(NULL)	(NULL)	(NULL)	(NULL)		HASH
swchatchilds	1	chatchilds1	2	staffid	(NULL)	0	(NULL)	(NULL)		HASH
swchatchilds	1	chatchilds2	1	staffid	(NULL)	0	(NULL)	(NULL)		HASH
swchatchilds	1	chatchilds3	1	chatobjectid	(NULL)	(NULL)	(NULL)	(NULL)		HASH
swchatchilds	1	chatchilds3	2	isinvite	(NULL)	0	(NULL)	(NULL)		HASH

Back

 

swchatdata

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chatdataid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
chatobjectid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
contents	longtext	utf8_unicode_ci	YES		(NULL)		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swchatdata	0	PRIMARY	1	chatdataid	A	0	(NULL)	(NULL)		BTREE
swchatdata	1	cobjid	1	chatobjectid	A	0	(NULL)	(NULL)		BTREE

Back

 

swchathits

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chathitid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
staffid	int(11)	(NULL)	NO		0		select,insert,update,references
chatobjectid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references
fullname	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
email	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
isaccepted	smallint(6)	(NULL)	NO		0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swchathits	0	PRIMARY	1	chathitid	A	0	(NULL)	(NULL)		BTREE
swchathits	1	chathits1	1	chatobjectid	A	0	(NULL)	(NULL)		BTREE
swchathits	1	chathits1	2	staffid	A	0	(NULL)	(NULL)		BTREE

Back

 

swchatobjects

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chatobjectid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
chatobjectmaskid	varchar(50)	utf8_unicode_ci	NO	MUL			select,insert,update,references
visitorsessionid	varchar(32)	utf8_unicode_ci	NO	MUL			select,insert,update,references
chatsessionid	varchar(32)	utf8_unicode_ci	NO				select,insert,update,references
dateline	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
lastpostactivity	int(11)	(NULL)	NO		0		select,insert,update,references
userpostactivity	int(11)	(NULL)	NO		0		select,insert,update,references
staffpostactivity	int(11)	(NULL)	NO		0		select,insert,update,references
userid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
userfullname	varchar(150)	utf8_unicode_ci	NO				select,insert,update,references
useremail	varchar(255)	utf8_unicode_ci	NO	MUL			select,insert,update,references
subject	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
staffid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
staffname	varchar(150)	utf8_unicode_ci	NO				select,insert,update,references
chatstatus	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
transferfromid	int(11)	(NULL)	NO		0		select,insert,update,references
transfertoid	int(11)	(NULL)	NO		0		select,insert,update,references
transferstatus	smallint(6)	(NULL)	NO		0		select,insert,update,references
transfertimeline	int(11)	(NULL)	NO		0		select,insert,update,references
roundrobintimeline	int(11)	(NULL)	NO		0		select,insert,update,references
roundrobinhits	int(11)	(NULL)	NO		0		select,insert,update,references
departmentid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
departmenttitle	varchar(100)	utf8_unicode_ci	NO				select,insert,update,references
chattype	smallint(6)	(NULL)	NO		0		select,insert,update,references
ipaddress	varchar(50)	utf8_unicode_ci	NO	MUL			select,insert,update,references
waittime	int(11)	(NULL)	NO		0		select,insert,update,references
chatskillid	int(11)	(NULL)	NO		0		select,insert,update,references
isproactive	smallint(6)	(NULL)	NO		0		select,insert,update,references
creatorstaffid	int(11)	(NULL)	NO		0		select,insert,update,references
tgroupid	int(11)	(NULL)	NO		0		select,insert,update,references
isphone	smallint(6)	(NULL)	NO		0		select,insert,update,references
phonenumber	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
callstatus	smallint(6)	(NULL)	NO		0		select,insert,update,references
isindexed	smallint(6)	(NULL)	NO	MUL	0		select,insert,update,references
hasgeoip	smallint(6)	(NULL)	NO		0		select,insert,update,references
geoiptimezone	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoipisp	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoiporganization	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoipnetspeed	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoipcountry	varchar(10)	utf8_unicode_ci	NO				select,insert,update,references
geoipcountrydesc	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoipregion	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoipcity	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoippostalcode	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoiplatitude	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoiplongitude	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoipmetrocode	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
geoipareacode	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swchatobjects	0	PRIMARY	1	chatobjectid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects1	1	chatstatus	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects1	2	staffid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects1	3	lastpostactivity	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects2	1	chatstatus	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects2	2	chattype	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects3	1	visitorsessionid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects4	1	staffid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects5	1	userid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects5	2	useremail	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects6	1	ipaddress	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects7	1	departmentid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects7	2	dateline	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects8	1	useremail	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects9	1	chatstatus	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects9	2	staffid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects9	3	dateline	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects10	1	chatstatus	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects10	2	chatobjectid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects10	3	staffid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects11	1	chatstatus	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects11	2	dateline	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects11	3	lastpostactivity	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects12	1	departmentid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects12	2	chatstatus	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects13	1	dateline	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects14	1	chatobjectmaskid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects15	1	chatstatus	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects15	2	staffid	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects15	3	isphone	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects16	1	isindexed	A	0	(NULL)	(NULL)		BTREE
swchatobjects	1	chatobjects16	2	chatstatus	A	0	(NULL)	(NULL)		BTREE

Back

 

swchatskilllinks

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chatskilllinkid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
chatskillid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
staffid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swchatskilllinks	0	PRIMARY	1	chatskilllinkid	A	3	(NULL)	(NULL)		BTREE
swchatskilllinks	1	chatskilllinks1	1	chatskillid	A	3	(NULL)	(NULL)		BTREE
swchatskilllinks	1	chatskilllinks2	1	staffid	A	3	(NULL)	(NULL)		BTREE

Back

 

swchatskills

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chatskillid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
dateline	int(11)	(NULL)	NO		0		select,insert,update,references
title	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references
description	varchar(255)	utf8_unicode_ci	NO				select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swchatskills	0	PRIMARY	1	chatskillid	A	3	(NULL)	(NULL)		BTREE

Back

 

swchattextdata

Fields

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
chattextdataid	int(11)	(NULL)	NO	PRI	(NULL)	auto_increment	select,insert,update,references
chatobjectid	int(11)	(NULL)	NO	MUL	0		select,insert,update,references
contents	longtext	utf8_unicode_ci	YES		(NULL)		select,insert,update,references

Indexes

Table	Non unique	Key name	Seq in index	Column name	Collation	Cardinality	Sub part	Packed	Null	Index type	Comment
swchattextdata	0	PRIMARY	1	chattextdataid	A	0	(NULL)	(NULL)		BTREE
swchattextdata	1	chattextdata1	1	chatobjectid	A	0	(NULL)	(NULL)		BTREE