-- database-update.sql

-- ---------- version 5.2.1 -------------
-- Make confname a unique column
ALTER TABLE configs ADD UNIQUE(confname);

-- Delete db name, user, and password configs
DELETE FROM configs where confname="ol_dbname";
DELETE FROM configs where confname="ol_dbuser";
DELETE FROM configs where confname="ol_dbpass";

-- Add config option for server side error logging
INSERT IGNORE INTO configs(confname,confvalue) values('log_errors','0')

-- Update version number
UPDATE configs SET confvalue="5.2.1" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.2 -------------
-- Update version number
UPDATE configs SET confvalue="5.2.2" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.3 -------------
-- Update version number
UPDATE configs SET confvalue="5.2.3" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.4 -------------
-- Update version number
UPDATE configs SET confvalue="5.2.4" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.4.1 -----------
-- Update version number
UPDATE configs SET confvalue="5.2.4.1" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.4.2 -----------
-- Update version number
UPDATE configs SET confvalue="5.2.4.2" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.4.3 -----------
-- Update version number
UPDATE configs SET confvalue="5.2.4.3" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.4.4 -----------
-- Update version number
UPDATE configs SET confvalue="5.2.4.4" WHERE confname="ol_version";
-- --------------------------------------

-- ---------- version 5.2.5 -------------
-- Update version number
UPDATE configs SET confvalue="5.2.5" WHERE confname="ol_version";
-- --------------------------------------