diff options
author | Mario Vavti <mario@mariovavti.com> | 2016-05-29 00:33:28 +0200 |
---|---|---|
committer | Mario Vavti <mario@mariovavti.com> | 2016-05-29 00:33:28 +0200 |
commit | aab9766c53e42c3141d0497fce78977d262efbc1 (patch) | |
tree | f633ad641d818d6229ea7d14e72de42e739196de /vendor/sabre/dav/examples/sql/sqlite.calendars.sql | |
parent | 66effbfe0827fc61fff6d248797a894213ad20d6 (diff) | |
download | volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.gz volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.bz2 volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.zip |
missed some files
Diffstat (limited to 'vendor/sabre/dav/examples/sql/sqlite.calendars.sql')
-rw-r--r-- | vendor/sabre/dav/examples/sql/sqlite.calendars.sql | 76 |
1 files changed, 0 insertions, 76 deletions
diff --git a/vendor/sabre/dav/examples/sql/sqlite.calendars.sql b/vendor/sabre/dav/examples/sql/sqlite.calendars.sql deleted file mode 100644 index 1c8070496..000000000 --- a/vendor/sabre/dav/examples/sql/sqlite.calendars.sql +++ /dev/null @@ -1,76 +0,0 @@ -CREATE TABLE calendarobjects ( - id integer primary key asc NOT NULL, - calendardata blob NOT NULL, - uri text NOT NULL, - calendarid integer NOT NULL, - lastmodified integer NOT NULL, - etag text NOT NULL, - size integer NOT NULL, - componenttype text, - firstoccurence integer, - lastoccurence integer, - uid text -); - -CREATE TABLE calendars ( - id integer primary key asc NOT NULL, - synctoken integer DEFAULT 1 NOT NULL, - components text NOT NULL -); - -CREATE TABLE calendarinstances ( - id integer primary key asc NOT NULL, - calendarid integer NOT NULL, - principaluri text NULL, - access integer COMMENT '1 = owner, 2 = read, 3 = readwrite' NOT NULL DEFAULT '1', - displayname text, - uri text NOT NULL, - description text, - calendarorder integer, - calendarcolor text, - timezone text, - transparent bool, - share_href text, - share_displayname text, - share_invitestatus integer DEFAULT '2', - UNIQUE (principaluri, uri), - UNIQUE (calendarid, principaluri), - UNIQUE (calendarid, share_href) -); - -CREATE TABLE calendarchanges ( - id integer primary key asc NOT NULL, - uri text, - synctoken integer NOT NULL, - calendarid integer NOT NULL, - operation integer NOT NULL -); - -CREATE INDEX calendarid_synctoken ON calendarchanges (calendarid, synctoken); - -CREATE TABLE calendarsubscriptions ( - id integer primary key asc NOT NULL, - uri text NOT NULL, - principaluri text NOT NULL, - source text NOT NULL, - displayname text, - refreshrate text, - calendarorder integer, - calendarcolor text, - striptodos bool, - stripalarms bool, - stripattachments bool, - lastmodified int -); - -CREATE TABLE schedulingobjects ( - id integer primary key asc NOT NULL, - principaluri text NOT NULL, - calendardata blob, - uri text NOT NULL, - lastmodified integer, - etag text NOT NULL, - size integer NOT NULL -); - -CREATE INDEX principaluri_uri ON calendarsubscriptions (principaluri, uri); |