X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F071-apprentice.sql;h=eb905b7bf710dba1cba64a8d64f94fbc7ed71600;hb=a04917816df17fb43979ecb4299d84ac3ae7e6e7;hp=c3a0193bfcbe4b609a1a1cd7e7d7ce5f979d94f8;hpb=66f94441ec85a5555c7280aff03ba7e5d661c364;p=brisk.git

diff --git a/sql/sql.d/071-apprentice.sql b/sql/sql.d/071-apprentice.sql
index c3a0193..eb905b7 100644
--- a/sql/sql.d/071-apprentice.sql
+++ b/sql/sql.d/071-apprentice.sql
@@ -1,8 +1,16 @@
 --
 --  Table to manage mails sent to users
 --
-DROP TABLE #PFX#selfreg_chk;
+DROP TABLE IF EXISTS #PFX#selfreg_chk;
 CREATE TABLE #PFX#selfreg_chk (
        ip         integer,                           -- ip v4 address
        atime      timestamp DEFAULT to_timestamp(0)  -- access time
        );
+
+--
+--  Add counters to show how many matches and games are played
+--
+ALTER TABLE #PFX#users DROP COLUMN match_cnt;
+ALTER TABLE #PFX#users ADD COLUMN match_cnt integer DEFAULT 0;
+ALTER TABLE #PFX#users DROP COLUMN game_cnt;
+ALTER TABLE #PFX#users ADD COLUMN game_cnt integer DEFAULT 0;