Expresso Livre Comunidade

CREATE ROLE sa_master LOGIN
  ENCRYPTED PASSWORD '<md5password-here>'
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

CREATE DATABASE expresso_master
  WITH OWNER = sa_master
       ENCODING = 'LATIN1'
       TABLESPACE = pg_default
       LC_COLLATE = 'pt_BR.iso88591'
       LC_CTYPE = 'pt_BR.iso88591'
       CONNECTION LIMIT = -1;

ALTER DATABASE expresso_master
  SET bytea_output = 'escape';

CREATE SEQUENCE nextid_seq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 500000
  CACHE 1;

ALTER TABLE nextid_seq
  OWNER TO sa_nextid;

Host do DB: 200.189.113.xxx
Porta do DB: 5432
Nome do DB: expresso_master
Sequência do DB: nextid_seq
Usuário: sa_nextid
Senha: xxxxx

drop table phpgw_nextid;

<style type="text/css">
    #footer ul { display:block; margin:0 auto; width:290px; }
    #footer li { float:left; width:130px; text-align:center; }
    #footer .logo-governo { width: 83px; height: 70px; background:url(http://www.pr.gov.br/logos/logo_gov_93x70px.gif) no-repeat; 
        background-size: 93px 70px; margin:0 10px; display:block; float:left; overflow:hidden; }
    #footer .logo-celepar {    width: 104px; height: 49px; background:url(http://www.pr.gov.br/logos/logo_celepar_170x79px.png) no-repeat; 
        background-size: 104px 49px; margin:0 10px; display:block; float:left; overflow:hidden; }
    #footer span { display:block; clear:both; }
</style>

<ul>
    <li><a href="http://www.pr.gov.br/" class="logo-governo"></a></li>
    <li><a href="http://www.pr.gov.br/" class="logo-celepar"></a>
        <span id="info-deploy">
        <a title="Projeto Expresso Livre" target="_blank" href="http://www.expressolivre.org/">Expresso Livre</a>&nbsp;2.2.6<br />
        Powered by <a title="eGroupWare" target="_blank" href="http://www.egroupware.org/">eGroupWare</a>
        </span>
    </li>
</ul>

delete from phpgw_acl where acl_appname = 'filemanager';

delete from phpgw_applications where app_name = 'filemanager';

delete from phpgw_config where config_app = 'filemanager';

delete from phpgw_expressoadmin_apps where app = 'filemanager';

delete from phpgw_hooks where hook_appname = 'filemanager';

delete from phpgw_lang where app_name = 'filemanager';

delete from phpgw_vfs where app = 'filemanager';

delete from phpgw_vfs_quota; 

drop table phpgw_filemanager_notification;

alter table phpgw_emailadmin add column imapAdminServer character varying (80);
alter table phpgw_emailadmin add column imapAdminPort integer;

update phpgw_emailadmin set imapAdminServer = imapServer, imapAdminPort = imapPort;