X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=db%2Fcreate.sql;h=c28bd561ce369a937220586e352f9ed9aa16c3bc;hp=321274d01111e7ab76e5c043cf611a29ebe5f922;hb=c326e657d451c90220edbaa6f09fcb991350524c;hpb=5188295933c6628a7f52473b8f61c93a0aaac179

diff --git a/db/create.sql b/db/create.sql
index 321274d0..c28bd561 100644
--- a/db/create.sql
+++ b/db/create.sql
@@ -1,28 +1,9 @@
--- database should be in this folder, and named 'vchess.sqlite'
+-- Database should be in this folder, and named 'vchess.sqlite'
 
 create table Variants (
 	name varchar primary key,
 	description text
 );
-insert into Variants values
-	('Checkered', 'Shared pieces'),
-	('Zen', 'Reverse captures'),
-	('Atomic', 'Explosive captures'),
-	('Chess960', 'Standard rules'),
-	('Antiking', 'Keep antiking in check'),
-	('Magnetic', 'Laws of attraction'),
-	('Alice', 'Both sides of the mirror'),
-	('Grand', 'Big board'),
-	('Wildebeest', 'Balanced sliders & leapers'),
-	('Loser', 'Lose all pieces'),
-	('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,
@@ -33,4 +14,5 @@ create table Problems (
 	solution text,
 	foreign key (variant) references Variants(name)
 );
---PRAGMA foreign_keys = ON;
+
+PRAGMA foreign_keys = ON;