forked from namastePrashant/Booking
-
Notifications
You must be signed in to change notification settings - Fork 0
/
new_reservation.sql
6384 lines (6195 loc) · 443 KB
/
new_reservation.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 26, 2012 at 04:44 AM
-- Server version: 5.5.25a
-- PHP Version: 5.4.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `new_reservation`
--
-- --------------------------------------------------------
--
-- Table structure for table `advertisements`
--
CREATE TABLE IF NOT EXISTS `advertisements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`position` enum('top-left','top-right','center-center','bottom-right','bottom-left','topics','tarateesh') NOT NULL,
`type` enum('file','text') NOT NULL,
`file_id` varchar(100) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`content` text,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `advertisements`
--
INSERT INTO `advertisements` (`id`, `title`, `position`, `type`, `file_id`, `url`, `content`, `start_date`, `end_date`) VALUES
(2, 'عن الشركة', 'bottom-right', 'file', '384f2201dc4ba2c7251909a8d1a1e6bd', 'http://www.google.com', NULL, '2010-12-01', '2020-12-02');
-- --------------------------------------------------------
--
-- Table structure for table `auth_belong`
--
CREATE TABLE IF NOT EXISTS `auth_belong` (
`user_id` int(11) unsigned NOT NULL,
`group_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`user_id`,`group_id`),
KEY `fk_belong__group_id___group__user_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `auth_belong`
--
INSERT INTO `auth_belong` (`user_id`, `group_id`) VALUES
(1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `auth_group`
--
CREATE TABLE IF NOT EXISTS `auth_group` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text,
`group_parent_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_group__group_parent_id___group__id` (`group_parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `auth_group`
--
INSERT INTO `auth_group` (`id`, `name`, `description`, `group_parent_id`) VALUES
(1, 'Administrator', 'Administrator', 4),
(2, 'Webmaster', 'Webmaster', 3),
(3, 'User', 'User', NULL),
(4, 'Moderator', 'Moderator', 2);
-- --------------------------------------------------------
--
-- Table structure for table `auth_group_permission`
--
CREATE TABLE IF NOT EXISTS `auth_group_permission` (
`group_id` int(11) unsigned NOT NULL,
`permission_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`group_id`,`permission_id`),
KEY `fk_group_permission__permission_id___permission__id` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `auth_group_permission`
--
INSERT INTO `auth_group_permission` (`group_id`, `permission_id`) VALUES
(2, 9),
(3, 9),
(4, 9);
-- --------------------------------------------------------
--
-- Table structure for table `auth_permission`
--
CREATE TABLE IF NOT EXISTS `auth_permission` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `auth_permission`
--
INSERT INTO `auth_permission` (`id`, `name`, `description`) VALUES
(9, 'all', 'All');
-- --------------------------------------------------------
--
-- Table structure for table `auth_user`
--
CREATE TABLE IF NOT EXISTS `auth_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`first_name` varchar(30) DEFAULT NULL,
`last_name` varchar(30) DEFAULT NULL,
`email` varchar(75) DEFAULT NULL,
`password` varchar(128) NOT NULL,
`salt` varchar(128) DEFAULT NULL,
`algorithm` varchar(128) NOT NULL,
`contact_name` varchar(255) DEFAULT NULL,
`country_code` varchar(10) DEFAULT NULL,
`phone` varchar(75) NOT NULL,
`zipcode` varchar(15) NOT NULL,
`address` varchar(255) NOT NULL,
`city` varchar(50) NOT NULL,
`state` char(2) NOT NULL,
`can_be_deleted` int(1) unsigned NOT NULL DEFAULT '1',
`is_active` int(1) unsigned NOT NULL DEFAULT '0',
`is_super_admin` int(1) unsigned NOT NULL DEFAULT '0',
`is_staff` int(1) unsigned NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`user_parent_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_user__user_parent_id___user__id` (`user_parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `auth_user`
--
INSERT INTO `auth_user` (`id`, `username`, `first_name`, `last_name`, `email`, `password`, `salt`, `algorithm`, `contact_name`, `country_code`, `phone`, `zipcode`, `address`, `city`, `state`, `can_be_deleted`, `is_active`, `is_super_admin`, `is_staff`, `created_at`, `last_login`, `updated_at`, `user_parent_id`) VALUES
(1, 'admin', NULL, NULL, 'moamenmashael@yahoo.com', '322f55c5e83f2a4768e3a90988687f7f03bb7ed2', 'a73056c2bbdca2d4148049493e296e70', 'sha1', NULL, NULL, '2125551212', '11222', 'PO Box 345', 'Flushing', 'NY', 0, 1, 1, 0, '2009-11-23 12:36:31', '2012-12-05 11:57:45', '2012-12-05 11:57:45', NULL),
(2, 'lukasz4k@gmail.com', 'asdf', 'asdf', 'lukasz4k@gmail.com', 'a5c0daa9f08634f1d610c50a71aebb65fd8ae46a', '97a7d16eac6e73ce8ac31320455daced', 'sha1', NULL, '', '', '11222', '34 new street', 'new york', 'NY', 1, 0, 0, 0, '2012-08-27 19:33:23', '0000-00-00 00:00:00', '2012-09-18 12:06:03', NULL),
(4, 'moamenmashael@gmail.com', 'Moamen', 'Mashael', 'moamenmashael@gmail.com', 'c771b4dc5a0b3752ae7dd74db69ad38a4b4b55cf', '0587984775807bb17f46dfe0a1d3658f', 'sha1', NULL, NULL, '', '32888', 'bishtami', 'Al Shohadaa', 'DC', 1, 1, 0, 0, '2012-08-30 12:57:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(5, 'moamenmashael@hotmail.com', 'Moamen', 'Mashael', 'moamenmashael@hotmail.com', '920db5bc4cfb613b2828da01b3a158fde95dd288', '5979d17ace1fa21498ba61a278d9c874', 'sha1', NULL, '+20', '1116904793', '32888', 'bishtami', 'Al Shohadaa', 'CT', 1, 1, 0, 0, '2012-08-30 13:03:08', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `auth_user_permission`
--
CREATE TABLE IF NOT EXISTS `auth_user_permission` (
`user_id` int(11) unsigned NOT NULL,
`permission_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`user_id`,`permission_id`),
KEY `fk_persmission__action_id___action__id` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `centurion_content_type`
--
CREATE TABLE IF NOT EXISTS `centurion_content_type` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `centurion_content_type`
--
INSERT INTO `centurion_content_type` (`id`, `name`) VALUES
(2, 'Cms_Model_DbTable_Flatpage'),
(3, 'Cms_Model_DbTable_Row_Flatpage'),
(8, 'Core_Model_DbTable_Navigation');
-- --------------------------------------------------------
--
-- Table structure for table `centurion_navigation`
--
CREATE TABLE IF NOT EXISTS `centurion_navigation` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(150) DEFAULT NULL,
`module` varchar(100) DEFAULT NULL,
`controller` varchar(100) DEFAULT NULL,
`action` varchar(100) DEFAULT NULL,
`params` text,
`permission` varchar(255) DEFAULT NULL,
`route` varchar(100) DEFAULT NULL,
`uri` varchar(255) DEFAULT NULL,
`order` int(11) DEFAULT NULL,
`is_visible` int(1) NOT NULL DEFAULT '1',
`class` varchar(50) DEFAULT NULL,
`mptt_lft` int(11) unsigned NOT NULL,
`mptt_rgt` int(11) unsigned NOT NULL,
`mptt_level` int(11) unsigned NOT NULL,
`mptt_tree_id` int(11) unsigned DEFAULT NULL,
`mptt_parent_id` int(11) unsigned DEFAULT NULL,
`proxy_model` int(11) unsigned DEFAULT NULL,
`proxy_pk` int(11) unsigned DEFAULT NULL,
`can_be_deleted` int(11) unsigned DEFAULT '1',
PRIMARY KEY (`id`),
KEY `proxy_model` (`proxy_model`,`proxy_pk`),
KEY `fk_navigation__navigation_parent_id___navigation__id` (`mptt_parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- Dumping data for table `centurion_navigation`
--
INSERT INTO `centurion_navigation` (`id`, `label`, `module`, `controller`, `action`, `params`, `permission`, `route`, `uri`, `order`, `is_visible`, `class`, `mptt_lft`, `mptt_rgt`, `mptt_level`, `mptt_tree_id`, `mptt_parent_id`, `proxy_model`, `proxy_pk`, `can_be_deleted`) VALUES
(1, 'Backoffice', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 190, 0, 22, NULL, NULL, NULL, 0),
(2, 'Frontoffice', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 34, 0, 30, NULL, NULL, NULL, 0),
(4, 'Draft', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'unactived', 1, 2, 0, 27, NULL, NULL, NULL, 0),
(5, 'Manage Vehicles', 'form', 'manage-vehicles', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 167, 168, 2, 22, 18, NULL, NULL, 1),
(6, 'Manage Locations', 'form', 'manage-locations', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 171, 172, 2, 22, 18, NULL, NULL, 1),
(7, 'Manage Trip Fees', 'form', 'manage-trips', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 173, 174, 2, 22, 18, NULL, NULL, 1),
(10, 'Manage Reservations', 'form', 'manage-reservations', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 177, 178, 2, 22, 18, NULL, NULL, 1),
(11, 'Manage Users', 'auth', 'admin-user', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 156, 157, 1, 22, 1, NULL, NULL, 1),
(12, 'Settings', 'form', 'manage-settings', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 164, 165, 1, 22, 1, NULL, NULL, 1),
(13, 'Manage Pages', 'cms', 'admin-pages', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 158, 161, 1, 22, 1, NULL, NULL, 1),
(15, 'Manage Airlines', 'form', 'manage-airlines', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 175, 176, 2, 22, 18, NULL, NULL, 1),
(16, 'Manage Page Templates', 'cms', 'admin-flatpage-template', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 159, 160, 2, 22, 13, NULL, NULL, 1),
(17, 'Manage Coupons', 'form', 'manage-coupons', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 179, 180, 2, 22, 18, NULL, NULL, 1),
(18, 'Reservations', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 166, 189, 1, 22, 1, NULL, NULL, 1),
(19, 'Email Templates', 'form', 'manage-emailtemplates', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 185, 186, 2, 22, 18, NULL, NULL, 1),
(20, 'Optional Services', 'form', 'manage-optionalservices', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 169, 170, 2, 22, 18, NULL, NULL, 1),
(21, 'Manage States', 'form', 'manage-states', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 181, 182, 2, 22, 18, NULL, NULL, 1),
(22, 'Manage Zipcodes', 'form', 'manage-zipcodes', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 183, 184, 2, 22, 18, NULL, NULL, 1);
-- --------------------------------------------------------
--
-- Table structure for table `centurion_site`
--
CREATE TABLE IF NOT EXISTS `centurion_site` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`domain` varchar(100) NOT NULL,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `centurion_site`
--
INSERT INTO `centurion_site` (`id`, `domain`, `name`) VALUES
(1, 'example.com', 'example.com');
-- --------------------------------------------------------
--
-- Table structure for table `cms_flatpage`
--
CREATE TABLE IF NOT EXISTS `cms_flatpage` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`slug` varchar(100) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`keywords` varchar(255) DEFAULT NULL,
`body` text,
`sidebar` text,
`url` varchar(100) DEFAULT NULL,
`flatpage_template_id` int(11) unsigned NOT NULL,
`flatpage_position_id` int(11) unsigned DEFAULT NULL,
`published_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`is_published` int(1) unsigned DEFAULT '0',
`mptt_lft` int(11) unsigned NOT NULL,
`mptt_rgt` int(11) unsigned NOT NULL,
`mptt_level` int(11) unsigned NOT NULL,
`mptt_tree_id` int(11) unsigned DEFAULT NULL,
`mptt_parent_id` int(11) unsigned DEFAULT NULL,
`original_id` int(11) unsigned DEFAULT NULL,
`language_id` int(11) unsigned DEFAULT NULL,
`forward_url` varchar(255) DEFAULT NULL,
`flatpage_type` int(1) NOT NULL DEFAULT '1',
`route` varchar(50) DEFAULT NULL,
`class` varchar(255) DEFAULT NULL,
`cover_id` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `flatpage_template_id` (`flatpage_template_id`),
KEY `flatpage_position_id` (`flatpage_position_id`),
KEY `flatpage_cover_id` (`cover_id`),
KEY `mptt_parent_id` (`mptt_parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `cms_flatpage`
--
INSERT INTO `cms_flatpage` (`id`, `title`, `slug`, `description`, `keywords`, `body`, `sidebar`, `url`, `flatpage_template_id`, `flatpage_position_id`, `published_at`, `created_at`, `updated_at`, `is_published`, `mptt_lft`, `mptt_rgt`, `mptt_level`, `mptt_tree_id`, `mptt_parent_id`, `original_id`, `language_id`, `forward_url`, `flatpage_type`, `route`, `class`, `cover_id`) VALUES
(3, 'Terms and Condition', 'terms-and-condition', NULL, NULL, '<p>Your access to and use of the CourierCLS Website (the \\"Site\\") is subject to the following terms and conditions (\\"Terms and Conditions\\") and all applicable laws. By accessing and browsing the Site, you accept, without limitation or qualification, the Terms and Conditions and acknowledge that any other agreements between you and CourierCLS are superseded and of no force or effect.</p>\r\n<h3>1. Terms and Conditions:</h3>\r\n<ul>\r\n<li>Changes and cancellations require 24 hours advance notice on- line or can be made within 2 hours (nationwide) by calling CourierCLS at (877) 892-6182 for calls outside the U.S. and Canada</li>\r\n<li>CourierCLS monitors all commercial airline arrivals. A 30-minute grace period is allowed on all domestic arrivals and 60 minutes on all international arrivals. After the grace period, waiting time charges will apply. Waiting time charges are accrued in quarter hour increments, based on the vehicle’s hourly rate.</li>\r\n<li>A 15-minute grace period is allowed on pick-ups other than at an airport. After the grace period, waiting time charges will apply. Waiting time charges are accrued in quarter hour increments, based on the vehicle’s hourly rate.</li>\r\n<li>Full fare (including a 20% gratuity) will be billed for late cancellations. If you cannot locate your driver please call CourierCLS at (877) 892-6182 for calls outside the U.S. and Canada. To avoid being billed as a no-show, we advise you not to leave your location without contacting CourierCLS.</li>\r\n<li>Rates are subject to change without notice. CourierCLS is not responsible for services delayed or not rendered due to weather or other circumstances beyond its control.</li>\r\n<li>RATE ESTIMATE The rate presented to you prior to your trip is an initial estimate of the cost of service as reserved. Wait time, taxes, extra stops or additional services may change your rate.</li>\r\n</ul>\r\n<h3>2. Use of Personal Data.</h3>\r\n<p>CourierCLS Worldwide Chauffeured Services (\\"CourierCLS\\") takes your privacy very seriously and understands the importance of knowing how your personal information is being used and shared. For more information See <a>Privacy Policy</a>.</p>\r\n<h3>3. Copyrights, Trademarks and Ownership.</h3>\r\n<p>All content included on the Site, including text, graphics, logos, images, news, articles, software scripts and applets (\\"Content\\"), is the property of CourierCLS or its affiliates, and is protected by United States and International copyright laws. You may not modify, copy, distribute, transmit, display, perform, reproduce, publish, license, create derivative works from, transfer, or sell any information, software, or services obtained from the Site without the written permission of CourierCLS. Any other use, including the reproduction, modification, distribution, transmission, republication, display or performance, or any exploitation, of the Site or any of the Content or software on the Site, in whole or in part, is strictly prohibited.</p>\r\n<p>The trademarks, logos, and service marks (collectively the \\"Trademarks\\") displayed on the Site are the registered and unregistered Trademarks of CourierCLS and others.</p>\r\n<p>Nothing contained on the Site should be construed as granting, by implication, estoppel, or otherwise, any license or right to use any Trademark displayed on the Site without the written permission of CourierCLS or such third party that may own the Trademarks displayed on the Site. Your misuse of the Trademarks displayed on the Site, or any other content on the Site, except as provided in these Terms and Conditions, is strictly prohibited. CourierCLS will aggressively enforce its intellectual property rights to the fullest extent of the law.</p>\r\n<h3>4. Disclaimers of Warranties and Liability.</h3>\r\n<p>CourierCLS DOES NOT WARRANT OR MAKE ANY REPRESENTATIONS REGARDING THE USE OR THE RESULTS OF THE USE OF THE MATERIALS IN THE SITE IN TERMS OF THEIR CORRECTNESS, ACCURACY, RELIABILITY, OR OTHERWISE.</p>\r\n<p>CourierCLS AND/OR ITS RESPECTIVE AFFILIATES AND SUPPLIERS MAY MAKE IMPROVEMENTS AND/OR CHANGES TO THE SITE AT ANY TIME.</p>\r\n<p>ALL INFORMATION, SOFTWARE, AND SERVICES ON THE SITE ARE PROVIDED \\"AS IS\\" WITHOUT WARRANTY OF ANY KIND EITHER EXPRESS OR IMPLIED. CourierCLS, ITS AFFILIATES AND/OR ITS SUPPLIERS HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH REGARD TO THIS INFORMATION, SOFTWARE, PRODUCTS, AND SERVICES INCLUDING, WITHOUT LIMITATION, ALL IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE, AND NON-INFRINGEMENT. IN NO EVENT SHALL CourierCLS, ITS AFFILIATES AND/OR ITS SUPPLIERS BE LIABLE FOR ANY DIRECT, INDIRECT, PUNITIVE, INCIDENTAL, COVER, SPECIAL, OR CONSEQUENTIAL DAMAGES OR LOSS OF PROFITS ARISING OUT OF OR IN ANY WAY CONNECTED WITH THE USE OF THE SITE OR WITH THE DELAY OR INABILITY TO USE THE SITE, OR FOR ANY INFORMATION, SOFTWARE OR SERVICES OBTAINED THROUGH THE SITE, OR OTHERWISE ARISING OUT OF THE USE OF THE SITE, WHETHER BASED ON CONTRACT, TORT, STRICT LIABILITY OR OTHERWISE, EVEN IF CourierCLS OR ANY OF ITS AFFILIATES OR SUPPLIERS HAS BEEN ADVISED OF THE POSSIBILITY OF DAMAGES. BECAUSE SOME STATES/JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY OF CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU.</p>\r\n<h3>5. Secure and Lawful Use.</h3>\r\n<p>You agree to comply with and abide by any security measures or systems implemented from time to time by CourierCLS in connection with the Site, including but not limited to passwords or encryption mechanisms (such as digital certificates). As a condition of your use of the Site, you also warrant to CourierCLS that you will not use the Site for any purpose that is unlawful or prohibited by these Terms and Conditions. You are prohibited from posting or transmitting any unlawful, threatening, libelous, defamatory, obscene, scandalous, inflammatory, pornographic, or profane material or any materials that could constitute or encourage conduct that would be considered a criminal offense, give rise to civil liability, or otherwise violate any law. CourierCLS will fully cooperate with any law enforcement authorities or court order requesting or directing CourierCLS to disclose the identity of anyone posting such information or materials.</p>\r\n<h3>6. Informational Hyperlinks.</h3>\r\n<p>The Site may contain hyperlinks to websites operated by parties other than CourierCLS. Such hyperlinks are provided for your reference only.</p>\r\n<p>CourierCLS explicitly disclaims responsibility for the accuracy, copyright compliance, or reliability of material provided by or about third parties. Furthermore, CourierCLS does not make any representations or warranties as to the security of any information (including, without limitation, credit card and other personal information) you might be requested to give any third party, and you hereby irrevocably waive any claim against CourierCLS with respect to such other operator or company. CourierCLS strongly encourages you to make whatever investigation you feel necessary or appropriate before proceeding with any online or offline transaction with any other operator or company.</p>\r\n<h3>7. Software Available on the Site.</h3>\r\n<p>CourierCLS hereby grants to you, the user, a personal, nontransferable license to use any downloadable software applets (\\"the Software\\") for viewing and otherwise using the Site in accordance with these Terms and Conditions and for no other purpose.</p>\r\n<p>Please note that all Software, including without limitation all HTML code, Java Script and ActiveX controls contained in the Site, is owned by CourierCLS, its affiliates, and/or its suppliers and is protected by copyright laws and international treaty provisions. Any reproduction or redistribution of the Software is expressly prohibited by law.</p>\r\n<p>WITHOUT LIMITING THE FOREGOING, COPYING OR REPRODUCTION OF THE SOFTWARE TO ANY OTHER SERVER OR LOCATION FOR FURTHER REPRODUCTION OR REDISTRIBUTION IS EXPRESSLY PROHIBITED. THE SOFTWARE IS WARRANTED, IF AT ALL, ONLY ACCORDING TO THE TERMS OF THE LICENSE AGREEMENT.</p>\r\n<h3>8. Use of CourierCLS\\''s Customer Online Services.</h3>\r\n<p>The Site is provided solely for assisting CourierCLS\\'' customers in making legitimate reservations, retrieving online ride receipts or otherwise transacting business with CourierCLS, and for no other purposes. You agree to be financially responsible for all of your use of the Site (as well as for use of your account by others, including without limitation, minors living with you). You agree to supervise all usage by minors of the Site under your name or account. You also warrant that all information supplied by you or members of your household in using the Site is true and accurate. You understand that overuse or abuse of the reservation request facilities of the Site may result in your being denied access to such facilities.</p>\r\n<h3>9. General.</h3>\r\n<p>This agreement is governed by the laws of the State of New York, U.S.A., without regard to principals of conflicts of law. You hereby consent to the exclusive jurisdiction and venue of courts in Columbia County, New York, U.S.A., in all disputes arising out of or relating to the use of the Site. Use of the Site is unauthorized in any jurisdiction that does not give effect to all provision of these Terms and Conditions, including without limitation this paragraph.</p>\r\n<p>If any part of this agreement is determined to be invalid or unenforceable pursuant to applicable law including, but not limited to, the warranty disclaimers and liability limitations set forth above, then the invalid or unenforceable provision will be deemed superseded by a valid, enforceable provision that most closely matches the intent of the original provision and the remainder of the agreement shall continue in effect.</p>\r\n<p>This agreement constitutes the entire agreement between the customer and CourierCLS with respect to the Site and supersedes all prior or contemporaneous communications and proposals, whether electronic, oral, or written, between the customer and CourierCLS with respect to the Site. A printed version of this agreement and of any notice given in electronic form shall be admissible in judicial or administrative proceedings based upon or relating to this agreement to the same extent and subject to the same conditions as other business documents and records originally generated and maintained in printed form.</p>\r\n<p>Any rights not expressly granted herein are reserved.</p>\r\n<p>CourierCLS may at any time without notice revise these Terms and Conditions by updating this page. You are bound by any such revisions and should therefore; periodically visit this page to review the then currrent Terms and Conditions. Your use of CourierCLS\\'' services indicates your acceptance of these Terms and Conditions.</p>', '<h6 class=\\"\\\\"vlist\\\\"\\">IMPORTANT INFORMATION</h6>\r\n<ul class=\\"\\\\"vlist\\\\"\\">\r\n<li class=\\"\\\\"active\\\\"\\"><a href=\\"\\\\\\">Travelling with childre</a></li>\r\n<li><a href=\\"\\\\\\">Passengers with special needs</a></li>\r\n<li><a href=\\"\\\\\\">Travel documents</a></li>\r\n<li><a href=\\"\\\\\\">Special documents</a></li>\r\n<li><a href=\\"\\\\\\">At the airport</a></li>\r\n<li><a href=\\"\\\\\\">Carrying animals</a></li>\r\n<li><a href=\\"\\\\\\">Baggage</a></li>\r\n<li><a href=\\"\\\\\\">Check-in</a></li>\r\n<li><a href=\\"\\\\\\">On board</a></li>\r\n<li><a href=\\"\\\\\\">FAQ</a></li>\r\n<li><a href=\\"\\\\\\">Passenger rights</a></li>\r\n<li><a href=\\"\\\\\\">General Conditions of Carriage</a></li>\r\n</ul>', '/terms.html', 3, NULL, '2012-08-26 04:00:00', '2012-08-26 23:26:14', '2012-09-10 19:48:19', 1, 2, 3, 1, 4, 6, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(4, 'At The Airport', 'at-the-airport', NULL, NULL, '<p>At the airport</p>', '<ul>\r\n<li>Look for a car</li>\r\n<li>Make sure that you ....</li>\r\n<li>Present your recipt to the driver</li>\r\n<li>Have your credit card ready</li>\r\n</ul>', '/at-the-airport.html', 3, NULL, '2012-08-31 04:00:00', '2012-08-31 16:29:19', '2012-09-11 02:01:34', 1, 1, 2, 0, 2, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(6, 'Important information', 'important-information', NULL, NULL, NULL, '<h6 class=\\"vlist\\">IMPORTANT INFORMATION</h6>\r\n<ul class=\\"vlist\\">\r\n<li class=\\"active\\"><a href=\\"#\\">Travelling with childre</a></li>\r\n<li><a href=\\"#\\">Passengers with special needs</a></li>\r\n<li><a href=\\"#\\">Travel documents</a></li>\r\n<li><a href=\\"#\\">Special documents</a></li>\r\n<li><a href=\\"#\\">At the airport</a></li>\r\n<li><a href=\\"#\\">Carrying animals</a></li>\r\n<li><a href=\\"#\\">Baggage</a></li>\r\n<li><a href=\\"#\\">Check-in</a></li>\r\n<li><a href=\\"#\\">On board</a></li>\r\n<li><a href=\\"#\\">FAQ</a></li>\r\n<li><a href=\\"#\\">Passenger rights</a></li>\r\n<li><a href=\\"#\\">General Conditions of Carriage</a></li>\r\n</ul>', '/important-information.html', 1, NULL, '2012-09-03 04:00:00', '2012-09-03 10:56:13', '2012-09-10 19:48:19', 0, 1, 6, 0, 4, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(8, 'Important Information', 'important-information', NULL, NULL, NULL, '<div id=\\"col1_content\\">\r\n<h6 class=\\"vlist\\">IMPORTANT INFORMATION</h6>\r\n<ul class=\\"vlist\\">\r\n<li class=\\"active\\"><a href=\\"/terms.html\\">Terms and Conditions</a></li>\r\n<li><a href=\\"/privacy-policy.html\\">Privacy Policy</a></li>\r\n</ul>\r\n</div>', '/important-info.html', 3, NULL, '2012-09-10 04:00:00', '2012-09-10 19:47:14', '2012-09-11 01:56:56', 0, 1, 2, 0, 5, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(9, 'About CourierCLS', 'about-couriercls', NULL, NULL, '<p>When you\\''re in charge of getting that somebody special from Point A to Point B, you want only the best. Whether it\\''s the CEO of your largest client, your beautiful daughter and her wedding party or taking that special person out for the evening, knowing that they arrived safely and on time is the most important factor. You want to put those important to you in the hands of somebody like you that has their safety at heart as much as getting them there on time.</p>\r\n<p>That\\''s why you call a transportation company like CourierCLS. When our highly trained, experienced and uniformed chauffeurs arrive in one of our new, sleek, shiny, styling vehicles, you\\''ll know you made the right call. We know that the destination is only part of the equation. The presentation and the functionality are just as important. </p>\r\n<p>When it comes to transporting those important to you, CourierCLS won\\''t send in the clowns! We only send out the best of the best in the best vehicle for your needs. </p>', '<div id=\\"col1_content\\">\r\n<h6 class=\\"vlist\\">Highlights</h6>\r\n<ul class=\\"vlist\\">\r\n<li><a>Excellent customer service</a></li>\r\n<li><a>No hidden fees; fine print</a></li>\r\n<li><a>Complete focus on your satisfaction</a></li>\r\n<li><a>We don\\''t share <em>your</em> ride</a></li>\r\n<li><a>Quick transportation to/from JFK, LGA and EWR</a></li>\r\n<li><a>Consistent and accurate rates available before your trip</a></li>\r\n</ul>\r\n</div>', '/about-couriercls.html', 3, NULL, '2012-09-10 04:00:00', '2012-09-11 01:49:15', '2012-09-15 12:04:32', 1, 1, 2, 0, 6, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(10, 'Why CourierCLS', 'why-couriercls', NULL, NULL, '<p>With so many options to get around the New York and surrounding areas, why should you choose CourierCLS? Besides the fact that you can rest easy knowing that your passengers are safe and will arrive on time, here are a few other reasons you should choose CourierCLS:</p>\r\n<ul>\r\n<li>We are locally owned and we are everywhere you need us. No matter where you are in the tri-state area, CourierCLS is just a phone call and a short distance away. Don\\''t worry about extra mileage charges because we had to come across the river to get you. We\\''re already there!</li>\r\n<li>We operate 24 hours a day, 7 days a week with a full staff of experienced, knowledgeable travel experts to book your transportation needs the most efficient and cost effective way possible and experienced, trained chauffeurs. CourierCLS is always on-call and ready to go a moments notice or book ahead for that special event. We\\''ll be here for you. The hotel leaves the light on for you … We leave the motor running for you.</li>\r\n<li>We not only arrive at pick up on, but we make sure our passengers arrive on time, safe, secure, sound. With only experienced and trained chauffeurs that know the area better than our passengers, we don\\''t have to offer you a free trip to back up our guarantee. We know we\\''ll be on time, every time.</li>\r\n<li>The newest, sleek and sexy fleet of cars are at your service with CourierCLS. Our entire fleet is equipped with the finest, newest equipment inside for your convenience on the inside. We have only the best technology available for our drivers to navigate their way around traffic and construction to your desired location, and under the hood, the power that is second only to a race car while being environmentally conscious too.</li>\r\n</ul>\r\n<p>CourierCLS knows that it\\''s not just getting you to your destination that counts, but how it looks, rides and feels is important too. No matter if your chauffeur needs are for transporting a wedding party, those special customers or just a weekend of romance with your love, CourierCLS is the service you need to make it all happen.</p>', '<div id=\\"col1_content\\">\r\n<h6 class=\\"vlist\\">Highlights</h6>\r\n<ul class=\\"vlist\\">\r\n<li><a>Located in Queens, NY</a></li>\r\n<li><a>15 min. from JFK</a></li>\r\n<li><a>10 min. from LGA</a></li>\r\n<li><a>24/7 Hotline</a></li>\r\n<li><a>Express service to NYC</a></li>\r\n</ul>\r\n</div>', '/why-couriercls.html', 3, NULL, '2012-09-10 04:00:00', '2012-09-11 01:58:18', '2012-09-25 16:07:26', 1, 1, 2, 0, 7, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(11, 'Our Fleet', 'our-fleet', NULL, NULL, '<h3>Our Fleet</h3>', NULL, '/our-fleet.html', 1, NULL, '2012-09-10 04:00:00', '2012-09-11 02:00:43', '2012-09-11 02:03:29', 1, 1, 2, 0, 8, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(12, 'CourierCLS Blog', 'couriercls-blog', NULL, NULL, '<h3>CourierCLS Blog</h3>', NULL, '/couriercls-blog.html', 1, NULL, '2012-09-10 04:00:00', '2012-09-11 02:02:19', '2012-09-25 12:54:06', 0, 1, 2, 0, 9, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(13, 'Customer Service Center', 'customer-service-center', NULL, NULL, '<h3>Customer Service Center</h3>', NULL, '/customer-service.html', 3, NULL, '2012-09-10 04:00:00', '2012-09-11 02:03:04', '2012-09-11 02:04:20', 1, 1, 2, 0, 10, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL),
(14, 'Privacy Policy', 'privacy-policy', NULL, NULL, '<h3>Overview</h3>\r\n<p>CourierCLS Worldwide Chauffeured Services (“CourierCLS”) takes your privacy very seriously and understands the importance of knowing how your personal information is being used and shared. This policy describes the types of information collected, how it may and may not be used, and how it is protected. By visiting CourierCLS’s website, and/or using any of our services on the website, you acknowledge that you accept the policies and procedures outlined in this Privacy Policy and our use of your information in accordance with this Privacy Policy.</p>\r\n<h3>Information Collected From Users</h3>\r\n<p>In the course of your browsing the Website, CourierCLS may collect the IP/URL address of the computer through which your visit is enabled (for example your Internet Service Provider\\''s server); cookie information. Upon any registration for, and in subsequent interaction with, Website Services, CourierCLS will collect mandatory information such as your User Name, Password, primary email address, phone number, company name, and password hint question and answer. To access and make reservations, obtain receipts, through CourierCLS’ website will require you to complete a new user form. This form will request certain personal information about the Web Site user and the traveler who will use our transportation services. This information will be compiled into a profile. Such information may include at least the following; email addresses for receipts and confirmations, contact phone numbers, company name, or account number, home address and billing address, pick-up and drop-off information, credit card information.</p>\r\n<h3>How we use your information</h3>\r\n<p>CourierCLS collects user information to create a personalized experience for you and to fulfill all ground transportation requests. Once this information is collected, you are not anonymous to us; however, this information will not be shared with any third parties. CourierCLS will not place your name, email address, physical address or any other personally identifiable information into any marketing, promotional database, or mailing list. CourierCLS uses sensitive billing information (such as cardholder name, credit card number, and expiration date) for the purpose of completing the travel purchases you conduct on our site. We use other information about you for the following general purposes: to provide you with the products and services you request; travel confirmation, receipts and updates; to manage your account, including processing bills and providing travel notifications; to communicate with you in general; to respond to your questions and comments; to measure interest in and improve our products, services, and Web site; to notify you about special offers and products or services that may be of interest to you; to otherwise customize your experience with CourierCLS.com; to reward you as part of any reward and recognition program; to solicit information from you, including through surveys; to resolve disputes, or troubleshoot problems; to enforce our Terms of Use.</p>\r\n<h3>Security</h3>\r\n<p>We have established and maintain the highest level of security to safeguard the confidentiality of your Personally Identifiable Information, including the use of encryption, firewalls, and Secure Socket Layers. In an effort to protect all data against loss and unauthorized access, we employ many different security techniques to protect such data from unauthorized access by users inside and outside the company including regulating the physical and virtual access to any root access, database(s), servers, back-ups, encryption keys or other network and security-related infrastructure components. In addition, sensitive information such as passwords are encrypted before being stored in our systems such that even if a breach were to occur and access to the data achieved, the data would still be encrypted. Please be aware that while we take efforts to safeguard your user information, \\"perfect security\\" does not exist on the Internet.</p>\r\n<h3>Changes to the CourierCLS’ Privacy Policy</h3>\r\n<p>You agree that CourierCLS may amend this policy from time to time by posting the revised Privacy Policy on this Website. Please check the revision date at the top of this page to determine whether the policy has been modified since you last reviewed it. Your continued use of any portion of the Website or CourierCLS’ service following the posting of the revised policy will constitute your acceptance of the changes.</p>', NULL, '/privacy-policy.html', 3, NULL, '2012-09-10 04:00:00', '2012-09-11 02:17:25', '2012-09-11 02:17:42', 1, 1, 2, 0, 11, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `cms_flatpage_position`
--
CREATE TABLE IF NOT EXISTS `cms_flatpage_position` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`key` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `cms_flatpage_position`
--
INSERT INTO `cms_flatpage_position` (`id`, `name`, `key`) VALUES
(2, 'الÙوتر', 'footer');
-- --------------------------------------------------------
--
-- Table structure for table `cms_flatpage_template`
--
CREATE TABLE IF NOT EXISTS `cms_flatpage_template` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`view_script` varchar(50) NOT NULL,
`class` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `cms_flatpage_template`
--
INSERT INTO `cms_flatpage_template` (`id`, `name`, `view_script`, `class`) VALUES
(1, 'Basic', '_generic/basic.phtml', NULL),
(2, 'Basic no title', '_generic/basic-notitle.phtml', NULL),
(3, 'With sidebar and breadcrumb', '_generic/content-sidebar-breadcrumb.phtml', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `form_airlines`
--
CREATE TABLE IF NOT EXISTS `form_airlines` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`code` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=281 ;
--
-- Dumping data for table `form_airlines`
--
INSERT INTO `form_airlines` (`id`, `name`, `code`) VALUES
(1, 'AB Airlines', NULL),
(2, 'Adam Air Indonesia', NULL),
(3, 'ADC Airlines', NULL),
(4, 'Adria Airways', NULL),
(5, 'Aer Lingus', NULL),
(6, 'AerArann', NULL),
(7, 'Aeroflot', NULL),
(8, 'Aerolineas Argentinas', NULL),
(9, 'Aerolitoral', NULL),
(10, 'AeroMexico', NULL),
(11, 'Aeropelican', NULL),
(12, 'AeroSvit', NULL),
(13, 'Air Berlin', NULL),
(14, 'Air Canada', NULL),
(15, 'Air China', NULL),
(16, 'Air Comet', NULL),
(17, 'Air Europa', NULL),
(18, 'Air France', NULL),
(19, 'Air Gozo', NULL),
(20, 'Air India', NULL),
(21, 'Air Inuit', NULL),
(22, 'Air Jamaica', NULL),
(23, 'Air Kazakhstan', NULL),
(24, 'Air Labrador', NULL),
(25, 'Air Malta', NULL),
(26, 'Air Mauritius', NULL),
(27, 'Air Midwest', NULL),
(28, 'Air New Zealand', NULL),
(29, 'Air Niugini', NULL),
(30, 'Air One', NULL),
(31, 'Air Pacific', NULL),
(32, 'Air Paradise', NULL),
(33, 'Air Polonia', NULL),
(34, 'Air Rarotonga', NULL),
(35, 'Air Scotland', NULL),
(36, 'Air Seychelles', NULL),
(37, 'Air Tahiti-Nui', NULL),
(38, 'Air Tran Airways', NULL),
(39, 'Air Transat', NULL),
(40, 'Air UK', NULL),
(41, 'Air Vanuatu', NULL),
(42, 'Air Wisconsin', NULL),
(43, 'Airlines of Mexico', NULL),
(44, 'Airlines of South America', NULL),
(45, 'AirTran', NULL),
(46, 'Alaska', NULL),
(47, 'Alitalia', NULL),
(48, 'All Nippon (ANA)', NULL),
(49, 'Allegiant Air', NULL),
(50, 'ALM Antillean Airlines', NULL),
(51, 'Alma de Mexico', NULL),
(52, 'America West', NULL),
(53, 'America West Express', NULL),
(54, 'American Airlines', NULL),
(55, 'American Eagle', NULL),
(56, 'American Trans Air', NULL),
(57, 'AMR Corp.', NULL),
(58, 'ANA (All Nippon)', NULL),
(59, 'AOM French Airlines', NULL),
(60, 'Arik Air', NULL),
(61, 'Asiana', NULL),
(62, 'ATA Connection', NULL),
(63, 'Atlantic Aviation', NULL),
(64, 'Atlantic Coast Airlines', NULL),
(65, 'Atlantic Southeast Airlines', NULL),
(66, 'Atlasjet', NULL),
(67, 'Aurigny', NULL),
(68, 'Austrian', NULL),
(69, 'Avianca', NULL),
(70, 'Avolar', NULL),
(71, 'Bahamasair', NULL),
(72, 'Baltia Air Lines', NULL),
(73, 'Belavia', NULL),
(74, 'BigSky Airlines', NULL),
(75, 'bmi British Midland', NULL),
(76, 'bmiBaby', NULL),
(77, 'Bouraq', NULL),
(78, 'Braathens SAFE', NULL),
(79, 'British Airways', NULL),
(80, 'Brussels Airlines', NULL),
(81, 'CanJet', NULL),
(82, 'Cape Air', NULL),
(83, 'Cargolux', NULL),
(84, 'Caribbean', NULL),
(85, 'Caribbean Sun Airlines', NULL),
(86, 'Cathay Pacific', NULL),
(87, 'Cayman Airways', NULL),
(88, 'Centralwings', NULL),
(89, 'China Air', NULL),
(90, 'China Airlines', NULL),
(91, 'China Eastern', NULL),
(92, 'China Southern Airlines', NULL),
(93, 'Comair', NULL),
(94, 'Continental Airlines', NULL),
(95, 'Continental Express', NULL),
(96, 'Copa Airlines', NULL),
(97, 'COPA Panama', NULL),
(98, 'Corsair', NULL),
(99, 'Croatia Airlines', NULL),
(100, 'Crossair', NULL),
(101, 'Cubana', NULL),
(102, 'Czech Airlines', NULL),
(103, 'Delta Air Lines', NULL),
(104, 'Delta Connection', NULL),
(105, 'Delta Shuttle', NULL),
(106, 'Desert Sun,', NULL),
(107, 'Druk Air (Royal Bhutan Airlines)', NULL),
(108, 'Eagle Canyon Airlines', NULL),
(109, 'EasyJet', NULL),
(110, 'EgyptAir', NULL),
(111, 'El Al', NULL),
(112, 'Emirates', NULL),
(113, 'Ethiopian Airlines', NULL),
(114, 'Etihad', NULL),
(115, 'Eurofly', NULL),
(116, 'EVA Airways', NULL),
(117, 'Ezjet Air Services', NULL),
(118, 'Eznis Airways', NULL),
(119, 'Finnair', NULL),
(120, 'Finncomm Airlines', NULL),
(121, 'Florida Gulf', NULL),
(122, 'Flybe', NULL),
(123, 'FlyGlobespan', NULL),
(124, 'FreshAer', NULL),
(125, 'Frontier', NULL),
(126, 'Futura', NULL),
(127, 'Garuda Indonesia', NULL),
(128, 'Georgia National Airlines', NULL),
(129, 'Georgian Airways', NULL),
(130, 'German Wings', NULL),
(131, 'Go!', NULL),
(132, 'GoAir', NULL),
(133, 'Great Lakes Airlines', NULL),
(134, 'Great Lakes Aviation', NULL),
(135, 'Gryphon', NULL),
(136, 'Gulf Air', NULL),
(137, 'Gulfstream International', NULL),
(138, 'Hapag-Lloyd Express', NULL),
(139, 'Harmony Airways', NULL),
(140, 'Hawaiian', NULL),
(141, 'Hewa Bora Airways', NULL),
(142, 'Iberia', NULL),
(143, 'Iceland Express', NULL),
(144, 'Icelandair', NULL),
(145, 'Indian Airlines', NULL),
(146, 'Interjet', NULL),
(147, 'Interstate Jet', NULL),
(148, 'Island Air', NULL),
(149, 'Japan Airlines', NULL),
(150, 'Japanese', NULL),
(151, 'Jet Airways', NULL),
(152, 'Jet America', NULL),
(153, 'Jet2', NULL),
(154, 'JetBlue', NULL),
(155, 'Kenya Airways', NULL),
(156, 'Kingfisher Airlines', NULL),
(157, 'KLM', NULL),
(158, 'Korean Air', NULL),
(159, 'Kulula.com', NULL),
(160, 'Kuwait Airways', NULL),
(161, 'Lacsa', NULL),
(162, 'Lan Chile', NULL),
(163, 'Lan Ecuador', NULL),
(164, 'Lan Peru', NULL),
(165, 'Landmark Aviation', NULL),
(166, 'LatinPass', NULL),
(167, 'Lauda Air', NULL),
(168, 'Liberty Express', NULL),
(169, 'Lion Air', NULL),
(170, 'lOT Polish Airlines', NULL),
(171, 'LTU', NULL),
(172, 'Lufthansa', NULL),
(173, 'Luxair', NULL),
(174, 'Macair Airlines', NULL),
(175, 'Macedonian Airlines', NULL),
(176, 'Malaysia', NULL),
(177, 'Mal�v', NULL),
(178, 'Mango', NULL),
(179, 'MEA - Middle East Airlines', NULL),
(180, 'Meridiana Fly', NULL),
(181, 'Mesa Air', NULL),
(182, 'Mexicana', NULL),
(183, 'Miami Air', NULL),
(184, 'Midwest Express', NULL),
(185, 'MK Airlines', NULL),
(186, 'Mokulele Airlines', NULL),
(187, 'Mountain West', NULL),
(188, 'MyTravel Lite', NULL),
(189, 'Nationwide Airlines', NULL),
(190, 'Norfolk Air', NULL),
(191, 'North American Airlines', NULL),
(192, 'Northwest Airlines', NULL),
(193, 'Oasis Hong Kong', NULL),
(194, 'Olympic', NULL),
(195, 'OpenSkies', NULL),
(196, 'Other - Airline Not Listed', NULL),
(197, 'Pacific Airlines (Vietnam)', NULL),
(198, 'Pakistan International Airlines (PIA)', NULL),
(199, 'Palestinian Airlines', NULL),
(200, 'Pen Air (Peninsula Airways)', NULL),
(201, 'Philippine Airlines', NULL),
(202, 'Phuket Air', NULL),
(203, 'Porter Airlines', NULL),
(204, 'Portug_lia', NULL),
(205, 'Primaris Airlines', NULL),
(206, 'Provincial Airlines', NULL),
(207, 'Qantas', NULL),
(208, 'Qatar Airways', NULL),
(209, 'Royal Air Cambodge', NULL),
(210, 'Royal Air Maroc', NULL),
(211, 'Royal Brunei', NULL),
(212, 'Royal Jordanian', NULL),
(213, 'Royal Wings', NULL),
(214, 'Ryan International', NULL),
(215, 'Ryanair', NULL),
(216, 'SAS', NULL),
(217, 'Saudi Arabian Airlines', NULL),
(218, 'Scandinavian Airlines System (SAS)', NULL),
(219, 'ScotAirways', NULL),
(220, 'Shoreline Aviation', NULL),
(221, 'Shuttle America', NULL),
(222, 'Signature Flight Support', NULL),
(223, 'Singapore Airlines', NULL),
(224, 'Sky Europe', NULL),
(225, 'Skynet Asia Airlines', NULL),
(226, 'Skyservice', NULL),
(227, 'SkyValue', NULL),
(228, 'Skywest Airlines', NULL),
(229, 'SN Brussels Airlines', NULL),
(230, 'Solomon Airlines', NULL),
(231, 'South African Airways', NULL),
(232, 'Southeast Airlines', NULL),
(233, 'Southwest Airlines', NULL),
(234, 'Spanair', NULL),
(235, 'Spirit Airlines', NULL),
(236, 'Sri Lankan', NULL),
(237, 'Star Alliance', NULL),
(238, 'Sudan Airways', NULL),
(239, 'Sun Country', NULL),
(240, 'Sunwing', NULL),
(241, 'Swiss', NULL),
(242, 'Swiss Skies', NULL),
(243, 'Syrian Arab Airlines', NULL),
(244, 'TACA', NULL),
(245, 'TAM', NULL),
(246, 'Tango', NULL),
(247, 'TAP Portugal', NULL),
(248, 'Tatarstan Airlines', NULL),
(249, 'Thai Airways International', NULL),
(250, 'Thomsonfly', NULL),
(251, 'Transaero Airlines', NULL),
(252, 'Transwede', NULL),
(253, 'Travelair', NULL),
(254, 'Turkish Airlines', NULL),
(255, 'United Airlines', NULL),
(256, 'United Express', NULL),
(257, 'US Airways', NULL),
(258, 'US Airways Express', NULL),
(259, 'US Airways Shuttle', NULL),
(260, 'US Helicopter', NULL),
(261, 'USA 3000 Airlines', NULL),
(262, 'USAir', NULL),
(263, 'USAir Express', NULL),
(264, 'Uzbekistan', NULL),
(265, 'Vanair', NULL),
(266, 'Virgin America', NULL),
(267, 'Virgin Atlantic', NULL),
(268, 'Virgin Blue', NULL),
(269, 'Virgin Express', NULL),
(270, 'VivaAerobus', NULL),
(271, 'Vueling', NULL),
(272, 'West Coast Air', NULL),
(273, 'WestJet', NULL),
(274, 'Wizz Air', NULL),
(275, 'World Airways', NULL),
(276, 'XL Airways', NULL),
(277, 'Yemenia', NULL),
(278, 'Zambezi Airlines', NULL),
(279, 'Zip', NULL),
(280, 'Zoom Airlines', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `form_banners`
--
CREATE TABLE IF NOT EXISTS `form_banners` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`file_id` varchar(100) NOT NULL,
`link` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `form_banners`
--
INSERT INTO `form_banners` (`id`, `title`, `file_id`, `link`) VALUES
(1, 'test', 'ece1aecfb0fd0f9991051f8296c30ca3', 'http://couriercls.com'),
(2, 'Test 2', 'ff0264400cb0f475592de93e3d84141a', 'http://sandbox.couriercls.com/admin');
-- --------------------------------------------------------
--
-- Table structure for table `form_cars`
--
CREATE TABLE IF NOT EXISTS `form_cars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`car_type` varchar(255) DEFAULT NULL,
`car_capacity` int(11) DEFAULT NULL,
`car_luggage` int(11) DEFAULT NULL,
`pic` varchar(100) DEFAULT NULL,
`brief` text,
`display_order` int(11) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `form_cars`
--
INSERT INTO `form_cars` (`id`, `car_type`, `car_capacity`, `car_luggage`, `pic`, `brief`, `display_order`) VALUES
(1, 'Luxury Sedan', 3, 3, '4783ef7a7cfaf2958303a1fda201b18a', '<p>Audi A8, Mercedes S550</p>', 0),
(2, 'Luxury SUV', 6, 6, 'e92807be16d0a7dbfe1d38c23dc8b8f5', '<p>Cadillac Escalade ESV</p>', 0),
(3, 'Luxury Van', 10, 10, 'ace16028658f9a80bea73b3833190284', '<p>Mercedes Sprinter</p>', 0);
-- --------------------------------------------------------
--
-- Table structure for table `form_car_fees`
--
CREATE TABLE IF NOT EXISTS `form_car_fees` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`trip` int(11) DEFAULT NULL,
`car` int(11) DEFAULT NULL,
`fee` float DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `trip` (`trip`,`car`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `form_car_fees`
--
INSERT INTO `form_car_fees` (`id`, `trip`, `car`, `fee`) VALUES
(1, 2, 1, 50),
(2, 2, 2, 90),
(3, 2, 3, 115),
(4, 3, 1, 71),
(5, 3, 2, 110),
(6, 3, 3, 100),
(7, 4, 1, 103.01),
(8, 4, 2, 138.6),
(9, 4, 3, 155.04),
(13, 1, 1, 69),
(14, 1, 2, 105),
(15, 1, 3, 105);
-- --------------------------------------------------------
--
-- Table structure for table `form_coupons`
--
CREATE TABLE IF NOT EXISTS `form_coupons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`coupon` varchar(50) NOT NULL,
`type` enum('percent','fixed') NOT NULL,
`amount` float NOT NULL,
`start_at` date NOT NULL,
`end_at` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `form_coupons`
--
INSERT INTO `form_coupons` (`id`, `coupon`, `type`, `amount`, `start_at`, `end_at`) VALUES
(1, 'test', 'percent', 10, '2012-09-14', '2012-10-31');
-- --------------------------------------------------------
--
-- Table structure for table `form_emailtemplates`
--
CREATE TABLE IF NOT EXISTS `form_emailtemplates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`template` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `form_emailtemplates`
--
INSERT INTO `form_emailtemplates` (`id`, `name`, `subject`, `template`) VALUES
(2, 'reservation-confirmation', 'CourierCLS - Conf #{reservation_number} For {first_name} {last_name}', '<table style=\\"border-collapse: collapse; width: 100%;\\" border=\\"0\\" cellspacing=\\"0\\" cellpadding=\\"3\\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\\"2\\" width=\\"56%\\" height=\\"25\\">{logo}</td>\r\n<td width=\\"44%\\" height=\\"25\\" align=\\"right\\"><span style=\\"font-size: medium;\\"><strong>Confirmation</strong></span></td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\" height=\\"10\\"> </td>\r\n</tr>\r\n<tr>\r\n<td style=\\"border-bottom: 2px solid #3087b1;\\" colspan=\\"2\\" width=\\"56%\\" height=\\"25\\" bgcolor=\\"#E5F2F8\\"><span style=\\"font-size: medium;\\">Reservation Confirmation #{reservation_number}</span></td>\r\n<td style=\\"border-bottom: 2px solid #3087b1;\\" width=\\"44%\\" height=\\"25\\" align=\\"right\\" bgcolor=\\"#E5F2F8\\">Last Modified On: {reservation_date}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\" height=\\"10\\"> </td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">Thank You for traveling with CourierCLS. Below please find your confirmation. If any of the information appears to be incorrect, please contact our office immediately to correct it.</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Pick-up Date:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{pickup_date}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Pick-up Time:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{pickup_time}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Trip Route:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{direction}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Passenger:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{first_name} {last_name}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Phone Number:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{contact_phone}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>No. of Pass:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{number_passengers}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Luggage:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{number_luggage}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Vehicle Type:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{vehicle}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Primary/Billing Contact:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{first_name} {last_name}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Payment Method:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">Credit Card</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Trip Routing Information:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{direction}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Flight Information:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{flight_info}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\" align=\\"left\\" valign=\\"top\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Notes/Comments:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{notes}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\\"top\\"><strong>Charges & Fees</strong></td>\r\n<td width=\\"40%\\" align=\\"left\\">\r\n<div style=\\"padding: 7px 0;\\">\r\n<table style=\\"border-collapse: collapse; width: 100%;\\" border=\\"0\\" cellspacing=\\"0\\">\r\n<tbody>\r\n<tr>\r\n<td width=\\"76%\\">Base Fare</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${base_fare}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Gratuiy</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${grat}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Tolls</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${tolls}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Processing fee</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${pro_fee}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">NY sales tax</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${nys_tax}</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\\"width: 100%;\\" cellspacing=\\"0\\">\r\n<tbody>\r\n<tr>\r\n<td width=\\"74%\\"><strong>Reservation Total:</strong></td>\r\n<td style=\\"text-align: right;\\" colspan=\\"2\\" width=\\"26%\\">${transaction_amount}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"74%\\"><strong><span style=\\"color: green;\\">Payments/Deposits:</span></strong></td>\r\n<td style=\\"text-align: right;\\" colspan=\\"2\\" width=\\"26%\\"><span style=\\"color: green;\\">${transaction_amount}</span></td>\r\n</tr>\r\n<tr>\r\n<td width=\\"74%\\"><strong><span style=\\"color: green;\\">Authorizations:</span></strong></td>\r\n<td style=\\"text-align: right;\\" colspan=\\"2\\" width=\\"26%\\"><span style=\\"color: green;\\">$0.00</span></td>\r\n</tr>\r\n<tr>\r\n<td width=\\"74%\\"><strong><span style=\\"color: red;\\">Total Due:</span></strong></td>\r\n<td style=\\"text-align: right;\\" colspan=\\"2\\" width=\\"26%\\"><span style=\\"color: red;\\">$0.00</span></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Terms & Conditions/<br />Reservation Agreement:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\"><a href=\\"#\\">Terms & Conditions</a></td>\r\n</tr>\r\n</tbody>\r\n</table>'),
(3, 'agent-notification', 'New Reservation - Conf #{reservation_number}.', '<table style=\\"border-collapse: collapse; width: 100%;\\" border=\\"0\\" cellspacing=\\"0\\" cellpadding=\\"3\\">\r\n<tbody>\r\n<tr>\r\n<td style=\\"border-bottom: 2px solid #3087b1;\\" colspan=\\"2\\" width=\\"56%\\" height=\\"25\\" bgcolor=\\"#E5F2F8\\"><span style=\\"font-size: medium;\\">Reservation Confirmation #{reservation_number}</span></td>\r\n<td style=\\"border-bottom: 2px solid #3087b1;\\" width=\\"44%\\" height=\\"25\\" align=\\"right\\" bgcolor=\\"#E5F2F8\\">Last Modified On: {reservation_date}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Pick-up Date:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{pickup_date}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Pick-up Time:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{pickup_time}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Trip Route:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{direction}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Passenger:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{first_name} {last_name}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Phone Number:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{contact_phone}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>No. of Pass:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{number_passengers}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Luggage:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{number_luggage}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Vehicle Type:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{vehicle}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Primary/Billing Contact:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{first_name} {last_name}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Payment Method:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">Credit Card</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Trip Routing Information:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{direction}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Flight Information:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{flight_info}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\" align=\\"left\\" valign=\\"top\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Notes/Comments:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{notes}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\\"top\\"><strong>Charges & Fees</strong></td>\r\n<td width=\\"40%\\" align=\\"left\\">\r\n<div style=\\"padding: 7px 0;\\">\r\n<table style=\\"border-collapse: collapse; width: 100%;\\" border=\\"0\\" cellspacing=\\"0\\">\r\n<tbody>\r\n<tr>\r\n<td width=\\"76%\\">Base Fare</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${base_fare}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Gratuiy</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${grat}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Tolls</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${tolls}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Processing fee</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${pro_fee}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">NY sales tax</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${nys_tax}</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\\"width: 100%;\\" cellspacing=\\"0\\">\r\n<tbody>\r\n<tr>\r\n<td width=\\"74%\\"><strong>Reservation Total:</strong></td>\r\n<td style=\\"text-align: right;\\" colspan=\\"2\\" width=\\"26%\\">${transaction_amount}</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>'),
(4, 'reservation-modified', 'MODIFIED - Reservation #{reservation_number}', '<table style=\\"border-collapse: collapse; width: 100%;\\" border=\\"0\\" cellspacing=\\"0\\" cellpadding=\\"3\\">\r\n<tbody>\r\n<tr>\r\n<td style=\\"border-bottom: 2px solid #3087b1;\\" colspan=\\"2\\" width=\\"56%\\" height=\\"25\\" bgcolor=\\"#E5F2F8\\"><span style=\\"font-size: medium;\\">MODIFIED - Reservation #{reservation_number}</span></td>\r\n<td style=\\"border-bottom: 2px solid #3087b1;\\" width=\\"44%\\" height=\\"25\\" align=\\"right\\" bgcolor=\\"#E5F2F8\\">Last Modified On: {reservation_date}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Pick-up Date:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{pickup_date}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Pick-up Time:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{pickup_time}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Trip Route:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{direction}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Passenger:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{first_name} {last_name}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Phone Number:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{contact_phone}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>No. of Pass:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{number_passengers}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Luggage:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{number_luggage}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Vehicle Type:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{vehicle}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Primary/Billing Contact:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{first_name} {last_name}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\"><strong>Payment Method:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">Credit Card</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Trip Routing Information:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{direction}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Flight Information:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{flight_info}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\" align=\\"left\\" valign=\\"top\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"26%\\" align=\\"left\\" valign=\\"top\\"><strong>Notes/Comments:</strong></td>\r\n<td colspan=\\"2\\" width=\\"74%\\">{notes}</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\\"3\\" width=\\"100%\\">\r\n<hr size=\\"1\\" />\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\\"top\\"><strong>Charges & Fees</strong></td>\r\n<td width=\\"40%\\" align=\\"left\\">\r\n<div style=\\"padding: 7px 0;\\">\r\n<table style=\\"border-collapse: collapse; width: 100%;\\" border=\\"0\\" cellspacing=\\"0\\">\r\n<tbody>\r\n<tr>\r\n<td width=\\"76%\\">Base Fare</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${base_fare}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Gratuiy</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${grat}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Tolls</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${tolls}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">Processing fee</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${pro_fee}</td>\r\n</tr>\r\n<tr>\r\n<td width=\\"76%\\">NY sales tax</td>\r\n<td style=\\"text-align: right;\\" width=\\"24%\\">${nys_tax}</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<table style=\\"width: 100%;\\" cellspacing=\\"0\\">\r\n<tbody>\r\n<tr>\r\n<td width=\\"74%\\"><strong>Reservation Total:</strong></td>\r\n<td style=\\"text-align: right;\\" colspan=\\"2\\" width=\\"26%\\">${transaction_amount}</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>'),
(5, 'feedback', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `form_locations`
--
CREATE TABLE IF NOT EXISTS `form_locations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`location` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `form_locations`
--
INSERT INTO `form_locations` (`id`, `location`) VALUES
(1, 'Newark Airport'),
(2, 'LaGuardia Airport'),
(3, 'JFK Airport');
-- --------------------------------------------------------
--
-- Table structure for table `form_optional_services`
--
CREATE TABLE IF NOT EXISTS `form_optional_services` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`direction` enum('from','to','both') NOT NULL,
`change` enum('+','-') NOT NULL,
`amount` float NOT NULL,
`notes` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `form_optional_services`
--
INSERT INTO `form_optional_services` (`id`, `name`, `direction`, `change`, `amount`, `notes`) VALUES
(1, 'Inside Pickup', 'from', '+', 30, 'Our chauffeur will meet you in the terminal.'),
(2, 'Add car seat', 'both', '+', 30, 'We will provide a car seat for your child.'),
(3, 'Concierge pickup', 'from', '+', 95, 'Our welcome agent will escort you to your car at the airport');
-- --------------------------------------------------------
--
-- Table structure for table `form_postcodes`
--
CREATE TABLE IF NOT EXISTS `form_postcodes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `form_postcodes`
--
INSERT INTO `form_postcodes` (`id`, `code`) VALUES
(1, '10011'),
(2, '10010'),
(3, '10001'),
(4, '10016'),
(5, '10018'),
(6, '10017'),
(7, '10036'),
(8, '10019'),
(9, '10022'),
(10, '10023'),
(11, '10021'),
(12, '10024'),
(13, '10028'),
(14, '10025'),
(15, '10128'),
(16, '10029'),
(17, '10026');
-- --------------------------------------------------------
--
-- Table structure for table `form_reservation`
--
CREATE TABLE IF NOT EXISTS `form_reservation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`number` int(11) NOT NULL,
`amount` float NOT NULL,
`direction` enum('to','from') NOT NULL,
`location_id` int(11) NOT NULL,
`to_address_street` varchar(255) NOT NULL,
`to_address_city` varchar(255) NOT NULL,
`to_address_state` char(2) NOT NULL,
`to_address_zipcode` varchar(15) NOT NULL,
`flight_date` date NOT NULL,
`flight_time` varchar(15) NOT NULL,
`adults` smallint(6) NOT NULL,
`children` smallint(6) NOT NULL,
`vehicle_id` int(11) NOT NULL,
`bags` smallint(6) NOT NULL,
`instructions` text,
`car_seat` tinyint(1) DEFAULT NULL,
`airline` varchar(75) DEFAULT NULL,
`flight_no` varchar(25) DEFAULT NULL,
`services` text,
`driver_inside` tinyint(1) DEFAULT NULL,
`user_id` int(11) NOT NULL,
`transaction_id` varchar(19) DEFAULT NULL,
`coupon_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`priv` text,
`status` enum('pending','assigned','completed') NOT NULL DEFAULT 'pending',
`feedback_date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `form_reservation`
--
INSERT INTO `form_reservation` (`id`, `number`, `amount`, `direction`, `location_id`, `to_address_street`, `to_address_city`, `to_address_state`, `to_address_zipcode`, `flight_date`, `flight_time`, `adults`, `children`, `vehicle_id`, `bags`, `instructions`, `car_seat`, `airline`, `flight_no`, `services`, `driver_inside`, `user_id`, `transaction_id`, `coupon_id`, `created_at`, `updated_at`, `priv`, `status`, `feedback_date`) VALUES
(1, 1, 99.55, 'from', 3, '69-54 74th Street', 'Middle Village', '', '11379', '2012-10-06', '6:00am', 1, 0, 1, 1, 'Please wait outside with my name.', NULL, 'Virgin America', '30', 'a:0:{}', NULL, 2, '1M388407JM499992P', NULL, '2012-10-05 14:17:31', '2012-10-05 14:17:31', NULL, 'pending', NULL),
(2, 2, 73.98, 'from', 2, '123', '123', '', '12345', '2012-10-12', '2:00am', 1, 0, 1, 1, '', NULL, 'America West', '1234', 'a:0:{}', NULL, 2, '3V343878TU2958635', NULL, '2012-10-09 09:27:55', '2012-10-09 09:27:55', NULL, 'pending', NULL),
(3, 4000, 103.98, 'from', 2, 'st', 'test', '1', '10016', '2012-10-20', '1:30am', 1, 0, 1, 2, NULL, NULL, NULL, NULL, 'a:2:{i:0;s:1:"1";i:1;s:1:"2";}', NULL, 1, '1LK53358JV307890R', NULL, '2012-10-09 11:17:30', '2012-11-16 08:14:55', NULL, 'assigned', NULL),
(4, 0, 73.98, 'from', 2, 'dasd', 'test', '2', '10001', '2012-10-26', '1:30am', 3, 0, 1, 2, '', NULL, 'Adam Air Indonesia', '233', NULL, NULL, 0, '25X437490R526952S', NULL, '2012-10-20 12:24:39', '2012-10-20 12:24:39', NULL, 'pending', NULL),
(5, 0, 73.98, 'from', 2, 'dasd', 'test', '2', '10001', '2012-10-26', '1:30am', 3, 0, 1, 2, '', NULL, 'Adam Air Indonesia', '233', NULL, NULL, 0, '1SA98867DL158445J', NULL, '2012-10-20 12:26:18', '2012-10-20 12:26:18', NULL, 'pending', NULL),
(6, 4001, 73.98, 'from', 2, 'dasd', 'test', '2', '10001', '2012-10-26', '1:30am', 3, 0, 1, 2, NULL, NULL, 'Adam Air Indonesia', '233', 'a:2:{i:0;s:1:"1";i:1;s:1:"2";}', NULL, 1, '21283218U3205661R', NULL, '2012-10-20 12:35:29', '2012-10-20 12:37:54', '68d91cddba1d714b', 'pending', NULL),
(7, 4002, 73.98, 'from', 2, 'dasd', 'test', '2', '10001', '2012-10-27', '1:30am', 2, 0, 1, 1, NULL, NULL, NULL, NULL, 'a:2:{i:0;s:1:"1";i:1;s:1:"2";}', NULL, 1, '10Y45019UT318544V', NULL, '2012-10-20 13:10:10', '2012-10-20 13:12:01', 'ac80cf5fde86c5b279dfe2f8b39c278c40b39dcccffb499af9085bfb528b1afca0a40dd5fb0006e904eb5d6aa5ffdc27c898dab63c60dfc9bb1457424475a068e2d2049f51ff94d956f5a8dc0d0c6e79a07436d8520570e3f09089ec35c9eeb278bea3aa9b9bfc12841f1708834e72b47e29368dbbf7b00435fc98c56c17c69737325f7bdd7f6cb785fa4533014248a5e8d4aa62fdff890f44eb1c1c64f7565f973591db20db05e49fbff2e01b08e1935da449d455f138ae559bbd75958bd2938aa67812be9487368a1261f73857f0a66e7e6e0ca1169461ad71200a71acb61065d4b170dedbc6eacc090ca3791b64ee5dd890f29361184f5842bee3645fd148aeafaa24fab34c1a7672a2f0172ab3b930419642aeccd67600a3761b03e32ecc5534e13e893634c91c7635fca81d4f6231ff1e886808373fb764ef3f21e6a2babefab906cdfe596afb9d239eace3ba400dea5dda6c94add743536ff52d3495165f16a30aaa8c1b82d7b573d3345cb1847fd897907beaa4b5052c065731356be7e2fd9f35ababef23d7e471a4efcc912336f77e02d355eb2429c50a0c1b35c5443ac30e43e7b14a16e416cb7d79f6928af2c13ab65a73e1358335e5f8b648253709e2691730ed9bd612b3ca956162abc11af14e2b437cb6352108b844e99a6028a166eb81ae98a38a9de92ddb946b2e4115af1ed62e96bd85c2a0bbe5d39cf02beb9edc6bb5e82cd70dc78c900480e68563fc3deed60b21e7fc175db146f553655b46eb66e605d86118d178b5b1676d587e20b16042cb1513ca3f2c99a70a273e16d37cdbbdc4d60677350948c330f369eafae5e67c5b4d90f9ec39b123ab96c8ac075ebc4cd94f1d5af9610fd945035d8f3728dc286b2fdbc7fddc95915e64d2a5b920a6b083a1d95a830bb5bf21b22836c776a26a48f470164a4c0db5dc6f1b376b2cacc93fff150acafb4be50af3005058a757ae1a5fa9d826673ef7b26837d6f609bcfba160fe13675d2eafac875a86fbd4c669af5f041a963216e1361a8100209b968222874a0f93000ec383b733156c9a62dbcb701b2a9090f48dc2b2aabe3478656626246830a743ca900de4db7c3f0bd934b390542a855eb3e23be4b30fcb984ba34da594de3935a0cfb08248767668ad2ed6d5266a821ef0d8b67faddf52cd1587eff8efca910cb21d689c97c67cff3f7bc8d8d15de43a01516588e2c0b9d1a1858628d0114a5a99c49ec145f44d5a7a236bdd8c9e8b0c23d111b78923b47af3dc463397701db3dd3db7a39dc0f3f43f871ccf6505686145150a4c1c03742ff6d740c1f741f235d27718a50e86adbcea8a38047f3eb13bcf3ce097d995d44eafcefd987dcbbd37a62c707c8af3e30d368864676f9427ec68540ce070f0e7a229d96ab3b1a30c956d028e66188240ec89fe23ce15cadcaaa3734f730e2ff71a3b99abdf61553b46c8ce7fbad9cb2c7639f4358f432c362e2d4dd4ab9b336e6cb61821cc46c3d85b3d0d6b12c7b582ac3c72c6f041e674ec9ff6d27fb267576c6b5ae6de4391efaf75bffcd3aae6df69c631bc7605d3c86db6ede12c78e2823a10088fdefde393f9ff55ed81c6f20be858aba7e5239d9a5e1735f1b48b90a091b4ba62c3e419a5b5bbfe43694339071232eceb89eb5280f1eb27ef5921b496a25340bd1284efc0434f767b2132c1a7841c1682b71f6cd191cb2f01163c57a1aaa7697445393257baae5318399f', 'pending', NULL),
(8, 4003, 99.55, 'from', 3, 'd', 'a', '2', '10018', '2012-10-24', '2:00am', 3, 0, 1, 1, '', NULL, '', '', 'a:0:{}', NULL, 1, '81094537RB063760U', 0, '2012-10-20 13:23:46', '2012-10-20 13:23:46', '807018bcdc9e4121d91383e96c145b1bd4b4bf1d0960d40c86c3d50c533f0a51abbd05b68e9769d15948adbc090bab8f29d55f6e97b2000b4e722605051d4e2544f6a77e7d7b2c63d9ffad9c61af5f94e40c3cbc6ec958f0a05c2cfbf041a500207b5cdfb48a19c3103be236e0a2203feafc3baf869eea0271e5dbb674756adc76673e1f0f899d0816cbda335400f4d7e1cf6c1db7c55abea9394c7850928414b3f8226a0e73b0f1aaafbba1d0f3e21781871f8eacb90e18f9a02ca80ed24d01fecde31562e557663f3c3314746c58579aa58ddfb85e63186fcb96be313d9de48e27b29332c12d7a6f4865f178f4f807709405c4d0d94af9af10d1c4dcdc8a2519ee7a2b382ec56212c3bb7993b957717f20b918ef0095561f94cf7139166001a1971ec63e201466ed326ed855e64346900fc36c11a8eb24b42cd23237c3de5851e0e07d42cb8e7e26b79d9541595167f274dd6d9753689497353cbe7e83921782ba9126a530e2113404d2ca9241250f8a3c09b55f337e305b4b9c603ba74a6c6dbdeb4b0133cc97ed2e42df7eb1fc4bf772b235bb956c6fa668b7181a88428466b2b224e646272b45fee5f9579c8ca3b9cf5cd37e6254c5a67c1822c5142556ce458f8a93ff5d6bb323dbe6439873bdb45152bb25bca8b1ab60774a8c3112bbd81396c0a7e1da750da0cff19528fcd36d6dadcc60791fb3523357a77bb478cf419a9c3a7389f1ef208397d712c9e4180c88e1ce329e620a68f58d4898b9a64a74aea1d3f48363897852806b3f89fb9710bc37e4b3f7fec54dea76a3247ea214f780fb5ed3a6a66700660571b629d10f16c94e268695d56bd1df69d02b40faad17d83815749e952188413afd880a0dc4b74374eed454e68df34a83339b883823a02de50e2a6bdbbd712ca1f4351a3742375cd48f5ea7b37751b9909d83ca07358bbb3d5fd0752b5215e3460c46aa67f2605a726d49644196788dba005ffb2f58fc50005081bb856063c66c8135928be92d55651fc277962810d7b68ba79edb1e1c6c375a753562b08897b72bdecc829f5a1235f55f7eca00e795b33b6c3ff2f45029fbf544f5d6aaa8c8e451492e673d3690822c5e05094f495854196e7e96c1d2e176d912c3b3b28be31b4215677d81299ce44d25966a69f8637c5a53c6f93d063ca59339a68d93ee0251ea90b7040fbfa48ff1f8a3fdc58bf6b865627459087567ad355c6fc1bd7d9301e421876487b6abb802221503fac43cfd4de25191939ef1f7ee781598f71c68a62c55125b195d93116be8d5843f70fae5f51dd735c4650d29d847368c671d1724e50b94cd144f67475a7b29fd6c8006f1a91eca10196ec85038861f1b9c4911ae5f736f39d7eeab91d0208f826655b0ff1a1462f2762adee9cfb98d89512b126bb35f3ffb38c434c0d9809f3cb85482d5b66e16faa874bc6fbba30dc9833dc08e1b93b0e7ce4a2b3df8d8f5078173c30782543db71e58c059daddf6eb64cd90acb8d92d1bfcd6ecfea9663d40374e520d91847e615b61a9a30bbf73c7fdc62c94a35efb8ab5413776ecde3ccb84646be390b1e7df99f656c6e527a58fc660a3624be5d90c561386a5b7d55a1f529bfa8faa4852769f7bbdeb5d0f0954952c3e7148e251b710045f94e7a0a9ea791549634df0533dfafe8b0127421c7abcdee8228f839c9b1cdfd6599eac757878694b74cab400bae66ffc9e3700f4a4c9', 'pending', NULL),
(9, 4004, 254.55, 'from', 3, 'd', 'a', '2', '10018', '2012-10-24', '2:00am', 3, 0, 1, 1, 'Add modification email.', NULL, 'American Airlines', '1234', 'a:3:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";}', NULL, 1, '2W296648RU553012X', NULL, '2012-10-20 13:25:49', '2012-10-20 15:41:55', '125f37a0f97515479ecb11d500d713163227b3c9e0de6d266761b95f32165724970e4a4bb952265689826726674a0cff31317a2e3be7f351f9fbe35de4933b1472a6c33250407ac8b60ac2a22bbd3eed370e5569ad3bcf26e18f468f92d72e86cb3a8c137f90648200f6df055058946cd71b908d4631904022d74ccd894343aff41de778ea02532187bf0cd2532f6f6f548460512016b2912d7df4700a8a8f2563166c754769f9fc71d15a2d2b73943c660f4cad445e0e6f7d61eda4b6b162abfda892a15f5fbd59ca322c98110f776931486d37eae3520117062bd7a7078e8d9c119ffe3f82c74963d5a967ae369d35981272e85d33234d0969b59842e9ef520c41157bb5899a6de5298dfff96f9f5a5b15361d1edb66320865c3bb66c5d8a1d368a97f14c83c7553c4316659f69e3fef4544346d368524559a495dc6a1782f236e3c6ba26135d5de8b5f94a3473d6eea2d809b197d5608fe36b1cf24c2b2afbced6e460febc94c5c4088ba009f6f641d5433c82b22a56eded56ccc692c6daf0a0ea1b3a05b0a71f8ce74a9b8e0cbb639330f1c611723c351ddc49444f3d5e409661b6a1372fb59d3a5dd0d64fe9d447be7fad7dd804059d683c2afe90c5f4a390bb3bfe5737a53c4416a1b70d6e7a0f0f622af7dbb221acc5658aec51ec45f712857c3663e4add1f86267876c4557a88975a71cd2509933b542dee5325c5ba62a71e8eb2dacb3614cfcd03cde0094472358b153c799028e19d269c5b9a74a84cddc088026ff978419ad065446a928f5db8c852a5c4044ede8555e5b9648040226d99dfc62b0ce17f018825e6c22f3dea901efaaf1627687cee86d9e964dc91265796d650d45bc56009e73452a53fc3168010e7c269381d542633532967fefa221acd843e234083f559b12de442290e8bf58bd5eda3efb6c66079852d73f738d5e34c1231377d763868b8a6d910d5b0f00e946b5090896a1f7a08f63a4200d51490d868eecb5e48b2a7b7896b7dcd8c63df23fea4cc8ab5a8f5115c7a4d9828e51028560203b181d315e7fc44a6768d945fc8038fc66326a321306dd37141c16a95e95ac66ba2ac54d8e1c53d1c2a9a47babd0e056affb8ad3db4b3b220268437721466022b6ce3beb9e3abec0e49fa165eb7fcc2b64af4b3606d4c1a97ae9c268daee3e4dd76b2234c9054e728b49c8b14fbb7405653c348ea1de8fe17bb6f6e3eb0c0948ac18ca41050b41cda45ce7a90acc9b10708a46fd99563febe9d6497875a334004292f47fc231b3a4097cd00c3b5fe48fa6a213ee3dfc6ecb8e87ab569fa6d8b8a28d418ef9140202d955c235a15d3a31e6f80fcbde7ac0ba3f61dde0b3b7a6563fe7837cefbc05242c25087f37f4602c812d9c0706575a626a5058e54367262f8a9da78ebf75e3458fc9213ee78b74b866cfcb0b6574c44c8f2700e988c4b32b6d20401fa949f188dab3eb2ef4390efbf7cd7f25ac9d2d935f615f0166156d1db16c0bcae22c714f77398cc9300040d749848d28c03d365b5fcd7736f0f9412f60bff3d70b4a192e4374ea06ed80a87b34e28d7471691752c0ad4727be6132e616762f4a31f264b4fd299ec83158fb9e270f9bb7df75085cc54966d656b0908f0a07a9cb403c97c6cdf94b904637b1babceffd2f0103f4d70ac84e7aeab53e9a115c2c96b36428a6dd49d0a319a698844183250e8f6e1c345ec3e6f65922d605b774a7ab557760f7e71c29237334cfad8e66789d0beff7e463e3b8a423404edfd390df7b86018b17d6276280f27edd455cea993316d871c0ab74f61ddad733522bc019cb215ca40f120aada8185e5781dca53bfb9ef245404ab7754f0e1191f38e7412087a21fbf22aeb18a9374352c82d043f1736a899cf2832b42074fc3c6a79c0cc6c2209b8a44102677b485e1da7dc360f8c45da39b83909543a360b6791cc5b5d179a132550fe25f6bcd40eb12870ab9c6a13fc7853b7429231df519ae811bea34b201798a3a6c2bb27076c3ad5b58030b1032fcefbc6701ae58be74a14240596d02eac955579cc6430118866e5ee7f7a3fbfe1668c8e4b233a37750117896a19ef19625491a7c167348e2af8e40deb0a39a06af85da88cdc961c857ed5c9011acff1b609381b3654952544502bdd1717fae03259b1acb225d29315ea1de561aebf4cfcb913ff8f1ef1b6bf4c703a23d0de91c3afbc06a111569c5868995a45cb81175ee383c2869027cdb6a5221ba410ab545116a18a4c768af6098104d7991d828840eb6ca0a1ded025181391baa9aa51b78f3184848da0592c2a35fa167ea60193f0b8eca523b948a20820a40f06817e57b45fa6ed18671be668e732ccbb0ff704d1308e812863ad95e7e297ef74b1841fc8ecfbc0baf51fca65ced47c6eab20044a558044680b02d0e20dd32924de41b4d6594b07d1f8bc7cd8eec7ba6ab52e04d8379235fb3f9e2ae35cc7e8edc22abfa15898940ebb51c5ebe73cfb635d91758b6c0731e08031251459c5670675f5a50fe3159e67b6f8e2e351a3b8ffbc1d1b6321efd25f51f4de57d92a166bcd4f5a49842bc81f7f3de68eb81620fe1aa7ed144a323d60c8a845916d6d8b1446e1e7691666bd9c9acb154863327faebdc2dd06833d5b5cd400b083f37380791b5fa4eabf32c2fa462c6ce61ec010e18587ab35c7b006a6a9393f137214ad653eeab45a33ea09c93d25a53e3b32f35ee20be5f4f68ec4a7e99ee2d70d9fdf9e7f6ca6de6a84ecda38b4447c29cbfd08cb5abd8c2792211b57637c95365813b9c0669f32da14cf696bdee3fff060b876cd9189ab08d544acefbd11790b75fd6df2b8b6ea5224158448863579126946e89103f5e44ac2dfef1f6f60d774f837d66a55e821e29fcde9bb48dcbd87d8b8dc12d8f989649ad31b809903c40e5cda083c6682fa396717229cc881a32d054bf171832458dd3dd7f235fb15530367ef1dd6c711454d365acca524b96d43b4cb15635e6a6ce08a1f24778caa001aa9d664c73a68b2edcee7e7b3063cf5b8496a4ed35bcabb6d543aef4384769f54c7d114305f4bfa0059af54fb6a73f9008a55fb52034cd9d2458b33fb1af23cde0744d9296b87f3f2ed6bc6c014d9d282700ec41aa43ddb13adb0e1e33e9337fbe4baa59e70391ae4a3691d93243a2d00ddfa9021742939ac00b97dc93aec41302af6797e1aa7efc657564baec9ad510b3db029978bd65137026470ee98e3870ef0bafefd69f8076102a11ae13b1cd7576297fad0fd1249329b090652f3c38c227ef5b682589ebc7f9336f38b1218abfd7c3a47c7566462f24902b02c3d1d248f329f550db5ad54cc6cb28db6d3fe7e659da76ad8f55829d3994782286a6c2f643833e99da8c24d711f48c7d068a78ecf6336c5519ccc1c967e6ab968566d35ba32bfa97920de4cec90fc5fe2d1e2444a4cbe7b11c53ff39b443293c17eefd730015363f7a82bb6a2f47d31bfad50cb7c5a9733761b3c8b7ae8b65830e1f75fe55228f02bb8931b6e6e4b211d3def4e16ee38320f3a3dacb8ecd8ec1f9ee092ca24aecf450a5e36412223d71020b1d3da0c96cdac7e9a97e076805ec700836fac287c7da3285a41c6559f83ae290465508c6e73d1b9bc8cf5c6eeea0dbc70c5a27155a730d80141aeddd5916c2aa2cd5488ac61d2b1105312b12c285eb73d44a9483254b9e967b4a3029f15a337f62956fab475963670e57e22265a628ca7578987b70731a8afe89db1571389e9ae676d24b645b6f09b36ae37e2ab74fd795c697f6b1c8d73d68c915b66e627fd85a38be8ee1d7a05d2970ab88aa77143e5b69ea164b83581d744a62da65ac2f96db467e21bc60eb56d6c6ac2d5b376eb576569bd2ef6c600f4b3f604983221c9db1951db6037cf9f8f46bedac94d6b3fb2ed9306a9ad04bf9f5c0886892ed14fe8a03f9b07277b31049b8610f25a3ff6aa75426b137cf9e0d8efacb566735b1efea9fdd0ab1997f7975c7034c97250cad47266705a0d7cfcf635f1b4947c7d5bf4a5cea85e2ca9344aa720668eba6746f3d3142ce350f2f3950b4cefb16068107d19a61800e9a1d8e062659ee30a470ac29f06710e16a4f3faca479f87f6622cc2f4f306802687eeb34c5976379b59881aa6882a17a1e9a2c99c711751efbeb969a96270e8fe8231bebaa6ecb9e961d33c854f866bf0c5b9283cfbf2c2c2b78d947207c3f645dfc592dfba6fdd5d2e24969bf7876edeb88fea4c1df9d88e09d965de7f54382dca27e2c52e43e662e45dffebeb1d25c3203a1c715ad46a7501cbfc2a6d9e6b55c40ea4e9779a59e67d164f1221d4039cc8975e2e416851e45d28fadcb55ecbae49543d00bf332660568e0ac09b856d9117ea6bba5ac58cff12d037e20e8be16019924735e9c3449e44b83b1364c7efbe623879461cc710ae2a4e5fe901272e9a32113b6e72e815035b9e485643174cafdd18b4cefacf7170c8fe0bfda4f7ff395d46fb46792efad75b17f46e7dbe4646a270e165f3f8694fc84554bd955d59fe3319b9761471f4cd1803c7dea7e968854fc32638ee27e6b5ce838528f4e4d7f3deccedf33e8468b464a5686781aff3a028a5b88c82ac232eee8476b235f53ac61da657ffad64955ea3bc87e6118f33e660b07624c49a24cd08af6b1304861ef1a205a3b0855f558fe5b9d433332e03f941f3b4cb37e293aa174e03b7b28e81299c0971e1f7201ae32604636a63a017c65fee914b86feff64d374089e532526d6245baf3175d630b1f44e2d1a0d0dff766f87760eb27f61b88bc341b8852063a5321b19fd4b4ef94c4e4eb071692fddbf414dace9f460e7694baf38bcb5e1bda3ad2a56b34a25968f30de795319b9d4ccbb1278e37e45dee18db1dbe716ac0f277c022f099db638ce0d9665becd45cc96e7ef7fcefcb03c274e99a238e231f01e1e6eeff845798048f99c3ad7ba9b32053b9b30d94b6545b13dce2df94462c481689d80e54f5e010ec5ebbc065e17e55b8739c0556394e523d3e3632807a1175545d3e8c8611467f4331589c5462a7c21f5364798165e140830df7ce6e50b21370211b6d54817e828c3d93622c2a858754a72e93e9028886542f01ff65ac17cdcf31afb45115303c047e8e6b81f3b85a9c54c53b2174cb591bb0d9bc3892739c11d33332eae02ddeafd128726d6bce227146ebeafd88f8a2c0b5e5e2b07350bc090502d16c4b36f54585d26ca1463a4d40dc83a0acd883ac2ec9c757f02755f1526d89c0b1201337a753e6a6dd74c98ef1fe1fcb7a2c8836e6adae88806a9ca4bc4370429eb807796d291e14d3ff7a5e64db04680c56dd98b79fac19e4e4fd4488d7dd0afd9fc28b25cec53f70afe41bc673b8ea7b1346209a4511a91870f65ae2b5b40f7efe50e782f285ca59d941b0aa0d1b4989712ebbd7be010f5aa898fdce04a2da7b22e84ab68d84d304f22a889fc10b0593f6cb5378331dfeb2c7f3beaa7be76c27bc5b30ed2877cff03000e6d40f5faa2148d19b38c1b51a3c4cb7e297fa0b8c26ea728dbad30e707b53afb0cabc6643dd21a0c0e9fe7355ffc95ed613fd8e2b7b3a11d60da98421c587854cc9bbe39996e9444b59bfca50727f9dd1e69deaf397831bcf1fb595676feb0b8dd4f3283df326bcc20b94f573a58a58b5a7cdca34e6a921dc9dabd982e5657ad9c3f38d135b94013210d77047d2a11362c106788ac2fa17b13af5e27b9215276d391d5b819dcec0be7de14436aaab94292e025001869bd00708c9855da5c9f61f5383e41e137fa7fdb988f11e59333fabcbaa83a65ddc9a1a2ab851790ea6164ce25e6b2aa402fbf1b9929e3be26da4bb592f6b7ffd60d2fcaef663c70dc02f3f54ae911991d1418d7b44d6417622c8a717b64c62f2c53a46515a1ec8f3048ddde16aeef09798cdbb8c1a98f732d8fef21366123b3b769e270a5843e01cf1ef47828850cd830b2e175a3a2408a0ab65b5fd0d5d77a3388acfa78d5550b3f62a9b7725e447b58f77f34897e68e49014a8335820d1a7c5ca78a1ae3249b7bce7d39b246ef96007be6da658e559c9d4a790a7d361273b461deb7f9372eabab50121624d24159d3cf4e771f61ce82399054afbf2f8d76464234fbf17d7bc7cbda1fd91e3f197fb2809bcad2290edcefd58eefc6c5ccfdf9d6594672087b5689508a55997d749533f3c63d07d1219bc4fa51a1b9e08674b2811c7cf63161cb37ec6631f82baab46a762fe7fcb7114db6d90194df5836edd59ebe3bb02eb97c202119520d3e62859766d1e3cd4d0b54669c4a241faab98210ad638c10fc3f83e7ec639b492e5e8b93ede9c59ccd6c5407251617f47c9c05349dc2ea41a38cdf96d1424c87d5cf05f1b0ec0fb4bb54cbb6d9095901cf7f0d776733f07981a71fb6c6b09ba4cbfd58208597f6afd636b898c9080f116d8106941e7e95c28d2eb0e662a0797d26315cf1bfdcaacc25f181596fdf6ed6056c010ae23503e27485b9064aa33b1a3c983057aed5b59f4275d981513732787fd804427e3de2978509558a22a3df1c73a8c03d8aa60dadb912ddfa6d849455939c51419616f8ab2b343a14ed9260650ef5476ffa6be0d221f0baf292bc7e8f2b2b1ccf599ce6fe8c71d0a22c1117cb07eb704bcb980e384e1b255cafda8192a192d942596be72cc562a12a1263d64a9186438658b248f31acaf1dea0024a9295dc565a0e4038ded488dd216ce73dab10cba7380cb7238acea08136843150a815abb9331162daae1456d2c5e829c6d37bbb0ea4f75e9e1b2dcfdfa524dc09b1d70c553f52773b74450084b540edc80e201bd36ceb95dacbd895204d1b5b0bc348d51dc7cabe5ac4a441edd6f02f13f6b93d51b2ea5d886f51dbb94532f0436828e18a7d227d0c1f39bbabfb736456c1e471e35f79ed34fabba5622212d7cde56bd587831f7d44785ec89541d1abc199a2f5bfea5551b33a6b2bb79f0954c6ef81560b7cc504b7c383ea63721dc3036f3a714d29fae908ccc2f00a105728ce245adce37727ac5036c40768cac5082e0865cd6a35bba7ee51aa91b3b873e54e30ba0aa48db4063117846b3250e0b266a2919f4470ace4c0e3eab4c9e305304f9c1cb9b4fbda1b4ecdbd3daffc1f146b7f833bd28f55b7a442692444c55bc54ec5889c06ff98653b48c438f76a04c67692ed1f7e0687bf93815c69660252af179ea891185dd49d0139cd5719fc650620f219908bf99226919240d62a6c9a15eda661f8ccb6172de8e9209ade88f88c8034f2f4a201fc14db2117fdaafb743029ced75ee148adc7ba29b090b47522e78880087647efea58605991a92ce685b6ad2357af47c5e594e6bc48ef031d68329c6b1bd9fa329706e924467a05859465c1045e080cb0293d532a41f2a8e882fb48d1c33a7f87ce27dfde6d07875b34cad6c56697a2d6ef7a9831fff0601b8bcfc01c68056ab27576088ab63b7986ac5b443167bd91c1371f1e3f89dd937667be14d9dd962ad59bc14f7dbf874034dd858217cbe7b2f6660ed5d5c1f737f6f0434e5386c983bd85ca548536fbf6d9e0ce3be4479e12b5cbe63e7c04b0bbd0fc70dd1f91d3b7b62e23ba9fa858e5bb28978236d12b5e43edff20e52a3a48c1795a76160e3bfaf7c4ed40bfd98a5ca3ed5b588df61a451fb67a310369c4f6022fab76a3f622bfce9de32b4c78859dffc6cca4f72bca48ef9a30e31fcbc3c847938d80b8d32b56ebed4d5992a212cfe54adcde6d7f303b06267cfc7e186f0bed3488298a864a579c0c035f6442a76b00410a68b121ef40f3daa4fef149e22a61f637ad2259bfabb5ab059914a976f530fd9640fa3c5cd5ea9f75e65b658c0646187d7ac2fc88d0fbdbd03e5fcd69ef1d54b0449e2601bc65cab3c54aed4914b614e49814aac68b913248283dfb52d4170535dbed2fe00e28c8be47c24869c9556d6ae2948e76fd596a747815884b957421e04fab67c43247e114a8311f64cf720b2dddb14a3dcac0bf0e74a7f395aee5111718a036383dbf1a8d929efb228c6c26f5e9d37a68fa6a1416d8a2aed892bd12cb0f18bf25ef41119993999fd18a6d1aad2f5f5c6cb54ca78d21d72a371b5379d6d0c241923330cf30be4e239b414ff0121c537635b1e71b0f99e9d75f756634619554110594bba148c561061e22a5d4431f3e9e5b209b61acf91c88569c088042f3add9f95dd3d82b652f829f546ae3add7d84a265a10ca642eec10a6bad97b0c6d0a7adc66b083dd1b0b106d072297e2270a8bb4f2da118c0b8c04b6fb092a1503048920527c414cff3b38fbb7701a796892b35040b2934ddbbbb35d1d4e723306385fd132cbd7c73467af57a23c0a7b924ed343e790ef91875d5218d8e1ee6cf6edf0e5f9f8a8f2dae40395e9445241bab42fca275cbe243999757df4cc427c586da288bbfbbe0ff0bc6037e1f5b280d949e3ea668ea21a93c6e15d4ce40f612d03808e4115ce28a72288c2bfc5001b579ae4ad9abbe92636288beba633dccc31f5bb3535276b57e395d3d9ed7f1fe12950eacad4bfefa3dee81cebef8622f4a124425520b1d8fa26cfadacccf0af3756ebbd6ad07bed774569d2da9891d893870f79dda1dab46741cf111301dd5739667315c49249a664a1d8f419d9f841c2ea8f1052452e7556ad9ef3983a56609ac885a282f59f883e9940fda6226545c0702302dacfa2f9c7c1e3d8f592571ccc4df0ab3dd6c383fa8148e1c251c80602814819e4264e5da687d232d51646d04ba1100933c7c9e02d09526fb7470e2d41dea23e504b152202197678becb391f992f6cbdf2935b6f18e203ba41502aa9944d2fc32b025b30c5ac04a91bafd4ced589c8e07b7997586cd8b06296cdb20097530867dfd7905ba39c06aabe892f7e84bbbaafddb7776295aeeebbb590fcd77ecb800e45fd5c235903855f589d6b2055caaa801b4ddfeb85366cc11dcb45a42de240d51f3cfd25693ab4ccedf1fb9860a87510d7fffce173e5a86425e9ae9d3633c20b79b730e1bf767ac7d3be3526e8ac0458297098bb6eb19d3f26ec0dfb5e827d82f062490165bd254dc650992caafdda7a73087074d10927971141e0c2c1af16033f645913251588adec15cba03c0686a018a39249f576d260416f4b07c576d036fe2dda7a7cb71a6567b3da7a6769e70ff7cd23056a6dea7d26f5d066ae8f3dff4ae655168cd7df1e7f524b14acd52841a8f3def7a95f8e56582c686eebad021e032eccacff21367e0562f8bd5b5609f472a2b27d0432c1811a7b22ea225876435d3f79f1258576eac79c6de2365184c975c48d8bb6357f8ee5aac9197316475a8515c64de6ec5a082f824bb97cd48281c7726d0349b91ba9e244fc0b78069ab0fa8aed60c6ab2a7bce13ab1a6eb8259de477e3aa0628407b64f533753118db499070e04ee0c8b933adaf5c0302c16ee0437e76bd85b4da173b6e739ac012df2dc7ee2ab83ffeb71a6b2f63059d9c528c695fcd18c74039715178d43b9aa7379f656101d6458791fbf8962debbc3b345fdf63ec8b9f3059570a198d6a0126c02911ad6366b1546685feb62e7e38180dcc74e82ae8555fcad7c075c2a01de10ba4c293195f361dea94adea152acaec4f67f3943d850569e797924b07a1fabcb9ab04bfa6a5d9c09730c1384de9f2843316dbeb0d929ae13299d8c10a611112568b8191fb350f16df4f7a81b037aa6c57ccdd155f56c5b2efe64a2cb36667e6e80e86e394dfb4c7bc3cd6d708de8e27c56ab07d7e478878407a39a510322e7e5a1146d98f3f9ad18a6d15ae61cce6bf0bb2e5c3dba119791df51447e505030bfdcd0508534908915fbdbaa4544d14130b16434bffe44fe45cecac1a0ba97ae96b5609203560625d35bee7995c2133cfe3738a13c7af22f487ade7001c595ebc8657c1d77868f3e9911922278baf997241ec5932ecbfba8df4663fd95a6cbd51b8dcd7ef54abd41a91f195b94c4f8017dba72c56cf4f2aeff62bd7944e1f4cf8ed0cba7b06fa8954e7766b0e543df4e4cdd444adc7a0b82ea6c3540787d0dd3672a0c781698fc9b11d09b68805341320b54b39db13e55bd8ebd3372eb9017e020c705eb61573e558d1641fa7b93b83aa9aafb7c7c0ca7faaccd7d6dc7333f6d8c60018d48eeef92511d9952ff792a328f88d6c6c04655f4e98e8db116ff63bf8b337e03c1acb6845bf7c59d1855321d123ea4e44cad27425f77e028e07b211abd951202b89e9a5830402da0fe08525c4bd2a20ddcf6795011ef8d133012a5a26c220a504bf1b9736dabd872432b24fd89173a8d3b57423ff4d85609f52a1381593c8a9b641fbe71e013af641eb213804aabe4b562bb595e69ffbbb2b10071ebfa876db9888578c17ab70069ed8316105a101edb51368b8054f63da169da8312045c36d1801475dc7b4423c0c1df2ba14c606be195242409fb0fd43bb625a674d0c92e4fad4954e739d39596438a098ce0280b169619f77854b3e4a9d44356dd94522f706dd89f2b915492b57a6c07c4874c0f175295a8484df3638e069a852f25f85a57509ad670693d9022661ed22c5b69bd48ec0655b32cc346ae8fa65444d508e5d410618e1a12b52afa5946a2dcbce5ca3a0a0adf0db8b6a1f23d907056833eb200f09fcb02b582f5fcf8208c3cf8b606183722f54803803e53ef8d96266a08a31b17f80b05b108e82ecacaf39c61ddde2204f75893f100db0f515dd783f530251d5549333c92afb39a8598cd4c40304d84f7cae1e7d11e46491bddddf787079e9f0e0f6c08c676e7b26b285e78fca2fc149159280e028f6df5f93eeeefae2fc362a612c14d5aba35700c60957e2b2d0b58dd36ff0bb8dbe9232d99155886d5c626d709c171805b10fdf15184dca65ab36aae17281710276c9ae2c8912c35773b2df61ced34854893cec83d297cd5ef82257463405fae5fd60830d17af06444048052f7c78fbe7e93b2c88fdeeda56c739dfc795b566c842b60b22e5e0c531163570227cb5d6e6d872880d874e6baa89320f3bcfdecc2b4abf29f01ec9c9202d9d3131c5fbc7e2b3554cb27f9aadbcbf75f37d1ac6f6684eb4d892b8d7622f4e006db67cd2ea309c6cb21f5281ed436db45a1a70f45c128a5e43343b295158a5ac0bef7eeb892bbdd5b48b64becf98a4278b3262d0457127b3ac7b14756dc431b5fa29a8d02dddab5c96ea4c08ddc318419176715a4fa4cbea908a6134d4439fb223a374d309cd8704671279c97206dc7dad79cd50722297f3c66f82c9d92a4c226000ea958c300cb18133e86c6a7abf5e0f9f020aada5b01faa809c90dd8be46ad6678e0d427073626be5fc968856142393a9866102840548ee2a99c31fc244a775652ccf0aa45e7ef0404e4c2fb3aa8537a2a21e390177c28f117b3a71faf27c8ad240901c2c2b77cbcf7ec1a2971079c461fe07b68a2cee787232d32af8678f4ef6470609e1fb60dee57bf52b93ca435ed8e7f00b14c4f981f7baaebdf706e57279b1cef5a9280cbb6d379599f309a9942f18fe0e0a138928701647f431864d0219861e57c222fc5c053da2f5a89509c4d4699d25260ef4f4e92e6e486084b4a4e39400805645eb8a421d2ea24f3bc80f4d5f319842f924318add31d4805171ae133d51d2c14495319fd4bfb09a8a2af676fa704e2ee20858e61ee24bfa976441e17980bbc222cb427038e8811a5763f3a33263bdc0c6e083ab980ef2c4f50b3a0e3a519b6cbdfb58d4aeb12650449940acd55fabc6bbb0dc8db6ec06f0e828067a6590f1867137f29bcb908379fd9f07aaea37d186b0715c510ba87c685371ce67b2623d6cf221a186505edeb39bde9d9164ca8f3f7e91d1b41f0975e19a74fc9eff5dacac194eef9d54ab01e3e47d703970ea0c44177fff9a5b8fc95fbd68da05037342fec0ac8653255cc1619d1c8b6243072864de12f1d63404f32a2e15b0f9bc4fa828bcf4a7b368d7a7071648d377941fff175ba531e2ffe4ac0666dc36f0cde0f7f2e0a939540997d835f5be8bef88f5f52b44f642e3c334a4f009550f3a0b532cb07bf7db7976f0ceb4e58e955453613c2dcfce59bd10a8e3dc98abc595d98423b8a7aecad1d7b3b181c1fb3c520f16288f9e9e4281cdfc7995ac6c89d9dd79367c6827ff6abbf15b2d9d56a89d555660b46ca68f2e3c7469ce0adfc36848738ca28a80700aeac1293f8013bb191619693a2f2e21e6532e9fc62fd409f3e821c51532f07102e40942dce71343871bb998c0d219b6261875800f598846853fae44cc52de864142eacc8ff396b158f71037f0fa34e8a31518ab0ddddd4c6846d2577ef5cac8e78e9e869eb4ac1d946999d73588da70f78278b8a82939b516b272938db646df50ff705239d39f3d70e5f9e4e8b2e5f05d549dca5722c6d61736ad36ffb8305fca092fd473bacdb29cc15e27431c355755d99ce7e0e923afdc698a8efc6157f159f53b758e6c25c5490be0fe64ca4f7aa5b763caf1b7e1c46e92c887c2aca98ae4ca84b5c47381d795cfcbc2595df97f38254f5f5df36146676fc877837de77b3b3740adb6c93be349a278c8bac50e1072cfc3d6b50c4e77f7e9e91978459a0dcc805948b0ad5dbf6d5645d7c99cb84bee4485fac2b3a65651d712b37fc15db817b245ae4fa567090860637fc75ecbccabb6a38abdf42b88970d7b4d2cc759c812a2a9ebe385c48a69ee908acb774f6b678e9d6f288dc23a2047bba70a131f61c430d6159cb98c60e01127aa4af8730be89f6c0ce64bdc05c4e1824bf38ebe7ae240f80572986e9df6ac17f0c32f30ee5319f5b66684fa50fe318731ac7f62bbc00fc439e2c5d689fa839e6fa20cfbfada6f26c8d2db2424ea8feedf0cbb9e1e96fdbb189fa602ea044fd3f362192811110c5a4213d9f1deaffcaee5212a34b7b950521f130fef7acefb63a9fb150a4769c82d6717acc351c1efe99615e41de65ab4282bdcfb084896400549edd098df85dd3be8662d1934fc6e82dbb225d5fdeb9b68f13c315ed39ab3e3f9824ccc46fa6815f3a2e208879613446f72aa9d82032a79218757c54240f9d8abe569bdc09620974d89302be17c04fe0f2c25caa666eec0772ac375096834f17a115406bc00f217bdf8aa3aa7d7c22cad3a8281650cd7419c0bbd3157fd1b574a20b99de281232d794a7018046aeaac83bc70ea5b4de6b83e6a036b382f94f91faf368ef0c97699502352107456f1ac9bfb6df76143e052422bafa255609e87452318eff6e3133fdd91cf2f239199b2475e7e118fb9cabf82a0c45e66e00b195024801376c66d1be119787bdb5bf5c3efe855920d90144d3f5addde75500a72abef62861b6d1c2bbe1515e1950bf4974604d98ad5842459c4e09333f4d68b1ef523309619d9be6a1e2689cbd3538cb77e99374d6bf704354e72084e7e24a1a3fb75a02f49b499913bb955ed9c3c748b171b7f4ff5b7ef4a93621b1037fcf60089dde9cb447fb3f1a288a21b43f69c973b36f1a3cf8d2f8048c43a6b4f6907d07b040afe79ec3d224b00ffc6456fb750bfef11c4713760157a7575b47874f0f3e3424aec92ae84d97eb8b9483cff604325703886e5b6a790762d1647fef96ec5745e7df2b460674273af44d859990bb1cd564d2212154f094f42e091fc6c6ff23bb9844178f465670558dc057deb34c090096d118de758bdae322c9c4d53e7f9a173b23f7e8fa72639161659ef74cc6a775c6dd4a141cb23bf8259f24390f81cad0b9fbf9ff94bfe7f44b8df38998772a122d0e52580fe8fafa04427e9de7995a0bcbe945b08c6c98cef1708dcb1055711371a192def483fc6243331b907eb604472de300dddc37609a14f39143babb761e2d978451d77fcd0f0ff1e04645fd264fb990bb5bafb146a93252350792609aa926a3d987180aa75ecebcc1878b1c85d720bf4923fdbd19fe1652166c96860f5fb91e4ca65387e292d5fb6c276950f9b0981dfd40924eb89b3454a76c4f3d87d304cea4fe15910995004f2e2a6275cc88a0ab184b772b53034799b8f91bc2ca6e50a0a0aa6e930f66bcef2bf85be86beb913382ba08fd2b62657a640834bc6f6d1a86cef99e7cf983255dda8ae665b42b7ebfa0eb70d979d9b2e93bb8b5d039aa3d4cd5eb84362a289f7223b852e7c29653e411075cc04b41c382ca112b0077eb0be66202de1e2e41e1fac82f7d8307435e11893e5f0f86f8c21f0e36ef2b2f80c6526251728d1652005efa07ea84ebb1a3e98cb12ec050e0e87086d0634c3c07e6a0b0bd88b4ee7d4988d5241c754e51996a493163f9d5798039069b747e145d932e0824c09d50edee64e21648270215e50ab08d03f7e7e486154a8cbfcd1a209776c0d2daaf24e806e43fa676eef23ac45970b92ff41f707f747a1357cde07553de7e008017cb09ac6d60a9fc72bbad6c7fc617402b8e0e94e65f4264be7e1c61d664c436ab6c92ce858d0c7c167625ee7dab53abe61a2dcb90445629eb0b08f1f86a0a16c6c874120e52a31b9bda426968e69b8ffba06aa94788fa6c43b5fc593606573ef8c2aa47f6564c544116b5a66a1fe80c59f8e9b107b845124ee2c43d34c9d8fbc62ee798b45c906ff624aeba24fe777f23c184be85da9f2a27277e343acc5ed60f57068be8540f0134564c4', 'pending', NULL),
(10, 4005, 129.55, 'from', 3, '12 new st', 'mv', '1', '10011', '2012-10-27', '2:00am', 5, 2, 1, 2, '2 bags added\r\n2 children\r\n5 adults\r\ncar seat added', NULL, 'America West', '1234', 'a:1:{i:0;s:1:"2";}', NULL, 2, '9FY03690YK675222T', NULL, '2012-10-20 15:44:25', '2012-10-20 15:47:05', '125f37a0f97515479ecb11d500d713163227b3c9e0de6d266761b95f32165724970e4a4bb952265689826726674a0cff31317a2e3be7f351f9fbe35de4933b1472a6c33250407ac8b60ac2a22bbd3eed370e5569ad3bcf26e18f468f92d72e86cb3a8c137f90648200f6df055058946cd71b908d4631904022d74ccd894343af6882dd7fa6e6b20ddf1a21d7e7e9bd81696249608df6792081110bb5262c55438f450723759f1abba8e464501814e4bea6fddf9f6cf607f1a474f518ea55dbe0f0d61a177f069b394844ce7db62798ad07336e445e5d886fd7bef3ed8f89679fe81675e3e900b8be5bd3ba3193b2f86212886be00725536fe10d1fa8638d4e6a2b2e8719568facf9793ed8757abb25b7d35a86baeb73b78834d922a849bfff47481f3fa9bf663a6fdb6884be37b1fd693bf4fd64f1939821ab76a0918dd2130b8c69c899d3f5712a4826ce9d98d2e35e5165f5a558e45f5819d7f0befbbe02ffa237519b953bad54c1a86ec551c135cc856ab54a7c58bee67001bba7a0e0a003009aaececc52de917b672a980cd9c61f0939a30a022e98ea878e55ab01ee6cb6d516ee98285ecef7a128257e8d3dde68c33304195a6b5582a96cce4b6b542b7b55ae18e44c75cd21822b84c0a5a97243d7661417e9d653f4f9f581e6fb890c8596a29e887be0f645b97befc76415b31057a0337ab3dbe1730a792bfcd29c38bcb63608bdfdffacba4f0f8dcfcb415a16d9cddcb8e01856684d3804f33dd8a9e30b238d0e2685ef9ae8537db82d41f73620493a8fba3ca6d9beb5bd8ec92e4dfae4cb88aee75f0698560811eba70dcd5946b65248872e064fa6159e96553767583af4add1fff7b12db6eb9a8077eff8f7ab11475774b9256888d18f7ab0647d93772077b4e94a5b58497f34abf0c1cb2054ab92e46113c2cd8458fcf40e16ee80951500a3787ae210dc1e91cfc3e8a9d70c4f5698a4c3d9779ce3d1c817b68cedc6585b090d31f93a8afe4d56f40f1edef4775e080675daa605868c83e10db284b5baa2f418363cc5bb9b5d021521339d33d2fe01bdb394245c12403fd4f532962a3af324f26ddbf2112be9d61c2772acec43df95ac9e52e8e9f9bab1cbbefcb5bf0913472a00357cb8343dff070be3500e7cf6b079c8cccfefc2074a8692f1ca8ba6fe34a1b361b8215c289de684b315c3cc776cca38de716de75e09afdfd6c67447ccc198a797b9253ee1c03d15994f129a9898f65ffe4a4f231bf4d922448785054af1588dad7bf7a3c5966b14b65bd9453f2b6cc3712b6eb6f5df6e19d92c943ab4a4569f11bf58a3195a93998eac15d0949afb84fdb2ec249dcc679e2e50178672797ec5b5060ec7c0be5bae1e59c448a528886942f9fe3fbf49bebce7b033fe7f5bde1c6437153a6ddf3f9dfdd978439e38062d592891d91278672b0ccc2aba56053b0363ce2cc989f5f5d9478dc0f315306989cf8e1a1d8b36ba256641193fc48e71ca12de1113a9d6cc16847ac1bf662c53bac0861383ea3bf3343d2c17d7aea612dc31c2b4b59328a48a9711f9454eb0e2d2248d014d47ae4c210a49e1b366f8434da40acfc2e069b37082651f730669b94dc23b126407d226c647651e67cb71f00acaf4f387f5186f0f8c1b269d1bc8fe6f0d2a8ada326547ec778f2c40ea2600ce9da69683fa1001712c954923c6de6c0fcd7c826f6d82816fe73533624285c5c061250e7be70f29779e7752a2d6e7871143f2650b688b2cc712d0031b8b2b70beda2fc39e9910550bac8195502fa757604a15a8d2ae521ff4b57522f76d099b76ded884869fc9cc2e16a7191edd9dabb07f8e4e5fdf719068cfb8fe5b6570f714fa1b05b71ca33df199c32f5662fb160a480d', 'pending', NULL),
(11, 4006, 105.33, 'from', 1, '1', 'nyc', '2', '10011', '2012-10-25', '2:30am', 1, 0, 1, 1, '', NULL, 'America West', '1234', 'a:0:{}', NULL, 2, '45021571P0795230G', 0, '2012-10-23 08:39:58', '2012-10-23 08:39:58', '125f37a0f97515479ecb11d500d713163227b3c9e0de6d266761b95f32165724970e4a4bb952265689826726674a0cff31317a2e3be7f351f9fbe35de4933b1472a6c33250407ac8b60ac2a22bbd3eed370e5569ad3bcf26e18f468f92d72e8689b284f3df14754bce5a80f63eaad82cab72ede661a4c4600b530151bd073d08e9cda54b206a576fae6d36ae220ab2ae54f0e703d57c4e2b4b10781cc721d22984409ce75401bd79506db69cbf8a8be96b3167e125592275688194abddf924dd2974f7af36b66e11490a273d5de3a40fee0851d863209aa9709fb58ac74da07a62ee7e04c097c9302b702f25b325a94734737a3926a464941dcf3a92dfe8295e2f76132e826d0157c20062a04e7c30acd00f8b1a433dd592d5153325f6f02dc60f865b8c0c08f87c8ff43277c6049510edaa8b047485829f79eb5e1dd479713968e2b2fb83ffd56bf2b60dec40ce2de462b1c086dc799d3bedd4d4bf7350bb9afb97a5bac0a261c3c348be435f30abdad0829b3ef116d405fb82b94220bed33df52981bd8b137d8a2901d9bc32f3903ccf2d2ecb54bc3da606dee32fef036ea33d9011099676c47b42f76fdc9a9f05479cb52c93992c6818c9b3270e4b832a9c206037af63c3d0e090405ad3e28596b3c2236a25bc052aa950db5735f53e64582bf66711bed72414bb2e37678e56e5f27d709448a5c88582a4776c148ac63de4f1617335da6334c4b98cb9698eb0715053a66cf67277acfdd7e9432368a3290b421bd1580cd3baa4126e3122d30c9c2fd1ca89600db442470a470868cdf2001f0d13b02d8331cb752fedaa7bc6e33fed7286a5d7e913e9fb2cadd8aa9d0b51544042207eeef34fc866a2c0e5aa840a7518cda164dff7e9d9b3c720dc2b0046e4d064d76a3a524cb8a05d3b39bd1f1101b193148c98bf6964f7dea345300c3453c156c5d55c6ecdcbd881218a5cc7c8bef52c58bfa4570e7dff0ba4fe110f118b9b0afef70d3737506bae78906445df236d9938b70513c016ff0334f3ea5dc4b841964fe9c18e8c5540cd6dc677e3d0f95829f71c2b142f916dbdceea6f52b358389024ee4783138ab2c1228fdaa781667f7095c9e5b24c8b1ecdf2358bea8e1aaf2fc00c48d0a0583ed3c0d14441310e7145182fe8cfd193ef962a07c0c05547c92c8f10c4b23590f9eff58424a108330714f14a2ee83ed37c1e86dd54e47a9e9222fe7a87088b54e6608523597bbbe23fb406d0ee94944afac778ccd2c3f7c6dd86448893749f6c3120ca45425d9fc4179a2515369901b944f584588ec68c5439c3849de1df15eb8841710cfc9744de47443d3802fd9f40016c6d8aaa5c1a240cd2c098c9890c828fa440c63daf909ef8abd882662ff825f7d5839367a8831332d4534faeadbb63e5c6bdb280cde97c234aad937e3e3bbd5b1a3dee86cb9a8c9dd14809fdaa74c14102f7475fbf1441f4134a08f46a555865dd8707d7eb6be80ed97b72e3455c336db38e014d998269b2eba202c99de7a16ae6228388a96373431a58a5738228a0baaf3114952fe382edd2876e132bfb2890f3881c275781a17eb44e1e81f645d1e5a2a8f6259f63c06dd6604ad2f81d00b5f05b4b967a5d85e1deabe22184270cf85db42605bf10870b8abf9711801dfb07d0996d1c39697a6c56f5b8ebfe3f3ab46d3833d2b82346d1600050cac6c438ee2a74f637873f30e902e02dbcee3ceb74bfef9f6dd8089d036fde698c833b57d20527d0ab479d55ce8a61401e5b043f9f2cbb082c318156fcd433a195245740941ee02251ffdecaa7982af20616200dd164c6c4ebf9d5ce', 'pending', NULL),
(12, 4007, 73.98, 'from', 2, '74747', 'nyc', '2', '10001', '2012-11-21', '1:30am', 1, 0, 1, 1, '', NULL, 'America West', '1234', 'a:0:{}', NULL, 2, '9NM36721247089621', 0, '2012-11-05 23:10:28', '2012-11-05 23:10:28', '125f37a0f97515479ecb11d500d713163227b3c9e0de6d266761b95f32165724970e4a4bb952265689826726674a0cff31317a2e3be7f351f9fbe35de4933b1472a6c33250407ac8b60ac2a22bbd3eed370e5569ad3bcf26e18f468f92d72e868be82f39ca3a91ae2bd72b8ad4691e5772a979c1172376fe3b5a2fc897d4f46a8d23c96a0bfbc1d7584a7668e45296087c7d8c1a6e19fb965fbf26c45b3eb34eb86c82a6fc94ee0a6789604dd1e7d932585db01e34de982cb2d8bfff4ddea27b5511f0c78551e5fb2ecbbcf479395352cdb2371c6102a0825b48555abe8fd1249459bea51a928a408c3c52a4c86becfe8b5ea093040efad9f4e27cf689510ef45afc21604663ec7ad9bdea94c21b9850e1913d67271bb45bd8d6ac42a1b79287da7a0aa14e8574d8c2865ba827a208cbcfa9e894cf49d8e2830d3e4f11438d475250e76fc2714fb919fd6d553103d22471fc4dd99f650650b07c151b757bb1e5d3c1b1969f379b1d36bbd02e06a03387be2c5e5cbe478050e74c08095e43b05e28b4653860f1ced03570dd94642395acd1e5a1da62aa3cffc209e49111d67075222eae2cfdadc7b1548f3d0dad3b46b5cbbac7ff9846e4ada3be2a9ce4dc34a5617fe3e7983eca15e22ce9677b3cf09da7b42987b1851dbc6a5ed4864aee6b5b604f5d7a07e5588800bd24c73bfa7e3655013f39ed4b58af0d82790bf83d4c21d3d52b2b35b45d41bfbb2723c563c60440e0010eb52f26f7f3e7962887cdd57ce001f4811dd20d132fd124db1bacb01bbd9c7b1e32bb5a561783e238e5ee246e48f22aa717e99e224d2890d11eafc1915171e4efa4ab9a2a3b2f9576fcc4fff8872b646c31806911872e8aea462e7c97b191e2d3665df2df0234d6ccc26065e7c9fd27b1adbbd820362504144c674552372a087e9c6a237bdbfef7073b904d7b2964b504dd5451b69eb21bd9c7f1439914cc484260730b47098768fdfdb9847dae7451c6fcbe87e159df9af90e80a40e05e6c406a4020559821ed15d855b3d679a9c9ae9372bbfcd6fdf86a19ccfc5736788262efe761d29db6bd7e5a00f440ee3ac9fc483cde8020e5327a4e6e095dbf6128bf4efebe47fab62c8503c50eeb913c803eb54919af675429cc0e6a1fd4f1b04ae4ea6266bfaa098d3f006615d711aea9903ff2d8404e0d0829e9c2285913a2cc897bd0f62fae406fa704eb327c4792ba582426dc182fcaefd502adedb8ce4c68c0c63e1c086c603575762f568c453587fe29f26fa689351b4e154f3b0315fc20e0b3ee78f59a24611091c202846f3c988c8581d4420814be32fa5fdf228460fbdf046954f3760b93a7ef9313985bfe15e9dd5e589b2ed7e535e5375d74471d1cc9516ca30f8e94d42bbacfd4bbc7d0ca8050b2defa832c830a39213dbf17e567fd7abf2c224f6e7d6baa4bc4e51eb6ce811bc56326f99e5fca781e463466c80ee0b68eaa0243c235623496f17b138e80ff706ccb6687972c8c9bf5f916a2d13c5fa066196a1689df7ff52293b0715bc6c77b3210c764df2208142e2a39dfc8155c9eeed55b184b16f6692f2de12dcfb1344d5f306ea84642079246fefe952f1c288c03c1da8297db81eb7439b6483d8c2a2f8054aa521645b27dec01875b4fb80f2c1f1faf2b8ed9917eda521b4f90593cce8bfff28d7f00dddad809ff0e92eeeb387f5afa4290bb25d2144c1456490a5559b2e212fbd626ee7d832399ab2ca8b501d9e4b72545a00e06ab16a6946799f007f4a6f64f952fed0423f488237f1e83153e9ee9248d08a9740599953c4e21338168f2f1fe50e06aa1fbe63ec1320fa743bb8ff647a21b57b7d66e12848ffe8839517161ef1156a082870623d', 'pending', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `form_settings`
--
CREATE TABLE IF NOT EXISTS `form_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nys_tax` float DEFAULT NULL,
`pro_fee` float DEFAULT NULL,
`mid_tax` float DEFAULT NULL,
`lin_tax` float DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`car_seat` float NOT NULL,
`driver_inside` float NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `form_settings`
--
INSERT INTO `form_settings` (`id`, `nys_tax`, `pro_fee`, `mid_tax`, `lin_tax`, `username`, `password`, `car_seat`, `driver_inside`) VALUES
(1, 8.875, 0.03, 5, 5, 'username', 'password', 30, 30);
-- --------------------------------------------------------
--
-- Table structure for table `form_states`
--
CREATE TABLE IF NOT EXISTS `form_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`code` varchar(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `form_states`
--
INSERT INTO `form_states` (`id`, `name`, `code`) VALUES
(1, 'NY', 'NY'),
(2, 'NJ', 'NJ'),
(3, 'CT', 'CT');