diff options
| author | Mario <mario@mariovavti.com> | 2021-05-07 15:02:55 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2021-05-07 15:02:55 +0000 |
| commit | c2e007a8392be62c2698e5519b6d0dc0ec92a92b (patch) | |
| tree | e7e2916e8c2546bb2dedaa3f23b61fc26366f71a | |
| parent | ebd0333256b8209de958085057848b649dbd9283 (diff) | |
| download | volse-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.php | 29 | ||||
| -rw-r--r-- | boot.php | 2 | ||||
| -rw-r--r-- | install/schema_postgres.sql | 7 |
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; + } + + } + +} @@ -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, |