From 63d4d01025b0436db01dd9df2dce313e4db0014f Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sun, 6 Mar 2011 16:00:14 -0500 Subject: [PATCH] Change foreign keys from serial to integer. --- tables/achievements.tab | 2 +- tables/hashkeys.tab | 2 +- tables/player_weapon_stats.tab | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/tables/achievements.tab b/tables/achievements.tab index 2ad5c2e..1ce2cde 100644 --- a/tables/achievements.tab +++ b/tables/achievements.tab @@ -2,7 +2,7 @@ CREATE TABLE xonstat.achievements ( achievement_id serial NOT NULL, achievement_cd integer NOT NULL, - player_id serial NOT NULL, + player_id integer NOT NULL, create_dt timestamp with time zone NOT NULL DEFAULT now(), CONSTRAINT achievements_pk PRIMARY KEY (achievement_id), CONSTRAINT achievements_fk001 FOREIGN KEY (achievement_cd) diff --git a/tables/hashkeys.tab b/tables/hashkeys.tab index 6d7fd88..b39409a 100644 --- a/tables/hashkeys.tab +++ b/tables/hashkeys.tab @@ -1,6 +1,6 @@ CREATE TABLE xonstat.hashkeys ( - player_id serial NOT NULL, + player_id integer NOT NULL, hashkey character varying(44) NOT NULL, active_ind boolean NOT NULL DEFAULT true, create_dt timestamp with time zone NOT NULL DEFAULT now(), diff --git a/tables/player_weapon_stats.tab b/tables/player_weapon_stats.tab index 4b328e3..07a8ca5 100644 --- a/tables/player_weapon_stats.tab +++ b/tables/player_weapon_stats.tab @@ -1,7 +1,7 @@ CREATE TABLE xonstat.player_weapon_stats ( player_weapon_stats_id serial NOT NULL, - player_id serial NOT NULL, + player_id integer NOT NULL, game_id bigint NOT NULL, weapon_cd character varying(3) NOT NULL, actual integer NOT NULL, -- 2.39.2