
--
-- Struktura tabulky `quests`
--
-- Vytvoøení: Úterý 15. ledna 2008, 17:26
-- Poslední zmìna: Ètvrtek 17. ledna 2008, 22:00
-- Poslední kontrola: Úterý 15. ledna 2008, 17:26
--

CREATE TABLE IF NOT EXISTS `quests` (
  `ID` int(11) NOT NULL auto_increment,
  `entry` int(11) NOT NULL default '0',
  `Title` text character set latin2 collate latin2_czech_cs NOT NULL,
  `Details` text character set latin2 collate latin2_czech_cs NOT NULL,
  `Objectives` text character set latin2 collate latin2_czech_cs NOT NULL,
  `OfferRewardText` text character set latin2 collate latin2_czech_cs NOT NULL,
  `RequestItemsText` text character set latin2 collate latin2_czech_cs NOT NULL,
  `EndText` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText1` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText2` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText3` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText4` text character set latin2 collate latin2_czech_cs NOT NULL,
  `Language` int(11) NOT NULL default '1',
  `Vote` float NOT NULL default '0',
  `CountVote` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `complete` int(11) NOT NULL default '1',
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7565 ;

-- --------------------------------------------------------
