diff options
| author | stuconnolly <stuart02@gmail.com> | 2009-11-18 22:20:25 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2009-11-18 22:20:25 +0000 |
| commit | a401277e6a7aff7ce778617d6c4de16f38e37fe5 (patch) | |
| tree | 21eae12c0397be0b143c51b366ed24e4b93cdaf7 /Source/SPTableRelations.m | |
| parent | bf4a5566109942b94919d06f8a0edcacf68ceeb0 (diff) | |
| download | sequelpro-a401277e6a7aff7ce778617d6c4de16f38e37fe5.tar.gz sequelpro-a401277e6a7aff7ce778617d6c4de16f38e37fe5.tar.bz2 sequelpro-a401277e6a7aff7ce778617d6c4de16f38e37fe5.zip | |
When attempting to delete a field that is part of a foreign key relationship, remove the key before the field to prevent an error. Obviously warn the user that the key is being dropped as well. Fixes issue #462.
This check also needs to be implemented when removing indexes as foreign keys depend on the presence of indexes to prevent table scans.
Something to be discussed, the display of foreign keys that are made up of multiple fields in the relations table and link arrows in the content table.
Diffstat (limited to 'Source/SPTableRelations.m')
| -rw-r--r-- | Source/SPTableRelations.m | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Source/SPTableRelations.m b/Source/SPTableRelations.m index d0ebb11b..29719f0b 100644 --- a/Source/SPTableRelations.m +++ b/Source/SPTableRelations.m @@ -455,7 +455,7 @@ { [relationData addObject:[NSDictionary dictionaryWithObjectsAndKeys: [constraint objectForKey:@"name"], @"name", - [constraint objectForKey:@"columns"], @"columns", + [[constraint objectForKey:@"columns"] objectAtIndex:0], @"columns", [constraint objectForKey:@"ref_table"], @"fk_table", [constraint objectForKey:@"ref_columns"], @"fk_columns", [constraint objectForKey:@"update"], @"on_update", |