View | Details | Raw Unified | Return to bug 31028
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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
- 

Return to bug 31028