21 lines
431 B
MySQL
21 lines
431 B
MySQL
|
create table if not exists tables (
|
||
|
tableid INTEGER PRIMARY KEY ASC,
|
||
|
name TEXT,
|
||
|
edition TEXT,
|
||
|
active INT
|
||
|
);
|
||
|
|
||
|
create table if not exists tournaments (
|
||
|
tournamentid INTEGER PRIMARY KEY ASC,
|
||
|
date DATE,
|
||
|
description TEXT
|
||
|
);
|
||
|
|
||
|
create table if not exists players (
|
||
|
playerid INTEGER PRIMARY KEY ASC,
|
||
|
name TEXT,
|
||
|
tournament INTEGER,
|
||
|
FOREIGN KEY(tournament) REFERENCES tournaments(tournamentid)
|
||
|
);
|
||
|
|