-- MySQL dump 10.11 -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 5.0.90 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `sanitized` -- DROP TABLE IF EXISTS `sanitized`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `sanitized` ( `post_id` mediumint(8) unsigned NOT NULL default '0', `topic_id` mediumint(8) unsigned NOT NULL default '0', `forum_id` mediumint(8) unsigned NOT NULL default '0', `poster_id` mediumint(8) unsigned NOT NULL default '0', `post_time` int(11) unsigned NOT NULL default '0', `post_username` varchar(255) collate utf8_bin NOT NULL default '', `post_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '', `post_text` mediumtext collate utf8_bin NOT NULL, PRIMARY KEY (`post_id`), UNIQUE KEY `topicids` (`topic_id`,`post_id`), KEY `forum_id` (`forum_id`), KEY `topic_id` (`topic_id`), KEY `post_username` (`post_username`), KEY `poster_id` (`poster_id`), KEY `tid_post_time` (`topic_id`,`post_time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `sanitized` -- LOCK TABLES `sanitized` WRITE; /*!40000 ALTER TABLE `sanitized` DISABLE KEYS */; INSERT INTO `sanitized` VALUES (12,3,3,2,1112391142,'','subject12','text12'); INSERT INTO `sanitized` VALUES (13,4,3,2,1112393024,'','subject13','text13'); INSERT INTO `sanitized` VALUES (14,5,3,2,1112394482,'','subject14','text14'); INSERT INTO `sanitized` VALUES (15,6,3,2,1112400946,'','subject15','text15'); INSERT INTO `sanitized` VALUES (16,6,3,1,1112478441,'name16','subject16','text16'); INSERT INTO `sanitized` VALUES (17,4,3,1,1112586140,'name17','subject17','text17'); INSERT INTO `sanitized` VALUES (18,6,3,1,1112613629,'name18','subject18','text18'); INSERT INTO `sanitized` VALUES (19,4,3,1,1112614454,'name19','subject19','text19'); INSERT INTO `sanitized` VALUES (23,4,3,1,1112651615,'name23','subject23','text23'); INSERT INTO `sanitized` VALUES (24,4,3,1,1112652952,'name24','subject24','text24'); INSERT INTO `sanitized` VALUES (25,4,3,1,1112665601,'name25','subject25','text25'); /*!40000 ALTER TABLE `sanitized` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2010-04-25 18:08:15