aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/sabre/dav/examples/sql/pgsql.addressbook.sql
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2016-05-29 00:33:28 +0200
committerMario Vavti <mario@mariovavti.com>2016-05-29 00:33:28 +0200
commitaab9766c53e42c3141d0497fce78977d262efbc1 (patch)
treef633ad641d818d6229ea7d14e72de42e739196de /vendor/sabre/dav/examples/sql/pgsql.addressbook.sql
parent66effbfe0827fc61fff6d248797a894213ad20d6 (diff)
downloadvolse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.gz
volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.bz2
volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.zip
missed some files
Diffstat (limited to 'vendor/sabre/dav/examples/sql/pgsql.addressbook.sql')
-rw-r--r--vendor/sabre/dav/examples/sql/pgsql.addressbook.sql52
1 files changed, 0 insertions, 52 deletions
diff --git a/vendor/sabre/dav/examples/sql/pgsql.addressbook.sql b/vendor/sabre/dav/examples/sql/pgsql.addressbook.sql
deleted file mode 100644
index ef2cc5b9a..000000000
--- a/vendor/sabre/dav/examples/sql/pgsql.addressbook.sql
+++ /dev/null
@@ -1,52 +0,0 @@
-CREATE TABLE addressbooks (
- id SERIAL NOT NULL,
- principaluri VARCHAR(255),
- displayname VARCHAR(255),
- uri VARCHAR(200),
- description TEXT,
- synctoken INTEGER NOT NULL DEFAULT 1
-);
-
-ALTER TABLE ONLY addressbooks
- ADD CONSTRAINT addressbooks_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX addressbooks_ukey
- ON addressbooks USING btree (principaluri, uri);
-
-CREATE TABLE cards (
- id SERIAL NOT NULL,
- addressbookid INTEGER NOT NULL,
- carddata TEXT,
- uri VARCHAR(200),
- lastmodified INTEGER,
- etag VARCHAR(32),
- size INTEGER NOT NULL
-);
-
-ALTER TABLE ONLY cards
- ADD CONSTRAINT cards_pkey PRIMARY KEY (id);
-
-CREATE UNIQUE INDEX cards_ukey
- ON cards USING btree (addressbookid, uri);
-
-ALTER TABLE ONLY cards
- ADD CONSTRAINT cards_addressbookid_fkey FOREIGN KEY (addressbookid) REFERENCES addressbooks(id)
- ON DELETE CASCADE;
-
-CREATE TABLE addressbookchanges (
- id SERIAL NOT NULL,
- uri VARCHAR(200) NOT NULL,
- synctoken INTEGER NOT NULL,
- addressbookid INTEGER NOT NULL,
- operation SMALLINT NOT NULL
-);
-
-ALTER TABLE ONLY addressbookchanges
- ADD CONSTRAINT addressbookchanges_pkey PRIMARY KEY (id);
-
-CREATE INDEX addressbookchanges_addressbookid_synctoken_ix
- ON addressbookchanges USING btree (addressbookid, synctoken);
-
-ALTER TABLE ONLY addressbookchanges
- ADD CONSTRAINT addressbookchanges_addressbookid_fkey FOREIGN KEY (addressbookid) REFERENCES addressbooks(id)
- ON DELETE CASCADE;