createsimplequest.sql

天之炼狱OpenDE_SQL.tar.gz

################################################################################
#
#  Project : Online Game DARKEDEN
#  Module  :
#
#  FileName : CreateSimpleQuest.sql
#  Description : 
#
#  History
# ------------ -------------- -----------------------------------------------
# 2002.12.02     辣康侥        脚痹 颇老 积己 
###############################################################################

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

CREATE TABLE SimpleQuest (
  OwnerID  	varchar(10)      NOT NULL,
  QuestType int(11)      	NOT NULL,
  Objective  varchar(100)      NOT NULL,
  Reward  	varchar(100)      NOT NULL default '',
  Penalty  	varchar(100)      NOT NULL default '',
  YearTime int(10) unsigned NOT NULL default '0',
  DayTime int(10) unsigned NOT NULL default '0',

  PRIMARY KEY (OwnerID)

) TYPE=MyISAM;

# 单捞磐 持扁