Lines 6287-6292
DROP TABLE IF EXISTS `tickets`;
Link Here
|
6287 |
/*!40101 SET character_set_client = utf8 */; |
6287 |
/*!40101 SET character_set_client = utf8 */; |
6288 |
CREATE TABLE `tickets` ( |
6288 |
CREATE TABLE `tickets` ( |
6289 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
6289 |
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key', |
|
|
6290 |
`source` enum('catalog') NOT NULL DEFAULT 'catalog' COMMENT 'source of ticket', |
6290 |
`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', |
6291 |
`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', |
6291 |
`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', |
6292 |
`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', |
6292 |
`title` text NOT NULL COMMENT 'ticket title', |
6293 |
`title` text NOT NULL COMMENT 'ticket title', |
6293 |
- |
|
|