DATABASE 0.1.4.2 to 0.1.5.sql

ALTER TABLE `nf_comments` CHANGE `content` `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `nf_comments` CHANGE `date` `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE `nf_files` CHANGE `date` `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE `nf_forum` CHANGE `order` `order` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_forum_categories` CHANGE `order` `order` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_forum_messages` CHANGE `message` `message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `nf_forum_url` CHANGE `redirects` `redirects` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_forum_topics` CHANGE `message_id` `message_id` INT(11) UNSIGNED NULL DEFAULT NULL;
ALTER TABLE `nf_forum_topics` CHANGE `views` `views` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_forum_topics` CHANGE `count_messages` `count_messages` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_gallery_images` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `nf_gallery_images` CHANGE `views` `views` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_news` CHANGE `views` `views` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_partners` CHANGE `count` `count` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_partners` CHANGE `order` `order` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_settings_languages` CHANGE `order` `order` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_talks_messages` CHANGE `message` `message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `nf_teams` CHANGE `order` `order` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_teams_roles` CHANGE `order` `order` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `nf_users` CHANGE `last_activity_date` `last_activity_date` TIMESTAMP NULL DEFAULT NULL;
ALTER TABLE `nf_users_messages` CHANGE `reply_id` `reply_id` INT(11) UNSIGNED NULL DEFAULT NULL;
INSERT IGNORE INTO `nf_settings` VALUES('nf_version_css', '', '', '0', 'int');
INSERT IGNORE INTO `nf_settings_addons` VALUES('statistics', 'module', '1');
INSERT IGNORE INTO `nf_settings_addons` VALUES('monitoring', 'module', '1');
INSERT IGNORE INTO `nf_settings` VALUES('nf_monitoring_last_check', '', '', '0', 'int');