SHARE
TWEET

tables

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