After creating the Scriptcase log module, it is possible to change the table.
When making this change, a new table will be created from scratch with no records. The records in the previous table must be migrated to your database.
How to edit log schema to change your table
1 - Access the menu: Modules > Log> Create / Edit Log module.
2 - Click on the icon highlighted in the image below to edit the logging scheme.
The log module edit screen will be displayed.
3 - In the log schema edit screen, enter a new name for the table in the Table field and click save.
4 - Then, the creation confirmation screen will be displayed.
Click the button, Close to save schema, to confirm the creation of the table and the change in the schema.
With this change, the log module will start saving data in the new_tb_sc_log table.
Changing table in the Log Report application
In the module> log menu, it is possible to create a grid application based on the log table.
If the application is already created, before changing the module table, it will be necessary to change the SQL or create a new application, so that the report is displayed correctly.
To change the SQL, follow the steps below.
1 - Access the application settings and click on the SQL menu, as highlighted in the image.
2 - In the SQL settings just inform the name of the new table and click on generate source code.
This change is possible only because both tables have the same field structure