X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fcreate.sql;h=033df4be67b60ae30b994be7b6428579e2796861;hb=4fefd0195b2dc8559284d3b3701a242a862cb70e;hp=aa2f3ae13451c530770dceb2b48e58af1ac9bdb3;hpb=da06a6eb0237123ce43fdb01cb06246b8b57f5e5;p=vchess.git

diff --git a/db/create.sql b/db/create.sql
index aa2f3ae1..033df4be 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
@@ -19,6 +21,7 @@ insert into Variants values
 	('Ultima', 'Exotic captures');
 
 create table Problems (
+	num integer primary key,
 	added datetime,
 	variant varchar,
 	fen varchar,