id |
mediumint(8)
|
|
|
|
trackid |
varchar(13)
|
utf8_unicode_ci
|
|
|
name |
varchar(255)
|
utf8_unicode_ci
|
|
|
email |
varchar(1000)
|
utf8_unicode_ci
|
|
|
category |
smallint(5)
|
|
|
|
priority |
enum('0', '1', '2', '3')
|
utf8_unicode_ci
|
|
|
subject |
varchar(255)
|
utf8_unicode_ci
|
|
|
message |
mediumtext
|
utf8_unicode_ci
|
|
|
message_html |
mediumtext
|
utf8_unicode_ci
|
|
|
dt |
timestamp
|
|
|
|
lastchange |
timestamp
|
|
|
|
firstreply |
timestamp
|
|
|
|
closedat |
timestamp
|
|
|
|
articles |
varchar(255)
|
utf8_unicode_ci
|
|
|
ip |
varchar(45)
|
utf8_unicode_ci
|
|
|
language |
varchar(50)
|
utf8_unicode_ci
|
|
|
status |
tinyint(3)
|
|
|
|
openedby |
mediumint(8)
|
|
|
|
firstreplyby |
smallint(5)
|
|
|
|
closedby |
mediumint(8)
|
|
|
|
replies |
smallint(5)
|
|
|
|
staffreplies |
smallint(5)
|
|
|
|
owner |
smallint(5)
|
|
|
|
assignedby |
mediumint(8)
|
|
|
|
time_worked |
time
|
|
|
|
lastreplier |
enum('0', '1')
|
utf8_unicode_ci
|
|
|
replierid |
smallint(5)
|
|
|
|
archive |
enum('0', '1')
|
utf8_unicode_ci
|
|
|
locked |
enum('0', '1')
|
utf8_unicode_ci
|
|
|
attachments |
mediumtext
|
utf8_unicode_ci
|
|
|
merged |
mediumtext
|
utf8_unicode_ci
|
|
|
history |
mediumtext
|
utf8_unicode_ci
|
|
|
custom1 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom2 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom3 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom4 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom5 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom6 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom7 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom8 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom9 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom10 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom11 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom12 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom13 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom14 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom15 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom16 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom17 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom18 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom19 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom20 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom21 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom22 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom23 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom24 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom25 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom26 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom27 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom28 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom29 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom30 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom31 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom32 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom33 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom34 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom35 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom36 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom37 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom38 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom39 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom40 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom41 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom42 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom43 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom44 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom45 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom46 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom47 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom48 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom49 |
mediumtext
|
utf8_unicode_ci
|
|
|
custom50 |
mediumtext
|
utf8_unicode_ci
|
|
|
due_date |
timestamp
|
|
|
|
overdue_email_sent |
tinyint(1)
|
|
|
|
satisfaction_email_sent |
tinyint(1)
|
|
|
|
satisfaction_email_dt |
timestamp
|
|
|
|