Tagged as: vusys, oss, basilmarket.
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL auto_increment,
`username` text NOT ULL,
`track` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=130 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `username`, `track`) VALUES
(1, 'vusys', 1);
CREATE TABLE IF NOT EXISTS `forum_posts` (
`forum_post_id` int(32) NOT NULL auto_increment,
`thread_id` int(32) NOT NULL,
`page_id` int(32) NOT NULL,
`post_id` int(32) NOT NULL,
`thread_name` text NOT NULL,
`username` text NOT NULL,
`datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`forum_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=226485 ;
--
-- Dumping data for table `forum_posts`
--
INSERT INTO `forum_posts` (`forum_post_id`, `thread_id`, `page_id`, `post_id`, `thread_name`, `username`, `datetime`) VALUES
(1, 952301, 1, 18910576, 'if_you_could_ask_god_one_question', 'fade2black', '2009-02-24 17:14:26');