aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-05-03 18:50:32 -0700
committerzotlabs <mike@macgirvin.com>2017-05-03 18:50:32 -0700
commit519aef7ff52013170b08eb89c0a95072fe8047e1 (patch)
tree169cf989615c5caab26b35fab492302e862fdf34 /install/schema_postgres.sql
parentd6a3f7765adbbf5f58c08964932d25d3c0364439 (diff)
downloadvolse-hubzilla-519aef7ff52013170b08eb89c0a95072fe8047e1.tar.gz
volse-hubzilla-519aef7ff52013170b08eb89c0a95072fe8047e1.tar.bz2
volse-hubzilla-519aef7ff52013170b08eb89c0a95072fe8047e1.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 0328040f4..774f355aa 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");