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

(-)a/installer/data/mysql/atomicupdate/bug_30928.pl (+18 lines)
Line 0 Link Here
1
use Modern::Perl;
2
return {
3
    bug_number => "30928",
4
    description => "Add interface field to statistics table",
5
    up => sub {
6
        my ($args) = @_;
7
        my ($dbh, $out) = @$args{qw(dbh out)};
8
        if( !column_exists( 'statistics', 'interface' ) ) {
9
            $dbh->do(q{
10
                ALTER TABLE statistics
11
                ADD COLUMN interface varchar(30) NULL DEFAULT NULL
12
                COMMENT "interface"
13
                AFTER categorycode
14
            });
15
            say $out "Added column 'statistics.interface'";
16
        }
17
    },
18
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 5360-5365 CREATE TABLE `statistics` ( Link Here
5360
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower',
5360
  `borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower',
5361
  `ccode` varchar(80) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code',
5361
  `ccode` varchar(80) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code',
5362
  `categorycode` varchar(10) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category',
5362
  `categorycode` varchar(10) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category',
5363
  `interface` varchar(30) DEFAULT NULL COMMENT 'the context this action was taken in',
5363
  KEY `timeidx` (`datetime`),
5364
  KEY `timeidx` (`datetime`),
5364
  KEY `branch_idx` (`branch`),
5365
  KEY `branch_idx` (`branch`),
5365
  KEY `type_idx` (`type`),
5366
  KEY `type_idx` (`type`),
5366
- 

Return to bug 30928