text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Generation Time: Mar 24, 2022 at 11:55 PM
  -- Server version: 5.7.24
  -- PHP Version: 7.4.27
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `8_db_shortner_url`
  --
  
  -- --------------------------------------------------------
  
  --
  -- 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, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
  (4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
  (5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
  (6, '2016_06_01_000004_create_oauth_clients_table', 1),
  (7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
  (8, '2022_03_23_015145_create_shortner_urls_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_access_tokens`
  --
  
  CREATE TABLE `oauth_access_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) DEFAULT NULL,
    `client_id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `oauth_access_tokens`
  --
  
  INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
  ('a7606ad364d30288a3f8b4b891a88c722c41449b1d5b9eb5faa2429d544d6b7e800b5468542651ff', 1, 1, 'Laravel Password Grant Client', '[]', 0, '2022-03-24 11:38:44', '2022-03-24 11:38:44', '2023-03-24 17:38:44');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_auth_codes`
  --
  
  CREATE TABLE `oauth_auth_codes` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) NOT NULL,
    `client_id` int(10) UNSIGNED NOT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_clients`
  --
  
  CREATE TABLE `oauth_clients` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` bigint(20) DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `personal_access_client` tinyint(1) NOT NULL,
    `password_client` tinyint(1) NOT NULL,
    `revoked` tinyint(1) 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 `oauth_clients`
  --
  
  INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
  (1, NULL, 'Laravel Personal Access Client', 'RDw9GVhW9qO4u86sh1NgwhiGb15p7hvwOvzm4VkP', 'http://localhost', 1, 0, 0, '2022-03-24 11:37:25', '2022-03-24 11:37:25'),
  (2, NULL, 'Laravel Password Grant Client', '41E7lLsXyxn7xsXx2KV84HhOnYSQ6X4mpZc4N9kI', 'http://localhost', 0, 1, 0, '2022-03-24 11:37:25', '2022-03-24 11:37:25');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_personal_access_clients`
  --
  
  CREATE TABLE `oauth_personal_access_clients` (
    `id` int(10) UNSIGNED NOT NULL,
    `client_id` int(10) UNSIGNED 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 `oauth_personal_access_clients`
  --
  
  INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
  (1, 1, '2022-03-24 11:37:25', '2022-03-24 11:37:25');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `oauth_refresh_tokens`
  --
  
  CREATE TABLE `oauth_refresh_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- 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;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `shortner_urls`
  --
  
  CREATE TABLE `shortner_urls` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `userid` int(11) NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `shortlink` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `fulllink` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `visiteParMin` int(11) NOT NULL,
    `ipBlockTime` int(11) 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 `shortner_urls`
  --
  
  INSERT INTO `shortner_urls` (`id`, `userid`, `code`, `shortlink`, `fulllink`, `visiteParMin`, `ipBlockTime`, `created_at`, `updated_at`) VALUES
  (1, 1, '03cFyG', 'http://127.0.0.1:8000/03cFyG', 'https://laravel.com/docs/5.8/passport#main-content', 2, 2, '2022-03-24 11:39:03', '2022-03-24 11:39:03'),
  (2, 1, '15XQkt', 'http://127.0.0.1:8000/15XQkt', 'https://www.itsolutionstuff.com/post/how-to-create-url-shortener-using-laravelexample.html', 1, 3, '2022-03-24 11:39:15', '2022-03-24 11:39:22'),
  (3, 1, '375WKB', 'http://127.0.0.1:8000/375WKB', 'https://www.itsolutionstuff.com/post/how-to-create-url-shortener-using-laravelexample.html', 2, 4, '2022-03-24 11:39:37', '2022-03-24 11:39:37'),
  (4, 1, '57X27r', 'http://127.0.0.1:8000/57X27r', 'https://www.google.com/search?client=firefox-b-d&q=google+trans', 60, 3, '2022-03-24 11:40:57', '2022-03-24 11:47:57'),
  (5, 1, '09bGAO', 'http://127.0.0.1:8000/09bGAO', 'https://www.google.com/search?client=firefox-b-d&q=google+trans', 2, 2, '2022-03-24 11:46:09', '2022-03-24 11:46:09');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `firstname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `lastname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `userStatusId` int(11) NOT NULL DEFAULT '1' COMMENT '1=active,2=pending,3=successpend',
    `ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `present_address` text COLLATE utf8mb4_unicode_ci,
    `shipping_address` text COLLATE utf8mb4_unicode_ci,
    `user_role` int(11) NOT NULL DEFAULT '1' COMMENT '1=user,2=admin',
    `email_verified_at` timestamp NULL DEFAULT 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`, `firstname`, `lastname`, `username`, `email`, `password`, `image`, `phone_no`, `userStatusId`, `ip_address`, `present_address`, `shipping_address`, `user_role`, `email_verified_at`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'Nuruzzaman', 'Himel', 'Nuruzzaman285', 'nuruzzaman.himel147@gmail.com', '$2y$10$jNm6o5yVbRFqAvzr3NHdGeh13FYlocypNkO2hhc60nNt1iYA/1YCW', 'Nuruzzaman_685137540.jpeg', '01622819929', 1, '127.0.0.1', 'dhaka', NULL, 1, NULL, NULL, '2022-03-24 11:38:39', '2022-03-24 11:38:39');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `oauth_access_tokens`
  --
  ALTER TABLE `oauth_access_tokens`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);
  
  --
  -- Indexes for table `oauth_auth_codes`
  --
  ALTER TABLE `oauth_auth_codes`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `oauth_clients`
  --
  ALTER TABLE `oauth_clients`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_clients_user_id_index` (`user_id`);
  
  --
  -- Indexes for table `oauth_personal_access_clients`
  --
  ALTER TABLE `oauth_personal_access_clients`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);
  
  --
  -- Indexes for table `oauth_refresh_tokens`
  --
  ALTER TABLE `oauth_refresh_tokens`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indexes for table `shortner_urls`
  --
  ALTER TABLE `shortner_urls`
    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 `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT for table `oauth_clients`
  --
  ALTER TABLE `oauth_clients`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `oauth_personal_access_clients`
  --
  ALTER TABLE `oauth_personal_access_clients`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `shortner_urls`
  --
  ALTER TABLE `shortner_urls`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) 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 */;
  