up.sql « 2022-08-23-174628_maps « migrations « planetwars-server - planetwars.dev - Unnamed repository; edit this file 'description' to name the repository.

about summary refs log tree commit diff

path: root/planetwars-server/migrations/2022-08-23-174628_maps/up.sql

blob: c66fc9f51817a7ce2e734d35caf57a921d354a30 (plain)

CREATE TABLE maps (
    id SERIAL PRIMARY KEY,
    name TEXT UNIQUE NOT NULL,
    file_path TEXT NOT NULL
);

ALTER TABLE matches ADD COLUMN map_id INTEGER REFERENCES maps(id);