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: 6f98e5f43160f24a5146473b2495bdd114d97bd5
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
74

75
76
77
78
79
80
81
    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,

    expiry_date TEXT NULL DEFAULT CURRENT_DATE CHECK (date(expiry_date) IS NOT NULL AND 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
(







|
>







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
(