aboutsummaryrefslogtreecommitdiffstats
path: root/Source/SPIndexesController.m
Commit message (Collapse)AuthorAgeFilesLines
* Bring outline view branch up to date with trunk (r3203:r3224).stuconnolly2011-03-071-0/+4
|
* - Fix errors creating indexes, addressing Issue #946rowanbeentje2011-01-111-8/+8
| | | | | | - Move index type query part before the column list to fix advanced use errors - Correct spelling of -_removeIndexUsingDetails:
* - Rework the Add Index indexes menu and the auto_increment index required ↵rowanbeentje2011-01-041-14/+43
| | | | | | | | | | | | | menu to use tag-based values when generating queries, allowing localisation of menu contents without using those localised values in queries. This addresses I$ - Remove the ability to specify a FULLTEXT auto_increment index, as I believe this isn't possible. - Prevent sheet reuse from specifying invalid storage types for PRIMARY KEYs - Fix exceptions when adding indexes to a table where every field is already indexed - Fix initialField/indexedFieldNames check to improve on r3061 - Fix toggling advanced index view after closing the sheet with the view open - Update localisable strings
* • fixed by mistake setting of initialField to nil instead of ↵Bibiko2011-01-031-1/+1
| | | | | | initialFiledNames if initialField is not nil - this should fix i933
* Protect against potentially over-releasing.stuconnolly2010-12-281-1/+1
|
* When opening the add index sheet, the initial suggested field should be one ↵stuconnolly2010-12-271-1/+23
| | | | that is not already indexed. This completes the implementation of issue #928.
* When adding a new index, exclude fields that have already been added from ↵stuconnolly2010-12-261-2/+6
| | | | the drop down list. Part of issue #928.
* When adding a new index, as well as checking for an existing primary key ↵stuconnolly2010-12-251-4/+18
| | | | also check for a composite primary key. Part of issue #928.
* Add a new category to SPDatabaseDocument, allowing code cleanup and moving ↵rowanbeentje2010-11-031-2/+2
| | | | | | | | | | | central functionality out of SPTablesList: - Centralise control over table loading, moving it away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Centralise control over the main tab view, moving control away from SPTablesList and into SPDatabaseDocument and the new SPDatabaseViewController category - Simplify and clean up view loading logic - Improve thread safety - Update localisable strings
* Update indexes controller constants.stuconnolly2010-10-191-5/+5
|
* Considering nearly every class uses constants, import it via the prefix header.stuconnolly2010-10-191-1/+0
|
* Fix a bug when adding a PRIMARY KEY index, introduced in r2742. Fixes issue ↵stuconnolly2010-10-121-2/+2
| | | | #863.
* Add support for adding SPATIAL indexes on MyISAM tables. Also, update ↵stuconnolly2010-10-081-6/+18
| | | | Localizable.strings.
* Various improvements to server capability/version checking, including:stuconnolly2010-10-071-1/+2
| | | | | | | | | | | | | - Add a new ServerSupport class, for which an instance is created upon each new connection and is then subsequently accessible via SPDatabaseDocument. - Replace the majority of manual version checking with calls to properties in the above new class. - Improve the user manager's compatibility with MySQL 3 and 4 servers. Fixes issue #811 Other changes include: - Disable the encoding popup button when adding a new table or database to servers running pre MySQL 4.1 as it only contains one option, 'Default'. - Fix various potential memory leaks discovered during static analysis. - General tidy up and comments.
* Add support in the new index sheet for specifying an index's key block size ↵stuconnolly2010-09-221-8/+29
| | | | (in the advanced view) which was added in MySQL 5.1.10.
* • fixed in [_addIndexUsingDetails:]: do not release supportsLength and ↵Bibiko2010-09-201-187/+208
| | | | | | | | | | | requiresLength since they are still in use • fixed: if new field was added store the the underlying NSDictionary not only the field name • fixed in [addIndex:]: init indexedFields with a mutable copy - this fixes all issue for "mutating method sent to immutable object" of SPIndexController like i1609 • fixed "Add" Button validation • fixed display of "Size" column validation • code cosmetics
* Add index sheet:stuconnolly2010-09-181-7/+7
| | | | | | | | - Fix an exception caused when cancelling adding an index with the advanced options view open. - Move 'Cancel and 'Add' buttons to be inline with index type and name controls. Both found/suggested by Rowan.
* - When opening the add new sheet, ensure that the remove button is disabled ↵stuconnolly2010-09-171-0/+10
| | | | | | | when there is only one indexed field. - When cancelling adding a new index reset the indexed columns.
* - Fix a UI validation bug when adding an additional indexed field with a ↵stuconnolly2010-09-171-2/+4
| | | | | | | | | length specified and the advanced view open. - Fix an exception when adding the same indexed field when creating a new index. Both found by Max. Thanks Max!
* New add index sheet, which includes:stuconnolly2010-09-171-143/+445
| | | | | | | | | - The ability to easily index multiple columns - The ability to specify the storage type (HASH or BTREE) that should be used when available and permitted - The ability to specify a length prefix when indexing a specific column (required on TEXT columns) Requires lots of testing.
* • TableStructureBibiko2010-09-091-103/+103
| | | | | | | - changed: field information are retrieved via [SPTableData columns]; mainly to get all infos like comment, encoding, and collation - added the chance to edit encoding, collation, and comment for each field Note: This is work is progress - not yet optimized but fully workable. Due to GUI I simply added these three columns - improvements will follow
* Remove an attempt to obtain a bool value from a var that is already one ↵stuconnolly2010-09-011-1/+1
| | | | resulting in a crash when attempting to remove an index. Fixes log: http://spbug.com/l/1007.
* Fix various potential memory leaks and general warnings as a result of ↵stuconnolly2010-08-191-1/+0
| | | | static analysis.
* Fix call to showErrorSheetWith: which should be made against ↵stuconnolly2010-06-251-2/+2
| | | | SPTableStructure. Fixes logs http://spbug.com/875, http://spbug.com/876 and http://spbug.com/910.
* Revert a change made in r2320 that required an explicit name when adding new ↵stuconnolly2010-06-151-26/+6
| | | | index.
* • several fixes for index table in Structure viewBibiko2010-06-151-0/+18
| | | | | | | - fixed binding for removeIndexButton - moved indexTable's tableViewSelectionDidChange: delegate to SPIndexController to fix enabling/disabling of the removeIndexButton - fixed issue to blank the index table for multiple selected tables
* Split the management of a table's indexes (adding and removing) to its own ↵stuconnolly2010-06-141-0/+524
controller and XIB in preparation for the UI redesign.