Subversion Repositories bacoAlunos

Rev

Rev 343 | 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;