Expressolivremilestone21 » Histórico » Versão 2
Versão 1 (Mauricio Luiz Viani, 29/08/2018 13:56 h) → Versão 2/3 (Mauricio Luiz Viani, 29/08/2018 13:59 h)
{{collapse(Realizar em produção...)
* Criar tabela no banco de dados: dados
<pre>
CREATE TABLE public.phpgw_cal_invite
(
invite_id serial NOT NULL,
hash character(150) NOT NULL,
contents text NOT NULL,
owner integer NOT NULL,
created_at timestamp without time zone NOT NULL DEFAULT now(),
imported_at timestamp without time zone,
CONSTRAINT phpgw_cal_invite_pkey PRIMARY KEY (invite_id)
)
</pre>
* Atualizar tabela do módulo Workflow: (banco do workflow)
<pre>
alter table egw_wf_user_cache alter column uid type varchar(70);
alter table egw_wf_user_cache alter column cn type varchar(200);
alter table egw_wf_user_cache alter column givenname type varchar(100);
alter table egw_wf_user_cache alter column sn type varchar(100);
alter table egw_wf_user_cache alter column dn type varchar(500);
</pre>
}}
* Criar tabela no banco de dados: dados
<pre>
CREATE TABLE public.phpgw_cal_invite
(
invite_id serial NOT NULL,
hash character(150) NOT NULL,
contents text NOT NULL,
owner integer NOT NULL,
created_at timestamp without time zone NOT NULL DEFAULT now(),
imported_at timestamp without time zone,
CONSTRAINT phpgw_cal_invite_pkey PRIMARY KEY (invite_id)
)
</pre>
* Atualizar tabela do módulo Workflow: (banco do workflow)
<pre>
alter table egw_wf_user_cache alter column uid type varchar(70);
alter table egw_wf_user_cache alter column cn type varchar(200);
alter table egw_wf_user_cache alter column givenname type varchar(100);
alter table egw_wf_user_cache alter column sn type varchar(100);
alter table egw_wf_user_cache alter column dn type varchar(500);
</pre>
}}