-- 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 */;