gamenight/migrations/2022-03-19-191822_initial/up.sql

12 lines
269 B
MySQL
Raw Permalink Normal View History

2022-03-20 10:55:30 +01:00
-- Your SQL goes here
CREATE TABLE gamenight (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
game text TEXT NOT NULL,
datetime TEXT NOT NULL
);
CREATE TABLE known_games (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
game TEXT UNIQUE NOT NULL
);