/*
 Navicat MySQL Data Transfer

 Source Server         : OVH-MVP-PROD-148.113.189.152
 Source Server Type    : MySQL
 Source Server Version : 80045
 Source Host           : 127.0.0.1:3306
 Source Schema         : searchmercials

 Target Server Type    : MySQL
 Target Server Version : 80045
 File Encoding         : 65001

 Date: 13/04/2026 09:26:43
*/


-- ----------------------------
-- Table structure for bm_accounts
-- ----------------------------
CREATE TABLE `bm_accounts`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`acct_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_click_log
-- ----------------------------
CREATE TABLE `bm_click_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` int NOT NULL DEFAULT 0,
  `campaign` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `banner` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `bn_member` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ex_member` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_id` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_clicks` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `cl1`(`date`, `campaign`) USING BTREE,
  INDEX `cl2`(`date`, `bn_member`, `site_id`) USING BTREE,
  INDEX `cl3`(`date`, `ex_member`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_deposits
-- ----------------------------
CREATE TABLE `bm_deposits`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `acct_id` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `tax` decimal(9, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_gdep`(`acct_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_exchange_curr
-- ----------------------------
CREATE TABLE `bm_exchange_curr`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `ex_remaining` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_finances
-- ----------------------------
CREATE TABLE `bm_finances`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` int NOT NULL DEFAULT 0,
  `account` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `campaign` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `item_purchased` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `quantity` int NOT NULL DEFAULT 0,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_groups
-- ----------------------------
CREATE TABLE `bm_groups`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `account` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `bm_grp_acct`(`group_name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_payments
-- ----------------------------
CREATE TABLE `bm_payments`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `member` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `paid_date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `paid_amount` decimal(9, 2) NULL DEFAULT NULL,
  `due_amount` decimal(9, 2) NULL DEFAULT NULL,
  `balance` decimal(9, 2) NULL DEFAULT NULL,
  `period_start` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `period_end` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `tstamp` int NOT NULL DEFAULT 0,
  `comments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `bm_pay1`(`member`, `paid_date`) USING BTREE,
  INDEX `bm_pay2`(`member`, `tstamp`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_rotation
-- ----------------------------
CREATE TABLE `bm_rotation`  (
  `group_name` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `last_campaign` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`group_name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_sites
-- ----------------------------
CREATE TABLE `bm_sites`  (
  `site_owner` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_id` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_type` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `status` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_title` char(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_url` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_desc` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `approved_referers` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `allow_targets` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `exclude_targets` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `exclude_domains` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `campaign` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`site_id`) USING BTREE,
  INDEX `bms_2`(`status`) USING BTREE,
  INDEX `bms_3`(`site_owner`) USING BTREE,
  INDEX `bms_4`(`site_type`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_sites_temp
-- ----------------------------
CREATE TABLE `bm_sites_temp`  (
  `site_owner` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_id` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_type` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `status` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_title` char(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_url` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_desc` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `approved_referers` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `allow_targets` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `exclude_targets` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `exclude_domains` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `campaign` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`site_id`) USING BTREE,
  INDEX `bms_2`(`status`) USING BTREE,
  INDEX `bms_3`(`site_owner`) USING BTREE,
  INDEX `bms_4`(`site_type`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for bm_statistics
-- ----------------------------
CREATE TABLE `bm_statistics`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` int NOT NULL DEFAULT 0,
  `campaign` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `banner` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `bn_member` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ex_member` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `site_id` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `group_name` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_clicks` int NULL DEFAULT NULL,
  `num_impressions` int NULL DEFAULT NULL,
  `paid_flag` char(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `st1`(`date`, `campaign`) USING BTREE,
  INDEX `st2`(`date`, `bn_member`, `site_id`) USING BTREE,
  INDEX `st3`(`date`, `ex_member`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for campaign_pay
-- ----------------------------
CREATE TABLE `campaign_pay`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `campaign` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `impression_amt` decimal(11, 5) NULL DEFAULT NULL,
  `click_amt` decimal(11, 5) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `camp_p1`(`campaign`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for campaign_temp
-- ----------------------------
CREATE TABLE `campaign_temp`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `campaign` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `parent_account` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `category` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `target` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `redirect_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `alt_text` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `under_text` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `banner_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `width` int NULL DEFAULT NULL,
  `height` int NULL DEFAULT NULL,
  `banner_text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `expiration_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_clicks` int NULL DEFAULT NULL,
  `clicks_allowed` int NULL DEFAULT NULL,
  `num_impressions` int NULL DEFAULT NULL,
  `imp_allowed` int NULL DEFAULT NULL,
  `start_date` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `end_date` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_disabled` int NULL DEFAULT NULL,
  `num_credits` decimal(11, 5) NULL DEFAULT NULL,
  `time_restricted` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `start_time` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `end_time` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `max_per_day` int NULL DEFAULT NULL,
  `last_shown_time` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `bm_camp`(`campaign`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for campaigns
-- ----------------------------
CREATE TABLE `campaigns`  (
  `campaingid` int NOT NULL AUTO_INCREMENT,
  `campaign` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `parent_account` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `category` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `target` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `redirect_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `alt_text` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `under_text` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `banner_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `banner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `width` int NULL DEFAULT NULL,
  `height` int NULL DEFAULT NULL,
  `banner_text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `expiration_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_clicks` int NULL DEFAULT NULL,
  `clicks_allowed` int NULL DEFAULT NULL,
  `num_impressions` int NULL DEFAULT NULL,
  `imp_allowed` int NULL DEFAULT NULL,
  `start_date` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `end_date` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_disabled` int NULL DEFAULT NULL,
  `num_credits` decimal(11, 5) NULL DEFAULT NULL,
  `time_restricted` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `start_time` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `end_time` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `max_per_day` int NULL DEFAULT NULL,
  `last_shown_time` int NULL DEFAULT NULL,
  PRIMARY KEY (`campaingid`) USING BTREE,
  INDEX `bm_camp`(`campaign`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for geoiplocation
-- ----------------------------
CREATE TABLE `geoiplocation`  (
  `startIpNum` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `endIpNum` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `country` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `region` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `postalCode` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `latitude` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `longitude` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `dmaCode` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `areaCode` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for geoiptbl
-- ----------------------------
CREATE TABLE `geoiptbl`  (
  `startIpNum` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `endIpNum` varchar(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `country` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `region` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `postalCode` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `latitude` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `longitude` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `dmaCode` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `areaCode` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_balance
-- ----------------------------
CREATE TABLE `iweb_accounts_balance`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `balance` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `total_paid` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `last_paid_date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ppl` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `ppl_total_paid` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `ppl_last_paid_date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`acct_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_details
-- ----------------------------
CREATE TABLE `iweb_accounts_details`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `service_provider` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `domain_contactid` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `AuthNetCustID` int NULL DEFAULT NULL,
  `facebook` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `twitter` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `linkedin` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `instagram` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `youtube` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`acct_id`) USING BTREE,
  INDEX `service_provider`(`service_provider`) USING BTREE,
  INDEX `AuthNetProfID`(`AuthNetCustID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_financial_cim
-- ----------------------------
CREATE TABLE `iweb_accounts_financial_cim`  (
  `finidkey` int NOT NULL,
  `AuthNetCustID` int NULL DEFAULT NULL COMMENT 'Use Data from Integration Table - Documentation Only',
  `AuthNetPayID` int NULL DEFAULT NULL,
  `CCTypeIdKey` tinyint NULL DEFAULT NULL,
  PRIMARY KEY (`finidkey`) USING BTREE,
  INDEX `AuthNetCustID`(`AuthNetCustID`, `AuthNetPayID`) USING BTREE,
  INDEX `CCTypeIdKey`(`CCTypeIdKey`) USING BTREE,
  INDEX `AuthNetPayID`(`AuthNetPayID`) USING BTREE,
  CONSTRAINT `iweb_accounts_financial_cim_ibfk_1` FOREIGN KEY (`finidkey`) REFERENCES `iweb_accounts_financial` (`fin_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_network_servers
-- ----------------------------
CREATE TABLE `iweb_accounts_network_servers`  (
  `networkidkey` int NOT NULL DEFAULT 0,
  `serveridkey` int NOT NULL DEFAULT 0,
  PRIMARY KEY (`networkidkey`, `serveridkey`) USING BTREE,
  INDEX `serveridkey`(`serveridkey`) USING BTREE,
  CONSTRAINT `iweb_accounts_network_servers_ibfk_1` FOREIGN KEY (`networkidkey`) REFERENCES `iweb_accounts_networks` (`networkid`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `iweb_accounts_network_servers_ibfk_2` FOREIGN KEY (`serveridkey`) REFERENCES `iweb_accounts_servers` (`serverid`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_status
-- ----------------------------
CREATE TABLE `iweb_accounts_status`  (
  `statusid` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `accountstatus` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`statusid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_tblimagebank
-- ----------------------------
CREATE TABLE `iweb_accounts_tblimagebank`  (
  `ImageID` int NOT NULL AUTO_INCREMENT,
  `Acct_Id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ImageFile` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ImageName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ImageID`) USING BTREE,
  UNIQUE INDEX `AcctUniqueImage`(`Acct_Id`, `ImageFile`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_templates_hosts
-- ----------------------------
CREATE TABLE `iweb_accounts_templates_hosts`  (
  `TemplateIDKey` int NOT NULL DEFAULT 0,
  `HostHeader` varchar(180) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`TemplateIDKey`, `HostHeader`) USING BTREE,
  INDEX `HostHeader`(`HostHeader`) USING BTREE,
  CONSTRAINT `iweb_accounts_templates_hosts_ibfk_1` FOREIGN KEY (`TemplateIDKey`) REFERENCES `iweb_accounts_templates` (`TemplateID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `iweb_accounts_templates_hosts_ibfk_2` FOREIGN KEY (`TemplateIDKey`) REFERENCES `iweb_accounts_templates` (`TemplateID`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_terms
-- ----------------------------
CREATE TABLE `iweb_accounts_terms`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `baldaysnet` int NULL DEFAULT NULL COMMENT 'Number of Days NET',
  `balamtnet` decimal(9, 2) NULL DEFAULT NULL COMMENT 'Amount NET',
  `requiredfunds` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Determines if House Credit can Pay Required Funds',
  `ref_com` decimal(5, 2) NULL DEFAULT NULL,
  `sales_buy_com` decimal(5, 2) NULL DEFAULT NULL,
  `prod_com` decimal(5, 2) NULL DEFAULT NULL,
  `plat_com` decimal(5, 2) NULL DEFAULT NULL,
  `sales_sell_com` decimal(5, 2) NULL DEFAULT NULL,
  `sales_trans_price` decimal(9, 2) NULL DEFAULT NULL,
  `managed_price` decimal(9, 2) NULL DEFAULT NULL,
  `dailytrans_price` decimal(9, 2) NULL DEFAULT NULL,
  `minimum_payment` decimal(9, 2) NULL DEFAULT NULL,
  `featured_price` decimal(9, 2) NULL DEFAULT NULL,
  `production_price` decimal(9, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`acct_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_terms_temp
-- ----------------------------
CREATE TABLE `iweb_accounts_terms_temp`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `baldaysnet` int NULL DEFAULT NULL,
  `balamtnet` decimal(9, 2) NULL DEFAULT NULL,
  `ref_com` decimal(5, 2) NULL DEFAULT NULL,
  `sales_buy_com` decimal(5, 2) NULL DEFAULT NULL,
  `prod_com` decimal(5, 2) NULL DEFAULT NULL,
  `plat_com` decimal(5, 2) NULL DEFAULT NULL,
  `sales_sell_com` decimal(5, 2) NULL DEFAULT NULL,
  `sales_trans_price` decimal(9, 2) NULL DEFAULT NULL,
  `managed_price` decimal(9, 2) NULL DEFAULT NULL,
  `dailytrans_price` decimal(9, 2) NULL DEFAULT NULL,
  `minimum_payment` decimal(9, 2) NULL DEFAULT NULL,
  `featured_price` decimal(9, 2) NULL DEFAULT NULL,
  `production_price` decimal(9, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`acct_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_accounts_types
-- ----------------------------
CREATE TABLE `iweb_accounts_types`  (
  `typeid` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `CategoryValue` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`typeid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_deposits
-- ----------------------------
CREATE TABLE `iweb_acct_deposits`  (
  `acct_id` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `tax` decimal(9, 2) NULL DEFAULT NULL,
  INDEX `hsl_gdep`(`acct_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_deposits-orig
-- ----------------------------
CREATE TABLE `iweb_acct_deposits-orig`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `acct_id` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `tax` decimal(9, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_gdep`(`acct_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_summary
-- ----------------------------
CREATE TABLE `iweb_acct_summary`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `click_count` int NULL DEFAULT NULL,
  `click_amount` decimal(9, 2) NULL DEFAULT NULL,
  `fraud_count` int NULL DEFAULT NULL,
  `deposit_count` int NULL DEFAULT NULL,
  `deposit_amount` decimal(9, 2) NULL DEFAULT NULL,
  `withdrawl_count` int NULL DEFAULT NULL,
  `withdrawl_amount` decimal(9, 2) NULL DEFAULT NULL,
  `escrow_count` int NULL DEFAULT NULL,
  `escrow_amount` decimal(9, 2) NULL DEFAULT NULL,
  `earnings_due` decimal(9, 2) NULL DEFAULT NULL,
  `earnings_paid` decimal(9, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`acct_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_transactions
-- ----------------------------
CREATE TABLE `iweb_acct_transactions`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `acct_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_date` int NOT NULL DEFAULT 0,
  `trans_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `tax_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `source` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `commission_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `commission_paid_date` int NULL DEFAULT NULL,
  `extra_info` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_finance1`(`acct_id`) USING BTREE,
  INDEX `hsl_finance2`(`affiliate`) USING BTREE,
  INDEX `hsl_finance3`(`trans_type`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_transactions_gbl
-- ----------------------------
CREATE TABLE `iweb_acct_transactions_gbl`  (
  `trans_id` int NOT NULL AUTO_INCREMENT,
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `sales_rep` tinyint(1) NOT NULL DEFAULT 0,
  `trans_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `trans_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `tax_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `source` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `platform_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `referer` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `referer_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `network` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `channel_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `revshare_com` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `balance` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `extra_info` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_status` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `auth_trans_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `orderid` int NULL DEFAULT NULL,
  `productid` int NULL DEFAULT NULL,
  `paid_comments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`trans_id`) USING BTREE,
  INDEX `orderid`(`orderid`) USING BTREE,
  INDEX `productid`(`productid`) USING BTREE,
  INDEX `acct_id`(`acct_id`) USING BTREE,
  INDEX `source`(`source`) USING BTREE,
  INDEX `referer`(`referer`) USING BTREE,
  INDEX `network`(`network`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_transactions_log
-- ----------------------------
CREATE TABLE `iweb_acct_transactions_log`  (
  `trans_id` int NOT NULL AUTO_INCREMENT,
  `trans_typeidkey` int NOT NULL DEFAULT 0,
  `trans_itemidentifier` int NULL DEFAULT NULL,
  `factortypeidkey` int NULL DEFAULT NULL,
  `factoramt` int NULL DEFAULT NULL,
  `factoramttype` int NULL DEFAULT NULL,
  `source` int NULL DEFAULT NULL COMMENT 'CIM or other sources (wwbn_transaction_providers)',
  `source_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `purchaseitemidkey` int NULL DEFAULT NULL,
  `startdate` datetime NULL DEFAULT NULL,
  `enddate` datetime NULL DEFAULT NULL,
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `sales_rep` tinyint(1) NOT NULL DEFAULT 0,
  `trans_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `trans_price` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'The price of the transaction as reflected at checkout',
  `trans_amount` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT ' Total cost of this transaction - (trans_amount = applied_balance + applied_credit + funds_provided)',
  `tax_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `applied_balance` decimal(9, 2) NOT NULL COMMENT 'Amount of the account\'s available balance applied towards the trans amount',
  `applied_net` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'Amount of the account\'s available net applied towards the trans amount',
  `funds_provided` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'Amount of the funds provided from a credit card or other source towards the trans amount',
  `unit_price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `platformidkey` int NULL DEFAULT NULL,
  `platform_fees` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `platform_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `enterpriseidkey` int NULL DEFAULT NULL,
  `is_enterprise` tinyint(1) NOT NULL DEFAULT 0,
  `enterprise_commission` decimal(9, 2) NOT NULL,
  `enterprise_fee` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'Enterprise instance fees',
  `instanceidkey` int NULL DEFAULT NULL,
  `is_instance` tinyint(1) NOT NULL DEFAULT 0,
  `instance_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `salesrep_buyer` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_salesrepbuy` tinyint(1) NOT NULL DEFAULT 0,
  `salesrep_buyer_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `seller` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_seller` tinyint(1) NOT NULL DEFAULT 0,
  `seller_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `salesrep_seller` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_salesrepsell` tinyint(1) NOT NULL DEFAULT 0,
  `salesrep_seller_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `balance` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'The amount owed of NET owed for transaction',
  `responsible_acctkey` int NULL DEFAULT NULL,
  `purchasing_acctid` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `purchasing_user` int NULL DEFAULT NULL,
  `extra_info` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_statusid` tinyint NOT NULL DEFAULT 1,
  `trans_status` enum('Pending','Completed','Allocated','Paid','Void') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Indicates the payout status of transaction (Allocated, Paid, Void)',
  `auth_trans_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`trans_id`) USING BTREE,
  UNIQUE INDEX `trans_item`(`trans_typeidkey`, `trans_itemidentifier`, `purchaseitemidkey`, `factortypeidkey`) USING BTREE,
  INDEX `salesrep_buyer`(`salesrep_buyer`) USING BTREE,
  INDEX `salesrep_seller`(`salesrep_seller`) USING BTREE,
  INDEX `acct_id`(`acct_id`) USING BTREE,
  INDEX `enterprise`(`enterpriseidkey`) USING BTREE,
  INDEX `purchaseitemidkey`(`purchaseitemidkey`) USING BTREE,
  INDEX `seller`(`seller`) USING BTREE,
  INDEX `platformidkey`(`platformidkey`) USING BTREE,
  INDEX `source`(`source`) USING BTREE,
  INDEX `instanceidkey`(`instanceidkey`) USING BTREE,
  INDEX `factortypeidkey`(`factortypeidkey`) USING BTREE,
  INDEX `factoramttype`(`factoramttype`) USING BTREE,
  INDEX `trans_date`(`trans_date`) USING BTREE,
  INDEX `responsible_acctkey`(`responsible_acctkey`) USING BTREE,
  INDEX `trans_status`(`trans_status`) USING BTREE,
  INDEX `trans_statusid`(`trans_statusid`) USING BTREE,
  INDEX `trans_typeidkey`(`trans_typeidkey`, `trans_statusid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_transactions_log_temp
-- ----------------------------
CREATE TABLE `iweb_acct_transactions_log_temp`  (
  `trans_id` int NOT NULL AUTO_INCREMENT,
  `trans_typeidkey` int NOT NULL DEFAULT 0,
  `trans_itemidentifier` int NULL DEFAULT NULL,
  `factortypeidkey` int NULL DEFAULT NULL,
  `factoramt` int NULL DEFAULT NULL,
  `factoramttype` int NULL DEFAULT NULL,
  `source` int NULL DEFAULT NULL COMMENT 'CIM or other sources (wwbn_transaction_providers)',
  `source_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `purchaseitemidkey` int NULL DEFAULT NULL,
  `startdate` datetime NULL DEFAULT NULL,
  `enddate` datetime NULL DEFAULT NULL,
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `sales_rep` tinyint(1) NOT NULL DEFAULT 0,
  `trans_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `trans_price` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'The price of the transaction as reflected at checkout',
  `trans_amount` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT ' Total cost of this transaction - (trans_amount = applied_balance + applied_credit + funds_provided)',
  `tax_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `applied_balance` decimal(9, 2) NOT NULL COMMENT 'Amount of the account\'s available balance applied towards the trans amount',
  `applied_net` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'Amount of the account\'s available net applied towards the trans amount',
  `funds_provided` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'Amount of the funds provided from a credit card or other source towards the trans amount',
  `unit_price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `platformidkey` int NULL DEFAULT NULL,
  `platform_fees` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `platform_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `enterpriseidkey` int NULL DEFAULT NULL,
  `enterprise_commission` decimal(9, 2) NOT NULL,
  `instanceidkey` int NULL DEFAULT NULL,
  `instance_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `salesrep_buyer` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `salesrep_buyer_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `seller` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `seller_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `salesrep_seller` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `salesrep_seller_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `balance` decimal(9, 2) NOT NULL DEFAULT 0.00 COMMENT 'The amount owed of NET owed for transaction',
  `responsible_acctkey` int NULL DEFAULT NULL,
  `purchasing_acctid` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `purchasing_user` int NULL DEFAULT NULL,
  `extra_info` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_status` enum('Pending','Completed','Void') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'Indicates the payout status of transaction (Pending, Completed, Void)',
  `auth_trans_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`trans_id`) USING BTREE,
  UNIQUE INDEX `trans_typeidkey`(`trans_typeidkey`, `trans_itemidentifier`, `purchaseitemidkey`, `factortypeidkey`) USING BTREE,
  INDEX `salesrep_buyer`(`salesrep_buyer`) USING BTREE,
  INDEX `salesrep_seller`(`salesrep_seller`) USING BTREE,
  INDEX `acct_id`(`acct_id`) USING BTREE,
  INDEX `enterprise`(`enterpriseidkey`) USING BTREE,
  INDEX `purchaseitemidkey`(`purchaseitemidkey`) USING BTREE,
  INDEX `seller`(`seller`) USING BTREE,
  INDEX `platformidkey`(`platformidkey`) USING BTREE,
  INDEX `source`(`source`) USING BTREE,
  INDEX `instanceidkey`(`instanceidkey`) USING BTREE,
  INDEX `factortypeidkey`(`factortypeidkey`) USING BTREE,
  INDEX `factoramttype`(`factoramttype`) USING BTREE,
  INDEX `trans_date`(`trans_date`) USING BTREE,
  INDEX `responsible_acctkey`(`responsible_acctkey`) USING BTREE,
  INDEX `trans_status`(`trans_status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_transactions_ppl
-- ----------------------------
CREATE TABLE `iweb_acct_transactions_ppl`  (
  `trans_id` int NOT NULL AUTO_INCREMENT,
  `acct_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `sales_rep` tinyint(1) NOT NULL DEFAULT 0,
  `trans_date` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `tax_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `source` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `network` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `referer` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `platform_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `channel_commission` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `affiliate` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `revshare_com` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `balance` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `extra_info` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `trans_status` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `auth_trans_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `orderid` int NOT NULL DEFAULT 0,
  `channelid` int NOT NULL DEFAULT 0,
  `paid_comments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `ppl_last_paid_date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `field1` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`trans_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_acct_withdrawls
-- ----------------------------
CREATE TABLE `iweb_acct_withdrawls`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `acct_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `withdrawl_amount` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `payment_method` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_gwit`(`acct_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_access
-- ----------------------------
CREATE TABLE `iweb_affiliate_access`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `affiliate` char(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `ip_number` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `link_id` int NOT NULL DEFAULT 0,
  `link_id_count` int NULL DEFAULT NULL,
  `search_terms` char(224) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `num_searches` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_access1`(`ip_number`, `link_id`) USING BTREE,
  INDEX `hsl_access2`(`ip_number`, `search_terms`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_balance
-- ----------------------------
CREATE TABLE `iweb_affiliate_balance`  (
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `balance` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `total_paid` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `last_paid_date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ppl_balance` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `ppl_total_paid` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `ppl_last_paid_date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`affiliate`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_cobrand
-- ----------------------------
CREATE TABLE `iweb_affiliate_cobrand`  (
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `brandidkey` int NULL DEFAULT NULL,
  `customurl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`affiliate`) USING BTREE,
  INDEX `brandidkey`(`brandidkey`) USING BTREE,
  CONSTRAINT `iweb_affiliate_cobrand_ibfk_1` FOREIGN KEY (`affiliate`) REFERENCES `iweb_affiliate_info` (`affiliate`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `iweb_affiliate_cobrand_ibfk_2` FOREIGN KEY (`brandidkey`) REFERENCES `iweb_affiliate_cobrand_types` (`brandid`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_cobrand_types
-- ----------------------------
CREATE TABLE `iweb_affiliate_cobrand_types`  (
  `brandid` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `url` varchar(180) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`brandid`, `url`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_html
-- ----------------------------
CREATE TABLE `iweb_affiliate_html`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `header` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `footer` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`acct_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_info
-- ----------------------------
CREATE TABLE `iweb_affiliate_info`  (
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'Inactive',
  `payment_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'cash',
  `payment_trigger` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'click',
  `search_amount` int NULL DEFAULT 50,
  `click_amount` int NULL DEFAULT 50,
  `revshare_amount` int NULL DEFAULT 50,
  `allowed_referers` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `minimum_payment` decimal(9, 2) NULL DEFAULT NULL,
  `application_date` date NULL DEFAULT NULL,
  `approval_date` date NULL DEFAULT NULL,
  `xml_feeds` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL COMMENT 'Index into the site the engine name from the iweb_xml_feeds table',
  `selected_cats` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `video_mimetypes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `notes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `restrict_bans` tinyint(1) NULL DEFAULT 1,
  `publisher_logo` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT '380 X 380 GIF, PNG or JPG',
  `publisher_brand` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT '250 X 70 GIF, PNG or JPG',
  PRIMARY KEY (`affiliate`, `affiliate_type`) USING BTREE,
  UNIQUE INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_pages
-- ----------------------------
CREATE TABLE `iweb_affiliate_pages`  (
  `page_id` int NOT NULL AUTO_INCREMENT,
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `page_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `page_title` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `page_description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `page_html` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`page_id`) USING BTREE,
  INDEX `acct_id`(`affiliate`) USING BTREE,
  INDEX `page_name`(`page_name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_payments
-- ----------------------------
CREATE TABLE `iweb_affiliate_payments`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `paid_date` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `paid_amount` decimal(9, 2) NULL DEFAULT NULL,
  `due_amount` decimal(9, 2) NULL DEFAULT NULL,
  `balance` decimal(9, 2) NULL DEFAULT NULL,
  `period_start` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `period_end` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `tstamp` int NOT NULL DEFAULT 0,
  `comments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_pay1`(`affiliate`, `paid_date`) USING BTREE,
  INDEX `hsl_pay2`(`affiliate`, `tstamp`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliate_searches
-- ----------------------------
CREATE TABLE `iweb_affiliate_searches`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `acct_id` char(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `search_date` int NOT NULL DEFAULT 0,
  `search_count` int NULL DEFAULT NULL,
  `commission` decimal(9, 2) NULL DEFAULT NULL,
  `paid_flag` char(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_affs1`(`acct_id`, `search_date`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliates_cats
-- ----------------------------
CREATE TABLE `iweb_affiliates_cats`  (
  `affcatid` int NOT NULL AUTO_INCREMENT,
  `affcat` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `affcatdesc` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`affcatid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_affiliates_demo
-- ----------------------------
CREATE TABLE `iweb_affiliates_demo`  (
  `demoid` int NOT NULL AUTO_INCREMENT,
  `affcatid` int NULL DEFAULT NULL,
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate_ppl_comm` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `monthly_traffic` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `page_views` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `target_market` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `region` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `circulation` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `monthly_searches` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `age_groups` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_topic` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `productid` int NULL DEFAULT 0,
  `notes` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`demoid`) USING BTREE,
  UNIQUE INDEX `affiliate`(`affiliate`) USING BTREE,
  INDEX `affcatid`(`affcatid`) USING BTREE,
  CONSTRAINT `iweb_affiliates_demo_ibfk_1` FOREIGN KEY (`affcatid`) REFERENCES `iweb_affiliates_cats` (`affcatid`) ON DELETE SET NULL ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci COMMENT = 'Publisher Demographics' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_claimed_listings
-- ----------------------------
CREATE TABLE `iweb_claimed_listings`  (
  `cid` int NOT NULL AUTO_INCREMENT,
  `order_id` int NULL DEFAULT NULL,
  `ypid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `orgs` int NULL DEFAULT NULL,
  `acct_key_fk` int NULL DEFAULT NULL,
  `contact_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `company` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `contact_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `Contact_Phone` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `Contact_Mobile` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `Company_Email` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `Iweb_Category` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `Primary_Category` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `Suggested_Categories` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `address` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address2` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `country` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `longitude` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `latitude` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `last_ip` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `referred_by` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `sales_rep` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`cid`) USING BTREE,
  UNIQUE INDEX `ypid`(`ypid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_contentmatch
-- ----------------------------
CREATE TABLE `iweb_contentmatch`  (
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `last_update` int NULL DEFAULT NULL,
  PRIMARY KEY (`url`) USING BTREE,
  INDEX `cmlookup`(`last_update`, `url`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_glossary
-- ----------------------------
CREATE TABLE `iweb_glossary`  (
  `word` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `definition` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`word`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_group_assignments
-- ----------------------------
CREATE TABLE `iweb_group_assignments`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `acct_id` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `ug1`(`acct_id`) USING BTREE,
  INDEX `ug2`(`group_name`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_categories
-- ----------------------------
CREATE TABLE `iweb_hs_categories`  (
  `category_id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NOT NULL DEFAULT 0,
  `last_activity` int NOT NULL DEFAULT 0,
  `last_listing` int NOT NULL DEFAULT 0,
  `cat_count` int NOT NULL DEFAULT 0,
  `teaser` int NOT NULL DEFAULT 0,
  `sort_order` int NOT NULL DEFAULT 0,
  `price` int NOT NULL,
  `category_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `category_icon` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `full_name` varchar(180) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `meta_title` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `meta_keywords` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `page_content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `rule` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `qualifiers` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `template` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`category_id`) USING BTREE,
  UNIQUE INDEX `full_name`(`full_name`) USING BTREE,
  INDEX `hsc1`(`parent_id`) USING BTREE,
  INDEX `hsc2`(`last_activity`) USING BTREE,
  INDEX `hsc3`(`last_listing`) USING BTREE,
  INDEX `meta_keywords`(`meta_keywords`) USING BTREE,
  INDEX `category_name`(`category_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 976 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_categories_sitemeta
-- ----------------------------
CREATE TABLE `iweb_hs_categories_sitemeta`  (
  `sitemeta_id` int NOT NULL AUTO_INCREMENT,
  `sitelink_id` int NOT NULL COMMENT 'site link id from demo_youportal.domain_names_sites',
  `category_id` int NOT NULL DEFAULT 0,
  `last_activity` int NOT NULL DEFAULT 0,
  `og_title` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `og_keywords` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `og_description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `og_image` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `og_alt` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `acctid_fk` int NULL DEFAULT NULL,
  PRIMARY KEY (`sitemeta_id`) USING BTREE,
  INDEX `hsc1`(`category_id`) USING BTREE,
  INDEX `hsc2`(`last_activity`) USING BTREE,
  INDEX `meta_keywords`(`og_keywords`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_categories_sitemeta_website_default
-- ----------------------------
CREATE TABLE `iweb_hs_categories_sitemeta_website_default`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `siteid` int NOT NULL,
  `sitelink_id` int NOT NULL COMMENT 'site link id from demo_youportal.domain_names_sites',
  `acctid_fk` int NOT NULL,
  `og_image` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_categories_xml
-- ----------------------------
CREATE TABLE `iweb_hs_categories_xml`  (
  `xmlcatid` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `xmlcatname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `xmltypeidkey` int NOT NULL DEFAULT 0,
  `catidkey` int NOT NULL DEFAULT 0,
  PRIMARY KEY (`xmlcatid`, `xmltypeidkey`) USING BTREE,
  INDEX `xmltypeidkey`(`xmltypeidkey`) USING BTREE,
  INDEX `catidkey`(`catidkey`) USING BTREE,
  CONSTRAINT `iweb_hs_categories_xml_ibfk_1` FOREIGN KEY (`xmltypeidkey`) REFERENCES `iweb_hs_categories_xml_type` (`xmltypeid`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `iweb_hs_categories_xml_ibfk_2` FOREIGN KEY (`catidkey`) REFERENCES `iweb_hs_categories` (`category_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_categories_xml_copy1
-- ----------------------------
CREATE TABLE `iweb_hs_categories_xml_copy1`  (
  `xmlcatid` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `xmlcatname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `xmltypeidkey` int NOT NULL DEFAULT 0,
  `catidkey` int NOT NULL DEFAULT 0,
  PRIMARY KEY (`xmlcatid`, `xmltypeidkey`) USING BTREE,
  INDEX `xmltypeidkey`(`xmltypeidkey`) USING BTREE,
  INDEX `catidkey`(`catidkey`) USING BTREE,
  CONSTRAINT `iweb_hs_categories_xml_copy1_ibfk_1` FOREIGN KEY (`xmltypeidkey`) REFERENCES `iweb_hs_categories_xml_type` (`xmltypeid`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `iweb_hs_categories_xml_copy1_ibfk_2` FOREIGN KEY (`catidkey`) REFERENCES `iweb_hs_categories` (`category_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_categories_xml_type
-- ----------------------------
CREATE TABLE `iweb_hs_categories_xml_type`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `xmltypeid` int NOT NULL AUTO_INCREMENT,
  `xmltypename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `xmlcatdef` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `xmlpublic` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`xmltypeid`) USING BTREE,
  UNIQUE INDEX `xmltypename`(`xmltypename`) USING BTREE,
  INDEX `acct_id`(`acct_id`, `xmlpublic`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_categories_xml_type_copy1
-- ----------------------------
CREATE TABLE `iweb_hs_categories_xml_type_copy1`  (
  `acct_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `xmltypeid` int NOT NULL AUTO_INCREMENT,
  `xmltypename` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `xmlcatdef` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `xmlpublic` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`xmltypeid`) USING BTREE,
  UNIQUE INDEX `xmltypename`(`xmltypename`) USING BTREE,
  INDEX `acct_id`(`acct_id`, `xmlpublic`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_category_tree
-- ----------------------------
CREATE TABLE `iweb_hs_category_tree`  (
  `category_id` int NOT NULL DEFAULT 0,
  `parents` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `children` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`category_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_featured
-- ----------------------------
CREATE TABLE `iweb_hs_featured`  (
  `area` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `id` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`area`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_moderator_log
-- ----------------------------
CREATE TABLE `iweb_hs_moderator_log`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL DEFAULT 0,
  `moderator_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `num_added` int NULL DEFAULT NULL,
  `num_deleted` int NULL DEFAULT NULL,
  `num_rejected` int NULL DEFAULT NULL,
  `num_approved` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsm1`(`moderator_id`) USING BTREE,
  INDEX `hsm2`(`category_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_moderators
-- ----------------------------
CREATE TABLE `iweb_hs_moderators`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL DEFAULT 0,
  `moderator_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `can_add_listings` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `can_approve_listings` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `can_edit_listings` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `can_delete_listings` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `can_add_moderators` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `access_level` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsm1`(`moderator_id`) USING BTREE,
  INDEX `hsm2`(`category_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_openhours
-- ----------------------------
CREATE TABLE `iweb_hs_openhours`  (
  `ohid` int NOT NULL AUTO_INCREMENT,
  `open_hours_json` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  PRIMARY KEY (`ohid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_optin
-- ----------------------------
CREATE TABLE `iweb_hs_optin`  (
  `category_id` int NOT NULL DEFAULT 0,
  `last_sent_date` int NULL DEFAULT NULL,
  `send_flag` int NOT NULL DEFAULT 0,
  `additions` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`category_id`) USING BTREE,
  INDEX `sf1`(`send_flag`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_ratings
-- ----------------------------
CREATE TABLE `iweb_hs_ratings`  (
  `ratingid` int NOT NULL AUTO_INCREMENT,
  `uidfk` int NOT NULL,
  `listingidfk` bigint NOT NULL,
  `score` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `sitelink_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`ratingid`) USING BTREE,
  UNIQUE INDEX `ratingid`(`ratingid`) USING BTREE,
  INDEX `uidfk`(`uidfk`, `listingidfk`, `score`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_related
-- ----------------------------
CREATE TABLE `iweb_hs_related`  (
  `category_id` int NOT NULL DEFAULT 0,
  `related_id` int NOT NULL DEFAULT 0,
  PRIMARY KEY (`category_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_reviews
-- ----------------------------
CREATE TABLE `iweb_hs_reviews`  (
  `review_id` bigint NOT NULL AUTO_INCREMENT,
  `listingid` bigint NOT NULL,
  `uidfk` int NOT NULL,
  `review_text` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `rating_id` int NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'pending=0, published=1, unpublished=2',
  `sitelink_id` int NULL DEFAULT NULL,
  `acctidkey` int NULL DEFAULT NULL,
  PRIMARY KEY (`review_id`) USING BTREE,
  INDEX `uidfk`(`uidfk`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 31 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_reviews_20200627
-- ----------------------------
CREATE TABLE `iweb_hs_reviews_20200627`  (
  `review_id` bigint NOT NULL AUTO_INCREMENT,
  `listingid` bigint NOT NULL,
  `uidfk` int NOT NULL,
  `review_text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`review_id`) USING BTREE,
  INDEX `uidfk`(`uidfk`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_reviews_comments
-- ----------------------------
CREATE TABLE `iweb_hs_reviews_comments`  (
  `commentid` int NOT NULL AUTO_INCREMENT,
  `reviewid_fk` int NOT NULL,
  `comments` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `user_id` int NULL DEFAULT NULL,
  `activeacctid` int NULL DEFAULT NULL,
  `siterole_id` int NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`commentid`, `reviewid_fk`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_subscribers
-- ----------------------------
CREATE TABLE `iweb_hs_subscribers`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `category_id` int NOT NULL DEFAULT 0,
  `subscriber_email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sf1`(`category_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_validate
-- ----------------------------
CREATE TABLE `iweb_hs_validate`  (
  `id` bigint NOT NULL DEFAULT 0,
  `modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `modified_date`(`modified_date`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci COMMENT = 'Last Link with URL Validation' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hs_votes
-- ----------------------------
CREATE TABLE `iweb_hs_votes`  (
  `voteid` int NOT NULL AUTO_INCREMENT,
  `vote_value` tinyint(1) NOT NULL COMMENT 'NULL no vote, 0 = thumbs down, 1 = thumbs up, ',
  `linkid` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'id from iweb_hyperseek_links table',
  `uid_fk` int NOT NULL COMMENT 'user id from user\'s table',
  `sitelink_id` int NULL DEFAULT NULL,
  `acctidkey` int NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`voteid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_html_replacements
-- ----------------------------
CREATE TABLE `iweb_html_replacements`  (
  `source_tag` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `dest_tag` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`source_tag`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_backfill_table
-- ----------------------------
CREATE TABLE `iweb_hyperseek_backfill_table`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `categoryName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categoryName',
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` int NOT NULL DEFAULT 0,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `emails` varchar(999) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'contactDetails->emails',
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `website` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'website',
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `searchString` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `subTitle` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `openingHours` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL COMMENT 'openingHours',
  `about` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `neighborhood` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `postalCode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'postalCode',
  `countryCode` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'countryCode',
  `latitude` double NULL DEFAULT NULL COMMENT 'location->lat',
  `longitude` double NULL DEFAULT NULL COMMENT 'location->long',
  `plusCode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phoneUnformatted` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `menu` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `totalScore` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `temporarilyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `permanentlyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `placeId` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `primarycategory` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `categories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `claimThisBusiness` tinyint NOT NULL DEFAULT 0 COMMENT 'claimThisBusiness',
  `searchPageUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `searchPageLoadedUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `isAdvertisement` tinyint(1) NULL DEFAULT 0,
  `reviewsCount` int NULL DEFAULT NULL,
  `reviewsDistribution` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `imagesCount` int NULL DEFAULT NULL,
  `imageCategories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `scrapedAt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `peopleAlsoSearch` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `additionalInfo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `contactDetails` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX1`(`cid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5580 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_backfill_table_duplicate
-- ----------------------------
CREATE TABLE `iweb_hyperseek_backfill_table_duplicate`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `categoryName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categoryName',
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` int NOT NULL DEFAULT 0,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `emails` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'contactDetails->emails',
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `website` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'website',
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `searchString` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `subTitle` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `openingHours` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL COMMENT 'openingHours',
  `about` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `neighborhood` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `postalCode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'postalCode',
  `countryCode` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'countryCode',
  `latitude` double NULL DEFAULT NULL COMMENT 'location->lat',
  `longitude` double NULL DEFAULT NULL COMMENT 'location->long',
  `plusCode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phoneUnformatted` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `menu` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `totalScore` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `temporarilyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `permanentlyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `placeId` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `primarycategory` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `categories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `claimThisBusiness` tinyint NOT NULL DEFAULT 0 COMMENT 'claimThisBusiness',
  `searchPageUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `searchPageLoadedUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `isAdvertisement` tinyint(1) NULL DEFAULT 0,
  `reviewsCount` int NULL DEFAULT NULL,
  `reviewsDistribution` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `imagesCount` int NULL DEFAULT NULL,
  `imageCategories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `scrapedAt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `peopleAlsoSearch` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `additionalInfo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `contactDetails` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `duplicateid` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1390 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_backfill_table_kualng
-- ----------------------------
CREATE TABLE `iweb_hyperseek_backfill_table_kualng`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `categoryName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categoryName',
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` int NOT NULL DEFAULT 0,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `emails` varchar(999) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'contactDetails->emails',
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `website` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'website',
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `searchString` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `subTitle` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `openingHours` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL COMMENT 'openingHours',
  `about` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `neighborhood` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `postalCode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'postalCode',
  `countryCode` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'countryCode',
  `latitude` double NULL DEFAULT NULL COMMENT 'location->lat',
  `longitude` double NULL DEFAULT NULL COMMENT 'location->long',
  `plusCode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phoneUnformatted` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `menu` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `totalScore` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `temporarilyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `permanentlyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `placeId` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `primarycategory` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `categories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `claimThisBusiness` tinyint NOT NULL DEFAULT 0 COMMENT 'claimThisBusiness',
  `searchPageUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `searchPageLoadedUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `isAdvertisement` tinyint(1) NULL DEFAULT 0,
  `reviewsCount` int NULL DEFAULT NULL,
  `reviewsDistribution` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `imagesCount` int NULL DEFAULT NULL,
  `imageCategories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `scrapedAt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `peopleAlsoSearch` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `additionalInfo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `contactDetails` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX1`(`cid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 170 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_backfill_table_xx
-- ----------------------------
CREATE TABLE `iweb_hyperseek_backfill_table_xx`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `cid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `categoryName` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categoryName',
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` int NOT NULL DEFAULT 0,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `emails` varchar(999) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'contactDetails->emails',
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `website` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'website',
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `searchString` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `subTitle` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `openingHours` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL COMMENT 'openingHours',
  `about` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `neighborhood` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `postalCode` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'postalCode',
  `countryCode` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'countryCode',
  `latitude` double NULL DEFAULT NULL COMMENT 'location->lat',
  `longitude` double NULL DEFAULT NULL COMMENT 'location->long',
  `plusCode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phoneUnformatted` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `menu` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `totalScore` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `temporarilyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `permanentlyClosed` enum('true','false') CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT 'false',
  `placeId` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `primarycategory` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `categories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'categories',
  `claimThisBusiness` tinyint NOT NULL DEFAULT 0 COMMENT 'claimThisBusiness',
  `searchPageUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `searchPageLoadedUrl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `isAdvertisement` tinyint(1) NULL DEFAULT 0,
  `reviewsCount` int NULL DEFAULT NULL,
  `reviewsDistribution` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `imagesCount` int NULL DEFAULT NULL,
  `imageCategories` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `scrapedAt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `peopleAlsoSearch` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `additionalInfo` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `contactDetails` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX1`(`cid`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4070 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_cats
-- ----------------------------
CREATE TABLE `iweb_hyperseek_cats`  (
  `id` bigint NOT NULL DEFAULT 0,
  `category` int NOT NULL DEFAULT 0,
  `bid_price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `proxy_max` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `last_modified` bigint NOT NULL DEFAULT 0,
  `last_modify_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `create_date` bigint NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`, `category`) USING BTREE,
  INDEX `hsc_mod`(`last_modified`) USING BTREE,
  INDEX `hsc_c`(`create_date`) USING BTREE,
  INDEX `hsc_search`(`category`) USING BTREE,
  INDEX `hsc_id`(`id`, `category`, `bid_price`) USING BTREE,
  CONSTRAINT `iweb_hyperseek_cats_ibfk_1` FOREIGN KEY (`category`) REFERENCES `iweb_hs_categories` (`category_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_draft_listing
-- ----------------------------
CREATE TABLE `iweb_hyperseek_draft_listing`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `listingid` int NULL DEFAULT NULL,
  `submission_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'NEW' COMMENT 'NEW, UPDATE, EDITING, LIVE, DECLINED',
  `update_count` int NOT NULL,
  `complete_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'User ID who submitted the listing',
  `instance_idfk` int NOT NULL DEFAULT 10008,
  `category` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `contact_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `contact_phone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `listing_title` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `company_website` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `company_name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `country` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `company_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `company_phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `admin_comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `full_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'full address',
  `order_id` int NULL DEFAULT NULL COMMENT 'from payment_listing.id',
  `sitelinkid_fk` int NULL DEFAULT NULL COMMENT 'websiteid',
  `siteid_fk` int NULL DEFAULT NULL COMMENT 'config id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_email`(`contact_phone`) USING BTREE,
  INDEX `hsl_url`(`company_website`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_forbid
-- ----------------------------
CREATE TABLE `iweb_hyperseek_forbid`  (
  `id` int NOT NULL,
  `word` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`, `word`) USING BTREE,
  INDEX `hsl_forbid`(`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci COMMENT = 'Forbidden Keywords for a Listing' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_keys
-- ----------------------------
CREATE TABLE `iweb_hyperseek_keys`  (
  `id` bigint NOT NULL DEFAULT 0,
  `keyword` varchar(125) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `metaphone` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `lexical_key` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `bid_price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `proxy_max` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `last_modified` bigint NOT NULL DEFAULT 0,
  `last_modify_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `create_date` bigint NOT NULL DEFAULT 0,
  `zone` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  INDEX `hsk_search`(`keyword`) USING BTREE,
  INDEX `hsk_msearch`(`metaphone`) USING BTREE,
  INDEX `hsk_lex`(`lexical_key`) USING BTREE,
  INDEX `hsk_mod`(`last_modified`) USING BTREE,
  INDEX `hsk_c`(`create_date`) USING BTREE,
  INDEX `hsk_id`(`id`, `keyword`, `bid_price`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_links
-- ----------------------------
CREATE TABLE `iweb_hyperseek_links`  (
  `id` bigint NOT NULL DEFAULT 0,
  `acct_key_fk` int NOT NULL,
  `instance_idfk` int NOT NULL,
  `category` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL COMMENT 'finalcategory',
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` decimal(15, 5) NOT NULL DEFAULT 0.00000,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `title` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `metadescription` varchar(180) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `desc_image` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title_tag` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_icon` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'Thumbnail',
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `open_hours` int NULL DEFAULT 0,
  `about` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `address` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `country` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `latitude` double NULL DEFAULT NULL,
  `longitude` double NULL DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `fax` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `startdate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `enddate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(9, 2) NOT NULL DEFAULT 0.00,
  `account` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `xfactor` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `hits` int NOT NULL DEFAULT 0,
  `phone_hits` int NOT NULL DEFAULT 0,
  `qr_hits` int NOT NULL DEFAULT 0,
  `email_hits` int NOT NULL DEFAULT 0,
  `top_votes` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rate_votes` int NOT NULL DEFAULT 0,
  `rate_score` int NOT NULL DEFAULT 0,
  `av_links` int NOT NULL DEFAULT 0,
  `last_status` int NULL DEFAULT NULL COMMENT 'system field to detect url status',
  `is_adult` int NOT NULL DEFAULT 0,
  `enable_ratings` int NOT NULL DEFAULT 0,
  `enable_streetview` int NOT NULL DEFAULT 0,
  `enable_map` int NOT NULL DEFAULT 0,
  `start_date` date NULL DEFAULT NULL,
  `end_date` date NULL DEFAULT NULL,
  `enable_hours` int NOT NULL DEFAULT 0,
  `enable_comments` int NOT NULL DEFAULT 0,
  `enable_votes` int NOT NULL DEFAULT 0,
  `enable_reviews` int NOT NULL DEFAULT 0,
  `enable_video` tinyint(1) NULL DEFAULT 1,
  `videoid` int NOT NULL,
  `field1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'multimedia',
  `field2` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'large_icon',
  `field3` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'Banner',
  `field4` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field6` int NULL DEFAULT NULL COMMENT 'orderid',
  `field7` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'identifier',
  `field8` int NULL DEFAULT NULL COMMENT 'id from searchmercial.video.id',
  `field9` int NULL DEFAULT NULL,
  `field10` varchar(4096) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `ibeacon_radius` int NOT NULL COMMENT 'circle radius of map',
  `radius_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'radius type if meters or miles',
  `tsadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `verified` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 = verified 0 = Not Verified',
  `default_cfa` tinyint NULL DEFAULT NULL COMMENT '0 = URL, 1 = extra_url, 2 = email, 3 = phone',
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `full_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'full_address',
  `order_id` int NULL DEFAULT NULL COMMENT 'from payment_listing.id',
  `video_type` int NULL DEFAULT NULL,
  `cat_type` int NULL DEFAULT NULL COMMENT 'category type',
  `enable_rfq` tinyint NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 = Inactive     \r1 = Active    \r2 = Demo',
  `sitelinkid_fk` int NOT NULL,
  `siteid_fk` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `orderid`(`field6`) USING BTREE,
  INDEX `hsl_email`(`email`) USING BTREE,
  INDEX `hsl_url`(`url`) USING BTREE,
  INDEX `hsl_pos1`(`rank`) USING BTREE,
  INDEX `membercodeid`(`field8`) USING BTREE,
  INDEX `category`(`category`) USING BTREE,
  INDEX `hsl_acct1`(`account`) USING BTREE,
  INDEX `identifier`(`field7`, `account`) USING BTREE,
  INDEX `duration_link`(`startdate`, `enddate`, `id`) USING BTREE,
  INDEX `title`(`title`, `id`, `account`) USING BTREE,
  INDEX `field1`(`field1`) USING BTREE,
  FULLTEXT INDEX `hs_ft`(`title`, `description`, `keywords`, `city`, `name`, `state`, `zip`)
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_live
-- ----------------------------
CREATE TABLE `iweb_hyperseek_live`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `distributionid` int NULL DEFAULT NULL,
  `orderid` int NOT NULL DEFAULT 0,
  `identifier` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `broadcastid` int NULL DEFAULT NULL,
  `startdate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `enddate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `ordertype` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `sysnodeid` int NULL DEFAULT NULL,
  `membercodeid` int NULL DEFAULT NULL,
  `categoryid` int NULL DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `hits` int NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `membercodeid`(`membercodeid`) USING BTREE,
  INDEX `sysnodeid`(`sysnodeid`) USING BTREE,
  INDEX `categoryid`(`categoryid`) USING BTREE,
  INDEX `orderid`(`orderid`) USING BTREE,
  INDEX `startdate`(`startdate`) USING BTREE,
  INDEX `enddate`(`enddate`) USING BTREE,
  INDEX `distributionid`(`distributionid`) USING BTREE,
  INDEX `broadcastid`(`broadcastid`) USING BTREE,
  CONSTRAINT `iweb_hyperseek_live_ibfk_1` FOREIGN KEY (`membercodeid`) REFERENCES `membercode` (`membercodeid`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `iweb_hyperseek_live_ibfk_2` FOREIGN KEY (`sysnodeid`) REFERENCES `network_nodes` (`SystemNode`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `iweb_hyperseek_live_ibfk_3` FOREIGN KEY (`categoryid`) REFERENCES `iweb_hs_categories` (`category_id`) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT `iweb_hyperseek_live_ibfk_4` FOREIGN KEY (`orderid`) REFERENCES `mediaorders` (`orderid`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_live_log
-- ----------------------------
CREATE TABLE `iweb_hyperseek_live_log`  (
  `hit_id` int NOT NULL AUTO_INCREMENT,
  `link_id` int NULL DEFAULT NULL,
  `orderid` int NULL DEFAULT NULL,
  `channel` int NULL DEFAULT NULL,
  `commission` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `gross_price` decimal(5, 3) NOT NULL DEFAULT 0.000,
  `price` decimal(5, 3) NOT NULL DEFAULT 0.000,
  `hit_date` date NULL DEFAULT NULL,
  `hit_time` datetime NULL DEFAULT NULL,
  `affiliate` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `account` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `roi_code` int NOT NULL DEFAULT 0,
  `roi_sale` int NOT NULL DEFAULT 0,
  `logdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `channel_type` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `criteria` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `action` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `ip_number` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `user_agent` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `referer` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`hit_id`) USING BTREE,
  INDEX `orderid`(`orderid`) USING BTREE,
  INDEX `criteria`(`criteria`) USING BTREE,
  INDEX `channel`(`channel`) USING BTREE,
  INDEX `account`(`account`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MRG_MYISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_live_log_201203
-- ----------------------------
CREATE TABLE `iweb_hyperseek_live_log_201203`  (
  `hit_id` int NOT NULL AUTO_INCREMENT,
  `link_id` int NULL DEFAULT NULL,
  `orderid` int NULL DEFAULT NULL,
  `channel` int NULL DEFAULT NULL,
  `commission` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `gross_price` decimal(5, 3) NOT NULL DEFAULT 0.000,
  `price` decimal(5, 3) NOT NULL DEFAULT 0.000,
  `hit_date` date NULL DEFAULT NULL,
  `hit_time` datetime NULL DEFAULT NULL,
  `affiliate` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `account` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `roi_code` int NOT NULL DEFAULT 0,
  `roi_sale` int NOT NULL DEFAULT 0,
  `logdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `channel_type` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `criteria` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `action` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `ip_number` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `user_agent` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `referer` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`hit_id`) USING BTREE,
  INDEX `orderid`(`orderid`) USING BTREE,
  INDEX `criteria`(`criteria`) USING BTREE,
  INDEX `channel`(`channel`) USING BTREE,
  INDEX `account`(`account`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 136256230 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_live_log_201204
-- ----------------------------
CREATE TABLE `iweb_hyperseek_live_log_201204`  (
  `hit_id` int NOT NULL AUTO_INCREMENT,
  `link_id` int NULL DEFAULT NULL,
  `orderid` int NULL DEFAULT NULL,
  `channel` int NULL DEFAULT NULL,
  `commission` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `gross_price` decimal(5, 3) NOT NULL DEFAULT 0.000,
  `price` decimal(5, 3) NOT NULL DEFAULT 0.000,
  `hit_date` date NULL DEFAULT NULL,
  `hit_time` datetime NULL DEFAULT NULL,
  `affiliate` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `account` varchar(80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `roi_code` int NOT NULL DEFAULT 0,
  `roi_sale` int NOT NULL DEFAULT 0,
  `logdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `channel_type` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `criteria` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `action` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `ip_number` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `user_agent` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `referer` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`hit_id`) USING BTREE,
  INDEX `orderid`(`orderid`) USING BTREE,
  INDEX `criteria`(`criteria`) USING BTREE,
  INDEX `channel`(`channel`) USING BTREE,
  INDEX `account`(`account`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 136394413 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_live_log_criteria
-- ----------------------------
CREATE TABLE `iweb_hyperseek_live_log_criteria`  (
  `crti_id` int NOT NULL AUTO_INCREMENT,
  `criteria` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `color` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `target` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`crti_id`) USING BTREE,
  UNIQUE INDEX `criteria`(`criteria`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci COMMENT = 'Criteria for log reports' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201402
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201402`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201403
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201403`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201409
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201409`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201411
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201411`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201503
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201503`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201504
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201504`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201505
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201505`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201508
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201508`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201509
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201509`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201510
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201510`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201511
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201511`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201512
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201512`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201601
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201601`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201602
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201602`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201603
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201603`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201604
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201604`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201605
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201605`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201705
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201705`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201706
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201706`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201707
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201707`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201708
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201708`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201709
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201709`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201710
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201710`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201711
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201711`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201712
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201712`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201801
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201801`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201802
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201802`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201803
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201803`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201804
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201804`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201805
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201805`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201806
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201806`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201807
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201807`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201808
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201808`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201809
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201809`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201810
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201810`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201811
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201811`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201812
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201812`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201901
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201901`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201902
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201902`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201903
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201903`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201904
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201904`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201905
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201905`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201906
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201906`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201907
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201907`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201908
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201908`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201909
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201909`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_201910
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_201910`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202006
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202006`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202007
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202007`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202008
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202008`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202009
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202009`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202010
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202010`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202105
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202105`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202106
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202106`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202107
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202107`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202108
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202108`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202109
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202109`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202110
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202110`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202111
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202111`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202112
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202112`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202201
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202201`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202202
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202202`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202203
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202203`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202204
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202204`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202205
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202205`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202206
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202206`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202207
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202207`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202208
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202208`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202209
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202209`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202210
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202210`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202211
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202211`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202212
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202212`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202301
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202301`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202302
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202302`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202303
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202303`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202304
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202304`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202305
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202305`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202306
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202306`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202307
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202307`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202308
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202308`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202309
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202309`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202310
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202310`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202311
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202311`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202312
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202312`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202401
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202401`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202402
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202402`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202403
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202403`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202404
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202404`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202405
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202405`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202406
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202406`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202407
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202407`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202408
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202408`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202409
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202409`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202410
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202410`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202411
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202411`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202412
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202412`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_202501
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_202501`  (
  `logdate` int NOT NULL DEFAULT 0,
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `ip_number` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `user_agent` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `referer` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `affiliate` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num_results` int NULL DEFAULT NULL,
  INDEX `hslog1`(`logdate`) USING BTREE,
  INDEX `hslog2`(`search_type`) USING BTREE,
  INDEX `hslog3`(`criteria`) USING BTREE,
  INDEX `hslog4`(`ip_number`) USING BTREE,
  INDEX `hslog5`(`user_agent`) USING BTREE,
  INDEX `hslog6`(`referer`) USING BTREE,
  INDEX `affiliate`(`affiliate`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_log_summary
-- ----------------------------
CREATE TABLE `iweb_hyperseek_log_summary`  (
  `search_type` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `criteria` char(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `num_searches` int NULL DEFAULT NULL,
  `click_count` int NULL DEFAULT 0,
  `click_amount_gross` decimal(9, 2) NULL DEFAULT 0.00,
  `click_amount_net` decimal(9, 2) NULL DEFAULT 0.00,
  INDEX `hssumlog1`(`criteria`) USING BTREE,
  INDEX `hssumlog2`(`search_type`, `criteria`) USING BTREE,
  INDEX `hssumlog3`(`num_searches`, `click_count`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_results
-- ----------------------------
CREATE TABLE `iweb_hyperseek_results`  (
  `cookie_id` int NOT NULL DEFAULT 0,
  `id_set` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  PRIMARY KEY (`cookie_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_submitted_feeds
-- ----------------------------
CREATE TABLE `iweb_hyperseek_submitted_feeds`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `feedurl` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `email` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `parsing` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Indicates the feed is currently being parses',
  `approved` tinyint(1) NOT NULL DEFAULT 0,
  `submitted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `lastread` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `feedurl`(`feedurl`(255)) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_temp
-- ----------------------------
CREATE TABLE `iweb_hyperseek_temp`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `submission_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'NEW' COMMENT 'NEW, UPDATE, EDITING, LIVE, DECLINED',
  `update_count` int NOT NULL,
  `submitted_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'User ID who submitted the listing',
  `acct_key_fk` int NOT NULL COMMENT 'Account number from WWBN',
  `instance_idfk` int NOT NULL DEFAULT 10008,
  `category` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` decimal(15, 5) NOT NULL DEFAULT 0.00000,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `desc_image` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title_tag` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_icon` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `open_hours` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `about` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `country` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `longitude` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `latitude` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `fax` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `startdate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `enddate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(7, 2) NULL DEFAULT NULL,
  `account` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'Domain name from iweb_accounts table',
  `xfactor` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `hits` int NULL DEFAULT NULL,
  `top_votes` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rate_votes` int NULL DEFAULT NULL,
  `rate_score` int NULL DEFAULT NULL,
  `av_links` int NULL DEFAULT NULL,
  `last_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_adult` int NULL DEFAULT NULL,
  `enable_ratings` tinyint NOT NULL DEFAULT 1,
  `enable_comments` tinyint NOT NULL DEFAULT 1,
  `enable_streetview` tinyint NOT NULL DEFAULT 1,
  `enable_map` tinyint NOT NULL DEFAULT 1,
  `start_date` date NULL DEFAULT NULL,
  `end_date` date NULL DEFAULT NULL,
  `enable_hours` tinyint NOT NULL DEFAULT 1,
  `enable_votes` tinyint NOT NULL DEFAULT 1,
  `enable_reviews` tinyint NOT NULL DEFAULT 1,
  `enable_video` tinyint(1) NULL DEFAULT 1,
  `videoid` int NOT NULL,
  `field1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field2` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field3` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field4` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field6` int NULL DEFAULT NULL,
  `field7` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field8` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field9` decimal(7, 2) NULL DEFAULT NULL,
  `field10` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `ibeacon_radius` int NOT NULL,
  `radius_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `tsadded` datetime NOT NULL,
  `declid_fk` tinyint NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `default_cfa` tinyint NULL DEFAULT NULL COMMENT '0 = URL, 1 = extra_url, 2 = email, 3 = phone',
  `full_address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'full address',
  `order_id` int NULL DEFAULT NULL COMMENT 'from payment_listing.id',
  `video_type` int NULL DEFAULT NULL,
  `cat_type` int NULL DEFAULT NULL COMMENT 'category type',
  `enable_rfq` tinyint NOT NULL DEFAULT 1,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sitelinkid_fk` int NOT NULL,
  `siteid_fk` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `paymentlisting`(`order_id`) USING BTREE,
  INDEX `hsl_email`(`email`) USING BTREE,
  INDEX `hsl_url`(`url`) USING BTREE,
  INDEX `hsl_acct1`(`account`) USING BTREE,
  INDEX `hsl_pos1`(`rank`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_temp_06092020
-- ----------------------------
CREATE TABLE `iweb_hyperseek_temp_06092020`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `submission_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'NEW' COMMENT 'NEW, UPDATE, EDITING, LIVE, DECLINED',
  `update_count` int NOT NULL,
  `submitted_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'User ID who submitted the listing',
  `acct_key_fk` int NOT NULL COMMENT 'Account number from WWBN',
  `instance_idfk` int NOT NULL DEFAULT 10008,
  `category` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` decimal(15, 5) NOT NULL DEFAULT 0.00000,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `desc_image` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title_tag` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_icon` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `open_hours` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `about` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `country` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `longitude` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `latitude` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `fax` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `startdate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `enddate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(7, 2) NULL DEFAULT NULL,
  `account` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL COMMENT 'Domain name from iweb_accounts table',
  `xfactor` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `hits` int NULL DEFAULT NULL,
  `top_votes` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rate_votes` int NULL DEFAULT NULL,
  `rate_score` int NULL DEFAULT NULL,
  `av_links` int NULL DEFAULT NULL,
  `last_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_adult` int NULL DEFAULT NULL,
  `enable_ratings` tinyint NOT NULL DEFAULT 0,
  `enable_comments` tinyint NOT NULL DEFAULT 0,
  `enable_streetview` tinyint NOT NULL DEFAULT 0,
  `enable_map` tinyint NOT NULL DEFAULT 0,
  `start_date` date NULL DEFAULT NULL,
  `end_date` date NULL DEFAULT NULL,
  `enable_hours` tinyint NOT NULL DEFAULT 0,
  `enable_votes` tinyint NOT NULL DEFAULT 0,
  `enable_reviews` tinyint NOT NULL DEFAULT 0,
  `videoid` int NOT NULL,
  `field1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field2` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field3` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field4` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field6` int NULL DEFAULT NULL,
  `field7` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field8` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field9` decimal(7, 2) NULL DEFAULT NULL,
  `field10` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `ibeacon_radius` int NOT NULL,
  `radius_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `tsadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `admin_comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_email`(`email`) USING BTREE,
  INDEX `hsl_url`(`url`) USING BTREE,
  INDEX `hsl_acct1`(`account`) USING BTREE,
  INDEX `hsl_pos1`(`rank`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_temp_backup
-- ----------------------------
CREATE TABLE `iweb_hyperseek_temp_backup`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `submission_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'NEW',
  `submitted_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `category` int NULL DEFAULT NULL,
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` decimal(15, 5) NOT NULL DEFAULT 0.00000,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `desc_image` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title_tag` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_icon` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `payment_methods` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `open_hours` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `about` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `country` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `longitude` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `latitude` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `fax` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `startdate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `enddate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(7, 2) NULL DEFAULT NULL,
  `account` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `xfactor` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `hits` int NULL DEFAULT NULL,
  `top_votes` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rate_votes` int NULL DEFAULT NULL,
  `rate_score` int NULL DEFAULT NULL,
  `av_links` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `last_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_adult` int NULL DEFAULT NULL,
  `field1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field2` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field3` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field4` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field6` int NULL DEFAULT NULL,
  `field7` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field8` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field9` decimal(7, 2) NULL DEFAULT NULL,
  `field10` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_email`(`email`) USING BTREE,
  INDEX `hsl_url`(`url`) USING BTREE,
  INDEX `hsl_acct1`(`account`) USING BTREE,
  INDEX `hsl_pos1`(`rank`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for iweb_hyperseek_temp_copy
-- ----------------------------
CREATE TABLE `iweb_hyperseek_temp_copy`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `submission_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'NEW',
  `submitted_by` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `category` int NULL DEFAULT NULL,
  `extra_link` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rank` decimal(15, 5) NOT NULL DEFAULT 0.00000,
  `qualifier` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `url` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `keywords` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL,
  `desc_image` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title_tag` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `site_icon` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(75) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `state` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `zip` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `country` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `fax` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `startdate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `enddate` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `price` decimal(7, 2) NULL DEFAULT NULL,
  `account` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `xfactor` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `hits` int NULL DEFAULT NULL,
  `top_votes` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `rate_votes` int NULL DEFAULT NULL,
  `rate_score` int NULL DEFAULT NULL,
  `av_links` int NULL DEFAULT NULL,
  `last_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `is_adult` int NULL DEFAULT NULL,
  `field1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field2` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field3` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field4` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field5` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field6` int NULL DEFAULT NULL,
  `field7` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field8` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `field9` decimal(7, 2) NULL DEFAULT NULL,
  `field10` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `hsl_email`(`email`) USING BTREE,
  INDEX `hsl_url`(`url`) USING BTREE,
  INDEX `hsl_acct1`(`account`) USING BTREE,
  INDEX `hsl_pos1`(`rank`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
