All pastes #468788 Raw Edit

Untitled

public text v1 · immutable
·published 2007-05-03 11:05 UTC
rendered paste body
Loading Creature Reputation OnKill Data...
SQL: SELECT `creature_id`,`RewOnKillRepFaction1`,`RewOnKillRepFaction2`,`IsTeamAward1`,`MaxStanding1`,`RewOnKillRepValue1`,`IsTeamAward2`,`MaxStanding2`,`RewOnKillRepValue2`,`TeamDependent` FROM `creature_onkill_reputation`
query ERROR: Unknown column 'TeamDependent' in 'field list'
[**************************************************] 100%  
>> Loaded 0 creature award reputation definitions. DB table `creature_onkill_reputation` is empty.


execute this by console 

ALTER TABLE `creature_onkill_reputation` 
  CHANGE COLUMN `MaxStanding1` `MaxStanding1` tinyint(1) default '0',
  CHANGE COLUMN `IsTeamAward1` `IsTeamAward1` tinyint(1) default '0',
  CHANGE COLUMN `MaxStanding2` `MaxStanding2` tinyint(1) default '0',
  CHANGE COLUMN `IsTeamAward2` `IsTeamAward2` tinyint(1) default '0',
  ADD COLUMN `TeamDependent` tinyint(1) unsigned NOT NULL default '0' AFTER `RewOnKillRepValue2`;