ALTER TABLE News CHANGE AutomaticFilename AutomaticFilename TINYINT(3) UNSIGNED NOT NULL DEFAULT '1', CHANGE CreatedById CreatedById INT(11) NOT NULL DEFAULT '-1', CHANGE ModifiedById ModifiedById INT(11) NOT NULL DEFAULT '-1', CHANGE EndOn EndOn INT(11) NULL DEFAULT NULL, CHANGE Priority Priority INT(11) NOT NULL DEFAULT '0'; ALTER TABLE News DROP Filename; UPDATE News SET EndOn = NULL WHERE EndOn = 0; UPDATE Modules SET Version = '4.1.0' WHERE Name = 'In-News';