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

(-)a/Koha/Schema/Result/Statistic.pm (+10 lines)
Lines 108-113 foreign key from the items table, links transaction to a specific collection cod Link Here
108
108
109
foreign key from the borrowers table, links transaction to a specific borrower category
109
foreign key from the borrowers table, links transaction to a specific borrower category
110
110
111
=head2 interface
112
113
  data_type: 'varchar'
114
  is_nullable: 1
115
  size: 30
116
117
interface acted upon
118
111
=cut
119
=cut
112
120
113
__PACKAGE__->add_columns(
121
__PACKAGE__->add_columns(
Lines 137-142 __PACKAGE__->add_columns( Link Here
137
  { data_type => "varchar", is_nullable => 1, size => 80 },
145
  { data_type => "varchar", is_nullable => 1, size => 80 },
138
  "categorycode",
146
  "categorycode",
139
  { data_type => "varchar", is_nullable => 1, size => 10 },
147
  { data_type => "varchar", is_nullable => 1, size => 10 },
148
  "interface",
149
  { data_type => "varchar", is_nullable => 1, size => 30 },
140
);
150
);
141
151
142
152
(-)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