diff options
author | Ivan Kohler <ivan@freeside.biz> | 2014-05-30 14:04:10 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2014-05-30 14:04:10 -0700 |
commit | 704df08c7f81c0ac0e828362f0b1304225757374 (patch) | |
tree | 63a4c1505524f5bdf4ec46c4b7e592c0be8878de /FS/bin | |
parent | 92f4d4407513140d5c78a689f340e5f4c1ffcbe5 (diff) |
MySQL support, RT#28895
Diffstat (limited to 'FS/bin')
-rwxr-xr-x | FS/bin/freeside-upgrade | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade index c3d070eec..e74abbfd0 100755 --- a/FS/bin/freeside-upgrade +++ b/FS/bin/freeside-upgrade @@ -94,10 +94,18 @@ if ( dbdef->table('areacode') and } if ( dbdef->table('upgrade_journal') ) { - push @bugfix, "SELECT SETVAL( 'upgrade_journal_upgradenum_seq', - ( SELECT MAX(upgradenum) FROM upgrade_journal ) - ) - "; + if ( driver_name =~ /^Pg/i ) { + push @bugfix, " + SELECT SETVAL( 'upgrade_journal_upgradenum_seq', + ( SELECT MAX(upgradenum) FROM upgrade_journal ) + ) + "; + } elsif ( driver_name =~ /^mysql/i ) { + push @bugfix, " + ALTER TABLE upgrade_journal AUTO_INCREMENT = + ( ( SELECT MAX(upgradenum) FROM upgrade_journal ) + 1 ) + "; + } } if ( $DRY_RUN ) { |