   `transcription_eng` varchar(255) DEFAULT NULL,
   `transcription_rus` varchar(255) DEFAULT NULL,
   `rating` int(11) NOT NULL DEFAULT '0',
-  `favorite` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `favorite` int(11) NOT NULL DEFAULT '0',
   `enabled` tinyint(1) NOT NULL DEFAULT '1',
   `published_at` datetime DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `word_eng_rus`
  ADD CONSTRAINT `word_eng_rus_fk0` FOREIGN KEY (`word_eng_id`) REFERENCES `words_eng` (`word_eng_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `word_eng_rus_fk1` FOREIGN KEY (`word_rus_id`) REFERENCES `words_rus` (`word_rus_id`) ON DELETE CASCADE;

--
-- Ограничения внешнего ключа таблицы `word_eng_tag`
--
ALTER TABLE `word_eng_tag`
  ADD CONSTRAINT `word_eng_tag_fk0` FOREIGN KEY (`word_eng_id`) REFERENCES `words_eng` (`word_eng_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `word_eng_tag_fk1` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`tag_id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET NAMES utf8mb4 */;

--
-- База данных: `english`
--

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