diff options
| author | Jose M. Guisado <jguisado@soleta.eu> | 2021-04-28 09:55:45 +0000 |
|---|---|---|
| committer | OpenGnSys Support Team <soporte-og@soleta.eu> | 2021-04-28 12:10:27 +0200 |
| commit | 8775c06d3643e20d01eed8d9dee147765292a3e2 (patch) | |
| tree | bf3217d6c97ad3ccbb006d4cec6f37c7712c516a /cfg/ogAdmBD.sql | |
| parent | 3b1f2c293f5f71468dc7c5cfd876e2a53f869d46 (diff) | |
#1042 Add schema version 2
Add foreign keys (version 1 introduced innoDB as default db engine)
allowing cascade deletions for some tables:
- perfilessoft_softwares
If a software profile or a software component is deleted, the
corresponding row in this table will be deleted too.
- ordenadores_particiones
If a computer or a partition is deleted from the DB, delete the
corresponding row inside this table.
- aulas
If the center the room is in is removed, delete the room too.
- ordenadores
If the room in which a computer is in is removed, the computer
will be deleted accordingly.
We should take into account that this schema superseeds some code
regarding deletions inside WebConsole that probably are not needed any
more, at least for the tables mentioned.
(See admin/WebConsole/gestores/relaciones/*.php in OpenGnsys repo)
Diffstat (limited to 'cfg/ogAdmBD.sql')
0 files changed, 0 insertions, 0 deletions