Subversion Repositories bacoAlunos

ALTER TABLE `courseunit` ADD COLUMN `courseUnitProgram` BIGINT(20) AFTER `validProgram`;

CREATE TABLE courseunitprogram (id bigint NOT NULL AUTO_INCREMENT, discrimitator varchar(255) NOT NULL, updateDate datetime NOT NULL, saveDate datetime, bibliografia text, bibliografiaComplementar text, adaptacaoObjectivosMetodologia text, demonstracaoCargaEcts text, garantiaAvaliacaoFuncaObjectivos text, metodologiasActividadeCientifica text, ects varchar(255), prerequisitos text, obrigatoria varchar(255), lingua1 varchar(255), lingua2 varchar(255), courseunitprogrampart2 BIGINT(20), PRIMARY KEY (id)) ENGINE=Innodb DEFAULT CHARSET=utf8;
CREATE TABLE courseunitprogrampart2 (id bigint NOT NULL AUTO_INCREMENT, discrimitator varchar(255) NOT NULL, updateDate datetime NOT NULL, saveDate datetime, objectivos text, conteudos text,demonstracaoCoerenciaConteudos text, metodologiasEnsino text, avaliacaoOrdinariosFrequencia text, avaliacaoOrdinariosExame text, avaliacaoEspeciaisFrequencia text, avaliacaoEspeciaissExame text, demonstracaoObjectivosMetodologia text, PRIMARY KEY (id)) ENGINE=Innodb DEFAULT CHARSET=utf8;

ALTER TABLE courseunit ADD INDEX FK9486341F2DE085C4 (courseUnitProgram), ADD constraint FK9486341F2DE085C4 FOREIGN KEY (courseUnitProgram) REFERENCES courseunitprogram (id);
ALTER TABLE courseunitprogram ADD INDEX FKPART2 (courseUnitProgramPart2), ADD constraint FKPART2 FOREIGN KEY (courseUnitProgramPart2) REFERENCES courseunitprogrampart2 (id);

ALTER TABLE `baco3`.`courseunit` MODIFY COLUMN `objectives` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL;




UPDATE courseunit SET courseUnitProgram = NULL;
UPDATE courseunit SET programStreamId = NULL;
DELETE FROM courseunitprogram;
ALTER TABLE courseunit DROP FOREIGN KEY `FK9486341F2DE085C4`;
ALTER TABLE courseunit DROP INDEX `FK9486341F2DE085C4`;
DROP TABLE courseunitprogram;
DROP TABLE courseunitprogrampart2;

CREATE TABLE courseunitprogram (id bigint NOT NULL AUTO_INCREMENT, discrimitator varchar(255) NOT NULL, updateDate datetime NOT NULL, saveDate datetime, bibliografia text, bibliografiaComplementar text, adaptacaoObjectivosMetodologia text, demonstracaoCargaEcts text, garantiaAvaliacaoFuncaObjectivos text, metodologiasActividadeCientifica text, ects varchar(255), prerequisitos text, obrigatoria varchar(255), lingua1 varchar(255), lingua2 varchar(255), courseunitprogrampart2 BIGINT(20), PRIMARY KEY (id)) ENGINE=Innodb DEFAULT CHARSET=utf8;
CREATE TABLE courseunitprogrampart2 (id bigint NOT NULL AUTO_INCREMENT, discrimitator varchar(255) NOT NULL, updateDate datetime NOT NULL, saveDate datetime, objectivos text, conteudos text,demonstracaoCoerenciaConteudos text, metodologiasEnsino text, avaliacaoOrdinariosFrequencia text, avaliacaoOrdinariosExame text, avaliacaoEspeciaisFrequencia text, avaliacaoEspeciaissExame text, demonstracaoObjectivosMetodologia text, PRIMARY KEY (id)) ENGINE=Innodb DEFAULT CHARSET=utf8;

ALTER TABLE courseunit ADD INDEX FK9486341F2DE085C4 (courseUnitProgram), ADD constraint FK9486341F2DE085C4 FOREIGN KEY (courseUnitProgram) REFERENCES courseunitprogram (id);
ALTER TABLE courseunitprogram ADD INDEX FKPART2 (courseUnitProgramPart2), ADD constraint FKPART2 FOREIGN KEY (courseUnitProgramPart2) REFERENCES courseunitprogrampart2 (id);