createeventquestrewardinfo.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  : SQL - GameInfo
#
#  FileName    : CreateEventQuestRewardInfo.sql
#  Description : EventQuestReward 俊 措茄 沥焊
#
#  History      Writer          Description
# ------------ -------------- -----------------------------------------------
# 2003.04.25    全惑刮        脚痹 颇老 积己 
#
################################################################################


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

CREATE TABLE EventQuestRewardInfo (
  RewardID  int(10) unsigned	NOT NULL default 0,
  Name		varchar(30)			NOT NULL default '',
  Status 	int(10) unsigned 	NOT NULL default 0,
  Grade		tinyint(3) unsigned	NOT NULL default 0,

  PRIMARY KEY (RewardID)
) TYPE=MyISAM;

################################################################################
# 单捞鸥 持扁
INSERT INTO EventQuestRewardInfo VALUES (11, '酒荤崔碱俏 惑前鼻(1父盔)', 1, 1);
INSERT INTO EventQuestRewardInfo VALUES (12, '促农俊掸 奇带飘', 1, 1);
INSERT INTO EventQuestRewardInfo VALUES (13, '促农俊掸 萍寂明', 1, 1);
INSERT INTO EventQuestRewardInfo VALUES (14, '促农俊掸 1俺岿 捞侩鼻', 1, 1);

INSERT INTO EventQuestRewardInfo VALUES (21, '牢扼牢 胶纳捞飘', 1, 2);
INSERT INTO EventQuestRewardInfo VALUES (22, '鳃府胶 Accel 7021', 1, 2);
INSERT INTO EventQuestRewardInfo VALUES (23, 'DVD 敲饭捞绢 MDVD-9006', 1, 2);
INSERT INTO EventQuestRewardInfo VALUES (24, '5.1盲澄 胶乔目', 1, 2);
INSERT INTO EventQuestRewardInfo VALUES (25, '酒荤崔碱俏 惑前鼻(10父盔)', 1, 2);

INSERT INTO EventQuestRewardInfo VALUES (31, '疙前矫拌', 1, 3);
INSERT INTO EventQuestRewardInfo VALUES (32, 'MP3P iRIVER 395', 1, 3);
INSERT INTO EventQuestRewardInfo VALUES (33, '姆内歹', 1, 3);
INSERT INTO EventQuestRewardInfo VALUES (34, '叼瘤判 墨皋扼', 1, 3);
INSERT INTO EventQuestRewardInfo VALUES (35, '酒荤崔 碱俏 惑前鼻(50父盔)', 1, 3);

INSERT INTO EventQuestRewardInfo VALUES (41, '权矫绢磐老眉屈', 1, 4);
INSERT INTO EventQuestRewardInfo VALUES (42, '趁厘绊', 1, 4);
INSERT INTO EventQuestRewardInfo VALUES (43, '肯傈乞搁 TV', 1, 4);
INSERT INTO EventQuestRewardInfo VALUES (44, 'TFT-LCD 葛聪磐', 1, 4);
INSERT INTO EventQuestRewardInfo VALUES (45, '哪腔磐', 1, 4);

INSERT INTO EventQuestRewardInfo VALUES (51, '叼瘤判 TV', 1, 5);
INSERT INTO EventQuestRewardInfo VALUES (52, '促农俊掸1/2 捞侩鼻(乞积)', 1, 5);