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

---
 install/schema_postgres.sql | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

(limited to 'install/schema_postgres.sql')

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

