
CREATE TABLE IF NOT EXISTS `ci_forum_categories` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `priority` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ci_forum_categories`
--

INSERT INTO `ci_forum_categories` (`id`, `name`, `priority`) VALUES
(1, 'General', 0),
(2, 'Category II', 3);

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

--
-- Table structure for table `ci_forum_forums`
--

CREATE TABLE IF NOT EXISTS `ci_forum_forums` (
  `id` tinyint(4) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text,
  `priority` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `ci_forum_forums`
--

INSERT INTO `ci_forum_forums` (`id`, `category_id`, `name`, `description`, `priority`) VALUES
(1, 1, 'Introduce Yourself', 'Use this forum to introduce yourself', 0),
(2, 1, 'PHP Stuff', 'Here you can talk about anything that is PHP related. ', 0),
(3, 2, 'First Forum In Cat 2', 'This is a forum that is only for category two.', 0);

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

--
-- Table structure for table `ci_forum_posts`
--

CREATE TABLE IF NOT EXISTS `ci_forum_posts` (
  `id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `text` text NOT NULL,
  `date` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `ci_forum_posts`
--

INSERT INTO `ci_forum_posts` (`id`, `topic_id`, `user_id`, `title`, `text`, `date`, `status`) VALUES
(1, 1, 1, 'Just a reply', 'Nice to meet you!', 1111111111, 1),
(2, 1, 3, 'Nice to meet you too', 'Nice to meet you user 1', 1219111825, 1),
(3, 1, 4, 'I also want to say hi', 'Hello from user 4', 1119111825, 1),
(4, 2, 1, 'I think so too!', 'This is very cool', 1219111825, 1);

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

--
-- Table structure for table `ci_forum_topics`
--

CREATE TABLE IF NOT EXISTS `ci_forum_topics` (
  `id` int(11) NOT NULL auto_increment,
  `forum_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `text` text NOT NULL,
  `date` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `ci_forum_topics`
--

INSERT INTO `ci_forum_topics` (`id`, `forum_id`, `user_id`, `title`, `text`, `date`, `status`) VALUES
(1, 1, 1, 'Hello World!', 'This is a test Topic', 1111111111, 1),
(2, 2, 1, 'Topic One from Forum 2', 'This is text from user 1', 1219111825, 1),
(3, 1, 1, 'Topic Two from Forum 1', 'This is the second topic in forum 1', 1119111825, 0);