(7086,1984,'panels_data','a:3:{s:7:\"widgets\";a:5:{i:0;a:7:{s:5:\"title\";s:0:\"\";s:4:\"text\";s:926:\"<p><strong>Fees and subscriptions</strong> <br />Being a member of GOGA makes you part of a powerful global network of the Alumnae of Gayaza High School. Your Annual subscriptions enables GOGA to continue to carry out its activities and provide support to the School.</p>\n<p><strong>Membership Fees</strong><br />A Membership fee is payable by every person who joins the Association.<br />This is a one-off payment. You have a choice between Gold and Platinum Membership.</p>\n<p>Fees:<br />Platinum        £50       $60      UGX 200,000<br />Gold                 £25       $30      UGX 100,000</p>\n<p><strong>Subscription Fees</strong><br />Your annual membership subscription is due on 1 January. Every year, we will contact you in November about your renewal. Payment is due on 1 January and should be received before 31st March. </p>\n<p>Annually        £32     $40       UGX 120,000</p>\";s:20:\"text_selected_editor\";s:4:\"tmce\";s:5:\"autop\";b:1;s:12:\"_sow_form_id\";s:13:\"5a60faa900f4a\";s:19:\"_sow_form_timestamp\";s:13:\"1516307447740\";s:11:\"panels_info\";a:8:{s:5:\"class\";s:31:\"SiteOrigin_Widget_Editor_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:0;s:4:\"cell\";i:0;s:2:\"id\";i:0;s:9:\"widget_id\";s:36:\"43e4754f-a9b2-4e76-8f3b-4fa25d4f594a\";s:5:\"style\";a:4:{s:18:\"background_display\";s:4:\"tile\";s:17:\"content_alignment\";s:4:\"left\";s:11:\"title_color\";s:7:\"#443f3f\";s:14:\"headings_color\";s:7:\"#443f3f\";}s:10:\"cell_index\";i:0;}}i:1;a:9:{s:4:\"text\";s:19:\"Pay Gold Membership\";s:3:\"url\";s:50:\"http://www.gayazaoldgirls.com/shop/gold-membership\";s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:21:\"fontawesome-id-card-o\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:405;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"design\";a:12:{s:5:\"width\";s:5:\"300px\";s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:6:\"center\";s:5:\"theme\";s:4:\"atom\";s:12:\"button_color\";s:7:\"#ff0000\";s:10:\"text_color\";b:0;s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:1:\"1\";s:8:\"rounding\";s:4:\"0.25\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:4:\"open\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"_sow_form_id\";s:13:\"5a60fdb82d6cd\";s:19:\"_sow_form_timestamp\";s:13:\"1516453328585\";s:10:\"new_window\";b:0;s:11:\"panels_info\";a:8:{s:5:\"class\";s:31:\"SiteOrigin_Widget_Button_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:0;s:2:\"id\";i:1;s:9:\"widget_id\";s:36:\"14e92b1f-8609-46ed-8193-32ed13167443\";s:5:\"style\";a:4:{s:18:\"background_display\";s:4:\"tile\";s:17:\"content_alignment\";s:4:\"left\";s:11:\"title_color\";s:7:\"#443f3f\";s:14:\"headings_color\";s:7:\"#443f3f\";}s:10:\"cell_index\";i:0;}}i:2;a:9:{s:4:\"text\";s:23:\"Pay Platinum Membership\";s:3:\"url\";s:54:\"http://www.gayazaoldgirls.com/shop/platinum-membership\";s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:21:\"fontawesome-id-card-o\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:1897;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"design\";a:12:{s:5:\"width\";s:5:\"300px\";s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:6:\"center\";s:5:\"theme\";s:4:\"atom\";s:12:\"button_color\";s:7:\"#ff0000\";s:10:\"text_color\";b:0;s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:1:\"1\";s:8:\"rounding\";s:4:\"0.25\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:4:\"open\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"_sow_form_id\";s:13:\"5a610004823b4\";s:19:\"_sow_form_timestamp\";s:13:\"1516453294431\";s:10:\"new_window\";b:0;s:11:\"panels_info\";a:8:{s:5:\"class\";s:31:\"SiteOrigin_Widget_Button_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:1;s:4:\"cell\";i:1;s:2:\"id\";i:2;s:9:\"widget_id\";s:36:\"d58649cd-c8f5-46ef-820e-d0cdfa0c883a\";s:5:\"style\";a:4:{s:18:\"background_display\";s:4:\"tile\";s:17:\"content_alignment\";s:4:\"left\";s:11:\"title_color\";s:7:\"#443f3f\";s:14:\"headings_color\";s:7:\"#443f3f\";}s:10:\"cell_index\";i:0;}}i:3;a:9:{s:4:\"text\";s:17:\"Pay Subscriptions\";s:3:\"url\";s:48:\"http://www.gayazaoldgirls.com/shop/subscriptions\";s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:21:\"fontawesome-id-card-o\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:1923;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"design\";a:12:{s:5:\"width\";s:5:\"300px\";s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:6:\"center\";s:5:\"theme\";s:4:\"atom\";s:12:\"button_color\";s:7:\"#ff0000\";s:10:\"text_color\";b:0;s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:1:\"1\";s:8:\"rounding\";s:4:\"0.25\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:4:\"open\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"_sow_form_id\";s:13:\"5a633bab4a577\";s:19:\"_sow_form_timestamp\";s:13:\"1516453223427\";s:10:\"new_window\";b:0;s:11:\"panels_info\";a:8:{s:5:\"class\";s:31:\"SiteOrigin_Widget_Button_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:2;s:4:\"cell\";i:0;s:2:\"id\";i:3;s:9:\"widget_id\";s:36:\"17b59934-7b92-410c-a088-95ea728257f6\";s:5:\"style\";a:4:{s:18:\"background_display\";s:4:\"tile\";s:17:\"content_alignment\";s:4:\"left\";s:11:\"title_color\";s:7:\"#443f3f\";s:14:\"headings_color\";s:7:\"#443f3f\";}s:10:\"cell_index\";i:0;}}i:4;a:9:{s:4:\"text\";s:52:\"Paying by Bank Transfer?  Find our Bank Details Here\";s:3:\"url\";s:47:\"http://www.gayazaoldgirls.com/goga-bank-details\";s:10:\"new_window\";b:1;s:11:\"button_icon\";a:5:{s:13:\"icon_selected\";s:16:\"fontawesome-bank\";s:10:\"icon_color\";b:0;s:4:\"icon\";i:0;s:14:\"icon_placement\";s:4:\"left\";s:24:\"so_field_container_state\";s:4:\"open\";}s:6:\"design\";a:12:{s:5:\"width\";s:5:\"300px\";s:10:\"width_unit\";s:2:\"px\";s:5:\"align\";s:6:\"center\";s:5:\"theme\";s:4:\"atom\";s:12:\"button_color\";s:7:\"#ff0000\";s:10:\"text_color\";b:0;s:5:\"hover\";b:1;s:4:\"font\";s:7:\"default\";s:9:\"font_size\";s:1:\"1\";s:8:\"rounding\";s:4:\"0.25\";s:7:\"padding\";s:1:\"1\";s:24:\"so_field_container_state\";s:4:\"open\";}s:10:\"attributes\";a:6:{s:2:\"id\";s:0:\"\";s:7:\"classes\";s:0:\"\";s:5:\"title\";s:0:\"\";s:7:\"onclick\";s:0:\"\";s:3:\"rel\";s:0:\"\";s:24:\"so_field_container_state\";s:6:\"closed\";}s:12:\"_sow_form_id\";s:13:\"5a63709563bd9\";s:19:\"_sow_form_timestamp\";s:13:\"1516466502964\";s:11:\"panels_info\";a:8:{s:5:\"class\";s:31:\"SiteOrigin_Widget_Button_Widget\";s:3:\"raw\";b:0;s:4:\"grid\";i:2;s:4:\"cell\";i:1;s:2:\"id\";i:4;s:9:\"widget_id\";s:36:\"49ec0002-587b-4724-93ad-8edb1ef02951\";s:5:\"style\";a:4:{s:18:\"background_display\";s:4:\"tile\";s:17:\"content_alignment\";s:4:\"left\";s:11:\"title_color\";s:7:\"#443f3f\";s:14:\"headings_color\";s:7:\"#443f3f\";}s:10:\"cell_index\";i:0;}}}s:5:\"grids\";a:3:{i:0;a:4:{s:5:\"cells\";i:1;s:5:\"style\";a:6:{s:7:\"padding\";s:3:\"0px\";s:11:\"row_stretch\";s:4:\"full\";s:14:\"cell_alignment\";s:10:\"flex-start\";s:5:\"align\";s:0:\"\";s:7:\"overlay\";s:0:\"\";s:13:\"overlay_color\";s:7:\"#000000\";}s:5:\"ratio\";i:1;s:15:\"ratio_direction\";s:5:\"right\";}i:1;a:4:{s:5:\"cells\";i:3;s:5:\"style\";a:6:{s:7:\"padding\";s:4:\"10px\";s:11:\"row_stretch\";s:4:\"full\";s:14:\"cell_alignment\";s:10:\"flex-start\";s:5:\"align\";s:0:\"\";s:7:\"overlay\";s:0:\"\";s:13:\"overlay_color\";s:7:\"#000000\";}s:5:\"ratio\";i:1;s:15:\"ratio_direction\";s:5:\"right\";}i:2;a:4:{s:5:\"cells\";i:3;s:5:\"style\";a:6:{s:7:\"padding\";s:4:\"10px\";s:11:\"row_stretch\";s:4:\"full\";s:14:\"cell_alignment\";s:10:\"flex-start\";s:5:\"align\";s:0:\"\";s:7:\"overlay\";s:0:\"\";s:13:\"overlay_color\";s:7:\"#000000\";}s:5:\"ratio\";i:1;s:15:\"ratio_direction\";s:5:\"right\";}}s:10:\"grid_cells\";a:7:{i:0;a:4:{s:4:\"grid\";i:0;s:5:\"index\";i:0;s:6:\"weight\";i:1;s:5:\"style\";a:0:{}}i:1;a:4:{s:4:\"grid\";i:1;s:5:\"index\";i:0;s:6:\"weight\";d:0.40000000000000002220446049250313080847263336181640625;s:5:\"style\";a:2:{s:18:\"background_display\";s:4:\"tile\";s:18:\"vertical_alignment\";s:4:\"auto\";}}i:2;a:4:{s:4:\"grid\";i:1;s:5:\"index\";i:1;s:6:\"weight\";d:0.40000000000000002220446049250313080847263336181640625;s:5:\"style\";a:0:{}}i:3;a:4:{s:4:\"grid\";i:1;s:5:\"index\";i:2;s:6:\"weight\";d:0.200000000000000011102230246251565404236316680908203125;s:5:\"style\";a:0:{}}i:4;a:4:{s:4:\"grid\";i:2;s:5:\"index\";i:0;s:6:\"weight\";d:0.40000000000000002220446049250313080847263336181640625;s:5:\"style\";a:2:{s:18:\"background_display\";s:4:\"tile\";s:18:\"vertical_alignment\";s:4:\"auto\";}}i:5;a:4:{s:4:\"grid\";i:2;s:5:\"index\";i:1;s:6:\"weight\";d:0.40000000000000002220446049250313080847263336181640625;s:5:\"style\";a:0:{}}i:6;a:4:{s:4:\"grid\";i:2;s:5:\"index\";i:2;s:6:\"weight\";d:0.200000000000000011102230246251565404236316680908203125;s:5:\"style\";a:0:{}}}}'),(7087,1985,'_wp_trash_meta_status','publish'),(7088,1985,'_wp_trash_meta_time','1516791749'),(7089,1986,'_wp_trash_meta_status','publish'),(7090,1986,'_wp_trash_meta_time','1516791848'),(7099,1990,'_wp_attached_file','2018/01/card-invitation.png'),(7098,1989,'_edit_last','1'),(7097,1989,'_edit_lock','1517304466:1'),(7100,1990,'_wp_attachment_metadata','a:5:{s:5:\"width\";i:684;s:6:\"height\";i:769;s:4:\"file\";s:27:\"2018/01/card-invitation.png\";s:5:\"sizes\";a:14:{s:9:\"thumbnail\";a:4:{s:4:\"file\";s:27:\"card-invitation-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";}s:6:\"medium\";a:4:{s:4:\"file\";s:27:\"card-invitation-267x300.png\";s:5:\"width\";i:267;s:6:\"height\";i:300;s:9:\"mime-type\";s:9:\"image/png\";}s:14:\"shop_thumbnail\";a:4:{s:4:\"file\";s:27:\"card-invitation-180x180.png\";s:5:\"width\";i:180;s:6:\"height\";i:180;s:9:\"mime-type\";s:9:\"image/png\";}s:12:\"shop_catalog\";a:4:{s:4:\"file\";s:27:\"card-invitation-300x300.png\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:9:\"image/png\";}s:11:\"shop_single\";a:4:{s:4:\"file\";s:27:\"card-invitation-600x600.png\";s:5:\"width\";i:600;s:6:\"height\";i:600;s:9:\"mime-type\";s:9:\"image/png\";}s:19:\"sydney-medium-thumb\";a:4:{s:4:\"file\";s:27:\"card-invitation-550x400.png\";s:5:\"width\";i:550;s:6:\"height\";i:400;s:9:\"mime-type\";s:9:\"image/png\";}s:18:\"sydney-small-thumb\";a:4:{s:4:\"file\";s:27:\"card-invitation-230x259.png\";s:5:\"width\";i:230;s:6:\"height\";i:259;s:9:\"mime-type\";s:9:\"image/png\";}s:20:\"sydney-service-thumb\";a:4:{s:4:\"file\";s:27:\"card-invitation-350x393.png\";s:5:\"width\";i:350;s:6:\"height\";i:393;s:9:\"mime-type\";s:9:\"image/png\";}s:16:\"sydney-mas-thumb\";a:4:{s:4:\"file\";s:27:\"card-invitation-480x540.png\";s:5:\"width\";i:480;s:6:\"height\";i:540;s:9:\"mime-type\";s:9:\"image/png\";}s:14:\"rpwe-thumbnail\";a:4:{s:4:\"file\";s:25:\"card-invitation-45x45.png\";s:5:\"width\";i:45;s:6:\"height\";i:45;s:9:\"mime-type\";s:9:\"image/png\";}s:19:\"default_header_mail\";a:4:{s:4:\"file\";s:27:\"card-invitation-420x203.png\";s:5:\"width\";i:420;s:6:\"height\";i:203;s:9:\"mime-type\";s:9:\"image/png\";}s:20:\"default_content_mail\";a:4:{s:4:\"file\";s:27:\"card-invitation-601x340.png\";s:5:\"width\";i:601;s:6:\"height\";i:340;s:9:\"mime-type\";s:9:\"image/png\";}s:19:\"default_footer_mail\";a:4:{s:4:\"file\";s:25:\"card-invitation-66x43.png\";s:5:\"width\";i:66;s:6:\"height\";i:43;s:9:\"mime-type\";s:9:\"image/png\";}s:20:\"sow-carousel-default\";a:4:{s:4:\"file\";s:27:\"card-invitation-272x182.png\";s:5:\"width\";i:272;s:6:\"height\";i:182;s:9:\"mime-type\";s:9:\"image/png\";}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),(7101,1989,'_thumbnail_id','1990'),(7102,1989,'_wp_page_template','default'),(7110,1995,'_name','Jared Streets'),(7109,1995,'_email','TheoMessina@gmail.com'),(7111,1995,'_props','a:0:{}'),(7112,1995,'_last_contacted','2018-02-04 20:07:53'),(7113,1996,'_subject','Make Insane Gains from “Bitcoin Loophole”'),(7114,1996,'_from','Jared Streets <TheoMessina@gmail.com>'),(7115,1996,'_from_name','Jared Streets'),(7116,1996,'_from_email','TheoMessina@gmail.com'),(7117,1996,'_field_your-name','Jared Streets'),(7118,1996,'_field_your-email','TheoMessina@gmail.com'),(7119,1996,'_field_your-subject','Make Insane Gains from “Bitcoin Loophole”'),(7120,1996,'_field_your-message','This is crazy and could change your life overnight. Pat Kendrick, a retired economist, lead researcher and head of the Crypto Mining & Trading Division at the Cryptocurrency Institute reveals cryptocurrency profit “loophole”, that can completely transform your net worth. The best thing is the “loophole” works for everyday folks without a lot of money to risk and with zero experience. Don\'t miss this once in a lifetime opportunity; http://bit.ly/-cryptocurrency'),(7121,1996,'_fields','a:4:{s:9:\"your-name\";N;s:10:\"your-email\";N;s:12:\"your-subject\";N;s:12:\"your-message\";N;}'),(7122,1996,'_meta','a:11:{s:9:\"remote_ip\";s:14:\"173.208.39.191\";s:10:\"user_agent\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36\";s:3:\"url\";s:38:\"https://gayazaoldgirls.com/contact-us/\";s:4:\"date\";s:17:\"4th February 2018\";s:4:\"time\";s:5:\"20:07\";s:7:\"post_id\";s:2:\"29\";s:9:\"post_name\";s:10:\"contact-us\";s:10:\"post_title\";s:10:\"Contact Us\";s:8:\"post_url\";s:38:\"https://gayazaoldgirls.com/contact-us/\";s:11:\"post_author\";s:8:\"Jennifer\";s:17:\"post_author_email\";s:21:\"2jennifer.m@gmail.com\";}'),(7123,1996,'_akismet',NULL),(7124,1996,'_consent','a:0:{}'),(7125,1997,'_email','Matthew5112@mail.com'),(7126,1997,'_name','Matt Prince'),(7127,1997,'_props','a:0:{}'),(7128,1997,'_last_contacted','2018-02-06 01:14:43'),(7129,1998,'_subject','Get More Website Visitors on Autopilot'),(7130,1998,'_from','Matt Prince <Matthew5112@mail.com>'),(7131,1998,'_from_name','Matt Prince'),(7132,1998,'_from_email','Matthew5112@mail.com'),(7133,1998,'_field_your-name','Matt Prince'),(7134,1998,'_field_your-email','Matthew5112@mail.com'),(7135,1998,'_field_your-subject','Get More Website Visitors on Autopilot'),(7136,1998,'_field_your-message','Ever Wonder How the Top sites on Google get to the First Page and Stay There ? Answer is they are using Submission tools such as SeNuke and Magicsubmitter to work around the Search engines algorithm. Find out More:  http://bit.ly/2DC43OR '),(7137,1998,'_fields','a:4:{s:9:\"your-name\";N;s:10:\"your-email\";N;s:12:\"your-subject\";N;s:12:\"your-message\";N;}'),(7138,1998,'_meta','a:11:{s:9:\"remote_ip\";s:15:\"192.126.160.138\";s:10:\"user_agent\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36\";s:3:\"url\";s:38:\"https://gayazaoldgirls.com/contact-us/\";s:4:\"date\";s:17:\"6th February 2018\";s:4:\"time\";s:5:\"01:14\";s:7:\"post_id\";s:2:\"29\";s:9:\"post_name\";s:10:\"contact-us\";s:10:\"post_title\";s:10:\"Contact Us\";s:8:\"post_url\";s:38:\"https://gayazaoldgirls.com/contact-us/\";s:11:\"post_author\";s:8:\"Jennifer\";s:17:\"post_author_email\";s:21:\"2jennifer.m@gmail.com\";}'),(7139,1998,'_akismet',NULL),(7140,1998,'_consent','a:0:{}');

--
-- Table structure for table `wpba_qsot_event_zone_to_order`
--

CREATE TABLE `wpba_qsot_event_zone_to_order` (
  `event_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `quantity` smallint(5) unsigned NOT NULL,
  `state` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `since` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `mille` smallint(4) NOT NULL DEFAULT '0',
  `session_customer_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ticket_type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `order_item_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  KEY `evt_id` (`event_id`),
  KEY `ord_id` (`order_id`),
  KEY `oiid` (`order_item_id`),
  KEY `stt` (`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_qsot_event_zone_to_order`
--

INSERT INTO `wpba_qsot_event_zone_to_order` VALUES (1226,0,1,'reserved','2017-12-22 21:21:14',8459,'1',1200,0);

--
-- Table structure for table `wpba_qsot_ticket_codes`
--

CREATE TABLE `wpba_qsot_ticket_codes` (
  `order_item_id` bigint(20) unsigned NOT NULL,
  `ticket_code` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `tc` (`ticket_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_qsot_ticket_codes`
--


--
-- Table structure for table `wpba_term_relationships`
--

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

--
-- Dumping data for table `wpba_term_relationships`
--

INSERT INTO `wpba_term_relationships` VALUES (1709,12,0),(1858,52,0),(23,2,0),(467,11,0),(31,2,0),(381,15,0),(221,10,0),(222,10,0),(223,10,0),(224,10,0),(225,10,0),(226,10,0),(465,11,0),(422,2,0),(1860,27,0),(421,2,0),(1200,42,0),(1627,49,0),(1184,45,0),(1184,27,0),(463,11,0),(1628,50,0),(1625,48,0),(373,12,0),(1184,43,0),(1195,44,0),(1195,45,0),(1942,27,0),(960,41,0),(1859,27,0),(461,11,0),(1481,2,0),(1719,12,0),(1124,41,0),(1714,41,0),(1790,41,0),(1669,52,0),(1794,2,0),(974,26,0),(1856,2,0),(1212,42,0),(1181,2,0),(469,11,0),(471,11,0),(473,11,0),(475,11,0),(477,11,0),(479,11,0),(383,16,0),(559,2,0),(625,13,0),(561,12,0),(634,13,0),(385,18,0),(391,19,0),(392,20,0),(1885,2,0),(394,21,0),(659,22,0),(657,24,0),(397,23,0),(702,25,0),(384,17,0),(1996,52,0),(1979,2,0),(1914,41,0),(1195,27,0),(1978,2,0),(1981,52,0),(1886,41,0),(1989,41,0),(1998,52,0),(2000,52,0),(2003,52,0),(2005,52,0),(2007,52,0);

--
-- Table structure for table `wpba_term_taxonomy`
--

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

--
-- Dumping data for table `wpba_term_taxonomy`
--

INSERT INTO `wpba_term_taxonomy` VALUES (1,1,'category','',0,0),(2,2,'nav_menu','',0,12),(18,18,'category','',0,1),(14,14,'post_format','',0,0),(12,12,'category','',0,4),(10,10,'nav_menu','',0,6),(17,17,'category','',0,1),(15,15,'category','',0,1),(16,16,'category','',0,1),(13,13,'category','',0,2),(19,19,'category','',0,1),(20,20,'category','',0,1),(21,21,'category','',0,1),(22,22,'category','',0,1),(23,23,'category','',0,1),(24,24,'category','',0,1),(25,25,'category','',0,1),(26,26,'category','',0,1),(27,27,'product_type','',0,5),(28,28,'product_type','',0,0),(29,29,'product_type','',0,0),(30,30,'product_type','',0,0),(31,31,'product_visibility','',0,0),(32,32,'product_visibility','',0,0),(33,33,'product_visibility','',0,0),(34,34,'product_visibility','',0,0),(35,35,'product_visibility','',0,0),(36,36,'product_visibility','',0,0),(37,37,'product_visibility','',0,0),(38,38,'product_visibility','',0,0),(39,39,'product_visibility','',0,0),(41,41,'category','',0,7),(42,42,'product_type','',0,2),(43,43,'product_cat','',0,1),(44,44,'product_cat','',0,1),(45,45,'product_shipping_class','Books and clothing',0,2),(46,46,'product_shipping_class','Letters',0,0),(47,47,'product_cat','',0,0),(48,48,'category','',0,1),(49,49,'category','',0,1),(50,50,'category','',0,1),(51,51,'flamingo_inbound_channel','',0,0),(52,52,'flamingo_inbound_channel','',51,9),(53,53,'product_cat','',0,0);

--
-- Table structure for table `wpba_termmeta`
--

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

--
-- Dumping data for table `wpba_termmeta`
--

INSERT INTO `wpba_termmeta` VALUES (1,43,'order','0'),(2,43,'product_count_product_cat','1'),(3,44,'order','0'),(4,44,'product_count_product_cat','1'),(5,47,'order','0'),(6,47,'product_count_product_cat','0');

--
-- Table structure for table `wpba_terms`
--

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

--
-- Dumping data for table `wpba_terms`
--

INSERT INTO `wpba_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Menu 1','menu-1',0),(15,'Employee1','employee1',0),(14,'post-format-aside','post-format-aside',0),(13,'Type A','type-a',0),(12,'Facilities','facilities',0),(10,'Social','social',0),(16,'Employee2','employee2',0),(17,'Employee3','employee3',0),(18,'Employee4','employee4',0),(19,'Employee5','employee5',0),(20,'Employee6','employee6',0),(21,'Employee7','employee7',0),(22,'Employee8','employee8',0),(23,'Employee9','employee9',0),(24,'Employee10','employee10',0),(25,'Employee11','employee11',0),(26,'Employee12','employee12',0),(27,'simple','simple',0),(28,'grouped','grouped',0),(29,'variable','variable',0),(30,'external','external',0),(31,'exclude-from-search','exclude-from-search',0),(32,'exclude-from-catalog','exclude-from-catalog',0),(33,'featured','featured',0),(34,'outofstock','outofstock',0),(35,'rated-1','rated-1',0),(36,'rated-2','rated-2',0),(37,'rated-3','rated-3',0),(38,'rated-4','rated-4',0),(39,'rated-5','rated-5',0),(41,'Activities','activities',0),(42,'ticket-event','ticket-event',0),(43,'Books','books',0),(44,'Clothing','clothing',0),(45,'Royal Mail Parcel','royal-mail-parcel',0),(46,'Royal Mail Letters','royal-mail-letters',0),(47,'Ticket','ticket',0),(48,'Employee13','employee13',0),(49,'Employee14','employee14',0),(50,'Employee15','employee15',0),(51,'Contact Form 7','contact-form-7',0),(52,'Contact form 1','contact-form-1',0),(53,'Uncategorized','uncategorized',0);

--
-- Table structure for table `wpba_usermeta`
--

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

--
-- Dumping data for table `wpba_usermeta`
--

INSERT INTO `wpba_usermeta` VALUES (1,1,'nickname','Jennifer'),(2,1,'first_name','JENNIFER'),(3,1,'last_name','MUWONGE'),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'comment_shortcuts','false'),(7,1,'admin_color','fresh'),(8,1,'use_ssl','0'),(9,1,'show_admin_bar_front','true'),(10,1,'locale',''),(11,1,'wpba_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(12,1,'wpba_user_level','10'),(13,1,'dismissed_wp_pointers','theme_editor_notice'),(14,1,'show_welcome_panel','0'),(219,1,'session_tokens','a:1:{s:64:\"9219ccbe41562a4731dc0c70582af8f20858324ff1acae5df89553f4521362a0\";a:4:{s:10:\"expiration\";i:1519065735;s:2:\"ip\";s:12:\"2.122.85.167\";s:2:\"ua\";s:129:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 Edge/16.16299\";s:5:\"login\";i:1518892935;}}'),(16,1,'wpba_dashboard_quick_press_last_post_id','2001'),(17,1,'community-events-location','a:1:{s:2:\"ip\";s:10:\"2.122.85.0\";}'),(18,1,'wpba_user-settings','libraryContent=browse&editor=tinymce&hidetb=1&editor_plain_text_paste_warning=2&align=right&siteorigin_panels_setting_tab=general&post_dfw=off'),(19,1,'wpba_user-settings-time','1516143611'),(20,1,'managenav-menuscolumnshidden','a:5:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";i:4;s:15:\"title-attribute\";}'),(21,1,'metaboxhidden_nav-menus','a:2:{i:0;s:12:\"add-post_tag\";i:1;s:15:\"add-post_format\";}'),(22,1,'nav_menu_recently_edited','2'),(24,2,'nickname','vlad'),(25,2,'first_name',''),(26,2,'last_name',''),(27,2,'description',''),(28,2,'rich_editing','true'),(29,2,'comment_shortcuts','false'),(30,2,'admin_color','fresh'),(31,2,'use_ssl','0'),(32,2,'show_admin_bar_front','true'),(33,2,'locale',''),(34,2,'wpba_capabilities','a:1:{s:10:\"subscriber\";b:1;}'),(35,2,'wpba_user_level','0'),(36,2,'dismissed_wp_pointers',''),(37,3,'nickname','chuck'),(38,3,'first_name',''),(39,3,'last_name',''),(40,3,'description',''),(41,3,'rich_editing','true'),(42,3,'comment_shortcuts','false'),(43,3,'admin_color','fresh'),(44,3,'use_ssl','0'),(45,3,'show_admin_bar_front','true'),(46,3,'locale',''),(47,3,'wpba_capabilities','a:1:{s:10:\"subscriber\";b:1;}'),(48,3,'wpba_user_level','0'),(49,3,'dismissed_wp_pointers',''),(50,1,'closedpostboxes_page','a:2:{i:0;s:12:\"revisionsdiv\";i:1;s:14:\"twitter-custom\";}'),(51,1,'metaboxhidden_page','a:4:{i:0;s:16:\"commentstatusdiv\";i:1;s:11:\"commentsdiv\";i:2;s:7:\"slugdiv\";i:3;s:9:\"authordiv\";}'),(53,1,'teasers_dismissed','a:1:{s:14:\"sow-image-grid\";b:1;}'),(54,1,'closedpostboxes_dashboard','a:2:{i:0;s:18:\"dashboard_activity\";i:1;s:17:\"dashboard_primary\";}'),(55,1,'metaboxhidden_dashboard','a:1:{i:0;s:17:\"dashboard_primary\";}'),(94,1,'closedpostboxes_product','a:3:{i:0;s:14:\"product_catdiv\";i:1;s:19:\"tagsdiv-product_tag\";i:2;s:14:\"twitter-custom\";}'),(57,1,'closedpostboxes_tmm','a:0:{}'),(58,1,'metaboxhidden_tmm','a:1:{i:0;s:7:\"slugdiv\";}'),(69,1,'closedpostboxes_post','a:3:{i:0;s:16:\"tagsdiv-post_tag\";i:1;s:10:\"postcustom\";i:2;s:14:\"twitter-custom\";}'),(70,1,'metaboxhidden_post','a:7:{i:0;s:16:\"so-panels-panels\";i:1;s:12:\"revisionsdiv\";i:2;s:11:\"postexcerpt\";i:3;s:13:\"trackbacksdiv\";i:4;s:11:\"commentsdiv\";i:5;s:7:\"slugdiv\";i:6;s:9:\"authordiv\";}'),(76,1,'so_panels_directory_enabled','1'),(78,1,'jetpack_tracks_anon_id','jetpack:mtOndXGzQ8GOei4SWWIN+FhL'),(130,1,'closedpostboxes_qsot-venue','a:2:{i:0;s:11:\"postexcerpt\";i:1;s:14:\"twitter-custom\";}'),(82,1,'closedpostboxes_team_mf','a:1:{i:0;s:14:\"twitter-custom\";}'),(83,1,'metaboxhidden_team_mf','a:1:{i:0;s:7:\"slugdiv\";}'),(84,1,'closedpostboxes_team_mf_team','a:1:{i:0;s:14:\"twitter-custom\";}'),(85,1,'metaboxhidden_team_mf_team','a:1:{i:0;s:7:\"slugdiv\";}'),(86,1,'closedpostboxes_employees','a:1:{i:0;s:14:\"twitter-custom\";}'),(87,1,'metaboxhidden_employees','a:1:{i:0;s:7:\"slugdiv\";}'),(95,1,'metaboxhidden_product','a:2:{i:0;s:10:\"postcustom\";i:1;s:7:\"slugdiv\";}'),(112,1,'billing_phone','07799485741'),(131,1,'metaboxhidden_qsot-venue','a:1:{i:0;s:7:\"slugdiv\";}'),(132,1,'closedpostboxes_qsot-event','a:1:{i:0;s:14:\"twitter-custom\";}'),(133,1,'metaboxhidden_qsot-event','a:1:{i:0;s:7:\"slugdiv\";}'),(101,1,'syntax_highlighting','true'),(102,1,'last_update','1518783398'),(103,1,'billing_first_name','JENNIFER'),(104,1,'billing_last_name','MUWONGE'),(105,1,'billing_company','NUMBERSBALANCED'),(106,1,'billing_address_1','10 THE COLTSFOOT'),(107,1,'billing_city','HEMEL HEMPSTEAD'),(108,1,'billing_state','HERTS'),(109,1,'billing_postcode','HP1 2DF'),(110,1,'billing_country','GB'),(111,1,'billing_email','2jennifer.m@gmail.com'),(113,1,'shipping_first_name','JENNIFER'),(114,1,'shipping_last_name','MUWONGE'),(115,1,'shipping_company','NUMBERSBALANCED'),(116,1,'shipping_address_1','10 THE COLTSFOOT'),(117,1,'shipping_city','HEMEL HEMPSTEAD'),(118,1,'shipping_state','HERTS'),(119,1,'shipping_postcode','HP1 2DF'),(120,1,'shipping_country','GB'),(170,1,'shipping_method','a:1:{i:0;s:11:\"flat_rate:1\";}'),(146,1,'closedpostboxes_shop_order','a:0:{}'),(147,1,'metaboxhidden_shop_order','a:0:{}'),(148,1,'twitter',''),(149,1,'periscope',''),(150,1,'paying_customer',''),(135,1,'manageedit-tix_attendeecolumnshidden','a:4:{i:0;s:15:\"tix_order_total\";i:1;s:16:\"tix_ticket_price\";i:2;s:15:\"tix_reservation\";i:3;s:10:\"tix_coupon\";}'),(136,1,'manageedit-tix_ticketcolumnshidden','a:2:{i:0;s:18:\"tix_purchase_count\";i:1;s:12:\"tix_reserved\";}'),(171,1,'_woocommerce_persistent_cart_1','a:1:{s:4:\"cart\";a:0:{}}'),(175,1,'closedpostboxes_event','a:1:{i:0;s:14:\"twitter-custom\";}'),(176,1,'metaboxhidden_event','a:1:{i:0;s:7:\"slugdiv\";}'),(177,3,'_order_count','0'),(178,3,'_money_spent','0'),(183,2,'_order_count','0'),(184,2,'_money_spent','0'),(185,1,'meta-box-order_page','a:3:{s:4:\"side\";s:36:\"submitdiv,pageparentdiv,postimagediv\";s:6:\"normal\";s:70:\"revisionsdiv,postcustom,commentstatusdiv,commentsdiv,slugdiv,authordiv\";s:8:\"advanced\";s:14:\"twitter-custom\";}'),(186,1,'screen_layout_page','2'),(187,1,'closedpostboxes_projects','a:2:{i:0;s:11:\"postexcerpt\";i:1;s:14:\"twitter-custom\";}'),(188,1,'metaboxhidden_projects','a:1:{i:0;s:7:\"slugdiv\";}');

--
-- Table structure for table `wpba_wc_download_log`
--

CREATE TABLE `wpba_wc_download_log` (
  `download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`download_log_id`),
  KEY `permission_id` (`permission_id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_wc_download_log`
--


--
-- Table structure for table `wpba_wc_webhooks`
--

CREATE TABLE `wpba_wc_webhooks` (
  `webhook_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `delivery_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `topic` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `api_version` smallint(4) NOT NULL,
  `failure_count` smallint(10) NOT NULL DEFAULT '0',
  `pending_delivery` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`webhook_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_wc_webhooks`
--


--
-- Table structure for table `wpba_woocommerce_api_keys`
--

CREATE TABLE `wpba_woocommerce_api_keys` (
  `key_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `description` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `consumer_key` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `consumer_secret` char(43) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nonces` longtext COLLATE utf8mb4_unicode_ci,
  `truncated_key` char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_access` datetime DEFAULT NULL,
  PRIMARY KEY (`key_id`),
  KEY `consumer_key` (`consumer_key`),
  KEY `consumer_secret` (`consumer_secret`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_api_keys`
--


--
-- Table structure for table `wpba_woocommerce_attribute_taxonomies`
--

CREATE TABLE `wpba_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_label` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attribute_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_orderby` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attribute_public` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`attribute_id`),
  KEY `attribute_name` (`attribute_name`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_attribute_taxonomies`
--


--
-- Table structure for table `wpba_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `wpba_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `download_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `order_key` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_email` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`permission_id`),
  KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
  KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_downloadable_product_permissions`
--


--
-- Table structure for table `wpba_woocommerce_log`
--

CREATE TABLE `wpba_woocommerce_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `level` smallint(4) NOT NULL,
  `source` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `context` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`log_id`),
  KEY `level` (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_log`
--


--
-- Table structure for table `wpba_woocommerce_order_itemmeta`
--

CREATE TABLE `wpba_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `order_item_id` (`order_item_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=MyISAM AUTO_INCREMENT=287 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_order_itemmeta`
--

INSERT INTO `wpba_woocommerce_order_itemmeta` VALUES (1,1,'_product_id','1200'),(2,1,'_variation_id','0'),(3,1,'_qty','1'),(4,1,'_tax_class',''),(5,1,'_line_subtotal','50'),(6,1,'_line_subtotal_tax','0'),(7,1,'_line_total','50'),(8,1,'_line_tax','0'),(9,1,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(10,1,'_product_type','ticket-event'),(11,2,'method_id','flat_rate:1'),(12,2,'cost','0.00'),(13,2,'total_tax','0'),(14,2,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(15,2,'Items','GOGA London Fundraising Dinner 14th April 2018 &times; 1'),(16,3,'_product_id','1200'),(17,3,'_variation_id','0'),(18,3,'_qty','1'),(19,3,'_tax_class',''),(20,3,'_line_subtotal','1'),(21,3,'_line_subtotal_tax','0'),(22,3,'_line_total','1'),(23,3,'_line_tax','0'),(24,3,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(25,3,'_product_type','ticket-event'),(26,4,'method_id','flat_rate:1'),(27,4,'cost','0.00'),(28,4,'total_tax','0'),(29,4,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(30,4,'Items','GOGA Fundraising Dinner Ticket &times; 1'),(31,3,'_event_id','1457'),(171,1,'_event_id','1482'),(256,29,'_product_id','1200'),(257,29,'_variation_id','0'),(258,29,'_qty','1'),(259,29,'_tax_class',''),(260,29,'_line_subtotal','50'),(261,29,'_line_subtotal_tax','0'),(262,29,'_line_total','50'),(263,29,'_line_tax','0'),(264,29,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}'),(265,29,'_product_type','ticket-event'),(266,29,'_field_Full Name','Agnes Ward'),(267,29,'_field_Email','agnes.ward@btinternet.com'),(268,29,'_field_Phone Number','07404185348'),(269,29,'_field_Starter','liver parfait'),(270,29,'_field_Main','salmon'),(271,29,'_field_Dessert','fresh fruit salad'),(272,30,'method_id','flat_rate:1'),(273,30,'cost','0.00'),(274,30,'total_tax','0'),(275,30,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(276,30,'Items','GOGA Fundraising Dinner Ticket &times; 1'),(277,29,'_event_id','1754'),(278,31,'_product_id','1942'),(279,31,'_variation_id','0'),(280,31,'_qty','1'),(281,31,'_tax_class',''),(282,31,'_line_subtotal','32'),(283,31,'_line_subtotal_tax','0'),(284,31,'_line_total','32'),(285,31,'_line_tax','0'),(286,31,'_line_tax_data','a:2:{s:5:\"total\";a:0:{}s:8:\"subtotal\";a:0:{}}');

--
-- Table structure for table `wpba_woocommerce_order_items`
--

CREATE TABLE `wpba_woocommerce_order_items` (
  `order_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_item_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `order_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_order_items`
--

INSERT INTO `wpba_woocommerce_order_items` VALUES (1,'GOGA London Fundraising Dinner 14th April 2018','line_item',1209),(2,'Flat rate','shipping',1209),(3,'GOGA Fundraising Dinner Ticket','line_item',1456),(4,'Flat rate','shipping',1456),(29,'GOGA Fundraising Dinner Ticket','line_item',1712),(30,'Flat rate','shipping',1712),(31,'Subscriptions','line_item',1946);

--
-- Table structure for table `wpba_woocommerce_payment_tokenmeta`
--

CREATE TABLE `wpba_woocommerce_payment_tokenmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_token_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`meta_id`),
  KEY `payment_token_id` (`payment_token_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_payment_tokenmeta`
--


--
-- Table structure for table `wpba_woocommerce_payment_tokens`
--

CREATE TABLE `wpba_woocommerce_payment_tokens` (
  `token_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gateway_id` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`token_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_payment_tokens`
--


--
-- Table structure for table `wpba_woocommerce_shipping_zone_locations`
--

CREATE TABLE `wpba_woocommerce_shipping_zone_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_id` bigint(20) unsigned NOT NULL,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `location_id` (`location_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_shipping_zone_locations`
--

INSERT INTO `wpba_woocommerce_shipping_zone_locations` VALUES (1,1,'GB','country');

--
-- Table structure for table `wpba_woocommerce_shipping_zone_methods`
--

CREATE TABLE `wpba_woocommerce_shipping_zone_methods` (
  `zone_id` bigint(20) unsigned NOT NULL,
  `instance_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_id` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method_order` bigint(20) unsigned NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`instance_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_shipping_zone_methods`
--

INSERT INTO `wpba_woocommerce_shipping_zone_methods` VALUES (1,1,'flat_rate',1,1),(0,2,'flat_rate',1,1);

--
-- Table structure for table `wpba_woocommerce_shipping_zones`
--

CREATE TABLE `wpba_woocommerce_shipping_zones` (
  `zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zone_order` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`zone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_shipping_zones`
--

INSERT INTO `wpba_woocommerce_shipping_zones` VALUES (1,'United Kingdom (UK)',0);

--
-- Table structure for table `wpba_woocommerce_tax_rate_locations`
--

CREATE TABLE `wpba_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_rate_id` bigint(20) unsigned NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_tax_rate_locations`
--


--
-- Table structure for table `wpba_woocommerce_tax_rates`
--

CREATE TABLE `wpba_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_rate_country` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax_rate_priority` bigint(20) unsigned NOT NULL,
  `tax_rate_compound` int(1) NOT NULL DEFAULT '0',
  `tax_rate_shipping` int(1) NOT NULL DEFAULT '1',
  `tax_rate_order` bigint(20) unsigned NOT NULL,
  `tax_rate_class` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_id`),
  KEY `tax_rate_country` (`tax_rate_country`),
  KEY `tax_rate_state` (`tax_rate_state`(2)),
  KEY `tax_rate_class` (`tax_rate_class`(10)),
  KEY `tax_rate_priority` (`tax_rate_priority`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wpba_woocommerce_tax_rates`
--



