Ignore:
Timestamp:
10/28/09 20:58:21 (15 years ago)
Author:
wmerlotto
Message:

Ticket #693 - Incrementado a sincronizacao de contatos, integracao com maven e codigo de autenticacao no LDAP.

Location:
contrib/psync/src/main/sql/postgresql
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • contrib/psync/src/main/sql/postgresql/create_schema.sql

    r1103 r1545  
    1 ALTER TABLE phpgw_cal ALTER title TYPE character varying(255); 
    2 ALTER TABLE phpgw_cal ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar; 
    3 ALTER TABLE phpgw_cal ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision); 
     1--ALTER TABLE phpgw_cal ALTER title TYPE character varying(255); 
     2--ALTER TABLE phpgw_cal ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar; 
     3--ALTER TABLE phpgw_cal ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision); 
    44 
    5 ALTER TABLE phpgw_cc_contact ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar; 
    6 ALTER TABLE phpgw_cc_contact ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision); 
    7 ALTER TABLE phpgw_cc_contact ADD COLUMN category character varying(20); 
     5--ALTER TABLE phpgw_cc_contact ADD COLUMN last_status char(1) DEFAULT 'N'::bpchar; 
     6--ALTER TABLE phpgw_cc_contact ADD COLUMN last_update int8 DEFAULT (date_part('epoch'::text, ('now'::text)::timestamp(3) with time zone) * (1000)::double precision); 
     7--ALTER TABLE phpgw_cc_contact ADD COLUMN category character varying(20); 
    88 

  • contrib/psync/src/main/sql/postgresql/drop_schema.sql

    r1009 r1545  
    1 ALTER TABLE public.phpgw_cal DROP COLUMN last_status; 
    2 ALTER TABLE public.phpgw_cal DROP COLUMN last_update; 
     1--ALTER TABLE public.phpgw_cal DROP COLUMN last_status; 
     2--ALTER TABLE public.phpgw_cal DROP COLUMN last_update; 
    33 
    4 ALTER TABLE public.phpgw_cc_contact DROP COLUMN last_status; 
    5 ALTER TABLE public.phpgw_cc_contact DROP COLUMN last_update; 
    6 ALTER TABLE public.phpgw_cc_contact DROP COLUMN category; 
     4--ALTER TABLE public.phpgw_cc_contact DROP COLUMN last_status; 
     5--ALTER TABLE public.phpgw_cc_contact DROP COLUMN last_update; 
     6--ALTER TABLE public.phpgw_cc_contact DROP COLUMN category; 
Note: See TracChangeset for help on using the changeset viewer.