1 | create language plpgsql;
|
---|
2 | CREATE OR REPLACE FUNCTION atualiza_phpgw_config() RETURNS VOID AS
|
---|
3 | $$
|
---|
4 | BEGIN
|
---|
5 |
|
---|
6 | BEGIN
|
---|
7 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','site_title','Expresso Livre - SERPRO');
|
---|
8 | EXCEPTION WHEN unique_violation THEN
|
---|
9 | update phpgw_config set config_value='Expresso Livre - SERPRO' where config_app='phpgwapi' and config_name='site_title';
|
---|
10 | END;
|
---|
11 |
|
---|
12 | BEGIN
|
---|
13 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','login_logo_url','http://www.serpro.gov.br');
|
---|
14 | EXCEPTION WHEN unique_violation THEN
|
---|
15 | update phpgw_config set config_value='http://www.serpro.gov.br' where config_app='phpgwapi' and config_name='login_logo_url';
|
---|
16 | END;
|
---|
17 |
|
---|
18 | BEGIN
|
---|
19 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','login_logo_title','Serviço Federal de Processamento de Dados - SERPRO');
|
---|
20 | EXCEPTION WHEN unique_violation THEN
|
---|
21 | update phpgw_config set config_value='Serviço Federal de Processamento de Dados - SERPRO' where config_app='phpgwapi' and config_name='login_logo_title';
|
---|
22 | END;
|
---|
23 |
|
---|
24 | BEGIN
|
---|
25 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','login_logo_file','logo.png');
|
---|
26 | EXCEPTION WHEN unique_violation THEN
|
---|
27 | update phpgw_config set config_value='logo.png' where config_app='phpgwapi' and config_name='login_logo_file';
|
---|
28 | END;
|
---|
29 |
|
---|
30 | BEGIN
|
---|
31 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','login_bg_color','FFFFFF');
|
---|
32 | EXCEPTION WHEN unique_violation THEN
|
---|
33 | update phpgw_config set config_value='FFFFFF' where config_app='phpgwapi' and config_name='login_bg_color';
|
---|
34 | END;
|
---|
35 |
|
---|
36 | BEGIN
|
---|
37 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','login_caixa_bg_color','FFFFFF');
|
---|
38 | EXCEPTION WHEN unique_violation THEN
|
---|
39 | update phpgw_config set config_value='FFFFFF' where config_app='phpgwapi' and config_name='login_caixa_bg_color';
|
---|
40 | END;
|
---|
41 |
|
---|
42 | BEGIN
|
---|
43 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','imagem_de_fundo_exibicao','background-repeat:repeat-x; overflow:auto;overflow-x:hidden;');
|
---|
44 | EXCEPTION WHEN unique_violation THEN
|
---|
45 | update phpgw_config set config_value='background-repeat:repeat-x; overflow:auto;overflow-x:hidden;' where config_app='phpgwapi' and config_name='imagem_de_fundo_exibicao';
|
---|
46 | END;
|
---|
47 |
|
---|
48 | BEGIN
|
---|
49 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','imagem_de_fundo_exibicao','background-repeat:repeat-x; overflow:auto;overflow-x:hidden;');
|
---|
50 | EXCEPTION WHEN unique_violation THEN
|
---|
51 | update phpgw_config set config_value='background-repeat:repeat-x; overflow:auto;overflow-x:hidden;' where config_app='phpgwapi' and config_name='imagem_de_fundo_exibicao';
|
---|
52 | END;
|
---|
53 |
|
---|
54 | BEGIN
|
---|
55 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','imagem_de_fundo','back.jpg');
|
---|
56 | EXCEPTION WHEN unique_violation THEN
|
---|
57 | update phpgw_config set config_value='back.jpg' where config_app='phpgwapi' and config_name='imagem_de_fundo';
|
---|
58 | END;
|
---|
59 |
|
---|
60 | END;
|
---|
61 | $$
|
---|
62 | LANGUAGE plpgsql;
|
---|
63 |
|
---|
64 | select atualiza_phpgw_config();
|
---|
65 |
|
---|
66 | drop function atualiza_phpgw_config();
|
---|
67 | |
---|
68 | VACUUM phpgw_config;
|
---|
69 |
|
---|
70 |
|
---|