--
-- Структура таблицы `jwqt5_messagestagsxref`
--

CREATE TABLE IF NOT EXISTS `jwqt5_messagestagsxref` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `tid` int(10) unsigned NOT NULL COMMENT 'tag id',
  `item_id` int(10) unsigned NOT NULL COMMENT 'Item id',
  PRIMARY KEY (`id`),
  KEY `tid` (`tid`),
  KEY `item_id` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table of xref to message tags'  ;

--
-- Ограничения внешнего ключа сохраненных таблиц
--

--
-- Ограничения внешнего ключа таблицы `jwqt5_messagestagsxref`
--
ALTER TABLE `jwqt5_messagestagsxref`
  ADD CONSTRAINT `jwqt5_messagestagsxref_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `jwqt5_message` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jwqt5_messagestagsxref_ibfk_1` FOREIGN KEY (`tid`) REFERENCES `jwqt5_messagestags` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;