NAMING
It is strongly recommended to use only lower case for all tables and fields. In addition, no space are allowed, use underscore to separate words.
The API will make columns and table accessible to you via the CamelCase version.
AUTO CREATION OF FIELDS
All tables will have a timestamp automatically created and set on create and update. To avoid it, use the TableStamp behavior.
RESERVED NAMES
Some tables and columns are automatically created at compile time.
Tables names
- config
- authy, authy_log, authy_group and authy_group_x
- message and message_i18n
if compiled with API
- api_log
- api_rbac
- template and template_file
Columns names
- date_creation
- date_modification
- id_group_creation
- id_creation
- id_modification
Authy table specific column name
- is_root
- id_authy_group
- expire
- deactivate
- is_system
- rights_all
- rights_group
- rights_owner
REMOVING COLUMNS
Unfortunately, removing columns from the schema will result in an error when restoring the last dump. Be aware an plan accordingly.