-- MySQL dump 10.14  Distrib 5.5.68-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: supercheats_reports
-- ------------------------------------------------------
-- Server version	5.5.68-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `adblock_check`
--

DROP TABLE IF EXISTS `adblock_check`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adblock_check` (
  `t` varchar(12) NOT NULL,
  `block` tinyint(1) NOT NULL,
  `ipaddress` varchar(24) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `adblock_check2`
--

DROP TABLE IF EXISTS `adblock_check2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adblock_check2` (
  `t` varchar(12) NOT NULL,
  `block` tinyint(1) NOT NULL,
  `ipaddress` varchar(24) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `admin_ext_sitemaps_import`
--

DROP TABLE IF EXISTS `admin_ext_sitemaps_import`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_ext_sitemaps_import` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tstamp` varchar(12) DEFAULT NULL,
  `url` varchar(128) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `lastmod` varchar(45) DEFAULT NULL,
  `name_string` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=276047 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `admin_roblox_games_data`
--

DROP TABLE IF EXISTS `admin_roblox_games_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_roblox_games_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gamename` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `lchyphname` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL,
  `rolimons_id` int(11) DEFAULT NULL,
  `rolimons_players` int(11) DEFAULT NULL,
  `datestamp` varchar(12) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `console_games`
--

DROP TABLE IF EXISTS `console_games`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `console_games` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `platform` varchar(12) CHARACTER SET latin1 DEFAULT NULL,
  `name` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `lchyphname` varchar(128) CHARACTER SET latin1 DEFAULT NULL,
  `rating` decimal(2,1) DEFAULT NULL,
  `gamers` int(11) DEFAULT NULL,
  `gamers_change` int(11) DEFAULT NULL,
  `gamers_change_perc` decimal(4,1) DEFAULT NULL,
  `dateadded` varchar(12) CHARACTER SET latin1 DEFAULT NULL,
  `dateupdated` varchar(12) DEFAULT NULL,
  `ignoregame` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27815 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `console_games_history`
--

DROP TABLE IF EXISTS `console_games_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `console_games_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gameid` int(11) DEFAULT NULL,
  `gamers` int(11) DEFAULT NULL,
  `rating` decimal(2,1) DEFAULT NULL,
  `dateimported` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=663043 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `daily_analytics`
--

DROP TABLE IF EXISTS `daily_analytics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `daily_analytics` (
  `item_id` int(11) NOT NULL,
  `day` varchar(12) NOT NULL,
  `total` int(8) NOT NULL,
  `index_hits` int(11) DEFAULT NULL,
  `guide_hits` int(11) DEFAULT NULL,
  `cheats_hits` int(11) DEFAULT NULL,
  `questions_hits` int(11) DEFAULT NULL,
  KEY `day` (`day`),
  KEY `item_id` (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ga_count_urls`
--

DROP TABLE IF EXISTS `ga_count_urls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ga_count_urls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `gameid` int(11) DEFAULT NULL,
  `subytype` varchar(24) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  `status` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=264609 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ga_low_count_urls`
--

DROP TABLE IF EXISTS `ga_low_count_urls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ga_low_count_urls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `gameid` int(11) DEFAULT NULL,
  `subtype` varchar(16) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  `status` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3700 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `hitcounter`
--

DROP TABLE IF EXISTS `hitcounter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hitcounter` (
  `time_stamp` varchar(12) NOT NULL DEFAULT '',
  `gameid` int(11) NOT NULL DEFAULT '0',
  `item_id` int(11) NOT NULL,
  `platform` varchar(16) NOT NULL DEFAULT '',
  `gamename` varchar(128) NOT NULL DEFAULT '',
  `subtype` varchar(20) NOT NULL DEFAULT '',
  `referer` varchar(128) NOT NULL DEFAULT '',
  `ipaddress` varchar(16) NOT NULL DEFAULT '',
  KEY `platform` (`platform`),
  KEY `subtype` (`subtype`),
  KEY `timestamp` (`time_stamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ipblockcheck`
--

DROP TABLE IF EXISTS `ipblockcheck`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipblockcheck` (
  `t` varchar(12) NOT NULL,
  `ip` varchar(24) NOT NULL,
  `url` varchar(128) NOT NULL,
  KEY `t` (`t`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ipblocks`
--

DROP TABLE IF EXISTS `ipblocks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipblocks` (
  `ip` varchar(24) NOT NULL,
  `blocktime` varchar(12) NOT NULL,
  `expiretime` varchar(12) NOT NULL,
  `reason` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ipcountry`
--

DROP TABLE IF EXISTS `ipcountry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipcountry` (
  `ipFROM` decimal(39,0) NOT NULL,
  `ipTO` decimal(39,0) NOT NULL,
  `countrySHORT` char(2) NOT NULL,
  `countryLONG` varchar(50) NOT NULL,
  PRIMARY KEY (`ipFROM`,`ipTO`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `notes_perday`
--

DROP TABLE IF EXISTS `notes_perday`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notes_perday` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(12) NOT NULL,
  `note` mediumtext NOT NULL,
  `date_added` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `prizedraw2016_2`
--

DROP TABLE IF EXISTS `prizedraw2016_2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prizedraw2016_2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(50) NOT NULL,
  `name` varchar(64) NOT NULL,
  `email` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2297 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `social_feed_addlog`
--

DROP TABLE IF EXISTS `social_feed_addlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `social_feed_addlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `added_date` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=213 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `survey1`
--

DROP TABLE IF EXISTS `survey1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(24) NOT NULL,
  `platforms` varchar(255) NOT NULL,
  `purch_console` varchar(12) NOT NULL,
  `purch_app` varchar(12) NOT NULL,
  `genre` varchar(255) NOT NULL,
  `hours` varchar(12) NOT NULL,
  `gender` varchar(12) NOT NULL,
  `age` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2911 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `survey2`
--

DROP TABLE IF EXISTS `survey2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(24) NOT NULL,
  `platforms` varchar(255) NOT NULL,
  `purch_console` varchar(12) NOT NULL,
  `purch_app` varchar(12) NOT NULL,
  `genre` varchar(255) NOT NULL,
  `hours` varchar(12) NOT NULL,
  `gender` varchar(12) NOT NULL,
  `age` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5799 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `survey2016`
--

DROP TABLE IF EXISTS `survey2016`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey2016` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(24) NOT NULL,
  `mobile` tinyint(1) NOT NULL,
  `platforms` varchar(255) NOT NULL,
  `games_console` varchar(12) NOT NULL,
  `games_app_paid` varchar(12) NOT NULL,
  `games_app_free` varchar(12) NOT NULL,
  `genres` varchar(255) NOT NULL,
  `games_hours` varchar(12) NOT NULL,
  `gender` varchar(12) NOT NULL,
  `age` varchar(12) NOT NULL,
  `inapp_purchase` varchar(1) NOT NULL,
  `headset` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=43922 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `survey2016_2`
--

DROP TABLE IF EXISTS `survey2016_2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey2016_2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(50) NOT NULL,
  `mobile` tinyint(1) NOT NULL,
  `platforms` varchar(255) NOT NULL,
  `purchase_platforms` varchar(64) NOT NULL,
  `games_purchased` varchar(12) NOT NULL,
  `games_downloaded` varchar(12) NOT NULL,
  `inapp_purchase` varchar(1) NOT NULL,
  `games_hours` varchar(12) NOT NULL,
  `gender` varchar(12) NOT NULL,
  `age` varchar(12) NOT NULL,
  `marital` varchar(12) NOT NULL,
  `site_rating` varchar(12) NOT NULL,
  `site_visits` varchar(12) NOT NULL,
  `first_visit` varchar(12) NOT NULL,
  `feedback` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7025 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `survey3`
--

DROP TABLE IF EXISTS `survey3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(24) NOT NULL,
  `preference` varchar(16) NOT NULL,
  `comment` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `survey4`
--

DROP TABLE IF EXISTS `survey4`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(24) NOT NULL,
  `preference` varchar(16) NOT NULL,
  `uid` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9110 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `survey5`
--

DROP TABLE IF EXISTS `survey5`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `survey5` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdate` varchar(12) NOT NULL,
  `ipaddress` varchar(24) NOT NULL,
  `preference` varchar(16) NOT NULL,
  `uid` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3371 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ugo_adverts`
--

DROP TABLE IF EXISTS `ugo_adverts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ugo_adverts` (
  `date` varchar(12) NOT NULL,
  `ad_unit` varchar(48) NOT NULL,
  `size` varchar(12) NOT NULL,
  `unit_id` varchar(12) NOT NULL,
  `impressions` int(11) NOT NULL,
  KEY `date` (`date`),
  KEY `size` (`size`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-06-11  7:25:41
