Lines 6270-6275
CREATE TABLE `ticket_updates` (
Link Here
|
6270 |
`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', |
6270 |
`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', |
6271 |
`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', |
6271 |
`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', |
6272 |
`message` text NOT NULL COMMENT 'update message content', |
6272 |
`message` text NOT NULL COMMENT 'update message content', |
|
|
6273 |
`status` varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update', |
6273 |
PRIMARY KEY (`id`), |
6274 |
PRIMARY KEY (`id`), |
6274 |
KEY `ticket_updates_ibfk_1` (`ticket_id`), |
6275 |
KEY `ticket_updates_ibfk_1` (`ticket_id`), |
6275 |
KEY `ticket_updates_ibfk_2` (`user_id`), |
6276 |
KEY `ticket_updates_ibfk_2` (`user_id`), |
6276 |
- |
|
|