Update code to remove users in tournament DB as well

[vchess.git] / server / db / populate.sql

diff --git a/server/db/populate.sql b/server/db/populate.sql
index 7def7a6..18d9269 100644 (file)
--- a/server/db/populate.sql
+++ b/server/db/populate.sql
@@ -76,6 +76,7 @@ insert or ignore into Variants (name, description) values
   ('Makruk', 'Thai Chess'),
   ('Maxima', 'Occupy the enemy palace'),
   ('Minishogi', 'Shogi 5 x 5'),
   ('Makruk', 'Thai Chess'),
   ('Maxima', 'Occupy the enemy palace'),
   ('Minishogi', 'Shogi 5 x 5'),

+  ('Minixiangqi', 'Xiangqi 7 x 7'),

   ('Monochrome', 'All of the same color'),
   ('Monster', 'White move twice'),
   ('Omega', 'A wizard in the corner'),
   ('Monochrome', 'All of the same color'),
   ('Monster', 'White move twice'),
   ('Omega', 'A wizard in the corner'),


@@ -104,7 +105,7 @@ insert or ignore into Variants (name, description) values
   ('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'),
+  ('Sittuyin', 'Burmese Chess'),

   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),
   ('Swap', 'Dangerous captures'),
   ('Suicide', 'Lose all pieces'),
   ('Suction', 'Attract opposite king'),
   ('Swap', 'Dangerous captures'),


@@ -119,4 +120,5 @@ insert or ignore into Variants (name, description) values
   ('Vchess', 'Pawns capture backward'),
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),
   ('Vchess', 'Pawns capture backward'),
   ('Wildebeest', 'Balanced sliders & leapers'),
   ('Wormhole', 'Squares disappear'),

+  ('Xiangqi', 'Chinese Chess'),

   ('Zen', 'Reverse captures');
   ('Zen', 'Reverse captures');