Ticket #2292 (assigned good practices)

Opened 4 months ago

Last modified 6 weeks ago

[GUI] Re-factoring: Databases and users management

Reported by: nuxwin Owned by: nuxwin
Priority: normal Milestone: ispCP ω 1.0.7
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

Changed 4 months ago by nuxwin

  • description modified (diff)

Changed 4 months ago by nuxwin

  • description modified (diff)

Changed 4 months ago by nuxwin

  • description modified (diff)

Changed 4 months ago by nuxwin

  • summary changed from Re-factoring: Gui databases and users management to * [GUI] Re-factoring: Databases and users management

Changed 4 months ago by nuxwin

  • summary changed from * [GUI] Re-factoring: Databases and users management to [GUI] Re-factoring: Databases and users management

Changed 4 months ago by nuxwin

First part fixed in r2717

Changed 4 months ago by nuxwin

  • status changed from new to assigned

Changed 2 months ago by nuxwin

@Benedikt: Please, create roadmap for 1.0.7 and shift this ticket in it. Thank.

Changed 6 weeks ago by nuxwin

  • milestone changed from ispCP ω 1.0.6 to ispCP ω 1.0.7
Note: See TracTickets for help on using tickets.