Rev 1306 |
Blame |
Compare with Previous |
Last modification |
View Log
| RSS feed
ALTER TABLE courseunit ENGINE = myisam;
ALTER TABLE `courseunit` ADD COLUMN `validatorUser` BIGINT(20) UNSIGNED AFTER `course`, ADD COLUMN `validProgram` BIT(1) DEFAULT 0 AFTER `validatorUser`, ADD INDEX `validatorUserIndex`(`validatorUser`);
ALTER TABLE `courseunit` ADD CONSTRAINT `FK_validatorUser` FOREIGN KEY `FK_validatorUser` (`validatorUser`)
REFERENCES `user` (`id`)
ON DELETE SET NULL
ON UPDATE SET NULL;
UPDATE courseunit SET validProgram = 0;
ALTER TABLE courseunit ENGINE = ndb;