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 2708-2714
          CREATE TABLE `accountlines` (
      
      
        Link Here
      
    
  

        

          2708
          
  `accountlines_id` int(11) NOT NULL AUTO_INCREMENT,

          2708
          
  `accountlines_id` int(11) NOT NULL AUTO_INCREMENT,

        

        

          2709
          
  `issue_id` int(11) NULL DEFAULT NULL,

          2709
          
  `issue_id` int(11) NULL DEFAULT NULL,

        

        

          2710
          
  `borrowernumber` int(11) DEFAULT NULL,

          2710
          
  `borrowernumber` int(11) DEFAULT NULL,

        

            

              2711
              
  `accountno` smallint(6) NOT NULL default 0,

              
              
            

        

          2712
          
  `itemnumber` int(11) default NULL,

          2711
          
  `itemnumber` int(11) default NULL,

        

        

          2713
          
  `date` date default NULL,

          2712
          
  `date` date default NULL,

        

        

          2714
          
  `amount` decimal(28,6) default NULL,

          2713
          
  `amount` decimal(28,6) default NULL,

        

            

              2715
              
- 

              
              
            






  

  Return to bug 21683