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