Stuff

public text v1 · immutable
#458007
·published 2007-04-25 17:52 UTC
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for creature_onkill_reputation
-- ----------------------------
CREATE TABLE `creature_onkill_reputation` (
  `creature_id` int(10) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
  `RewOnKillRepFaction1` int(10) default '0',
  `RewOnKillRepFaction2` int(10) default '0',
  `MaxStanding1` int(1) default '0',
  `IsTeamAward1` int(1) default '0',
  `RewOnKillRepValue1` int(10) default '0',
  `MaxStanding2` int(1) default '0',
  `IsTeamAward2` int(1) default '0',
  `RewOnKillRepValue2` int(10) default '0',
  PRIMARY KEY  (`creature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain';

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `creature_onkill_reputation` VALUES ('2496', '87', '21', '5', '0', '5', '5', '0', '-375');
INSERT INTO `creature_onkill_reputation` VALUES ('3381', '470', '0', '4', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('3382', '470', '0', '4', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('3383', '470', '0', '4', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('3384', '470', '0', '4', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('4624', '87', '21', '5', '0', '25', '5', '1', '-125');
INSERT INTO `creature_onkill_reputation` VALUES ('8523', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8524', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11880', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15201', '609', '0', '6', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11881', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11803', '609', '0', '6', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11804', '609', '0', '6', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15200', '609', '0', '6', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14479', '609', '0', '7', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15542', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15541', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11883', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15213', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15308', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11882', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15202', '609', '0', '5', '0', '1', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15211', '609', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15209', '609', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15307', '609', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15212', '609', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15206', '609', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15207', '609', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15208', '609', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15220', '609', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15305', '609', '0', '7', '0', '50', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15204', '609', '0', '7', '0', '50', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('15205', '609', '0', '7', '0', '50', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1852', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11873', '529', '0', '7', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8550', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8530', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8557', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8558', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8555', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8556', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8526', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8542', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8532', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8528', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8539', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8544', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8531', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10825', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8541', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10821', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10826', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('16184', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8529', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8527', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('17878', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8525', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('4475', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10580', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1847', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1796', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('4472', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8534', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1802', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10801', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('4474', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1793', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1795', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1789', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1787', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1783', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1784', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1785', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1791', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1794', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('8543', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10698', '529', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1788', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('12263', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('12262', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('1805', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10383', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10411', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11197', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10391', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10390', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10388', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10387', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10389', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14514', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10481', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10485', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10491', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10488', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10489', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10480', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11598', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10413', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10412', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10407', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10385', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10406', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10382', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10414', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10405', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10381', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10408', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10409', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10463', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10384', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10464', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10478', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10498', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10500', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10499', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14511', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10486', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10487', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10497', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14513', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10495', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11284', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14512', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('16120', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14521', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14520', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14519', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14518', '529', '0', '6', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14684', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10436', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10416', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11058', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('16101', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10435', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10437', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11143', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10439', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('16102', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10809', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10516', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10808', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10417', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14861', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10506', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11622', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11286', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10433', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10505', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11261', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10901', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10507', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11439', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10503', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10502', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10504', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14695', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11551', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10432', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14516', '529', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11075', '529', '0', '6', '0', '15', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11076', '529', '0', '6', '0', '15', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11077', '529', '0', '6', '0', '15', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('11078', '529', '0', '6', '0', '15', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10440', '529', '0', '7', '0', '50', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10508', '529', '0', '7', '0', '50', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7157', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7156', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7158', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('9462', '576', '0', '7', '0', '15', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7154', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7155', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7153', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('9464', '576', '0', '7', '0', '15', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('14342', '576', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10916', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7440', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7442', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7441', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7439', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('7438', '576', '0', '5', '0', '5', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10199', '576', '0', '7', '0', '25', '0', '0', '0');
INSERT INTO `creature_onkill_reputation` VALUES ('10738', '576', '0', '7', '0', '25', '0', '0', '0');