Overview
Comment: | Make sure to unlink fees from a deleted year |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
2e04cd892d4b69ef42c5a7eaf99663eb |
User & Date: | bohwaz on 2020-12-09 18:42:27 |
Other Links: | manifest | tags |
Context
2020-12-09
| ||
18:55 | new release check-in: 2c2492b860 user: bohwaz tags: trunk, stable, 1.0.0-rc11 | |
18:42 | Make sure to unlink fees from a deleted year check-in: 2e04cd892d user: bohwaz tags: trunk | |
18:41 | Add one hour caching to graphs check-in: d4e4b804a8 user: bohwaz tags: trunk | |
Changes
Modified src/include/data/1.0.0_schema.sql from [2cb870482b] to [4710567bc0].
︙ | ︙ | |||
228 229 230 231 232 233 234 235 236 237 238 239 240 241 | start_date TEXT NOT NULL CHECK (date(start_date) IS NOT NULL AND date(start_date) = start_date), end_date TEXT NOT NULL CHECK (date(end_date) IS NOT NULL AND date(end_date) = end_date), closed INTEGER NOT NULL DEFAULT 0, id_chart INTEGER NOT NULL REFERENCES acc_charts (id) ); CREATE INDEX IF NOT EXISTS acc_years_closed ON acc_years (closed); CREATE TABLE IF NOT EXISTS acc_transactions -- Opérations comptables ( id INTEGER PRIMARY KEY NOT NULL, | > > > > | 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 | start_date TEXT NOT NULL CHECK (date(start_date) IS NOT NULL AND date(start_date) = start_date), end_date TEXT NOT NULL CHECK (date(end_date) IS NOT NULL AND date(end_date) = end_date), closed INTEGER NOT NULL DEFAULT 0, id_chart INTEGER NOT NULL REFERENCES acc_charts (id) ); CREATE TRIGGER IF NOT EXISTS acc_years_delete BEFORE DELETE ON acc_years BEGIN UPDATE services_fees SET id_account = NULL, id_year = NULL WHERE id_year = OLD.id; END; CREATE INDEX IF NOT EXISTS acc_years_closed ON acc_years (closed); CREATE TABLE IF NOT EXISTS acc_transactions -- Opérations comptables ( id INTEGER PRIMARY KEY NOT NULL, |
︙ | ︙ |
Modified src/include/lib/Garradin/Upgrade.php from [c40d4d26aa] to [b4ea8189bd].
︙ | ︙ | |||
92 93 94 95 96 97 98 99 100 101 102 103 104 105 | if (version_compare($v, '1.0.0-beta1', '>=') && version_compare($v, '1.0.0-rc10', '<')) { $db->beginSchemaUpdate(); $db->import(ROOT . '/include/data/1.0.0-rc10_migration.sql'); $db->commitSchemaUpdate(); } // Vérification de la cohérence des clés étrangères $db->foreignKeyCheck(); Utils::clearCaches(); $config->setVersion(garradin_version()); | > > > > > > > > | 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 | if (version_compare($v, '1.0.0-beta1', '>=') && version_compare($v, '1.0.0-rc10', '<')) { $db->beginSchemaUpdate(); $db->import(ROOT . '/include/data/1.0.0-rc10_migration.sql'); $db->commitSchemaUpdate(); } if (version_compare($v, '1.0.0-beta1', '>=') && version_compare($v, '1.0.0-rc11', '<')) { // Missing trigger $db->beginSchemaUpdate(); $db->import(ROOT . '/include/data/1.0.0_schema.sql'); $db->commitSchemaUpdate(); } // Vérification de la cohérence des clés étrangères $db->foreignKeyCheck(); Utils::clearCaches(); $config->setVersion(garradin_version()); |
︙ | ︙ |