· 11 years ago · Jul 28, 2015, 09:37 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jul 28, 2015 at 05:36 AM
7-- Server version: 5.5.43-0ubuntu0.14.04.1
8-- PHP Version: 5.5.9-1ubuntu4.11
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `wgcallcenter_demo`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `app_log`
27--
28
29CREATE TABLE IF NOT EXISTS `app_log` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `channel` varchar(255) DEFAULT NULL,
32 `level` int(11) DEFAULT NULL,
33 `message` text,
34 `time` int(10) DEFAULT NULL,
35 `username` varchar(255) DEFAULT NULL,
36 `userid` int(11) DEFAULT NULL,
37 `type` varchar(255) DEFAULT NULL,
38 `api_req_url` text,
39 `api_response` text,
40 `route` text,
41 `ip` varchar(255) DEFAULT NULL,
42 `created_at` datetime DEFAULT NULL,
43 `updated_at` datetime DEFAULT NULL,
44 PRIMARY KEY (`id`)
45) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `booking`
51--
52
53CREATE TABLE IF NOT EXISTS `booking` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `customer_id` int(11) DEFAULT NULL,
56 `order_id` int(11) DEFAULT NULL,
57 `ticket_hotel_id` int(11) DEFAULT NULL,
58 `user_id` int(11) DEFAULT NULL,
59 `passport_number` varchar(255) DEFAULT NULL,
60 `created_at` datetime DEFAULT NULL,
61 `updated_at` datetime DEFAULT NULL,
62 PRIMARY KEY (`id`),
63 KEY `booking_FI_1` (`ticket_hotel_id`),
64 KEY `booking_FI_2` (`user_id`),
65 KEY `booking_FI_3` (`order_id`),
66 KEY `booking_FI_4` (`customer_id`)
67) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
68
69--
70-- Dumping data for table `booking`
71--
72
73INSERT INTO `booking` (`id`, `customer_id`, `order_id`, `ticket_hotel_id`, `user_id`, `passport_number`, `created_at`, `updated_at`) VALUES
74(1, 1, 1, 1, 1, '3140166', '2015-07-27 19:53:23', '2015-07-27 19:53:23'),
75(2, 3, 3, 2, 1, '3140170', '2015-07-27 20:57:27', '2015-07-27 20:57:27'),
76(3, 5, 4, 5, 1, '3140179', '2015-07-28 03:58:46', '2015-07-28 03:58:46');
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `customer_info`
82--
83
84CREATE TABLE IF NOT EXISTS `customer_info` (
85 `id` int(11) NOT NULL AUTO_INCREMENT,
86 `first_name` varchar(128) NOT NULL,
87 `last_name` varchar(128) NOT NULL,
88 `email` varchar(128) DEFAULT NULL,
89 `address1` text,
90 `address2` text,
91 `phone_number` varchar(128) DEFAULT NULL,
92 `city` varchar(128) DEFAULT NULL,
93 `state` varchar(128) DEFAULT NULL,
94 `zip_code` varchar(128) DEFAULT NULL,
95 `country` varchar(128) DEFAULT NULL,
96 `gender` int(11) DEFAULT NULL,
97 `marital_status` varchar(128) DEFAULT NULL,
98 `annual_income` varchar(128) DEFAULT NULL,
99 `total_travellers` int(128) DEFAULT NULL,
100 `campaign_id` int(11) DEFAULT NULL,
101 `cc_type` varchar(255) DEFAULT NULL,
102 `last_4_cc` int(11) DEFAULT NULL,
103 `income_group` int(11) DEFAULT NULL,
104 `age_group` int(11) DEFAULT NULL,
105 `citizenship` text,
106 `tour_with_spouse` tinyint(4) DEFAULT NULL,
107 `already_toured` tinyint(4) DEFAULT NULL,
108 `travelled_within_12_mnths_wg` tinyint(4) DEFAULT NULL,
109 `travelled_with_other_party` tinyint(4) DEFAULT NULL,
110 `created_at` datetime DEFAULT NULL,
111 `updated_at` datetime DEFAULT NULL,
112 PRIMARY KEY (`id`)
113) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
114
115--
116-- Dumping data for table `customer_info`
117--
118
119INSERT INTO `customer_info` (`id`, `first_name`, `last_name`, `email`, `address1`, `address2`, `phone_number`, `city`, `state`, `zip_code`, `country`, `gender`, `marital_status`, `annual_income`, `total_travellers`, `campaign_id`, `cc_type`, `last_4_cc`, `income_group`, `age_group`, `citizenship`, `tour_with_spouse`, `already_toured`, `travelled_within_12_mnths_wg`, `travelled_with_other_party`, `created_at`, `updated_at`) VALUES
120(1, 'imtiaz', 'pabel', 'pabel@test.com', 'Dallas', 'Dallas', '1819534767', 'Dallas', 'AL', '75002', 'US', NULL, NULL, 'N/A', NULL, 403297, '1234', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-27 19:53:23', '2015-07-27 19:53:23'),
121(2, 'Sean', 'Ramphal', 'info@miteksupport.com', '10217 N 28th Street', '10217 N 28th Street', '8134811533', 'Tampa', 'FL', '33612', 'US', NULL, NULL, '$75,000 - $79,000', NULL, 403297, '1654', NULL, NULL, 2, NULL, 0, 0, 0, 0, '2015-07-27 20:28:53', '2015-07-27 20:28:53'),
122(3, 'Shaharia', 'Azam', 'shaharia.azam@gmail.com', '50/60 Street', '50/60 Street', '2125412512', 'New York', 'NY', '20001', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-27 20:57:27', '2015-07-27 20:57:27'),
123(4, 'Shaharia', 'Azam', 'shaharia.azam@gmail.com', '50/60 Street', '50/60 Street', '2125412512', 'New York', 'NY', '20001', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 03:01:35', '2015-07-28 03:01:35'),
124(5, 'Shaharia', 'Azam', 'shaharia.azam@gmail.com', '50/60 Street', '50/60 Street', '2125412512', 'New York', 'NY', '20001', 'US', NULL, NULL, 'N/A', NULL, 403297, '', NULL, NULL, 0, NULL, 0, 0, 0, 0, '2015-07-28 03:58:46', '2015-07-28 03:58:46');
125
126-- --------------------------------------------------------
127
128--
129-- Table structure for table `order_info`
130--
131
132CREATE TABLE IF NOT EXISTS `order_info` (
133 `id` int(11) NOT NULL AUTO_INCREMENT,
134 `api_order_id` int(11) DEFAULT NULL,
135 `passport_no` int(11) NOT NULL,
136 `vacpac_no` int(11) NOT NULL,
137 `prospect_id` int(11) NOT NULL,
138 `custom_discount_price` decimal(10,2) NOT NULL,
139 `total_price` int(11) NOT NULL,
140 `quantity` int(11) DEFAULT NULL,
141 `transaction_id` int(11) DEFAULT NULL,
142 `cart_subtotal` decimal(10,2) DEFAULT NULL,
143 `cart_tax` decimal(10,2) DEFAULT NULL,
144 `cart_total_savings` decimal(10,2) DEFAULT NULL,
145 `cart_custom_discount` decimal(10,2) DEFAULT NULL,
146 `cart_total` decimal(10,2) DEFAULT NULL,
147 `session_raw` text,
148 `request_json` text,
149 `response_json` text,
150 `activity_started` datetime DEFAULT NULL,
151 `activity_finished` datetime DEFAULT NULL,
152 `activity_duration` int(11) DEFAULT NULL,
153 `begin_campaign` varchar(255) DEFAULT NULL,
154 `user_id` int(11) DEFAULT NULL,
155 `status` tinyint(4) DEFAULT NULL,
156 `created_at` datetime DEFAULT NULL,
157 `updated_at` datetime DEFAULT NULL,
158 PRIMARY KEY (`id`),
159 KEY `order_info_FI_1` (`user_id`)
160) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
161
162--
163-- Dumping data for table `order_info`
164--
165
166INSERT INTO `order_info` (`id`, `api_order_id`, `passport_no`, `vacpac_no`, `prospect_id`, `custom_discount_price`, `total_price`, `quantity`, `transaction_id`, `cart_subtotal`, `cart_tax`, `cart_total_savings`, `cart_custom_discount`, `cart_total`, `session_raw`, `request_json`, `response_json`, `activity_started`, `activity_finished`, `activity_duration`, `begin_campaign`, `user_id`, `status`, `created_at`, `updated_at`) VALUES
167(1, 10011, 3140166, 3140166, 67264891, 0.00, 17, 1, 130901, 17.00, 0.00, 4.29, 0.00, 17.00, 'a:6:{s:10:"slim.flash";a:0:{}s:4:"user";s:14:"rqw23525asdf56";s:16:"booking_activity";a:4:{s:7:"user_id";i:1;s:14:"campaign_begin";s:8:"Vac Pack";s:7:"started";s:19:"2015-07-27 07:25:51";s:8:"finished";s:19:"2015-07-27 07:53:23";}s:8:"customer";a:23:{s:19:"customer_first_name";s:6:"imtiaz";s:18:"customer_last_name";s:5:"pabel";s:14:"customer_email";s:14:"pabel@test.com";s:17:"customer_address1";s:6:"Dallas";s:17:"customer_address2";s:6:"Dallas";s:14:"customer_phone";s:10:"1819534767";s:13:"customer_city";s:6:"Dallas";s:14:"customer_state";s:2:"AL";s:12:"customer_zip";s:5:"75002";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:7:"Albania";s:24:"customer_no_of_travelers";s:1:"0";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:16:"American Express";s:18:"customer_last_4_cc";s:4:"1234";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:4:"cart";a:1:{i:7507531723466582;a:9:{s:9:"productID";s:6:"130901";s:11:"productName";s:24:"1 DAY CRAYOLA EXPERIENCE";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"17";s:6:"others";a:4:{s:11:"retailPrice";s:5:"21.29";s:8:"nonPrice";s:5:"21.29";s:6:"saving";d:4.29;s:9:"tourPrice";i:0;}s:5:"total";i:17;s:13:"intAvailSeqId";s:0:"";}}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10011&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=&pchr_customer_info_array=%2C%2C%2Cimtiaz%2Cpabel%2C%2C%2C1819534767%2C%2CDallas%2CDallas%2CDallas%2CAL%2C75002%2C%2CUS%2Cpabel%40test.com%2CEnglish&pchr_tickets_array=130901%2C1%2C21.29%2C4.29%2C17&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10011";s:6:"vacpac";s:7:"3140166";s:8:"prospect";s:8:"67264891";s:5:"price";s:5:"16.99";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Imtiaz Pabel";s:7:"address";s:35:"DALLAS DALLAS DALLAS, AL 75002 USA";s:5:"email";s:14:"pabel@test.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:6:"130901";s:10:"ticketDesc";s:24:"1 DAY CRAYOLA EXPERIENCE";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"17";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-27 07:25:51', '2015-07-27 07:53:23', 1652, 'Vac Pack', 1, 1, '2015-07-27 19:53:23', '2015-07-27 19:53:23'),
168(2, 10012, 3140167, 3140167, 67264889, 5.00, 140, 2, 43917, 144.00, 0.00, 150.62, 5.00, 139.00, 'a:9:{s:4:"user";s:14:"rqw23525asdf56";s:10:"slim.flash";a:0:{}s:16:"booking_activity";a:4:{s:7:"user_id";i:1;s:14:"campaign_begin";s:13:"Ticket Offers";s:7:"started";s:19:"2015-07-27 08:23:20";s:8:"finished";s:19:"2015-07-27 08:28:53";}s:8:"customer";a:23:{s:19:"customer_first_name";s:4:"Sean";s:18:"customer_last_name";s:7:"Ramphal";s:14:"customer_email";s:21:"info@miteksupport.com";s:17:"customer_address1";s:19:"10217 N 28th Street";s:17:"customer_address2";s:0:"";s:14:"customer_phone";s:10:"8134811533";s:13:"customer_city";s:5:"Tampa";s:14:"customer_state";s:2:"FL";s:12:"customer_zip";s:5:"33612";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:9:"Argentina";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:5:"Cohab";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:17:"$75,000 - $79,000";s:18:"customer_age_group";s:1:"2";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:16:"American Express";s:18:"customer_last_4_cc";s:4:"1654";}s:23:"ticketSearchInformation";a:1:{s:14:"ticketQuantity";i:1;}s:9:"cart_tour";b:0;s:24:"packageSearchInformation";a:6:{s:18:"packageDestination";s:7:"ORLANDO";s:13:"packageInDate";s:13:" 11-Aug-2015 ";s:14:"packageOutDate";s:13:" 13-Aug-2015 ";s:6:"nights";i:2;s:5:"guest";i:1;s:15:"packageQuantity";i:1;}s:4:"cart";a:2:{i:2084391597204488;a:9:{s:9:"productID";s:19:"3516STM - 2 DOUBLES";s:11:"productName";s:18:"DAYS INN KISSIMMEE";s:18:"productDescription";s:0:"";s:11:"productType";s:5:"Hotel";s:3:"qty";s:1:"2";s:9:"unitPrice";s:2:"37";s:6:"others";a:9:{s:8:"roomType";s:15:"STM - 2 DOUBLES";s:7:"hotelId";s:4:"3516";s:11:"arrivalDate";s:13:" 11-Aug-2015 ";s:6:"nights";s:1:"2";s:5:"guest";i:1;s:11:"retailPrice";s:2:"39";s:9:"tourPrice";s:2:"37";s:8:"nonPrice";i:0;s:6:"saving";i:2;}s:5:"total";i:74;s:13:"intAvailSeqId";s:0:"";}i:7536766523952257;a:9:{s:9:"productID";s:5:"43917";s:11:"productName";s:33:"1 DAY MAGIC YOUR WAY BASE - ADULT";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"2";s:9:"unitPrice";s:2:"35";s:6:"others";a:4:{s:11:"retailPrice";s:6:"108.31";s:8:"nonPrice";s:6:"108.31";s:6:"saving";d:73.310000000000002;s:9:"tourPrice";i:0;}s:5:"total";i:70;s:13:"intAvailSeqId";s:0:"";}}s:21:"custom_discount_price";d:5;}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10012&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=3516%2CSTM+-+2+DOUBLES%2C+11-Aug-2015+%2C2%2C1%2C%2C39%2C4%2C35%2C0%2C&pchr_customer_info_array=%2C%2C%2CSean%2CRamphal%2C%2C%2C8134811533%2C%2C10217+N+28th+Street%2C%2CTampa%2CFL%2C33612%2C%2CUS%2Cinfo%40miteksupport.com%2CEnglish&pchr_tickets_array=43917%2C2%2C108.31%2C73.31%2C70&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=5', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10012";s:6:"vacpac";s:7:"3140167";s:8:"prospect";s:8:"67264889";s:5:"price";s:6:"148.62";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:12:"Sean Ramphal";s:7:"address";s:36:"10217 N 28TH ST TAMPA, FL 33612 USA";s:5:"email";s:21:"info@miteksupport.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:5:"43917";s:10:"ticketDesc";s:33:"1 DAY MAGIC YOUR WAY BASE - ADULT";s:9:"ticketQty";s:1:"2";s:11:"ticketPrice";s:3:"140";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:1:"5";}}}}', '2015-07-27 08:23:20', '2015-07-27 08:28:53', 333, 'Ticket Offers', 1, 1, '2015-07-27 20:28:53', '2015-07-27 20:28:53'),
169(3, 10013, 3140170, 3140170, 67264888, 2.00, 25, 1, 93616, 25.00, 0.00, 0.00, 2.00, 23.00, 'a:7:{s:10:"slim.flash";a:0:{}s:4:"user";s:14:"rqw23525asdf56";s:16:"booking_activity";a:4:{s:7:"user_id";i:1;s:14:"campaign_begin";s:8:"Vac Pack";s:7:"started";s:19:"2015-07-27 08:56:35";s:8:"finished";s:19:"2015-07-27 08:57:27";}s:8:"customer";a:23:{s:19:"customer_first_name";s:8:"Shaharia";s:18:"customer_last_name";s:4:"Azam";s:14:"customer_email";s:23:"shaharia.azam@gmail.com";s:17:"customer_address1";s:12:"50/60 Street";s:17:"customer_address2";s:12:"50/60 Street";s:14:"customer_phone";s:10:"2125412512";s:13:"customer_city";s:8:"New York";s:14:"customer_state";s:2:"NY";s:12:"customer_zip";s:5:"20001";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:4:"cart";a:1:{i:9771316679248337;a:9:{s:9:"productID";s:5:"93616";s:11:"productName";s:41:"$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"25";s:6:"others";a:4:{s:11:"retailPrice";s:2:"25";s:8:"nonPrice";s:2:"25";s:6:"saving";i:0;s:9:"tourPrice";i:0;}s:5:"total";i:25;s:13:"intAvailSeqId";s:0:"";}}s:21:"custom_discount_price";d:2;}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10013&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=&pchr_customer_info_array=%2C%2C%2CShaharia%2CAzam%2C%2C%2C2125412512%2C%2C50%2F60+Street%2C50%2F60+Street%2CNew+York%2CNY%2C20001%2C%2CUS%2Cshaharia.azam%40gmail.com%2CEnglish&pchr_tickets_array=93616%2C1%2C25%2C0%2C25&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=2', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10013";s:6:"vacpac";s:7:"3140170";s:8:"prospect";s:8:"67264888";s:5:"price";s:2:"23";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:13:"Shaharia Azam";s:7:"address";s:48:"5060 STREET 50/60 STREET NEW YORK, NY 20001 USA";s:5:"email";s:23:"shaharia.azam@gmail.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:5:"93616";s:10:"ticketDesc";s:41:"$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"25";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:1:"2";}}}}', '2015-07-27 08:56:35', '2015-07-27 08:57:27', 52, 'Vac Pack', 1, 1, '2015-07-27 20:57:27', '2015-07-27 20:57:27'),
170(4, 10014, 3140179, 3140179, 67264888, 0.00, 17, 1, 130901, 17.00, 0.00, 4.29, 0.00, 17.00, 'a:6:{s:10:"slim.flash";a:0:{}s:4:"user";s:14:"rqw23525asdf56";s:16:"booking_activity";a:4:{s:7:"user_id";i:1;s:14:"campaign_begin";s:8:"Vac Pack";s:7:"started";s:19:"2015-07-28 03:58:12";s:8:"finished";s:19:"2015-07-28 03:58:46";}s:8:"customer";a:23:{s:19:"customer_first_name";s:8:"Shaharia";s:18:"customer_last_name";s:4:"Azam";s:14:"customer_email";s:23:"shaharia.azam@gmail.com";s:17:"customer_address1";s:12:"50/60 Street";s:17:"customer_address2";s:12:"50/60 Street";s:14:"customer_phone";s:10:"2125412512";s:13:"customer_city";s:8:"New York";s:14:"customer_state";s:2:"NY";s:12:"customer_zip";s:5:"20001";s:16:"customer_country";s:2:"US";s:20:"customer_citizenship";s:13:"United States";s:24:"customer_no_of_travelers";s:3:" 2 ";s:23:"customer_martial_status";s:6:"Single";s:15:"customer_gender";s:1:"1";s:22:"customer_annual_income";s:3:"N/A";s:18:"customer_age_group";s:1:"0";s:25:"customer_tour_with_spouse";s:1:"0";s:23:"customer_already_toured";s:1:"0";s:37:"customer_travelled_within_12_mnths_wg";s:1:"0";s:35:"customer_travelled_with_other_party";s:1:"0";s:20:"customer_campaign_id";s:6:"403297";s:16:"customer_cc_type";s:3:"N/A";s:18:"customer_last_4_cc";s:0:"";}s:23:"ticketSearchInformation";a:2:{s:17:"ticketDestination";s:7:"ORLANDO";s:14:"ticketQuantity";s:1:"1";}s:4:"cart";a:1:{i:7280471672918618;a:9:{s:9:"productID";s:6:"130901";s:11:"productName";s:24:"1 DAY CRAYOLA EXPERIENCE";s:18:"productDescription";s:0:"";s:11:"productType";s:6:"Ticket";s:3:"qty";s:1:"1";s:9:"unitPrice";s:2:"17";s:6:"others";a:4:{s:11:"retailPrice";s:5:"21.29";s:8:"nonPrice";s:5:"21.29";s:6:"saving";d:4.29;s:9:"tourPrice";i:0;}s:5:"total";i:17;s:13:"intAvailSeqId";s:0:"";}}}', 'https://api-services-qa.westgateresorts.com/pkg_sam_vacpac_pub_api.prc_online_booking?pnum_online_order_id=10014&pnum_marketing_campaign=403297&pchr_destination_id=ORLANDO&pchr_hotel_reservation_array=&pchr_customer_info_array=%2C%2C%2CShaharia%2CAzam%2C%2C%2C2125412512%2C%2C50%2F60+Street%2C50%2F60+Street%2CNew+York%2CNY%2C20001%2C%2CUS%2Cshaharia.azam%40gmail.com%2CEnglish&pchr_tickets_array=130901%2C1%2C21.29%2C4.29%2C17&pchr_travel_ins_array=&pchr_cc_type=&pnum_cc_number=&pnum_cc_exp=&pchr_cc_cardholder=&pnum_cc_charge_amount=&pnum_cc_cvv_number=&pnum_tour_discount=0.01', 'a:1:{s:13:"bookingResult";a:2:{s:7:"summary";a:5:{s:5:"order";s:5:"10014";s:6:"vacpac";s:7:"3140179";s:8:"prospect";s:8:"67264888";s:5:"price";s:5:"16.99";s:6:"ccauth";a:0:{}}s:19:"confirmationDetails";a:3:{s:12:"customerInfo";a:3:{s:4:"name";s:13:"Shaharia Azam";s:7:"address";s:48:"5060 STREET 50/60 STREET NEW YORK, NY 20001 USA";s:5:"email";s:23:"shaharia.azam@gmail.com";}s:7:"tickets";a:1:{s:10:"ticketInfo";a:4:{s:8:"ticketId";s:6:"130901";s:10:"ticketDesc";s:24:"1 DAY CRAYOLA EXPERIENCE";s:9:"ticketQty";s:1:"1";s:11:"ticketPrice";s:2:"17";}}s:12:"tourDiscount";a:1:{s:11:"discountAmt";s:3:".01";}}}}', '2015-07-28 03:58:12', '2015-07-28 03:58:46', 34, 'Vac Pack', 1, 1, '2015-07-28 03:58:46', '2015-07-28 03:58:46');
171
172-- --------------------------------------------------------
173
174--
175-- Table structure for table `package_ticket`
176--
177
178CREATE TABLE IF NOT EXISTS `package_ticket` (
179 `id` int(11) NOT NULL AUTO_INCREMENT,
180 `inventory_id` int(11) DEFAULT NULL,
181 `brand` varchar(64) DEFAULT NULL,
182 `name` varchar(128) NOT NULL,
183 `description` varchar(255) DEFAULT NULL,
184 `destination` varchar(255) NOT NULL,
185 `gate_price` decimal(10,2) DEFAULT NULL,
186 `price` decimal(10,2) DEFAULT NULL,
187 `cost` decimal(10,2) DEFAULT NULL,
188 `created_at` datetime DEFAULT NULL,
189 `updated_at` datetime DEFAULT NULL,
190 PRIMARY KEY (`id`)
191) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
192
193--
194-- Dumping data for table `package_ticket`
195--
196
197INSERT INTO `package_ticket` (`id`, `inventory_id`, `brand`, `name`, `description`, `destination`, `gate_price`, `price`, `cost`, `created_at`, `updated_at`) VALUES
198(1, 43917, NULL, '1 DAY MAGIC YOUR WAY BASE - ADULT', 'Valid for 1 admission to the park of your choice. Choose from Epcot, Disney''s Hollywood Studios and Disney''s Animal Kingdom. Parking is not included.', 'ORLANDO', 108.31, 108.31, 103.31, '2015-07-27 19:58:48', '2015-07-27 19:58:48');
199
200-- --------------------------------------------------------
201
202--
203-- Table structure for table `package_ticket_pricing`
204--
205
206CREATE TABLE IF NOT EXISTS `package_ticket_pricing` (
207 `id` int(11) NOT NULL AUTO_INCREMENT,
208 `ticket_id` int(11) DEFAULT NULL,
209 `inventory_id` int(11) DEFAULT NULL,
210 `quantity` int(11) NOT NULL,
211 `price` decimal(10,2) NOT NULL,
212 `user_id` int(11) NOT NULL,
213 `created_at` datetime DEFAULT NULL,
214 `updated_at` datetime DEFAULT NULL,
215 PRIMARY KEY (`id`),
216 KEY `package_ticket_pricing_FI_1` (`ticket_id`),
217 KEY `package_ticket_pricing_FI_2` (`user_id`)
218) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
219
220--
221-- Dumping data for table `package_ticket_pricing`
222--
223
224INSERT INTO `package_ticket_pricing` (`id`, `ticket_id`, `inventory_id`, `quantity`, `price`, `user_id`, `created_at`, `updated_at`) VALUES
225(1, 1, 43917, 2, 70.00, 1, '2015-07-27 19:58:48', '2015-07-27 19:58:48'),
226(2, 1, 43917, 3, 175.00, 1, '2015-07-27 19:58:48', '2015-07-27 19:58:48'),
227(3, 1, 43917, 4, 289.00, 1, '2015-07-27 19:58:48', '2015-07-27 19:58:48');
228
229-- --------------------------------------------------------
230
231--
232-- Table structure for table `tickets`
233--
234
235CREATE TABLE IF NOT EXISTS `tickets` (
236 `id` int(11) NOT NULL AUTO_INCREMENT,
237 `inventory_id` int(11) DEFAULT NULL,
238 `brand` varchar(64) DEFAULT NULL,
239 `name` varchar(128) NOT NULL,
240 `description` varchar(255) DEFAULT NULL,
241 `destination` varchar(255) NOT NULL,
242 `quantity` int(11) DEFAULT NULL,
243 `api_price` decimal(10,2) DEFAULT NULL,
244 `custom_price` decimal(10,2) DEFAULT NULL,
245 `sells_type` int(11) DEFAULT NULL,
246 `created_at` datetime DEFAULT NULL,
247 `updated_at` datetime DEFAULT NULL,
248 PRIMARY KEY (`id`)
249) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
250
251-- --------------------------------------------------------
252
253--
254-- Table structure for table `ticket_hotel`
255--
256
257CREATE TABLE IF NOT EXISTS `ticket_hotel` (
258 `id` int(11) NOT NULL AUTO_INCREMENT,
259 `product_id` int(11) DEFAULT NULL,
260 `name` varchar(255) DEFAULT NULL,
261 `description` text,
262 `type` varchar(255) DEFAULT NULL,
263 `destination` varchar(255) DEFAULT NULL,
264 `arrival_date` date DEFAULT NULL,
265 `departure_date` date DEFAULT NULL,
266 `quantity` int(11) DEFAULT NULL,
267 `unit_price` float DEFAULT NULL,
268 `retail_price` float DEFAULT NULL,
269 `non_tour_retail_price` float DEFAULT NULL,
270 `saving` float DEFAULT NULL,
271 `tour_price` float DEFAULT NULL,
272 `total` float DEFAULT NULL,
273 `created_at` datetime DEFAULT NULL,
274 `updated_at` datetime DEFAULT NULL,
275 PRIMARY KEY (`id`)
276) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
277
278--
279-- Dumping data for table `ticket_hotel`
280--
281
282INSERT INTO `ticket_hotel` (`id`, `product_id`, `name`, `description`, `type`, `destination`, `arrival_date`, `departure_date`, `quantity`, `unit_price`, `retail_price`, `non_tour_retail_price`, `saving`, `tour_price`, `total`, `created_at`, `updated_at`) VALUES
283(1, NULL, '1 DAY CRAYOLA EXPERIENCE', '', 'Ticket', 'ORLANDO', NULL, NULL, 1, 17, 21.29, 21.29, 4.29, 0, 17, '2015-07-27 19:53:23', '2015-07-27 19:53:23'),
284(2, NULL, '$25 SMOKEHOUSE GRILL OR SERENITY SPA CERT', '', 'Ticket', 'ORLANDO', NULL, NULL, 1, 25, 25, 25, 0, 0, 25, '2015-07-27 20:57:27', '2015-07-27 20:57:27'),
285(3, NULL, '1 DAY MAGIC YOUR WAY + HOPPER - ADULT', '', 'Ticket', 'ORLANDO', NULL, NULL, 1, 170.08, 170.08, 170.08, 0, 0, 170.08, '2015-07-28 03:01:35', '2015-07-28 03:01:35'),
286(4, NULL, '1 DAY MAGIC YOUR WAY BASE - ADULT', '', 'Ticket', 'ORLANDO', NULL, NULL, 4, 108.31, 108.31, 108.31, 0, 0, 433.24, '2015-07-28 03:01:35', '2015-07-28 03:01:35'),
287(5, NULL, '1 DAY CRAYOLA EXPERIENCE', '', 'Ticket', 'ORLANDO', NULL, NULL, 1, 17, 21.29, 21.29, 4.29, 0, 17, '2015-07-28 03:58:46', '2015-07-28 03:58:46');
288
289-- --------------------------------------------------------
290
291--
292-- Table structure for table `user`
293--
294
295CREATE TABLE IF NOT EXISTS `user` (
296 `id` int(11) NOT NULL AUTO_INCREMENT,
297 `uuid` char(36) NOT NULL,
298 `email` varchar(128) NOT NULL,
299 `password` varchar(255) NOT NULL,
300 `first_name` varchar(128) NOT NULL,
301 `last_name` varchar(128) NOT NULL,
302 `role` int(1) NOT NULL,
303 `created_at` datetime DEFAULT NULL,
304 `updated_at` datetime DEFAULT NULL,
305 PRIMARY KEY (`id`)
306) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
307
308--
309-- Dumping data for table `user`
310--
311
312INSERT INTO `user` (`id`, `uuid`, `email`, `password`, `first_name`, `last_name`, `role`, `created_at`, `updated_at`) VALUES
313(1, 'rqw23525asdf56', 'info@miteksoftware.com', '$2y$10$mETHeJDX9K8Re7rDBVnZ/OoUEW.QZzPrcgBSSjmal/P6V39Bl0k0u', 'MiTek Software', 'Solutions', 5, NULL, NULL),
314(2, 'aa631b85-339c-4ae8-8c8b-1773653937fa', 'test@agent.com', '$2y$10$Aym0XZtzPhEWh/qXWyFuKukwjLwNu6aO99Hlb.FERT.SEsxhIIKFW', 'TEST ', 'AGENT', 1, '2015-07-27 19:54:39', '2015-07-27 19:54:39');
315
316--
317-- Constraints for dumped tables
318--
319
320--
321-- Constraints for table `booking`
322--
323ALTER TABLE `booking`
324 ADD CONSTRAINT `booking_FK_1` FOREIGN KEY (`ticket_hotel_id`) REFERENCES `ticket_hotel` (`id`),
325 ADD CONSTRAINT `booking_FK_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
326 ADD CONSTRAINT `booking_FK_3` FOREIGN KEY (`order_id`) REFERENCES `order_info` (`id`),
327 ADD CONSTRAINT `booking_FK_4` FOREIGN KEY (`customer_id`) REFERENCES `customer_info` (`id`);
328
329--
330-- Constraints for table `order_info`
331--
332ALTER TABLE `order_info`
333 ADD CONSTRAINT `order_info_FK_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
334
335--
336-- Constraints for table `package_ticket_pricing`
337--
338ALTER TABLE `package_ticket_pricing`
339 ADD CONSTRAINT `package_ticket_pricing_FK_1` FOREIGN KEY (`ticket_id`) REFERENCES `package_ticket` (`id`),
340 ADD CONSTRAINT `package_ticket_pricing_FK_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
341
342/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
343/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
344/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;