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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1850-1856 CREATE TABLE `statistics` ( -- information related to transactions (circulation Link Here
1850
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
1850
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
1851
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1851
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1852
  `associatedborrower` int(11) default NULL,
1852
  `associatedborrower` int(11) default NULL,
1853
  `ccode` int(11) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1853
  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1854
  KEY `timeidx` (`datetime`)
1854
  KEY `timeidx` (`datetime`)
1855
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1855
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1856
1856
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 6062-6067 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
6062
   SetVersion ($DBversion);
6062
   SetVersion ($DBversion);
6063
}
6063
}
6064
6064
6065
$DBversion = "3.09.00.XXX";
6066
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
6067
   $dbh->do("ALTER TABLE statistics CHANGE COLUMN ccode ccode varchar(10) NULL");
6068
   print "Upgrade to $DBversion done (Bug 9064: statistics.ccode potentially wrongly defined)\n";
6069
   SetVersion ($DBversion);
6070
}
6071
6065
6072
6066
=head1 FUNCTIONS
6073
=head1 FUNCTIONS
6067
6074
6068
- 

Return to bug 9064