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

(-)a/installer/data/mysql/atomicupdate/bug15685.perl (-1 / +1 lines)
Lines 4-10 if( CheckVersion( $DBversion ) ) { Link Here
4 
    unless( column_exists('aqbasket','create_items') ){
 4 
    unless( column_exists('aqbasket','create_items') ){
5 
        $dbh->do(q{
 5 
        $dbh->do(q{
6 
            ALTER TABLE aqbasket
 6 
            ALTER TABLE aqbasket
7 
                ADD COLUMN create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL
 7 
                ADD COLUMN create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL AFTER is_standing
8 
        });
 8 
        });
9 
    }
 9 
    }
10 

          10
          

        



(-)a/installer/data/mysql/kohastructure.sql
      (-2 / +1 lines)




  

    
      
            Lines 2992-3000
          CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions
      
      
        Link Here
      
    
  

        

          2992
          
  `basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id)

          2992
          
  `basketgroupid` int(11), -- links this basket to its group (aqbasketgroups.id)

        

        

          2993
          
  `deliveryplace` varchar(10) default NULL, -- basket delivery place

          2993
          
  `deliveryplace` varchar(10) default NULL, -- basket delivery place

        

        

          2994
          
  `billingplace` varchar(10) default NULL, -- basket billing place

          2994
          
  `billingplace` varchar(10) default NULL, -- basket billing place

        

            

              2995
              
  create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL, -- when items should be created for orders in this basket

              
              
            

        

          2996
          
  branch varchar(10) default NULL, -- basket branch

          2995
          
  branch varchar(10) default NULL, -- basket branch

        

        

          2997
          
  is_standing TINYINT(1) NOT NULL DEFAULT 0, -- orders in this basket are standing

          2996
          
  is_standing TINYINT(1) NOT NULL DEFAULT 0, -- orders in this basket are standing

        

            

              
              
              2997
              
  create_items ENUM('ordering', 'receiving', 'cataloguing') default NULL, -- when items should be created for orders in this basket

            

        

          2998
          
  PRIMARY KEY  (`basketno`),

          2998
          
  PRIMARY KEY  (`basketno`),

        

        

          2999
          
  KEY `booksellerid` (`booksellerid`),

          2999
          
  KEY `booksellerid` (`booksellerid`),

        

        

          3000
          
  KEY `basketgroupid` (`basketgroupid`),

          3000
          
  KEY `basketgroupid` (`basketgroupid`),

        

            

              3001
              
- 

              
              
            






  

  Return to bug 15685