aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/examples/sql/sqlite.addressbooks.sql
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2016-05-29 00:33:28 +0200
committerMario Vavti <mario@mariovavti.com>2016-05-29 00:33:28 +0200
commitaab9766c53e42c3141d0497fce78977d262efbc1 (patch)
treef633ad641d818d6229ea7d14e72de42e739196de /vendor/examples/sql/sqlite.addressbooks.sql
parent66effbfe0827fc61fff6d248797a894213ad20d6 (diff)
downloadvolse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.gz
volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.bz2
volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.zip
missed some files
Diffstat (limited to 'vendor/examples/sql/sqlite.addressbooks.sql')
-rw-r--r--vendor/examples/sql/sqlite.addressbooks.sql28
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);