Kexi/Plugins/Tables/Simple alter table

Design page for task: Simple approach to fulfill "Add support for alter table's design without losing data" wish.

• Started: Jstaniek (talk) August 2012
• Wish #125253
• Target: 2.6.0

Rationale

Approach when modification to table schema is saved directly after user performed it is much easier than full alter table tired in Kexi 1.x and never delivered.

Analysis

• Altering some physical properties would require immediate saving of the design but will not remove all the data.
• Other properties (for which KexiDB::isExtendedTableFieldProperty() return true) can be modified without altering any data.

Alter actions

This section publishes details on particular actions of table altering.

Caption rename

• triggers name change in propeditor, so:
  • if name changed, go to Name change section
  • else, do nothing, caption should be saved on Save action

Requirements

• Full data safety
  • It's better to warn and request data removal than claiming it is not necessary and then doing that