createskullinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : DB - Item Info
#
#  FileName    :  CreateSkullInfo.sql
#  Description :  霸烙惑狼 秦榜 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS SkullInfo;
CREATE TABLE SkullInfo (
  ItemType tinyint(3) unsigned NOT NULL default '0',
  Name varchar(30) NOT NULL default '',
  EName varchar(30) NOT NULL default '',
  Price int(10) unsigned NOT NULL default '0',
  Volume tinyint(3) unsigned NOT NULL default '0',
  Weight tinyint(3) unsigned NOT NULL default '0',
  Ratio int(11) NOT NULL default '0',
  ItemLevel tinyint(3) unsigned NOT NULL default '0',

  PRIMARY KEY(ItemType)

) TYPE=MyISAM;



################################################################################
# 牢郸胶 积己



################################################################################
# Sequence 积己



################################################################################
# 鼻茄 汲沥 



################################################################################
# 单捞磐 持扁

INSERT INTO SkullInfo VALUES (0,'骷髅','Skull',0,1,1,0,0);
INSERT INTO SkullInfo VALUES (1,'肮脏兽骷髅','Dirty Strider Head',6944,1,1,0,1);
INSERT INTO SkullInfo VALUES (2,'血术士骷髅','Blood Warlock Head',9720,1,1,0,2);
INSERT INTO SkullInfo VALUES (3,'异形骷髅','Mutant Head',4800,1,1,0,3);
INSERT INTO SkullInfo VALUES (4,'幽灵骷髅','Turning Soul Head',644,1,1,0,4);
INSERT INTO SkullInfo VALUES (5,'僵尸骷髅','Turning Dead Head',540,1,1,0,5);
INSERT INTO SkullInfo VALUES (6,'魔鬼骷髅','Kid Head',1296,1,1,0,6);
INSERT INTO SkullInfo VALUES (7,'队长骷髅','Captain Head',2520,1,1,0,7);
INSERT INTO SkullInfo VALUES (8,'艾克兽骷髅','Alkan Head',3120,1,1,0,8);
INSERT INTO SkullInfo VALUES (9,'士兵骷髅','Soldier Head',1800,1,1,0,9);
INSERT INTO SkullInfo VALUES (10,'红眼骷髅','Red Eye Head',3784,1,1,0,10);
INSERT INTO SkullInfo VALUES (11,'死尸骷髅','Dead Body Head',436,1,1,0,11);
INSERT INTO SkullInfo VALUES (12,'金色骷髅','Golden Skull',0,1,1,0,12);
INSERT INTO SkullInfo VALUES (13,'紫色骷髅','Purple Skull',0,1,1,0,13);
INSERT INTO SkullInfo VALUES (14,'黑色骷髅','Black Skull',0,1,1,0,14);
INSERT INTO SkullInfo VALUES (15,'水晶骷髅','Crystal Skull',0,1,1,0,15);
INSERT INTO SkullInfo VALUES (16,'绿色骷髅','Green Skull',0,1,1,0,16);
INSERT INTO SkullInfo VALUES (17,'破坏者骷髅','Vandalizer Head',6440,1,1,0,17);
INSERT INTO SkullInfo VALUES (18,'屠杀者骷髅','Crimson Slaughter Head',15540,1,1,0,18);
INSERT INTO SkullInfo VALUES (19,'铁牙骷髅','Iron Teeth Head',3800,1,1,0,19);
INSERT INTO SkullInfo VALUES (20,'莫地兽骷髅','Moderas Skull',4800,1,1,0,19);
INSERT INTO SkullInfo VALUES (21,'食人兽骷髅','Estroider Skull',7200,1,1,0,19);
INSERT INTO SkullInfo VALUES (22,'女鬼骷髅','Widows Skull',8680,1,1,0,19);
INSERT INTO SkullInfo VALUES (23,'刀鬼骷髅','Hoble Skull',8248,1,1,0,19);
INSERT INTO SkullInfo VALUES (24,'巨型兽骷髅','Big Fang Skull',11952,1,1,0,19);
INSERT INTO SkullInfo VALUES (25,'傀儡骷髅','Golemer Skull',15600,1,1,0,19);
INSERT INTO SkullInfo VALUES (26,'飞影骷髅','Shadow Wing Skull',13528,1,1,0,19);
INSERT INTO SkullInfo VALUES (27,'割头者骷髅','Reaper Skull',16076,1,1,0,19);
INSERT INTO SkullInfo VALUES (28,'混乱骑士骷髅','Chaos Knight Skull',19908,1,1,0,19);
INSERT INTO SkullInfo VALUES (29,'男巫骷髅','Hell Wizard Skull',18892,1,1,0,19);
INSERT INTO SkullInfo VALUES (30,'黑魔骷髅','Dark Screamer Skull',19584,1,1,0,19);
INSERT INTO SkullInfo VALUES (31,'混乱使者骷髅','Chaos Gurdian Skull',24840,1,1,0,19);
INSERT INTO SkullInfo VALUES (32,'地狱使者骷髅','Hell Gurdian Skull',22740,1,1,0,19);
INSERT INTO SkullInfo VALUES (33,'暗黑帝王骷髅','Lord Darkness Skull',25000,1,1,0,19);
INSERT INTO SkullInfo VALUES (34,'暗黑守卫骷髅','Dark Guardian Skull',30000,1,1,0,19);
INSERT INTO SkullInfo VALUES (35,'领主骷髅','Lord Chaos Skull',32000,1,1,0,19);
INSERT INTO SkullInfo VALUES (36,'贪婪食者骷髅','Chaos Greed Head',34000,1,1,0,19);
INSERT INTO SkullInfo VALUES (37,'地狱魔王骷髅','Hell Fiend Skull',37000,1,1,0,19);
INSERT INTO SkullInfo VALUES (38,'黑雾骷髅','Dark Haze Skull',41000,1,1,0,19);

INSERT INTO SkullInfo VALUES (39,'追讨者之头','Dun Wolfarch Head',44500,1,1,0,20);
INSERT INTO SkullInfo VALUES (40,'利蒙之头','Mum Rimmon Head',48000,1,1,0,20);
INSERT INTO SkullInfo VALUES (41,'变异萨满之头','Shaman Oaf Head',51500,1,1,0,20);
INSERT INTO SkullInfo VALUES (42,'黑暗百瑞兹的头骨','Dark Berith Skull',58500,1,1,0,20);
INSERT INTO SkullInfo VALUES (43,'亡灵巫师的头骨','Lich Jel Skull',76000,1,1,0,20);
INSERT INTO SkullInfo VALUES (44,'岩石怪的头骨','Mount Crag Skull',72500,1,1,0,20);
INSERT INTO SkullInfo VALUES (45,'巨骨怪的头骨','Giant Os Skull',62000,1,1,0,20);
INSERT INTO SkullInfo VALUES (46,'石像怪的头骨','Dim Gargoyle Skull',55000,1,1,0,20);
INSERT INTO SkullInfo VALUES (47,'梅杜莎的头骨','Volva Medusa Skull',65500,1,1,0,20);
INSERT INTO SkullInfo VALUES (48,'阿撒巴洛德的头骨','Ash Balog Skull',69000,1,1,0,20);