Subversion Repositories bacoAlunos

Rev

Rev 1834 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1830 jmachado 1 
ESTG NOVEMBRO DE 2017
1563 jmachado 2 
 
1831 jmachado 3 
correr o ant -> generateUpdateHibernateSql
1563 jmachado 4 
 
1832 jmachado 5 
SELECT * FROM repositoryfileversion where mirrorFileVersionId is not null;
1563 jmachado 6 
 
1830 jmachado 7 
Para todos os encontrados colocar manualmente o valor do mirror no novo campo
8 
seguir os comandos
1563 jmachado 9 
 
1830 jmachado 10 
mirroredFileVersion
1565 jmachado 11 
 
1830 jmachado 12 
apagar o campo mirrorFileVersionId
1565 jmachado 13 
 
1572 jmachado 14 
 
1585 jmachado 15 
 
16 
 
17 
 
1830 jmachado 18 
Atualizacao do relatorio de avaliacao das unidades curriculares
1585 jmachado 19 
 
1834 jmachado 20 
SELECT * FROM repositoryfileversion where mirrorFileVersionId is not null;
21 
 
22 
 
23 
update repositoryfileversion set mirroredFileVersion = mirrorFileVersionId;
24 
 
25 
SELECT * FROM repositoryfileversion where mirroredFileVersion is not null;
26 
 
27 
ALTER TABLE repositoryfileversion DROP COLUMN mirrorFileVersionId;
28 
 
29 
 
1830 jmachado 30 
update courseunitevaluation set numAlunosInscritos = 0 where numAlunosInscritos is null;
31 
update courseunitevaluation set numAlunosSemElementosAvaliacao = 0 where numAlunosSemElementosAvaliacao is null;
32 
update courseunitevaluation set numAlunosAprovFrequencia = 0 where numAlunosAprovFrequencia is null;
33 
update courseunitevaluation set numAlunosAprovNormal = 0 where numAlunosAprovNormal is null;
34 
update courseunitevaluation set numAlunosAprovRecurso = 0 where numAlunosAprovRecurso is null;
35 
update courseunitevaluation set numAlunosAprovTotal = 0 where numAlunosAprovTotal is null;
36 
update courseunitevaluation set numAlunosAprov1013 = 0 where numAlunosAprov1013 is null;
37 
update courseunitevaluation set numAlunosAprov1416 = 0 where numAlunosAprov1416 is null;
38 
update courseunitevaluation set numAlunosAprov1720 = 0 where numAlunosAprov1720 is null;
39 
update courseunitevaluation set numAlunosAprovados = 0 where numAlunosAprovados is null;
40 
update courseunitevaluation set numAlunosReprovados = 0 where numAlunosReprovados is null;
41 
update courseunitevaluation set numAlunosAprov1013Percent = 0 where numAlunosAprov1013Percent is null;
42 
update courseunitevaluation set numAlunosAprov1416Percent = 0 where numAlunosAprov1416Percent is null;
43 
update courseunitevaluation set numAlunosAprov1720Percent = 0 where numAlunosAprov1720Percent is null;
1586 jmachado 44 
 
1620 jmachado 45 
 
46 
 
1830 jmachado 47 
update courseunitevaluation set numAlunosAprov1013Percent = numAlunosAprov1013;
48 
update courseunitevaluation set numAlunosAprov1416Percent = numAlunosAprov1416;
49 
update courseunitevaluation set numAlunosAprov1720Percent = numAlunosAprov1720;
1620 jmachado 50 
 
1830 jmachado 51 
ALTER TABLE courseunitevaluation DROP COLUMN numAlunosAprovados;
1620 jmachado 52 
 
53 
 
1830 jmachado 54 
update courseunitevaluation set numAlunosAprov1013 = numAlunosAprov1013Percent * numAlunosAprovTotal / 100 where id > 683;
55 
update courseunitevaluation set numAlunosAprov1416 = numAlunosAprov1416Percent * numAlunosAprovTotal / 100 where id > 683;
56 
update courseunitevaluation set numAlunosAprov1720 = numAlunosAprov1720Percent * numAlunosAprovTotal / 100 where id > 683;
1841 jmachado 57 
 
58 
 
59 
ALTER TABLE courseunitevaluation CHANGE COLUMN numAlunosInscritos numAlunosInscritos INT(10) NULL DEFAULT 0 ;