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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 1799-1805 CREATE TABLE `serial` ( Link Here
1799
  `planneddate` date default NULL,
1799
  `planneddate` date default NULL,
1800
  `notes` text,
1800
  `notes` text,
1801
  `publisheddate` date default NULL,
1801
  `publisheddate` date default NULL,
1802
  `itemnumber` text default NULL,
1803
  `claimdate` date default NULL,
1802
  `claimdate` date default NULL,
1804
  `routingnotes` text,
1803
  `routingnotes` text,
1805
  PRIMARY KEY  (`serialid`)
1804
  PRIMARY KEY  (`serialid`)
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 6399-6404 if ( CheckVersion($DBversion) ) { Link Here
6399
    SetVersion($DBversion);
6399
    SetVersion($DBversion);
6400
}
6400
}
6401
6401
6402
$DBversion ="3.11.00.XXX";
6403
if ( CheckVersion($DBversion) ) {
6404
    $dbh->do("ALTER TABLE serial DROP itemnumber");
6405
    print "Upgrade to $DBversion done (Add IDreamBooks enhanced content)\n";
6406
    SetVersion($DBversion);
6407
}
6408
6402
6409
6403
=head1 FUNCTIONS
6410
=head1 FUNCTIONS
6404
6411
6405
- 

Return to bug 7718