Projeto

Geral

Perfil

Expressolivremilestone21 » Histórico » Versão 2

Mauricio Luiz Viani, 29/08/2018 13:59 h

1 1 Mauricio Luiz Viani
{{collapse(Realizar em produção...)
2 2 Mauricio Luiz Viani
* Criar tabela no banco de dados:
3 1 Mauricio Luiz Viani
<pre>
4 1 Mauricio Luiz Viani
CREATE TABLE public.phpgw_cal_invite
5 1 Mauricio Luiz Viani
(
6 1 Mauricio Luiz Viani
  invite_id serial NOT NULL,
7 1 Mauricio Luiz Viani
  hash character(150) NOT NULL,
8 1 Mauricio Luiz Viani
  contents text NOT NULL,
9 1 Mauricio Luiz Viani
  owner integer NOT NULL,
10 1 Mauricio Luiz Viani
  created_at timestamp without time zone NOT NULL DEFAULT now(),
11 1 Mauricio Luiz Viani
  imported_at timestamp without time zone,
12 1 Mauricio Luiz Viani
  CONSTRAINT phpgw_cal_invite_pkey PRIMARY KEY (invite_id)
13 1 Mauricio Luiz Viani
)
14 2 Mauricio Luiz Viani
</pre>
15 2 Mauricio Luiz Viani
16 2 Mauricio Luiz Viani
* Atualizar tabela do módulo Workflow: (banco do workflow)
17 2 Mauricio Luiz Viani
<pre>
18 2 Mauricio Luiz Viani
  alter table egw_wf_user_cache alter column uid type varchar(70);
19 2 Mauricio Luiz Viani
20 2 Mauricio Luiz Viani
  alter table egw_wf_user_cache alter column cn type varchar(200);
21 2 Mauricio Luiz Viani
22 2 Mauricio Luiz Viani
  alter table egw_wf_user_cache alter column givenname type varchar(100);
23 2 Mauricio Luiz Viani
24 2 Mauricio Luiz Viani
  alter table egw_wf_user_cache alter column sn type varchar(100);
25 2 Mauricio Luiz Viani
26 2 Mauricio Luiz Viani
  alter table egw_wf_user_cache alter column dn type varchar(500);
27 1 Mauricio Luiz Viani
</pre>
28 1 Mauricio Luiz Viani
}}