[903] | 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 |
|
---|