aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql')
-rw-r--r--vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql b/vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql
new file mode 100644
index 000000000..aa7639c5f
--- /dev/null
+++ b/vendor/sabre/dav/examples/sql/sqlite.addressbooks.sql
@@ -0,0 +1,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
+);
+