148
149
150
151
152
153
154
155
156
157
158
159
160
161
|
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;
|
>
|
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
|
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
WHERE id_rappel IS NOT NULL
GROUP BY id_membre, id_cotisation, id_rappel;
DROP TABLE cotisations;
DROP TABLE cotisations_membres;
DROP TABLE rappels;
DROP TABLE rappels_envoyes;
|