-- 
-- Struktura tabulky `history`
-- 

CREATE TABLE `history` (
  `idloger` text collate latin2_czech_cs NOT NULL,
  `data` text collate latin2_czech_cs NOT NULL,
  `date` int(11) NOT NULL,
  `num` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

-- 
-- Struktura tabulky `logery`
-- 

CREATE TABLE `logery` (
  `idloger` text collate latin2_czech_cs NOT NULL,
  `iduser` int(11) NOT NULL,
  `ignor` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

-- 
-- Struktura tabulky `logy`
-- 

CREATE TABLE `logy` (
  `id` text collate latin2_czech_cs NOT NULL,
  `data` text collate latin2_czech_cs
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

-- 
-- Struktura tabulky `users`
-- 

CREATE TABLE `users` (
  `nick` text collate latin2_czech_cs NOT NULL,
  `id` int(11) NOT NULL default '0',
  `pass` text collate latin2_czech_cs NOT NULL,
  `poclog` int(11) NOT NULL,
  `activate` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

-- 
-- Vypisuji data pro tabulku `users`
-- 

INSERT INTO `users` VALUES ('admin', 1, 'root', -1000015, 1);

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

-- 
-- Struktura tabulky `userset`
-- 

CREATE TABLE `userset` (
  `id` text collate latin2_czech_cs,
  `lmouse` text collate latin2_czech_cs NOT NULL,
  `rmouse` text collate latin2_czech_cs NOT NULL,
  `tab` text collate latin2_czech_cs NOT NULL,
  `caps` text collate latin2_czech_cs NOT NULL,
  `larrow` text collate latin2_czech_cs NOT NULL,
  `rarrow` text collate latin2_czech_cs NOT NULL,
  `uarrow` text collate latin2_czech_cs NOT NULL,
  `darrow` text collate latin2_czech_cs NOT NULL,
  `backspace` text collate latin2_czech_cs
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

-- 
-- Vypisuji data pro tabulku `userset`
-- 

INSERT INTO `userset` VALUES ('1', '', '', 'on', '', '', '', '', '', 'on');