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

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

Return to bug 31028