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