Lines 5747-5753
CREATE TABLE `tags_index` (
Link Here
|
5747 |
DROP TABLE IF EXISTS `tickets`; |
5747 |
DROP TABLE IF EXISTS `tickets`; |
5748 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5748 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5749 |
/*!40101 SET character_set_client = utf8 */; |
5749 |
/*!40101 SET character_set_client = utf8 */; |
5750 |
CREATE TABLE IF NOT EXISTS `tickets` ( |
5750 |
CREATE TABLE `tickets` ( |
5751 |
`id` int(11) NOT NULL auto_increment COMMENT 'primary key', |
5751 |
`id` int(11) NOT NULL auto_increment COMMENT 'primary key', |
5752 |
`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', |
5752 |
`reporter_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the patron who reported the ticket', |
5753 |
`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', |
5753 |
`reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', |
Lines 5770-5776
CREATE TABLE IF NOT EXISTS `tickets` (
Link Here
|
5770 |
DROP TABLE IF EXISTS `ticket_updates`; |
5770 |
DROP TABLE IF EXISTS `ticket_updates`; |
5771 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5771 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
5772 |
/*!40101 SET character_set_client = utf8 */; |
5772 |
/*!40101 SET character_set_client = utf8 */; |
5773 |
CREATE TABLE IF NOT EXISTS `ticket_updates` ( |
5773 |
CREATE TABLE `ticket_updates` ( |
5774 |
`id` int(11) NOT NULL auto_increment COMMENT 'primary key', |
5774 |
`id` int(11) NOT NULL auto_increment COMMENT 'primary key', |
5775 |
`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', |
5775 |
`ticket_id` int(11) NOT NULL COMMENT 'id of catalog ticket the update relates to', |
5776 |
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update', |
5776 |
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id of the user who logged the update', |
5777 |
- |
|
|