private bool Migrate_41 ()
{
Execute ("DROP TABLE IF EXISTS CoreShuffleDiscards");
Execute ("DROP INDEX IF EXISTS CoreShuffleDiscardsIndex");
Execute (@"
CREATE TABLE CoreShuffleModifications (
ShufflerId INTEGER,
TrackID INTEGER,
LastModifiedAt INTEGER,
ModificationType INTEGER,
CONSTRAINT one_entry_per_track UNIQUE (ShufflerID, TrackID)
)
");
Execute ("CREATE INDEX CoreShuffleModificationsIndex ON CoreShuffleModifications (ShufflerId, TrackID, LastModifiedAt, ModificationType)");
return true;
}