| 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
|
|
|
|
