createpotioninfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreatePotionInfo.sql
#  Description : 
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS PotionInfo;

CREATE TABLE PotionInfo (
  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',
  Effect varchar(50) NOT NULL default '',

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



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

INSERT INTO PotionInfo VALUES (0,'微型血瓶','Mini Healing Ampul',100,1,2,50000,0,'(HP,10,2,1)');
INSERT INTO PotionInfo VALUES (1,'小型血瓶','Light Healing Ampul',300,1,2,12500,1,'(HP,24,2,2)');
INSERT INTO PotionInfo VALUES (2,'中型血瓶','Half Healing Ampul',800,1,2,2500,2,'(HP,51,2,3)');
INSERT INTO PotionInfo VALUES (3,'巨型血瓶','Large Healing Ampul',2000,1,2,500,3,'(HP,100,2,4)');
INSERT INTO PotionInfo VALUES (4,'满血瓶','Full Healing Ampul',5000,1,2,100,4,'(HP,200,2,5)');
INSERT INTO PotionInfo VALUES (5,'微型魔法瓶','Mini Mana Ampul',30,1,2,50000,0,'(MP,10,2,2)');
INSERT INTO PotionInfo VALUES (6,'小型魔法瓶','Light Mana Ampul',100,1,2,12500,1,'(MP,24,2,4)');
INSERT INTO PotionInfo VALUES (7,'中型魔法瓶','Half Mana Ampul',300,1,2,2500,2,'(MP,51,2,6)');
INSERT INTO PotionInfo VALUES (8,'巨型魔法瓶','Large Mana Ampul',1000,1,2,500,3,'(MP,100,2,8)');
INSERT INTO PotionInfo VALUES (9,'满魔法瓶','Full Mana Ampul',3000,1,2,100,4,'(MP,200,2,10)');
INSERT INTO PotionInfo VALUES (10,'神丹','Blue Candy',3000,1,2,100,4,'(HP,1000,1,1000)(MP,1000,1,1000)');
INSERT INTO PotionInfo VALUES (11,'白米蛋糕','White Rice Cake',800000,1,2,100,4,'(HP,1000,1,1000)(MP,1000,1,1000)');

INSERT INTO PotionInfo VALUES (12,'恢复药剂瓶','Healing Bottle',40000,1,2,100,4,'(HP,400,2,6)');
INSERT INTO PotionInfo VALUES (13,'魔法药剂瓶','Mana Bottle',12000,1,2,100,4,'(MP,400,2,12)');
INSERT INTO PotionInfo VALUES (14,'小剂量圣水','Small Holy Potion',1,1,1,0,0,'(HP,24,2,3)');
INSERT INTO PotionInfo VALUES (15,'中剂量圣水','Medium Holy Potion',1,1,1,0,0,'(HP,51,2,5)');
INSERT INTO PotionInfo VALUES (16,'大剂量圣水','Large Holy Potion',1,1,1,0,0,'(HP,100,2,6)');
INSERT INTO PotionInfo VALUES (17,'全剂量圣水','Full Holy Potion',1,1,1,0,0,'(HP,200,2,8)');