aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql
blob: aa7639c5f9f2351f1000b4e646f64b6e32f8cc88 (plain) (blame)
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
);