From c2e007a8392be62c2698e5519b6d0dc0ec92a92b Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Fri, 7 May 2021 15:02:55 +0000
Subject: update 1245 to fix hubloc_hash index for postgres

---
 Zotlabs/Update/_1245.php    | 29 +++++++++++++++++++++++++++++
 boot.php                    |  2 +-
 install/schema_postgres.sql |  7 ++++---
 3 files changed, 34 insertions(+), 4 deletions(-)
 create mode 100644 Zotlabs/Update/_1245.php

diff --git a/Zotlabs/Update/_1245.php b/Zotlabs/Update/_1245.php
new file mode 100644
index 000000000..8212fde08
--- /dev/null
+++ b/Zotlabs/Update/_1245.php
@@ -0,0 +1,29 @@
+<?php
+
+namespace Zotlabs\Update;
+
+class _1245 {
+
+	function run() {
+
+		if(ACTIVE_DBTYPE == DBTYPE_MYSQL) {
+				return UPDATE_SUCCESS;
+		}
+
+		if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) {
+			q("START TRANSACTION");
+
+			$r = dbq("create index hubloc_hash on hubloc (hubloc_hash)");
+
+			if($r) {
+				q("COMMIT");
+				return UPDATE_SUCCESS;
+			}
+
+			q("ROLLBACK");
+			return UPDATE_FAILED;
+		}
+
+	}
+
+}
diff --git a/boot.php b/boot.php
index a6dfbf7a5..c057f8278 100644
--- a/boot.php
+++ b/boot.php
@@ -55,7 +55,7 @@ define ( 'PLATFORM_NAME',           'hubzilla' );
 define ( 'STD_VERSION',             '5.7' );
 define ( 'ZOT_REVISION',            '6.0' );
 
-define ( 'DB_UPDATE_VERSION',       1244 );
+define ( 'DB_UPDATE_VERSION',       1245 );
 
 define ( 'PROJECT_BASE',   __DIR__ );
 
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 52b44bd07..c18cc087b 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -506,6 +506,7 @@ CREATE TABLE "hubloc" (
 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_hash" on hubloc ("hubloc_hash");
 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");
@@ -1099,9 +1100,9 @@ CREATE TABLE "register" (
   "reg_did2"   text    DEFAULT '' NOT NULL,
   "reg_hash"   text    DEFAULT '' NOT NULL,
   "reg_email"  text    DEFAULT '' NOT NULL,
-  "reg_created" timestamp  NOT NULL,
-  "reg_startup" timestamp  NOT NULL,
-  "reg_expires" timestamp  NOT NULL,
+  "reg_created" timestamp  NOT NULL DEFAULT '0001-01-01 00:00:00',
+  "reg_startup" timestamp  NOT NULL DEFAULT '0001-01-01 00:00:00',
+  "reg_expires" timestamp  NOT NULL DEFAULT '0001-01-01 00:00:00',
   "reg_byc"    bigint  DEFAULT 0 NOT NULL,
   "reg_uid"    bigint  DEFAULT 0 NOT NULL,
   "reg_atip"   text    DEFAULT '' NOT NULL,
-- 
cgit v1.2.3