-- phpMyAdmin SQL Dump -- version 4.8.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jul 04, 2019 at 02:45 AM -- Server version: 10.1.32-MariaDB -- PHP Version: 7.2.5 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `adkgroup` -- -- -------------------------------------------------------- -- -- Table structure for table `downloads` -- CREATE TABLE `downloads` ( `id` bigint(20) UNSIGNED NOT NULL, `dl_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `dl_file_url` text COLLATE utf8mb4_unicode_ci NOT NULL, `dl_show` 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 `downloads` -- INSERT INTO `downloads` (`id`, `dl_name`, `dl_file_url`, `dl_show`, `created_at`, `updated_at`) VALUES (1, 'Sample Document 1', 'uploads/downloads/1553285872arctic-fire-1068x652.jpg', 0, '2019-03-22 15:17:52', '2019-03-22 15:22:25'); -- -------------------------------------------------------- -- -- 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_03_20_081543_create_downloads_table', 1), (4, '2019_03_21_132754_create_subscriptions_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_resets` -- INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('admin@adkgroup.com', '$2y$10$enjKF4S8gHjZXPj1ZWDU8uUENwtO0a6jORz7Fcrwymj1r02a7OVPK', '2019-03-22 15:15:23'); -- -------------------------------------------------------- -- -- 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-03-22 15:32:48', '2019-03-22 15:32:48'), (2, 'test@e.com', 1, '2019-03-22 15:37:41', '2019-03-22 15:37:41'), (3, 'check@demo.com', 1, '2019-03-22 15:43:36', '2019-03-22 15:43:36'), (4, 'mcloyd@test.com', 1, '2019-03-22 15:43:45', '2019-03-22 15:43:45'), (5, 'test@demo.com', 1, '2019-03-22 15:43:58', '2019-03-22 15:43:58'), (6, 'a.humeidh@gmail.com', 1, '2019-03-22 15:44:17', '2019-03-22 15:44:17'), (7, 'chaka@ecc.com', 1, '2019-03-23 02:16:13', '2019-03-23 02:16:13'), (8, 'vvv@vv.com', 1, '2019-03-23 03:15:47', '2019-03-23 03:15:47'), (9, 'tttt@tit.com', 1, '2019-03-23 03:19:11', '2019-03-23 03:19:11'), (10, 'valujinni@shimjin.com', 1, '2019-03-23 03:29:22', '2019-03-23 03:29:22'), (11, 'santhi@sun.com', 1, '2019-03-23 03:38:22', '2019-03-23 03:38:22'), (12, 'sdfgsdfsdf@ggg.com', 1, '2019-03-23 10:24:31', '2019-03-23 10:24:31'), (13, 'azza@a.com', 1, '2019-06-12 03:01:56', '2019-06-12 03:01:56'), (14, 'someonenew@new.com', 1, '2019-07-03 19:36:14', '2019-07-03 19:36:14'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 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 `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin@adkgroup.com', NULL, '$2y$10$YTjE9b2.urnj8VGuIxwBl.6GW44/IYJ184WRyVIKzolIQcnak7brW', NULL, '2019-03-22 11:58:36', '2019-03-22 11:58:36'); -- -- Indexes for dumped tables -- -- -- Indexes for table `downloads` -- ALTER TABLE `downloads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `downloads` -- ALTER TABLE `downloads` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;