SQL script to update pH7CMS from version 5.0.0 to 6.0.0

upgrade-ph7cms-5.0.0-to-6.0.0.sql

--
-- Author:        Pierre-Henry Soria <[email protected]>
-- Copyright:     (c) 2016, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License; https://www.gnu.org/licenses/gpl-3.0.en.html
--

--- Replace 'PH7_' by your prefix set in "~/_protected/app/configs/config.ini" [database] prefix

INSERT INTO PH7_Settings (`name`, value, `desc`, `group`) VALUES
('usersBlock', 1, '0 to disable or 1 to enable the profile photos on the homepage', 'homepage'),
('requireRegistrationAvatar', 0, '', 'registration');

INSERT INTO pH7_SysModsEnabled (moduleTitle, folderName, premiumMod, enabled) VALUES
('Related Profiles', 'related-profile', '0', '1'),
('Friends', 'friend', '0', '1');


-- Update pH7CMS's SQL schema version
UPDATE pH7_Modules SET version = '1.3.4' WHERE vendorName = 'pH7CMS';