tables

CREATE TABLE `serp_results` (
	`ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`SearchTerm` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	`URL` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	`Ad` BIT(1) NULL DEFAULT NULL,
	`AddedOn` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`ID`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
;

CREATE TABLE `serp_relatedsearches` (
	`ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`SearchTerm` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	`RelatedSearch` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	`DoSearch` BIT(1) NULL DEFAULT NULL,
	`AddedOn` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`ID`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
;


CREATE TABLE `serp_searchterms` (
	`ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`SearchTerm` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	`Results` INT(10) UNSIGNED NULL DEFAULT NULL,
	`ResultPages` INT(10) UNSIGNED NULL DEFAULT NULL,
	`Done` TIMESTAMP NULL DEFAULT NULL,
	`AddedOn` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`ID`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
AUTO_INCREMENT=2
;