createeventiteminfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateEventItemInfo.sql
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2003.04.25    全惑刮        脚痹 颇老 积己 
#
################################################################################


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

CREATE TABLE EventItemInfo (
  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',

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



################################################################################
# 单捞磐 持扁
INSERT INTO EventItemInfo VALUES ( 0,'水灵石 1',	'Soul Stone Of Water 1',   	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 1,'水灵石 2',	'Soul Stone Of Water 2', 	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 2,'水灵石 3',	'Soul Stone Of Water 3',   	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 3,'水灵石 4',	'Soul Stone Of Water 4',   	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 4,'水灵石 5',	'Soul Stone Of Water 5',   	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 5,'火灵石 1',	'Soul Stone Of Fire 1',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 6,'火灵石 2',	'Soul Stone Of Fire 2',   	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 7,'火灵石 3',	'Soul Stone Of Fire 3',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 8,'火灵石 4',	'Soul Stone Of Fire 4',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES ( 9,'火灵石 5',	'Soul Stone Of Fire 5',  	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (10,'远古地图',	'Ancient Map',    	0, 6, 1, 0, 0);

INSERT INTO EventItemInfo VALUES (11,'黄色Zimott ',	'Yellow Zimott',   	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (12,'绿色 Zimott',		'Green Zimott',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (13,'蓝色 Zimott',		'Blue Zimott',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (14,'红色 Zimott',		'Red Zimott',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (15,'黑色 Zimott',		'Black Zimott',    	0, 1, 1, 0, 0);

INSERT INTO EventItemInfo VALUES (16,'黄色 Zircon',	'Yellow Zircon',   	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (17,'绿色 Zircon',		'Green Zircon',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (18,'蓝色 Zircon',		'Blue Zircon',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (19,'红色 Zircon',		'Red Zircon',    	0, 1, 1, 0, 0);
INSERT INTO EventItemInfo VALUES (20,'黑色 Zircon',		'Black Zircon',    	0, 1, 1, 0, 0);

INSERT INTO EventItemInfo VALUES (21,'瑞菲尼',		'Refinium',    	0, 1, 1, 0, 0);

INSERT INTO EventItemInfo VALUES (22," Thurisaz Magic Pebble","Thurisaz Magic Pebble",0,1,1,0,0);
INSERT INTO EventItemInfo VALUES (23," Gebo Magic Pebble","Gebo Magic Pebble",0,1,1,0,0);
INSERT INTO EventItemInfo VALUES (24," Wunjo Magic Pebble","Wunjo Magic Pebble",0,1,1,0,0);
INSERT INTO EventItemInfo VALUES (25," Jera Magic Pebble","Jera Magic Pebble",0,1,1,0,0);
INSERT INTO EventItemInfo VALUES (26," Hagalaz Magic Pebble","Hagalaz Magic Pebble",0,1,1,0,0);

INSERT INTO EventItemInfo VALUES (27,"旗帜","Flag",0,2,1,0,0);