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','back.jpg');
|
---|
50 | EXCEPTION WHEN unique_violation THEN
|
---|
51 | update phpgw_config set config_value='back.jpg' where config_app='phpgwapi' and config_name='imagem_de_fundo';
|
---|
52 | END;
|
---|
53 |
|
---|
54 | BEGIN
|
---|
55 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','image_navbar_left','inicio.jpg');
|
---|
56 | EXCEPTION WHEN unique_violation THEN
|
---|
57 | update phpgw_config set config_value='inicio.jpg' where config_app='phpgwapi' and config_name='image_navbar_left';
|
---|
58 | END;
|
---|
59 |
|
---|
60 | BEGIN
|
---|
61 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','image_navbar_right','logo_expresso_transparente.png');
|
---|
62 | EXCEPTION WHEN unique_violation THEN
|
---|
63 | update phpgw_config set config_value='logo_expresso_transparente.png' where config_app='phpgwapi' and config_name='image_navbar_right';
|
---|
64 | END;
|
---|
65 |
|
---|
66 | BEGIN
|
---|
67 | insert into phpgw_config (config_app,config_name,config_value) values('phpgwapi','image_navbar_bg','fundo_topo.gif');
|
---|
68 | EXCEPTION WHEN unique_violation THEN
|
---|
69 | update phpgw_config set config_value='fundo_topo.gif' where config_app='phpgwapi' and config_name='image_navbar_bg';
|
---|
70 | END;
|
---|
71 |
|
---|
72 | END;
|
---|
73 | $$
|
---|
74 | LANGUAGE plpgsql;
|
---|
75 |
|
---|
76 | select atualiza_phpgw_config();
|
---|
77 |
|
---|
78 | drop function atualiza_phpgw_config();
|
---|
79 | |
---|
80 | VACUUM phpgw_config;
|
---|
81 |
|
---|
82 |
|
---|