Blame view

sources/3rdparty/sabre/dav/examples/sql/sqlite.calendars.sql 536 Bytes
6d9380f96   Cédric Dupont   Update sources OC...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
  CREATE TABLE calendarobjects (
      id integer primary key asc,
      calendardata blob,
      uri text,
      calendarid integer,
      lastmodified integer,
      etag text,
      size integer,
      componenttype text,
      firstoccurence integer,
      lastoccurence integer
  );
  
  CREATE TABLE calendars (
      id integer primary key asc,
      principaluri text,
      displayname text,
      uri text,
      ctag integer,
      description text,
      calendarorder integer,
      calendarcolor text,
      timezone text,
      components text,
      transparent bool
  );