summaryrefslogtreecommitdiffstats
path: root/cfg/ogAdmBD.sql
diff options
context:
space:
mode:
authorJose M. Guisado <jguisado@soleta.eu>2021-04-28 09:55:45 +0000
committerOpenGnSys Support Team <soporte-og@soleta.eu>2021-04-28 12:10:27 +0200
commit8775c06d3643e20d01eed8d9dee147765292a3e2 (patch)
treebf3217d6c97ad3ccbb006d4cec6f37c7712c516a /cfg/ogAdmBD.sql
parent3b1f2c293f5f71468dc7c5cfd876e2a53f869d46 (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