source: contrib/psync/src/main/sql/postgresql/create_schema.sql @ 1103

Revision 1103, 613 bytes checked in by wmerlotto, 15 years ago (diff)

Ticket #554 - Melhorias na sincronizacao de eventos, contatos e adaptacao para Funambol 7.0

Line 
1ALTER TABLE phpgw_cal ALTER title TYPE character varying(255);
2ALTER TABLE phpgw_cal ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar;
3ALTER TABLE phpgw_cal ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision);
4
5ALTER TABLE phpgw_cc_contact ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar;
6ALTER TABLE phpgw_cc_contact ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision);
7ALTER TABLE phpgw_cc_contact ADD COLUMN category character varying(20);
8
Note: See TracBrowser for help on using the repository browser.