Lines 6309-6314
CREATE TABLE `ticket_updates` (
Link Here
|
6309 |
`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', |
6309 |
`public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', |
6310 |
`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', |
6310 |
`date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', |
6311 |
`message` text NOT NULL COMMENT 'update message content', |
6311 |
`message` text NOT NULL COMMENT 'update message content', |
|
|
6312 |
`status` varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update', |
6312 |
PRIMARY KEY (`id`), |
6313 |
PRIMARY KEY (`id`), |
6313 |
KEY `ticket_updates_ibfk_1` (`ticket_id`), |
6314 |
KEY `ticket_updates_ibfk_1` (`ticket_id`), |
6314 |
KEY `ticket_updates_ibfk_2` (`user_id`), |
6315 |
KEY `ticket_updates_ibfk_2` (`user_id`), |
Lines 6331-6336
CREATE TABLE `tickets` (
Link Here
|
6331 |
`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', |
6332 |
`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', |
6332 |
`title` text NOT NULL COMMENT 'ticket title', |
6333 |
`title` text NOT NULL COMMENT 'ticket title', |
6333 |
`body` text NOT NULL COMMENT 'ticket details', |
6334 |
`body` text NOT NULL COMMENT 'ticket details', |
|
|
6335 |
`status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket', |
6334 |
`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', |
6336 |
`resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', |
6335 |
`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', |
6337 |
`resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', |
6336 |
`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', |
6338 |
`biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', |