UPDATE `config`
SET `Type` = 
'checkboxchoice:
    User Management|useradmin,
    Users Export|usersexport,
    Enforced Account Verification|accountverification,
    Pages|pages,    
    Page Editors|pageeditors,
    Page Version Control|pagesversion,
    Page Preview|pagepreview,
    Page Colour|pagecolour,
    News|news,
    Newsletter|newsletter,
    Newsletter Categories|newslettercategories,
    News in Members Area|newsinmembersarea,
    Sliders|sliders,
    Documents|documents,
    Snippets|snippets,
    Events|events,
    Public Events|publicevents,
    Forum|forum,
    Forum Reactions|forumreactions,
    Directory|directory,
    Contact Form|contactform,
    Tenders|tenders,
    Show Management|showmanagement,
    Tasks|tasks,
    Drug Shortages|drugshortages,
    Email Link|emaillink,
    Notices|notices,
    Notification Override|notificationoverride,
    Premium Content|premiumcontent,
    Flow Charts|flowcharts,
    Registration Disclaimer|regdisclaimer,
    Galleries|galleries,
    Gallery Editors|galleryeditors,
    Tiles|tiles,
    Custom Welcome Page|customwelcomepage,
    Popups|popups,
    Last Day Docs|lastdaydocs,
    Profiles|people,
    Error Reporting|errorreporting'

WHERE Config = 'FEATURES';

DELETE FROM `config` WHERE Config = 'DIRECTORYTOPLEVELNAME';
DELETE FROM `config` WHERE Config = 'DIRECTORYBOTTOMLEVELNAME';
DELETE FROM `config` WHERE Config = 'DIRECTORYPOSITIONSNAME';

ALTER TABLE `gallarys` ADD `Mode` VARCHAR(255) NOT NULL DEFAULT 'gallery' AFTER `ShowName`; 
ALTER TABLE `gallaryimages` ADD `LinkPageID` INT NOT NULL AFTER `GallaryOrder`, ADD `LinkText` TEXT NOT NULL AFTER `LinkPageID`, ADD `LinkURL` TEXT NOT NULL AFTER `LinkText`; 
ALTER TABLE `organisation` ADD `Mode` VARCHAR(255) NOT NULL DEFAULT 'profile' AFTER `HiddenFields`; 
ALTER TABLE `people` ADD `URL` TEXT NOT NULL AFTER `Email`; 