aboutsummaryrefslogtreecommitdiffstats
path: root/vendor/examples/sql/pgsql.addressbooks.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/examples/sql/pgsql.addressbooks.sql
parent66effbfe0827fc61fff6d248797a894213ad20d6 (diff)
downloadvolse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.gz
volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.tar.bz2
volse-hubzilla-aab9766c53e42c3141d0497fce78977d262efbc1.zip
missed some files
Diffstat (limited to 'vendor/examples/sql/pgsql.addressbooks.sql')
-rw-r--r--vendor/examples/sql/pgsql.addressbooks.sql44
1 files changed, 44 insertions, 0 deletions
diff --git a/vendor/examples/sql/pgsql.addressbooks.sql b/vendor/examples/sql/pgsql.addressbooks.sql
new file mode 100644
index 000000000..98f414f42
--- /dev/null
+++ b/vendor/examples/sql/pgsql.addressbooks.sql
@@ -0,0 +1,44 @@
+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 BYTEA,
+ 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);
+
+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);