1 files changed, 28 insertions, 0 deletions
diff --git a/vendor/examples/sql/sqlite.addressbooks.sql b/vendor/examples/sql/sqlite.addressbooks.sql
new file mode 100644
index 000000000..0baed8bfb
--- /dev/null
+++ b/vendor/examples/sql/sqlite.addressbooks.sql
@@ -0,0 +1,28 @@
+CREATE TABLE addressbooks (
+    id integer primary key asc NOT NULL,
+    principaluri text NOT NULL,
+    displayname text,
+    uri text NOT NULL,
+    description text,
+    synctoken integer DEFAULT 1 NOT NULL
+);
+
+CREATE TABLE cards (
+    id integer primary key asc NOT NULL,
+    addressbookid integer NOT NULL,
+    carddata blob,
+    uri text NOT NULL,
+    lastmodified integer,
+    etag text,
+    size integer
+);
+
+CREATE TABLE addressbookchanges (
+    id integer primary key asc NOT NULL,
+    uri text,
+    synctoken integer NOT NULL,
+    addressbookid integer NOT NULL,
+    operation integer NOT NULL
+);
+
+CREATE INDEX addressbookid_synctoken ON addressbookchanges (addressbookid, synctoken);