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 { |