From f3efdaffb99dee93146426f429e6fd9ef6bc4050 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Fri, 13 Jun 2014 08:24:13 -0400 Subject: [PATCH] Add email address to the players table (for admins only). --- tables/players.tab | 1 + 1 file changed, 1 insertion(+) diff --git a/tables/players.tab b/tables/players.tab index 26c212a..57e81d5 100644 --- a/tables/players.tab +++ b/tables/players.tab @@ -4,6 +4,7 @@ CREATE TABLE xonstat.players nick character varying(128), stripped_nick character varying(128), "location" character varying(100), + email_addr character varying(255), active_ind boolean NOT NULL default true, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT players_pk PRIMARY KEY (player_id) -- 2.39.2