migrations/20170617130303_import.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied

CREATE TABLE IF NOT EXISTS scrobble_import (
	lfm_name text,
	"from" timestamptz,
	"to" timestamptz,
	last_fetch timestamptz,
	done bool,
	PRIMARY KEY (lfm_name, "from", "to")
);

CREATE INDEX scrobbles_time ON scrobbles(time DESC);

-- +goose Down
-- SQL section 'Down' is executed when this migration is rolled back
DROP TABLE scrobble_import;
DROP INDEX scrobbles_time;