From 79a806f328e27269d13f26deb0acee7ad8560f7a Mon Sep 17 00:00:00 2001 From: git-marijus Date: Mon, 31 Jul 2017 16:49:56 +0200 Subject: db update to add index for item.obj_type --- install/schema_mysql.sql | 1 + install/schema_postgres.sql | 1 + install/update.php | 14 +++++++++++++- 3 files changed, 15 insertions(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 4430e9f10..9e2e401b5 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -660,6 +660,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `item_flags` (`item_flags`), KEY `commented` (`commented`), KEY `verb` (`verb`), + KEY `obj_type` (`obj_type`), KEY `item_private` (`item_private`), KEY `llink` (`llink`), KEY `expires` (`expires`), diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index f3cead9b7..0bc783692 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -631,6 +631,7 @@ create index "item_restrict" on item ("item_restrict"); create index "item_flags" on item ("item_flags"); create index "item_commented" on item ("commented"); create index "item_verb" on item ("verb"); +create index "item_obj_type" on item ("obj_type"); create index "item_private" on item ("item_private"); create index "item_llink" on item ("llink"); create index "item_expires" on item ("expires"); diff --git a/install/update.php b/install/update.php index ac560f4db..8798a3d69 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ Date: Thu, 17 Aug 2017 16:26:14 -0700 Subject: update installation requirements - php 5.6 and mysql 5.5.3 --- install/INSTALL.txt | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'install') diff --git a/install/INSTALL.txt b/install/INSTALL.txt index c059fadf1..754504a33 100644 --- a/install/INSTALL.txt +++ b/install/INSTALL.txt @@ -104,7 +104,7 @@ technical abilities. Example config scripts are available for these platforms in the install directory. Apache and nginx have the most support. - - PHP 5.5 or later. + - PHP 5.6 or later. - PHP *command line* access with register_argc_argv set to true in the php.ini file - and with no hosting provider restrictions on the use of @@ -116,7 +116,7 @@ technical abilities. - some form of email server or email gateway such that PHP mail() works. - - Mysql 5.x or MariaDB or postgres database server. + - Mysql 5.5.3 or later or MariaDB or postgres database server. - ability to schedule jobs with cron. -- cgit v1.2.3 From e935473c5c05a40194c110fbb024825a30ca5a4b Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Fri, 1 Sep 2017 21:27:59 +0200 Subject: add combined index for item.uid and item.item_unseen. this speeds up notifications by a magnitude. --- install/schema_mysql.sql | 5 +++-- install/schema_postgres.sql | 1 + install/update.php | 16 +++++++++++++++- 3 files changed, 19 insertions(+), 3 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 9e2e401b5..a9950ce21 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -650,8 +650,9 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `created` (`created`), KEY `edited` (`edited`), KEY `received` (`received`), - KEY `uid_commented` (`uid`,`commented`), - KEY `uid_created` (`uid`,`created`), + KEY `uid_commented` (`uid`, `commented`), + KEY `uid_created` (`uid`, `created`), + KEY `uid_item_unseen` (`uid`, `item_unseen`); KEY `aid` (`aid`), KEY `owner_xchan` (`owner_xchan`), KEY `author_xchan` (`author_xchan`), diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 0bc783692..381c262a7 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -621,6 +621,7 @@ create index "item_edited" on item ("edited"); create index "item_received" on item ("received"); create index "item_uid_commented" on item ("uid","commented"); create index "item_uid_created" on item ("uid","created"); +create index "item_uid_unseen" on item ("uid","item_unseen"); create index "item_changed" on item ("changed"); create index "item_comments_closed" on item ("comments_closed"); create index "item_aid" on item ("aid"); diff --git a/install/update.php b/install/update.php index 8798a3d69..b99e4dd9d 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ Date: Wed, 6 Sep 2017 16:12:57 -0500 Subject: fix bogus semicolon Line 655 should have comma instead of semicolon --- install/schema_mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index a9950ce21..0988bfa4a 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -652,7 +652,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `received` (`received`), KEY `uid_commented` (`uid`, `commented`), KEY `uid_created` (`uid`, `created`), - KEY `uid_item_unseen` (`uid`, `item_unseen`); + KEY `uid_item_unseen` (`uid`, `item_unseen`), KEY `aid` (`aid`), KEY `owner_xchan` (`owner_xchan`), KEY `author_xchan` (`author_xchan`), -- cgit v1.2.3 From 607c4146349541565b82b86811c193b4f9da23fe Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Thu, 7 Sep 2017 10:14:34 +0200 Subject: remove semicolon from update query - this is probably trivial --- install/update.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/update.php b/install/update.php index b99e4dd9d..ce9a50913 100644 --- a/install/update.php +++ b/install/update.php @@ -2985,7 +2985,7 @@ function update_r1193() { $r1 = q("CREATE INDEX item_uid_unseen ON item (uid, item_unseen)"); } else { - $r1 = q("ALTER TABLE item ADD INDEX uid_item_unseen (uid, item_unseen);"); + $r1 = q("ALTER TABLE item ADD INDEX uid_item_unseen (uid, item_unseen)"); } if($r1) -- cgit v1.2.3 From 796228b7ad3cac90b23de2954445021578635105 Mon Sep 17 00:00:00 2001 From: zotlabs Date: Tue, 12 Sep 2017 23:15:30 -0700 Subject: wiki mimetype selection. We can add text/plain as soon as we add code to purify and render it specifically. --- install/update.php | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) (limited to 'install') diff --git a/install/update.php b/install/update.php index ce9a50913..8c9f83033 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ Date: Sat, 16 Sep 2017 10:11:59 +0200 Subject: db update to add index to item.resource_id we query this in wikis a lot --- install/schema_mysql.sql | 1 + install/schema_postgres.sql | 1 + install/update.php | 18 ++++++++++++++++-- 3 files changed, 18 insertions(+), 2 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 0988bfa4a..3143854f5 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -656,6 +656,7 @@ CREATE TABLE IF NOT EXISTS `item` ( KEY `aid` (`aid`), KEY `owner_xchan` (`owner_xchan`), KEY `author_xchan` (`author_xchan`), + KEY `resource_id` (`resource_id`), KEY `resource_type` (`resource_type`), KEY `item_restrict` (`item_restrict`), KEY `item_flags` (`item_flags`), diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 381c262a7..65acb644b 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -627,6 +627,7 @@ create index "item_comments_closed" on item ("comments_closed"); create index "item_aid" on item ("aid"); create index "item_owner_xchan" on item ("owner_xchan"); create index "item_author_xchan" on item ("author_xchan"); +create index "item_resource_id" on item ("resource_id"); create index "item_resource_type" on item ("resource_type"); create index "item_restrict" on item ("item_restrict"); create index "item_flags" on item ("item_flags"); diff --git a/install/update.php b/install/update.php index 8c9f83033..07675a973 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ Date: Mon, 2 Oct 2017 18:46:24 -0700 Subject: remove server role selection details from install documentation, no longer needed --- install/INSTALL.txt | 40 ++++++++++------------------------------ 1 file changed, 10 insertions(+), 30 deletions(-) (limited to 'install') diff --git a/install/INSTALL.txt b/install/INSTALL.txt index 754504a33..88269f032 100644 --- a/install/INSTALL.txt +++ b/install/INSTALL.txt @@ -7,14 +7,14 @@ such as XAMPP and WAMP are not officially supported at this time - however we welcome patches if you manage to get it working. Be aware that this software is more than a simple web application. It is a -complex communications system which more closely resembles an email server -than a web server. For reliability and performance, messages are delivered in -the background and are queued for later delivery when sites are down. This -kind of functionality requires a bit more of the host system than the typical -blog. Not every PHP/MySQL hosting provider will be able to support the -Hubzilla. Many will - but please review the requirements and confirm these -with your hosting provider prior to installation. (And preferably before -entering into a long-term contract.) +complex communications and content management system which more closely +resembles an email server than a web server. For reliability and performance, +messages are delivered in the background and are queued for later delivery +when sites are down. This kind of functionality requires a bit more of the +host system than the typical blog. Not every PHP/MySQL hosting provider will +be able to support Hubzilla. Many will - but please review the requirements +and confirm these with your hosting provider prior to installation. (And +preferably before entering into a long-term contract.) If you encounter installation issues, please let us know via the Github issue tracker where you downloaded the software. Please be as clear as @@ -75,27 +75,6 @@ location may prevent some of these services from working correctly. This should not be a problem with Apache, but may be an issue with nginx or other web server platforms. -**Server Roles** - -During installation you will be asked to choose a server role. Your choices are -1. Basic -2. Standard -3. Pro - -Basic is highly simplified, with almost all the advanced functionality and -complexity removed or permanently disabled. - -Standard is typically used for federated network use, when you wish to interact -with other networks using other protocols. Not all the built in features and -functionality work correctly when other networks are involved. All advanced -and complex features are available to all members by default. - -Pro is for sites that wish to make full use of the built-in abilities and -features, but **not** to interact with other networks. Advanced features are -enabled according to a per-account 'techlevel' which reduces complexity -initially and allows members to adjust the software complexity to match their -technical abilities. - **Installation** 1. Requirements @@ -173,7 +152,8 @@ technical abilities. cd mywebsite util/update_addon_repo hzaddons - - Create searchable representations of the online documentation. You may do this any time + - Once the software is configured and the database installed, create searchable + representations of the online documentation. You may do this any time that the documentation is updated. cd mywebsite -- cgit v1.2.3