Overview
Comment:Correction typo
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 6ccbb8a8e204cda46526665205d5f1ea544fc5e6
User & Date: bohwaz on 2018-02-09 01:13:17
Other Links: manifest | tags
Context
2018-02-09
01:20
Désactiver la possibilité de modifier les écritures de report à nouveau check-in: 0c1b75c44c user: bohwaz tags: trunk, stable
01:13
Correction typo check-in: 6ccbb8a8e2 user: bohwaz tags: trunk
01:12
Ne pas copier le champ s'il n'existe pas déjà ! check-in: b85cd942a5 user: bohwaz tags: trunk, stable
Changes

Modified src/include/data/schema.sql from [1c0ae41b79] to [271bbe8e5a].

67
68
69
70
71
72
73
74
75
76
77
78
79
80
81

    date TEXT NOT NULL DEFAULT CURRENT_DATE CHECK (date(date) IS NOT NULL AND date(date) = date)
);

CREATE UNIQUE INDEX IF NOT EXISTS cm_unique ON cotisations_membres (id_membre, id_cotisation, date);

CREATE TABLE IF NOT EXISTS membres_operations
-- Liaision des enregistrement des paiements en compta
(
    id_membre INTEGER NOT NULL REFERENCES membres (id) ON DELETE CASCADE,
    id_operation INTEGER NOT NULL REFERENCES compta_journal (id) ON DELETE CASCADE,
    id_cotisation INTEGER NULL REFERENCES cotisations_membres (id) ON DELETE SET NULL,

    PRIMARY KEY (id_membre, id_operation)
);







|







67
68
69
70
71
72
73
74
75
76
77
78
79
80
81

    date TEXT NOT NULL DEFAULT CURRENT_DATE CHECK (date(date) IS NOT NULL AND date(date) = date)
);

CREATE UNIQUE INDEX IF NOT EXISTS cm_unique ON cotisations_membres (id_membre, id_cotisation, date);

CREATE TABLE IF NOT EXISTS membres_operations
-- Liaison des enregistrement des paiements en compta
(
    id_membre INTEGER NOT NULL REFERENCES membres (id) ON DELETE CASCADE,
    id_operation INTEGER NOT NULL REFERENCES compta_journal (id) ON DELETE CASCADE,
    id_cotisation INTEGER NULL REFERENCES cotisations_membres (id) ON DELETE SET NULL,

    PRIMARY KEY (id_membre, id_operation)
);