quest[v1].sql.svn-base

来自「絲路server源碼 Silk Road server source」· SVN-BASE 代码 · 共 34 行

-----------------
Edited by hitomi2
-----------------


CREATE TABLE `quests` (
  `entry` int(11) NOT NULL auto_increment,  
  `id` int(10) unsigned NOT NULL default '0',
  `MinLevel` int(10) unsigned NOT NULL default '0',
  `questlevel` int(10) unsigned NOT NULL default '0',
  `Type` int(10) unsigned NOT NULL default '0',
  `RequiredEuro` int(10) unsigned NOT NULL default '0',
  `RequiredChine` int(10) unsigned NOT NULL default '0',
  `LimitTime` int(10) unsigned NOT NULL default '0',
  `PrevQuestId` int(10) unsigned NOT NULL default '0',
  `NextQuestId` int(10) unsigned NOT NULL default '0',
  `srcItem` int(10) unsigned NOT NULL default '0',
  `SrcItemAmmount` int(10) unsigned NOT NULL default '0',
  `Title` char(255) NOT NULL,
  `Details` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `ReqKillMobId` int(10) unsigned NOT NULL default '0',
  `ReqKillMobId2` int(10) unsigned NOT NULL default '0',
  `ReqKillMobCount` int(10) unsigned NOT NULL default '0',
  `ReqKillMobCount2` int(10) unsigned NOT NULL default '0',
  `RewItemId1` int(10) unsigned NOT NULL default '0',
  `RewItemId2` int(10) unsigned NOT NULL default '0',
  `RewMoney` int(10) unsigned NOT NULL default '0',
  `RewXP` int(10) unsigned NOT NULL default '0',
  `IsRepeatable` int(11) NOT NULL default '0',
  PRIMARY KEY  (`entry`),
  UNIQUE KEY `entry` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Quests System';