diff options
| author | rowanbeentje <rowan@beent.je> | 2011-01-13 00:51:39 +0000 |
|---|---|---|
| committer | rowanbeentje <rowan@beent.je> | 2011-01-13 00:51:39 +0000 |
| commit | 15ad4cdf44427d5a9595a0d7a15257ed79eae8ae (patch) | |
| tree | 247e33de73bd9fb41291c3bea7cb1c08256be03f /Source/SPExtendedTableInfo.m | |
| parent | ff134517f81971fce5ee5636aab9d2051ffa7705 (diff) | |
| download | sequelpro-15ad4cdf44427d5a9595a0d7a15257ed79eae8ae.tar.gz sequelpro-15ad4cdf44427d5a9595a0d7a15257ed79eae8ae.tar.bz2 sequelpro-15ad4cdf44427d5a9595a0d7a15257ed79eae8ae.zip | |
- Add a new -engineTypeQueryName method to SPServerSupport, with a correct split between TYPE or ENGINE depending on database version.
- Update CREATE TABLE and ALERT TABLE queries to use this, fixing custom-type table creation on MySQL <4 and table type changes on MySQL >= 5.5. This addresses Issue #947.
Diffstat (limited to 'Source/SPExtendedTableInfo.m')
| -rw-r--r-- | Source/SPExtendedTableInfo.m | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Source/SPExtendedTableInfo.m b/Source/SPExtendedTableInfo.m index a765f6df..6f039659 100644 --- a/Source/SPExtendedTableInfo.m +++ b/Source/SPExtendedTableInfo.m @@ -98,7 +98,7 @@ } // Alter table's storage type - [connection queryString:[NSString stringWithFormat:@"ALTER TABLE %@ TYPE = %@", [selectedTable backtickQuotedString], newType]]; + [connection queryString:[NSString stringWithFormat:@"ALTER TABLE %@ %@ = %@", [selectedTable backtickQuotedString], [[tableDocumentInstance serverSupport] engineTypeQueryName], newType]]; if ([connection getLastErrorID] == 0) { // Reload the table's data |