(Edited 38 seconds later.)
(Edited 1 minute later.)
— phpMyAdmin SQL Dump — version 3.2.4 — http://www.phpmyadmin.net — — Host: 127.0.0.1 — Generation Time: Jul 29, 2011 at 09:44 AM — Server version: 5.1.41 — PHP Version: 5.3.1 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; — — Database: `anonbbs` — — ———————————————————————————— — — Table structure for table `ban_list` — CREATE TABLE IF NOT EXISTS `ban_list` ( `ban_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ban_time` int(11) NOT NULL, `ban_expire_time` int(11) NOT NULL, `ban_type` tinyint(4) NOT NULL, `ban_reason` varchar(100) DEFAULT NULL, `ban_issuer` int(10) unsigned NOT NULL, `ban_ip` varchar(16) NOT NULL, PRIMARY KEY (`ban_id`), UNIQUE KEY `ban_ip` (`ban_ip`), KEY `ban_type` (`ban_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; — — Dumping data for table `ban_list` — — ———————————————————————————— — — Table structure for table `board_list` — CREATE TABLE IF NOT EXISTS `board_list` ( `board_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `board_name` varchar(30) NOT NULL, `board_friendly_name` tinytext NOT NULL, `board_description` tinytext, `last_post` int(10) unsigned NOT NULL DEFAULT '0', `post_count` int(10) unsigned NOT NULL DEFAULT '0', `topic_count` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`board_id`), UNIQUE KEY `board_name` (`board_name`), KEY `last_post` (`last_post`), KEY `post_count` (`post_count`,`topic_count`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; — — Dumping data for table `board_list` — — ———————————————————————————— — — Table structure for table `image_list` — CREATE TABLE IF NOT EXISTS `image_list` ( `image_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `image_hash` char(16) NOT NULL, `image_name` varchar(50) NOT NULL, `image_uploader` int(10) unsigned NOT NULL, PRIMARY KEY (`image_id`), UNIQUE KEY `image_hash` (`image_hash`), KEY `image_name` (`image_name`), KEY `image_uploader` (`image_uploader`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; — — Dumping data for table `image_list` — — ———————————————————————————— — — Table structure for table `poll_list` — CREATE TABLE IF NOT EXISTS `poll_list` ( `poll_link` int(10) unsigned NOT NULL COMMENT 'Link to topic', `poll_title` varchar(255) NOT NULL, `poll_options` text NOT NULL COMMENT 'Serialize', PRIMARY KEY (`poll_link`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; — — Dumping data for table `poll_list` — — ———————————————————————————— — — Table structure for table `post_list` — CREATE TABLE IF NOT EXISTS `post_list` ( `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `post_parent` int(10) unsigned DEFAULT NULL COMMENT 'Link to topic', `post_author` int(10) unsigned NOT NULL COMMENT 'Link to user', `post_image` int(10) unsigned DEFAULT NULL COMMENT 'link to image_list', `post_body` text, `post_author_ip` varchar(16) DEFAULT NULL, `post_number` smallint(5) unsigned NOT NULL, `post_name` varchar(50) DEFAULT NULL, `post_email` varchar(50) DEFAULT NULL, `post_time` int(10) unsigned NOT NULL, `post_edit_time` int(10) DEFAULT NULL, PRIMARY KEY (`post_id`), KEY `post_parent` (`post_parent`,`post_author`,`post_author_ip`), KEY `post_time` (`post_time`), KEY `post_image` (`post_image`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; — — Dumping data for table `post_list` — — — Triggers `post_list` — DROP TRIGGER IF EXISTS `board_updater`; DELIMITER // CREATE TRIGGER `board_updater` AFTER INSERT ON `post_list` FOR EACH ROW BEGIN DECLARE board_link smallint(5) DEFAULT (SELECT topic_board_link FROM topic_list WHERE topic_id=NEW.post_parent LIMIT 1); UPDATE board_list SET board_list.last_post=NEW.post_id WHERE board_link=board_list.board_id; UPDATE board_list SET board_list.post_count=board_list.post_count+1 WHERE board_link=board_list.board_id; END // DELIMITER ; — ———————————————————————————— — — Table structure for table `private_messages` — CREATE TABLE IF NOT EXISTS `private_messages` ( `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `message_parent` int(10) unsigned DEFAULT NULL, `message_title` varchar(100) DEFAULT NULL, `message_body` text NOT NULL, `message_time` int(10) unsigned NOT NULL, `message_receiver` int(10) unsigned NOT NULL, `message_sender` int(10) unsigned NOT NULL, `message_read` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`message_id`), KEY `message_parent` (`message_parent`,`message_time`), KEY `message_receive` (`message_receiver`,`message_sender`), KEY `message_time` (`message_time`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; — — Dumping data for table `private_messages` — — ———————————————————————————— — — Table structure for table `topic_list` — CREATE TABLE IF NOT EXISTS `topic_list` ( `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `topic_board_link` smallint(5) unsigned NOT NULL, `topic_title` varchar(100) NOT NULL, `topic_stickied` tinyint(1) NOT NULL, `topic_locked` tinyint(1) NOT NULL, `topic_hidden` tinyint(1) NOT NULL, `topic_views` mediumint(8) unsigned NOT NULL DEFAULT '0', `topic_rates` int(10) unsigned NOT NULL COMMENT 'The amount of ratings', `topic_total_rating` int(10) unsigned NOT NULL COMMENT 'The total amount of ratings', PRIMARY KEY (`topic_id`), KEY `topic_locked` (`topic_locked`), KEY `topic_total_rating` (`topic_total_rating`), KEY `topic_title` (`topic_title`), KEY `topic_board_link` (`topic_board_link`), KEY `topic_views` (`topic_views`), KEY `topic_stickied` (`topic_stickied`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; — — Dumping data for table `topic_list` — — — Triggers `topic_list` — DROP TRIGGER IF EXISTS `thread_updater`; DELIMITER // CREATE TRIGGER `thread_updater` AFTER INSERT ON `topic_list` FOR EACH ROW BEGIN UPDATE board_list SET board_list.topic_count = board_list.topic_count+1 WHERE NEW.topic_board_link=board_list.board_id; END // DELIMITER ; — ———————————————————————————— — — Table structure for table `user_list` — CREATE TABLE IF NOT EXISTS `user_list` ( `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_password` char(16) NOT NULL, `user_registered` int(11) NOT NULL, `user_theme` tinyint(4) NOT NULL DEFAULT '0', `user_friendly_name` varchar(255) DEFAULT NULL, `user_friendly_password` char(16) DEFAULT NULL, `user_email` varchar(100) DEFAULT NULL, `user_ip` varchar(16) DEFAULT NULL, `post_name` tinytext, `user_allow_messages` tinyint(1) NOT NULL DEFAULT '1', `user_data` text, PRIMARY KEY (`user_id`), UNIQUE KEY `user_password` (`user_password`), UNIQUE KEY `user_friendly_name` (`user_friendly_name`), KEY `user_registered` (`user_registered`,`user_friendly_password`,`user_email`,`user_ip`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; — — Dumping data for table `user_list` —