daily pastebin goal
0%
SHARE
TWEET

Untitled

a guest Dec 6th, 2015 168 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE DATABASE  IF NOT EXISTS `crawler` /*!40100 DEFAULT CHARACTER SET latin1 */;
  2. USE `crawler`;
  3. -- MySQL dump 10.13  Distrib 5.6.24, for Win64 (x86_64)
  4. --
  5. -- Host: localhost    Database: crawler
  6. -- ------------------------------------------------------
  7. -- Server version       5.1.33-community
  8.  
  9. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  10. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  11. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  12. /*!40101 SET NAMES utf8 */;
  13. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  14. /*!40103 SET TIME_ZONE='+00:00' */;
  15. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  16. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  17. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  18. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  19.  
  20. --
  21. -- Table structure for table `keyword_index`
  22. --
  23.  
  24. DROP TABLE IF EXISTS `keyword_index`;
  25. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  26. /*!40101 SET character_set_client = utf8 */;
  27. CREATE TABLE `keyword_index` (
  28.   `word` VARCHAR(100) NOT NULL,
  29.   `freq` INT(3) NOT NULL,
  30.   UNIQUE KEY `word` (`word`)
  31. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  32. /*!40101 SET character_set_client = @saved_cs_client */;
  33.  
  34. --
  35. -- Table structure for table `keyword_list`
  36. --
  37.  
  38. DROP TABLE IF EXISTS `keyword_list`;
  39. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  40. /*!40101 SET character_set_client = utf8 */;
  41. CREATE TABLE `keyword_list` (
  42.   `word` VARCHAR(100) NOT NULL,
  43.   `urlhash` CHAR(32) NOT NULL,
  44.   `freq` INT(3) NOT NULL,
  45.   `per_in_site` INT(3) NOT NULL
  46. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  47. /*!40101 SET character_set_client = @saved_cs_client */;
  48.  
  49. --
  50. -- Table structure for table `url_image`
  51. --
  52.  
  53. DROP TABLE IF EXISTS `url_image`;
  54. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  55. /*!40101 SET character_set_client = utf8 */;
  56. CREATE TABLE `url_image` (
  57.   `urlhash` CHAR(32) NOT NULL,
  58.   `url` VARCHAR(250) NOT NULL,
  59.   `state` INT(2) NOT NULL,
  60.   `crawl_date` datetime DEFAULT NULL,
  61.   `backlink` INT(3) NOT NULL,
  62.   `priority` INT(1) NOT NULL,
  63.   `title` VARCHAR(500) NOT NULL,
  64.   UNIQUE KEY `urlhash` (`urlhash`),
  65.   UNIQUE KEY `url` (`url`)
  66. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  67. /*!40101 SET character_set_client = @saved_cs_client */;
  68.  
  69. --
  70. -- Table structure for table `url_webpage`
  71. --
  72.  
  73. DROP TABLE IF EXISTS `url_webpage`;
  74. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  75. /*!40101 SET character_set_client = utf8 */;
  76. CREATE TABLE `url_webpage` (
  77.   `urlhash` CHAR(32) NOT NULL,
  78.   `url` VARCHAR(250) NOT NULL,
  79.   `state` INT(2) NOT NULL,
  80.   `crawl_date` datetime DEFAULT NULL,
  81.   `backlink` INT(3) NOT NULL,
  82.   `priority` INT(1) NOT NULL,
  83.   `title` VARCHAR(500) NOT NULL,
  84.   UNIQUE KEY `urlhash` (`urlhash`),
  85.   UNIQUE KEY `url` (`url`)
  86. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  87. /*!40101 SET character_set_client = @saved_cs_client */;
  88. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  89.  
  90. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  91. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  92. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  93. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  94. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  95. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  96. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  97.  
  98. -- Dump completed on 2015-12-06 21:31:21
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top