Ticket #2292 (new good practice)
[GUI] Re-factoring: Databases and users management
| Reported by: | nuxwin | Owned by: | |
|---|---|---|---|
| Priority: | normal | Milestone: | ispCP ω 1.x.0 |
| Component: | Frontend (GUI) | Version: | ispCP ω 1.0.5 |
| Severity: | Medium | Keywords: | |
| Cc: |
Description (last modified by nuxwin) (diff)
The current database schema for the managment of the databases and the associated users is bad.
First, all queries must be rewriten to delete heredoc syntax.
Also, we should use many to many relationship according the SQL good practices. For that, we should create a new database table named 'sql_database_sql_user'.
The new table must provide two columns where the first column should contain the Id of a database and the second, the Id of Sql user.
Indeed, an database can have many Sql users and an Sql user can be used by many databases.
Change History
comment:4 Changed 23 months ago by nuxwin
- Summary changed from Re-factoring: Gui databases and users management to * [GUI] Re-factoring: Databases and users management
comment:5 Changed 23 months ago by nuxwin
- Summary changed from * [GUI] Re-factoring: Databases and users management to [GUI] Re-factoring: Databases and users management
comment:8 Changed 20 months ago by nuxwin
@Benedikt: Please, create roadmap for 1.0.7 and shift this ticket in it. Thank.
comment:10 Changed 14 months ago by benedikt
- Owner nuxwin deleted
- Status changed from assigned to new
Note: See
TracTickets for help on using
tickets.
