X-Git-Url: http://de.git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=blobdiff_plain;f=tables%2Fplayers.tab;h=57e81d52f3b50bed203839a8813d27d47952ed09;hp=26c212a567fd1fa8c831cb6a99b6031ea3a66ce7;hb=2f026e4afe1d96d4c3ef28dbfb4262c60b51bb7c;hpb=32ac8e3fe4d0d14b568206e1a17790b631d9a2bc diff --git a/tables/players.tab b/tables/players.tab old mode 100644 new mode 100755 index 26c212a..57e81d5 --- 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)