2 -- Table to manage mails sent to users
4 DROP TABLE IF EXISTS #PFX#selfreg_chk;
5 CREATE TABLE #PFX#selfreg_chk (
6 ip integer, -- ip v4 address
7 atime timestamp DEFAULT to_timestamp(0) -- access time
11 -- Add counters to show how many matches and games are played
13 ALTER TABLE #PFX#users DROP COLUMN match_cnt;
14 ALTER TABLE #PFX#users ADD COLUMN match_cnt integer DEFAULT 0;
15 ALTER TABLE #PFX#users DROP COLUMN game_cnt;
16 ALTER TABLE #PFX#users ADD COLUMN game_cnt integer DEFAULT 0;