--
-- 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 ;
