update0001.sql
No OneTemporary
Actions

Size

1 KB

Subscribers

None

update0001.sql
View Options

	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,
	uid text
	);

	CREATE TABLE calendars (
	id integer primary key asc,
	principaluri text,
	displayname text,
	uri text,
	synctoken integer,
	description text,
	calendarorder integer,
	calendarcolor text,
	timezone text,
	components text,
	transparent bool
	);

	CREATE TABLE calendarchanges (
	id integer primary key asc,
	uri text,
	synctoken integer,
	calendarid integer,
	operation integer
	);

	CREATE INDEX calendarid_synctoken ON calendarchanges (calendarid, synctoken);

	CREATE TABLE calendarsubscriptions (
	id integer primary key asc,
	uri text,
	principaluri text,
	source text,
	displayname text,
	refreshrate text,
	calendarorder integer,
	calendarcolor text,
	striptodos bool,
	stripalarms bool,
	stripattachments bool,
	lastmodified int
	);

	CREATE TABLE schedulingobjects (
	id integer primary key asc,
	principaluri text,
	calendardata blob,
	uri text,
	lastmodified integer,
	etag text,
	size integer
	);

	CREATE INDEX principaluri_uri ON calendarsubscriptions (principaluri, uri);