X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fcreate.sql;h=56ae4f19183da7a21a192689e9dcaa83ca082438;hb=HEAD;hp=75e1b1cd8cd17b47b51d04084f0f1a003e7dcfc5;hpb=00f2759e16ec73fa1ecd0254a9c9018530d71892;p=vchess.git

diff --git a/db/create.sql b/db/create.sql
deleted file mode 100644
index 75e1b1cd..00000000
--- a/db/create.sql
+++ /dev/null
@@ -1,78 +0,0 @@
--- Database should be in this folder, and named 'vchess.sqlite'
-
-create table Variants (
-	id integer primary key,
-	name varchar unique,
-	description text
-);
-
-create table Users (
-	id integer primary key,
-	name varchar unique,
-	email varchar unique,
-	loginToken varchar,
-	loginTime datetime,
-	sessionToken varchar,
-	notify boolean
-);
-
-create table Problems (
-	id integer primary key,
-	added datetime,
-	uid integer,
-	vid integer,
-	fen varchar,
-	instructions text,
-	solution text,
-	foreign key (uid) references Users(id),
-	foreign key (vid) references Variants(id)
-);
-
--- All the following tables are for correspondance play only
--- (Live games are stored only in browsers)
-
-create table Challenges (
-	id integer primary key,
-	added datetime,
-	uid integer,
-	vid integer,
-	nbPlayers integer,
-	foreign key (uid) references Users(id),
-	foreign key (vid) references Variants(id)
-);
-
--- Store informations about players who accept a challenge
-create table WillPlay (
-	cid integer,
-	uid integer,
-	foreign key (cid) references Challenges(id),
-	foreign key (uid) references Users(id)
-);
-
-create table Games (
-	id integer primary key,
-	vid integer,
-	fen varchar, --initial position
-	score varchar default '*',
-	foreign key (vid) references Variants(id)
-);
-
--- Store informations about players in a corr game
-create table Players (
-	gid integer,
-	uid integer,
-	color character,
-	foreign key (gid) references Games(id),
-	foreign key (uid) references Users(id)
-);
-
-create table Moves (
-	gid integer,
-	move varchar,
-	played datetime, --when was this move played?
-	idx integer, --index of the move in the game
-	color character, --required for e.g. Marseillais Chess
-	foreign key (gid) references Games(id)
-);
-
-pragma foreign_keys = on;