14 lines
390 B
SQL
14 lines
390 B
SQL
-- +goose Up
|
|
CREATE TABLE IF NOT EXISTS game_map_items (
|
|
game_id INTEGER NOT NULL REFERENCES games(id) ON DELETE CASCADE,
|
|
kind TEXT NOT NULL,
|
|
item_id INTEGER NOT NULL,
|
|
x INTEGER NOT NULL DEFAULT 40,
|
|
y INTEGER NOT NULL DEFAULT 40,
|
|
hidden BOOLEAN NOT NULL DEFAULT FALSE,
|
|
PRIMARY KEY (game_id, kind, item_id)
|
|
);
|
|
|
|
-- +goose Down
|
|
DROP TABLE IF EXISTS game_map_items;
|