 CREATE TABLE `prefix_blog_comments` (
   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
   `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `author` tinytext NOT NULL,
-  `author_email` varchar(100) NOT NULL DEFAULT '',
-  `author_url` varchar(200) NOT NULL DEFAULT '',
-  `author_ip` varchar(100) NOT NULL DEFAULT '',
+  `author` tinytext DEFAULT NULL,
+  `author_email` varchar(100) DEFAULT NULL,
+  `author_url` varchar(200) DEFAULT NULL,
+  `author_ip` varchar(100) DEFAULT NULL,
   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
-  `content` text NOT NULL,
+  `content` text DEFAULT NULL,
   `approved` varchar(20) NOT NULL DEFAULT '1',
   `member_id` bigint(20) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`),


CREATE TABLE `prefix_blog` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `type` smallint(1) NOT NULL DEFAULT '1',
  `member_owner_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),

DROP TABLE IF EXISTS `prefix_session`;

CREATE TABLE `prefix_session` (
  `id` char(32) DEFAULT NULL,
  `modified` int(11) NOT NULL DEFAULT '0',
  `lifetime` int(11) NOT NULL DEFAULT '0',
  `user_agent` varchar(255) DEFAULT NULL,
  `data` text,
  PRIMARY KEY (`id`)
