diff options
author | Mario Vavti <mario@mariovavti.com> | 2016-05-29 10:58:11 +0200 |
---|---|---|
committer | Mario Vavti <mario@mariovavti.com> | 2016-05-29 10:58:11 +0200 |
commit | cac6cef4952e6535788c1c6db8ef1e58e88536a0 (patch) | |
tree | 574d653201c280cb082877f80d814b6899aacaf9 /vendor/examples/sql/sqlite.calendars.sql | |
parent | aab9766c53e42c3141d0497fce78977d262efbc1 (diff) | |
download | volse-hubzilla-cac6cef4952e6535788c1c6db8ef1e58e88536a0.tar.gz volse-hubzilla-cac6cef4952e6535788c1c6db8ef1e58e88536a0.tar.bz2 volse-hubzilla-cac6cef4952e6535788c1c6db8ef1e58e88536a0.zip |
use composer to install sabre32
Diffstat (limited to 'vendor/examples/sql/sqlite.calendars.sql')
-rw-r--r-- | vendor/examples/sql/sqlite.calendars.sql | 76 |
1 files changed, 0 insertions, 76 deletions
diff --git a/vendor/examples/sql/sqlite.calendars.sql b/vendor/examples/sql/sqlite.calendars.sql deleted file mode 100644 index 1c8070496..000000000 --- a/vendor/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); |