1CREATE TABLE addressbookobjects (
2    id integer primary key asc,
3    contactdata blob,
4    uri text,
5    addressbookid integer,
6    lastmodified integer,
7    etag text,
8    size integer,
9    formattedname text,
10    structuredname text
11);
12
13CREATE TABLE addressbookchanges (
14    id integer primary key asc,
15    uri text,
16    synctoken integer,
17    addressbookid integer,
18    operation integer
19);
20
21CREATE INDEX addressbookid_synctoken ON addressbookchanges (addressbookid, synctoken);
22
23CREATE TABLE pagetoaddressbookmapping (
24    id integer primary key asc,
25    page text,
26    addressbookid integer
27);
28
29CREATE TABLE addressbooks (
30    id integer primary key asc,
31    principaluri text,
32    displayname text,
33    uri text,
34    synctoken integer,
35    description text
36);
37