-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `gaa-2020`
--

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

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertisements`
--

INSERT INTO `advertisements` (`id`, `name`, `price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Inside Front Cover', 1500, 1, '2020-01-28 07:16:13', '2020-01-28 07:16:13'),
(2, 'Inside Back Cover', 1500, 1, '2020-01-28 07:16:13', '2020-01-28 07:16:13'),
(3, 'Spread', 1000, 1, '2020-01-28 07:16:13', '2020-01-28 07:16:13'),
(4, 'Full Page', 800, 1, '2020-01-28 07:16:13', '2020-01-28 07:16:13'),
(5, 'Half Page', 600, 1, '2020-01-28 07:16:13', '2020-01-28 07:16:13'),
(6, 'Quarter Page', 400, 1, '2020-01-28 07:16:13', '2020-01-28 07:16:13');

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

--
-- Table structure for table `agendas`
--

CREATE TABLE `agendas` (
  `id` int(10) UNSIGNED NOT NULL,
  `day` int(11) NOT NULL,
  `from` time NOT NULL,
  `to` time NOT NULL,
  `event` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dress` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sponsor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agendas`
--

INSERT INTO `agendas` (`id`, `day`, `from`, `to`, `event`, `venue`, `dress`, `sponsor`, `created_at`, `updated_at`) VALUES
(1, 1, '10:00:00', '16:00:00', 'Registration and Scheduler Pick-Up', 'TBA', '----', '', '2020-01-27 18:16:35', '2020-01-27 18:16:35'),
(2, 2, '09:30:00', '09:45:00', 'Conference Assembly', 'Ground Foyer', 'Business Attire', '', '2020-01-27 18:35:09', '2020-01-27 18:35:09'),
(3, 1, '17:00:00', '19:00:00', 'Welcome Cocktail Reception', 'Crystal Room, Level 2', 'Business Attire', '', '2020-01-27 18:41:17', '2020-01-27 18:41:17'),
(4, 2, '09:45:00', '21:55:00', 'Ribbon Cutting Ceremony', 'Ground Foyer', 'Business Attire', '', '2020-01-27 18:42:07', '2020-01-27 18:42:07'),
(5, 2, '09:55:00', '10:15:00', 'Network Management Updates <br/>Mr. Nils Walle<br/>  Director and Co-Founder', 'Opal & Pearl, Ground Floor', 'Business Attire', '', '2020-01-27 18:43:08', '2020-01-27 18:43:08'),
(6, 2, '10:15:00', '10:25:00', 'Newbie Open Mic', 'Opal & Pearl, Ground Floor', 'Business Attire', '', '2020-01-27 18:43:57', '2020-01-27 18:43:57'),
(7, 3, '09:00:00', '09:15:00', 'Assembly for GAA City Tour', 'TBA', 'GAA Shirt', '', '2020-01-27 18:44:58', '2020-01-27 18:44:58'),
(8, 4, '09:45:00', '22:00:00', 'Conference Assembly', 'Ground Foyer', 'Business Attire', '', '2020-01-27 18:45:50', '2020-01-27 18:45:50'),
(9, 2, '10:25:00', '10:45:00', 'Network Coffee Break', 'Opal & Pearl, Ground Floor', 'Business Attire', '', '2020-01-29 07:07:48', '2020-01-29 07:07:48'),
(10, 4, '10:00:00', '12:00:00', 'Face-to-Face Meetings', 'Diamond Ballroom', 'Business Attire', '', '2020-01-29 07:08:18', '2020-01-29 07:09:30'),
(11, 4, '12:00:00', '13:30:00', 'Lunch Break', 'Emerald Room', 'Business Attire', '', '2020-01-29 07:08:47', '2020-01-29 07:08:47'),
(12, 4, '14:00:00', '16:00:00', 'Face-to-Face Meetings', 'Diamond Ballroom', 'Business Attire', '', '2020-01-29 07:09:21', '2020-01-29 07:09:21'),
(13, 4, '16:00:00', '17:00:00', 'Closing Happy Hour', 'Diamond Ballroom Foyer', 'Business Attire', '', '2020-01-29 07:09:59', '2020-01-29 07:09:59'),
(14, 3, '09:15:00', '11:00:00', 'GAA City Tour', 'TBA', 'GAA Shirt', '', '2020-01-29 07:10:40', '2020-01-29 07:10:40'),
(15, 3, '13:39:00', '13:30:00', 'Lunch Break', 'Mosaic', 'GAA Shirt', '', '2020-01-29 07:11:18', '2020-01-29 07:11:18'),
(16, 3, '14:00:00', '16:00:00', 'Face-to-Face Meetings', 'Diamond Ballroom', 'GAA Shirt/Casual Attire', '', '2020-01-29 07:11:55', '2020-01-29 07:11:55'),
(17, 3, '16:45:00', '17:00:00', 'Assembly for Sunset Cocktail', 'TBA', 'GAA Shirt/Casual Attire', '', '2020-01-29 07:12:41', '2020-01-29 07:12:41'),
(18, 3, '17:00:00', '19:00:00', 'Sunset Cocktail', 'TBA', 'GAA Shirt/Casual Attire', '', '2020-01-29 07:13:08', '2020-01-29 07:13:08'),
(19, 2, '10:45:00', '11:15:00', 'Keynote Speaker: TBA', 'Opal & Pearl, Ground Floor', 'Business Attire', '', '2020-01-29 19:04:31', '2020-01-29 19:04:31'),
(20, 2, '11:15:00', '11:35:00', 'Sponsor\'s Presentation: TBA', 'Opal & Pearl, Ground Floor', 'Business Attire', '', '2020-01-29 19:05:03', '2020-01-29 19:05:03'),
(21, 2, '11:35:00', '12:00:00', 'Group Photo', 'Opal & Pearl, Ground Floor', 'Business Attire', '', '2020-01-29 19:05:28', '2020-01-29 19:05:28'),
(22, 2, '12:00:00', '13:30:00', 'Lunch Break', 'Crystal Room, Level 2', 'Business Attire', '', '2020-01-29 19:06:01', '2020-01-29 19:06:01'),
(23, 2, '14:00:00', '15:20:00', 'Face-to-Face Meetings', 'Diamond Ballroom', 'Business Attire', '', '2020-01-29 19:06:24', '2020-01-29 19:06:24'),
(24, 2, '15:20:00', '15:40:00', 'Coffee Break', 'Diamond Ballroom Foyer', 'Business Attire', '', '2020-01-29 19:06:50', '2020-01-29 19:06:50'),
(25, 2, '15:40:00', '17:00:00', 'Face-to-Face Meetings', 'Diamond Ballroom', 'Business Attire', '', '2020-01-29 19:07:11', '2020-01-29 19:07:11'),
(26, 2, '17:00:00', '19:00:00', 'Open Evening', 'TBA', '----', '', '2020-01-29 19:07:45', '2020-01-29 19:07:45');

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

--
-- Table structure for table `days`
--

CREATE TABLE `days` (
  `id` int(10) UNSIGNED NOT NULL,
  `day` date NOT NULL,
  `title` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `days`
--

INSERT INTO `days` (`id`, `day`, `title`, `created_at`, `updated_at`) VALUES
(1, '2020-10-06', 'Registration and Welcome Cocktail Reception', '2020-01-27 17:35:58', '2020-01-27 17:35:58'),
(2, '2020-10-07', 'Ribbon Cutting Ceremony and Face2Face Meetings', '2020-01-27 18:34:15', '2020-01-27 18:34:15'),
(3, '2020-10-08', 'City Tour and Face-to-face Meetings', '2020-01-27 18:44:24', '2020-01-27 18:44:24'),
(4, '2020-10-09', 'Face2Face Meetings', '2020-01-27 18:45:21', '2020-01-27 18:45:21');

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

--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `id` int(10) UNSIGNED NOT NULL,
  `company_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website_url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` (`id`, `company_name`, `name`, `email`, `phone_number`, `website_url`, `message`, `created_at`, `updated_at`) VALUES
(1, 'RW', 'Ivy Auxu', 'auxilioivy30@gmail.com', '4534534', 'Gooogle.com', 'Test here', '2020-01-30 22:16:39', '2020-01-30 22:16:39'),
(2, 'RWTest', 'Ivy Auxu', 'auxilioivy30@gmail.com', '4534534', 'Gooogle.com', 'Test', '2020-01-30 22:32:42', '2020-01-30 22:32:42'),
(3, 'RW', 'Ivy Auxu', 'auxilioivy30@gmail.com', '4534534', 'Gooogle.com', 'Test mail', '2020-01-30 22:59:57', '2020-01-30 22:59:57'),
(4, 'Google Inc', 'Ivy Auxu', 'auxilioivy30@gmail.com', '4534534', 'Gooogle.com', 'Test Message', '2020-01-30 23:29:12', '2020-01-30 23:29:12'),
(5, 'SCV', 'Ivy Auxu', 'auxilioivy30@gmail.com', '4534534', 'Gooogle.com', 'Should you have any concerns on Global Air Cargo Forwarders Alliance, kindly fill-out the form or send us an email at info@globalaircargoalliance.com and we’ll get back to you the soonest.', '2020-01-30 23:34:32', '2020-01-30 23:34:32'),
(6, 'RW', 'Ivy Auxu', 'auxilioivy30@gmail.com', '4534534', 'Gooogle.com', 'Should you have any concerns on Global Air Cargo Forwarders Alliance, kindly fill-out the form or send us an email at info@globalaircargoalliance.com and we’ll get back to you the soonest.', '2020-01-30 23:37:52', '2020-01-30 23:37:52'),
(7, 'RW', 'Ivy Auxu', 'auxilioivy30@gmail.com', '4534534', 'Gooogle.com', 'Should you have any concerns on Global Air Cargo Forwarders Alliance, kindly fill-out the form or send us an email at info@globalaircargoalliance.com and we’ll get back to you the soonest.', '2020-01-30 23:42:06', '2020-01-30 23:42:06'),
(8, 'RW', 'ivy', 'auxilioivy30@gmail.com', '4534534', 'google.com', 'This is a test message', '2020-02-03 18:38:14', '2020-02-03 18:38:14'),
(9, 'RW', 'ivy', 'auxilioivy30@gmail.com', '4534534', 'google.com', 'withError', '2020-02-03 19:49:35', '2020-02-03 19:49:35'),
(10, 'RW', 'ivy', 'auxilioivy30@gmail.com', '4534534', 'google.com', 'heaa', '2020-02-03 19:56:22', '2020-02-03 19:56:22'),
(11, 'RW-Manila', 'ivy', 'auxilioivy30@gmail.com', '4534534', 'google.com', '@if ($errors->any())\r\n<div class=\"alert alert-danger\">\r\n	<button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button>	\r\n	Please check the form below for errors\r\n</div>\r\n@endif', '2020-02-03 21:12:31', '2020-02-03 21:12:31');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(10) UNSIGNED NOT NULL,
  `network_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `network_slug` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `network_logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_logo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hotel_logo` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_tagline` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_sale` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_director` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hotel_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_year` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `director_message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `regular_fee` int(11) NOT NULL,
  `vip_fee` int(11) NOT NULL,
  `earlybird_fee` int(11) NOT NULL,
  `earlybird_status` int(11) NOT NULL COMMENT '0 = false , 1 = true',
  `earlybird_end` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_start_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `launch_scheduler` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_teaser_video` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `event_director_dp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `waiver` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `network_name`, `network_slug`, `event_name`, `network_logo`, `event_logo`, `hotel_logo`, `event_tagline`, `event_sale`, `event_director`, `event_email`, `venue`, `hotel_name`, `event_date`, `event_year`, `director_message`, `regular_fee`, `vip_fee`, `earlybird_fee`, `earlybird_status`, `earlybird_end`, `event_start_date`, `launch_scheduler`, `event_teaser_video`, `event_director_dp`, `waiver`, `created_at`, `updated_at`) VALUES
(1, 'Global Air Cargo Forwarders Alliance', 'GAA', '3rd Annual Partnership Meeting', '/network_logo.jpg', '/event_logo.jpg', '/hotel_logo.jpg', 'THE GLOBAL AIR CARGO FORWARDERS EVENT', 'Jian Yuzon', 'Christian Raueber & Nils Walle', 'info@globalaircargoalliance.com', 'Mandarin Oriental Kuala Lumpur, Malaysia', 'Mandarin Oriental', 'October 6-9,2020', '2020', '                           <h2>WE’RE FLYING TO KUALA LUMPUR, JOIN US!</h2>\r\n\r\n                            <p>Hello GAA Friends,</p>\r\n\r\n                            <p>Buckle up and get ready for your next flight.</p>\r\n                            <p>We’re glad to inform you that GAA will be heading to one of Asia’s most exciting\r\n                                destinations - Kuala Lumpur.\r\n                            </p>\r\n                            <p>GAA’s 3rd Annual Partnership Meeting is planned for October 9 – 12, 2020 at the Mandarin\r\n                                Oriental Kuala Lumpur, Malaysia; expecting to be at a level of 120+ airfreight\r\n                                forwarders from all over the world.\r\n                            </p>\r\n                            <p>\r\n                                This year, I have taken the personal challenge to host an even better conference in\r\n                                Kuala Lumpur - we promise to show you a different GAA, with new airfreight friends that\r\n                                will take the network to the next level.\r\n                            </p>\r\n                            <p>We have a bright future in airfreight, let us realize it together and make the best out\r\n                                of it!\r\n                            </p>\r\n                           ', 999, 800, 100, 1, '1597237140000', '1599609600000', '1601337600000', '', '/director.jpg', '                    <p><b>Liability Waiver</b></p>\r\n                    <div class=\"col-12 py-3\" align=\"justify\">\r\n                        <input type=\"checkbox\" name=\"termsA\" id=\"termsA\" class=\"form-check-input\" value=\"1\">\r\n\r\n                        <label for=\"termsA\" class=\"form-check-label\">\r\n                            This is to confirm that I am not an owner/administrator/board member or adviser to other\r\n                            freight forwarding\r\n                            networks/alliances, profit or non-profit oriented. I agree that if any form of link is\r\n                            established that my\r\n                            membership can be cancelled without refund and agree that RW may terminate my\r\n                            attendance/members and inform\r\n                            all members/attendees of my termination including other network owners, associations and\r\n                            alliances. </label>\r\n                    </div>\r\n                    <div class=\"col-12 py-3\" align=\"justify\">\r\n                        <input type=\"checkbox\" name=\"waiver\" id=\"waiver\" class=\"form-check-input\" value=\"1\">\r\n\r\n                        <label for=\"waiver\" class=\"form-check-label\">\r\n                            This is to confirm that we do not have any outstanding payables or disputes with any of our\r\n                            forwarding\r\n                            partners beyond 60 days. This is to confirm that we are not listed on any blacklisting in\r\n                            either FDRS or our\r\n                            local association, as any findings can be published. </label>\r\n                    </div>', '2020-01-23 08:15:56', '2020-01-23 08:15:56');

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

--
-- Table structure for table `member__advertisements`
--

CREATE TABLE `member__advertisements` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `advertisement_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `member__advertisements`
--

INSERT INTO `member__advertisements` (`id`, `member_id`, `advertisement_id`, `created_at`, `updated_at`) VALUES
(37, 71, 3, '2020-02-05 19:17:04', '2020-02-05 19:17:04');

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

--
-- Table structure for table `member__dietaries`
--

CREATE TABLE `member__dietaries` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `diet_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `member__services`
--

CREATE TABLE `member__services` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `member__softwares`
--

CREATE TABLE `member__softwares` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `software_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `member__softwares`
--

INSERT INTO `member__softwares` (`id`, `member_id`, `software_id`, `created_at`, `updated_at`) VALUES
(9, 31, 7, '2020-02-04 19:51:39', '2020-02-04 19:51:39'),
(10, 31, 8, '2020-02-04 19:51:39', '2020-02-04 19:51:39'),
(11, 32, 7, '2020-02-04 19:54:07', '2020-02-04 19:54:07'),
(12, 32, 8, '2020-02-04 19:54:07', '2020-02-04 19:54:07'),
(13, 64, 1, '2020-02-05 18:49:50', '2020-02-05 18:49:50'),
(14, 64, 8, '2020-02-05 18:49:50', '2020-02-05 18:49:50'),
(15, 65, 7, '2020-02-05 18:57:03', '2020-02-05 18:57:03'),
(16, 70, 7, '2020-02-05 19:05:00', '2020-02-05 19:05:00'),
(17, 70, 8, '2020-02-05 19:05:00', '2020-02-05 19:05:00'),
(18, 71, 7, '2020-02-05 19:17:04', '2020-02-05 19:17:04'),
(19, 71, 8, '2020-02-05 19:17:04', '2020-02-05 19:17:04');

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

--
-- Table structure for table `member__specializations`
--

CREATE TABLE `member__specializations` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `specialization_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `member__sponsorships`
--

CREATE TABLE `member__sponsorships` (
  `id` int(10) UNSIGNED NOT NULL,
  `member_id` int(11) NOT NULL,
  `sponsorship_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2020_01_23_065002_create_events_table', 1),
(4, '2020_01_27_075904_create_sponsorships_table', 2),
(5, '2020_01_27_082251_create_agendas_table', 3),
(6, '2020_01_27_082638_create_days_table', 3),
(7, '2020_01_28_025437_create_registrations_table', 4),
(8, '2020_01_28_031833_create_services_table', 4),
(9, '2020_01_28_031945_create_software_table', 4),
(10, '2020_01_28_032005_create_networks_table', 4),
(11, '2020_01_28_055939_create_specializations_table', 5),
(12, '2020_01_28_071026_create_advertisements_table', 6),
(13, '2020_01_28_122832_create_member__dietaries_table', 7),
(14, '2020_01_28_123132_create_member__specializations_table', 7),
(15, '2020_01_28_123155_create_member__services_table', 7),
(16, '2020_01_28_123212_create_member__softwares_table', 7),
(17, '2020_01_29_110836_create_member__sponsorships_table', 8),
(18, '2020_01_29_110901_create_member__advertisements_table', 8),
(19, '2020_01_31_030551_create_emails_table', 9);

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

--
-- Table structure for table `networks`
--

CREATE TABLE `networks` (
  `id` int(10) UNSIGNED NOT NULL,
  `network` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `registrations`
--

CREATE TABLE `registrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `salutation` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Mr.',
  `firstname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shirt_size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iata` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '1-pending payment, 2-paid for confirmation, 3-confirmed',
  `early_bird` int(11) NOT NULL COMMENT '1-yes, 0-no',
  `referral` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vip` int(11) NOT NULL DEFAULT '0',
  `conference_fee` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_price` int(11) NOT NULL,
  `learm_about_us` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Freight Network and Alliance', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(2, 'Freight Media', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(3, 'Freight Payment Security Provider', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(4, 'Freight Technology Provider', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(5, 'Freight Events', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(6, 'Non-Profit Charity', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31');

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

--
-- Table structure for table `software`
--

CREATE TABLE `software` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `software`
--

INSERT INTO `software` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Wisetech/ Cargowise', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(2, 'Redberry', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(3, 'Centrolene', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(4, 'SAP', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(5, 'Win', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(6, 'Logitude', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(7, 'Magaya', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(8, 'Softlink', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31');

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

--
-- Table structure for table `specializations`
--

CREATE TABLE `specializations` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `specializations`
--

INSERT INTO `specializations` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Import Airfreight', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(2, 'Export Airfreight', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(3, 'Wholesale Forwarding', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(4, 'Courier Express', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(5, 'Critical Airlines', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(6, 'Air-Air Transshipments', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(7, 'Importer of Record Services (IOR)', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(8, 'Exporter of Record Services (EOR)', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31'),
(9, 'E-Commerce Cargo', 1, '2020-01-28 06:00:31', '2020-01-28 06:00:31');

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

--
-- Table structure for table `sponsorships`
--

CREATE TABLE `sponsorships` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `slots` int(11) NOT NULL,
  `inclusions` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL,
  `sponsor_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sponsorships`
--

INSERT INTO `sponsorships` (`id`, `title`, `price`, `status`, `slots`, `inclusions`, `order`, `sponsor_by`, `created_at`, `updated_at`) VALUES
(1, 'Diamond Package', 6000, 1, 1, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition in the speech of the RW Solutions\' Founder during the\r\n                                                opening ceremony</li>\r\n                                            <li>4 free passes to the conference</li>\r\n                                            <li>Print advertisement on conference directory (Spread)</li>\r\n                                            <li>Logo display on conference website homepage with hyperlink to your\r\n                                                company website </li>\r\n                                            <li>Logo printing on 2 banners </li>\r\n                                            <li>Placement of marketing collaterals in conference bags</li>\r\n                                            <li>Free 1 VIP Table </li>\r\n                                        </ul>', 0, '', '2020-01-27 08:05:12', '2020-01-27 08:05:12'),
(2, 'Gold Package', 5000, 1, 2, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition in the speech of the RW Solutions\' Founder during the\r\n                                                opening ceremony</li>\r\n                                            <li>2 free passes to the conference</li>\r\n                                            <li>Print advertisement on conference directory (Full page)</li>\r\n                                            <li>Logo display on conference website homepage with hyperlink to your\r\n                                                company website </li>\r\n                                            <li>Logo printing on 2 banners </li>\r\n                                            <li>Free 1 VIP Table </li>\r\n                                            <!-- <li>Free 1 VIP Table </li> -->\r\n                                        </ul>', 1, NULL, '2020-01-27 08:07:02', '2020-01-27 08:07:02'),
(3, 'Silver Package', 4000, 1, 3, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition on the speech of the RW Solutions\' Founder during the\r\n                                                opening\r\n                                                ceremony </li>\r\n                                            <li>2 free passes to the conference </li>\r\n                                            <li>Print advertisement on conference directory (Half page)</li>\r\n                                            <li> Logo display on conference website homepage with hyperlink to your\r\n                                                company\r\n                                                website</li>\r\n                                            <li> Logo printing on 1 banner </li>\r\n                                            <li>Free 1 VIP Table </li>\r\n                                        </ul>', 2, NULL, '2020-01-27 08:07:02', '2020-01-27 08:07:02'),
(4, 'Lanyard Sponsorship', 3000, 1, 1, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition on the speech of the RW Solutions\' Founder during the\r\n                                                opening\r\n                                                ceremony</li>\r\n                                            <li>Print advertisement on conference directory (Full Page)</li>\r\n                                            <li>Logo display on conference website homepage with hyperlink to your\r\n                                                company\r\n                                                website</li>\r\n                                            <li>Logo printing on the badge lanyard </li>\r\n                                        </ul>', 3, NULL, '2020-01-27 08:11:05', '2020-01-27 08:11:05'),
(5, 'Conference Portfolio Sponsorship', 2500, 1, 1, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition on the speech of the RW Solutions\' Founder during the\r\n                                                opening\r\n                                                ceremony</li>\r\n                                            <li>Print advertisement on conference directory (Full Page)</li>\r\n                                            <li>Logo display on conference website homepage with hyperlink to your\r\n                                                company\r\n                                                website</li>\r\n                                            <li>Logo printing on the conference portfolio</li>\r\n                                        </ul>', 4, NULL, '2020-01-27 08:11:05', '2020-01-27 08:11:05'),
(6, 'Welcome Cocktail Sponsorship', 2500, 1, 1, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li> Recognition on the speech of the RW Solutions\' Founder during the\r\n                                                opening\r\n                                                ceremony </li>\r\n                                            <li>Print advertisement on conference directory (Half page) </li>\r\n                                            <li>Logo display on conference website homepage with hyperlink to your\r\n                                                company\r\n                                                website</li>\r\n                                            <li>Logo printing on 2 banners which will be displayed on the welcome\r\n                                                cocktail venue\r\n                                            </li>\r\n                                        </ul>', 5, NULL, '2020-01-27 08:11:05', '2020-01-27 08:11:05'),
(7, 'Shirt Sponsorship', 2500, 1, 1, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition on the speech of the RW Solutions\' Founder during the\r\n                                                opening\r\n                                                ceremony</li>\r\n                                            <li>Print advertisement on conference booklet (Full Page)</li>\r\n                                            <li>Logo placement on conference website with a link to your website</li>\r\n                                            <li>Logo printing on the conference shirts </li>\r\n                                        </ul>', 6, NULL, '2020-01-27 08:11:05', '2020-01-27 08:11:05'),
(8, 'Sunset Cocktail Sponsorship', 2000, 1, 1, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition on the speech of the RW Solutions\' Founder during the\r\n                                                opening\r\n                                                ceremony</li>\r\n                                            <li>Print advertisement on conference directory (Half Page)</li>\r\n                                            <li>Logo placement on conference website with a link to company website</li>\r\n                                            <li>Logo printing on 2 banners which will be displayed on the sunset\r\n                                                cocktail\r\n                                                venue.\r\n                                            </li>\r\n                                        </ul>', 7, NULL, '2020-01-27 08:11:05', '2020-01-27 08:11:05'),
(9, 'Pen Sponsorship', 1500, 1, 1, '<ul style=\"list-style:disc; margin-left:10px;\">\r\n                                            <li>Recognition on the speech of the RW Solutions\' Founder during the\r\n                                                opening\r\n                                                ceremony</li>\r\n                                            <li> Print advertisement on conference directory (Full page)</li>\r\n                                            <li>Logo display on conference website homepage with hyperlink to your\r\n                                                company\r\n                                                website</li>\r\n                                            <li>Logo printing on the conference pen</li>\r\n                                        </ul>', 8, NULL, '2020-01-27 08:11:05', '2020-01-27 08:11:05');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `advertisements`
--
ALTER TABLE `advertisements`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `agendas`
--
ALTER TABLE `agendas`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `days`
--
ALTER TABLE `days`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `emails`
--
ALTER TABLE `emails`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `member__advertisements`
--
ALTER TABLE `member__advertisements`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `member__dietaries`
--
ALTER TABLE `member__dietaries`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `member__services`
--
ALTER TABLE `member__services`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `member__softwares`
--
ALTER TABLE `member__softwares`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `member__specializations`
--
ALTER TABLE `member__specializations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `member__sponsorships`
--
ALTER TABLE `member__sponsorships`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `networks`
--
ALTER TABLE `networks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `registrations`
--
ALTER TABLE `registrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `software`
--
ALTER TABLE `software`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `specializations`
--
ALTER TABLE `specializations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `sponsorships`
--
ALTER TABLE `sponsorships`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
COMMIT;

