X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F085-tourn-update.sql;fp=sql%2Fsql.d%2F085-tourn-update.sql;h=56dd0c4f396afcac8f2a135955eba86a5ff259a4;hb=7332bf2e21e419c2f5af5f7e955367b59c9da135;hp=0000000000000000000000000000000000000000;hpb=8740bf85c70c984fdd5342ef4446cced16fb4e5e;p=brisk.git

diff --git a/sql/sql.d/085-tourn-update.sql b/sql/sql.d/085-tourn-update.sql
new file mode 100644
index 0000000..56dd0c4
--- /dev/null
+++ b/sql/sql.d/085-tourn-update.sql
@@ -0,0 +1,7 @@
+--  from:
+--    INSERT INTO #PFX#bin5_tournaments (code, active, name) VALUES (1, 1, 'normal match');
+--    INSERT INTO #PFX#bin5_tournaments (code, active, name) VALUES (2, 1, 'special match');
+
+UPDATE #PFX#bin5_tournaments SET (name) = ('old rules: with draw') WHERE code = 1;
+UPDATE #PFX#bin5_tournaments SET (name) = ('new rules: without draw') WHERE code = 2;
+INSERT INTO #PFX#bin5_tournaments (code, active, name) VALUES (3, 1, 'special match');