btw the sql thing
--
-- Table structure for table `forums`
--
CREATE TABLE IF NOT EXISTS `forums` (
`id` varchar(13) NOT NULL,
`name` varchar(100) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`creator_user_name` varchar(20) NOT NULL,
`slug` varchar(60) DEFAULT NULL,
`sequence` int(11) NOT NULL,
`topic_count` int(11) DEFAULT NULL,
`post_count` int(11) DEFAULT NULL,
`is_visible` tinyint(1) NOT NULL DEFAULT '1',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `forum_slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;# MySQL returned an empty result set (i.e. zero rows).
--
-- Table structure for table `posts`
--
CREATE TABLE IF NOT EXISTS `posts` (
`id` varchar(13) NOT NULL,
`creator_user_name` varchar(20) NOT NULL,
`text` text NOT NULL,
`topic_id` varchar(13) NOT NULL,
`is_visible` tinyint(1) NOT NULL DEFAULT '1',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
PRIMARY KEY (`id`),
KEY `posts_topic_id` (`topic_id`),
FULLTEXT KEY `posts_fulltext` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;# MySQL returned an empty result set (i.e. zero rows).
--
-- Table structure for table `status_types`
--
CREATE TABLE IF NOT EXISTS `status_types` (
`id` varchar(13) NOT NULL,
`name` varchar(25) NOT NULL,
`status_type` enum('Open','Closed','Deleted') NOT NULL DEFAULT 'Open',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;# MySQL returned an empty result set (i.e. zero rows).
--
-- Dumping data for table `status_types`
--
INSERT INTO `status_types` (`id`, `name`, `status_type`, `created`, `modified`) VALUES
('none', 'None', 'Open', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('planned', 'Planned', 'Open', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('started', 'Started', 'Open', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('under-review', 'Under Review', 'Open', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('completed', 'Completed', 'Closed', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('resolved', 'Resolved', 'Closed', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('duplicate', 'Duplicate', 'Deleted', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('inappropriate', 'Inappropriate', 'Deleted', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('other', 'Other', 'Deleted', '2009-07-29 00:00:00', '2009-07-29 00:00:00'),
('spam', 'Spam', 'Deleted', '2009-07-29 00:00:00', '2009-07-29 00:00:00');# 10 row(s) affected.
--
-- Table structure for table `topics`
--
CREATE TABLE IF NOT EXISTS `topics` (
`id` varchar(13) NOT NULL,
`name` varchar(100) NOT NULL,
`slug` varchar(60) DEFAULT NULL,
`forum_id` varchar(13) NOT NULL,
`creator_user_name` varchar(20) NOT NULL,
`last_poster_user_name` varchar(20) DEFAULT NULL,
`last_post_date` datetime DEFAULT NULL,
`post_count` int(11) NOT NULL DEFAULT '0',
`is_sticky` tinyint(1) unsigned DEFAULT '0',
`is_locked` tinyint(1) unsigned DEFAULT '0',
`status_type_id` varchar(13) NOT NULL DEFAULT 'none',
`is_visible` tinyint(1) NOT NULL DEFAULT '1',
`created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `topics_slug_unique` (`slug`),
KEY `topics_forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;# MySQL returned an empty result set (i.e. zero rows).