X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F09_remaining_foreign_keys.sql;h=0c0b4bc537050f164ce5165e8dd0933ce1734207;hb=843707811834ac764ceb05df10ddfde16e143912;hp=f30eaf93c1707de2c30cd8f3abeb65e0be28283e;hpb=60db728a2709b1ee2d53fd3162644eb8dc184a7d;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);