aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2018-08-13 21:18:20 -0700
committerzotlabs <mike@macgirvin.com>2018-08-13 21:18:20 -0700
commitf15c1c4e54a49d1e76747ca5e3034ca2cef909aa (patch)
tree417d40aaf26fa3be3f85072e6ef92e1267e4d956 /install/schema_postgres.sql
parent62925c4c3f0fb184c194f0cb177c1525ccdb72cb (diff)
downloadvolse-hubzilla-f15c1c4e54a49d1e76747ca5e3034ca2cef909aa.tar.gz
volse-hubzilla-f15c1c4e54a49d1e76747ca5e3034ca2cef909aa.tar.bz2
volse-hubzilla-f15c1c4e54a49d1e76747ca5e3034ca2cef909aa.zip
hubloc DB changes needed for z6
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r--install/schema_postgres.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 8db0eb8be..68c65c830 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -474,10 +474,12 @@ create index "hook_idx" on hook ("hook");
create index "hook_version_idx" on hook ("hook_version");
create index "hook_priority_idx" on hook ("priority");
+
CREATE TABLE "hubloc" (
"hubloc_id" serial NOT NULL,
"hubloc_guid" text NOT NULL DEFAULT '',
"hubloc_guid_sig" text NOT NULL DEFAULT '',
+ "hubloc_id_url" text NOT NULL DEFAULT '',
"hubloc_hash" text NOT NULL,
"hubloc_addr" text NOT NULL DEFAULT '',
"hubloc_network" text NOT NULL DEFAULT '',
@@ -485,6 +487,7 @@ CREATE TABLE "hubloc" (
"hubloc_status" bigint NOT NULL DEFAULT '0',
"hubloc_url" text NOT NULL DEFAULT '',
"hubloc_url_sig" text NOT NULL DEFAULT '',
+ "hubloc_site_id" text NOT NULL DEFAULT '',
"hubloc_host" text NOT NULL DEFAULT '',
"hubloc_callback" text NOT NULL DEFAULT '',
"hubloc_connect" text NOT NULL DEFAULT '',
@@ -498,7 +501,9 @@ CREATE TABLE "hubloc" (
PRIMARY KEY ("hubloc_id")
);
create index "hubloc_url" on hubloc ("hubloc_url");
+create index "hubloc_site_id" on hubloc ("hubloc_site_id");
create index "hubloc_guid" on hubloc ("hubloc_guid");
+create index "hubloc_id_url" on hubloc ("hubloc_id_url");
create index "hubloc_flags" on hubloc ("hubloc_flags");
create index "hubloc_connect" on hubloc ("hubloc_connect");
create index "hubloc_host" on hubloc ("hubloc_host");