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

(-)a/installer/data/mysql/db_revs/241200018.pl (-1 / +1 lines)
Lines 22-28 return { Link Here
22
            );
22
            );
23
            $dbh->do(q{ UPDATE additional_field_values SET new_record_id = CAST(record_id AS CHAR(11)); });
23
            $dbh->do(q{ UPDATE additional_field_values SET new_record_id = CAST(record_id AS CHAR(11)); });
24
            $dbh->do(q{ ALTER TABLE additional_field_values DROP COLUMN record_id; });
24
            $dbh->do(q{ ALTER TABLE additional_field_values DROP COLUMN record_id; });
25
            $dbh->do(q{ ALTER TABLE additional_field_values RENAME COLUMN new_record_id TO record_id; });
25
            $dbh->do(q{ ALTER TABLE additional_field_values CHANGE COLUMN new_record_id record_id VARCHAR(11); });
26
26
27
            say_success( $out, "Converted record_id to VARCHAR" );
27
            say_success( $out, "Converted record_id to VARCHAR" );
28
        } else {
28
        } else {
(-)a/installer/data/mysql/db_revs/241200042.pl (-1 / +1 lines)
Lines 12-18 return { Link Here
12
            if ( column_exists( 'aqbookseller_aliases', 'alias_id' ) ) {
12
            if ( column_exists( 'aqbookseller_aliases', 'alias_id' ) ) {
13
                $dbh->do(
13
                $dbh->do(
14
                    q{
14
                    q{
15
                        ALTER TABLE aqbookseller_aliases RENAME COLUMN alias_id TO vendor_alias_id;
15
                        ALTER TABLE aqbookseller_aliases CHANGE COLUMN alias_id vendor_alias_id INT(11);
16
                    }
16
                    }
17
                );
17
                );
18
                say_success(
18
                say_success(
(-)a/installer/data/mysql/db_revs/241200043.pl (-2 / +1 lines)
Lines 12-18 return { Link Here
12
            if ( column_exists( 'aqbookseller_interfaces', 'interface_id' ) ) {
12
            if ( column_exists( 'aqbookseller_interfaces', 'interface_id' ) ) {
13
                $dbh->do(
13
                $dbh->do(
14
                    q{
14
                    q{
15
                        ALTER TABLE aqbookseller_interfaces RENAME COLUMN interface_id TO vendor_interface_id;
15
                        ALTER TABLE aqbookseller_interfaces CHANGE COLUMN interface_id vendor_interface_id INT(11);
16
                    }
16
                    }
17
                );
17
                );
18
                say_success(
18
                say_success(
19
- 

Return to bug 40292