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 ; |