aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorMario <mario@mariovavti.com>2021-05-07 15:02:55 +0000
committerMario <mario@mariovavti.com>2021-05-07 15:02:55 +0000
commitc2e007a8392be62c2698e5519b6d0dc0ec92a92b (patch)
treee7e2916e8c2546bb2dedaa3f23b61fc26366f71a /install/schema_postgres.sql
parentebd0333256b8209de958085057848b649dbd9283 (diff)
downloadvolse-hubzilla-c2e007a8392be62c2698e5519b6d0dc0ec92a92b.tar.gz
volse-hubzilla-c2e007a8392be62c2698e5519b6d0dc0ec92a92b.tar.bz2
volse-hubzilla-c2e007a8392be62c2698e5519b6d0dc0ec92a92b.zip
update 1245 to fix hubloc_hash index for postgres
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r--install/schema_postgres.sql7
1 files changed, 4 insertions, 3 deletions
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,