X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F09_remaining_foreign_keys.sql;h=0c0b4bc537050f164ce5165e8dd0933ce1734207;hb=821198c7f5394839f6421c54a32ae2a0dca19b3d;hp=f30eaf93c1707de2c30cd8f3abeb65e0be28283e;hpb=12ddbc2037b16496dfb9d91c4f7091850146fcde;p=platal.git diff --git a/upgrade/1.0.1/09_remaining_foreign_keys.sql b/upgrade/1.0.1/09_remaining_foreign_keys.sql index f30eaf9..0c0b4bc 100644 --- a/upgrade/1.0.1/09_remaining_foreign_keys.sql +++ b/upgrade/1.0.1/09_remaining_foreign_keys.sql @@ -15,6 +15,7 @@ ALTER TABLE group_event_participants MODIFY COLUMN item_id INT(11) UNSIGNED DEFA UPDATE groups SET dom = NULL WHERE dom = 0; UPDATE payments SET asso_id = NULL WHERE asso_id = 0; UPDATE newsletter_art SET cid = NULL WHERE cid = 0; +UPDATE newsletter_ins SET last = NULL WHERE last = 0; -- Deletes things that should have been deleted ealier. DELETE FROM newsletter_art WHERE NOT EXISTS (SELECT * FROM newsletter WHERE newsletter.id = newsletter_art.id);