-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3307
-- Generation Time: Jul 08, 2020 at 09:26 PM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.3.9

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: `another_shop`
--

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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);

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

--
-- 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(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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
('170576019aaf2b6a607b67c81c453e6e97beadd464d15c9148526beff1e3f5b2b266c3c6aed9dec0', 12, 1, 'MyApp', '[]', 0, '2020-07-07 13:01:27', '2020-07-07 13:01:27', '2021-07-07 18:01:27'),
('4136f2ed694bc8ebd1edcc10467aa835dc0bdb5b0881ddf5c533ab14c223d3be13f214a66836ede8', 10, 1, 'MyApp', '[]', 0, '2020-07-07 12:26:20', '2020-07-07 12:26:20', '2021-07-07 17:26:20'),
('445ddf8aface78534bf6f3b0e809e8eb13d57cbd14041e2debf083ebf3c52e6d7a407e06b1c3ed00', 4, 1, 'MyApp', '[]', 0, '2020-07-07 11:34:14', '2020-07-07 11:34:14', '2021-07-07 16:34:14'),
('4b0e15150c24854580ac3dbb6f093090c54e39b17a1a7ae8ad50438d5af74161e54852f9ec916acc', 13, 1, 'MyApp', '[]', 0, '2020-07-07 13:36:09', '2020-07-07 13:36:09', '2021-07-07 18:36:09'),
('4c5f7b8c3a08bdfd4fb56be56b70ee746d21f5d64e6991edb9af11ee8d84bf151ef414e3b2f9f1c0', 13, 1, 'MyApp', '[]', 0, '2020-07-07 13:35:50', '2020-07-07 13:35:50', '2021-07-07 18:35:50'),
('5316c2bdbb079f478eb4108678636bb7d13f936c61fc29551fc03503f1e1541c27a7aa6873f49c51', 8, 1, 'MyApp', '[]', 0, '2020-07-07 12:15:56', '2020-07-07 12:15:56', '2021-07-07 17:15:56'),
('5581adebbc19c4c6c794afac76e51abbe3e922780357c4c457f2f5795dfab2274f093b72ff361334', 4, 1, 'MyApp', '[]', 0, '2020-07-07 11:34:59', '2020-07-07 11:34:59', '2021-07-07 16:34:59'),
('576cba37a331986b5f55ca7eefbeb97566ae04aa163f20f5fb6428a10e237d4846e71e72bb64b08a', 4, 1, 'MyApp', '[]', 0, '2020-07-07 11:33:10', '2020-07-07 11:33:10', '2021-07-07 16:33:10'),
('57f1ab00849f14ae57735fbe09688d1d676d0e6dc3811f8af2bc8f602218c622ec53af4dedc523c5', 13, 1, 'MyApp', '[]', 0, '2020-07-07 13:31:39', '2020-07-07 13:31:39', '2021-07-07 18:31:39'),
('86d22625c04f008d51ccf2b24af5e6c93f783b5fa2de6be4668d3e2c0c158cade69fcc59af6389ee', 7, 1, 'MyApp', '[]', 0, '2020-07-07 11:38:42', '2020-07-07 11:38:42', '2021-07-07 16:38:42'),
('93636dce733eeaaf017b01f8ea8549e5a17c65ffba038d4ec064ac39be88028180d62175a67fbb01', 11, 1, 'MyApp', '[]', 0, '2020-07-07 13:00:49', '2020-07-07 13:00:49', '2021-07-07 18:00:49'),
('bb3981bc6e5e7270351f6abbe6529d4e2c514c75f199a79b738ff8da893446833d8a4ca2048b54f2', 5, 1, 'MyApp', '[]', 0, '2020-07-07 11:37:46', '2020-07-07 11:37:46', '2021-07-07 16:37:46'),
('c4ba36e35da58eec14c6a50da06e4c0e71bc4b67a2b06bf51d516ff8762e7c29f2ee5d2324be43cf', 19, 1, 'MyApp', '[]', 0, '2020-07-07 13:56:15', '2020-07-07 13:56:15', '2021-07-07 18:56:15'),
('d8fb42244f6715b83e7461ba2a517a3464f19ef4c509298f76c938828dc4757e0be057707fc017a4', 9, 1, 'MyApp', '[]', 0, '2020-07-07 12:25:17', '2020-07-07 12:25:17', '2021-07-07 17:25:17'),
('e2ee3808cdf685b6642020172ee834e9edea7b79f1bf9d4b172b3af18ce4fb3435dba3e312431beb', 13, 1, 'MyApp', '[]', 0, '2020-07-08 10:31:32', '2020-07-08 10:31:32', '2021-07-08 15:31:32'),
('edc23c71435970091cfc291b0af4856d4bc1ac91baff47578f5f3cddf58372cb80383377ff2b8e1c', 8, 1, 'MyApp', '[]', 0, '2020-07-07 12:16:57', '2020-07-07 12:16:57', '2021-07-07 17:16:57'),
('f49f57a6c390501fb1f7d5bced66f8f3d11e36482c63de07fc210494f2a4f1dbad18e433571ca8ec', 4, 1, 'MyApp', '[]', 0, '2020-07-07 11:35:08', '2020-07-07 11:35:08', '2021-07-07 16:35:08');

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

--
-- 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 DEFAULT NULL,
  `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(255) 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', 'PUOR7Znc1gT9sQIdN357SspAU3SO3RcQ7i0rShwR', 'http://localhost', 1, 0, 0, '2020-07-07 11:32:35', '2020-07-07 11:32:35'),
(2, NULL, 'Laravel Password Grant Client', 'TYBpxEZh3JTLm2mhSYFc1mvVO7QZLsGH1ifNBIUa', 'http://localhost', 0, 1, 0, '2020-07-07 11:32:35', '2020-07-07 11:32:35');

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

--
-- 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, '2020-07-07 11:32:35', '2020-07-07 11:32:35');

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

--
-- 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 `order`
--

CREATE TABLE `order` (
  `id` int(11) NOT NULL,
  `shop_type` int(11) DEFAULT NULL,
  `text` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `voice_note` varchar(500) DEFAULT NULL,
  `created_at` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_at` timestamp(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `order`
--

INSERT INTO `order` (`id`, `shop_type`, `text`, `user_id`, `image`, `voice_note`, `created_at`, `updated_at`) VALUES
(51, 2, 'asd', 1, '1594227455.PNG', '1594227455.PNG', '2020-07-08 17:00:54.705392', '2020-07-08 17:00:54.705392'),
(52, 1, 'ass', 1, '1594227576.PNG', '1594227576.PNG', '2020-07-08 17:00:54.705392', '2020-07-08 17:00:54.705392'),
(53, 1, 'ass', 1, '1594227663.PNG', '1594227663.PNG', '2020-07-08 12:01:03.000000', '2020-07-08 12:01:03.000000'),
(54, 1, NULL, 1, '1594227677.PNG', NULL, '2020-07-08 12:01:17.000000', '2020-07-08 12:01:17.000000'),
(55, 2, 'my order is grocery', 1, '1594232391.png', '1594232391.ogv', '2020-07-08 18:19:51.739189', '2020-07-08 18:19:51.739189'),
(56, 2, 'asdasd', 20, '1594232836.jpg', '1594232836.ogv', '2020-07-08 18:27:16.502439', '2020-07-08 18:27:16.502439'),
(57, 2, 'asdsd', 1, '1594233041.jpg', '1594233041.ogv', '2020-07-08 18:30:41.122951', '2020-07-08 18:30:41.122951');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) 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 `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_verified` int(6) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `approve` int(2) NOT NULL DEFAULT 0,
  `address` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` decimal(8,6) DEFAULT NULL,
  `log` decimal(9,6) 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`, `name`, `email`, `mobile_verified`, `email_verified_at`, `password`, `mobile_no`, `approve`, `address`, `lat`, `log`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'raja', 'raja@gmail.com', NULL, NULL, '$2y$10$pY35lP0MeCijiUo2/PirF.oTmz81DWeqi7W58GT.tLwAv2.8AMgNq', '02145214784', 0, NULL, NULL, NULL, NULL, '2020-07-07 11:31:04', '2020-07-07 11:31:04'),
(2, 'sss', 'aa@gmail.com', NULL, NULL, '$2y$10$TXO01SPgXk9..SWQbdzx4e58dOe7Kyo5wcbGLWDdfQM2pnbwttRZe', '03214512547', 0, NULL, NULL, NULL, NULL, '2020-07-07 11:31:46', '2020-07-07 11:31:46'),
(4, 'sss', 'tt@gmail.com', NULL, NULL, '$2y$10$03OUSo5HMGGHLvJ451S00ONI266/FbzZ4EjKbxMgr326ALJRPkgzG', '03214512547', 0, NULL, NULL, NULL, NULL, '2020-07-07 11:33:10', '2020-07-07 11:33:10'),
(13, 'arsalan', 'rarsalan0@gmail.com', 1019, NULL, '$2y$10$weE7QErHsA/OxD/SBGGDUu1ZCTAuYsdiYMEcHC1uwmLr6OlZTMimu', '923463339814', 1, NULL, NULL, NULL, NULL, '2020-07-07 13:31:38', '2020-07-07 13:32:23'),
(14, 'arsalan', 'raaaarsalana0@gmail.com', 1015, NULL, '$2y$10$rrx0IBuXFOp2O7Hg9MbvteZKaqhmNlH6WoILB5UO0QP6ANvD2x.K6', '03463339814', 0, NULL, NULL, NULL, NULL, '2020-07-07 13:45:59', '2020-07-07 13:45:59'),
(15, 'arsalan', 'raaaarsalanaa0@gmail.com', 1021, NULL, '$2y$10$jGxvcAIQaXU69EkL97LFCu2F1yIdO5bJwev7IFVdlCXkxoZoCHRx2', '03463339814', 0, NULL, NULL, NULL, NULL, '2020-07-07 13:46:20', '2020-07-07 13:46:20'),
(16, 'arsalan', 'raaaarsalanasssa0@gmail.com', 1017, NULL, '$2y$10$tO9XDgReTVXgh/7MC7jYAeTaVTJN5uR4S.2wrSVCPMJWSdBQp1Wr.', '923463339814', 0, NULL, NULL, NULL, NULL, '2020-07-07 13:55:01', '2020-07-07 13:55:01'),
(18, 'arsalan', 'raaaarsalanassssa0@gmail.com', 1017, NULL, '$2y$10$bVoFPGJZiXV7aRWMNcG1MuP9NOODtZuyg7OFVZGk6UBgS9mxt5BcO', '923463339814', 0, NULL, NULL, NULL, NULL, '2020-07-07 13:55:33', '2020-07-07 13:55:33'),
(19, 'arsalan', 'raaaarsalanassssaaa0@gmail.com', 1021, NULL, '$2y$10$RROh7xmxF4HnKjU01QY8T.uQvHmpCb2qQAcodp26Ay4FE5OReXgGa', '923463339814', 0, NULL, NULL, NULL, NULL, '2020-07-07 13:56:14', '2020-07-07 13:56:14'),
(20, 'ra', 'arsalan@gmail.com', NULL, NULL, '$2y$10$b78FSC1qRzzBdTMqAQ7vU.iul5hoQnrhPtG/D5aVL4RVH6zWit8zu', NULL, 0, NULL, NULL, NULL, NULL, '2020-07-08 10:21:39', '2020-07-08 10:21:39'),
(21, NULL, 'demo@gmail.com', 1014, NULL, '$2y$10$2w6P1FDf8DY20Bri6qdosO0bhyMDcSu0eWJnA/ArMH/L0HkZesBwK', '923651425147', 0, NULL, '20.593681', '20.593682', NULL, '2020-07-08 11:49:42', '2020-07-08 14:16:56'),
(22, NULL, 'testing@gmail.com', 1014, NULL, '$2y$10$vrIVmsXjj0Ki0jd2J3ghz.dqJ7BiONlPfTpSrIs/FoFlmiwAXS28K', '923654784574', 0, 'gulshan iqbal', '20.593681', '20.593682', NULL, '2020-07-08 12:53:34', '2020-07-08 14:26:05');

--
-- 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 `order`
--
ALTER TABLE `order`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- 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=8;

--
-- 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 `order`
--
ALTER TABLE `order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
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 */;
