[adminer-tracker] [ adminer-Bugs and Features-3388093 ] Alter table functionality is too deficient

[SourceForge.net <no...@so...>]

Bugs and Features item #3388093, was opened at 2011-08-08 01:43
Message generated for change (Comment added) made by jakubvrana
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3388093&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQLite
Group: 3.3.2
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: rom (gmtfn)
Assigned to: Jakub Vrána (jakubvrana)
Summary: Alter table functionality is too deficient

Initial Comment:
Someone has already reported this (ticket 3196479), and the ticket got dismissed because SQLite may not provide an easy way to implement this. I want to make a plea to have this implemented. Without being able to modify existing columns, this tool's usability is diminished greatly -- only superficial changes can be made with it.

Authors of other tools (e.g. SQLite Expert, SQLite Maestro) have been able to provide this feature. Would you as well, please? The value of your tool is that it allows us to modify our DBs online, but lack of certain features counteracts that. This feature would be very, very helpful. Please reconsider your decision!

----------------------------------------------------------------------

>Comment By: Jakub Vrána (jakubvrana)
Date: 2011-08-08 18:01

Message:
1. PRAGMA foreign_keys = OFF
2. CREATE TABLE _adminer with new columns and original+new foreign keys
3. INSERT INTO _adminer (original columns) SELECT * FROM old_name
4. Remember original indexes and triggers
5. DROP TABLE old_name
6. ALTER TABLE _adminer RENAME TO new_name
7. Recreate indexes and triggers stored in 4.


----------------------------------------------------------------------

Comment By: rom (gmtfn)
Date: 2011-08-08 02:02

Message:
phpliteadmin is able to list existing columns, which is useful but also
deficient. We need to be able to modify our DBs online as we can with
standalone tools.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3388093&group_id=264133