createmonsterinfo.sql

来自「天之炼狱OpenDE_SQL.tar.gz」· SQL 代码 · 共 476 行 · 第 1/5 页

-- MySQL dump 8.22
--
-- Host: 61.78.53.167    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Table structure for table 'MonsterInfo'
--

DROP TABLE IF EXISTS MonsterInfo;

CREATE TABLE MonsterInfo (
  MType smallint(5) unsigned NOT NULL default '0',
  SType smallint(5) unsigned NOT NULL default '0',
  HName varchar(30) NOT NULL default '',
  EName varchar(30) NOT NULL default '',
  Level tinyint(3) unsigned default NULL,
  STR tinyint(3) unsigned default NULL,
  DEX tinyint(3) unsigned default NULL,
  INTE tinyint(3) unsigned default NULL,
  BSize tinyint(4) default NULL,
  Fame int(10) unsigned default '0',
  Exp int(10) unsigned default '0',
  MColor tinyint(3) unsigned default '1',
  SColor tinyint(3) unsigned default '1',
  Align tinyint(3) unsigned default NULL,
  AOrder tinyint(3) unsigned default NULL,
  Moral tinyint(3) unsigned default NULL,
  Delay smallint(5) unsigned default NULL,
  ADelay smallint(5) unsigned default NULL,
  Sight tinyint(3) unsigned default NULL,
  MeleeRange int(10) unsigned default '1',
  MissileRange int(10) unsigned default '6',
  RegenPortal int(10) unsigned default '0',
  RegenInvisible int(10) unsigned default '0',
  RegenBat int(10) unsigned default '0',
  UnburrowChance int(10) unsigned default '128',
  MMode enum('WALK','FLY','BURROW') default NULL,
  AIType tinyint(3) unsigned default NULL,
  Enhance text,
  SlayerTreasure longtext,
  VampireTreasure longtext,
  Master tinyint(4) NOT NULL default '0',
  ClanType tinyint(4) NOT NULL default '1',
  MonsterSummonInfo text,
  DefaultEffects text,
  Chief       tinyint NOT NULL default 0,
  NormalRegen tinyint(4) NOT NULL default '1',
  HasTreasure tinyint NOT NULL default 1,
  PRIMARY KEY  (MType)
) TYPE=MyISAM;

--
-- Dumping data for table 'MonsterInfo'
--

INSERT INTO MonsterInfo VALUES (4,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (29,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (30,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (31,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (32,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (33,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (34,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (35,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (36,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (37,5,'死尸','Dead Body',1,10,10,1,1,0,0,1,1,1,0,6,750,775,5,1,6,0,0,0,128,'WALK',0,'','','',0,1,'','',0, 1, 1);

INSERT INTO MonsterInfo VALUES (5,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (38,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (39,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (40,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (41,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (42,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (43,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (44,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (45,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (46,8,'丧尸','Turning Dead',1,15,10,1,1,0,0,1,1,2,4,7,750,775,6,1,6,0,0,0,128,'WALK',1,'','','',0,1,'','',0, 1, 1);

INSERT INTO MonsterInfo VALUES (7,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (56,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (57,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (58,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (59,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (60,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (61,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (62,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (63,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (64,7,'返魂尸','Turning Soul',1,20,10,1,1,0,0,1,1,2,4,8,750,775,7,1,6,0,0,0,128,'WALK',3,'','','',0,1,'','',0, 1, 1);

INSERT INTO MonsterInfo VALUES (6,6,'感染者','Kid',2,30,20,10,1,0,0,1,1,2,4,9,750,775,8,1,6,0,0,0,128,'WALK',2,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (47,6,'感染者','Kid',2,30,20,10,1,0,0,1,1,2,4,9,750,775,8,1,6,0,0,0,128,'WALK',2,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (48,6,'感染者','Kid',2,30,20,10,1,0,0,1,1,2,4,9,750,775,8,1,6,0,0,0,128,'WALK',2,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (49,6,'感染者','Kid',2,30,20,10,1,0,0,1,1,2,4,9,750,775,8,1,6,0,0,0,128,'WALK',2,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (50,6,'感染者','Kid',2,30,20,10,1,0,0,1,1,2,4,9,750,775,8,1,6,0,0,0,128,'WALK',2,'','','',0,1,'','',0, 1, 1);
INSERT INTO MonsterInfo VALUES (51,6,'感染者','Kid',2,30,20,10,1,0,0,1,1,2,4,9,750,775,8,1,6,0,0,0,128,'WALK',2,'','','',0,1,'','',0, 1, 1);