source: branches/old/sql/12-quests full.sql

-- phpMyAdmin SQL Dump
-- version 2.11.0-beta1
-- http://www.phpmyadmin.net
--
-- Poèítaè: localhost

-- Vygenerováno: Sobota 11. srpna 2007, 01:45
-- Verze MySQL: 5.0.37
-- Verze PHP: 5.2.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databáze: `quests`
--

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

--
-- Struktura tabulky `ajquests`
--

CREATE TABLE IF NOT EXISTS `ajquests` (
  `entry` int(11) NOT NULL default '0',
  `Title` text NOT NULL,
  `Details` text NOT NULL,
  `Objectives` text NOT NULL,
  `OfferRewardText` text NOT NULL,
  `RequestItemsText` text NOT NULL,
  `State` int(11) NOT NULL default '0',
  `User` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `czquests`
--

CREATE TABLE IF NOT EXISTS `czquests` (
  `entry` int(11) NOT NULL default '0',
  `Title` text NOT NULL,
  `Details` text NOT NULL,
  `Objectives` text NOT NULL,
  `OfferRewardText` text NOT NULL,
  `RequestItemsText` text NOT NULL,
  `State` int(11) NOT NULL default '0',
  `User` text NOT NULL,
  `complete` int(11) NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user` text NOT NULL,
  `pass` text NOT NULL,
  `gm` int(11) NOT NULL default '0',
  `LastIP` text NOT NULL,
  `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `NumberTranslateQuests` int(11) NOT NULL default '0',
  `Email` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `var`
--

CREATE TABLE IF NOT EXISTS `var` (
  `Name` text NOT NULL,
  `Value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;