DROP TABLE IF EXISTS `k4_categories`;
CREATE TABLE `k4_categories` (
  `category_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `user_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (`category_id`),
  UNIQUE KEY `name` (`name`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `k4_category_tags`;
CREATE TABLE `k4_category_tags` (
  `category_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  KEY `category_id` (`category_id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM ;

-- --------------------------------------------------------

-- 
-- Table structure for table `k4_comments`
-- 

DROP TABLE IF EXISTS `k4_comments`;
CREATE TABLE IF NOT EXISTS `k4_comments` (
  `comment_id` int(10) unsigned NOT NULL auto_increment,
  `thread_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `body` text NOT NULL,
  `karma_risk` float NOT NULL default '0.5',
  `karma_reward` float NOT NULL default '0',
  PRIMARY KEY  (`comment_id`),
  KEY `karma_reward` (`karma_reward`),
  KEY `thread_id` (`thread_id`),
  KEY `created` (`created`),
  FULLTEXT (`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `k4_comments`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `k4_faq_items`
-- 

DROP TABLE IF EXISTS `k4_faq_items`;
CREATE TABLE IF NOT EXISTS `k4_faq_items` (
  `item_id` int(10) unsigned NOT NULL auto_increment,
  `section_id` int(10) unsigned NOT NULL,
  `relation_id` int(10) unsigned default NULL,
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  PRIMARY KEY  (`item_id`),
  KEY `section_id` (`section_id`),
  KEY `relation_id` (`relation_id`),
  FULLTEXT (`question`, `answer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `k4_faq_items`
-- 

INSERT INTO `k4_faq_items` (`item_id`, `section_id`, `relation_id`, `question`, `answer`) VALUES (1, 1, NULL, 'How do I register on this board?', 'You can become member of this awesome peace of code through accepting our registration agreement and completing the registration process afterwards.');
INSERT INTO `k4_faq_items` (`item_id`, `section_id`, `relation_id`, `question`, `answer`) VALUES (2, 1, NULL, 'How do I resign from this board?', 'Actually you neither are able to delete your account nor you can resign from this board as it''s still under development where such a feature is not yet built in.');
INSERT INTO `k4_faq_items` (`item_id`, `section_id`, `relation_id`, `question`, `answer`) VALUES (3, 2, 1, 'Wie registriere ich mich auf diesem Forum?', 'Du kannst Mitglied dieses unglaublichen Stücks Programmierarbeit werden indem du unsere Registrierungsbestimmungen akzeptierst und danach den Registrierungsprozess abschließt.');
INSERT INTO `k4_faq_items` (`item_id`, `section_id`, `relation_id`, `question`, `answer`) VALUES (4, 4, 2, 'Wie löse ich mein Benutzerkonto auf?', 'Gegenwärtig ist es nicht möglich seinen Benutzer oder dessen Benutzerkonto zu löschen, da sich die Forensoftware noch in Entwicklung befindet und noch keine solche Funktion zur Verfügung stellt.');

-- --------------------------------------------------------

-- 
-- Table structure for table `k4_faq_sections`
-- 

DROP TABLE IF EXISTS `k4_faq_sections`;
CREATE TABLE IF NOT EXISTS `k4_faq_sections` (
  `section_id` int(10) unsigned NOT NULL auto_increment,
  `language_id` int(10) unsigned NOT NULL,
  `parent_id` int(10) unsigned default NULL,
  `relation_id` int(10) unsigned default NULL,
  `title` varchar(100) NOT NULL,
  `description` text,
  PRIMARY KEY  (`section_id`),
  KEY `language_id` (`language_id`,`relation_id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `k4_faq_sections`
-- 

INSERT INTO `k4_faq_sections` (`section_id`, `language_id`, `parent_id`, `relation_id`, `title`, `description`) VALUES (1, 1, NULL, NULL, 'Account Management', 'How to organize, customize and control your user account.');
INSERT INTO `k4_faq_sections` (`section_id`, `language_id`, `parent_id`, `relation_id`, `title`, `description`) VALUES (2, 2, NULL, 1, 'Kontoverwaltung', 'Organisation und Verwaltung des Benutzerkontos.');
INSERT INTO `k4_faq_sections` (`section_id`, `language_id`, `parent_id`, `relation_id`, `title`, `description`) VALUES (3, 1, NULL, NULL, 'General Board Usage', 'Browsing, viewing, reading of the k4 bulletin board and much more.');
INSERT INTO `k4_faq_sections` (`section_id`, `language_id`, `parent_id`, `relation_id`, `title`, `description`) VALUES (4, 2, NULL, 3, 'Allgemeine Benützung der Foren', 'Stöbern, lesen und schreiben von Beiträgen in den k4BB Foren.');

-- --------------------------------------------------------

-- 
-- Table structure for table `k4_languages`
-- 

DROP TABLE IF EXISTS `k4_languages`;
CREATE TABLE IF NOT EXISTS `k4_languages` (
  `language_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(16) NOT NULL,
  `foreign` varchar(16) NOT NULL,
  `code` varchar(2) NOT NULL,
  PRIMARY KEY  (`language_id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `foreign` (`foreign`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `k4_languages`
-- 

INSERT INTO `k4_languages` (`language_id`, `name`, `foreign`, `code`) VALUES (1, 'english', 'english', 'en');
INSERT INTO `k4_languages` (`language_id`, `name`, `foreign`, `code`) VALUES (2, 'german', 'deutsch', 'de');

-- --------------------------------------------------------

CREATE TABLE `k4_objects` (
  `object_id` int(10) unsigned NOT NULL auto_increment,
  `object_name` varchar(20) NOT NULL,
  `object_desc` varchar(50) NOT NULL,
  `object_perms` varchar(200) NOT NULL,
  PRIMARY KEY  (`object_id`),
  UNIQUE KEY `object_name` (`object_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `k4_objects`
-- 

INSERT INTO `k4_objects` (`object_id`, `object_name`, `object_desc`, `object_perms`) VALUES (1, 'threads', 'Threads.', 'view,post,delete,edit,rate,moderate,tag'),
(2, 'comments', 'Comments to threads.', 'view,post,delete,edit,rate,moderate'),
(3, 'categories', 'User defined categories that group threads by tags', 'add,view,edit,moderate'),
(4, 'admin_perms', 'The administration permissions section.', 'manage,roles,objects'),
(5, 'admin_tags', 'Administration of tags.', 'add,merge,delete,tags');


-- --------------------------------------------------------

-- 
-- Table structure for table `k4_perms`
-- 

CREATE TABLE `k4_perms` (
  `perm_id` int(10) unsigned NOT NULL auto_increment,
  `role_id` int(10) unsigned NOT NULL,
  `object_id` int(5) unsigned NOT NULL,
  `perm_grant` tinyint(3) unsigned NOT NULL,
  `perm_deny` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`perm_id`),
  UNIQUE KEY `role_id` (`role_id`,`object_id`),
  KEY `role_id_2` (`role_id`),
  KEY `object_id` (`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

-- 
-- Dumping data for table `k4_perms`
-- 

INSERT INTO `k4_perms` (`perm_id`, `role_id`, `object_id`, `perm_grant`, `perm_deny`) VALUES (1, 1, 1, 1, 124),
(2, 1, 2, 1, 60),
(3, 2, 1, 11, 64),
(4, 2, 2, 3, 36),
(5, 3, 1, 109, 0),
(6, 3, 2, 31, 0),
(7, 4, 1, 127, 0),
(8, 4, 2, 63, 0),
(9, 5, 1, 127, 0),
(10, 5, 2, 63, 0),
(11, 1, 3, 2, 0),
(12, 2, 3, 2, 0),
(13, 3, 3, 3, 0),
(14, 4, 3, 15, 0),
(15, 5, 3, 15, 0),
(16, 5, 4, 7, 0),
(17, 4, 4, 0, 7),
(18, 3, 4, 0, 7),
(19, 5, 5, 15, 0),
(20, 4, 5, 15, 0),
(21, 3, 5, 0, 15),
(22, 2, 5, 0, 15),
(23, 1, 5, 0, 15);


-- --------------------------------------------------------

-- 
-- Table structure for table `k4_post_karma`
-- 

DROP TABLE IF EXISTS `k4_post_karma`;
CREATE TABLE IF NOT EXISTS `k4_post_karma` (
  `thread_id` int(10) unsigned NOT NULL default '0',
  `comment_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL,
  `rate_val` float NOT NULL default '0',
  `rate_time` int(10) unsigned NOT NULL,
  KEY `thread_id` (`thread_id`),
  KEY `comment_id` (`comment_id`),
  KEY `user_id` (`user_id`),
  KEY `rate_val` (`rate_val`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `k4_post_karma`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `k4_roles`
-- 

DROP TABLE IF EXISTS `k4_roles`;
CREATE TABLE IF NOT EXISTS `k4_roles` (
  `role_id` int(10) unsigned NOT NULL auto_increment,
  `role_name` varchar(20) NOT NULL,
  `perm_level` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`role_id`),
  UNIQUE KEY `role_name` (`role_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `k4_roles`
-- 

INSERT INTO `k4_roles` (`role_id`, `role_name`, `perm_level`) VALUES (1, 'guest', 1);
INSERT INTO `k4_roles` (`role_id`, `role_name`, `perm_level`) VALUES (2, 'unconfirmed', 2);
INSERT INTO `k4_roles` (`role_id`, `role_name`, `perm_level`) VALUES (3, 'member', 4);
INSERT INTO `k4_roles` (`role_id`, `role_name`, `perm_level`) VALUES (4, 'moderator', 8);
INSERT INTO `k4_roles` (`role_id`, `role_name`, `perm_level`) VALUES (5, 'administrator', 16);

-- --------------------------------------------------------

-- 
-- Table structure for table `k4_spiders`
-- 

DROP TABLE IF EXISTS `k4_spiders`;
CREATE TABLE IF NOT EXISTS `k4_spiders` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `useragent` varchar(150) NOT NULL,
  `spidername` varchar(150) NOT NULL,
  `allowaccess` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `k4_spiders`
-- 

INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (1, 'Mediapartners-Google', 'Google AdSense', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (2, 'Googlebot', 'Google', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (3, 'Sidewinder', 'Infoseek', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (4, 'Scooter', 'Altavista', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (5, 'T-Rex', 'Lycos', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (6, 'Architext', 'Excite', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (7, 'Backrub', 'Google', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (8, 'Altavista', 'Altavista', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (9, 'Gulliver', 'Northern Light', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (10, 'Lycos', 'Lycos', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (11, 'EZResult', 'EZResult', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (12, 'MuscatFerret', 'EuroFerret', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (13, 'Slurp', 'HotBot', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (14, 'Ultraseek', 'Infoseek', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (15, 'WebCrawler', 'WebCrawler', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (16, 'WiseWire', 'WiseWire', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (17, 'msnbot', 'MSN', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (18, 'msnbot/1.0', 'MSN', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (19, 'W3C_Validator', 'W3C', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (20, 'Gigabot', 'Gigablast', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (21, 'ConveraCrawler', 'Convera.com', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (22, 'CoralWebPrx', 'Coral Cache', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (23, 'ichiro', 'Ichiro', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (24, 'FeedFetcher Google;', 'Google FeedFetcher', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (25, 'LinkWalker', 'LinkWalker', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (26, 'Googlebot Image', 'Google Images', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (27, 'Baiduspider+', 'Baido.com', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (28, 'Microsoft URL Control 6.00.8862', 'SPAM Link Checker', 0);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (29, 'Inktomi', 'inktomi.com', 1);
INSERT INTO k4_spiders (id, useragent, spidername, allowaccess) VALUES (30, 'NewsAllow', 'newsallow', 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `k4_tags`
-- 

DROP TABLE IF EXISTS `k4_tags`;
CREATE TABLE IF NOT EXISTS `k4_tags` (
  `tag_id` int(10) unsigned NOT NULL auto_increment,
  `tag_name` varchar(20) NOT NULL,
  PRIMARY KEY  (`tag_id`),
  UNIQUE KEY `tag_name` (`tag_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `k4_tag_groups`;
CREATE TABLE IF NOT EXISTS `k4_tag_groups` (
  `group_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`group_id`),
  KEY `user_id`(`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `k4_group_tags`;
CREATE TABLE IF NOT EXISTS `k4_group_tags` (
  `group_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`group_id`,`tag_id`)
);

-- --------------------------------------------------------

-- 
-- Table structure for table `k4_thread_tags`
-- 

DROP TABLE IF EXISTS `k4_thread_tags`;
CREATE TABLE IF NOT EXISTS `k4_thread_tags` (
  `thread_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`thread_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `k4_thread_user_tags`;
CREATE TABLE IF NOT EXISTS `k4_thread_user_tags` (
  `thread_id` int(10) unsigned NOT NULL,
  `tag_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`thread_id`,`tag_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `k4_bookmarked_threads`;
CREATE TABLE IF NOT EXISTS `k4_bookmarked_threads` (
  `bookmark_id` int(10) unsigned NOT NULL auto_increment,
  `thread_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `views` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY (`bookmark_id`),
  KEY `views` (`views`),
  KEY `thread_id` (`thread_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `k4_thread_tags`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `k4_thread_users`
-- 

DROP TABLE IF EXISTS `k4_thread_users`;
CREATE TABLE IF NOT EXISTS `k4_thread_users` (
  `thread_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`thread_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `k4_thread_users`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `k4_threads`
-- 

DROP TABLE IF EXISTS `k4_threads`;
CREATE TABLE IF NOT EXISTS `k4_threads` (
  `thread_id` int(10) unsigned NOT NULL auto_increment,
  `created` int(10) unsigned NOT NULL,
  `deleted` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `type` set('sticky','announcement','featured') default NULL,
  `num_comments` int(10) NOT NULL default '0',
  `views` int(10) NOT NULL default '0',
  `recent_cid` int(10) unsigned default NULL,
  `recent_created` int(10) unsigned default NULL,
  `recent_uid` int(10) unsigned default NULL,
  `recent_user` varchar(30) default NULL,
  `recent_name` varchar(32) default NULL,
  `karma_risk` tinyint(4) NOT NULL default '0',
  `karma_reward` float NOT NULL default '0',
  `allow_coauthors` tinyint(1) default '0',
  `user_id` int(10) unsigned NOT NULL,
  `edit_user_id` int(10) unsigned NOT NULL,
  `edit_message` varchar(255) NOT NULL default '',
  `edit_time` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`thread_id`),
  KEY `deleted` (`deleted`),
  KEY `created` (`created`),
  KEY `karma_reward` (`karma_reward`),
  KEY `type` (`type`),
  KEY `user_id` (`user_id`),
  FULLTEXT (`name`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `k4_thread_revisions`;
CREATE TABLE IF NOT EXISTS `k4_thread_revisions` (
  `revision_id` int(10) unsigned NOT NULL auto_increment,
  `thread_id` int(10) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `edit_user_id` int(10) unsigned NOT NULL,
  `edit_message` varchar(255) NOT NULL default '',
  `edit_time` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`revision_id`),
  KEY `thread_id` (`thread_id`),
  KEY `edit_user_id` (`edit_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `k4_threads`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `k4_user_roles`
-- 

DROP TABLE IF EXISTS `k4_user_roles`;
CREATE TABLE IF NOT EXISTS `k4_user_roles` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  KEY `user_id` (`user_id`),
  KEY `role_id` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `k4_user_roles`
-- 

INSERT INTO `k4_user_roles` (`user_id`, `role_id`) VALUES (1, 1);
INSERT INTO `k4_user_roles` (`user_id`, `role_id`) VALUES (2, 2);
INSERT INTO `k4_user_roles` (`user_id`, `role_id`) VALUES (2, 3);
INSERT INTO `k4_user_roles` (`user_id`, `role_id`) VALUES (2, 4);
INSERT INTO `k4_user_roles` (`user_id`, `role_id`) VALUES (2, 5);

-- --------------------------------------------------------

-- 
-- Table structure for table `k4_users`
-- 

DROP TABLE IF EXISTS `k4_users`;
CREATE TABLE IF NOT EXISTS `k4_users` (
  `user_id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `num_threads` int(5) unsigned NOT NULL default '0',
  `num_comments` int(5) unsigned NOT NULL default '0',
  `pass` char(32) NOT NULL,
  `login_key` char(32) default NULL,
  `register_key` char(32) default NULL,
  `email` varchar(50) NOT NULL,
  `last_seen` int(10) NOT NULL default '0',
  `last_login` int(10) NOT NULL default '0',
  `karma` float NOT NULL default '100',

  `last_wall_view` int(10) unsigned NOT NULL default '0',
  `last_wall_post` int(10) unsigned NOT NULL default '0',
  `num_new_wall_posts` tinyint(1) unsigned NOT NULL default '0',
  `num_tagged_threads` tinyint(1) unsigned NOT NULL default '0',
  `num_tag_groups` tinyint(1) unsigned NOT NULL default '0',

  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `email` (`email`),
  KEY `created` (`created`),
  KEY `karma` (`karma`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO `k4_users` (`user_id`, `name`, `created`, `num_threads`, `num_comments`, `pass`, `login_key`, `register_key`, `email`, `last_seen`, `last_login`, `karma`) VALUES (1, 'Guest', 0, 0, 0, '', NULL, NULL, '', 0, 0, 0);
INSERT INTO `k4_users` (`user_id`, `name`, `created`, `num_threads`, `num_comments`, `pass`, `login_key`, `register_key`, `email`, `last_seen`, `last_login`, `karma`) VALUES (2, 'k4st', 1149807323, 0, 0, '45ab33cd411356d0e6c5b29d883ccea9', '005cfe9840fc39272cc7723f89adab8c', NULL, 'peter.goodman@gmail.com', 0, 0, 100);

DROP TABLE IF EXISTS `k4_wall_posts`;
CREATE TABLE IF NOT EXISTS `k4_wall_posts` (
  `post_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL,
  `poster_id` int(10) unsigned NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `body` text NOT NULL,
  `private` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY (`post_id`),
  KEY `user_id` (`user_id`),
  KEY `poster_id` (`poster_id`),
  KEY `created` (`created`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;