createitemmineinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateItemMineInfo.sql
#  Description : 酒捞袍 堡魂. 措面 咯矾 酒捞袍捞 甸绢乐促.
#				 霸烙 辑滚郴俊辑 焊惑侩栏肺 酒捞袍阑 瘤鞭且锭 窍唱究 某郴辑 敬促.
#
################################################################################


################################################################################
# 抛捞喉 积己 
DROP TABLE IF EXISTS ItemMineInfo;
CREATE TABLE ItemMineInfo
(
 	ID				int				NOT NULL	DEFAULT 0,

	ItemClass		varchar(30)		NOT NULL	DEFAULT 0,
	ItemType		smallint(5)		NOT NULL	DEFAULT 0,
	ItemOption		varchar(50)		NOT NULL	DEFAULT '',

	PRIMARY KEY (ID)
);

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

INSERT INTO ItemMineInfo VALUES (  0, 'RING', 4, 'DAM+4,HPSTL+2' );	# 坷矾胶傅 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  1, 'RING', 5, 'DAM+4,HPSTL+2' );	# 青款狼馆瘤 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  2, 'RING', 6, 'DAM+4,HPSTL+2' );	# 肺磊府坷 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  3, 'RING', 7, 'DAM+4,HPSTL+2' );	# 榜电促捞酒阁靛傅 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  4, 'RING', 8, 'DAM+4,HPSTL+2' );	# 敲贰萍逞 胶颇捞凡 DAM+4/HP软荐+2

INSERT INTO ItemMineInfo VALUES (  5, 'VAMPIRE_RING', 4, 'DAM+4,HPSTL+2' );	# 矩萍姐傅 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  6, 'VAMPIRE_RING', 5, 'DAM+4,HPSTL+2' );	# 喉风矫掂急 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  7, 'VAMPIRE_RING', 6, 'DAM+4,HPSTL+2' );	# 喉矾靛辑目 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  8, 'VAMPIRE_RING', 7, 'DAM+4,HPSTL+2' );	# 攫圈府浆靛 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES (  9, 'VAMPIRE_RING', 8, 'DAM+4,HPSTL+2' );	# 傅坷宏胶拿令 DAM+4/HP软荐+2

INSERT INTO ItemMineInfo VALUES ( 10, 'OUSTERS_RING', 4, 'DAM+4,HPSTL+2' );	# 骏器胶傅 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES ( 11, 'OUSTERS_RING', 5, 'DAM+4,HPSTL+2' );	# 抛老令坷宏箕牢 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES ( 12, 'OUSTERS_RING', 6, 'DAM+4,HPSTL+2' );	# 胶颇捞歹酒捞令 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES ( 13, 'OUSTERS_RING', 7, 'DAM+4,HPSTL+2' );	# 贾府磐府胶鸥 DAM+4/HP软荐+2
INSERT INTO ItemMineInfo VALUES ( 14, 'OUSTERS_RING', 8, 'DAM+4,HPSTL+2' );	# 皋农莉狼傅 DAM+4/HP软荐+2

INSERT INTO ItemMineInfo VALUES ( 15, 'SWORD',	0, 'STR+5' );		# 扼捞飘家靛 STR+5
INSERT INTO ItemMineInfo VALUES ( 16, 'BLADE',	1, 'RES+5' );		# 氛伙寂 葛历+9
INSERT INTO ItemMineInfo VALUES ( 17, 'SMG',	4, 'CRI+5' );		# 靛贰帮敲扼捞 农府萍拿+10
INSERT INTO ItemMineInfo VALUES ( 18, 'AR',		0, 'MP+5' );		# 厚寂胶 MP+25
INSERT INTO ItemMineInfo VALUES ( 19, 'CROSS',	0, 'ATTR+3' );	# 角滚农肺胶 葛瓷+3
INSERT INTO ItemMineInfo VALUES ( 20, 'MACE',	2, 'DEX+5' );		#弊腐皋捞胶 DEX+5

INSERT INTO ItemMineInfo VALUES ( 21, 'COAT',	2, 'ASPD+5' );	#海胶飘(W) 傍加+25
INSERT INTO ItemMineInfo VALUES ( 22, 'TROUSER',6, 'VIS+5' );		#硅撇贰彪(W) 矫具+5
INSERT INTO ItemMineInfo VALUES ( 23, 'HELM',	3, 'ACRES+3' );	#俊烙秋镐 魂历亲+15
INSERT INTO ItemMineInfo VALUES ( 24, 'GLOVE',	1, 'DEF+5' );		#宏沸令扒甸房 叼奇胶+5
INSERT INTO ItemMineInfo VALUES ( 25, 'COAT',	4, 'DUR+5' );		#硅撇酱飘(M) 郴备+100
INSERT INTO ItemMineInfo VALUES ( 26, 'SHOES',	1, 'DAM+4' );		#饭歹酱令 DAM+4
INSERT INTO ItemMineInfo VALUES ( 27, 'TROUSER',4, 'CRI+5' );		#贰彪令(M) 农府萍拿+10

INSERT INTO ItemMineInfo VALUES ( 28, 'NECKLACE',	3, 'INT+5' );	 	#敲饭萍逞奇带飘 INT+5
INSERT INTO ItemMineInfo VALUES ( 29, 'BRACELET',	0, 'LUCK+3' );	#皋呕 喉饭捞浇复 青款+3
INSERT INTO ItemMineInfo VALUES ( 30, 'RING',		0, 'MP+5' );	 	#喉发傅 MP+25
INSERT INTO ItemMineInfo VALUES ( 31, 'NECKLACE',	1, 'HP+5' );	 	#俊皋饿靛埔带飘 HP+15
INSERT INTO ItemMineInfo VALUES ( 32, 'BRACELET',	1, 'DAM+5' );	 	#胶瓶 喉饭捞浇复 DAM+5

INSERT INTO ItemMineInfo VALUES ( 33, 'VAMPIRE_WEAPON',	0, 'STR+5' );	 	#呈努颇飘 STR+5
INSERT INTO ItemMineInfo VALUES ( 34, 'VAMPIRE_WEAPON',	3, 'RES+5' );	 	#力呈澄傅呈努 葛历+9
INSERT INTO ItemMineInfo VALUES ( 35, 'VAMPIRE_WEAPON',	1, 'HP+5' );	 	#芥弊乏 HP+15
INSERT INTO ItemMineInfo VALUES ( 36, 'VAMPIRE_WEAPON',	4, 'DEX+5' );	 	#抗萍农肺快 DEX+5

INSERT INTO ItemMineInfo VALUES ( 37, 'VAMPIRE_COAT',	2, 'VIS+5' );	 	#橇废内飘(M) 矫具+5
INSERT INTO ItemMineInfo VALUES ( 38, 'VAMPIRE_COAT',	0, 'INT+5' );	 	#官叼酱飘(W) INT+5
INSERT INTO ItemMineInfo VALUES ( 39, 'VAMPIRE_COAT',	4, 'DUR+5' );	 	#浇府欺府肺宏(M) 郴备+100
INSERT INTO ItemMineInfo VALUES ( 40, 'VAMPIRE_COAT',	4, 'CRI+5' );	 	#敲抚酿废(W) 农府萍拿+10

INSERT INTO ItemMineInfo VALUES ( 41, 'VAMPIRE_NECKLACE',	1, 'ASPD+5' ); 	#胶拿匙农府胶 傍加+25
INSERT INTO ItemMineInfo VALUES ( 42, 'VAMPIRE_BRACELET',	0, 'RES+5' );	 	#饭捞胶喉饭捞浇复 葛历+9
INSERT INTO ItemMineInfo VALUES ( 43, 'VAMPIRE_EARRING',	2, 'TOHIT+5' ); 	#榜靛 捞绢傅 疙吝伏+5
INSERT INTO ItemMineInfo VALUES ( 44, 'VAMPIRE_AMULET',		0, 'LUCK+3' ); 	#扼靛 青款+3
INSERT INTO ItemMineInfo VALUES ( 45, 'VAMPIRE_RING',		0, 'STR+5' );	 	#酒捞攫 傅 STR+5

INSERT INTO ItemMineInfo VALUES ( 46, 'OUSTERS_CHAKRAM',	 1, 'DEX+5' );	 	#欺宏 铆农恩 DEX+5
INSERT INTO ItemMineInfo VALUES ( 47, 'OUSTERS_WRISTLET',	 1, 'DUR+5' );	 	#阂狼 官牢 府胶撇复 郴备+100
INSERT INTO ItemMineInfo VALUES ( 48, 'OUSTERS_WRISTLET',	10, 'VIS+5' );	 	#拱狼 匙抿凡 府胶撇复 矫具+5
INSERT INTO ItemMineInfo VALUES ( 49, 'OUSTERS_WRISTLET',	22, 'ATTR+3' );	 	#措瘤狼 扼翟 府胶撇复 葛瓷+3
INSERT INTO ItemMineInfo VALUES ( 50, 'OUSTERS_CHAKRAM',	 3, 'ASPD+5' );	 	#春焊 铆农恩 傍加+25

INSERT INTO ItemMineInfo VALUES ( 51, 'OUSTERS_COAT',		0, 'CURES+3' ); 	#靛扼捞绢靛内飘 历林历亲+15
INSERT INTO ItemMineInfo VALUES ( 52, 'OUSTERS_COAT',		0, 'MPSTL+5' ); 	#靛扼捞绢靛内飘 MP软荐+5
INSERT INTO ItemMineInfo VALUES ( 53, 'OUSTERS_COAT',		1, 'INT+5' ); 	#坷饭酒胶内飘 INT+5
INSERT INTO ItemMineInfo VALUES ( 54, 'OUSTERS_CIRCLET',	1, 'DUR+5' ); 	#父岿狼 辑努复 郴何+100
INSERT INTO ItemMineInfo VALUES ( 55, 'OUSTERS_ARMSBAND',	0, 'CRI+5' );	 	#快靛鞠胶龟靛 农府萍拿+10

INSERT INTO ItemMineInfo VALUES ( 56, 'OUSTERS_PENDENT',	 1, 'RES+5' ); 	#坷府箕埔带飘 葛历+9
INSERT INTO ItemMineInfo VALUES ( 57, 'OUSTERS_RING',		 0, 'LUCK+3' ); 	#丘橇狼 傅 青款+3
INSERT INTO ItemMineInfo VALUES ( 58, 'OUSTERS_STONE',		 0, 'MP+5' ); 	#阂狼沥飞籍1 MP+25
INSERT INTO ItemMineInfo VALUES ( 59, 'OUSTERS_STONE',		 6, 'DAM+5' ); 	#拱狼沥飞籍2 DAM+5
INSERT INTO ItemMineInfo VALUES ( 60, 'OUSTERS_STONE',		10, 'HP+5' );	 	#措瘤狼沥飞籍1 HP+15
INSERT INTO ItemMineInfo VALUES ( 61, 'OUSTERS_RING',		 2, 'PORES+3' ); 	#技捞橇啊靛傅 刀历亲+15