Subversion Repositories bacoAlunos

Rev

Rev 1306 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
749 jmachado 1 
 
2 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaTotal` VARCHAR(20) AFTER `lingua2`;
3 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaT` VARCHAR(20) AFTER `cargaHorariaTotal`;
4 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaTP` VARCHAR(20) AFTER `cargaHorariaT`;
5 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaPL` VARCHAR(20) AFTER `cargaHorariaTP`;
6 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaS` VARCHAR(20) AFTER `cargaHorariaPL`;
7 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaTC` VARCHAR(20) AFTER `cargaHorariaS`;
8 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaO` VARCHAR(20) AFTER `cargaHorariaTC`;
9 
ALTER TABLE `courseunitprogram` ADD COLUMN `cargaHorariaOT` VARCHAR(20) AFTER `cargaHorariaO`;
10 
 
11 
 
12 
ALTER TABLE `courseunit` ADD COLUMN `responsableTeacher` BIGINT(20) AFTER `courseUnitProgram`;
13 
ALTER TABLE courseunit ADD INDEX responsableTeacherIndex (responsableTeacher), ADD constraint responsableTeacherKey FOREIGN KEY (responsableTeacher) REFERENCES user (id);