Re: [RCU] db problem with address book

[Benny Pedersen]

Juerg Reimann skrev den 19-12-2012 21:47:
Hi Benny
Thanks, it didn't work out...the address book is still not working. 
This is
my current db layout: http://pastie.org/5554369

--- 1   2012-12-19 22:54:41.000000000 +0100
+++ postgres.initial.sql        2012-12-19 22:54:25.000000000 +0100
@@ -1,11 +1,12 @@
 CREATE TABLE contacts (
- contact_id integer DEFAULT nextval(('contact_ids'::text)::regclass) 
NOT NULL,
- user_id integer NOT NULL,
+ contact_id integer DEFAULT nextval('contact_ids'::text) PRIMARY KEY,
+ user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE 
ON UPDATE CASCADE,
  changed timestamp with time zone DEFAULT now() NOT NULL,
  del smallint DEFAULT 0 NOT NULL,
- name character varying(128) DEFAULT ''::character varying NOT NULL,
- email text DEFAULT ''::character varying NOT NULL,
- firstname character varying(128) DEFAULT ''::character varying NOT 
NULL,
- surname character varying(128) DEFAULT ''::character varying NOT 
NULL,
- vcard text
+ name varchar(128) DEFAULT '' NOT NULL,
+ email text DEFAULT '' NOT NULL,
+ firstname varchar(128) DEFAULT '' NOT NULL,
+ surname varchar(128) DEFAULT '' NOT NULL,
+ vcard text,
+ words text
 );

there is a diffrent to what is in 0.8.1, have you updated layout ?



_______________________________________________
Roundcube Users mailing list
users@lists.roundcube.net
http://lists.roundcube.net/mailman/listinfo/users