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

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

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

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databáze: `wow`
--

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

--
-- Struktura tabulky `finance`
--

CREATE TABLE IF NOT EXISTS `finance` (
  `id` int(11) NOT NULL auto_increment,
  `time` datetime default NULL,
  `money` int(11) default NULL,
  `operation` enum('contribution','consumption','buy','internet','sell') collate latin2_czech_cs NOT NULL default 'contribution',
  `description` varchar(255) collate latin2_czech_cs default NULL,
  KEY `ID` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=61 ;

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

--
-- Struktura tabulky `gm_news`
--

CREATE TABLE IF NOT EXISTS `gm_news` (
  `id` int(11) NOT NULL auto_increment,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `text` text character set latin1 NOT NULL,
  `author` varchar(64) collate latin2_czech_cs NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1398 ;

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

--
-- Struktura tabulky `mangos_restart`
--

CREATE TABLE IF NOT EXISTS `mangos_restart` (
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

--
-- Struktura tabulky `newgm`
--

CREATE TABLE IF NOT EXISTS `newgm` (
  `ID` int(11) NOT NULL,
  `reply` int(11) NOT NULL default '0',
  `Nick` text NOT NULL,
  `GameNick` text NOT NULL,
  `Icq` text NOT NULL,
  `Email` text NOT NULL,
  `OnlineOfDay` text NOT NULL,
  `OldPlay` text NOT NULL,
  `MaxLvl` text NOT NULL,
  `GMCommand` text NOT NULL,
  `Database` text NOT NULL,
  `Server` text NOT NULL,
  `LostLvl` text NOT NULL,
  `Onixie` text NOT NULL,
  `Why` text NOT NULL,
  `GMAnyWhere` text NOT NULL,
  `Dodatek` text NOT NULL,
  `Language` text NOT NULL,
  `Sintaxe` text NOT NULL,
  `old` int(11) NOT NULL,
  `Date` datetime NOT NULL,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `ID` int(11) NOT NULL,
  `User` text NOT NULL,
  `Pass` text NOT NULL,
  `LastIP` text,
  `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `Email` text NOT NULL,
  `Ban` int(11) NOT NULL default '0',
  `Function` text character set latin2 collate latin2_czech_cs NOT NULL,
  `AccID` int(11) NOT NULL,
  `ForumID` int(11) NOT NULL,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(32) collate latin2_czech_cs NOT NULL default '',
  `password` varchar(64) collate latin2_czech_cs NOT NULL default '',
  `email` varchar(128) collate latin2_czech_cs NOT NULL default '',
  `fullname` varchar(32) collate latin2_czech_cs NOT NULL default '',
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=3 ;

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

--
-- Struktura tabulky `users_online`
--

CREATE TABLE IF NOT EXISTS `users_online` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `session` varchar(128) collate latin2_czech_cs NOT NULL default '',
  `ip` varchar(64) collate latin2_czech_cs NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;