CREATE TABLE IF NOT EXISTS `CheckList_userLastOpenDate` (
  `CheckList_id` bigint(20) NOT NULL,
  `userLastOpenDate` datetime DEFAULT NULL,
  `userLastOpenDate_KEY` bigint(20) NOT NULL,
  PRIMARY KEY (`CheckList_id`,`userLastOpenDate_KEY`),
  KEY `FKF7E07AB26D025A9` (`userLastOpenDate_KEY`),
  KEY `FKF7E07AB21F327355` (`CheckList_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `CheckList_userLastOpenDate`
  ADD CONSTRAINT `FKF7E07AB21F327355` FOREIGN KEY (`CheckList_id`) REFERENCES `checklist` (`id`),
  ADD CONSTRAINT `FKF7E07AB26D025A9` FOREIGN KEY (`userLastOpenDate_KEY`) REFERENCES `user` (`id`);

ALTER TABLE file_description
  ADD `isThesisFile` bit(1) NOT NULL;
