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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 1900-1906 CREATE TABLE `serial` ( Link Here
1900
  `planneddate` date default NULL,
1900
  `planneddate` date default NULL,
1901
  `notes` text,
1901
  `notes` text,
1902
  `publisheddate` date default NULL,
1902
  `publisheddate` date default NULL,
1903
  `itemnumber` text default NULL,
1904
  `claimdate` date default NULL,
1903
  `claimdate` date default NULL,
1905
  `routingnotes` text,
1904
  `routingnotes` text,
1906
  PRIMARY KEY  (`serialid`)
1905
  PRIMARY KEY  (`serialid`)
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 6935-6940 INSERT INTO permissions (module_bit, code, description) VALUES Link Here
6935
    SetVersion($DBversion);
6935
    SetVersion($DBversion);
6936
}
6936
}
6937
6937
6938
$DBversion ="3.13.00.XXX";
6939
if ( CheckVersion($DBversion) ) {
6940
    $dbh->do("ALTER TABLE serial DROP itemnumber");
6941
    print "Upgrade to $DBversion done (Bug 7718 - Remove itemnumber column from serials table)\n";
6942
    SetVersion($DBversion);
6943
}
6944
6938
=head1 FUNCTIONS
6945
=head1 FUNCTIONS
6939
6946
6940
=head2 TableExists($table)
6947
=head2 TableExists($table)
6941
- 

Return to bug 7718