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