Extensions Paheko  Check-in [28521d20d0]

Overview
Comment:Update Taima for Paheko 1.3.0
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | dev
Files: files | file ages | folders
SHA1: 28521d20d0fbe608bf0db2b6a7c6556dc526d4fb
User & Date: bohwaz on 2023-05-30 10:44:45
Other Links: branch diff | manifest | tags
Context
2023-05-31
16:44
Merge with #28521d20d0 check-in: f83112263d user: alinaar tags: dev
2023-05-30
10:44
Update Taima for Paheko 1.3.0 check-in: 28521d20d0 user: bohwaz tags: dev
2023-05-28
18:53
HelloAsso: Chargeable item label clarified (options and donations) check-in: e821445e61 user: alinaar tags: dev
Changes

Modified taima/upgrade.php from [fe8f3e6007] to [2345d6ebbe].

31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
		timer_started INTEGER NULL -- date time for the start of the timer, is null if no timer is running
	);
	INSERT INTO plugin_taima_entries SELECT * FROM plugin_taima_entries_old;
	DROP TABLE plugin_taima_entries_old;');
}

// Change ON DELETE CASCADE to ON DELETE SET NULL
if (version_compare($old_version, '0.5.1', '<')) {
	$db->beginSchemaUpdate();
	$db->exec('ALTER TABLE plugin_taima_entries RENAME TO plugin_taima_entries_old;

	CREATE TABLE IF NOT EXISTS plugin_taima_entries (
		id INTEGER NOT NULL PRIMARY KEY,
		user_id INTEGER NULL REFERENCES users (id) ON DELETE SET NULL,
		task_id INTEGER NULL REFERENCES plugin_taima_tasks(id) ON DELETE SET NULL,







|







31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
		timer_started INTEGER NULL -- date time for the start of the timer, is null if no timer is running
	);
	INSERT INTO plugin_taima_entries SELECT * FROM plugin_taima_entries_old;
	DROP TABLE plugin_taima_entries_old;');
}

// Change ON DELETE CASCADE to ON DELETE SET NULL
if (version_compare($old_version, '0.6.0', '<')) {
	$db->beginSchemaUpdate();
	$db->exec('ALTER TABLE plugin_taima_entries RENAME TO plugin_taima_entries_old;

	CREATE TABLE IF NOT EXISTS plugin_taima_entries (
		id INTEGER NOT NULL PRIMARY KEY,
		user_id INTEGER NULL REFERENCES users (id) ON DELETE SET NULL,
		task_id INTEGER NULL REFERENCES plugin_taima_tasks(id) ON DELETE SET NULL,