search

Nuked-Klan / CMS_Nuked-Klan

[CLOSE] Official Nuked-Klan development
https://bel-cms.dev
30 stars 27 forks source link

Add constraint between some tables #96

Open akred opened 8 years ago

akred commented 8 years ago

The goal is to add a constraint between "Links" table and "Comments" table. When we remove a link, all attached comments will be removed automatical

cyrillePrigent commented 8 years ago

Also applies to modules Download, Gallery, News, Sections, Survey and Wars

akred commented 8 years ago

We can also add constraints in Vote module (notation with stars). When we delete a download for example, we delete automatically the attached notation

akred commented 8 years ago

Comment and Vote tables : 1/ Select all IDS on these tables where relations keys are orphans and delete them 2/ On row delete of these tables : Download / Gallery / News / Sections / Survey / Wars / Link -> remove attached comments and attached votes