vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

CREATE TABLE addressbooks (
    id integer primary key asc,
    principaluri text,
    displayname text,
    uri text,
    description text,
	ctag integer
);

CREATE TABLE cards (
	id integer primary key asc,
    addressbookid integer,
    carddata blob,
    uri text,
    lastmodified integer
);