database

var Migrations = map[int][]string{
	1: {
		`
		CREATE TABLE IF NOT EXISTS migration (
    		id INTEGER PRIMARY KEY NOT NULL,
    		updated_at timestamp DEFAULT CURRENT_TIMESTAMP,
    		migration_id INT NOT NULL UNIQUE
		)
		`,
		`
		INSERT INTO migration (migration_id) values(1)
		`,
	},
	2: {
		`
		CREATE TABLE IF NOT EXISTS item_count (
		    id INTEGER PRIMARY KEY NOT NULL,
		    owner VARCHAR(64) NOT NULL,
		    item_id VARCHAR(64) NOT NULL COLLATE NOCASE,
		    item_count INTEGER NOT NULL DEFAULT 0,
		    FOREIGN KEY(item_id) REFERENCES item(id),
		    UNIQUE(owner, item_id)
		)
		`,
		`
		CREATE TABLE IF NOT EXISTS item (
		    id VARCHAR(64) PRIMARY KEY NOT NULL,
		    name VARCHAR(255) UNIQUE COLLATE NOCASE
		)
		`,
		`
		INSERT INTO migration (migration_id) values(2)
		`,
	},
}