/home/altere25/quintelacrosse.com
Edit: /home/altere25/quintelacrosse.com/altere25_wp176.20200217-183145.sql (3940477B)
-- mysqldump-php https://github.com/ifsnop/mysqldump-php
--
-- Host: localhost Database: altere25_wp176
-- ------------------------------------------------------
-- Server version 5.5.5-10.1.36-MariaDB
-- Date: Mon, 17 Feb 2020 18:31:45 +0000
/*!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 `wpie_commentmeta`
--
DROP TABLE IF EXISTS `wpie_commentmeta`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_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=MyISAM AUTO_INCREMENT=1181 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_commentmeta`
--
LOCK TABLES `wpie_commentmeta` WRITE;
/*!40000 ALTER TABLE `wpie_commentmeta` DISABLE KEYS */;
INSERT INTO `wpie_commentmeta` VALUES (1180,174,'akismet_pro_tip','discard'),(1177,174,'akismet_result','true'),(1178,174,'akismet_history','a:2:{s:4:\"time\";d:1581811750.19557094573974609375;s:5:\"event\";s:10:\"check-spam\";}'),(1179,174,'akismet_as_submitted','a:13:{s:14:\"comment_author\";s:13:\"AffiliateLabz\";s:20:\"comment_author_email\";s:26:\"comments@affiliatelabz.com\";s:18:\"comment_author_url\";s:60:\"https://affiliatelabz.com/special/?source=quintelacrosse.com\";s:15:\"comment_content\";s:49:\"Great content! Super high-quality! Keep it up! :)\";s:12:\"comment_type\";s:0:\"\";s:7:\"user_ID\";i:0;s:7:\"user_id\";i:0;s:7:\"user_ip\";s:14:\"62.171.135.115\";s:10:\"user_agent\";s:72:\"Mozilla/5.0 (compatible; AffiliateLabz/1.0; +https://affiliatelabz.com/)\";s:4:\"blog\";s:25:\"http://quintelacrosse.com\";s:9:\"blog_lang\";s:5:\"en_US\";s:12:\"blog_charset\";s:5:\"UTF-8\";s:9:\"permalink\";s:81:\"http://quintelacrosse.com/bayhawks-fundraiser-night-with-the-belleville-senators/\";}');
/*!40000 ALTER TABLE `wpie_commentmeta` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_commentmeta` with 4 row(s)
--
--
-- Table structure for table `wpie_comments`
--
DROP TABLE IF EXISTS `wpie_comments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_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=MyISAM AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_comments`
--
LOCK TABLES `wpie_comments` WRITE;
/*!40000 ALTER TABLE `wpie_comments` DISABLE KEYS */;
INSERT INTO `wpie_comments` VALUES (174,5194,'AffiliateLabz','comments@affiliatelabz.com','https://affiliatelabz.com/special/?source=quintelacrosse.com','62.171.135.115','2020-02-16 00:09:10','2020-02-16 00:09:10','Great content! Super high-quality! Keep it up! :)',0,'spam','Mozilla/5.0 (compatible; AffiliateLabz/1.0; +https://affiliatelabz.com/)','',0,0);
/*!40000 ALTER TABLE `wpie_comments` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_comments` with 1 row(s)
--
--
-- Table structure for table `wpie_links`
--
DROP TABLE IF EXISTS `wpie_links`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_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=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_links`
--
LOCK TABLES `wpie_links` WRITE;
/*!40000 ALTER TABLE `wpie_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `wpie_links` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_links` with 0 row(s)
--
--
-- Table structure for table `wpie_my_calendar`
--
DROP TABLE IF EXISTS `wpie_my_calendar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_my_calendar` (
`event_id` int(11) NOT NULL AUTO_INCREMENT,
`event_begin` date NOT NULL,
`event_end` date NOT NULL,
`event_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
`event_short` text COLLATE utf8mb4_unicode_ci NOT NULL,
`event_registration` text COLLATE utf8mb4_unicode_ci NOT NULL,
`event_tickets` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_time` time DEFAULT NULL,
`event_endtime` time DEFAULT NULL,
`event_recur` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`event_repeats` int(3) DEFAULT NULL,
`event_status` int(1) NOT NULL DEFAULT '1',
`event_author` bigint(20) unsigned DEFAULT NULL,
`event_host` bigint(20) unsigned DEFAULT NULL,
`event_category` bigint(20) unsigned NOT NULL DEFAULT '1',
`event_link` text COLLATE utf8mb4_unicode_ci,
`event_post` bigint(20) unsigned NOT NULL DEFAULT '0',
`event_link_expires` tinyint(1) NOT NULL,
`event_location` bigint(20) unsigned NOT NULL DEFAULT '0',
`event_label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_street` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_street2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_postcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_region` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_url` text COLLATE utf8mb4_unicode_ci,
`event_longitude` float(10,6) NOT NULL DEFAULT '0.000000',
`event_latitude` float(10,6) NOT NULL DEFAULT '0.000000',
`event_zoom` int(2) NOT NULL DEFAULT '14',
`event_phone` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_phone2` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`event_access` text COLLATE utf8mb4_unicode_ci,
`event_group_id` int(11) NOT NULL DEFAULT '0',
`event_span` int(1) NOT NULL DEFAULT '0',
`event_approved` int(1) NOT NULL DEFAULT '1',
`event_flagged` int(1) NOT NULL DEFAULT '0',
`event_hide_end` int(1) NOT NULL DEFAULT '0',
`event_holiday` int(1) NOT NULL DEFAULT '0',
`event_fifth_week` int(1) NOT NULL DEFAULT '0',
`event_image` text COLLATE utf8mb4_unicode_ci,
`event_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`event_id`),
KEY `event_category` (`event_category`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_my_calendar`
--
LOCK TABLES `wpie_my_calendar` WRITE;
/*!40000 ALTER TABLE `wpie_my_calendar` DISABLE KEYS */;
INSERT INTO `wpie_my_calendar` VALUES (1,'2019-09-26','2019-09-26','QMLA AGM','','','','','18:30:00','20:00:00','S1',0,1,2,2,1,'http://quintelacrosse.com/qmla-notice-of-agm/',4846,1,1,'Quinte Sports and Wellness Centre - Fireplace Room','265 Cannifton Road','','Belleville','ON','K8N 4V8','','','',0.000000,0.000000,16,'','','',0,0,1,0,1,1,1,'','2019-09-11 00:59:18'),(2,'2019-11-15','2019-11-15','Try Lacrosse - Trenton','','','','','18:00:00','20:00:00','S1',0,1,2,2,1,'',4999,0,2,'Trent River Public School','84 Dixon Drive','','Trenton','ON','','','','',0.000000,0.000000,16,'','','',0,0,1,0,0,1,1,'','2019-11-06 14:29:27'),(3,'2020-02-21','2020-02-21','Try Lacrosse - Belleville','','','','','18:00:00','20:00:00','S1',0,1,2,2,1,'https://quintelacrosse.com/try-lacrosse-for-free',5001,0,3,'Sir John A. MacDonald School','22 Harder Drive','','Belleville','ON','K8P 1H2','','','',0.000000,0.000000,16,'','','',3,0,1,0,0,1,1,'','2019-11-10 22:08:35'),(4,'2020-01-24','2020-01-24','Try Lacrosse - Belleville','','','','','18:00:00','20:00:00','S1',0,1,2,2,1,'https://quintelacrosse.com/try-lacrosse-for-free',5002,0,3,'Sir John A. MacDonald School','22 Harder Drive','','Belleville','ON','K8P 1H2','','','',0.000000,0.000000,16,'','','',3,0,1,0,0,1,1,'','2019-11-10 22:08:36'),(5,'2020-01-20','2020-01-20','Quinte Winter Lacrosse School','Born in 2010 or later: 5:00pm to 6:00pm\r\n\r\nBorn in 2009 or ealier: 6:00pm to 7:00pm','','','','17:00:00','19:00:00','W1',6,1,2,2,1,'https://quintelacrosse.com/quinte-lacrosse-school-information',5164,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',0,0,1,0,0,1,1,'','2020-01-11 00:40:38'),(6,'2020-03-07','2020-03-07','Tyke Competitive Tryout','All players must be registered prior to attending tryouts.','','','','09:00:00','10:00:00','S1',0,1,2,2,1,'',5165,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',6,0,1,0,0,1,1,'','2020-01-11 01:02:27'),(7,'2020-02-28','2020-02-28','Tyke Competitive Tryout','All players must be registered prior to attending tryouts.','','','','17:00:00','18:00:00','S1',0,1,2,2,1,'',5166,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',6,0,1,0,0,1,1,'','2020-01-11 01:02:27'),(8,'2020-03-07','2020-03-07','Novice Competitive Tryout','All players must be registered prior to attending tryouts','','','','10:00:00','11:00:00','S1',0,1,2,2,1,'',5167,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',8,0,1,0,0,1,1,'','2020-01-11 01:09:13'),(9,'2020-02-28','2020-02-28','Novice Competitive Tryout','All players must be registered prior to attending tryouts','','','','18:00:00','19:00:00','S1',0,1,2,2,1,'',5168,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',8,0,1,0,0,1,1,'','2020-01-11 01:09:13'),(10,'2020-03-06','2020-03-06','Peewee Competitive Tryout','All players must be registered before attending tryouts','','','','17:00:00','18:00:00','S1',0,1,2,2,1,'',5169,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',10,0,1,0,0,1,1,'','2020-01-11 01:18:07'),(11,'2020-02-22','2020-02-22','Peewee Competitive Tryout','All players must be registered before attending tryouts','','','','09:00:00','10:00:00','S1',0,1,2,2,1,'',5170,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',10,0,1,0,0,1,1,'','2020-01-11 01:18:07'),(12,'2020-03-06','2020-03-06','Bantam Competitive Tryout','All players must be registered before attending tryouts','','','','18:00:00','19:00:00','S1',0,1,2,2,1,'',5171,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',12,0,1,0,0,1,1,'','2020-01-11 01:19:53'),(13,'2020-02-22','2020-02-22','Bantam Competitive Tryout','All players must be registered before attending tryouts','','','','10:00:00','11:00:00','S1',0,1,2,2,1,'',5172,0,4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','','http://loyalistsportsdome.com',0.000000,0.000000,16,'','','',12,0,1,0,0,1,1,'','2020-01-11 01:19:53');
/*!40000 ALTER TABLE `wpie_my_calendar` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar` with 13 row(s)
--
--
-- Table structure for table `wpie_my_calendar_categories`
--
DROP TABLE IF EXISTS `wpie_my_calendar_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_my_calendar_categories` (
`category_id` int(11) NOT NULL AUTO_INCREMENT,
`category_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`category_color` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL,
`category_icon` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`category_private` int(1) NOT NULL DEFAULT '0',
`category_term` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_my_calendar_categories`
--
LOCK TABLES `wpie_my_calendar_categories` WRITE;
/*!40000 ALTER TABLE `wpie_my_calendar_categories` DISABLE KEYS */;
INSERT INTO `wpie_my_calendar_categories` VALUES (1,'General','#ffffcc','event.png',0,25);
/*!40000 ALTER TABLE `wpie_my_calendar_categories` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar_categories` with 1 row(s)
--
--
-- Table structure for table `wpie_my_calendar_category_relationships`
--
DROP TABLE IF EXISTS `wpie_my_calendar_category_relationships`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_my_calendar_category_relationships` (
`relationship_id` int(11) NOT NULL AUTO_INCREMENT,
`event_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`relationship_id`),
KEY `event_id` (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_my_calendar_category_relationships`
--
LOCK TABLES `wpie_my_calendar_category_relationships` WRITE;
/*!40000 ALTER TABLE `wpie_my_calendar_category_relationships` DISABLE KEYS */;
INSERT INTO `wpie_my_calendar_category_relationships` VALUES (1,1,1),(2,2,1),(3,3,1),(4,4,1),(5,5,1),(6,6,1),(7,7,1),(8,8,1),(9,9,1),(10,10,1),(11,11,1),(12,12,1),(13,13,1);
/*!40000 ALTER TABLE `wpie_my_calendar_category_relationships` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar_category_relationships` with 13 row(s)
--
--
-- Table structure for table `wpie_my_calendar_events`
--
DROP TABLE IF EXISTS `wpie_my_calendar_events`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_my_calendar_events` (
`occur_id` int(11) NOT NULL AUTO_INCREMENT,
`occur_event_id` int(11) NOT NULL,
`occur_begin` datetime NOT NULL,
`occur_end` datetime NOT NULL,
`occur_group_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`occur_id`),
KEY `occur_event_id` (`occur_event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_my_calendar_events`
--
LOCK TABLES `wpie_my_calendar_events` WRITE;
/*!40000 ALTER TABLE `wpie_my_calendar_events` DISABLE KEYS */;
INSERT INTO `wpie_my_calendar_events` VALUES (1,1,'2019-09-26 18:30:00','2019-09-26 20:00:00',0),(2,2,'2019-11-15 18:00:00','2019-11-15 20:00:00',0),(3,3,'2020-02-21 18:00:00','2020-02-21 20:00:00',3),(4,4,'2020-01-24 18:00:00','2020-01-24 20:00:00',3),(5,5,'2020-01-20 17:00:00','2020-01-20 19:00:00',0),(6,5,'2020-01-27 17:00:00','2020-01-27 19:00:00',0),(7,5,'2020-02-03 17:00:00','2020-02-03 19:00:00',0),(8,5,'2020-02-10 17:00:00','2020-02-10 19:00:00',0),(10,5,'2020-02-24 17:00:00','2020-02-24 19:00:00',0),(11,5,'2020-03-02 17:00:00','2020-03-02 19:00:00',0),(13,6,'2020-03-07 09:00:00','2020-03-07 10:00:00',6),(14,7,'2020-02-28 17:00:00','2020-02-28 18:00:00',6),(15,8,'2020-03-07 10:00:00','2020-03-07 11:00:00',8),(16,9,'2020-02-28 18:00:00','2020-02-28 19:00:00',8),(17,10,'2020-03-06 17:00:00','2020-03-06 18:00:00',10),(18,11,'2020-02-22 09:00:00','2020-02-22 10:00:00',10),(19,12,'2020-03-06 18:00:00','2020-03-06 19:00:00',12),(20,13,'2020-02-22 10:00:00','2020-02-22 11:00:00',12);
/*!40000 ALTER TABLE `wpie_my_calendar_events` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar_events` with 18 row(s)
--
--
-- Table structure for table `wpie_my_calendar_locations`
--
DROP TABLE IF EXISTS `wpie_my_calendar_locations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_my_calendar_locations` (
`location_id` int(11) NOT NULL AUTO_INCREMENT,
`location_label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_street` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_street2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_postcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_region` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_url` text COLLATE utf8mb4_unicode_ci,
`location_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_longitude` float(10,6) NOT NULL DEFAULT '0.000000',
`location_latitude` float(10,6) NOT NULL DEFAULT '0.000000',
`location_zoom` int(2) NOT NULL DEFAULT '14',
`location_phone` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_phone2` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`location_access` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`location_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_my_calendar_locations`
--
LOCK TABLES `wpie_my_calendar_locations` WRITE;
/*!40000 ALTER TABLE `wpie_my_calendar_locations` DISABLE KEYS */;
INSERT INTO `wpie_my_calendar_locations` VALUES (1,'Quinte Sports and Wellness Centre - Fireplace Room','265 Cannifton Road','','Belleville','ON','K8N 4V8','','','',0.000000,0.000000,16,'','','a:6:{i:0;s:19:\"Accessible Entrance\";i:1;s:29:\"Accessible Parking Designated\";i:2;s:20:\"Accessible Restrooms\";i:3;s:18:\"Accessible Seating\";i:4;s:35:\"Accessible Transportation Available\";i:5;s:21:\"Wheelchair Accessible\";}'),(2,'Trent River Public School','84 Dixon Drive','','Trenton','ON','','','','',0.000000,0.000000,16,'','',''),(3,'Sir John A. MacDonald School','22 Harder Drive','','Belleville','ON','K8P 1H2','','','',0.000000,0.000000,16,'','',''),(4,'Loyalist Sports Dome','284 Wallbridge Loyalist Rd','','Belleville','Ontario','K8N 4Z2','','http://loyalistsportsdome.com','',0.000000,0.000000,16,'','','');
/*!40000 ALTER TABLE `wpie_my_calendar_locations` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar_locations` with 4 row(s)
--
--
-- Table structure for table `wpie_nextend2_image_storage`
--
DROP TABLE IF EXISTS `wpie_nextend2_image_storage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_nextend2_image_storage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hash` varchar(32) NOT NULL,
`image` text NOT NULL,
`value` mediumtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `hash` (`hash`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_nextend2_image_storage`
--
LOCK TABLES `wpie_nextend2_image_storage` WRITE;
/*!40000 ALTER TABLE `wpie_nextend2_image_storage` DISABLE KEYS */;
INSERT INTO `wpie_nextend2_image_storage` VALUES (1,'7c6d6efc321cee62255d313b0dec981b','$upload$/2018/11/Quinte-Bayhawks-Lacrosse-Logo-colour.png','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(2,'ed30f9fac6d793f430581fe88f6f4f6a','$upload$/slider5/fullwidthbg1.jpg','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(3,'dec3d6e08e2f46a8ef7d4805b0bbf9d2','$upload$/slider5/fullwidthbg2.jpg','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(4,'9e381f84dffd89485fa7c94cbb7c82d5','$upload$/slider5/fullwidthbg3.jpg','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(5,'41baa23025d18eab8a5a6839c18bf0a0','http://quintelacrosse.com/wp-content/uploads/2018/12/137-e1569878062351.jpg','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(6,'473178f73bf2b026f741f7dec40401b7','http://quintelacrosse.com/wp-content/uploads/2019/10/Shawn-and-Turner-e1571749157899.jpg','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(7,'7bc2cbaa92b450f52fbdbcb4a7fbb27c','$upload$/2019/10/tyler-seguin.png','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(8,'3a2ee2557eefefa2eda07b54bb8077ba','$upload$/2019/11/stick.jpg','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ=='),(9,'aceb6bc5fb3c9918805d409efd5e2498','$upload$/2019/11/2020-Sponsorship-Title-Page.jpg','eyJkZXNrdG9wIjp7InNpemUiOiIwfCp8MCJ9LCJkZXNrdG9wLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJ0YWJsZXQiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwidGFibGV0LXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9LCJtb2JpbGUiOnsiaW1hZ2UiOiIiLCJzaXplIjoiMHwqfDAifSwibW9iaWxlLXJldGluYSI6eyJpbWFnZSI6IiIsInNpemUiOiIwfCp8MCJ9fQ==');
/*!40000 ALTER TABLE `wpie_nextend2_image_storage` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_nextend2_image_storage` with 9 row(s)
--
--
-- Table structure for table `wpie_nextend2_section_storage`
--
DROP TABLE IF EXISTS `wpie_nextend2_section_storage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wpie_nextend2_section_storage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`application` varchar(20) NOT NULL,
`section` varchar(128) NOT NULL,
`referencekey` varchar(128) NOT NULL,
`value` mediumtext NOT NULL,
`system` int(11) NOT NULL DEFAULT '0',
`editable` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `application` (`application`,`section`,`referencekey`),
KEY `application_2` (`application`,`section`)
) ENGINE=MyISAM AUTO_INCREMENT=12487 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wpie_nextend2_section_storage`
--
LOCK TABLES `wpie_nextend2_section_storage` WRITE;
/*!40000 ALTER TABLE `wpie_nextend2_section_storage` DISABLE KEYS */;
INSERT INTO `wpie_nextend2_section_storage` VALUES (10000,'system','global','n2_ss3_version','3.3.25r5488',1,1),(10002,'smartslider','free','subscribeOnImport','1',0,1),(12482,'smartslider','sliderChanged','4','0',0,1),(12483,'cache','notweb/n2-ss-4','data.manifest','{\"generator\":[]}',0,1),(12484,'cache','notweb/n2-ss-4','variations.manifest','1',0,1),(12485,'cache','notweb/n2-ss-4','slideren_US1.manifest','{\"hash\":\"\",\"nextCacheRefresh\":1887372235,\"currentPath\":\"4e3f5f5f30d160e1c1c18f7e31465896\",\"version\":\"3.3.25\"}',0,1),(12486,'cache','notweb/n2-ss-4','slideren_US1','{\"html\":\"