Anonymous

/*MySQL Data TransferSource Host: localhostSource Database: testTarget Host: localhostTarget Database: testDate: 30.7.2007 16:28:37*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for botanica-- ----------------------------CREATE TABLE `botanica` (  `entry` int(11) unsigned NOT NULL default '0',  `modelid_m` int(11) unsigned default '0',  `modelid_f` int(11) unsigned default '0',  `name` varchar(100) NOT NULL default '0',  `subname` varchar(100) default NULL,  `minlevel` tinyint(3) unsigned default '1',  `maxlevel` tinyint(3) unsigned default '1',  `minhealth` int(5) unsigned default '0',  `maxhealth` int(5) unsigned default '0',  `minmana` int(5) unsigned default '0',  `maxmana` int(5) unsigned default '0',  `armor` int(10) unsigned NOT NULL default '0',  `faction` int(4) unsigned default '0',  `npcflag` int(4) unsigned default '0',  `speed` float default '0',  `rank` tinyint(3) unsigned default '0',  `mindmg` float default '0',  `maxdmg` float default '0',  `attackpower` int(10) unsigned NOT NULL default '0',  `baseattacktime` int(4) unsigned default '0',  `rangeattacktime` int(4) unsigned default '0',  `flags` int(11) unsigned default '0',  `dynamicflags` int(11) unsigned default '0',  `size` float default '0',  `family` int(11) default '0',  `bounding_radius` float default '0',  `trainer_type` tinyint(3) default '0',  `trainer_spell` int(11) unsigned default '0',  `class` tinyint(3) unsigned default '0',  `race` tinyint(3) unsigned default '0',  `minrangedmg` float NOT NULL default '0',  `maxrangedmg` float NOT NULL default '0',  `rangedattackpower` smallint(5) unsigned NOT NULL default '0',  `combat_reach` float NOT NULL default '0',  `type` tinyint(3) unsigned default '0',  `civilian` tinyint(3) unsigned NOT NULL default '0',  `flag1` int(11) unsigned default '0',  `equipmodel1` int(10) unsigned NOT NULL default '0',  `equipmodel2` int(10) unsigned NOT NULL default '0',  `equipmodel3` int(10) unsigned NOT NULL default '0',  `equipinfo1` int(10) unsigned NOT NULL default '0',  `equipinfo2` int(10) unsigned NOT NULL default '0',  `equipinfo3` int(10) unsigned NOT NULL default '0',  `equipslot1` int(11) NOT NULL default '0',  `equipslot2` int(11) NOT NULL default '0',  `equipslot3` int(11) NOT NULL default '0',  `lootid` int(10) unsigned NOT NULL default '0',  `pickpocketloot` int(10) unsigned NOT NULL default '0',  `skinloot` int(10) unsigned NOT NULL default '0',  `resistance1` int(10) unsigned NOT NULL default '0',  `resistance2` int(10) unsigned NOT NULL default '0',  `resistance3` int(10) unsigned NOT NULL default '0',  `resistance4` int(10) unsigned NOT NULL default '0',  `resistance5` int(10) unsigned NOT NULL default '0',  `resistance6` int(10) unsigned NOT NULL default '0',  `spell1` int(11) unsigned NOT NULL default '0',  `spell2` int(11) unsigned NOT NULL default '0',  `spell3` int(11) unsigned NOT NULL default '0',  `spell4` int(11) unsigned NOT NULL default '0',  `mingold` int(30) unsigned NOT NULL default '0',  `maxgold` int(30) unsigned NOT NULL default '0',  `AIName` varchar(128) NOT NULL default '',  `MovementType` tinyint(3) unsigned NOT NULL default '0',  `InhabitType` tinyint(1) unsigned NOT NULL default '3',  `RacialLeader` tinyint(1) unsigned NOT NULL default '0',  `ScriptName` varchar(128) NOT NULL default '',  PRIMARY KEY  (`entry`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- ------------------------------ Records -- ----------------------------INSERT INTO `botanica` VALUES ('19865', '18083', '0', 'Mutate Horror', '', '69', '71', '15000', '15000', '0', '0', '100', '168', '0', '1.71', '1', '1200', '1600', '6721', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '1', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19865', '100008', '0', '0', '0', '0', '0', '0', '0', '6016', '0', '0', '0', '0', '0', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19598', '19021', '0', 'Mutate Fleshlasher', '', '69', '71', '5200', '5200', '0', '0', '20', '168', '0', '1.48', '0', '1200', '1600', '6542', '1800', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '1', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19598', '100008', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('19843', '2019', '0', 'Nethervine Trickster', '', '69', '71', '22000', '22000', '0', '0', '100', '168', '0', '1.71', '1', '1200', '1600', '6125', '1300', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '3', '0', '32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19843', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4159', '5159', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('19513', '18082', '0', 'Mutate Fear-Shrieker', '', '69', '71', '15000', '15000', '0', '0', '100', '128', '0', '1.71', '1', '1100', '1500', '7783', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '1', '0', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19513', '100008', '0', '0', '0', '0', '0', '0', '0', '39176', '0', '0', '0', '0', '0', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19507', '17819', '0', 'Sunseeker Gene-Splicer', '', '69', '71', '15000', '15000', '7196', '7196', '100', '168', '0', '1.71', '1', '1300', '1700', '7014', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19507', '0', '0', '0', '0', '0', '0', '0', '0', '39658', '0', '0', '0', '4270', '4270', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('18587', '19030', '0', 'Frayer', null, '68', '69', '3400', '3600', '0', '0', '1766', '168', '0', '1.48', '0', '900', '1100', '7523', '1600', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18587', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('17993', '17773', '0', 'Bloodwarder Protector', null, '69', '70', '16000', '17000', '3080', '3155', '1901', '168', '0', '1.48', '1', '1200', '1600', '9591', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '3', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17993', '0', '0', '0', '0', '0', '0', '0', '0', '29765', '19645', '0', '0', '4150', '4150', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19557', '19029', '0', 'Greater Frayer', null, '69', '69', '8300', '8400', '0', '0', '1807', '168', '0', '1.48', '0', '950', '1150', '7456', '1500', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19557', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('18155', '19685', '0', 'Bloodfalcon', null, '69', '70', '13000', '13000', '0', '0', '1943', '168', '0', '1.48', '1', '1200', '1600', '7686', '1400', '1900', '0', '0', '1', '30', '2', '0', '0', '0', '0', '0', '0', '100', '3', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18155', '0', '0', '0', '0', '0', '0', '0', '0', '10483', '0', '0', '0', '0', '0', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('18419', '17883', '0', 'Bloodwarder Greenkeeper', null, '69', '70', '16000', '18000', '3080', '3155', '1943', '168', '0', '1.71', '1', '1000', '1400', '8275', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18419', '0', '0', '0', '0', '0', '0', '0', '0', '39121', '0', '0', '0', '4188', '4188', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('18404', '17813', '0', 'Bloodwarder Steward', null, '69', '70', '20000', '22000', '0', '0', '1943', '168', '0', '1.71', '1', '1400', '1800', '8281', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18404', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4034', '4034', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('18405', '18930', '0', 'Tempest-Forge Peacekeeper', null, '69', '70', '22000', '22000', '3155', '3155', '1943', '168', '0', '1.48', '1', '1400', '1800', '9613', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '3', '9', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18405', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('19633', '19051', '0', 'Bloodwarder Mender', null, '69', '70', '14000', '16000', '21093', '21588', '1943', '168', '0', '1.71', '1', '1000', '1200', '8735', '1500', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19633', '0', '0', '0', '0', '0', '0', '0', '0', '34119', '25367', '10947', '34809', '4130', '4130', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('18422', '17819', '0', 'Sunseeker Botanist', null, '70', '71', '17000', '17000', '9465', '9465', '1985', '168', '0', '1.71', '1', '1300', '1700', '7494', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18422', '0', '0', '0', '0', '0', '0', '0', '0', '27637', '27532', '0', '0', '4063', '4063', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('17994', '17779', '0', 'Bloodwarder Falconer', null, '70', '71', '21000', '22000', '0', '0', '1985', '168', '0', '1.71', '1', '1300', '1700', '9534', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17994', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('19509', '17819', '0', 'Sunseeker Harvester', null, '70', '71', '17000', '17000', '3155', '3231', '1985', '14', '0', '1.71', '1', '1300', '1700', '8534', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19509', '0', '0', '0', '0', '0', '0', '0', '0', '38896', '22127', '0', '0', '4039', '4039', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19486', '18925', '0', 'Sunseeker Chemist', null, '70', '71', '17000', '17000', '3155', '3155', '1985', '168', '0', '1.71', '1', '1200', '1600', '6746', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19486', '0', '0', '0', '0', '0', '0', '0', '0', '34358', '20712', '0', '0', '4039', '4039', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19608', '17714', '0', 'Frayer Wildling', null, '70', '70', '5100', '5100', '0', '0', '1848', '168', '0', '1.48', '0', '900', '1100', '6998', '1600', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19608', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', '3', '0', '');INSERT INTO `botanica` VALUES ('19508', '17819', '0', 'Sunseeker Herbalist', null, '70', '71', '21000', '21000', '0', '0', '1985', '14', '0', '1.71', '1', '1200', '1600', '7224', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19508', '0', '0', '0', '0', '0', '0', '0', '0', '20712', '0', '0', '0', '4035', '4035', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19511', '11331', '0', 'Nethervine Inciter', null, '70', '71', '21000', '21000', '0', '0', '1985', '168', '0', '1.71', '1', '1200', '1600', '9630', '1000', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '3', '0', '32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19511', '0', '0', '0', '0', '0', '0', '0', '0', '25810', '34616', '0', '0', '4193', '4193', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('18421', '17842', '0', 'Sunseeker Researcher', null, '70', '71', '17000', '17000', '9465', '9465', '1985', '14', '0', '1.71', '1', '1200', '1600', '9275', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18421', '0', '0', '0', '0', '0', '0', '0', '0', '39027', '34352', '39062', '39590', '4160', '4160', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19505', '17819', '0', 'Sunseeker Channeler', null, '70', '71', '15000', '15000', '7196', '7332', '1985', '168', '0', '1.71', '1', '1200', '1600', '9112', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19505', '0', '0', '0', '0', '0', '0', '0', '0', '34173', '34637', '0', '0', '4173', '4173', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('19512', '2878', '0', 'Nethervine Reaper', null, '70', '71', '21000', '21000', '0', '0', '1985', '128', '0', '1.71', '1', '1600', '2200', '8047', '1700', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '3', '0', '32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19512', '0', '0', '0', '0', '0', '0', '0', '0', '40505', '34626', '0', '0', '4270', '4271', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('17975', '19045', '0', 'High Botanist Freywinn', null, '72', '72', '93000', '93000', '49635', '49635', '2028', '168', '0', '1.71', '1', '1600', '2200', '10339', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17975', '17975', '0', '0', '0', '0', '0', '0', '0', '34550', '0', '0', '0', '3990', '3990', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('18420', '17916', '0', 'Sunseeker Geomancer', null, '71', '71', '24000', '24000', '12924', '12924', '2028', '168', '0', '1.71', '1', '1200', '1600', '9973', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '18420', '0', '0', '0', '0', '0', '0', '0', '0', '39348', '0', '0', '0', '4024', '4024', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('17978', '14416', '0', 'Thorngrin the Tender', null, '72', '72', '75000', '75000', '3309', '3309', '2071', '168', '0', '1.71', '1', '1600', '2200', '10496', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '3', '0', '32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17978', '17978', '0', '0', '0', '0', '0', '0', '0', '34661', '34660', '34670', '0', '3970', '3970', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('17977', '19438', '0', 'Warp Splinter', null, '72', '72', '130000', '130000', '0', '0', '2071', '168', '0', '1.48', '1', '1600', '2200', '8377', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '3', '4', '0', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17977', '0', '0', '0', '0', '0', '0', '0', '0', '16727', '37078', '0', '0', '3875', '3875', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('17976', '18929', '0', 'Commander Sarannis', null, '72', '72', '110000', '110000', '0', '0', '2071', '168', '0', '1.71', '1', '1600', '2200', '10112', '1400', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '7', '0', '32', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17976', '17976', '0', '0', '0', '0', '0', '0', '0', '24857', '0', '0', '0', '3940', '3940', '', '1', '3', '0', 'generic_creature');INSERT INTO `botanica` VALUES ('17980', '13109', '0', 'Laj', null, '72', '72', '120000', '120000', '0', '0', '2071', '168', '0', '1.71', '1', '1600', '2200', '8787', '1200', '1900', '0', '0', '1', '0', '2', '0', '0', '0', '0', '0', '0', '100', '0', '4', '0', '72', '0', '0', '0', '0', '0', '0', '0', '0', '0', '17980', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4210', '4210', '', '1', '3', '0', '');