-- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64) -- -- Host: 10.64.16.32 Database: enwiki -- ------------------------------------------------------ -- Server version 5.5.34-MariaDB-1~precise-log /*!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 `page` -- DROP TABLE IF EXISTS `page`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `page` ( `page_id` int(8) unsigned NOT NULL AUTO_INCREMENT, `page_namespace` int(11) NOT NULL DEFAULT '0', `page_title` varbinary(255) NOT NULL DEFAULT '', `page_restrictions` tinyblob NOT NULL, `page_counter` bigint(20) unsigned NOT NULL DEFAULT '0', `page_is_redirect` tinyint(1) unsigned NOT NULL DEFAULT '0', `page_is_new` tinyint(1) unsigned NOT NULL DEFAULT '0', `page_random` double unsigned NOT NULL DEFAULT '0', `page_touched` varbinary(14) NOT NULL DEFAULT '', `page_links_updated` varbinary(14) DEFAULT NULL, `page_latest` int(8) unsigned NOT NULL DEFAULT '0', `page_len` int(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`page_id`), UNIQUE KEY `name_title` (`page_namespace`,`page_title`), KEY `page_random` (`page_random`), KEY `page_len` (`page_len`), KEY `page_redirect_namespace_len` (`page_is_redirect`,`page_namespace`,`page_len`) ) ENGINE=InnoDB AUTO_INCREMENT=41532769 DEFAULT CHARSET=binary; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `page` -- /*!40000 ALTER TABLE `page` DISABLE KEYS */; INSERT INTO `page` VALUES (10,0,'AccessibleComputing','',0,1,0,0.33167112649574004,'20131223211334',NULL,381202555,57),(12,0,'Anarchism','',5252,0,0,0.786172332974311,'20140102071601',NULL,588758487,173521),(13,0,'AfghanistanHistory','',5,1,0,0.0621502865684687,'20140101120449',NULL,74466652,57),(14,0,'AfghanistanGeography','',0,1,0,0.952234464653055,'20140101143540',NULL,407008307,59),(15,0,'AfghanistanPeople','',4,1,0,0.574721494293512,'20140101073926',NULL,135089040,60),(18,0,'AfghanistanCommunications','',8,1,0,0.7510681513241201,'20131219163648',NULL,74466499,64),(19,0,'AfghanistanTransportations','',2,1,0,0.674272520164282,'20140101210650',NULL,409266982,79),(20,0,'AfghanistanMilitary','',7,1,0,0.118158177582694,'20131218234416',NULL,558328133,54),(21,0,'AfghanistanTransnationalIssues','',2,1,0,0.567973358154272,'20140101163532',NULL,46448859,67),(23,0,'AssistiveTechnology','',0,1,0,0.72304140005544,'20131127140227',NULL,74466798,55), ... ; ... ... ... INSERT INTO `page` VALUES (41532457,14,'1883_in_Illinois','',0,0,1,0.439835058381,'20140102224419',NULL,588880071,84), ... ,(41532768,3,'DutchWTW','',0,0,1,0.857167342465,'20140102232334',NULL,588885547,1076); /*!40000 ALTER TABLE `page` ENABLE KEYS */; /*!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 2014-01-02 23:27:07