GeotrekCE / Geotrek-admin

Paths management for National Parks and Tourism organizations

https://geotrek.fr

BSD 2-Clause "Simplified" License

130 stars 76 forks source link

BDD - Pas de ON DELETE, ni ON UPDATE sur les tables #259

Open makinabot opened 11 years ago

makinabot commented 11 years ago

DELETE

Delete e_t_evenement + e_r_evenement for delete on all "inherited" models
Set value = Null for delete on all bibs FK
Delete cascade for delete on all bibs N-N
UPDATE
l_t_troncon (supprime) -> e_r_evenement + e_t_evenement (une fois #752 implémenté)
o_b_difficulte (id) -> o_t_itineraire (difficulte)

CONSTRAINT difficulte_refs_id FOREIGN KEY (difficulte) REFERENCES o_b_difficulte (id) MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED,

Questions

Set project = null on intervention for delete project ?

submarcos commented 5 months ago

Managed by django, but django don't add constraints in database directly.