[Improved] SQL Views
Posted: Sun Jan 22, 2023 9:50 am
nuBuilder's database contains 3 SQL views.
When you log in as an administrator, the system now checks for their existence and creates them if they are not there.
Another problem was that, especially with shared hosting, you do not always have the rights to create SQL views. In this case, static tables are created instead of views, which are updated each time the administrator logs in or hits refresh.
- zzzzsys_object_list
- zzzzsys_report_data
- zzzzsys_run_list
When you log in as an administrator, the system now checks for their existence and creates them if they are not there.
Another problem was that, especially with shared hosting, you do not always have the rights to create SQL views. In this case, static tables are created instead of views, which are updated each time the administrator logs in or hits refresh.