createkeyinfo.sql

天之炼狱OpenDE_SQL.tar.gz

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


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

CREATE TABLE KeyInfo (
  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',
  OptionType tinyint(3) unsigned NOT NULL default '0',
  TargetType smallint(5) unsigned not null default 0,

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



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

INSERT INTO KeyInfo VALUES (0,'铜钥匙','Gilt Key',0,1,1,0,0,0);
INSERT INTO KeyInfo VALUES (1,'金钥匙','Gold Key',0,1,1,0,0,0);
INSERT INTO KeyInfo VALUES (2,'磁体钥匙','Magnet Key',0,1,1,0,0,0);
INSERT INTO KeyInfo VALUES (3,'特殊钥匙','Special Key',0,1,1,0,0,0);

INSERT INTO KeyInfo VALUES (4,'绿色Rubiate钥匙','Green Rubiate Key',0,1,1,0,10,5);
INSERT INTO KeyInfo VALUES (5,'蓝色Rubiate钥匙','Blue Rubiate Key',0,1,1,0,20,5);
INSERT INTO KeyInfo VALUES (6,'红色Rubiate钥匙','Red Rubiate Key',0,1,1,0,5,5);
INSERT INTO KeyInfo VALUES (7,'黄色Rubiate钥匙','Yellow Rubiate Key',0,1,1,0,31,5);
INSERT INTO KeyInfo VALUES (8,'橙色Rubiate钥匙','Orange Rubiate Key',0,1,1,0,161,5);
INSERT INTO KeyInfo VALUES (9,'天蓝色Rubiate钥匙','Sky Rubiate Key',0,1,1,0,35,5);
INSERT INTO KeyInfo VALUES (10,'淡紫色Rubiate钥匙','Lilac Rubiate Key',0,1,1,0,174,5);
INSERT INTO KeyInfo VALUES (11,'黑色Rubiate钥匙','Black Rubiate Key',0,1,1,0,50,5);