Struktůra databáze

--
-- Struktura tabulky `activity`
--

DROP TABLE IF EXISTS `activity`;
CREATE TABLE IF NOT EXISTS `activity` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date` int(11) NOT NULL DEFAULT '0',
  `description` mediumtext,
  PRIMARY KEY (`ID`),
  KEY `date` (`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=72 ;

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

--
-- Struktura tabulky `akce`
--

DROP TABLE IF EXISTS `akce`;
CREATE TABLE IF NOT EXISTS `akce` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(32) DEFAULT NULL,
  `popis` text,
  `url` varchar(128) DEFAULT NULL,
  `kateg` int(11) DEFAULT NULL,
  `od` datetime DEFAULT NULL,
  `do` datetime DEFAULT NULL,
  `misto` int(11) DEFAULT NULL,
  `odcas` double(4,2) DEFAULT NULL,
  `docas` double(4,2) DEFAULT NULL,
  `adresa` text,
  `stat` int(11) DEFAULT NULL,
  `vlozil` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `author`
--

DROP TABLE IF EXISTS `author`;
CREATE TABLE IF NOT EXISTS `author` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `login` varchar(20) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `useradmin` int(11) DEFAULT NULL,
  `stuffadmin` int(11) DEFAULT NULL,
  `topicadmin` int(11) DEFAULT NULL,
  `sqladmin` int(11) DEFAULT NULL,
  `boardadmin` int(11) DEFAULT NULL,
  `allowphp3` int(11) DEFAULT NULL,
  `directadd` int(11) DEFAULT NULL,
  `enabled` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=2858 ;

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

--
-- Struktura tabulky `board`
--

DROP TABLE IF EXISTS `board`;
CREATE TABLE IF NOT EXISTS `board` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `topic` varchar(100) DEFAULT NULL,
  `author` varchar(60) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `text` blob,
  `date` int(11) DEFAULT NULL,
  `nameindex` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `chat`
--

DROP TABLE IF EXISTS `chat`;
CREATE TABLE IF NOT EXISTS `chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chatid` int(11) DEFAULT NULL,
  `cas` datetime DEFAULT NULL,
  `nick` varchar(20) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `adresat` int(11) DEFAULT '0',
  `vzkaz` varchar(255) DEFAULT NULL,
  `typ` enum('user','registred','VIP','chatbot','admin') DEFAULT 'user',
  `uid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12432 ;

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

--
-- Struktura tabulky `chatindex`
--

DROP TABLE IF EXISTS `chatindex`;
CREATE TABLE IF NOT EXISTS `chatindex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(64) DEFAULT NULL,
  `misto` varchar(64) DEFAULT NULL,
  `osoba` varchar(64) DEFAULT NULL,
  `datum` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `poznamka` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `clanky_body`
--

DROP TABLE IF EXISTS `clanky_body`;
CREATE TABLE IF NOT EXISTS `clanky_body` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `body` int(11) DEFAULT '0',
  `comment` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=127 ;

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

--
-- Struktura tabulky `dbaddselect`
--

DROP TABLE IF EXISTS `dbaddselect`;
CREATE TABLE IF NOT EXISTS `dbaddselect` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nazev` varchar(32) DEFAULT NULL,
  `hodnota` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=64 ;

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

--
-- Struktura tabulky `downloads`
--

DROP TABLE IF EXISTS `downloads`;
CREATE TABLE IF NOT EXISTS `downloads` (
  `did` int(10) NOT NULL AUTO_INCREMENT,
  `dcounter` int(10) DEFAULT '0',
  `durl` varchar(255) DEFAULT NULL,
  `dfilename` varchar(255) DEFAULT NULL,
  `dfilesize` bigint(15) DEFAULT NULL,
  `ddate` datetime DEFAULT NULL,
  `duser` int(11) DEFAULT NULL,
  `dver` varchar(6) DEFAULT NULL,
  `dcategory` varchar(15) DEFAULT NULL,
  `ddescription` text,
  `privs` enum('0','1','2') DEFAULT '0',
  PRIMARY KEY (`did`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

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

--
-- Struktura tabulky `druhy_akci`
--

DROP TABLE IF EXISTS `druhy_akci`;
CREATE TABLE IF NOT EXISTS `druhy_akci` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7370 ;

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

--
-- Struktura tabulky `faqAnswer`
--

DROP TABLE IF EXISTS `faqAnswer`;
CREATE TABLE IF NOT EXISTS `faqAnswer` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `id_cat` tinyint(4) DEFAULT NULL,
  `question` varchar(255) DEFAULT NULL,
  `answer` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

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

--
-- Struktura tabulky `faqCategories`
--

DROP TABLE IF EXISTS `faqCategories`;
CREATE TABLE IF NOT EXISTS `faqCategories` (
  `id_cat` tinyint(3) NOT NULL AUTO_INCREMENT,
  `categories` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_cat`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

--
-- Struktura tabulky `fortunes`
--

DROP TABLE IF EXISTS `fortunes`;
CREATE TABLE IF NOT EXISTS `fortunes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datum` datetime DEFAULT NULL,
  `author` int(11) DEFAULT NULL,
  `moudro` text,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=594 ;

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

--
-- Struktura tabulky `galerie`
--

DROP TABLE IF EXISTS `galerie`;
CREATE TABLE IF NOT EXISTS `galerie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kategorie` int(11) DEFAULT NULL,
  `autor` int(11) DEFAULT NULL,
  `technika` varchar(64) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `popis` text,
  `pridal` int(11) DEFAULT NULL,
  `hodnoceni` int(11) DEFAULT NULL,
  `poslano` int(11) DEFAULT NULL,
  `aktiv` enum('yes','no','new') DEFAULT NULL,
  `keyid` varchar(32) DEFAULT NULL,
  `datum` datetime DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1058 ;

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

--
-- Struktura tabulky `galerie_skupina`
--

DROP TABLE IF EXISTS `galerie_skupina`;
CREATE TABLE IF NOT EXISTS `galerie_skupina` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datum` datetime DEFAULT NULL,
  `nazev` varchar(64) DEFAULT NULL,
  `popis` text,
  `url` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Struktura tabulky `guestbook`
--

DROP TABLE IF EXISTS `guestbook`;
CREATE TABLE IF NOT EXISTS `guestbook` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jmeno` varchar(20) DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  `vzkaz` text,
  `lang` enum('cz','en') DEFAULT NULL,
  `datum` datetime DEFAULT NULL,
  `keyid` varchar(40) DEFAULT NULL,
  `uid` int(11) DEFAULT '0',
  `notifyreply` enum('yes','no') DEFAULT 'yes',
  PRIMARY KEY (`id`),
  KEY `keyid` (`keyid`),
  KEY `uid` (`uid`),
  KEY `lang` (`lang`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=169356 ;

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

--
-- Struktura tabulky `headlines`
--

DROP TABLE IF EXISTS `headlines`;
CREATE TABLE IF NOT EXISTS `headlines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `headline` text,
  `author` int(11) DEFAULT NULL,
  `datum` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=385 ;

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

--
-- Struktura tabulky `hippyforumindex`
--

DROP TABLE IF EXISTS `hippyforumindex`;
CREATE TABLE IF NOT EXISTS `hippyforumindex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(64) DEFAULT NULL,
  `kategorie` int(11) unsigned NOT NULL DEFAULT '0',
  `zalozil` int(11) DEFAULT NULL,
  `datum` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `poznamka` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=668 ;

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

--
-- Struktura tabulky `hlavy`
--

DROP TABLE IF EXISTS `hlavy`;
CREATE TABLE IF NOT EXISTS `hlavy` (
  `hlava` varchar(64) NOT NULL DEFAULT '',
  `kolik` int(11) DEFAULT '0',
  PRIMARY KEY (`hlava`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `jinde`
--

DROP TABLE IF EXISTS `jinde`;
CREATE TABLE IF NOT EXISTS `jinde` (
  `cas` datetime NOT NULL,
  `nadpis` varchar(255) DEFAULT NULL,
  `popis` mediumtext,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cas`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='co pou jinde ?';

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

--
-- Struktura tabulky `kategorie_for`
--

DROP TABLE IF EXISTS `kategorie_for`;
CREATE TABLE IF NOT EXISTS `kategorie_for` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pozice` int(11) NOT NULL,
  `nazev` varchar(128) NOT NULL,
  `rodic` int(10) unsigned NOT NULL,
  `popis` text NOT NULL,
  `obrzek` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nazev` (`nazev`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

--
-- Struktura tabulky `links_categories`
--

DROP TABLE IF EXISTS `links_categories`;
CREATE TABLE IF NOT EXISTS `links_categories` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `cdescription` text,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

--
-- Struktura tabulky `links_editorials`
--

DROP TABLE IF EXISTS `links_editorials`;
CREATE TABLE IF NOT EXISTS `links_editorials` (
  `linkid` int(11) NOT NULL DEFAULT '0',
  `adminid` varchar(60) DEFAULT NULL,
  `editorialtimestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `editorialtext` text,
  `editorialtitle` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `links_links`
--

DROP TABLE IF EXISTS `links_links`;
CREATE TABLE IF NOT EXISTS `links_links` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT '0',
  `sid` int(11) DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `description` text,
  `date` datetime DEFAULT NULL,
  `name` varchar(60) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `hits` int(11) DEFAULT '0',
  `submitter` varchar(60) DEFAULT NULL,
  `linkratingsummary` double(6,4) DEFAULT '0.0000',
  `totalvotes` int(11) DEFAULT '0',
  `totalcomments` int(11) DEFAULT '0',
  PRIMARY KEY (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

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

--
-- Struktura tabulky `links_modrequest`
--

DROP TABLE IF EXISTS `links_modrequest`;
CREATE TABLE IF NOT EXISTS `links_modrequest` (
  `requestid` int(11) NOT NULL AUTO_INCREMENT,
  `lid` int(11) DEFAULT '0',
  `cid` int(11) DEFAULT '0',
  `sid` int(11) DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `description` text,
  `modifysubmitter` varchar(60) DEFAULT NULL,
  `brokenlink` int(3) DEFAULT '0',
  PRIMARY KEY (`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `links_newlink`
--

DROP TABLE IF EXISTS `links_newlink`;
CREATE TABLE IF NOT EXISTS `links_newlink` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT '0',
  `sid` int(11) DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `description` text,
  `name` varchar(60) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `submitter` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`lid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=379 ;

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

--
-- Struktura tabulky `links_subcategories`
--

DROP TABLE IF EXISTS `links_subcategories`;
CREATE TABLE IF NOT EXISTS `links_subcategories` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT '0',
  `title` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

--
-- Struktura tabulky `links_votedata`
--

DROP TABLE IF EXISTS `links_votedata`;
CREATE TABLE IF NOT EXISTS `links_votedata` (
  `ratingdbid` int(11) NOT NULL AUTO_INCREMENT,
  `ratinglid` int(11) DEFAULT '0',
  `ratinguser` varchar(60) DEFAULT NULL,
  `rating` int(11) DEFAULT '0',
  `ratinghostname` varchar(60) DEFAULT NULL,
  `ratingcomments` text,
  `ratingtimestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ratingdbid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `misto`
--

DROP TABLE IF EXISTS `misto`;
CREATE TABLE IF NOT EXISTS `misto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8324 ;

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

--
-- Struktura tabulky `online`
--

DROP TABLE IF EXISTS `online`;
CREATE TABLE IF NOT EXISTS `online` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `lasthit` datetime DEFAULT NULL,
  `status` enum('online','offline') DEFAULT 'online',
  `pozice` varchar(65) NOT NULL DEFAULT '',
  `url` varchar(128) NOT NULL DEFAULT '',
  `logons` int(5) unsigned NOT NULL DEFAULT '1' COMMENT 'počet přihlášení',
  `regdate` datetime NOT NULL COMMENT 'datum registrace',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3012 ;

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

--
-- Struktura tabulky `spamlist`
--

DROP TABLE IF EXISTS `spamlist`;
CREATE TABLE IF NOT EXISTS `spamlist` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(60) DEFAULT NULL,
  `password` varchar(12) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `stat`
--

DROP TABLE IF EXISTS `stat`;
CREATE TABLE IF NOT EXISTS `stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2033 ;

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

--
-- Struktura tabulky `stuff`
--

DROP TABLE IF EXISTS `stuff`;
CREATE TABLE IF NOT EXISTS `stuff` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` mediumtext,
  `authorid` int(11) DEFAULT NULL,
  `visits` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `date` int(11) DEFAULT NULL,
  `dateauth` int(11) DEFAULT NULL,
  `visitindex` int(11) DEFAULT NULL,
  `newdate` datetime DEFAULT NULL,
  `newdateauth` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=185 ;

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

--
-- Struktura tabulky `system_log`
--

DROP TABLE IF EXISTS `system_log`;
CREATE TABLE IF NOT EXISTS `system_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pořadové číslo',
  `date` datetime NOT NULL,
  `ip` varchar(32) COLLATE utf8_czech_ci NOT NULL COMMENT 'ip adresa prave pripojeneho klienta',
  `sender` varchar(64) COLLATE utf8_czech_ci NOT NULL,
  `type` varchar(32) COLLATE utf8_czech_ci NOT NULL,
  `message` text COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='do teto tabulky se loguji vsechny udalosti spojene s funkci ' AUTO_INCREMENT=7377 ;

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

--
-- Struktura tabulky `topic`
--

DROP TABLE IF EXISTS `topic`;
CREATE TABLE IF NOT EXISTS `topic` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `majorname` varchar(30) DEFAULT NULL,
  `minorname` varchar(30) DEFAULT NULL,
  `exact` int(11) DEFAULT NULL,
  `showinfo` int(11) DEFAULT NULL,
  `export` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=15 ;

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

--
-- Struktura tabulky `userdata`
--

DROP TABLE IF EXISTS `userdata`;
CREATE TABLE IF NOT EXISTS `userdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(32) DEFAULT NULL,
  `value` text,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=405193 ;

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

--
-- Struktura tabulky `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datum` date DEFAULT NULL,
  `jmeno` varchar(255) DEFAULT NULL,
  `prijmeni` varchar(255) DEFAULT NULL,
  `titul` varchar(40) DEFAULT NULL,
  `login` varchar(40) DEFAULT NULL,
  `heslo` varchar(40) DEFAULT NULL,
  `ulice` varchar(255) DEFAULT NULL,
  `misto` varchar(255) DEFAULT NULL,
  `psc` varchar(20) DEFAULT NULL,
  `adresa` text,
  `telefon` varchar(64) DEFAULT NULL,
  `fax` varchar(64) DEFAULT NULL,
  `mobil` varchar(64) DEFAULT NULL,
  `email` varchar(64) DEFAULT NULL,
  `icq` varchar(20) DEFAULT NULL,
  `www` varchar(128) DEFAULT NULL,
  `ico` varchar(40) DEFAULT NULL,
  `dic` varchar(40) DEFAULT NULL,
  `banka` varchar(255) DEFAULT NULL,
  `ucet` varchar(255) DEFAULT NULL,
  `spolecnost` varchar(255) DEFAULT NULL,
  `rodnecislo` varchar(15) DEFAULT NULL,
  `subjekt` enum('p','f') DEFAULT 'f',
  `zeme` varchar(5) DEFAULT 'cz',
  `poznamka` text,
  `karma` double(4,2) DEFAULT NULL,
  `prava` int(11) DEFAULT '1',
  `kapsa` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3417 ;

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

--
-- Struktura tabulky `visits`
--

DROP TABLE IF EXISTS `visits`;
CREATE TABLE IF NOT EXISTS `visits` (
  `id` int(11) NOT NULL DEFAULT '0',
  `vid` int(11) NOT NULL DEFAULT '0',
  `datum` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`datum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `votesimple`
--

DROP TABLE IF EXISTS `votesimple`;
CREATE TABLE IF NOT EXISTS `votesimple` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(100) DEFAULT NULL,
  `vote1` int(11) DEFAULT NULL,
  `vote2` int(11) DEFAULT NULL,
  `vote1text` int(11) DEFAULT NULL,
  `vote2text` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `votetimeout`
--

DROP TABLE IF EXISTS `votetimeout`;
CREATE TABLE IF NOT EXISTS `votetimeout` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `voteno` int(11) DEFAULT NULL,
  `date` int(11) DEFAULT NULL,
  `addr` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=1 ;