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

(-)a/installer/data/mysql/atomicupdate/bug_21683_remove_column_accountno.perl (+11 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
4
    if( column_exists( 'accountlines', 'accountno' ) ) {
5
        $dbh->do( "ALTER TABLE accountlines DROP COLUMN accountno" );
6
    }
7
8
    # Always end with this (adjust the bug info)
9
    SetVersion( $DBversion );
10
    print "Upgrade to $DBversion done (Bug XXXXX - description)\n";
11
}
(-)a/installer/data/mysql/kohastructure.sql (-2 lines)
Lines 2673-2679 CREATE TABLE `accountlines` ( Link Here
2673
  `accountlines_id` int(11) NOT NULL AUTO_INCREMENT,
2673
  `accountlines_id` int(11) NOT NULL AUTO_INCREMENT,
2674
  `issue_id` int(11) NULL DEFAULT NULL,
2674
  `issue_id` int(11) NULL DEFAULT NULL,
2675
  `borrowernumber` int(11) DEFAULT NULL,
2675
  `borrowernumber` int(11) DEFAULT NULL,
2676
  `accountno` smallint(6) NOT NULL default 0,
2677
  `itemnumber` int(11) default NULL,
2676
  `itemnumber` int(11) default NULL,
2678
  `date` date default NULL,
2677
  `date` date default NULL,
2679
  `amount` decimal(28,6) default NULL,
2678
  `amount` decimal(28,6) default NULL,
2680
- 

Return to bug 21683