Skip to content
This repository has been archived by the owner on Oct 7, 2023. It is now read-only.

Add constraint between some tables #96

Open
akred opened this issue Jan 2, 2016 · 3 comments
Open

Add constraint between some tables #96

akred opened this issue Jan 2, 2016 · 3 comments
Assignees
@akred
Labels
ENHANCEMENT IN PROGRESS
Milestone
Nuked Klan 1.8

Comments

@akred
Copy link
Contributor

akred commented Jan 2, 2016

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
@akred akred added this to the Nuked Klan 1.8 milestone Jan 2, 2016
@cyrillePrigent
Copy link
Contributor

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

@akred akred changed the title Add constraint between Links table and Comments table Add constraint between some tables Jan 29, 2016
@akred
Copy link
Contributor Author

akred commented Jan 29, 2016

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
Copy link
Contributor Author

akred commented Jan 31, 2016

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

@akred akred self-assigned this Jan 31, 2016
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@akred akred

Labels
ENHANCEMENT IN PROGRESS
Projects
None yet
Milestone
Nuked Klan 1.8
Development

No branches or pull requests
2 participants
@cyrillePrigent @akred