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 CHANGE COLUMN new_record_id record_id VARCHAR(11); }); |
25 |
$dbh->do( |
|
|
26 |
q{ ALTER TABLE additional_field_values CHANGE COLUMN new_record_id record_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT 'record_id'; } |
27 |
); |
26 |
|
28 |
|
27 |
say_success( $out, "Converted record_id to VARCHAR" ); |
29 |
say_success( $out, "Converted record_id to VARCHAR" ); |
28 |
} else { |
30 |
} else { |