Rev 1306 |
Blame |
Compare with Previous |
Last modification |
View Log
| RSS feed
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaTotal` VARCHAR(20) AFTER `lingua2`;
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaT` VARCHAR(20) AFTER `cargaHorariaTotal`;
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaTP` VARCHAR(20) AFTER `cargaHorariaT`;
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaPL` VARCHAR(20) AFTER `cargaHorariaTP`;
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaS` VARCHAR(20) AFTER `cargaHorariaPL`;
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaTC` VARCHAR(20) AFTER `cargaHorariaS`;
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaO` VARCHAR(20) AFTER `cargaHorariaTC`;
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaOT` VARCHAR(20) AFTER `cargaHorariaO`;
ALTER TABLE `courseunit` ADD COLUMN `responsableTeacher` BIGINT(20) AFTER `courseUnitProgram`;
ALTER TABLE courseunit ADD INDEX responsableTeacherIndex (responsableTeacher), ADD constraint responsableTeacherKey FOREIGN KEY (responsableTeacher) REFERENCES user (id);