Overview
SHA1:6ccbb8a8e204cda46526665205d5f1ea544fc5e6
Date: 2018-02-09 01:13:17
User: bohwaz
Comment:Correction typo
Timelines: family | ancestors | descendants | both | trunk
Downloads: Tarball | ZIP archive
Other Links: files | file ages | folders | manifest
Tags And Properties
Context
2018-02-09
01:20
[0c1b75c44c] Désactiver la possibilité de modifier les écritures de report à nouveau (user: bohwaz, tags: trunk, stable)
01:13
[6ccbb8a8e2] Correction typo (user: bohwaz, tags: trunk)
01:12
[b85cd942a5] Ne pas copier le champ s'il n'existe pas déjà ! (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)
);