createmixingiteminfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateMixingItemInfo.sql
#  Description : 雇教 器瘤 酒捞袍 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
################################################################################


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

CREATE TABLE MixingItemInfo (
  ItemType 		tinyint(3) 	unsigned NOT NULL default '0',
  Name 			varchar(50)			 NOT NULL default '',
  EName 		varchar(50)			 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',

  Target		enum('WEAPON','ARMOR','ACCESSORY')
  									 NOT NULL default 'ACCESSORY',
  Type			enum('MIX','DETACH') NOT NULL default 'MIX',
  SlayerLevel	tinyint(3)	unsigned NOT NULL default 0,
  VampireLevel	tinyint(3)	unsigned NOT NULL default 0,
  OustersLevel	tinyint(3)	unsigned NOT NULL default 0,

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



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

INSERT INTO MixingItemInfo VALUES (0, '武器改造种类A型', 'Weapon Mixing Forge Type A', 120000, 5, 1, 'WEAPON', 'MIX', 5, 8, 6);
INSERT INTO MixingItemInfo VALUES (1, '武器改造种类B型', 'Weapon Mixing Forge Type B', 120000, 5, 1, 'WEAPON', 'MIX', 8, 13, 8);
INSERT INTO MixingItemInfo VALUES (2, '武器改造种类C型', 'Weapon Mixing Forge Type C', 120000, 5, 1, 'WEAPON', 'MIX', 11,16, 10);

INSERT INTO MixingItemInfo VALUES (3, '防具改造种类A型', 'Armor Mixing Forge Type A', 120000, 5, 1, 'ARMOR', 'MIX', 11, 5, 6);
INSERT INTO MixingItemInfo VALUES (4, '防具改造种类B型', 'Armor Mixing Forge Type B', 120000, 5, 1, 'ARMOR', 'MIX', 15, 9, 8);
INSERT INTO MixingItemInfo VALUES (5, '防具改造种类C型', 'Armor Mixing Forge Type C', 120000, 5, 1, 'ARMOR', 'MIX', 19,15, 10);

INSERT INTO MixingItemInfo VALUES (6, '饰品改造种类A型', 'Accessory Mixing Forge Type A', 120000, 5, 1, 'ACCESSORY', 'MIX', 4, 4, 6);
INSERT INTO MixingItemInfo VALUES (7, '饰品改造种类B型', 'Accessory Mixing Forge Type B', 120000, 5, 1, 'ACCESSORY', 'MIX', 7, 7, 8);
INSERT INTO MixingItemInfo VALUES (8, '饰品改造种类C型', 'Accessory Mixing Forge Type C', 120000, 5, 1, 'ACCESSORY', 'MIX', 9, 9, 10);

INSERT INTO MixingItemInfo VALUES (9, '武器PuritasA型', 'Weapon Puritas Type A', 400000, 1, 1, 'WEAPON', 'DETACH', 5, 8, 6);
INSERT INTO MixingItemInfo VALUES (10, '武器PuritasB型', 'Weapon Puritas Type B', 400000, 1, 1, 'WEAPON', 'DETACH', 8, 13, 8);
INSERT INTO MixingItemInfo VALUES (11, '武器PuritasC型', 'Weapon Puritas Type C', 400000, 1, 1, 'WEAPON', 'DETACH', 11,16, 10);

INSERT INTO MixingItemInfo VALUES (12, '盔甲PuritasA型', 'Armor Puritas Type A', 400000, 1, 1, 'ARMOR', 'DETACH', 11, 5, 6);
INSERT INTO MixingItemInfo VALUES (13, '盔甲PuritasB型', 'Armor Puritas Type B', 400000, 1, 1, 'ARMOR', 'DETACH', 15, 9, 8);
INSERT INTO MixingItemInfo VALUES (14, '盔甲PuritasC型', 'Armor Puritas Type C', 400000, 1, 1, 'ARMOR', 'DETACH', 19,15, 10);

INSERT INTO MixingItemInfo VALUES (15, '饰品Puritas A型', 'Accessory Puritas Type A', 400000, 1, 1, 'ACCESSORY', 'DETACH', 4, 4, 6);
INSERT INTO MixingItemInfo VALUES (16, '饰品Puritas B型', 'Accessory Puritas Type B', 400000, 1, 1, 'ACCESSORY', 'DETACH', 7, 7, 8);
INSERT INTO MixingItemInfo VALUES (17, '饰品Puritas C型', 'Accessory Puritas Type C', 400000, 1, 1, 'ACCESSORY', 'DETACH', 9, 9, 10);