X-Git-Url: http://git.xonotic.org/?a=blobdiff_plain;f=tables%2Fplayer_weapon_stats.tab;h=ab041d490950194ef607a8a3cdbea4e422dac6e7;hb=HEAD;hp=2e1990935d59075a824bbd2d82bcee51e054e0f7;hpb=db3b17feff84d3089d6e06f47740d6b26a12b10d;p=xonotic%2Fxonstatdb.git

diff --git a/tables/player_weapon_stats.tab b/tables/player_weapon_stats.tab
deleted file mode 100644
index 2e19909..0000000
--- a/tables/player_weapon_stats.tab
+++ /dev/null
@@ -1,26 +0,0 @@
-CREATE TABLE xonstat.player_weapon_stats
-(
-  player_weapon_stats_id bigserial NOT NULL,
-  player_id integer NOT NULL,
-  game_id bigint NOT NULL,
-  weapon_cd character varying(3) NOT NULL,
-  actual integer NOT NULL,
-  max integer NOT NULL,
-  frags integer NOT NULL,
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
-  CONSTRAINT player_weapon_stats_pk PRIMARY KEY (player_weapon_stats_id),
-  CONSTRAINT player_weapon_stats_fk001 FOREIGN KEY (player_id)
-      REFERENCES xonstat.players (player_id) MATCH SIMPLE
-      ON UPDATE NO ACTION ON DELETE NO ACTION,
-  CONSTRAINT player_weapon_stats_fk002 FOREIGN KEY (game_id)
-      REFERENCES xonstat.games (game_id) MATCH SIMPLE
-      ON UPDATE NO ACTION ON DELETE NO ACTION,
-  CONSTRAINT player_weapon_stats_fk003 FOREIGN KEY (weapon_cd)
-      REFERENCES xonstat.cd_weapon (weapon_cd) MATCH SIMPLE
-      ON UPDATE NO ACTION ON DELETE NO ACTION,
-  CONSTRAINT player_weapon_stats_uk001 UNIQUE (player_id, game_id, weapon_cd)
-)
-WITH (
-  OIDS=FALSE
-);
-ALTER TABLE xonstat.player_weapon_stats OWNER TO xonstat;