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

(-)a/installer/data/mysql/atomicupdate/bug_39062_increase_stocknumber_length.pl (-3 / +6 lines)
Lines 9-16 return { Link Here
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
10
11
        # Do you stuffs here
11
        # Do you stuffs here
12
        $dbh->do(q{ALTER TABLE items MODIFY COLUMN stocknumber varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)'});
12
        $dbh->do(
13
        $dbh->do(q{ALTER TABLE deleteditems MODIFY COLUMN stocknumber varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)'});
13
            q{ALTER TABLE items MODIFY COLUMN stocknumber varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)'}
14
        );
15
        $dbh->do(
16
            q{ALTER TABLE deleteditems MODIFY COLUMN stocknumber varchar(80) DEFAULT NULL COMMENT 'inventory number (MARC21 952$i)'}
17
        );
14
18
15
        # Print useful stuff here
19
        # Print useful stuff here
16
        # tables
20
        # tables
17
- 

Return to bug 39062