diff options
author | mark <mark> | 2011-03-29 01:04:31 +0000 |
---|---|---|
committer | mark <mark> | 2011-03-29 01:04:31 +0000 |
commit | f40cdebc5e55cb0a209f7fd3e8c3858402c71f9f (patch) | |
tree | 3d8d534ba1e40c3e01f15bffdf113c4d3f3ad710 /FS/bin/freeside-upgrade | |
parent | 07c89b3d2c2b306ed04f1e12306e74fd7381d004 (diff) |
primary key for areacode table
Diffstat (limited to 'FS/bin/freeside-upgrade')
-rwxr-xr-x | FS/bin/freeside-upgrade | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade index aca545b84..e11a0a7fe 100755 --- a/FS/bin/freeside-upgrade +++ b/FS/bin/freeside-upgrade @@ -71,6 +71,19 @@ if ( dbdef->table('cgp_rule_condition') && } +if ( dbdef->table('areacode') and + dbdef->table('areacode')->primary_key eq 'code' ) +{ + if ( driver_name =~ /^mysql/i ) { + push @bugfix, + 'ALTER TABLE areacode DROP PRIMARY KEY', + 'ALTER TABLE areacode ADD COLUMN (areanum int auto_increment primary key)'; + } + else { + push @bugfix, 'ALTER TABLE areacode DROP CONSTRAINT areacode_pkey'; + } +} + # RT required field flag # for consistency with RT schema: mysql is in CamelCase, # pg is in lowercase, and they use different data types. |