aboutsummaryrefslogtreecommitdiffstats
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
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
-rw-r--r--Zotlabs/Update/_1245.php29
-rw-r--r--boot.php2
-rw-r--r--install/schema_postgres.sql7
3 files changed, 34 insertions, 4 deletions
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,