--
-- CMS - anketa
--

-- -----------------------------------------------------------------------------
-- Dependents On tables
--      menu [cms]
--      lang [core]
-- -----------------------------------------------------------------------------


-- -----------------------------------------------------------------------------
-- TABLE

CREATE TABLE `poll` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `next` tinyint NULL default 24 COMMENT 'ak je null potom je mozno hlasovat len jeden krat',
    PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ;

-- preklad ankety do jazyka
CREATE TABLE poll_lang (
    `id_poll` int(10) unsigned NOT NULL,
    `id_lang` varchar(2) not null,
    `question` text NULL,
    PRIMARY KEY  (`id`, `id_lang`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Odpovede na anketu (len pocet odpovedi)
-- pocet odpovedi sa priebezne aktualizuje aby sa nemuselo stale selectovat pocet hlasov vo vote
CREATE TABLE `poll_answer` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `id_poll` int(10) unsigned NOT NULL,
    `count` mediumint(10) unsigned NOT NULL default 0,
    PRIMARY KEY  (`id`),
    KEY (`id_poll`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ;

-- odpovede na anketu podla jazyka
CREATE TABLE `poll_answer_lang` (
    `id_answer` int(10) unsigned NOT NULL,
    `id_lang` varchar(2) not null,
    `answer` varchar(255) NOT NULL,
    PRIMARY KEY  (`id_answer`, `id_lang`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- Historia hlasovania, zaznamenane kto vykonal hlasovanie
CREATE TABLE `poll_vote` (
    `id_poll` int(10) unsigned NOT NULL,
    `ip` text not null,
    `datetime` datetime not null,
    key (`id_poll`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1 ;


-- -----------------------------------------------------------------------------
-- Relationships

ALTER TABLE `poll_lang` ADD FOREIGN KEY (`id`) REFERENCES `poll`(`id`) ON DELETE cascade ON UPDATE cascade;
ALTER TABLE `poll_lang` ADD FOREIGN KEY (`id_lang`) REFERENCES `lang`(`id`) ON DELETE cascade ON UPDATE cascade;
ALTER TABLE `poll_answer` ADD FOREIGN KEY (`id_poll`) REFERENCES `poll` (`id`) ON DELETE cascade ON UPDATE cascade;
ALTER TABLE `poll_answer_lang` ADD FOREIGN KEY (`id_answer`) REFERENCES `poll_answer` (`id`) ON DELETE cascade ON UPDATE cascade;
ALTER TABLE `poll_answer_lang` ADD FOREIGN KEY (`id_lang`) REFERENCES `lang`(`id`) ON DELETE cascade ON UPDATE cascade;
ALTER TABLE `poll_vote` ADD FOREIGN KEY (`id_poll`) REFERENCES `poll` (`id`) ON DELETE cascade ON UPDATE cascade;