1 CREATE TABLE calendarobjects (
2 id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3 calendardata MEDIUMBLOB,
5 calendarid INTEGER UNSIGNED NOT NULL,
6 lastmodified INT(11) UNSIGNED,
8 size INT(11) UNSIGNED NOT NULL,
9 componenttype VARCHAR(8),
10 firstoccurence INT(11) UNSIGNED,
11 lastoccurence INT(11) UNSIGNED,
12 UNIQUE(calendarid, uri)
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
15 CREATE TABLE calendars (
16 id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
17 principaluri VARCHAR(100),
18 displayname VARCHAR(100),
20 ctag INTEGER UNSIGNED NOT NULL DEFAULT '0',
22 calendarorder INTEGER UNSIGNED NOT NULL DEFAULT '0',
23 calendarcolor VARCHAR(10),
25 components VARCHAR(20),
26 UNIQUE(principaluri, uri)
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;