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

(-)a/installer/data/mysql/db_revs/250600011.pl (+5 lines)
Lines 47-52 return { Link Here
47
            );
47
            );
48
        }
48
        }
49
49
50
        unless ( index_exists( 'statistics', 'illrequest_idx' ) ) {
51
            $dbh->do(q{ALTER TABLE `statistics` ADD INDEX `illrequest_idx` (`illrequest_id`)});
52
53
        }
54
50
        my $reports = join(
55
        my $reports = join(
51
            "\n",
56
            "\n",
52
            map( "\tReport ID: "
57
            map( "\tReport ID: "
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 6124-6134 CREATE TABLE `statistics` ( Link Here
6124
  KEY `timeidx` (`datetime`),
6124
  KEY `timeidx` (`datetime`),
6125
  KEY `branch_idx` (`branch`),
6125
  KEY `branch_idx` (`branch`),
6126
  KEY `type_idx` (`type`),
6126
  KEY `type_idx` (`type`),
6127
  KEY `illrequest_idx` (`illrequest_id`),
6128
  KEY `itemnumber_idx` (`itemnumber`),
6127
  KEY `itemnumber_idx` (`itemnumber`),
6129
  KEY `itemtype_idx` (`itemtype`),
6128
  KEY `itemtype_idx` (`itemtype`),
6130
  KEY `borrowernumber_idx` (`borrowernumber`),
6129
  KEY `borrowernumber_idx` (`borrowernumber`),
6131
  KEY `ccode_idx` (`ccode`)
6130
  KEY `ccode_idx` (`ccode`),
6131
  KEY `illrequest_idx` (`illrequest_id`)
6132
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6132
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6133
/*!40101 SET character_set_client = @saved_cs_client */;
6133
/*!40101 SET character_set_client = @saved_cs_client */;
6134
6134
6135
- 

Return to bug 36033