16 lines
685 B
SQL
Executable File
16 lines
685 B
SQL
Executable File
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;
|