SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `situations`;

CREATE TABLE `situations` (
  `sitid` int(6) unsigned NOT NULL auto_increment,
  `userid` tinyint(2) unsigned NOT NULL,
  `situation` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`sitid`),
  UNIQUE KEY `situation` (`situation`,`userid`),
  KEY `userid` (`userid`),
  CONSTRAINT `sit_userid` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;