createeventstarinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - Item Info
#
#  FileName    : CreateEventStarInfo.sql
#  Description : 喊 酒捞袍 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2002.08.13    厘全芒        脚痹 颇老 积己 
#
# 2002.09.11    厘全芒        眠籍 捞亥飘 眠啊
#
# 2002.09.13    厘全芒        捞亥飘 侩 价祈 啊拜 (迫锭 扁霖栏肺 20父栏肺 荐沥)
################################################################################


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

CREATE TABLE EventStarInfo (
  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',
  FunctionFlag  tinyint 	unsigned NOT NULL default '0',
  FunctionValue smallint 			 NOT NULL default '0',

  PRIMARY KEY  (ItemType)

) TYPE=MyISAM;


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



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



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



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

INSERT INTO EventStarInfo VALUES (0,'黑星','Black Star',40000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (1,'红星','Red Star',40000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (2,'蓝星','Blue Star',40000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (3,'绿星','Green Star',40000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (4,'藏星','Cyan Star',40000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (5,'白星','White Star',20000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (6,'足球','Soccer Ball',40000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (7,'蓝色水滴','Blue Drop',200000,1,1,0,0,1,0);
INSERT INTO EventStarInfo VALUES (8,'红色米饼','Red Rice Cake',800000,1,1,0,0,2,1);
INSERT INTO EventStarInfo VALUES (9,'绿色米饼','Green Rice Cake',800000,1,1,0,0,2,6);
INSERT INTO EventStarInfo VALUES (10,'蓝色米饼','Blue Rice Cake',800000,1,1,0,0,2,11);
INSERT INTO EventStarInfo VALUES (11,'黑色米饼','Black Rice Cake',800000,1,1,0,0,2,48);

INSERT INTO EventStarInfo VALUES (12,'蓝鸟', 'Blue Bird',       400000, 1, 1, 0, 0, 4, 0);
INSERT INTO EventStarInfo VALUES (13, '蓝绿 年糕汤', 'Bluish Green Rice Cake Soup', 800000, 1, 1, 0, 0, 2, 183);
INSERT INTO EventStarInfo VALUES (14, '莴苣 年糕汤', 'Mugwort Rice Cake Soup', 800000, 1, 1, 0, 0, 2, 175);
INSERT INTO EventStarInfo VALUES (15,'蓝色 水滴 2', 'Blue Drop 2',       320000, 1, 1, 0, 0, 1, 0);
INSERT INTO EventStarInfo VALUES (16, 'Trans工具箱', 'Trans Item Kit', 8000000, 5, 1, 0, 0, 8, 0);