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: 2e04cd892d4b69ef42c5a7eaf99663eb0fee4e04
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
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
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());