X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fcreate.sql;h=321274d01111e7ab76e5c043cf611a29ebe5f922;hb=1b61a94dbd13f6a37a89e62216615d2496c760a2;hp=aa2f3ae13451c530770dceb2b48e58af1ac9bdb3;hpb=da06a6eb0237123ce43fdb01cb06246b8b57f5e5;p=vchess.git

diff --git a/db/create.sql b/db/create.sql
index aa2f3ae1..321274d0 100644
--- 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
@@ -16,9 +18,14 @@ insert into Variants values
 	('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 (
+	num integer primary key,
 	added datetime,
 	variant varchar,
 	fen varchar,