SQL data constraints.

[tyggerjai]

One of the fields in the db user table is set to only accept certain values. I need to add an acceptable value, preferably without dropping the entire table and rebuilding it. Any hints? There's probably an alter command....

Comments

[tyggerjai]

For people's future reference - "ALTER TABLE [tablename] MODIFY [column] [new column definition]".

There's an update-db and update-db-general script in bin/upgrading where you can add commands to the "register_alter" sub to alter an existing database, which will be run as part of $LJHOME/bin/upgrading/update-db.pl -r -p --inno

[kareila]

You may also find this useful: http://wiki.dwscoalition.org/notes/Adding_and_Removing_Database_Tables

[tyggerjai]

Thank you, yes! And in fact, had I read http://wiki.dwscoalition.org/notes/Beginning_dev_checklist more carefully, I might have noticed http://wiki.dwscoalition.org/notes/Dev_Finding_Things , and specifically http://wiki.dwscoalition.org/notes/Dev_Finding_Things#Managing_the_database_schema , which does mention the register_alter script I need.

[pauamma]

The more links to things, the easier they are to find. :-)