Rev 1620 | Rev 1831 | Go to most recent revision | 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 | |
1830 | jmachado | 3 | correr o ant -> generateUpdateHibernateUpdateSql |
1563 | jmachado | 4 | |
1830 | jmachado | 5 | SELECT * FROM baco4.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 | |
1830 | jmachado | 14 | update repositoryfileversion set mirroredFileVersion = mirrorFileVersionId; |
1572 | jmachado | 15 | |
1830 | jmachado | 16 | ALTER TABLE repositoryfileversion DROP COLUMN mirrorFileVersionId; |
1585 | jmachado | 17 | |
18 | |||
19 | |||
1830 | jmachado | 20 | Atualizacao do relatorio de avaliacao das unidades curriculares |
1585 | jmachado | 21 | |
1830 | jmachado | 22 | update courseunitevaluation set numAlunosInscritos = 0 where numAlunosInscritos is null; |
23 | update courseunitevaluation set numAlunosSemElementosAvaliacao = 0 where numAlunosSemElementosAvaliacao is null; |
||
24 | update courseunitevaluation set numAlunosAprovFrequencia = 0 where numAlunosAprovFrequencia is null; |
||
25 | update courseunitevaluation set numAlunosAprovNormal = 0 where numAlunosAprovNormal is null; |
||
26 | update courseunitevaluation set numAlunosAprovRecurso = 0 where numAlunosAprovRecurso is null; |
||
27 | update courseunitevaluation set numAlunosAprovTotal = 0 where numAlunosAprovTotal is null; |
||
28 | update courseunitevaluation set numAlunosAprov1013 = 0 where numAlunosAprov1013 is null; |
||
29 | update courseunitevaluation set numAlunosAprov1416 = 0 where numAlunosAprov1416 is null; |
||
30 | update courseunitevaluation set numAlunosAprov1720 = 0 where numAlunosAprov1720 is null; |
||
31 | update courseunitevaluation set numAlunosAprovados = 0 where numAlunosAprovados is null; |
||
32 | update courseunitevaluation set numAlunosReprovados = 0 where numAlunosReprovados is null; |
||
33 | update courseunitevaluation set numAlunosAprov1013Percent = 0 where numAlunosAprov1013Percent is null; |
||
34 | update courseunitevaluation set numAlunosAprov1416Percent = 0 where numAlunosAprov1416Percent is null; |
||
35 | update courseunitevaluation set numAlunosAprov1720Percent = 0 where numAlunosAprov1720Percent is null; |
||
1586 | jmachado | 36 | |
1620 | jmachado | 37 | |
38 | |||
1830 | jmachado | 39 | update courseunitevaluation set numAlunosAprov1013Percent = numAlunosAprov1013; |
40 | update courseunitevaluation set numAlunosAprov1416Percent = numAlunosAprov1416; |
||
41 | update courseunitevaluation set numAlunosAprov1720Percent = numAlunosAprov1720; |
||
1620 | jmachado | 42 | |
1830 | jmachado | 43 | ALTER TABLE courseunitevaluation DROP COLUMN numAlunosAprovados; |
1620 | jmachado | 44 | |
45 | |||
1830 | jmachado | 46 | update courseunitevaluation set numAlunosAprov1013 = numAlunosAprov1013Percent * numAlunosAprovTotal / 100 where id > 683; |
47 | update courseunitevaluation set numAlunosAprov1416 = numAlunosAprov1416Percent * numAlunosAprovTotal / 100 where id > 683; |
||
48 | update courseunitevaluation set numAlunosAprov1720 = numAlunosAprov1720Percent * numAlunosAprovTotal / 100 where id > 683; |