a8c8d687452e8d06d881d953ab3e5eb2eed0acb8
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 -- All the following tables are for correspondance play only
20 -- (Live games are stored in browser)
22 create table Challenges (
23 id integer primary key,
30 foreign key (uid
) references Users(id),
31 foreign key (vid
) references Variants(id)
34 -- NOTE: no need for a "created" field, it's deduced from first move playing time
36 id integer primary key,
38 fenStart
varchar, --initial state
39 fen
varchar, --current state
42 created datetime
, --used only for DB cleaning
43 foreign key (vid
) references Variants(id)
46 -- Store informations about players in a corr game
47 create table Players (
51 foreign key (gid
) references Games(id),
52 foreign key (uid
) references Users(id)
57 squares
varchar, --description, appear/vanish/from/to
59 played datetime
, --when was this move played?
60 idx
integer, --index of the move in the game
61 foreign key (gid
) references Games(id)
64 pragma foreign_keys
= on;