ALTER TABLE Topic CHANGE TodayDate TodayDate DATE NULL DEFAULT NULL, CHANGE AutomaticFilename AutomaticFilename TINYINT(3) UNSIGNED NOT NULL DEFAULT '1', CHANGE OwnerId OwnerId INT(11) NOT NULL DEFAULT '-1', CHANGE TopicType TopicType INT(11) NOT NULL DEFAULT '1', CHANGE LastPostDate LastPostDate INT(11) NULL DEFAULT NULL, CHANGE CachedRating CachedRating VARCHAR(10) NOT NULL DEFAULT '0', CHANGE OrgId OrgId INT(11) NULL DEFAULT NULL; ALTER TABLE Topic DROP Filename; UPDATE Topic SET TodayDate = NULL WHERE TodayDate = '0000-00-00'; UPDATE Modules SET Version = '4.1.0' WHERE Name = 'In-Bulletin';