diff options
| author | Mario Vavti <mario@mariovavti.com> | 2016-05-28 17:46:24 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2016-05-28 17:46:24 +0200 |
| commit | 66effbfe0827fc61fff6d248797a894213ad20d6 (patch) | |
| tree | 0fbb5ca644e1140e5b3b44b1adc874043790c388 /vendor/sabre/dav/examples/sql/sqlite.calendars.sql | |
| parent | ac4688eac087854bf8cb0c893d7a79052ad63a20 (diff) | |
| download | volse-hubzilla-66effbfe0827fc61fff6d248797a894213ad20d6.tar.gz volse-hubzilla-66effbfe0827fc61fff6d248797a894213ad20d6.tar.bz2 volse-hubzilla-66effbfe0827fc61fff6d248797a894213ad20d6.zip | |
upgrade to sabre32
Diffstat (limited to 'vendor/sabre/dav/examples/sql/sqlite.calendars.sql')
| -rw-r--r-- | vendor/sabre/dav/examples/sql/sqlite.calendars.sql | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/vendor/sabre/dav/examples/sql/sqlite.calendars.sql b/vendor/sabre/dav/examples/sql/sqlite.calendars.sql index a8654032d..1c8070496 100644 --- a/vendor/sabre/dav/examples/sql/sqlite.calendars.sql +++ b/vendor/sabre/dav/examples/sql/sqlite.calendars.sql @@ -14,16 +14,28 @@ CREATE TABLE calendarobjects ( CREATE TABLE calendars ( id integer primary key asc NOT NULL, - principaluri text 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, - synctoken integer DEFAULT 1 NOT NULL, description text, calendarorder integer, calendarcolor text, timezone text, - components text NOT NULL, - transparent bool + 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 ( |