Database: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 20: | Line 20: | ||
* In v4.5 a new view was introduced (<tt>zzzzsys_object_list</tt>) to get this [[Media:get_from_view.png|'''data''']] from the information_schema db directly. | * In v4.5 a new view was introduced (<tt>zzzzsys_object_list</tt>) to get this [[Media:get_from_view.png|'''data''']] from the information_schema db directly. | ||
* In v4, the <tt>nuapi.php</tt> kept on purging and [[Media:nuapi_re-creates_tables.png|'''re-creating''']] the said table. | * In v4, the <tt>nuapi.php</tt> kept on purging and [[Media:nuapi_re-creates_tables.png|'''re-creating''']] the said table. | ||
* In v4.5, the <tt>zzzzsys_report_data</tt> uses the new view. | * In v4.5, the <tt>zzzzsys_report_data</tt> view uses the new view. | ||
Revision as of 19:47, 17 January 2021
phpMyAdmin will give nuBuilder developers direct access to the database.
It is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
phpMyAdmin supports a wide range of operations on MySQL and MariaDB.
Frequently used operations can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
Those operations are..
- managing databases
- tables
- columns
- relations
- indexes
- users
- permissions
zzzzsys_table
- In nubuilder v4, there is a system table called zzzzsys_table that gets populated with all table and view names.
- In v4.5 a new view was introduced (zzzzsys_object_list) to get this data from the information_schema db directly.
- In v4, the nuapi.php kept on purging and re-creating the said table.
- In v4.5, the zzzzsys_report_data view uses the new view.
