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