createdyepotioninfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateDyePotionInfo.sql
#  Description : 喊 酒捞袍 沥焊
#
#  History      Writer              Description
# ------------ --------------      -----------------------------------------------
# 2003.05.14    Bezz,DEW,Sequoia    脚痹 颇老 积己 
#
################################################################################


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

CREATE TABLE DyePotionInfo (
  ItemType 		tinyint(3) 	unsigned NOT NULL default '0',
  Name 			varchar(20)			 NOT NULL default '',
  EName 		varchar(20)			 NOT NULL default '',
  Price 		int(1) 	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',
  FunctionFlag  tinyint 	unsigned NOT NULL default '0',
  FunctionValue smallint 			 NOT NULL default '0',

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



################################################################################
# 单捞磐 持扁
INSERT INTO DyePotionInfo VALUES ( 0,  '染发剂 1',  'Hair-Dye 1',  800000, 1, 1, 0, 0, 0, 400);
INSERT INTO DyePotionInfo VALUES ( 1,  '染发剂 2',  'Hair-Dye 2',  800000, 1, 1, 0, 0, 0, 359);
INSERT INTO DyePotionInfo VALUES ( 2,  '染发剂 3',  'Hair-Dye 3',  800000, 1, 1, 0, 0, 0, 312);
INSERT INTO DyePotionInfo VALUES ( 3,  '染发剂 4',  'Hair-Dye 4',  800000, 1, 1, 0, 0, 0, 267);
INSERT INTO DyePotionInfo VALUES ( 4,  '染发剂 5',  'Hair-Dye 5',  800000, 1, 1, 0, 0, 0, 222);
INSERT INTO DyePotionInfo VALUES ( 5,  '染发剂 6',  'Hair-Dye 6',  800000, 1, 1, 0, 0, 0, 174);
INSERT INTO DyePotionInfo VALUES ( 6,  '染发剂 7',  'Hair-Dye 7',  800000, 1, 1, 0, 0, 0, 130);
INSERT INTO DyePotionInfo VALUES ( 7,  '染发剂 8',  'Hair-Dye 8',  800000, 1, 1, 0, 0, 0, 86);
INSERT INTO DyePotionInfo VALUES ( 8,  '染发剂 9',  'Hair-Dye 9',  800000, 1, 1, 0, 0, 0, 381);
INSERT INTO DyePotionInfo VALUES ( 9,  '染发剂 10', 'Hair-Dye 10', 800000, 1, 1, 0, 0, 0, 342);
INSERT INTO DyePotionInfo VALUES ( 10, '染发剂 11', 'Hair-Dye 11', 800000, 1, 1, 0, 0, 0, 297);
INSERT INTO DyePotionInfo VALUES ( 11, '染发剂 12', 'Hair-Dye 12', 800000, 1, 1, 0, 0, 0, 252);
INSERT INTO DyePotionInfo VALUES ( 12, '染发剂 13', 'Hair-Dye 13', 800000, 1, 1, 0, 0, 0, 207);
INSERT INTO DyePotionInfo VALUES ( 13, '染发剂 14', 'Hair-Dye 14', 800000, 1, 1, 0, 0, 0, 159);
INSERT INTO DyePotionInfo VALUES ( 14, '染发剂 15', 'Hair-Dye 15', 800000, 1, 1, 0, 0, 0, 115);
INSERT INTO DyePotionInfo VALUES ( 15, '染发剂 16', 'Hair-Dye 16', 800000, 1, 1, 0, 0, 0, 70);
INSERT INTO DyePotionInfo VALUES ( 16, '染发剂 17', 'Hair-Dye 17', 800000, 1, 1, 0, 0, 0, 369);
INSERT INTO DyePotionInfo VALUES ( 17, '染发剂 18', 'Hair-Dye 18', 800000, 1, 1, 0, 0, 0, 327);
INSERT INTO DyePotionInfo VALUES ( 18, '染发剂 19', 'Hair-Dye 19', 800000, 1, 1, 0, 0, 0, 283);
INSERT INTO DyePotionInfo VALUES ( 19, '染发剂 20', 'Hair-Dye 20', 800000, 1, 1, 0, 0, 0, 237);
INSERT INTO DyePotionInfo VALUES ( 20, '染发剂 21', 'Hair-Dye 21', 800000, 1, 1, 0, 0, 0, 193);
INSERT INTO DyePotionInfo VALUES ( 21, '染发剂 22', 'Hair-Dye 22', 800000, 1, 1, 0, 0, 0, 145);
INSERT INTO DyePotionInfo VALUES ( 22, '染发剂 23', 'Hair-Dye 23', 800000, 1, 1, 0, 0, 0, 101);
INSERT INTO DyePotionInfo VALUES ( 23, '染发剂 24', 'Hair-Dye 24', 800000, 1, 1, 0, 0, 0, 57);

INSERT INTO DyePotionInfo VALUES ( 24, '肤色转换剂 1',  'Skin-Dye 1',  800000, 1, 1, 0, 0, 1, 165);
INSERT INTO DyePotionInfo VALUES ( 25, '肤色转换剂 2',  'Skin-Dye 2',  800000, 1, 1, 0, 0, 1, 381);
INSERT INTO DyePotionInfo VALUES ( 26, '肤色转换剂 3',  'Skin-Dye 3',  800000, 1, 1, 0, 0, 1, 407);
INSERT INTO DyePotionInfo VALUES ( 27, '肤色转换剂 4',  'Skin-Dye 4',  800000, 1, 1, 0, 0, 1, 420);
INSERT INTO DyePotionInfo VALUES ( 28, '肤色转换剂 5',  'Skin-Dye 5',  800000, 1, 1, 0, 0, 1, 435);
INSERT INTO DyePotionInfo VALUES ( 29, '肤色转换剂 6',  'Skin-Dye 6',  800000, 1, 1, 0, 0, 1, 451);
INSERT INTO DyePotionInfo VALUES ( 30, '肤色转换剂 7',  'Skin-Dye 7',  800000, 1, 1, 0, 0, 1, 466);
INSERT INTO DyePotionInfo VALUES ( 31, '肤色转换剂 8',  'Skin-Dye 8',  800000, 1, 1, 0, 0, 1, 480);
INSERT INTO DyePotionInfo VALUES ( 32, '肤色转换剂 9',  'Skin-Dye 9',  800000, 1, 1, 0, 0, 1, 170);
INSERT INTO DyePotionInfo VALUES ( 33, '肤色转换剂 10', 'Skin-Dye 10', 800000, 1, 1, 0, 0, 1, 364);
INSERT INTO DyePotionInfo VALUES ( 34, '肤色转换剂 11', 'Skin-Dye 11', 800000, 1, 1, 0, 0, 1, 412);
INSERT INTO DyePotionInfo VALUES ( 35, '肤色转换剂 12', 'Skin-Dye 12', 800000, 1, 1, 0, 0, 1, 426);
INSERT INTO DyePotionInfo VALUES ( 36, '肤色转换剂 13', 'Skin-Dye 13', 800000, 1, 1, 0, 0, 1, 440);
INSERT INTO DyePotionInfo VALUES ( 37, '肤色转换剂 14', 'Skin-Dye 14', 800000, 1, 1, 0, 0, 1, 455);
INSERT INTO DyePotionInfo VALUES ( 38, '肤色转换剂 15', 'Skin-Dye 15', 800000, 1, 1, 0, 0, 1, 471);
INSERT INTO DyePotionInfo VALUES ( 39, '肤色转换剂 16', 'Skin-Dye 16', 800000, 1, 1, 0, 0, 1, 487);
INSERT INTO DyePotionInfo VALUES ( 40, '肤色转换剂 17', 'Skin-Dye 17', 800000, 1, 1, 0, 0, 1, 179);
INSERT INTO DyePotionInfo VALUES ( 41, '肤色转换剂 18', 'Skin-Dye 18', 800000, 1, 1, 0, 0, 1, 371);
INSERT INTO DyePotionInfo VALUES ( 42, '肤色转换剂 19', 'Skin-Dye 19', 800000, 1, 1, 0, 0, 1, 419);
INSERT INTO DyePotionInfo VALUES ( 43, '肤色转换剂 20', 'Skin-Dye 20', 800000, 1, 1, 0, 0, 1, 434);
INSERT INTO DyePotionInfo VALUES ( 44, '肤色转换剂 21', 'Skin-Dye 21', 800000, 1, 1, 0, 0, 1, 449);
INSERT INTO DyePotionInfo VALUES ( 45, '肤色转换剂 22', 'Skin-Dye 22', 800000, 1, 1, 0, 0, 1, 464);
INSERT INTO DyePotionInfo VALUES ( 46, '肤色转换剂 23', 'Skin-Dye 23', 800000, 1, 1, 0, 0, 1, 479);
INSERT INTO DyePotionInfo VALUES ( 47, '肤色转换剂 24', 'Skin-Dye 24', 800000, 1, 1, 0, 0, 1, 494);

INSERT INTO DyePotionInfo VALUES ( 48, '变性药水', 'SEX Conversion Potion', 800000, 1, 1, 0, 0, 2, 0);