source: sql/full.sql

-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Počítač: mysql5-1
-- Vygenerováno: Čtvrtek 01. května 2008, 01:16
-- Verze MySQL: 5.0.32
-- Verze PHP: 5.2.0-8+etch3
-- 
-- Databáze: `servery_1274`
-- 

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

-- 
-- Struktura tabulky `comments`
-- 

CREATE TABLE `comments` (
  `id` int(11) NOT NULL auto_increment,
  `time` int(11) default NULL,
  `server` int(11) default NULL,
  `author` int(11) default NULL,
  `text` text character set utf8 collate utf8_czech_ci,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1486 ;

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

-- 
-- Struktura tabulky `pages`
-- 

CREATE TABLE `pages` (
  `page` varchar(30) collate utf8_czech_ci default NULL,
  `url` varchar(30) collate utf8_czech_ci default NULL,
  `title` varchar(30) collate utf8_czech_ci default NULL,
  `admin` tinyint(2) default NULL,
  `menu` tinyint(2) default NULL,
  UNIQUE KEY `page` (`page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

-- 
-- Struktura tabulky `ratings`
-- 

CREATE TABLE `ratings` (
  `user_id` int(11) default NULL,
  `server_id` int(11) default NULL,
  `rating` tinyint(2) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Struktura tabulky `servers`
-- 

CREATE TABLE `servers` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) character set utf8 collate utf8_czech_ci NOT NULL,
  `version` varchar(10) character set utf8 collate utf8_czech_ci default '2.1.3',
  `emu` varchar(30) character set utf8 collate utf8_czech_ci default NULL,
  `type` varchar(5) character set utf8 collate utf8_czech_ci default '1',
  `xp` tinyint(2) default '3',
  `limit` int(11) default '100',
  `place` tinyint(2) default '1',
  `web` varchar(255) character set utf8 collate utf8_czech_ci default 'http://',
  `web_reg` varchar(255) character set utf8 collate utf8_czech_ci default 'http://',
  `desc` text character set utf8 collate utf8_czech_ci,
  `owner` int(11) default NULL,
  `rating_sum` int(11) default '0',
  `ratings` int(11) default '0',
  `online_players_sum` bigint(20) default '0',
  `online` int(11) default '0',
  `player_checks` int(11) default '1',
  `online_checks` int(11) default '0',
  `port` int(11) default '8085',
  `ip` varchar(50) character set utf8 collate utf8_czech_ci default NULL,
  `created` int(11) default NULL,
  `wss_partner` tinyint(2) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=370 ;

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

-- 
-- Struktura tabulky `users`
-- 

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(30) collate utf8_czech_ci default NULL,
  `password` varchar(50) collate utf8_czech_ci default NULL,
  `email` varchar(50) collate utf8_czech_ci default NULL,
  `ban` tinyint(2) default '0',
  `active` tinyint(2) default '0',
  `admin` tinyint(2) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `Unique` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1471 ;