aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-05-03 18:50:32 -0700
committerMario Vavti <mario@mariovavti.com>2017-05-20 22:21:22 +0200
commit3919c8f79f9f104e99b161e9034c68eba3fe86a0 (patch)
treecb3c6f915c588c8b8d044af3c67ae018fe003b31 /install/schema_postgres.sql
parent803be11bbc6e4d149629808b4473833f73910c6f (diff)
downloadvolse-hubzilla-3919c8f79f9f104e99b161e9034c68eba3fe86a0.tar.gz
volse-hubzilla-3919c8f79f9f104e99b161e9034c68eba3fe86a0.tar.bz2
volse-hubzilla-3919c8f79f9f104e99b161e9034c68eba3fe86a0.zip
abook_not_here flag created to indicate singleton connections which are connected to this channel but not on this hub. abook_instance enumerates which hubs the connections is valid, but we ultimately need something more efficiently searchable to decide what operations are supported w/r/t this connection in the context of this hub. This flag is ignored during sync to clones although the code to set it correctly during channel creation, import, and sync has not yet been implemented.
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r--install/schema_postgres.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 4c65d165d..389cc6a84 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -32,6 +32,7 @@ CREATE TABLE "abook" (
"abook_unconnected" smallint NOT NULL DEFAULT '0',
"abook_self" smallint NOT NULL DEFAULT '0',
"abook_feed" smallint NOT NULL DEFAULT '0',
+ "abook_not_here" smallint NOT NULL DEFAULT '0',
"abook_profile" char(64) NOT NULL DEFAULT '',
"abook_incl" TEXT NOT NULL DEFAULT '',
"abook_excl" TEXT NOT NULL DEFAULT '',
@@ -55,6 +56,7 @@ CREATE TABLE "abook" (
create index "abook_unconnected" on abook ("abook_unconnected");
create index "abook_self" on abook ("abook_self");
create index "abook_feed" on abook ("abook_feed");
+ create index "abook_not_here" on abook ("abook_not_here");
create index "abook_profile" on abook ("abook_profile");
create index "abook_dob" on abook ("abook_dob");
create index "abook_connected" on abook ("abook_connected");