X-Git-Url: https://git.auder.net/?a=blobdiff_plain;f=db%2Fcreate.sql;h=c28bd561ce369a937220586e352f9ed9aa16c3bc;hb=c326e657d451c90220edbaa6f09fcb991350524c;hp=033df4be67b60ae30b994be7b6428579e2796861;hpb=643479f8d7c3622b57fc49c4f10d9950793ebf4f;p=vchess.git

diff --git a/db/create.sql b/db/create.sql
index 033df4be..c28bd561 100644
--- a/db/create.sql
+++ b/db/create.sql
@@ -1,24 +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'),
-	('Ultima', 'Exotic captures');
 
 create table Problems (
 	num integer primary key,
@@ -29,4 +14,5 @@ create table Problems (
 	solution text,
 	foreign key (variant) references Variants(name)
 );
---PRAGMA foreign_keys = ON;
+
+PRAGMA foreign_keys = ON;