Merge remote-tracking branch 'upstream/master'

1 files changed, 42 insertions, 0 deletions

diff --git a/vendor/sabre/dav/examples/sql/pgsql.calendars.sql b/vendor/sabre/dav/examples/sql/pgsql.calendars.sql
new file mode 100644
index 000000000..23465ae93
--- /dev/null
+++ b/vendor/sabre/dav/examples/sql/pgsql.calendars.sql
@@ -0,0 +1,42 @@
+CREATE TABLE calendars (
+    id SERIAL NOT NULL,
+    principaluri VARCHAR(100),
+    displayname VARCHAR(100),
+    uri VARCHAR(200),
+    ctag INTEGER NOT NULL DEFAULT 0,
+    description TEXT,
+    calendarorder INTEGER NOT NULL DEFAULT 0,
+    calendarcolor VARCHAR(10),
+    timezone TEXT,
+    components VARCHAR(20),
+    transparent SMALLINT NOT NULL DEFAULT '0'
+);
+
+ALTER TABLE ONLY calendars
+    ADD CONSTRAINT calendars_pkey PRIMARY KEY (id);
+
+CREATE UNIQUE INDEX calendars_ukey
+    ON calendars USING btree (principaluri, uri);
+
+CREATE TABLE calendarobjects (
+    id SERIAL NOT NULL,
+    calendarid INTEGER NOT NULL,
+    calendardata TEXT,
+    uri VARCHAR(200),
+    etag VARCHAR(32),
+    size INTEGER NOT NULL,
+    componenttype VARCHAR(8),
+    lastmodified INTEGER,
+    firstoccurence INTEGER,
+    lastoccurence INTEGER
+);
+
+ALTER TABLE ONLY calendarobjects
+    ADD CONSTRAINT calendarobjects_pkey PRIMARY KEY (id);
+
+CREATE UNIQUE INDEX calendarobjects_ukey
+    ON calendarobjects USING btree (calendarid, uri);
+
+ALTER TABLE ONLY calendarobjects
+    ADD CONSTRAINT calendarobjects_calendarid_fkey FOREIGN KEY (calendarid) REFERENCES calendars(id)
+        ON DELETE CASCADE;