130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
|
END
FROM cotisations_membres cm
INNER JOIN cotisations c ON c.id = cm.id_cotisation;
INSERT INTO services_reminders SELECT * FROM rappels;
INSERT INTO services_reminders_sent SELECT id, id_membre, id_cotisation,
CASE WHEN id_rappel IS NULL THEN (SELECT MAX(id) FROM rappels) ELSE id_rappel END, date
FROM rappels_envoyes;
DROP TABLE cotisations;
DROP TABLE cotisations_membres;
DROP TABLE rappels;
DROP TABLE rappels_envoyes;
-- Suppression inutilisées
|
|
>
|
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
|
END
FROM cotisations_membres cm
INNER JOIN cotisations c ON c.id = cm.id_cotisation;
INSERT INTO services_reminders SELECT * FROM rappels;
INSERT INTO services_reminders_sent SELECT id, id_membre, id_cotisation,
CASE WHEN id_rappel IS NULL THEN (SELECT MAX(id) FROM rappels) ELSE id_rappel END, date
FROM rappels_envoyes
GROUP BY id_membre, id_cotisation, id_rappel;
DROP TABLE cotisations;
DROP TABLE cotisations_membres;
DROP TABLE rappels;
DROP TABLE rappels_envoyes;
-- Suppression inutilisées
|