SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Table structure for table `pet_list` -- DROP TABLE IF EXISTS `pet_list`; CREATE TABLE IF NOT EXISTS `pet_list` ( `petid` int(10) unsigned NOT NULL, `name` char(15) NOT NULL, `poolid` int(10) unsigned NOT NULL DEFAULT '0', `minLevel` tinyint(2) unsigned NOT NULL DEFAULT '0', `maxLevel` tinyint(2) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', `element` tinyint(3) unsigned NOT NULL DEFAULT '0', `damageType` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`petid`) ) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- damageType ENUMs -- NONE = 0, -- PIERCING = 1, -- SLASHING = 2, -- IMPACT = 3, -- HTH = 4, INSERT INTO `pet_list` VALUES (0,'FireSpirit',5830,1,99,0,1,2); INSERT INTO `pet_list` VALUES (1,'IceSpirit',5831,1,99,0,2,2); INSERT INTO `pet_list` VALUES (2,'AirSpirit',5832,1,99,0,3,2); INSERT INTO `pet_list` VALUES (3,'EarthSpirit',5833,1,99,0,4,2); INSERT INTO `pet_list` VALUES (4,'ThunderSpirit',5834,1,99,0,5,2); INSERT INTO `pet_list` VALUES (5,'WaterSpirit',5835,1,99,0,6,2); INSERT INTO `pet_list` VALUES (6,'LightSpirit',5836,1,99,0,7,2); INSERT INTO `pet_list` VALUES (7,'DarkSpirit',5837,1,99,0,8,2); INSERT INTO `pet_list` VALUES (8,'Carbuncle',4588,1,99,0,7,2); INSERT INTO `pet_list` VALUES (9,'Fenrir',4581,1,99,0,8,2); INSERT INTO `pet_list` VALUES (10,'Ifrit',4582,1,99,0,1,2); INSERT INTO `pet_list` VALUES (11,'Titan',4583,1,99,0,4,2); INSERT INTO `pet_list` VALUES (12,'Leviathan',4584,1,99,0,6,2); INSERT INTO `pet_list` VALUES (13,'Garuda',4585,1,99,0,3,2); INSERT INTO `pet_list` VALUES (14,'Shiva',4586,1,99,0,2,2); INSERT INTO `pet_list` VALUES (15,'Ramuh',4587,1,99,0,5,2); INSERT INTO `pet_list` VALUES (16,'Diabolos',4590,1,99,0,8,2); INSERT INTO `pet_list` VALUES (17,'Alexander',4589,1,99,0,7,2); INSERT INTO `pet_list` VALUES (18,'Odin',4591,1,99,0,8,2); INSERT INTO `pet_list` VALUES (19,'Atomos',7297,1,99,0,8,2); INSERT INTO `pet_list` VALUES (20,'Cait Sith',5775,1,99,0,7,2); INSERT INTO `pet_list` VALUES (21,'SheepFamiliar',4598,23,35,3600,0,3); INSERT INTO `pet_list` VALUES (22,'HareFamiliar',4641,23,35,5400,0,3); INSERT INTO `pet_list` VALUES (23,'CrabFamiliar',4610,23,55,1800,0,3); INSERT INTO `pet_list` VALUES (24,'CourierCarrie',4611,23,75,1800,0,3); INSERT INTO `pet_list` VALUES (25,'Homunculus',4616,23,75,3600,0,3); INSERT INTO `pet_list` VALUES (26,'FlytrapFamiliar',4619,28,40,3600,0,3); INSERT INTO `pet_list` VALUES (27,'TigerFamiliar',4604,28,40,3600,0,3); INSERT INTO `pet_list` VALUES (28,'FlowerpotBill',4602,28,40,3600,0,3); INSERT INTO `pet_list` VALUES (29,'EftFamiliar',4621,33,45,3600,0,3); INSERT INTO `pet_list` VALUES (30,'LizardFamiliar',4600,33,45,3600,0,3); INSERT INTO `pet_list` VALUES (31,'MayflyFamiliar',4596,33,45,3600,0,3); INSERT INTO `pet_list` VALUES (32,'FunguarFamiliar',4614,33,65,3600,0,3); INSERT INTO `pet_list` VALUES (33,'BeetleFamiliar',4606,38,45,3600,0,3); INSERT INTO `pet_list` VALUES (34,'AntlionFamiliar',4625,38,50,3600,0,3); INSERT INTO `pet_list` VALUES (35,'MiteFamiliar',4623,43,55,3600,0,3); INSERT INTO `pet_list` VALUES (36,'LullabyMelodia',4599,43,55,3600,0,3); INSERT INTO `pet_list` VALUES (37,'KeenearedSteffi',4595,43,55,5400,0,3); INSERT INTO `pet_list` VALUES (38,'FlowerpotBen',4603,51,63,3600,0,3); INSERT INTO `pet_list` VALUES (39,'SaberSiravarde',4605,51,63,3600,0,3); INSERT INTO `pet_list` VALUES (40,'ColdbloodComo',4601,53,65,3600,0,3); INSERT INTO `pet_list` VALUES (41,'ShellbusterOrob',4597,53,65,3600,0,3); INSERT INTO `pet_list` VALUES (42,'VoraciousAudrey',4620,53,75,3600,0,3); INSERT INTO `pet_list` VALUES (43,'AmbusherAllie',4622,58,75,3600,0,3); INSERT INTO `pet_list` VALUES (44,'LifedrinkerLars',4624,63,75,3600,0,3); INSERT INTO `pet_list` VALUES (45,'PanzerGalahad',4607,63,75,3600,0,3); INSERT INTO `pet_list` VALUES (46,'ChopsueyChucky',4626,63,85,3600,0,3); INSERT INTO `pet_list` VALUES (47,'AmigoSabotender',4618,75,85,1800,0,3); INSERT INTO `pet_list` VALUES (48,'Wyvern',5551,1,99,0,0,2); INSERT INTO `pet_list` VALUES (49,'CraftyClyvonne',4608,76,90,7200,0,2); INSERT INTO `pet_list` VALUES (50,'BloodclawShasr',4609,90,99,7200,0,2); INSERT INTO `pet_list` VALUES (51,'LuckyLulush',4612,76,99,7200,0,2); INSERT INTO `pet_list` VALUES (52,'FatsoFargann',4613,81,99,7200,0,2); INSERT INTO `pet_list` VALUES (53,'DiscreetLouise',4615,79,99,7200,0,2); INSERT INTO `pet_list` VALUES (54,'SwiftSieghard',4617,86,94,7200,0,2); INSERT INTO `pet_list` VALUES (55,'DipperYuly',4627,76,99,7200,0,2); INSERT INTO `pet_list` VALUES (56,'FlowerpotMerle',4628,76,99,10800,0,3); INSERT INTO `pet_list` VALUES (57,'NurseryNazuna',4629,76,86,7200,0,2); INSERT INTO `pet_list` VALUES (58,'MailbusterCeta',4630,85,95,7200,0,2); INSERT INTO `pet_list` VALUES (59,'AudaciousAnna',4631,85,95,7200,0,2); INSERT INTO `pet_list` VALUES (60,'PrestoJulio',4632,83,93,7200,0,2); INSERT INTO `pet_list` VALUES (61,'BugeyedBroncha',4633,90,99,7200,0,2); INSERT INTO `pet_list` VALUES (62,'GooeyGerard',4634,95,99,5400,0,2); INSERT INTO `pet_list` VALUES (63,'GorefangHobs',4635,93,99,7200,0,2); INSERT INTO `pet_list` VALUES (64,'FaithfulFalcor',4636,86,99,7200,0,2); INSERT INTO `pet_list` VALUES (65,'CrudeRaphie',4637,96,99,5400,0,2); INSERT INTO `pet_list` VALUES (66,'DapperMac',4638,76,99,7200,0,3); INSERT INTO `pet_list` VALUES (67,'SlipperySilas',4639,23,99,1800,0,2); INSERT INTO `pet_list` VALUES (68,'TurbidToloi',4640,75,99,7200,0,2); INSERT INTO `pet_list` VALUES (69,'HarlequinFrame',5124,1,99,0,0,3); INSERT INTO `pet_list` VALUES (70,'ValoredgeFrame',5125,1,99,0,0,2); INSERT INTO `pet_list` VALUES (71,'SharpshotFrame',5126,1,99,0,0,3); INSERT INTO `pet_list` VALUES (72,'StormwakerFrame',5127,1,99,0,0,3); -- INSERT INTO `pet_list` VALUES (73, 'AdventuringFellow', 0, 1, 99, 0, 0); -- 74 is Chocobo in the enum.. INSERT INTO `pet_list` VALUES (75,'Luopan',6040,1,99,0,0,0); INSERT INTO `pet_list` VALUES (76,'Siren',7047,1,99,0,3,2); INSERT INTO `pet_list` VALUES (77,'SweetCaroline',7500,99,119,7200,0,3); INSERT INTO `pet_list` VALUES (78,'AmiableRoche',7501,99,110,7200,0,2); -- nat max 110, merit max 110 INSERT INTO `pet_list` VALUES (79,'HeadbreakerKen',7502,99,115,7200,0,2); -- nat max 115, merit max 115 INSERT INTO `pet_list` VALUES (80,'AnklebiterJedd',7503,99,116,7200,0,2); -- nat max 116, merit max 116 INSERT INTO `pet_list` VALUES (81,'CursedAnnabelle',7504,99,118,7200,0,2); -- nat max 118, merit max 118 INSERT INTO `pet_list` VALUES (82,'BrainyWaluis',7505,99,113,7200,0,2); -- nat max 113, merit max 113 INSERT INTO `pet_list` VALUES (83,'SlimeFamiliar',7506,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (84,'SultryPatrice',7507,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (85,'GenerousArthur',7508,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (86,'RedolentCandi',7509,99,115,7200,0,2); -- nat max 115, merit max 119 INSERT INTO `pet_list` VALUES (87,'AlluringHoney',7510,99,115,7200,0,2); -- nat max 115, merit max 119 INSERT INTO `pet_list` VALUES (88,'LynxFamiliar',7511,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (89,'VivaciousGaston',7512,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (90,'CaringKiyomaro',7513,99,116,7200,0,3); -- nat max 116, merit max 119 INSERT INTO `pet_list` VALUES (91,'VivaciousVickie',7514,99,116,7200,0,3); -- nat max 116, merit max 119 INSERT INTO `pet_list` VALUES (92,'SuspiciousAlice',7515,99,113,7200,0,2); -- nat max 113, merit max 113 INSERT INTO `pet_list` VALUES (93,'SurgingStorm',7516,99,118,7200,0,3); -- nat max 118, merit max 119 INSERT INTO `pet_list` VALUES (94,'SubmergedIyo',7517,99,118,7200,0,3); -- nat max 118, merit max 119 INSERT INTO `pet_list` VALUES (95,'WarlikePatrick',7518,99,104,7200,0,2); -- nat max 104, merit max 104 INSERT INTO `pet_list` VALUES (96,'RhymingShizuna',7519,99,107,7200,0,2); -- nat max 107, merit max 107 INSERT INTO `pet_list` VALUES (97,'BlackbeardRandy',7520,99,117,7200,0,2); -- nat max 117, merit max 117 INSERT INTO `pet_list` VALUES (98,'ThreestarLynn',7521,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (99,'HurlerPercival',7522,99,116,7200,0,2); -- nat max 116, merit max 116 INSERT INTO `pet_list` VALUES (100,'AcuexFamiliar',7523,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (101,'FluffyBredo',7524,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (102,'WeevilFamiliar',7525,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (103,'StalwartAngelina',7526,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (104,'FleetReinhard',7527,99,117,7200,0,2); -- nat max 117, merit max 117 INSERT INTO `pet_list` VALUES (105,'SharpwitHermes',7528,99,119,7200,0,3); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (106,'P.CrabFamiliar',7529,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (107,'JovialEdwin',7530,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (108,'AttentiveIbuki',7531,99,109,7200,0,2); -- nat max 109, merit max 119 INSERT INTO `pet_list` VALUES (109,'SwoopingZhivago',7532,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (110,'SunburstMalfik',7533,99,104,7200,0,2); -- nat max 104, merit max 119 INSERT INTO `pet_list` VALUES (111,'AgedAngus',7534,99,104,7200,0,2); -- nat max 104, merit max 119 INSERT INTO `pet_list` VALUES (112,'ScissorlegXerin',7535,99,105,7200,0,2); -- nat max 105, merit max 119 INSERT INTO `pet_list` VALUES (113,'BouncingBertha',7536,99,105,7200,0,2); -- nat max 105, merit max 119 INSERT INTO `pet_list` VALUES (114,'SpiderFamiliar',7537,99,118,7200,0,2); -- nat max 118, merit max 119 INSERT INTO `pet_list` VALUES (115,'GussyHachirobe',7538,99,118,7200,0,2); -- nat max 118, merit max 119 INSERT INTO `pet_list` VALUES (116,'ColibriFamiliar',7539,99,117,7200,0,2); -- nat max 117, merit max 119 INSERT INTO `pet_list` VALUES (117,'ChoralLeera',7540,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (118,'DroopyDortwin',7541,99,103,7200,0,2); -- nat max 103, merit max 119 INSERT INTO `pet_list` VALUES (119,'PonderingPeter',7542,99,103,7200,0,2); -- nat max 103, merit max 119 INSERT INTO `pet_list` VALUES (120,'HeraldHenry',7543,99,113,7200,0,2); -- nat max 113, merit max 113 INSERT INTO `pet_list` VALUES (121,'Hip.Familiar',7544,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (122,'DaringRoland',7545,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (123,'MosquitoFamiliar',7546,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (124,'Left-HandedYoko',7547,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (125,'BraveHeroGlenn',7548,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (126,'Y.BeetleFamiliar',7549,99,119,7200,0,2); -- nat max 119, merit max 119 INSERT INTO `pet_list` VALUES (127,'EnergizedSefina',7550,99,119,7200,0,2); -- nat max 119, merit max 119