--
-- Struktura tabulky `news`
--

CREATE TABLE `news` (
    `id` int(11) NOT NULL,
    `title` text NOT NULL,
    `date` date NOT NULL,
    `text` text NOT NULL,
    `active` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Klíče pro tabulku `news`
--
ALTER TABLE `news`
    ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pro tabulku `news`
--
ALTER TABLE `news`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;