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

(-)a/installer/data/mysql/atomicupdate/bug_17845.perl (+13 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "DROP TABLE IF EXISTS printers" );
4
5
    if( !column_exists( 'branches', 'branchprinter' ) ) {
6
      $dbh->do( "ALTER TABLE branches DROP COLUMN branchprinter" );
7
    }
8
    
9
    $dbh->do(qq{ DELETE FROM systempreferences WHERE variable = "printcirculationslips"} );
10
11
    SetVersion( $DBversion );
12
    print "Upgrade to $DBversion done (Bug 17845 - Drop unused table printers and branchprinter column)\n";
13
}
(-)a/installer/data/mysql/atomicupdate/bug_17845_remove_printers (-5 lines)
Lines 1-4 Link Here
1
DROP TABLE IF EXISTS printers;
2
ALTER TABLE branches DROP COLUMN branchprinter;
3
DELETE FROM systempreferences WHERE variable = "printcirculationslips";
4
-- Bug 17845: Drop unused table printers and branchprinter column
5
- 

Return to bug 17845