Server maintenence

Backup and restore

TS has inbuilt manual functions on the solution level, but measures have to taken to back the data IN the solutions.

Table naming conventions

Every solution has its own table namespace of "data_" followed by the system solution name.

Example for the solution named XXX:

• data_XXX

Other related tables include

• data_XXX_file
• data_XXX_mail
• data_XXX_comment
• data_XXX_contact
• data_XXX_measure
• data_XXX_member
• data_XXX_t_YYY
• data_XXX_accesslog
• data_XXX_statuslog
• data_XXX_revisionlog

Deleted tables are prefixed by a timestamp