source: companies/serpro/doc-expressolivre/scripts/dados_tab_phpgw_config.sql @ 903

Revision 903, 4.0 KB checked in by niltonneto, 15 years ago (diff)

Importacao inicial do Expresso do Serpro

Line 
1create language plpgsql;
2CREATE OR REPLACE FUNCTION atualiza_phpgw_config() RETURNS VOID AS
3$$
4BEGIN
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       
72END;
73$$
74LANGUAGE plpgsql;
75
76select atualiza_phpgw_config();
77
78drop function atualiza_phpgw_config();
79
80VACUUM phpgw_config;
81
82
Note: See TracBrowser for help on using the repository browser.