projects
/
vchess.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fix notation for Pacosako + Otage
[vchess.git]
/
server
/
db
/
populate.sql
diff --git
a/server/db/populate.sql
b/server/db/populate.sql
index
a44a3ab
..
122224d
100644
(file)
--- a/
server/db/populate.sql
+++ b/
server/db/populate.sql
@@
-7,10
+7,12
@@
insert or ignore into Variants (name, description, noProblems) values
('Dice', 'Roll the dice', true),
('Hidden', 'Unidentified pieces', true),
('Hiddenqueen', 'Queen disguised as a pawn', true),
('Dice', 'Roll the dice', true),
('Hidden', 'Unidentified pieces', true),
('Hiddenqueen', 'Queen disguised as a pawn', true),
- ('Synchrone', 'Play at the same time', true);
+ ('Synchrone1', 'Play at the same time (v1)', true),
+ ('Synchrone2', 'Play at the same time (v2)', true);
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)'),
@@
-19,15
+21,22
@@
insert or ignore into Variants (name, description) values
('Antiking2', 'Keep antiking in check (v2)'),
('Antimatter', 'Dangerous collisions'),
('Arena', 'Middle battle'),
('Antiking2', 'Keep antiking in check (v2)'),
('Antimatter', 'Dangerous collisions'),
('Arena', 'Middle battle'),
- ('Atomic', 'Explosive captures'),
+ ('Atomic1', 'Explosive captures (v1)'),
+ ('Atomic2', 'Explosive captures (v2)'),
+ ('Avalanche', 'Pawnfalls'),
('Ball', 'Score a goal'),
('Balaklava', 'Meet the Mammoth'),
('Ball', 'Score a goal'),
('Balaklava', 'Meet the Mammoth'),
+ ('Bario', 'A quantum story'),
('Baroque', 'Exotic captures'),
('Benedict', 'Change colors'),
('Berolina', 'Pawns move diagonally'),
('Bicolour', 'Harassed kings'),
('Baroque', 'Exotic captures'),
('Benedict', 'Change colors'),
('Berolina', 'Pawns move diagonally'),
('Bicolour', 'Harassed kings'),
+ ('Bishopawns', 'Bishop versus pawns'),
+ ('Brotherhood', 'Friendly pieces'),
('Cannibal', 'Capture powers'),
('Cannibal', 'Capture powers'),
+ ('Capablanca', 'Capablanca Chess'),
('Capture', 'Mandatory captures'),
('Capture', 'Mandatory captures'),
+ ('Castle', 'Win by castling long'),
('Checkered1', 'Shared pieces (v1)'),
('Checkered2', 'Shared pieces (v2)'),
('Checkless', 'No-check mode'),
('Checkered1', 'Shared pieces (v1)'),
('Checkered2', 'Shared pieces (v2)'),
('Checkless', 'No-check mode'),
@@
-38,26
+47,40
@@
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'),
('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)'),
('Dynamo', 'Push and pull'),
('Eightpieces', 'Each piece is unique'),
('Doublearmy', '64 pieces on the board'),
('Doublemove1', 'Double moves (v1)'),
('Doublemove2', 'Double moves (v2)'),
('Dynamo', 'Push and pull'),
('Eightpieces', 'Each piece is unique'),
+ ('Empire', 'Empire versus Kingdom'),
('Enpassant', 'Capture en passant'),
('Enpassant', 'Capture en passant'),
+ ('Evolution', 'Faster development'),
('Extinction', 'Capture all of a kind'),
('Football', 'Score a goal'),
('Forward', 'Moving forward'),
('Freecapture', 'Capture both colors'),
('Extinction', 'Capture all of a kind'),
('Football', 'Score a goal'),
('Forward', 'Moving forward'),
('Freecapture', 'Capture both colors'),
+ ('Fugue', 'Baroque Music'),
+ ('Fullcavalry', 'Lancers everywhere'),
('Grand', 'Big board'),
('Grasshopper', 'Long jumps over pieces'),
('Gridolina', 'Jump the borders'),
('Hamilton', 'Walk on a graph'),
('Grand', 'Big board'),
('Grasshopper', 'Long jumps over pieces'),
('Gridolina', 'Jump the borders'),
('Hamilton', 'Walk on a graph'),
+ ('Hoppelpoppel', 'Knibis and Bisknis'),
('Horde', 'A pawns cloud'),
('Horde', 'A pawns cloud'),
+ ('Hypnotic', 'Mind control (v1)'),
('Interweave', 'Interweaved colorbound teams'),
('Interweave', 'Interweaved colorbound teams'),
+ ('Isardam', 'No paralyzed pieces'),
+ ('Janggi', 'Korean Chess'),
+ ('Joker', 'Replace pieces'),
('Kinglet', 'Protect your pawns'),
('Kinglet', 'Protect your pawns'),
+ ('Kingsmaker', 'Promote into kings'),
('Knightmate', 'Mate the knight'),
('Knightmate', 'Mate the knight'),
+ ('Knightpawns', 'Knight versus pawns'),
('Knightrelay1', 'Move like a knight (v1)'),
('Knightrelay2', 'Move like a knight (v2)'),
('Koopa', 'Stun & kick pieces'),
('Knightrelay1', 'Move like a knight (v1)'),
('Knightrelay2', 'Move like a knight (v2)'),
('Koopa', 'Stun & kick pieces'),
@@
-66,42
+89,67
@@
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'),
- ('Makruk', 'Thai Chess'),
+ ('Maharajah', 'Augmented Queens'),
+ ('Makpong', 'Thai Chess (v2)'),
+ ('Makruk', 'Thai Chess (v1)'),
('Maxima', 'Occupy the enemy palace'),
('Maxima', 'Occupy the enemy palace'),
+ ('Mesmer', 'Mind control (v2)'),
('Minishogi', 'Shogi 5 x 5'),
('Minishogi', 'Shogi 5 x 5'),
+ ('Minixiangqi', 'Xiangqi 7 x 7'),
('Monochrome', 'All of the same color'),
('Monster', 'White move twice'),
('Monochrome', 'All of the same color'),
('Monster', 'White move twice'),
+ ('Musketeer', 'New fairy pieces'),
('Omega', 'A wizard in the corner'),
('Orda', 'Mongolian Horde (v1)'),
('Ordamirror', 'Mongolian Horde (v2)'),
('Omega', 'A wizard in the corner'),
('Orda', 'Mongolian Horde (v1)'),
('Ordamirror', 'Mongolian Horde (v2)'),
+ ('Otage', 'Capture and release hostages'),
('Pacifist1', 'Convert & support (v1)'),
('Pacifist2', 'Convert & support (v2)'),
('Pacifist1', 'Convert & support (v1)'),
('Pacifist2', 'Convert & support (v2)'),
+ ('Pacosako', 'Dance with the King'),
('Parachute', 'Landing on the board'),
('Parachute', 'Landing on the board'),
- ('Pawns', 'Reach the last rank'),
+ ('Pawnmassacre', 'Pieces upside down'),
+ ('Pawns', 'Reach the last rank (v1)'),
+ ('Pawnsking', 'Reach the last rank (v2)'),
('Perfect', 'Powerful pieces'),
('Pocketknight', 'Knight in pocket'),
('Perfect', 'Powerful pieces'),
('Pocketknight', 'Knight in pocket'),
+ ('Progressive1', 'Play more and more moves (v1)'),
+ ('Progressive2', 'Play more and more moves (v2)'),
+ ('Queenpawns', 'Queen versus pawns'),
('Racingkings', 'Kings cross the 8x8 board'),
('Rampage', 'Move under cover'),
('Racingkings', 'Kings cross the 8x8 board'),
('Rampage', 'Move under cover'),
+ ('Relayup', 'Upgrade pieces'),
('Rifle', 'Shoot pieces'),
('Recycle', 'Reuse pieces'),
('Rifle', 'Shoot pieces'),
('Recycle', 'Reuse pieces'),
+ ('Refusal', 'Do not play that!'),
+ ('Rollerball', 'As in the movie'),
('Rococo', 'Capture on the edge'),
('Rococo', 'Capture on the edge'),
+ ('Rookpawns', 'Rook versus pawns'),
('Royalrace', 'Kings cross the 11x11 board'),
('Rugby', 'Transform an essay'),
('Schess', 'Seirawan-Harper Chess'),
('Royalrace', 'Kings cross the 11x11 board'),
('Rugby', 'Transform an essay'),
('Schess', 'Seirawan-Harper Chess'),
+ ('Screen', 'Free initial setup'),
('Shako', 'Non-conformism and utopia'),
('Shatranj', 'Ancient rules'),
('Shogi', 'Japanese Chess'),
('Shako', 'Non-conformism and utopia'),
('Shatranj', 'Ancient rules'),
('Shogi', 'Japanese Chess'),
- ('Sittuyin', 'Burmese chess'),
+ ('Shogun', 'General''s Chess'),
+ ('Sittuyin', 'Burmese Chess'),
+ ('Spartan', 'Spartan versus Persians'),
+ ('Squatter1', 'Squat last rank (v1)'),
+ ('Squatter2', 'Squat last rank (v2)'),
('Suicide', 'Lose all pieces'),
('Suction', 'Attract opposite king'),
('Swap', 'Dangerous captures'),
('Switching', 'Exchange pieces'' positions'),
('Suicide', 'Lose all pieces'),
('Suction', 'Attract opposite king'),
('Swap', 'Dangerous captures'),
('Switching', 'Exchange pieces'' positions'),
+ ('Synochess', 'Dynasty versus Kingdom'),
('Takenmake', 'Prolongated captures'),
('Teleport', 'Reposition pieces'),
('Tencubed', 'Four new pieces'),
('Threechecks', 'Give three checks'),
('Takenmake', 'Prolongated captures'),
('Teleport', 'Reposition pieces'),
('Tencubed', 'Four new pieces'),
('Threechecks', 'Give three checks'),
+ ('Titan', 'Extra bishops and knights'),
('Twokings', 'Two kings'),
('Upsidedown', 'Board upside down'),
('Twokings', 'Two kings'),
('Upsidedown', 'Board upside down'),
+ ('Vchess', 'Pawns capture backward'),
('Wildebeest', 'Balanced sliders & leapers'),
('Wormhole', 'Squares disappear'),
('Wildebeest', 'Balanced sliders & leapers'),
('Wormhole', 'Squares disappear'),
+ ('Xiangqi', 'Chinese Chess'),
('Zen', 'Reverse captures');
('Zen', 'Reverse captures');