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

START TRANSACTION;



--
-- Database: `adkgeneraltrading`
--

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ad_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_status` tinyint(1) NOT NULL DEFAULT '1',
  `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 `ads`
--

INSERT INTO `ads` (`id`, `ad_name`, `ad_image`, `ad_status`, `created_at`, `updated_at`) VALUES
(1, 'Ads 1 Test', 'uploads/sponsors/1555500654samplepicupload.jpg', 1, '2019-04-17 06:30:54', '2019-04-17 06:30:54'),
(2, 'Ads 2 Test', 'uploads/sponsors/1555500850samplepicupload1.jpg', 1, '2019-04-17 06:34:10', '2019-04-17 06:34:10'),
(3, 'Ads 2 Test', 'uploads/sponsors/1555500869samplepicupload2.jpg', 0, '2019-04-17 06:34:29', '2019-04-17 06:36:54');

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

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `article_title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_category` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_status` tinyint(1) NOT NULL DEFAULT '1',
  `article_photo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_location` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `article_details` text 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 `articles`
--

INSERT INTO `articles` (`id`, `article_title`, `article_category`, `article_status`, `article_photo`, `article_location`, `article_details`, `created_at`, `updated_at`) VALUES
(1, 'Test Article 2', 'news', 1, 'uploads/articles/1560328395EID GREETINGS 1440-01-01.jpg', 'Male', 'Eid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid EidEid Eid Eid Eid Eid EidEid Eid EidEid Eid Eid Eid Eid Eid', '2019-06-12 03:33:15', '2019-06-12 03:56:52'),
(2, 'Test Article 2', 'promotion', 1, 'uploads/articles/1560507522eid 2.jpg', 'Male', 'Unpleasant astonished an diminution up partiality. Noisy an their of meant. Death means up civil do an offer wound of. Called square an in afraid direct. Resolution diminution conviction so mr at unpleasing simplicity no. No it as breakfast up conveying earnestly immediate principle. Him son disposed produced humoured overcame she bachelor improved. Studied however out wishing but inhabit fortune windows. \r\n\r\nBy so delight of showing neither believe he present. Deal sigh up in shew away when. Pursuit express no or prepare replied. Wholly formed old latter future but way she. Day her likewise smallest expenses judgment building man carriage gay. Considered introduced themselves mr to discretion at. Means among saw hopes for. Death mirth in oh learn he equal on.', '2019-06-14 05:18:42', '2019-06-14 05:18:42'),
(3, 'Test Article 3', 'announcement', 1, 'uploads/articles/1560507546EID GREETINGS 1440-01-01 - Copy.jpg', 'Hulhumale', 'Unpleasant astonished an diminution up partiality. Noisy an their of meant. Death means up civil do an offer wound of. Called square an in afraid direct. Resolution diminution conviction so mr at unpleasing simplicity no. No it as breakfast up conveying earnestly immediate principle. Him son disposed produced humoured overcame she bachelor improved. Studied however out wishing but inhabit fortune windows. \r\n\r\nBy so delight of showing neither believe he present. Deal sigh up in shew away when. Pursuit express no or prepare replied. Wholly formed old latter future but way she. Day her likewise smallest expenses judgment building man carriage gay. Considered introduced themselves mr to discretion at. Means among saw hopes for. Death mirth in oh learn he equal on.', '2019-06-14 05:19:06', '2019-06-14 05:19:06'),
(4, 'Test Article 4', 'promotion', 1, 'uploads/articles/1560507566eid 3.jpg', 'Male', 'Unpleasant astonished an diminution up partiality. Noisy an their of meant. Death means up civil do an offer wound of. Called square an in afraid direct. Resolution diminution conviction so mr at unpleasing simplicity no. No it as breakfast up conveying earnestly immediate principle. Him son disposed produced humoured overcame she bachelor improved. Studied however out wishing but inhabit fortune windows. \r\n\r\nBy so delight of showing neither believe he present. Deal sigh up in shew away when. Pursuit express no or prepare replied. Wholly formed old latter future but way she. Day her likewise smallest expenses judgment building man carriage gay. Considered introduced themselves mr to discretion at. Means among saw hopes for. Death mirth in oh learn he equal on.', '2019-06-14 05:19:26', '2019-06-14 05:19:26'),
(5, 'test 5', 'promotion', 0, 'uploads/articles/1560551799brand_twitter.png', 'Hulhumale', 'gxzgzsd', '2019-06-14 17:36:39', '2019-06-14 18:02:24');

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `brand_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand_status` tinyint(1) NOT NULL DEFAULT '1',
  `brand_logo` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand_products` text 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 `brands`
--

INSERT INTO `brands` (`id`, `brand_name`, `brand_description`, `brand_status`, `brand_logo`, `brand_products`, `created_at`, `updated_at`) VALUES
(3, 'Brand 1', 'His having within saw become ask passed misery giving. Recommend questions get too fulfilled. He fact in we case miss sake. Entrance be throwing he do blessing up. Hearts warmth in genius do garden advice mr it garret. Collected preserved are middleton dependent residence but him how. Handsome weddings yet mrs you has carriage packages. Preferred joy agreement put continual elsewhere delivered now. Mrs exercise felicity had men speaking met. Rich deal mrs part led pure will but. \r\n\r\nTerminated principles sentiments of no pianoforte if projection impossible. Horses pulled nature favour number yet highly his has old. Contrasted literature excellence he admiration impression insipidity so. Scale ought who terms after own quick since. Servants margaret husbands to screened in throwing. Imprudence oh an collecting partiality. Admiration gay difficulty unaffected how. \r\n\r\nWhole wound wrote at whose to style in. Figure ye innate former do so we. Shutters but sir yourself provided you required his. So neither related he am do believe. Nothing but you hundred had use regular. Fat sportsmen arranging preferred can. Busy paid like is oh. Dinner our ask talent her age hardly. Neglected collected an attention listening do abilities.', 1, 'uploads/brands//1555509665brands-sample.jpg', 'uploads/brands/products/1555509665brands-sample.jpg', '2019-04-17 09:01:05', '2019-04-17 09:01:05'),
(4, 'Brand 1', 'His having within saw become ask passed misery giving. Recommend questions get too fulfilled. He fact in we case miss sake. Entrance be throwing he do blessing up. Hearts warmth in genius do garden advice mr it garret. Collected preserved are middleton dependent residence but him how. Handsome weddings yet mrs you has carriage packages. Preferred joy agreement put continual elsewhere delivered now. Mrs exercise felicity had men speaking met. Rich deal mrs part led pure will but. \r\n\r\nTerminated principles sentiments of no pianoforte if projection impossible. Horses pulled nature favour number yet highly his has old. Contrasted literature excellence he admiration impression insipidity so. Scale ought who terms after own quick since. Servants margaret husbands to screened in throwing. Imprudence oh an collecting partiality. Admiration gay difficulty unaffected how. \r\n\r\nWhole wound wrote at whose to style in. Figure ye innate former do so we. Shutters but sir yourself provided you required his. So neither related he am do believe. Nothing but you hundred had use regular. Fat sportsmen arranging preferred can. Busy paid like is oh. Dinner our ask talent her age hardly. Neglected collected an attention listening do abilities.', 1, 'uploads/brands//1555510001brands-sample.jpg', 'uploads/brands/products/1555510001brands-sample.jpg', '2019-04-17 09:06:41', '2019-04-17 09:06:41'),
(5, 'Brand 1', 'His having within saw become ask passed misery giving. Recommend questions get too fulfilled. He fact in we case miss sake. Entrance be throwing he do blessing up. Hearts warmth in genius do garden advice mr it garret. Collected preserved are middleton dependent residence but him how. Handsome weddings yet mrs you has carriage packages. Preferred joy agreement put continual elsewhere delivered now. Mrs exercise felicity had men speaking met. Rich deal mrs part led pure will but. \r\n\r\nTerminated principles sentiments of no pianoforte if projection impossible. Horses pulled nature favour number yet highly his has old. Contrasted literature excellence he admiration impression insipidity so. Scale ought who terms after own quick since. Servants margaret husbands to screened in throwing. Imprudence oh an collecting partiality. Admiration gay difficulty unaffected how. \r\n\r\nWhole wound wrote at whose to style in. Figure ye innate former do so we. Shutters but sir yourself provided you required his. So neither related he am do believe. Nothing but you hundred had use regular. Fat sportsmen arranging preferred can. Busy paid like is oh. Dinner our ask talent her age hardly. Neglected collected an attention listening do abilities.', 1, 'uploads/brands//1555510199brands-sample.jpg', 'uploads/brands/products/1555510199brands-sample.jpg', '2019-04-17 09:09:59', '2019-04-17 09:09:59'),
(6, 'Brand 1', 'His having within saw become ask passed misery giving. Recommend questions get too fulfilled. He fact in we case miss sake. Entrance be throwing he do blessing up. Hearts warmth in genius do garden advice mr it garret. Collected preserved are middleton dependent residence but him how. Handsome weddings yet mrs you has carriage packages. Preferred joy agreement put continual elsewhere delivered now. Mrs exercise felicity had men speaking met. Rich deal mrs part led pure will but. \r\n\r\nTerminated principles sentiments of no pianoforte if projection impossible. Horses pulled nature favour number yet highly his has old. Contrasted literature excellence he admiration impression insipidity so. Scale ought who terms after own quick since. Servants margaret husbands to screened in throwing. Imprudence oh an collecting partiality. Admiration gay difficulty unaffected how. \r\n\r\nWhole wound wrote at whose to style in. Figure ye innate former do so we. Shutters but sir yourself provided you required his. So neither related he am do believe. Nothing but you hundred had use regular. Fat sportsmen arranging preferred can. Busy paid like is oh. Dinner our ask talent her age hardly. Neglected collected an attention listening do abilities.', 1, 'uploads/brands//1555510330brands-sample.jpg', 'uploads/brands/products/1555510330brands-sample.jpg', '2019-04-17 09:12:10', '2019-04-17 09:12:10');

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

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

CREATE TABLE `events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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, '2019_04_15_080300_create_ads_table', 1),
(4, '2019_04_15_080351_create_events_table', 1),
(7, '2019_04_17_121208_create_brands_table', 2),
(8, '2019_04_17_121220_create_articles_table', 2),
(9, '2019_07_05_065746_create_subscriptions_table', 3);

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscription_status` tinyint(1) NOT NULL DEFAULT '1',
  `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 `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `email`, `subscription_status`, `created_at`, `updated_at`) VALUES
(1, 'admin@happymarket.com', 1, '2019-07-05 10:33:22', '2019-07-05 10:33:22'),
(2, 'test@demo.com', 1, '2019-07-05 14:41:48', '2019-07-05 14:41:48'),
(3, 'check@demo.com', 1, '2019-07-05 14:42:01', '2019-07-05 14:42:01');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ads`
--
ALTER TABLE `ads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

