aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorgit-marijus <mario@mariovavti.com>2017-05-04 09:59:35 +0200
committerGitHub <noreply@github.com>2017-05-04 09:59:35 +0200
commitbc776a9534b57231b83f4c65fefdc3637db0e024 (patch)
tree95715134462579699fe8cc13d1925ebfc0d032e2 /install/schema_postgres.sql
parent45c64c2d2e5f7bde8a12c0010cd87eea106a65c6 (diff)
parent1e59d9ade576acbd1768303cb9e9c994b4d50392 (diff)
downloadvolse-hubzilla-bc776a9534b57231b83f4c65fefdc3637db0e024.tar.gz
volse-hubzilla-bc776a9534b57231b83f4c65fefdc3637db0e024.tar.bz2
volse-hubzilla-bc776a9534b57231b83f4c65fefdc3637db0e024.zip
Merge pull request #750 from zotlabs/abnothere
abook_not_here flag created to indicate singleton connections which a…
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");