source: branches/posledni/sql/structure.sql

--
-- Struktura tabulky `achievement`
--

CREATE TABLE IF NOT EXISTS `achievement` (
  `id` bigint(20) NOT NULL COMMENT 'Entry',
  `team` bigint(20) NOT NULL COMMENT '-1=all, 0=horde, 1=alliance',
  `mapid` bigint(20) NOT NULL COMMENT '-1=none - Only set if achievement is related to a zone',
  `field_3` bigint(20) NOT NULL,
  `name01` text NOT NULL,
  `name02` text NOT NULL,
  `name03` text NOT NULL,
  `name04` text NOT NULL,
  `name05` text NOT NULL,
  `name06` text NOT NULL,
  `name07` text NOT NULL,
  `name08` text NOT NULL,
  `name09` text NOT NULL,
  `name10` text NOT NULL,
  `name11` text NOT NULL,
  `name12` text NOT NULL,
  `name13` text NOT NULL,
  `name14` text NOT NULL,
  `name15` text NOT NULL,
  `name16` text NOT NULL,
  `field_20` bigint(20) NOT NULL,
  `description01` text NOT NULL COMMENT 'description - each for one locale',
  `description02` text NOT NULL,
  `description03` text NOT NULL,
  `description04` text NOT NULL,
  `description05` text NOT NULL,
  `description06` text NOT NULL,
  `description07` text NOT NULL,
  `description08` text NOT NULL,
  `description09` text NOT NULL,
  `description10` text NOT NULL,
  `description11` text NOT NULL,
  `description12` text NOT NULL,
  `description13` text NOT NULL,
  `description14` text NOT NULL,
  `description15` text NOT NULL,
  `description16` text NOT NULL,
  `field_37` bigint(20) NOT NULL,
  `categoryid` bigint(20) NOT NULL COMMENT 'id of category',
  `rewpoints` bigint(20) NOT NULL COMMENT 'rewarded points',
  `order` bigint(20) NOT NULL COMMENT 'order in category',
  `flags` bigint(20) NOT NULL COMMENT 'flags',
  `field_42` bigint(20) NOT NULL,
  `rewarddesc01` text NOT NULL COMMENT 'reward description - each for one locale',
  `rewarddesc02` text NOT NULL,
  `rewarddesc03` text NOT NULL,
  `rewarddesc04` text NOT NULL,
  `rewarddesc05` text NOT NULL,
  `rewarddesc06` text NOT NULL,
  `rewarddesc07` text NOT NULL,
  `rewarddesc08` text NOT NULL,
  `rewarddesc09` text NOT NULL,
  `rewarddesc10` text NOT NULL,
  `rewarddesc11` text NOT NULL,
  `rewarddesc12` text NOT NULL,
  `rewarddesc13` text NOT NULL,
  `rewarddesc14` text NOT NULL,
  `rewarddesc15` text NOT NULL,
  `rewarddesc16` text NOT NULL,
  `field_59` bigint(20) NOT NULL,
  `field_60` bigint(20) NOT NULL,
  `field_61` bigint(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `id` int(11) NOT NULL auto_increment,
  `title` text collate utf8_czech_ci NOT NULL,
  `autor` text collate utf8_czech_ci NOT NULL,
  `category` int(11) NOT NULL default '0',
  `text` text collate utf8_czech_ci NOT NULL,
  `date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=117 ;

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

--
-- Struktura tabulky `characters`
--

CREATE TABLE IF NOT EXISTS `characters` (
  `guid` int(11) NOT NULL default '0',
  `warm` int(11) NOT NULL default '0',
  `weblevel` int(11) NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `chyby`
--

CREATE TABLE IF NOT EXISTS `chyby` (
  `id` int(8) NOT NULL auto_increment,
  `id_name` varchar(128) collate utf8_czech_ci NOT NULL,
  `jmeno` varchar(128) collate utf8_czech_ci NOT NULL,
  `prispevek` text collate utf8_czech_ci NOT NULL,
  `postava` text collate utf8_czech_ci NOT NULL,
  `typ` int(24) NOT NULL,
  `frakce` int(24) NOT NULL,
  `mail` varchar(128) collate utf8_czech_ci NOT NULL,
  `screenshot` text collate utf8_czech_ci NOT NULL,
  `datum` int(24) NOT NULL,
  `status` int(24) NOT NULL,
  `ip` varchar(16) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=91 ;

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

--
-- Struktura tabulky `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL auto_increment,
  `user` text collate utf8_czech_ci NOT NULL,
  `comment` text collate utf8_czech_ci NOT NULL,
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `debug`
--

CREATE TABLE IF NOT EXISTS `debug` (
  `Id` int(11) NOT NULL auto_increment,
  `Time` datetime NOT NULL,
  `Backtrace` mediumtext collate latin2_czech_cs NOT NULL,
  `Log` text collate latin2_czech_cs NOT NULL,
  `MangosVersion` varchar(255) collate latin2_czech_cs NOT NULL,
  `DbVersion` varchar(255) collate latin2_czech_cs NOT NULL,
  `MaxPlayerCount` int(11) NOT NULL,
  `Uptime` int(11) NOT NULL,
  `ErrorLog` text collate latin2_czech_cs NOT NULL,
  `DbErrors` text collate latin2_czech_cs NOT NULL,
  `Configuration` text collate latin2_czech_cs NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `diskuze`
--

CREATE TABLE IF NOT EXISTS `diskuze` (
  `id` int(8) NOT NULL auto_increment,
  `entry` int(24) NOT NULL,
  `jmeno` varchar(128) collate utf8_czech_ci NOT NULL,
  `prispevek` text collate utf8_czech_ci NOT NULL,
  `datum` int(24) NOT NULL,
  `ip` varchar(16) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ;

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

--
-- Struktura tabulky `export_list`
--

CREATE TABLE IF NOT EXISTS `export_list` (
  `typ` varchar(255) collate utf8_czech_ci default NULL,
  `guid` varchar(255) collate utf8_czech_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- 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,
  `odmena` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
  KEY `ID` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=128 ;

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

--
-- Struktura tabulky `guildy`
--

CREATE TABLE IF NOT EXISTS `guildy` (
  `id` varchar(255) default NULL,
  `jmeno` varchar(255) character set utf8 collate utf8_czech_ci default NULL,
  `GuM` varchar(255) default NULL,
  `typgh` varchar(255) NOT NULL,
  `dalsi_platba` date default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Struktura tabulky `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `realmd_id` int(11) NOT NULL default '0',
  `name` text character set utf8 collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `uzivatele`
--

CREATE TABLE IF NOT EXISTS `uzivatele` (
  `id` int(64) NOT NULL auto_increment,
  `user` varchar(1024) collate utf8_czech_ci NOT NULL,
  `pass` varchar(40) collate utf8_czech_ci NOT NULL,
  `mail` varchar(1024) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=3 ;