planetwars.dev/planetwars-server/migrations/2022-08-23-174628_maps/up.sql

7 lines
176 B
MySQL
Raw Permalink Normal View History

2022-08-23 20:00:21 +02:00
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);