1 -- Database should be in this folder, and named 'vchess.sqlite'
3 create table Variants (
4 id integer primary key,
10 id integer primary key,
19 create table Problems (
20 id integer primary key,
27 foreign key (uid
) references Users(id),
28 foreign key (vid
) references Variants(id)
31 -- All the following tables are for correspondance play only
32 -- (Live games are stored in browser)
34 create table Challenges (
35 id integer primary key,
42 foreign key (uid
) references Users(id),
43 foreign key (vid
) references Variants(id)
47 id integer primary key,
49 fenStart
varchar, --initial state
50 fen
varchar, --current state
53 foreign key (vid
) references Variants(id)
56 -- Store informations about players in a corr game
57 create table Players (
61 rtime
integer, --remaining time in milliseconds
62 foreign key (gid
) references Games(id),
63 foreign key (uid
) references Users(id)
70 played datetime
, --when was this move played?
71 idx
integer, --index of the move in the game
72 color
character, --required for e.g. Marseillais Chess
73 foreign key (gid
) references Games(id)
76 pragma foreign_keys
= on;