SQL script to update pH7CMS from version 5.* to 7.1.3

upgrade-ph7cms-5.*-to-7.1.3.sql

--
-- Author:        Pierre-Henry Soria <[email protected]>
-- Copyright:     (c) 2017, 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
('profileWithAvatarSet', 0, '1 to display only the profiles with a profile photo.', 'homepage');


-- Update pH7CMS's SQL schema version
UPDATE PH7_Modules SET version = '1.3.7' WHERE vendorName = 'pH7CMS';