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

(-)a/installer/data/mysql/atomicupdate/bug_30984.pl (-1 / +1 lines)
Lines 9-15 return { Link Here
9
        if( !column_exists( 'action_logs', 'script' ) ) {
9
        if( !column_exists( 'action_logs', 'script' ) ) {
10
            $dbh->do(q{
10
            $dbh->do(q{
11
                ALTER TABLE action_logs
11
                ALTER TABLE action_logs
12
                ADD COLUMN script mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the name of the cron script that caused this change'
12
                ADD COLUMN script tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the name of the cron script that caused this change'
13
                AFTER interface
13
                AFTER interface
14
            });
14
            });
15
        }
15
        }
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 175-181 CREATE TABLE `action_logs` ( Link Here
175
  `object` int(11) DEFAULT NULL COMMENT 'the object that the action was taken against (could be a borrowernumber, itemnumber, etc)',
175
  `object` int(11) DEFAULT NULL COMMENT 'the object that the action was taken against (could be a borrowernumber, itemnumber, etc)',
176
  `info` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'information about the action (usually includes SQL statement)',
176
  `info` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'information about the action (usually includes SQL statement)',
177
  `interface` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the context this action was taken in',
177
  `interface` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the context this action was taken in',
178
  `script` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the name of the cron script that caused this change',
178
  `script` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the name of the cron script that caused this change',
179
  PRIMARY KEY (`action_id`),
179
  PRIMARY KEY (`action_id`),
180
  KEY `timestamp_idx` (`timestamp`),
180
  KEY `timestamp_idx` (`timestamp`),
181
  KEY `user_idx` (`user`),
181
  KEY `user_idx` (`user`),
182
- 

Return to bug 30984