projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fix MarseilleRules, remove debug traces
[vchess.git]
/
db
/
create.sql
diff --git
a/db/create.sql
b/db/create.sql
index
aa2f3ae
..
321274d
100644
(file)
--- a/
db/create.sql
+++ b/
db/create.sql
@@
-1,3
+1,5
@@
+-- database should be in this folder, and named 'vchess.sqlite'
+
create table Variants (
name varchar primary key,
description text
create table Variants (
name varchar primary key,
description text
@@
-16,9
+18,14
@@
insert into Variants values
('Crazyhouse', 'Captures reborn'),
('Switching', 'Exchange pieces positions'),
('Extinction', 'Capture all of a kind'),
('Crazyhouse', 'Captures reborn'),
('Switching', 'Exchange pieces positions'),
('Extinction', 'Capture all of a kind'),
+ ('Marseille', 'Move twice'),
+ ('Upsidedown', 'Walking on the hands'),
+ ('Dark', 'In the shadow'),
+ ('Berolina', 'Pawns move diagonally'),
('Ultima', 'Exotic captures');
create table Problems (
('Ultima', 'Exotic captures');
create table Problems (
+ num integer primary key,
added datetime,
variant varchar,
fen varchar,
added datetime,
variant varchar,
fen varchar,