projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Add Alapo, Crossing, Kingsmaker, Squatter variants
[vchess.git]
/
server
/
db
/
populate.sql
diff --git
a/server/db/populate.sql
b/server/db/populate.sql
index
399fbb5
..
3c70353
100644
(file)
--- a/
server/db/populate.sql
+++ b/
server/db/populate.sql
@@
-12,6
+12,7
@@
insert or ignore into Variants (name, description, noProblems) values
insert or ignore into Variants (name, description) values
('Absorption', 'Absorb powers'),
insert or ignore into Variants (name, description) values
('Absorption', 'Absorb powers'),
+ ('Alapo', 'Geometric Chess'),
('Alice', 'Both sides of the mirror'),
('Allmate1', 'Mate any piece (v1)'),
('Allmate2', 'Mate any piece (v2)'),
('Alice', 'Both sides of the mirror'),
('Allmate1', 'Mate any piece (v1)'),
('Allmate2', 'Mate any piece (v2)'),
@@
-30,6
+31,7
@@
insert or ignore into Variants (name, description) values
('Berolina', 'Pawns move diagonally'),
('Bicolour', 'Harassed kings'),
('Bishopawns', 'Bishop versus pawns'),
('Berolina', 'Pawns move diagonally'),
('Bicolour', 'Harassed kings'),
('Bishopawns', 'Bishop versus pawns'),
+ ('Brotherhood', 'Friendly pieces'),
('Cannibal', 'Capture powers'),
('Capture', 'Mandatory captures'),
('Castle', 'Win by castling long'),
('Cannibal', 'Capture powers'),
('Capture', 'Mandatory captures'),
('Castle', 'Win by castling long'),
@@
-43,9
+45,11
@@
insert or ignore into Variants (name, description) values
('Coregal', 'Two royal pieces'),
('Coronation', 'Long live the Queen'),
('Crazyhouse', 'Captures reborn'),
('Coregal', 'Two royal pieces'),
('Coronation', 'Long live the Queen'),
('Crazyhouse', 'Captures reborn'),
+ ('Crossing', 'Cross the river'),
('Cylinder', 'Neverending rows'),
('Diamond', 'Rotating board'),
('Discoduel', 'Enter the disco'),
('Cylinder', 'Neverending rows'),
('Diamond', 'Rotating board'),
('Discoduel', 'Enter the disco'),
+ ('Dobutsu', 'Let''s catch the Lion!'),
('Doublearmy', '64 pieces on the board'),
('Doublemove1', 'Double moves (v1)'),
('Doublemove2', 'Double moves (v2)'),
('Doublearmy', '64 pieces on the board'),
('Doublemove1', 'Double moves (v1)'),
('Doublemove2', 'Double moves (v2)'),
@@
-69,6
+73,7
@@
insert or ignore into Variants (name, description) values
('Isardam', 'No paralyzed pieces'),
('Janggi', 'Korean Chess'),
('Kinglet', 'Protect your pawns'),
('Isardam', 'No paralyzed pieces'),
('Janggi', 'Korean Chess'),
('Kinglet', 'Protect your pawns'),
+ ('Kingsmaker', 'Promote into kings'),
('Knightmate', 'Mate the knight'),
('Knightpawns', 'Knight versus pawns'),
('Knightrelay1', 'Move like a knight (v1)'),
('Knightmate', 'Mate the knight'),
('Knightpawns', 'Knight versus pawns'),
('Knightrelay1', 'Move like a knight (v1)'),
@@
-79,6
+84,7
@@
insert or ignore into Variants (name, description) values
('Madhouse', 'Rearrange enemy pieces'),
('Madrasi', 'Paralyzed pieces'),
('Magnetic', 'Laws of attraction'),
('Madhouse', 'Rearrange enemy pieces'),
('Madrasi', 'Paralyzed pieces'),
('Magnetic', 'Laws of attraction'),
+ ('Maharajah', 'Augmented Queens'),
('Makpong', 'Thai Chess (v2)'),
('Makruk', 'Thai Chess (v1)'),
('Maxima', 'Occupy the enemy palace'),
('Makpong', 'Thai Chess (v2)'),
('Makruk', 'Thai Chess (v1)'),
('Maxima', 'Occupy the enemy palace'),
@@
-104,6
+110,7
@@
insert or ignore into Variants (name, description) values
('Queenpawns', 'Queen versus pawns'),
('Racingkings', 'Kings cross the 8x8 board'),
('Rampage', 'Move under cover'),
('Queenpawns', 'Queen versus pawns'),
('Racingkings', 'Kings cross the 8x8 board'),
('Rampage', 'Move under cover'),
+ ('Relayup', 'Upgrade pieces'),
('Rifle', 'Shoot pieces'),
('Recycle', 'Reuse pieces'),
('Rococo', 'Capture on the edge'),
('Rifle', 'Shoot pieces'),
('Recycle', 'Reuse pieces'),
('Rococo', 'Capture on the edge'),
@@
-116,6
+123,7
@@
insert or ignore into Variants (name, description) values
('Shatranj', 'Ancient rules'),
('Shogi', 'Japanese Chess'),
('Sittuyin', 'Burmese Chess'),
('Shatranj', 'Ancient rules'),
('Shogi', 'Japanese Chess'),
('Sittuyin', 'Burmese Chess'),
+ ('Squatter', 'Squat last rank'),
('Suicide', 'Lose all pieces'),
('Suction', 'Attract opposite king'),
('Swap', 'Dangerous captures'),
('Suicide', 'Lose all pieces'),
('Suction', 'Attract opposite king'),
('Swap', 'Dangerous captures'),