From 584563d4c71892f27f78ad0ce751b9cbe10316af Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Tue, 26 Apr 2011 21:25:30 -0400 Subject: [PATCH] Align weapon codes with what is emitted in the stats code. --- build/build_full.sql | 25 +++++++++++++------------ tables/cd_weapon.tab | 2 +- 2 files changed, 14 insertions(+), 13 deletions(-) diff --git a/build/build_full.sql b/build/build_full.sql index eb22d6e..76ca005 100644 --- a/build/build_full.sql +++ b/build/build_full.sql @@ -69,20 +69,21 @@ insert into cd_game_type(game_type_cd, descr) values('tdm', 'Team Deathmatch'); -- weapons -insert into cd_weapon(weapon_cd, descr) values('lsr', 'Laser'); -insert into cd_weapon(weapon_cd, descr) values('shg', 'Shotgun'); +insert into cd_weapon(weapon_cd, descr) values('laser', 'Laser'); +insert into cd_weapon(weapon_cd, descr) values('sg', 'Shotgun'); insert into cd_weapon(weapon_cd, descr) values('uzi', 'Uzi'); -insert into cd_weapon(weapon_cd, descr) values('mrt', 'Mortar'); -insert into cd_weapon(weapon_cd, descr) values('elc', 'Electro'); -insert into cd_weapon(weapon_cd, descr) values('cry', 'Crylink'); +insert into cd_weapon(weapon_cd, descr) values('gl', 'Mortar'); +insert into cd_weapon(weapon_cd, descr) values('electro', 'Electro'); +insert into cd_weapon(weapon_cd, descr) values('crylink', 'Crylink'); insert into cd_weapon(weapon_cd, descr) values('nex', 'Nex'); -insert into cd_weapon(weapon_cd, descr) values('hgr', 'Hagar'); -insert into cd_weapon(weapon_cd, descr) values('rkt', 'Rocket Launcher'); -insert into cd_weapon(weapon_cd, descr) values('pol', 'Port-O-Launch'); -insert into cd_weapon(weapon_cd, descr) values('mns', 'MinstaNex'); -insert into cd_weapon(weapon_cd, descr) values('grp', 'Grappling Hook'); -insert into cd_weapon(weapon_cd, descr) values('hlc', 'Heavy Laser Assault Cannon'); -insert into cd_weapon(weapon_cd, descr) values('tag', 'T.A.G. Seeker'); +insert into cd_weapon(weapon_cd, descr) values('hagar', 'Hagar'); +insert into cd_weapon(weapon_cd, descr) values('rl', 'Rocket Launcher'); +insert into cd_weapon(weapon_cd, descr) values('minstanex', 'MinstaNex'); +insert into cd_weapon(weapon_cd, descr) values('rifle', 'Camping Rifle'); +insert into cd_weapon(weapon_cd, descr) values('fireball', 'Fireball'); +insert into cd_weapon(weapon_cd, descr) values('minelayer', 'Minelayer'); +insert into cd_weapon(weapon_cd, descr) values('seeker', 'T.A.G. Seeker'); +insert into cd_weapon(weapon_cd, descr) values('tuba', '@#!%''n Tuba'); -- achievements insert into cd_achievement(achievement_cd, descr, active_ind) diff --git a/tables/cd_weapon.tab b/tables/cd_weapon.tab index 72c9b1d..5b088ed 100644 --- a/tables/cd_weapon.tab +++ b/tables/cd_weapon.tab @@ -1,6 +1,6 @@ CREATE TABLE xonstat.cd_weapon ( - weapon_cd character varying(3) NOT NULL, + weapon_cd character varying(15) NOT NULL, descr character varying(100) NOT NULL, active_ind boolean NOT NULL DEFAULT true, CONSTRAINT cd_weapon_pk PRIMARY KEY (weapon_cd) -- 2.39.2