#!/usr/bin/env bash

upgradedatabase_4_5() {
	echo "Upgrading database to version 5... (backup is $database.bak_v4)"
	cp "$database" "$database.bak_v4"
	echo 'DROP TRIGGER force_destination_update_on_tag_update;' >&3
	echo '
		CREATE TRIGGER IF NOT EXISTS force_destination_update_on_tag_update
		AFTER UPDATE OF
			genre,
			albumartist,
			year,
			album,
			disc,
			artist,
			track,
			title,
			composer,
			performer,
			releasecountry,
			rate,
			channels,
			bitrate,
			depth
		ON tags
		BEGIN
			UPDATE destination_files SET last_change=0
			WHERE source_file_id=old.source_file;
		END;
	' >&3

	Update atom version 5 <<<"1 = 1"
}
