 DROP TABLE IF EXISTS `prefix_session`;
 
 CREATE TABLE `prefix_session` (
-  `id` char(32) NOT NULL DEFAULT '',
-  `modified` int(11) DEFAULT NULL,
-  `lifetime` int(11) DEFAULT NULL,
+  `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`)

CREATE TABLE `prefix_acl_roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent` bigint(20) NOT NULL DEFAULT '0',
  `role` varchar(64) NOT NULL,
  `description` varchar(256) NOT NULL,
  `res_module_admin` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


CREATE TABLE `prefix_members` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `password` varchar(64) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `role_id` smallint(1) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_active` smallint(1) NOT NULL DEFAULT '1',
