1 CREATE TABLE addressbooks (
3 principaluri VARCHAR(255),
4 displayname VARCHAR(255),
7 ctag INTEGER NOT NULL DEFAULT 1
10 ALTER TABLE ONLY addressbooks
11 ADD CONSTRAINT addressbooks_pkey PRIMARY KEY (id);
13 CREATE UNIQUE INDEX addressbooks_ukey
14 ON addressbooks USING btree (principaluri, uri);
18 addressbookid INTEGER NOT NULL,
24 ALTER TABLE ONLY cards
25 ADD CONSTRAINT cards_pkey PRIMARY KEY (id);
27 CREATE UNIQUE INDEX cards_ukey
28 ON cards USING btree (addressbookid, uri);
30 ALTER TABLE ONLY cards
31 ADD CONSTRAINT cards_addressbookid_fkey FOREIGN KEY (addressbookid) REFERENCES addressbooks(id)