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

START TRANSACTION;



--
-- Database: `connectionhub2`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id` int(11) NOT NULL,
  `details` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `details`) VALUES
(1, '<p>Lots of companies say they care about their customers. We want ConnectionHub customers to feel it. Every customer. Every day. At ConnectionHub, we have big ambitions about what we can become, and we know this goal will only be achieved when &quot;business as usual&quot; is transformed into a new standard of caring for our customers. The opportunity to serve our customers is more than a transaction to us. It&#39;s an interaction. So, in 2019, we&#39;re looking at every aspect of our business to ensure that we keep our customers&#39; best interests at the heart of everything we do. We&#39;ve already taken steps to deliver on our commitment to caring customer service: &ldquo;ConnectionHub- Ambition Counts&rdquo;</p>');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `fullname` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `fullname`, `phone`, `email`, `message`, `date_time`) VALUES
(1, 'Sharif Khan', '01763788679', 'zhasan04000000@gmail.com', 'N/A', '2020-02-10 20:14:48'),
(2, 'Zahid Hasan', '01763788679', 'musicfree267@gmail.com', '4wer', '2020-02-10 20:16:02'),
(3, 'Zahid', '01874420990', 'musicfree2671@gmail.com', 'n/a', '2020-02-10 20:19:09');

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

--
-- Table structure for table `footer`
--

CREATE TABLE `footer` (
  `id` int(11) NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `footer`
--

INSERT INTO `footer` (`id`, `country`, `phone`, `email`, `address`) VALUES
(1, 'Canada', '+1 587 501 5363', 'info@connectionhub.ca', '<p>3-2820 116 Street NW</p>\r\n\r\n<p>Edmonton, AB&nbsp;</p>\r\n\r\n<p>T6J 4G2<br />\r\nCanada.</p>'),
(2, 'Bangladesh', '+880 1911-254307', 'info@connectionhub.ca', '<p>Avenue-1; Road-1, House-146 (3rd floor),</p>\r\n\r\n<p>Mirpur DOHS, Dhaka-1216</p>');

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

--
-- Table structure for table `fos_user__group`
--

CREATE TABLE `fos_user__group` (
  `id` int(11) NOT NULL,
  `name` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `fos_user__user_group`
--

CREATE TABLE `fos_user__user_group` (
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migration_versions`
--

CREATE TABLE `migration_versions` (
  `version` varchar(14) COLLATE utf8mb4_unicode_ci NOT NULL,
  `executed_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migration_versions`
--

INSERT INTO `migration_versions` (`version`, `executed_at`) VALUES
('20200121074546', '2020-01-21 07:45:49'),
('20200121110534', '2020-01-21 11:05:39'),
('20200121111207', '2020-01-21 11:12:10'),
('20200121114958', '2020-01-21 11:50:08'),
('20200227185508', '2020-02-27 18:55:15');

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `id` int(11) NOT NULL,
  `title` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `services_overview`
--

CREATE TABLE `services_overview` (
  `id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_overview` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enable` tinyint(1) NOT NULL,
  `image_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services_overview`
--

INSERT INTO `services_overview` (`id`, `type`, `service_overview`, `enable`, `image_name`, `created_at`, `updated_at`) VALUES
(1, 'boat_supply', 'We can supply any type of boat as per your requirements. Just knock us and see how we meet your requirements.', 1, '5e5d2803e538a_boat.jpg', '0000-00-00 00:00:00', '2020-03-02 16:36:35'),
(2, 'export_import', 'We act as an “One Stop Solution” for any of your Import-Export business. With head office at Canada and branches at UK, Finland, Dubai and Bangladesh, we ensure a smooth Import-Export of your goods around the world. For a safe and fast transportation, you can trust Connection Hub.', 1, '5e5d28baa4d0b_export-import.jpeg', '0000-00-00 00:00:00', '2020-03-02 16:39:38'),
(3, 'marine_engine_supply', 'We have the most complete and modern engine supplier connection in Canada. We can link and supply the complete marine gas and diesel engine for Domestic and International use.', 1, '5e5d28dfa1bda_marinEngine.png', '0000-00-00 00:00:00', '2020-03-02 16:40:15'),
(4, 'marine_parts_supply', 'Connection Hub Marine Parts assure the Best price guaranteed! Call us or email us and we will price match or beat any price! We can connect the best supplier for quality marine engine parts and accessories worldwide.', 1, '5e5d28e5c3005_marineparts.jpg', '0000-00-00 00:00:00', '2020-03-02 16:40:21'),
(5, 'about', 'Lots of companies say they care about their customers. We want ConnectionHub customers to feel it. Every customer. Every day. At ConnectionHub, we have big ambitions about what we can become, and we know this goal will only be achieved when \"business as usual\" is transformed into a new standard of caring for our customers. The opportunity to serve our customers is more than a transaction to us. It\'s an interaction. So, in 2019, we\'re looking at every aspect of our business to ensure that we keep our customers\' best interests at the heart of everything we do. We\'ve already taken steps to deliver on our commitment to caring customer service: “ConnectionHub- Ambition Counts”', 1, '5e5d2a0a373ec_connection.jpg', '2020-03-02 21:45:14', '2020-03-02 21:45:14');

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

--
-- Table structure for table `services_product`
--

CREATE TABLE `services_product` (
  `id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_align` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `more_details` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `enable` tinyint(1) NOT NULL,
  `specifications` varchar(10000) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services_product`
--

INSERT INTO `services_product` (`id`, `type`, `name`, `description`, `img_align`, `image_name`, `more_details`, `created_at`, `updated_at`, `enable`, `specifications`) VALUES
(1, 'boat_supply', 'We love our boat as much as you..', 'We can supply any type of boat as per your requirements. Just knock us and see how we meet your requirements.', 'left', '5e5d1ef95ebe4_boat.jpg', NULL, '2020-03-02 20:58:01', '2020-03-02 20:58:01', 1, '<p>N/A</p>'),
(2, 'export_import', 'Export Import', 'We act as an “One Stop Solution” for any of your Import-Export business. With head office at Canada and branches at UK, Finland, Dubai and Bangladesh, we ensure a smooth Import-Export of your goods around the world. For a safe and fast transportation, you can trust Connection Hub.', 'left', '5e5d222c14174_export-import.jpeg', NULL, '2020-03-02 21:11:39', '2020-03-02 21:11:40', 1, NULL),
(3, 'marine_engine_supply', 'Marine Engine Supply', 'We have the most complete and modern engine supplier connection in Canada. We can link and supply the complete marine gas and diesel engine for Domestic and International use.', 'left', '5e5d227bc4d76_marinEngine.png', NULL, '2020-03-02 21:12:59', '2020-03-02 21:12:59', 1, NULL),
(4, 'marine_parts_supply', 'Marine Parts Supply', 'Connection Hub Marine Parts assure the Best price guaranteed! Call us or email us and we will price match or beat any price! We can connect the best supplier for quality marine engine parts and accessories worldwide.', 'left', '5e5d232cae689_marineparts.jpg', NULL, '2020-03-02 21:15:56', '2020-03-02 21:15:56', 1, NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `fos_user__group`
--
ALTER TABLE `fos_user__group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_CDA27E965E237E06` (`name`);

--
-- Indexes for table `fos_user__user_group`
--
ALTER TABLE `fos_user__user_group`
  ADD PRIMARY KEY (`user_id`,`group_id`),
  ADD KEY `IDX_8A73B1E4A76ED395` (`user_id`),
  ADD KEY `IDX_8A73B1E4FE54D947` (`group_id`);

--
-- Indexes for table `migration_versions`
--
ALTER TABLE `migration_versions`
  ADD PRIMARY KEY (`version`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `fos_user__user_group`
--
ALTER TABLE `fos_user__user_group`
  ADD CONSTRAINT `FK_8A73B1E4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `fos_user_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_8A73B1E4FE54D947` FOREIGN KEY (`group_id`) REFERENCES `fos_user__group` (`id`) ON DELETE CASCADE;
COMMIT;

