Overview
Comment: | Save the date of when a contribution has been paid |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev |
Files: | files | file ages | folders |
SHA1: |
6f98e5f43160f24a5146473b2495bdd1 |
User & Date: | bohwaz on 2020-10-31 12:21:11 |
Other Links: | branch diff | manifest | tags |
Context
2020-10-31
| ||
13:43 | Fix and improve reversed accounts in simple view check-in: c1565ad1db user: bohwaz tags: dev | |
12:21 | Save the date of when a contribution has been paid check-in: 6f98e5f431 user: bohwaz tags: dev | |
2020-10-28
| ||
01:52 | Add account selector to fees check-in: 3f5008e7e3 user: bohwaz tags: dev | |
Changes
Modified src/include/data/1.0.0_schema.sql from [15229907ec] to [7a06e30bc9].
︙ | ︙ | |||
67 68 69 70 71 72 73 | id INTEGER NOT NULL PRIMARY KEY, id_user INTEGER NOT NULL REFERENCES membres (id) ON DELETE CASCADE, id_service INTEGER NOT NULL REFERENCES services (id) ON DELETE CASCADE, id_fee INTEGER NULL REFERENCES services_fees (id) ON DELETE CASCADE, paid INTEGER NOT NULL DEFAULT 0, | | > | 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 | id INTEGER NOT NULL PRIMARY KEY, id_user INTEGER NOT NULL REFERENCES membres (id) ON DELETE CASCADE, id_service INTEGER NOT NULL REFERENCES services (id) ON DELETE CASCADE, id_fee INTEGER NULL REFERENCES services_fees (id) ON DELETE CASCADE, paid INTEGER NOT NULL DEFAULT 0, date TEXT NULL DEFAULT CURRENT_DATE CHECK (date(date) IS NOT NULL AND date(date) = date) expiry_date TEXT NULL CHECK (date(expiry_date) IS NULL OR date(expiry_date) = expiry_date) ); CREATE UNIQUE INDEX IF NOT EXISTS su_unique ON services_users (id_user, id_service, expiry_date); CREATE TABLE IF NOT EXISTS services_reminders -- Rappels de devoir renouveller une cotisation ( |
︙ | ︙ |