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

(-)a/installer/data/mysql/atomicupdate/bug_25159.pl (+13 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "251159",
5
    description => "Add action logs should be stored in JSON ( and as a diff of the change )",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
10
        $dbh->do(q{ALTER TABLE action_logs ADD COLUMN diff LONGTEXT NULL DEFAULT NULL AFTER trace;});
11
        say $out "Added column 'action_logs.diff'";
12
    },
13
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 173-178 CREATE TABLE `action_logs` ( Link Here
173
  `interface` varchar(30) DEFAULT NULL COMMENT 'the context this action was taken in',
173
  `interface` varchar(30) DEFAULT NULL COMMENT 'the context this action was taken in',
174
  `script` varchar(255) DEFAULT NULL COMMENT 'the name of the cron script that caused this change',
174
  `script` varchar(255) DEFAULT NULL COMMENT 'the name of the cron script that caused this change',
175
  `trace` text DEFAULT NULL COMMENT 'An optional stack trace enabled by ActionLogsTraceDepth',
175
  `trace` text DEFAULT NULL COMMENT 'An optional stack trace enabled by ActionLogsTraceDepth',
176
  `diff` LONGTEXT NULL DEFAULT NULL COMMENT 'Stores a diff of the changed object',
176
  PRIMARY KEY (`action_id`),
177
  PRIMARY KEY (`action_id`),
177
  KEY `timestamp_idx` (`timestamp`),
178
  KEY `timestamp_idx` (`timestamp`),
178
  KEY `user_idx` (`user`),
179
  KEY `user_idx` (`user`),
179
- 

Return to bug 25159