SHARE
TWEET

tables serp crawler

a guest Apr 18th, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `serp_searchterms` (
  2.     `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.     `SearchTerm` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
  4.     `Results` INT(10) UNSIGNED NULL DEFAULT NULL,
  5.     `ResultPages` INT(10) UNSIGNED NULL DEFAULT NULL,
  6.     `Done` TIMESTAMP NULL DEFAULT NULL,
  7.     `AddedOn` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  8.     PRIMARY KEY (`ID`)
  9. )
  10. COLLATE='utf8_unicode_ci'
  11. ENGINE=InnoDB
  12. ROW_FORMAT=DYNAMIC
  13. AUTO_INCREMENT=2
  14. ;
  15.  
  16. CREATE TABLE `serp_results` (
  17.     `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  18.     `SearchTerm` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
  19.     `URL` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
  20.     `AddedOn` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  21.     PRIMARY KEY (`ID`)
  22. )
  23. COLLATE='utf8_unicode_ci'
  24. ENGINE=InnoDB
  25. ROW_FORMAT=DYNAMIC
  26. ;
  27.  
  28. CREATE TABLE `serp_relatedsearches` (
  29.     `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  30.     `SearchTerm` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
  31.     `RelatedSearch` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
  32.     `DoSearch` BIT(1) NULL DEFAULT NULL,
  33.     `AddedOn` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  34.     PRIMARY KEY (`ID`)
  35. )
  36. COLLATE='utf8_unicode_ci'
  37. ENGINE=InnoDB
  38. ;
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