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

-- UPDATE NEWS TABLE COLUMNS
UPDATE News SET ExpiryDate = NULL WHERE news.ExpiryDate < '0001-01-01 00:00:00';
ALTER TABLE `news` CHANGE `IDLNK` `IDLNK` INT(11) NOT NULL AUTO_INCREMENT,
CHANGE `Title` `Title` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
CHANGE `URL` `URL` VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
CHANGE `Tags` `Tags` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
CHANGE `Content` `Content` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `Published` `Published` TINYINT(1) NOT NULL DEFAULT '0',
CHANGE `PublishedDate` `PublishedDate` TIMESTAMP NULL DEFAULT NULL,
CHANGE `EditedDate` `EditedDate` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
CHANGE `PublishedByIDLNK` `PublishedByIDLNK` INT(11) NOT NULL DEFAULT '0',
CHANGE `Public` `Public` TINYINT(1) NOT NULL DEFAULT '0',
CHANGE `Deleted` `Deleted` TINYINT(1) NOT NULL DEFAULT '0',
CHANGE `ExpiryDate` `ExpiryDate` TIMESTAMP on update CURRENT_TIMESTAMP NULL DEFAULT NULL;

ALTER TABLE `news` ADD `NewsletterSent` INT NOT NULL DEFAULT '0' AFTER `ExpiryDate`;