1 CREATE TABLE calendars (
3 principaluri VARCHAR(100),
4 displayname VARCHAR(100),
6 ctag INTEGER NOT NULL DEFAULT 0,
8 calendarorder INTEGER NOT NULL DEFAULT 0,
9 calendarcolor VARCHAR(10),
11 components VARCHAR(20)
14 ALTER TABLE ONLY calendars
15 ADD CONSTRAINT calendars_pkey PRIMARY KEY (id);
17 CREATE UNIQUE INDEX calendars_ukey
18 ON calendars USING btree (principaluri, uri);
20 CREATE TABLE calendarobjects (
22 calendarid INTEGER NOT NULL,
26 size INTEGER NOT NULL,
27 componenttype VARCHAR(8),
29 firstoccurence INTEGER,
33 ALTER TABLE ONLY calendarobjects
34 ADD CONSTRAINT calendarobjects_pkey PRIMARY KEY (id);
36 CREATE UNIQUE INDEX calendarobjects_ukey
37 ON calendarobjects USING btree (calendarid, uri);
39 ALTER TABLE ONLY calendarobjects
40 ADD CONSTRAINT calendarobjects_calendarid_fkey FOREIGN KEY (calendarid) REFERENCES calendars(id)