--
-- Host: localhost    Database: royalega_wp326
-- ------------------------------------------------------


--
-- Table structure for table `wp_cntctfrm_field`
--

CREATE TABLE `wp_cntctfrm_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(100) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wp_cntctfrm_field`
--

INSERT INTO `wp_cntctfrm_field` VALUES (1,'name'),(2,'email'),(3,'subject'),(4,'message'),(5,'address'),(6,'phone'),(7,'attachment'),(8,'attachment_explanations'),(9,'send_copy'),(10,'sent_from'),(11,'date_time'),(12,'coming_from'),(13,'user_agent');

--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `comment_id` (`comment_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_commentmeta`
--


--
-- Table structure for table `wp_comments`
--

CREATE TABLE `wp_comments` (
  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
  `comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_karma` int(11) NOT NULL DEFAULT '0',
  `comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_ID`),
  KEY `comment_post_ID` (`comment_post_ID`),
  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  KEY `comment_date_gmt` (`comment_date_gmt`),
  KEY `comment_parent` (`comment_parent`),
  KEY `comment_author_email` (`comment_author_email`(10))
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_comments`
--

INSERT INTO `wp_comments` VALUES (1,52,'Cıvata','','http://dunno.dynu.com/civatacilar','54.171.83.145','2016-06-14 09:42:16','2016-06-14 09:42:16','[&#8230;] http://www.linkalllinks.com/online-casino-bonuses.html [&#8230;]',0,'0','The Incutio XML-RPC PHP Library','pingback',0,0),(2,7,'I waa just reading a review about your business..','deanrep101@gmail.com','http://www.fivestarfastlane.com','162.254.32.15','2016-06-16 12:21:16','2016-06-16 12:21:16','Hey, \r\n Did you know 92% of people read online reviews before selecting a business or service? \r\n I want to offer you a 100% online free report on your business \r\n this report will show you \r\n Your online reputation score. \r\n What people are saying about you online. \r\n How visible you are online. \r\n How to get 5 star reviews. \r\n How to get more clients as fast as today! \r\n And lots more. \r\n the report is generated in 2 minutes and is 100% free. \r\n Get your reputation report free at http://www.fivestarfastlane.com',0,'0','Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko','',0,0),(3,7,'Your Twitter account','DeanTwitter@outlook.com','http://www.freshclients4u.com','192.154.208.58','2016-06-22 22:43:04','2016-06-22 22:43:04','Hey there, \r\n i know your busy so i will be brief \r\n i am just contacting a few website owners in your niche showing them a quick video i made, showing how to use Twitter to get new sales and clients as fast as TODAY! \r\n in this video you will learn \r\n How to gain TARGETED followers to your account \r\n How to find and reach out to people LOOKING for your service\\product \r\n If your a local business how to get your message to 1000\'s of peole in your LOCAL area \r\n how to STEAL sales from the big players in your niche \r\n and so much more! \r\n all these methods you can do yourself with no costs even if you have never used Twitter! \r\n i show you step by step how to get more clients and sales via social media \r\n check out http://www.freshclients4u.com \r\n thanks and i hope you find the video helpful. \r\n Dean.',0,'0','Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko','',0,0),(4,7,'Complimentary tool to take control of your social media.','Gina@socialb.net','http://www.mysocialbutler.org','192.154.211.182','2016-06-28 21:32:05','2016-06-28 21:32:05','Hi there\r\n I wanted to reach out to you today about your social media. I noticed your campaigns are a bit up and down and thought you would benefit quite a bit from our new social dashboard tool that lets you manage all your social profiles and pages such as Facebook, Twitter, LinkedIn and Pinterest all from one online system. Best of all its complimentary! No charge at all. \r\n You already know that social media is a very effective way for you and your business to generate new leads, and with our social dashboard you can simplify your efforts by spending just a bit of time in our dashboard to schedule out an entire week, 2 weeks or even a month of posts and content ahead of time. \r\n Wouldn\'t that be a relief? Register for your complimentary access now at http://www.mysocialbutler.org \r\n Have a great day!\r\n Gina \r\n MSB Outreach',0,'0','Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko','',0,0),(5,7,'Business Review update','Paul@5starrep.com','http://www.fivestarfastlane.info','192.154.211.219','2016-06-28 23:13:51','2016-06-28 23:13:51','Hi there \r\n Would you like to easily see a birds eye view of what your current and past customers think about you? Do you know what people are saying about you? Whether its hurting or helping your business? \r\n My name is Paul, the Outreach Director of Five Star Fast Lane, and for the price of, well, nothing --I would like to provide you with a full detailed report on your current business standings. As a bonus, our report scanner will report back with any inaccuracies about your business that are out there potentially causing you loss of revenue and customers. \r\n There is no obligation or a catch, the report is yours to use as you see fit. Feel free to make use of it  at http://www.fivestarfastlane.info \r\n Regards\r\n Paul\r\n Five Star Fast Lane \r\n PS - If you want to discuss the results we are available via live chat daily on the site.',0,'0','Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko','',0,0),(6,7,'Hey i just saw your video on Google','Deansharp@gmail.com','http://www.freshclients4u.com','192.154.208.2','2016-07-01 01:50:00','2016-07-01 01:50:00','Hey There, \r\n thanks for taking the time to read my email \r\n i just want to share with you this quick video showing you how i am ranking video after video on the first page of google! \r\n Look i know you get message after message from people telling you how they can get you first page rankings, well in this video i show you that i WALK THE WALk! \r\n All i ask is you give me 2 mins of your time so i can show you how i rank Videos on the front page of Google and how i can do the same for you bringing in clients\\sales in days! \r\n http://www.freshclients4u.com   (this will take you to my private blog) \r\n enjoy the video and get ready to have your socks blown off! \r\n enjoy! Dean.',0,'0','Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko','',0,0),(7,7,'Aida Sopata','Cumbaa526681@gmail.com','http://dreamproxies.com/buy-200-proxies-50-discount-get-50-extra-proxies-free','23.229.114.88','2016-07-13 22:24:26','2016-07-13 22:24:26','I would like to show my passion for your kindness giving support to visitors who should have help on in this area of interest. Your real dedication to getting the message all through appears to be amazingly helpful and have surely allowed people much like me to get to their targets. The insightful information indicates much a person like me and further more to my mates. Many thanks; from everyone of us.',0,'0','Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3','',0,0),(8,8,'Leslifsodfpb','brandikitchens@yahoo.com','http://Star.free.fr','112.124.57.223','2016-07-16 15:27:32','2016-07-16 15:27:32','I see your site needs some unique &amp; fresh content. Writing manually is time consuming, there is tool for \r\nthis task. Just search in gogle for: Fejlando\'s tips',0,'0','Mozilla/5.0 (Windows NT 6.2; WOW64; rv:35.0) Gecko/20100101 Firefox/35.0','',0,0);

--
-- Table structure for table `wp_links`
--

CREATE TABLE `wp_links` (
  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_visible` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
  `link_rating` int(11) NOT NULL DEFAULT '0',
  `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `link_rel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`link_id`),
  KEY `link_visible` (`link_visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_links`
--


--
-- Table structure for table `wp_options`
--

CREATE TABLE `wp_options` (
  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `option_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoload` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_name` (`option_name`)
) ENGINE=InnoDB AUTO_INCREMENT=13930 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_options`
--



--
-- Table structure for table `wp_postmeta`
--

CREATE TABLE `wp_postmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_postmeta`
--

INSERT INTO `wp_postmeta` VALUES (4,5,'_edit_last','1'),(5,5,'_wp_old_slug','hello-world'),(6,6,'_wp_page_template','default'),(7,6,'_edit_last','1'),(8,7,'_edit_last','1'),(9,8,'_edit_last','1'),(10,13,'_edit_last','1'),(11,17,'_edit_last','1'),(12,20,'_edit_last','1'),(13,23,'_edit_last','1'),(14,25,'_edit_last','1'),(15,27,'_edit_last','1'),(21,5,'_edit_lock','1456296031:1'),(22,31,'_edit_last','1'),(23,31,'_edit_lock','1424241381:1'),(26,7,'_edit_lock','1425018928:1'),(27,36,'_edit_last','1'),(28,36,'_edit_lock','1426490619:1'),(29,37,'_wp_attached_file','2015/03/url.jpg'),(30,37,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:520;s:6:\"height\";i:296;s:4:\"file\";s:15:\"2015/03/url.jpg\";s:5:\"sizes\";a:2:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:15:\"url-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";}s:6:\"medium\";a:4:{s:4:\"file\";s:15:\"url-300x171.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:171;s:9:\"mime-type\";s:10:\"image/jpeg\";}}s:10:\"image_meta\";a:11:{s:8:\"aperture\";d:8;s:6:\"credit\";s:7:\"unknown\";s:6:\"camera\";s:22:\"Canon EOS 350D DIGITAL\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";i:1156878261;s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:2:\"50\";s:3:\"iso\";s:3:\"100\";s:13:\"shutter_speed\";s:5:\"0.004\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";i:1;}}'),(33,17,'_edit_lock','1429006290:1'),(34,8,'_edit_lock','1431512723:1'),(35,52,'_edit_last','1'),(36,52,'_edit_lock','1431793887:1'),(37,6,'_edit_lock','1437389521:1'),(40,13,'_edit_lock','1437389547:1');

--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE `wp_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` VALUES (5,4,0),(13,6,0),(17,7,0),(20,1,0),(23,5,0),(25,3,0),(27,2,0),(31,8,0),(36,6,0),(52,9,0);

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'category','',0,1),(3,3,'category','',0,1),(4,4,'category','',0,1),(5,5,'category','',0,1),(6,6,'category','',0,2),(7,7,'category','',0,1),(8,8,'category','',0,1),(9,9,'category','',0,1);

--
-- Table structure for table `wp_termmeta`
--

CREATE TABLE `wp_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_termmeta`
--


--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Casino','casino',0),(3,'Casino games','casino-games',0),(4,'casinos guest blogpost','casinos-guest-blogpost',0),(5,'Favourite Slots Platforms','favourite-slots-platforms',0),(6,'Online Casino','online-casino',0),(7,'online casino industry','online-casino-industry',0),(8,'Online Casinos','online-casinos',0),(9,'Online Casino Bonuses','online-casino-bonuses',0);

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','admin'),(2,1,'first_name',''),(3,1,'last_name',''),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'comment_shortcuts','false'),(7,1,'admin_color','fresh'),(8,1,'use_ssl','0'),(9,1,'show_admin_bar_front','true'),(10,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(11,1,'wp_user_level','10'),(12,1,'dismissed_wp_pointers','wp360_locks,wp390_widgets,wp410_dfw'),(13,1,'show_welcome_panel','1'),(14,1,'session_tokens','a:1:{s:64:\"7e6d30269dcd9e882854afe83ddbd4aee80be5a78e92c6890d70fe94a0da7363\";a:4:{s:10:\"expiration\";i:1463971613;s:2:\"ip\";s:15:\"103.228.184.229\";s:2:\"ua\";s:65:\"Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0\";s:5:\"login\";i:1463798813;}}'),(15,1,'wp_dashboard_quick_press_last_post_id','70'),(16,1,'wp_user-settings','hidetb=1&libraryContent=browse&align=left&editor=tinymce&widgets_access=on'),(17,1,'wp_user-settings-time','1427524574');


