--
-- Struktura tabeli dla tabeli `psw_tags`
--

CREATE TABLE IF NOT EXISTS `psw_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `psw_assign2tags`
--

CREATE TABLE IF NOT EXISTS `psw_assign2tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_content` int(11) NOT NULL,
  `id_tag` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_tag` (`id_tag`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

--
-- Ograniczenia dla tabeli `psw_assign2tags`
--
ALTER TABLE `psw_assign2tags`
  ADD CONSTRAINT `psw_assign2tags_ibfk_1` FOREIGN KEY (`id_tag`) REFERENCES `psw_tags` (`id`) ON DELETE CASCADE;