Untitled

-- phpMyAdmin SQL Dump
-- version 4.7.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:8889
-- Generation Time: Apr 03, 2018 at 04:56 PM
-- Server version: 5.6.38
-- PHP Version: 5.6.32

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `pbt`
--

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

--
-- Table structure for table `appointments`
--

CREATE TABLE `appointments` (
  `id` int(11) NOT NULL,
  `mb_user_id` varchar(50) NOT NULL,
  `mb_appointment_ids` varchar(255) NOT NULL,
  `mb_sessions_titles` varchar(255) NOT NULL,
  `sessions_ids` varchar(255) NOT NULL,
  `booking_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `location_id` tinyint(3) NOT NULL,
  `location_name` varchar(20) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `price` float NOT NULL,
  `discount` float NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `appointments`
--

INSERT INTO `appointments` (`id`, `mb_user_id`, `mb_appointment_ids`, `mb_sessions_titles`, `sessions_ids`, `booking_time`, `location_id`, `location_name`, `staff_id`, `duration`, `price`, `discount`, `date`) VALUES
(1, 'Brando_215122', '[20608,20609,20610,20611]', '[\"LED (10 min)\",\"Eye Peel (10 min)\",\"Hand Peel (10 min)\",\"The Pre-Party Peel (20 min)\"]', '[\"13\",\"8\",\"9\",\"12\"]', '0000-00-00 00:00:00', 1, 'Marylebone', 100000006, 60, 115, 0, '2018-03-29 16:49:55'),
(2, 'Brando_215122', '[20612,20613,20614,20615,20616,20617]', '[\"The Brightening Peel (20 min)\",\"LED (10 min)\",\"Eye Peel (10 min)\",\"Neck Peel (10 min)\",\"Hand Peel (10 min)\",\"Facial Massage (10 min)\"]', '[\"5\",\"8\",\"9\",\"10\",\"12\",\"14\"]', '0000-00-00 00:00:00', 1, 'Marylebone', 100000006, 80, 155, 0, '2018-03-29 17:29:52');

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('1004b54cef3dd39a5e9aa8af7dfd61e562ea6a54', '127.0.0.1', 1522761975, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736313732303b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('28aa6f40196dae806da271744a69028b9fa5cf97', '127.0.0.1', 1522763472, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736333437313b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('39137ac3f9279a44ce55b3eb12c9125f8ecc3bdf', '127.0.0.1', 1522767104, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736363434393b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('3a2d4e43435d8e2676f74ad07ef4a4752eb045d6', '127.0.0.1', 1522763430, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736333136313b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('3bd71fc53dd7039e981a13a83d176d40b536d1ea', '127.0.0.1', 1522764271, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736343237303b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('3cd4d5b386966833cb40b22c54c0e3a9dd3641f2', '127.0.0.1', 1522757019, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323735363735373b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('3f7a6406073c06ccbfe91dd72b6efa9461132881', '127.0.0.1', 1522756372, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323735363130323b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('513f9258b4c4fab29e15ebaf97eadc8dff3e3c43', '127.0.0.1', 1522762721, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736323434393b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('597cd8083a2f4ce5f622140b4f12d025c64137ca', '127.0.0.1', 1522754899, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323735343632343b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('67f4c0a0bb0c4b03a4aed0bf5ba5631fa4255045', '127.0.0.1', 1522761244, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736313037363b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('6c2cc25cda8f6f862e5db634c1cc02b65af7aeac', '127.0.0.1', 1522766391, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736353930333b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('6c53c8592d85e354f67a086e6a4c3487a27b9091', '127.0.0.1', 1522761707, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736313431343b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('75a262c2d2dd483583e1536b5a8d56fc62a0908c', '127.0.0.1', 1522764773, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736343639303b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('a030cd9b54ab0384b933012bb2833eeff6dfc741', '127.0.0.1', 1522765401, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736353133303b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('a5f4e1147cdfbed4e251e0cb9667b9ea69c446cb', '127.0.0.1', 1522763109, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736323832313b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('b57eefeaf5115818bde2caddb1c43b345a1e4065', '127.0.0.1', 1522755251, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323735353235313b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('cc1e051fdda86f505022c413632c7d377b0b0670', '127.0.0.1', 1522760307, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736303330363b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('fa1cf11bc621efe2a795a8386f3f8b03ecb7b91f', '127.0.0.1', 1522764189, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736333932373b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d),
('ff1696d7f11adb200b56d16b463c720782645aac', '127.0.0.1', 1522765714, 0x5f5f63695f6c6173745f726567656e65726174657c693a313532323736353439383b736974655f6c616e677c733a373a22656e676c697368223b6d625f757365725f69647c733a31333a224272616e646f5f323135313232223b6d625f757365725f646174617c613a323a7b733a353a226d625f6964223b733a31333a224272616e646f5f323135313232223b733a353a22656d61696c223b733a32333a22736572676975406272616e646f2d6d656469612e636f6d223b7d);

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `variables` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` (`id`, `title`, `subject`, `text`, `variables`) VALUES
(1, 'Reset Password', 'Reset Password To The Peel Boutique!', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html>\r\n<head>\r\n</head>\r\n<body style=\"background-color: #ffffff\">\r\n<div style=\"text-align: center; margin: 20px 0 40px;\"><a href=\"http://www.thepeelboutique.com/\" target=\"_blank\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/pb-logo-pink.png\" alt=\"The Peel Boutique\" width=\"300px\" /> </a></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"font-size: 32px; font-weight: bold; color: #fda993;\">ACTIVATE YOUR ACCOUNT</span></div>\r\n<div style=\"text-align: left; margin-left: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\" /></span></div>\r\n<div style=\"text-align: center; margin-bottom: 10px;\"><span style=\"font-size: 18px; letter-spacing: 2px; color: #fda993;\">Welcome to The Peel Boutique! To book a treatment please visit our website.</span></div>\r\n<div style=\"text-align: center; margin-bottom: 10px;\"><span style=\"font-size: 18px; letter-spacing: 2px; color: #fda993;\">Here is your login information:</span></div>\r\n<div style=\"text-align: center; margin-bottom: 10px;\"><span style=\"font-size: 18px; letter-spacing: 2px; color: #fda993;\">Username: {USERNAME} <br />Password: {CREATE_PASSWORD}</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"font-size: 18px; letter-spacing: 2px; color: #fda993;\">If you have any additional questions, then please feel free to contact us by using the email listed below.</span></div>\r\n<div style=\"text-align: right; margin-right: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\" /></span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993;\"><a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://www.instagram.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/insta-icon-pink.png\" alt=\"Instagram\" width=\"40\" /> </span></a> <a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://en-gb.facebook.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/fb-icon-pink.png\" alt=\"Facebook\" width=\"40\" /> </span></a> <a style=\"text-decoration: none;\" href=\"https://twitter.com/thepeelboutique?lang=en\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/twitter-icon-pink.png\" alt=\"Twitter\" width=\"40\" /> </span></a></span></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"color: #fda993;\"><span style=\"padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"mailto:info@thepeelboutique.com\" target=\"_blank\"><span style=\"color: #fda993;\">info@thepeelboutique.com</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"http://www.thepeelboutique.com/contact\" target=\"_blank\"><span style=\"color: #fda993;\">CONTACT</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"https://www.thepeelboutique.com/locations\" target=\"_blank\"><span style=\"color: #fda993;\">LOCATIONS</span></a> </span></span></div>\r\n<div style=\"text-align: center; margin-bottom: 10px; color: #fda993;\"><span style=\"color: #fda993;\">#SetYourSkinFree</span></div>\r\n</body>\r\n</html>', 'USERNAME|CREATE_PASSWORD'),
(2, 'Appointment Is Booked', 'The Peel Boutique: Your Appointment Is Booked for {WEEK} at {TIME} on {DATE}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html><head>\r\n<style>ul,ol,li { list-style: none; } a { color: #fda893 !important; }</style>\r\n</head>\r\n<body style=\"background-color: #ffffff\">\r\n<div style=\"text-align: center; margin: 20px 0 40px;\"><a href=\"http://www.thepeelboutique.com/\" target=\"_blank\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/pb-logo-pink.png\" alt=\"The Peel Boutique\" width=\"300px\"> </a></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"font-size: 32px; font-weight: bold; color: #fda993;\">YOUR APPOINTMENT HAS BEEN BOOKED!</span></div>\r\n<div style=\"text-align: left; margin-left: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\"></span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">{TIME} on {WEEK}, {DATE}</span></div>\r\n{ITEMS}\r\n<div style=\"text-align: center; margin-bottom: 10px; margin-top: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">Address: {CITY}</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">{ADDRESS}</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">Please ensure that you arrive 5 minutes before your scheduled appointment time and be aware that you may have to forfeit your appointment if you’re more than 5 minutes late.</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">If you need to cancel your booking, \r\nplease do so no later than 24 hours prior to ensure \r\nyou are refunded for the treatment.</span></div>\r\n<div style=\"text-align: right; margin-right: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\"></span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993;\"><a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://www.instagram.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/insta-icon-pink.png\" alt=\"Instagram\" width=\"40\"> </span></a> <a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://en-gb.facebook.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/fb-icon-pink.png\" alt=\"Facebook\" width=\"40\"> </span></a> <a style=\"text-decoration: none;\" href=\"https://twitter.com/thepeelboutique?lang=en\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/twitter-icon-pink.png\" alt=\"Twitter\" width=\"40\"> </span></a></span></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"color: #fda993;\"><span style=\"padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"mailto:info@thepeelboutique.com\" target=\"_blank\"><span style=\"color: #fda993;\">info@thepeelboutique.com</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"http://www.thepeelboutique.com/contact\" target=\"_blank\"><span style=\"color: #fda993;\">CONTACT</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"https://www.thepeelboutique.com/locations\" target=\"_blank\"><span style=\"color: #fda993;\">LOCATIONS</span></a> </span></span></div>\r\n<div style=\"text-align: center; margin-bottom: 10px; color: #fda993;\"><span style=\"color: #fda993;\">#SetYourSkinFree</span></div>\r\n\r\n</body></html>', 'TIME|WEEK|DATE|CITY|ADDRESS|ITEMS'),
(3, 'Appointment Is Changed', 'The Peel Boutique: Your Appointment Is Changed for {WEEK} at {TIME} on {DATE}', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html><head>\r\n<style>ul,ol,li { list-style: none; } a { color: #fda893 !important; }</style>\r\n</head>\r\n<body style=\"background-color: #ffffff\">\r\n<div style=\"text-align: center; margin: 20px 0 40px;\"><a href=\"http://www.thepeelboutique.com/\" target=\"_blank\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/pb-logo-pink.png\" alt=\"The Peel Boutique\" width=\"300px\"> </a></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"font-size: 32px; font-weight: bold; color: #fda993;\">YOUR APPOINTMENT HAS BEEN CHANGED!</span></div>\r\n<div style=\"text-align: left; margin-left: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\"></span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">{TIME} on {WEEK}, {DATE}</span></div>\r\n{ITEMS}\r\n<div style=\"text-align: center; margin-bottom: 10px; margin-top: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">Address: {CITY}</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">{ADDRESS}</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">Please ensure that you arrive 5 minutes before your scheduled appointment time and be aware that you may have to forfeit your appointment if you’re more than 5 minutes late.</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">If you need to cancel your booking, \r\nplease do so no later than 24 hours prior to ensure \r\nyou are refunded for the treatment.</span></div>\r\n<div style=\"text-align: right; margin-right: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\"></span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993;\"><a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://www.instagram.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/insta-icon-pink.png\" alt=\"Instagram\" width=\"40\"> </span></a> <a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://en-gb.facebook.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/fb-icon-pink.png\" alt=\"Facebook\" width=\"40\"> </span></a> <a style=\"text-decoration: none;\" href=\"https://twitter.com/thepeelboutique?lang=en\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/twitter-icon-pink.png\" alt=\"Twitter\" width=\"40\"> </span></a></span></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"color: #fda993;\"><span style=\"padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"mailto:info@thepeelboutique.com\" target=\"_blank\"><span style=\"color: #fda993;\">info@thepeelboutique.com</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"http://www.thepeelboutique.com/contact\" target=\"_blank\"><span style=\"color: #fda993;\">CONTACT</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"https://www.thepeelboutique.com/locations\" target=\"_blank\"><span style=\"color: #fda993;\">LOCATIONS</span></a> </span></span></div>\r\n<div style=\"text-align: center; margin-bottom: 10px; color: #fda993;\"><span style=\"color: #fda993;\">#SetYourSkinFree</span></div>\r\n\r\n</body></html>', 'TIME|WEEK|DATE|CITY|ADDRESS|ITEMS'),
(4, 'Appointment Is Canceled', 'The Peel Boutique: Your Appointment Is Canceled', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html><head>\r\n<style>ul,ol,li { list-style: none; } a { color: #fda893 !important; }</style>\r\n</head>\r\n<body style=\"background-color: #ffffff\">\r\n<div style=\"text-align: center; margin: 20px 0 40px;\"><a href=\"http://www.thepeelboutique.com/\" target=\"_blank\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/pb-logo-pink.png\" alt=\"The Peel Boutique\" width=\"300px\"> </a></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"font-size: 32px; font-weight: bold; color: #fda993;\">YOUR APPOINTMENT HAS BEEN CANCELED!</span></div>\r\n<div style=\"text-align: left; margin-left: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\"></span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">{TIME} on {WEEK}, {DATE}</span></div>\r\n{ITEMS}\r\n<div style=\"text-align: center; margin-bottom: 10px; margin-top: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">Address: {CITY}</span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993; font-size: 18px; letter-spacing: 2px;\">{ADDRESS}</span></div>\r\n<div style=\"text-align: right; margin-right: 20px;\"><span style=\"color: #fda993;\"><img src=\"http://brando.media/peelboutique/assets/images/email-template/star-icon-pink.png\" alt=\"Star\"></span></div>\r\n<div style=\"text-align: center; margin-bottom: 40px;\"><span style=\"color: #fda993;\"><a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://www.instagram.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/insta-icon-pink.png\" alt=\"Instagram\" width=\"40\"> </span></a> <a style=\"margin-right: 30px; text-decoration: none;\" href=\"https://en-gb.facebook.com/thepeelboutique/\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/fb-icon-pink.png\" alt=\"Facebook\" width=\"40\"> </span></a> <a style=\"text-decoration: none;\" href=\"https://twitter.com/thepeelboutique?lang=en\" target=\"_blank\"><span style=\"color: #fda993;\"> <img src=\"http://brando.media/peelboutique/assets/images/email-template/twitter-icon-pink.png\" alt=\"Twitter\" width=\"40\"> </span></a></span></div>\r\n<div style=\"text-align: center; margin-bottom: 20px;\"><span style=\"color: #fda993;\"><span style=\"padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"mailto:info@thepeelboutique.com\" target=\"_blank\"><span style=\"color: #fda993;\">info@thepeelboutique.com</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"http://www.thepeelboutique.com/contact\" target=\"_blank\"><span style=\"color: #fda993;\">CONTACT</span></a> </span> <span style=\"padding-left: 10px; padding-right: 10px; border-right: 1px solid #fda993;\"> <a style=\"color: #fda993; text-decoration: none; font-size: 16px;\" href=\"https://www.thepeelboutique.com/locations\" target=\"_blank\"><span style=\"color: #fda993;\">LOCATIONS</span></a> </span></span></div>\r\n<div style=\"text-align: center; margin-bottom: 10px; color: #fda993;\"><span style=\"color: #fda993;\">#SetYourSkinFree</span></div>\r\n\r\n</body></html>', 'TIME|WEEK|DATE|CITY|ADDRESS|ITEMS');

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

--
-- Table structure for table `mindbody_book_data`
--

CREATE TABLE `mindbody_book_data` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `updated` datetime NOT NULL,
  `response` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mindbody_book_data`
--

INSERT INTO `mindbody_book_data` (`id`, `title`, `updated`, `response`) VALUES
(1, 'bookable items', '2018-04-03 14:00:54', '{\"marylebone\":{\"2018-04-03\":{\"day_format\":{\"date\":\"3rd Apr\",\"week\":\"Tue\"},\"13:0515:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"13:05\",\"end_time\":\"15:00\"},\"15:3016:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"15:30\",\"end_time\":\"16:30\"}},\"2018-04-04\":{\"day_format\":{\"date\":\"4th Apr\",\"week\":\"Wed\"},\"09:3013:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"13:30\"},\"14:2015:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"14:20\",\"end_time\":\"15:30\"},\"16:0017:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"16:00\",\"end_time\":\"17:30\"}},\"2018-04-05\":{\"day_format\":{\"date\":\"5th Apr\",\"week\":\"Thu\"},\"09:3012:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"12:30\"},\"13:0013:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"13:00\",\"end_time\":\"13:30\"},\"15:0015:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"15:00\",\"end_time\":\"15:30\"}},\"2018-04-06\":{\"day_format\":{\"date\":\"6th Apr\",\"week\":\"Fri\"},\"09:3012:00\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"12:00\"},\"14:2017:00\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"14:20\",\"end_time\":\"17:00\"}},\"2018-04-07\":{\"day_format\":{\"date\":\"7th Apr\",\"week\":\"Sat\"},\"09:3013:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"13:30\"},\"16:3017:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"16:30\",\"end_time\":\"17:30\"},\"15:5016:00\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"15:50\",\"end_time\":\"16:00\"}},\"2018-04-10\":{\"day_format\":{\"date\":\"10th Apr\",\"week\":\"Tue\"},\"09:3012:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"12:30\"},\"13:0015:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"13:00\",\"end_time\":\"15:00\"},\"15:3017:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"15:30\",\"end_time\":\"17:00\"}},\"2018-04-11\":{\"day_format\":{\"date\":\"11th Apr\",\"week\":\"Wed\"},\"09:3015:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"15:30\"},\"16:0017:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"16:00\",\"end_time\":\"17:30\"}},\"2018-04-12\":{\"day_format\":{\"date\":\"12th Apr\",\"week\":\"Thu\"},\"09:3012:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"12:30\"},\"13:0015:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"13:00\",\"end_time\":\"15:30\"},\"16:0018:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"16:00\",\"end_time\":\"18:30\"}},\"2018-04-13\":{\"day_format\":{\"date\":\"13th Apr\",\"week\":\"Fri\"},\"09:3012:00\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"12:00\"},\"13:0017:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"13:00\",\"end_time\":\"17:30\"}},\"2018-04-14\":{\"day_format\":{\"date\":\"14th Apr\",\"week\":\"Sat\"},\"09:3013:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"13:30\"},\"14:3017:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"14:30\",\"end_time\":\"17:30\"}},\"2018-04-17\":{\"day_format\":{\"date\":\"17th Apr\",\"week\":\"Tue\"},\"09:3012:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"12:30\"},\"13:0015:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"13:00\",\"end_time\":\"15:00\"},\"15:3017:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"15:30\",\"end_time\":\"17:30\"}}},\"kensington\":{\"2018-04-03\":{\"day_format\":{\"date\":\"3rd Apr\",\"week\":\"Tue\"},\"13:4017:20\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"13:40\",\"end_time\":\"17:20\"}},\"2018-04-04\":{\"day_format\":{\"date\":\"4th Apr\",\"week\":\"Wed\"},\"09:3013:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"13:30\"},\"14:3015:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"14:30\",\"end_time\":\"15:30\"},\"16:1017:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"16:10\",\"end_time\":\"17:30\"}},\"2018-04-07\":{\"day_format\":{\"date\":\"7th Apr\",\"week\":\"Sat\"},\"09:3012:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"12:00\"},\"12:3014:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"12:30\",\"end_time\":\"14:30\"},\"15:0016:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"15:00\",\"end_time\":\"16:00\"},\"16:5017:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"16:50\",\"end_time\":\"17:30\"}},\"2018-04-10\":{\"day_format\":{\"date\":\"10th Apr\",\"week\":\"Tue\"},\"09:3012:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"12:30\"},\"13:3016:40\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"13:30\",\"end_time\":\"16:40\"}},\"2018-04-11\":{\"day_format\":{\"date\":\"11th Apr\",\"week\":\"Wed\"},\"09:3013:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"13:30\"},\"14:3017:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"14:30\",\"end_time\":\"17:30\"}},\"2018-04-12\":{\"day_format\":{\"date\":\"12th Apr\",\"week\":\"Thu\"},\"10:0013:00\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"10:00\",\"end_time\":\"13:00\"},\"14:0018:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"14:00\",\"end_time\":\"18:30\"}},\"2018-04-13\":{\"day_format\":{\"date\":\"13th Apr\",\"week\":\"Fri\"},\"09:3010:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"10:30\"},\"11:3012:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"11:30\",\"end_time\":\"12:30\"},\"13:0015:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"13:00\",\"end_time\":\"15:00\"},\"15:3017:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"15:30\",\"end_time\":\"17:30\"}},\"2018-04-14\":{\"day_format\":{\"date\":\"14th Apr\",\"week\":\"Sat\"},\"09:3012:00\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"09:30\",\"end_time\":\"12:00\"},\"12:3014:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"12:30\",\"end_time\":\"14:30\"},\"15:0017:30\":{\"staff\":{\"name\":\"Arina Grisutina\",\"id\":100000006},\"start_time\":\"15:00\",\"end_time\":\"17:30\"}},\"2018-04-17\":{\"day_format\":{\"date\":\"17th Apr\",\"week\":\"Tue\"},\"09:3012:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"09:30\",\"end_time\":\"12:30\"},\"13:3017:30\":{\"staff\":{\"name\":\"Ayesha Sunni\",\"id\":100000003},\"start_time\":\"13:30\",\"end_time\":\"17:30\"}}},\"treatments\":{\"5\":{\"DefaultTimeLength\":30,\"ProgramID\":1,\"NumDeducted\":1,\"ID\":5,\"Name\":\"The Brightening Peel (20 min)\",\"price\":55,\"itemid\":100004},\"6\":{\"DefaultTimeLength\":30,\"ProgramID\":1,\"NumDeducted\":1,\"ID\":6,\"Name\":\"The Hydrating Peel (20 min)\",\"price\":55,\"itemid\":100005},\"7\":{\"DefaultTimeLength\":30,\"ProgramID\":1,\"NumDeducted\":1,\"ID\":7,\"Name\":\"The Blemish Peel (20 min)\",\"price\":55,\"itemid\":100003},\"8\":{\"DefaultTimeLength\":10,\"ProgramID\":2,\"NumDeducted\":1,\"ID\":8,\"Name\":\"LED (10 min)\",\"price\":20,\"itemid\":100006},\"9\":{\"DefaultTimeLength\":10,\"ProgramID\":2,\"NumDeducted\":1,\"ID\":9,\"Name\":\"Eye Peel (10 min)\",\"price\":20,\"itemid\":100007},\"10\":{\"DefaultTimeLength\":10,\"ProgramID\":2,\"NumDeducted\":1,\"ID\":10,\"Name\":\"Neck Peel (10 min)\",\"price\":20,\"itemid\":100008},\"12\":{\"DefaultTimeLength\":10,\"ProgramID\":2,\"NumDeducted\":1,\"ID\":12,\"Name\":\"Hand Peel (10 min)\",\"price\":20,\"itemid\":100010},\"13\":{\"DefaultTimeLength\":30,\"ProgramID\":1,\"NumDeducted\":1,\"ID\":13,\"Name\":\"The Pre-Party Peel (20 min)\",\"price\":55,\"itemid\":100023},\"14\":{\"DefaultTimeLength\":10,\"ProgramID\":2,\"NumDeducted\":1,\"ID\":14,\"Name\":\"Facial Massage (10 min)\",\"price\":20,\"itemid\":100043}},\"locations\":{\"1\":\"marylebone\",\"2\":\"kensington\"},\"current_time\":\"14:30\",\"current_date\":\"2018-04-03\"}'),
(2, 'packs', '2018-04-03 12:51:29', '{\"treatments\":[{\"Price\":\"560.0000\",\"OnlinePrice\":\"560.0000\",\"TaxIncluded\":\"93.33\",\"ProgramID\":1,\"TaxRate\":\"0\",\"ProductID\":100022,\"ID\":\"100022\",\"Name\":\"Peel Treatment Package x 12 Treaments\",\"Count\":12},{\"Price\":\"210.0000\",\"OnlinePrice\":\"210.0000\",\"TaxIncluded\":\"35.00\",\"ProgramID\":1,\"TaxRate\":\"0\",\"ProductID\":100020,\"ID\":\"100020\",\"Name\":\"Peel Treatment Package x 4 Treaments\",\"Count\":4},{\"Price\":\"295.0000\",\"OnlinePrice\":\"295.0000\",\"TaxIncluded\":\"49.17\",\"ProgramID\":1,\"TaxRate\":\"0\",\"ProductID\":100021,\"ID\":\"100021\",\"Name\":\"Peel Treatment Package x 6 Treatments\",\"Count\":6}],\"addons\":[{\"Price\":\"215.0000\",\"OnlinePrice\":\"215.0000\",\"TaxIncluded\":\"35.83\",\"ProgramID\":2,\"TaxRate\":\"0\",\"ProductID\":100041,\"ID\":\"100041\",\"Name\":\"Mixed Add-ons Package x 12 Treatments\",\"Count\":12},{\"Price\":\"340.0000\",\"OnlinePrice\":\"340.0000\",\"TaxIncluded\":\"56.67\",\"ProgramID\":2,\"TaxRate\":\"0\",\"ProductID\":100042,\"ID\":\"100042\",\"Name\":\"Mixed Add-ons Package x 20 Treatments\",\"Count\":20},{\"Price\":\"75.0000\",\"OnlinePrice\":\"75.0000\",\"TaxIncluded\":\"12.50\",\"ProgramID\":2,\"TaxRate\":\"0\",\"ProductID\":100040,\"ID\":\"100040\",\"Name\":\"Mixed Add-ons Package x 4 Treatments\",\"Count\":4}]}');

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

--
-- Table structure for table `peel_packs`
--

CREATE TABLE `peel_packs` (
  `id` int(11) NOT NULL,
  `category` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - treatment; 2 - addons; 3 - subscription',
  `mb_id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `count` int(11) NOT NULL,
  `amount` float NOT NULL,
  `expiry` tinyint(4) NOT NULL,
  `is_visible` int(11) NOT NULL DEFAULT '1',
  `position` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `peel_packs`
--

INSERT INTO `peel_packs` (`id`, `category`, `mb_id`, `title`, `count`, `amount`, `expiry`, `is_visible`, `position`) VALUES
(1, 1, 100020, 'Peel Treatments', 4, 210, 3, 1, 1),
(2, 1, 100021, 'Peel Treatments', 6, 295, 6, 1, 1),
(3, 1, 100022, 'Peel Treatments', 12, 560, 12, 1, 1),
(4, 2, 100040, 'Peel Treatments', 4, 75, 3, 1, 1),
(5, 2, 100041, 'Peel Treatments', 12, 215, 6, 1, 1),
(6, 2, 100042, 'Peel Treatments', 20, 340, 12, 1, 1),
(7, 3, 100037, 'Monthly Peel(s)', 1, 53, 12, 1, 1),
(8, 3, 100038, 'Monthly Peel(s)', 2, 100, 12, 1, 1),
(9, 3, 100039, 'Monthly Peel(s)', 4, 175, 12, 1, 1);

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

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` int(11) NOT NULL,
  `mb_user_id` varchar(50) NOT NULL,
  `amount` float NOT NULL,
  `appointment_id` int(11) NOT NULL,
  `pack_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchases`
--

INSERT INTO `purchases` (`id`, `mb_user_id`, `amount`, `appointment_id`, `pack_id`, `date`) VALUES
(1, 'Brando_215122', 115, 1, 0, '2018-03-29 16:47:50'),
(2, 'Brando_215122', 155, 2, 0, '2018-03-29 17:27:00');

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

--
-- Table structure for table `reset_password`
--

CREATE TABLE `reset_password` (
  `id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `mb_user_id` varchar(255) NOT NULL,
  `used` int(1) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reset_password`
--

INSERT INTO `reset_password` (`id`, `token`, `mb_user_id`, `used`, `date`) VALUES
(2, '1e5b53d7bde96c712104cc17b3b6c939', 'Brando_215122', 1, '2018-03-13 11:32:57'),
(3, 'c58b724bf2a25452d84aa6e036040e99', 'Brando_215122', 1, '2018-03-13 11:33:55'),
(4, '30a555f0f1510afd823faa87cd39ee39', 'Brando_215122', 1, '2018-03-13 11:37:57'),
(5, '26171237711aaffe663b4c95f20f3f8d', '100000290', 1, '2018-03-13 11:38:19'),
(6, '18d23cbd65da9284eb1bd80a32124a6c', '100000290', 0, '2018-03-13 11:38:27'),
(7, 'dc908a3e1fd2944a05a1f7f3e86d504b', 'Brando_215122', 1, '2018-03-13 12:45:57'),
(8, '97ac0c99f9e346276b64f998c21458cc', 'Brando_215122', 1, '2018-03-13 12:57:43'),
(9, '421eccfa15ab9ae05f1fdcd11899f090', 'Brando_215122', 1, '2018-03-13 13:08:43'),
(10, 'fa8c7a3f75cd001e661d2bbf0fca0d06', 'Brando_215122', 0, '2018-03-14 14:18:35'),
(11, '9a0475517af0e4ffe9543ec71cc357e4', '100000335', 0, '2018-03-20 11:28:36'),
(12, '26c91f0da347c3a0505fd671006535e3', '100000293', 1, '2018-03-29 19:15:11');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `client_id` int(11) NOT NULL,
  `packs` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `appointments`
--
ALTER TABLE `appointments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `date` (`date`),
  ADD KEY `mb_user_id` (`mb_user_id`),
  ADD KEY `booking_time` (`booking_time`);

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mindbody_book_data`
--
ALTER TABLE `mindbody_book_data`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `peel_packs`
--
ALTER TABLE `peel_packs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `purchases`
--
ALTER TABLE `purchases`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reset_password`
--
ALTER TABLE `reset_password`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `appointments`
--
ALTER TABLE `appointments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `email_templates`
--
ALTER TABLE `email_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mindbody_book_data`
--
ALTER TABLE `mindbody_book_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `peel_packs`
--
ALTER TABLE `peel_packs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `purchases`
--
ALTER TABLE `purchases`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `reset_password`
--
ALTER TABLE `reset_password`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;