/home/altere25/quintelacrosse.com
Edit: /home/altere25/quintelacrosse.com/altere25_wp176.20191104-175224.sql (3412050B)
-- mysqldump-php https://github.com/ifsnop/mysqldump-php
--
-- Host: localhost Database: altere25_wp176
-- ------------------------------------------------------
-- Server version 5.5.5-10.1.36-MariaDB
-- Date: Mon, 04 Nov 2019 17:52:24 +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=1136 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 (38,26,'akismet_history','a:3:{s:4:\"time\";d:1553643325.69910907745361328125;s:5:\"event\";s:11:\"check-error\";s:4:\"meta\";a:1:{s:8:\"response\";s:7:\"invalid\";}}'),(1024,26,'akismet_result','false'),(1025,26,'akismet_history','a:3:{s:4:\"time\";d:1571147580.8539040088653564453125;s:5:\"event\";s:11:\"recheck-ham\";s:4:\"user\";s:9:\"quintelax\";}'),(1067,26,'akismet_history','a:3:{s:4:\"time\";d:1571147710.739574909210205078125;s:5:\"event\";s:15:\"status-approved\";s:4:\"user\";s:9:\"quintelax\";}'),(1125,164,'akismet_result','false'),(1126,164,'akismet_history','a:2:{s:4:\"time\";d:1572558936.5976428985595703125;s:5:\"event\";s:9:\"check-ham\";}'),(1127,164,'akismet_as_submitted','a:13:{s:14:\"comment_author\";s:16:\"Orlinda Johnston\";s:20:\"comment_author_email\";s:23:\"ojohnston@metroland.com\";s:18:\"comment_author_url\";s:0:\"\";s:15:\"comment_content\";s:159:\"Please let me know who to send information to regarding advertising opportunities in the winter issue of 8 Wing/CFB Trenton Community Program Guide.\r\nThank you\";s:12:\"comment_type\";s:0:\"\";s:7:\"user_ID\";i:0;s:7:\"user_id\";i:0;s:7:\"user_ip\";s:12:\"76.74.201.36\";s:10:\"user_agent\";s:69:\"Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko\";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:55:\"https://quintelacrosse.com/3-on-3-paperweight-division/\";}'),(1132,164,'akismet_history','a:3:{s:4:\"time\";d:1572563491.6916339397430419921875;s:5:\"event\";s:15:\"status-approved\";s:4:\"user\";s:9:\"quintelax\";}'),(1133,166,'akismet_result','false'),(1134,166,'akismet_history','a:3:{s:4:\"time\";d:1572563575.54273509979248046875;s:5:\"event\";s:9:\"check-ham\";s:4:\"user\";s:9:\"quintelax\";}'),(1135,166,'akismet_as_submitted','a:13:{s:14:\"comment_author\";s:9:\"quintelax\";s:20:\"comment_author_email\";s:16:\"jfee_11@yahoo.ca\";s:18:\"comment_author_url\";s:25:\"http://quintelacrosse.com\";s:15:\"comment_content\";s:116:\"Hi there, you can contact us at quintelacrosse@gmail.com and we would be happy to discuss advertising opportunities.\";s:12:\"comment_type\";s:0:\"\";s:7:\"user_ID\";i:2;s:7:\"user_id\";i:2;s:7:\"user_ip\";s:12:\"76.71.85.141\";s:10:\"user_agent\";s:113:\"Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36\";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:54:\"http://quintelacrosse.com/3-on-3-paperweight-division/\";}');
/*!40000 ALTER TABLE `wpie_commentmeta` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_commentmeta` with 11 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=167 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 (3,4278,'Stephanie Gould','stephaniegould@hotmail.ca','','45.78.161.226','2019-02-05 18:58:22','2019-02-05 18:58:22','Before I am able to sign my sons up for Lacrosse I will need to know what nights they will play on as they play hockey and ball hockey as well.\r\n\r\nMy younger son is 2011, and older son 2008.\r\n\r\nThanks',0,'1','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36','',0,0),(4,4278,'QMLA','jfee_11@yahoo.ca','http://quintelacrosse.com','165.225.36.131','2019-02-05 19:03:54','2019-02-05 19:03:54','Hi Stephanie, we are glad to hear you and your boys are interested in lacrosse. We have our days of play posted under the \"House League\" tab on our website. If there is anything else you need, please feel free to contact us at quintelacrosse@gmail.com',0,'1','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36','',3,2),(6,1630,'Melissa Silverburg','nmsilverburg@gmail.com','','67.193.51.214','2019-02-20 03:17:34','2019-02-20 03:17:34','We just registered our little one for his first season. I saw on the website the first 60 get a stick. Just wondering how you know if you are one of the 60 or not.',0,'1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_2) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0.2 Safari/605.1.15','',0,0),(26,4417,'Andy','andyh749@gmail.com','','76.64.171.101','2019-03-26 23:35:25','2019-03-26 23:35:25','My son is interested in registering for peewee house league, \r\nwhen does season start and end ?\r\nThanks\r\nAndy',0,'1','Mozilla/5.0 (iPhone; CPU iPhone OS 12_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/73.0.3683.68 Mobile/15E148 Safari/605.1','',0,0),(164,4231,'Orlinda Johnston','ojohnston@metroland.com','','76.74.201.36','2019-10-31 21:55:36','2019-10-31 21:55:36','Please let me know who to send information to regarding advertising opportunities in the winter issue of 8 Wing/CFB Trenton Community Program Guide.\r\nThank you',0,'1','Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko','',0,0),(166,4231,'quintelax','jfee_11@yahoo.ca','http://quintelacrosse.com','76.71.85.141','2019-10-31 23:12:55','2019-10-31 23:12:55','Hi there, you can contact us at quintelacrosse@gmail.com and we would be happy to discuss advertising opportunities.',0,'1','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36','',0,2);
/*!40000 ALTER TABLE `wpie_comments` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_comments` with 6 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=2 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');
/*!40000 ALTER TABLE `wpie_my_calendar` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar` with 1 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,0);
/*!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=2 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);
/*!40000 ALTER TABLE `wpie_my_calendar_category_relationships` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar_category_relationships` with 1 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=2 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);
/*!40000 ALTER TABLE `wpie_my_calendar_events` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar_events` with 1 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=2 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\";}');
/*!40000 ALTER TABLE `wpie_my_calendar_locations` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_my_calendar_locations` with 1 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=8 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==');
/*!40000 ALTER TABLE `wpie_nextend2_image_storage` ENABLE KEYS */;
UNLOCK TABLES;
-- Dumped table `wpie_nextend2_image_storage` with 7 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=11261 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.22r4878',1,1),(10002,'smartslider','free','subscribeOnImport','1',0,1),(11256,'smartslider','sliderChanged','4','0',0,1),(11257,'cache','notweb/n2-ss-4','data.manifest','{\"generator\":[]}',0,1),(11258,'cache','notweb/n2-ss-4','variations.manifest','1',0,1),(11259,'cache','notweb/n2-ss-4','slideren_US1.manifest','{\"hash\":\"\",\"nextCacheRefresh\":1887372235,\"currentPath\":\"4e3f5f5f30d160e1c1c18f7e31465896\",\"version\":\"3.3.22\"}',0,1),(11260,'cache','notweb/n2-ss-4','slideren_US1','{\"html\":\"