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

START TRANSACTION;



--
-- Database: `goal_admin_laravel`
--

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `goal_master`
--

CREATE TABLE `goal_master` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `gl_u_id` int(11) NOT NULL,
  `gl_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gl_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gl_image_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gl_amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gl_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gl_target_date` date DEFAULT NULL,
  `gl_days` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gl_goal_progress` varchar(191) 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 `goal_master`
--

INSERT INTO `goal_master` (`id`, `gl_u_id`, `gl_name`, `gl_image`, `gl_image_path`, `gl_amount`, `gl_type`, `gl_target_date`, `gl_days`, `gl_goal_progress`, `created_at`, `updated_at`) VALUES
(3, 9, 'goal', '1637153996_image 3.jpg', NULL, '3000', 'archive', '2021-11-17', '5', 'pending', '2021-11-17 02:01:01', '2021-11-17 07:29:56'),
(11, 16, 'tour', '1637557192_pmv-chamara-dMjkQJs58uo-unsplash.jpg', NULL, '50000', 'true', NULL, NULL, NULL, '2021-11-21 23:29:52', NULL),
(12, 16, 'mobile', '1637557703_pmv-chamara-dMjkQJs58uo-unsplash.jpg', NULL, '50000', 'false', NULL, NULL, NULL, '2021-11-21 23:38:23', NULL),
(13, 16, 'mobile', '1637559612_pmv-chamara-dMjkQJs58uo-unsplash.jpg', NULL, '50000', 'false', NULL, NULL, NULL, '2021-11-22 00:10:12', NULL),
(14, 16, 'mobile', '1637559641_pmv-chamara-dMjkQJs58uo-unsplash.jpg', NULL, '50000', 'true', NULL, NULL, NULL, '2021-11-22 00:10:41', NULL),
(18, 16, 'mobile', '1637561455_pmv-chamara-dMjkQJs58uo-unsplash.jpg', NULL, '50000', 'archive', NULL, NULL, NULL, '2021-11-22 00:40:55', NULL),
(47, 9, 'change api goal 10', '1637582754_psl_naymar.jpg', NULL, '250', 'unarchive', '2021-11-16', '10', NULL, '2021-11-22 10:36:52', '2021-11-22 12:06:03'),
(48, 17, 'harry goal update', '1637583666_Smile.jpg', 'http://localhost:8000/goal/1637583666_Smile.jpg', '3700', 'archive', '2021-11-17', '5', 'pending', '2021-11-22 12:21:06', '2021-11-22 13:10:53');

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

--
-- 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_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2019_12_21_132456_user_groups', 1),
(6, '2020_01_16_115203_settings', 1),
(7, '2020_09_09_104216_create_webhook_calls_table', 1),
(8, '2020_12_07_115938_smtp_setting', 1),
(9, '2021_08_20_041307_create_social_master', 1),
(10, '2021_09_04_034726_create_payment_settings_master', 1),
(11, '2021_09_06_041005_create_sms_settings_master', 1),
(12, '2016_06_01_000001_create_oauth_auth_codes_table', 2),
(13, '2016_06_01_000002_create_oauth_access_tokens_table', 2),
(14, '2016_06_01_000003_create_oauth_refresh_tokens_table', 2),
(15, '2016_06_01_000004_create_oauth_clients_table', 2),
(16, '2016_06_01_000005_create_oauth_personal_access_clients_table', 2),
(17, '2021_11_16_070455_create_user_master_table', 2),
(18, '2021_11_17_053131_create_goal_master_table', 3),
(19, '2021_11_18_050252_add_user_id_to_goal_master', 4),
(20, '2021_11_18_061426_create_savings_master_table', 5),
(22, '2021_11_22_144637_add__image_path_field_to_goal_master_table', 6),
(23, '2021_11_22_170417_add_savings_date_field_to_savings_master_table', 7);

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

--
-- 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) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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
('03810a5084a03ee1a6d68b89d877f7881644d4c4024128dec8d971c38c585f97e2d7cad8a88572fb', 9, 1, 'UserToken', '[]', 0, '2021-11-21 22:58:41', '2021-11-21 22:58:41', '2022-11-22 04:28:41'),
('045b9bcfa419477cfd591fba058c783c754aaee1ca134a93459ef10a3e3ff9af6e84dacd10e9e070', 17, 1, 'UserToken', '[]', 0, '2021-11-22 12:18:31', '2021-11-22 12:18:31', '2022-11-22 17:48:31'),
('0688b2f19527950948d4a0f6146d9135e537193f5cc4873741941da28c2ad5628c97313d255516b9', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:42:40', '2021-11-16 03:42:40', '2022-11-16 09:12:40'),
('0b7adb04345c3d2580dcb6d27068e518e25feb58fc9827c29ab4ce839ec884553b9cec6b339e0ff5', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:43:00', '2021-11-16 03:43:00', '2022-11-16 09:13:00'),
('0b9d63b6e88c2af5485d0955a308c10d7afedf0cb2a087a18fb6c61f6e9c61764f8937e79c34fc1f', 9, 1, 'UserToken', '[]', 0, '2021-11-16 04:08:57', '2021-11-16 04:08:57', '2022-11-16 09:38:57'),
('17c388c98694de3cf06865635aedcc6e75838c82c43582de9aa4488b7db56081b67d8d7d7101f2ed', 1, 1, 'UserToken', '[]', 0, '2021-11-16 03:32:08', '2021-11-16 03:32:08', '2022-11-16 09:02:08'),
('1a30b5e3cffd7f369be98e384cfb0d2f8a6783ec85611b7c2bd97dde54176733401f4956d2aee009', 16, 1, 'UserToken', '[]', 0, '2021-11-21 23:08:50', '2021-11-21 23:08:50', '2022-11-22 04:38:50'),
('1de7508e9c55d6e5a8c48ee2283e1884bac5ad4b8dbd448b0dd358ae4b43e853265f880d80683d5e', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:34:57', '2021-11-16 03:34:57', '2022-11-16 09:04:57'),
('222b038898e95cc930a99abdd70c6ae825790c984128124989f43320be8909963049213444a6fdb9', 11, 1, 'UserToken', '[]', 0, '2021-11-17 01:29:03', '2021-11-17 01:29:03', '2022-11-17 06:59:03'),
('240a7386d0cd499f3b70f265080c1c4ad6e6f0d52e99fec1587fbdea63982865147c3d3073d8a528', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:44:00', '2021-11-16 03:44:00', '2022-11-16 09:14:00'),
('2c34f8deb4e45c1c11919c7c003db16f12c0b328ed9162577230a4e7c3976495a7d5f429ef182db5', 13, 1, 'UserToken', '[]', 0, '2021-11-20 00:46:21', '2021-11-20 00:46:21', '2022-11-20 06:16:21'),
('2c6ea608dda7d63864f0f4df35327550fb45502e61bc6b3f5a7b417c9d9c2ed4678c1a7cc121fc07', 9, 1, 'UserToken', '[]', 0, '2021-11-21 23:09:48', '2021-11-21 23:09:48', '2022-11-22 04:39:48'),
('3b772b5336c49eb21b633477e603b3968604ebe5a93d9e1fabc7eb849a126a91aaef3197726516d1', 1, 1, 'UserToken', '[]', 0, '2021-11-16 03:08:43', '2021-11-16 03:08:43', '2022-11-16 08:38:43'),
('3d3f94d98e4d2deeb02cafba76a55c2b341c97b8f2c3842949a37695b597c59b063d93b22b423568', 13, 1, 'UserToken', '[]', 0, '2021-11-18 06:27:54', '2021-11-18 06:27:54', '2022-11-18 11:57:54'),
('3f085398330fcc6735fde9a7fd8ffa70621da134393b98f09bdde8552de107cdbf86e45816a1f32c', 6, 1, 'UserToken', '[]', 0, '2021-11-16 04:01:41', '2021-11-16 04:01:41', '2022-11-16 09:31:41'),
('45099f25f3d59a153d274650f6b569d032b5f531553df2dafdff85e86163fc7552a35733ae0c7d89', 16, 1, 'UserToken', '[]', 1, '2021-11-21 23:10:05', '2021-11-21 23:10:05', '2022-11-22 04:40:05'),
('4887d07f3b7eb5115d7ccf1917a3e00420bba7acb53f68330f59f693408295a73463137bb7df3a99', 17, 1, 'UserToken', '[]', 0, '2021-11-22 12:18:55', '2021-11-22 12:18:55', '2022-11-22 17:48:55'),
('64b827515244108f938aaab1cfaadce4fa32563f0ae7c12c26e8974ea2f15362431a3780a6d2a01e', 14, 1, 'UserToken', '[]', 0, '2021-11-21 22:58:12', '2021-11-21 22:58:12', '2022-11-22 04:28:12'),
('65de1d4c0d6ae1bec12a184b1bc7dfb20524af0c4ca9d65712aeb90ca42e451cb3b9845b5bcef837', 9, 1, 'UserToken', '[]', 0, '2021-11-16 23:45:32', '2021-11-16 23:45:32', '2022-11-17 05:15:32'),
('6b025c92231bc4da0e1e6113fba8da84a9bf888b8f145b8ba2821c603f095182f5e91b724f304f09', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:39:44', '2021-11-16 03:39:44', '2022-11-16 09:09:44'),
('72323c263ed825abc48a1ecc6c06d6dac86fc9126faad0a364d82af8ab96f69437e2b85e9311b47b', 9, 1, 'UserToken', '[]', 1, '2021-11-16 04:09:05', '2021-11-16 04:09:05', '2022-11-16 09:39:05'),
('7b35812c84d9e5193c7e9a1603f51b586a75712420614100aa2528bd2a8f73249fa6696b4e5d5b83', 9, 1, 'UserToken', '[]', 0, '2021-11-16 23:45:15', '2021-11-16 23:45:15', '2022-11-17 05:15:15'),
('828083531ced02528b7b8f3100c76228af4a7d9fd19f95d30b478eb44f186ccd5ddb39f76c1d25fb', 10, 1, 'UserToken', '[]', 0, '2021-11-16 05:40:53', '2021-11-16 05:40:53', '2022-11-16 11:10:53'),
('984bf64fc782ee3e11932e6f6e43d15d22ec30941bbc887a72f86cbf14ed2977fea59390cb5ab615', 13, 1, 'UserToken', '[]', 0, '2021-11-17 04:46:17', '2021-11-17 04:46:17', '2022-11-17 10:16:17'),
('9c3e90dac597193bbdf3420e634b788d5d3b044b81925fe8ff6305a014bd33b3f70934f182fd1a00', 6, 1, 'UserToken', '[]', 0, '2021-11-16 03:44:13', '2021-11-16 03:44:13', '2022-11-16 09:14:13'),
('a0c445777d59159dae14ffab477458e8f2a77f8b33a6e17f6ac726db92a6ab34dd2a73a09e5826f2', 13, 1, 'UserToken', '[]', 0, '2021-11-20 00:19:44', '2021-11-20 00:19:44', '2022-11-20 05:49:44'),
('a2cdab69607cf556e1b314821a1b02c602d5f05b93ca79235d1821705796408c24e21b783cb892ac', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:43:20', '2021-11-16 03:43:20', '2022-11-16 09:13:20'),
('a367c022d6e00d76d7dd48cd664a262f18781b77b1d1d4932c56517b518e1b0b2e292fd449989eac', 3, 1, 'UserToken', '[]', 0, '2021-11-16 03:32:37', '2021-11-16 03:32:37', '2022-11-16 09:02:37'),
('b2ad6a22ec0f84991087e3563f94f5d4ee34edc84534cc9377d796ec8a74704082df14dc31e1e0e1', 14, 1, 'UserToken', '[]', 0, '2021-11-20 06:53:10', '2021-11-20 06:53:10', '2022-11-20 12:23:10'),
('bbf0ce75cbf373928b377edc726006f5ae4cd22babd65bb8458a6b7c279cef3aaab136cf93d0bbb8', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:39:48', '2021-11-16 03:39:48', '2022-11-16 09:09:48'),
('bfd6de8eda4e7dd6b2b3ec78a6002a5ac049873ce6bc85980cd8260e19b235440d2663696e7e97d0', 15, 1, 'UserToken', '[]', 0, '2021-11-20 07:01:37', '2021-11-20 07:01:37', '2022-11-20 12:31:37'),
('c3bc319eb31a68dc69aa0bc2dd8652c8dced45534c2dcd243e86f1fd87b38f8f317b39ccb88d884d', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:59:30', '2021-11-16 03:59:30', '2022-11-16 09:29:30'),
('cb2908920d93c75124e02849bdfe439516593f5e948e40b18369ac41d308cbbd2e4e238c47b8939f', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:33:17', '2021-11-16 03:33:17', '2022-11-16 09:03:17'),
('cd664455025b1cb3d5995a38a6dbb7c2be61cd65519a537409c970229cf58942a982e1f24097f330', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:39:17', '2021-11-16 03:39:17', '2022-11-16 09:09:17'),
('d4826bedff5e88e08410841d672955207740ef8837d8373fd07a9dfdaa1815bacfba083a7158336a', 12, 1, 'UserToken', '[]', 0, '2021-11-17 01:35:13', '2021-11-17 01:35:13', '2022-11-17 07:05:13'),
('d6a35918a344dd890b3652270591a89e13d08dce2a38897e279869b5f93ce9df4902513836ce7779', 8, 1, 'UserToken', '[]', 0, '2021-11-16 03:48:16', '2021-11-16 03:48:16', '2022-11-16 09:18:16'),
('db07fe357278334a8bb25f9df8be092f862085dce3c074494272d818ed324caf34602d2a0095b0d0', 2, 1, 'UserToken', '[]', 0, '2021-11-16 03:11:26', '2021-11-16 03:11:26', '2022-11-16 08:41:26'),
('dda398953097dd9c2ac5ae2b489976681c48e213aa14e2a5158d46c589a90ab6c0386f75795c9efb', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:43:07', '2021-11-16 03:43:07', '2022-11-16 09:13:07'),
('e1e8d38091d1fa590c6405b7a81280961f30bbd5cc7df08396bb464a049f8416ade04fb72c1025ed', 1, 1, 'UserToken', '[]', 0, '2021-11-16 03:31:31', '2021-11-16 03:31:31', '2022-11-16 09:01:31'),
('f460a1f4261a14abac66bc7631a6a07887a440c2e9957ef1cdcd0bf172092fe2e014c4e22e7b38a5', 4, 1, 'UserToken', '[]', 0, '2021-11-16 03:43:47', '2021-11-16 03:43:47', '2022-11-16 09:13:47');

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

--
-- 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) UNSIGNED NOT NULL,
  `client_id` bigint(20) 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` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'bDUIZZnue3OhWz7K2fyFK001sjqlscheMDuOuQBl', NULL, 'http://localhost', 1, 0, 0, '2021-11-16 01:40:28', '2021-11-16 01:40:28'),
(2, NULL, 'Laravel Password Grant Client', 'u3FQwOAdNDuD4FamVxPtbRNZrTTKWrDlHrMs2IVr', 'users', 'http://localhost', 0, 1, 0, '2021-11-16 01:40:28', '2021-11-16 01:40:28');

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

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_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;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2021-11-16 01:40:28', '2021-11-16 01:40:28');

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

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

CREATE TABLE `payment_settings_master` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) 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;

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT 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 `savings_master`
--

CREATE TABLE `savings_master` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sv_gl_id` int(11) DEFAULT NULL,
  `sv_u_id` int(11) DEFAULT NULL,
  `sv_note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sv_amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sv_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sv_date` date 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 `savings_master`
--

INSERT INTO `savings_master` (`id`, `sv_gl_id`, `sv_u_id`, `sv_note`, `sv_amount`, `sv_type`, `sv_date`, `created_at`, `updated_at`) VALUES
(1, 3, 9, 'update saving note', '2000', 'withdraw', '2021-11-22', '2021-11-18 01:04:38', '2021-11-22 11:39:23'),
(8, 3, 9, 'doble entry for 3 9', '2000', 'savings', NULL, '2021-11-18 23:19:18', '2021-11-18 23:19:18'),
(10, 16, 16, 'salary', '10000', 'savings', NULL, '2021-11-22 00:28:29', '2021-11-22 00:32:51'),
(11, 16, 16, 'remote work', '5000', 'savings', NULL, '2021-11-22 00:30:01', '2021-11-22 00:30:01'),
(14, 18, 16, 'remote work', '5000', 'savings', NULL, '2021-11-22 00:50:20', '2021-11-22 00:50:20');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `maintenance_mode` bigint(20) DEFAULT NULL,
  `notification_day` double DEFAULT 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 `sms_settings_master`
--

CREATE TABLE `sms_settings_master` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) 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;

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

--
-- Table structure for table `smtp_setting`
--

CREATE TABLE `smtp_setting` (
  `ss_id` int(10) UNSIGNED NOT NULL,
  `ss_mailer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ss_host` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ss_port` double DEFAULT NULL,
  `ss_uname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ss_pwd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ss_encryption` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ss_from_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ss_from_name` varchar(191) 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;

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

--
-- Table structure for table `social_master`
--

CREATE TABLE `social_master` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) 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;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_group` bigint(20) DEFAULT 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`, `status`, `user_type`, `user_group`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'active', 'administrator', 1, 'email@email.com', NULL, '$2y$10$MLF67XkiXHHLzmTM3JbPQevYNdg/UfVH740flduHjrggRlZHkf06C', NULL, NULL, '2021-11-16 23:48:01');

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE `user_groups` (
  `ug_id` bigint(20) UNSIGNED NOT NULL,
  `ug_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ug_permissions` text 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 `user_groups`
--

INSERT INTO `user_groups` (`ug_id`, `ug_name`, `ug_permissions`, `created_at`, `updated_at`) VALUES
(1, 'Administrator', 'login,logout,register,password.request,password.email,password.reset,password.update,password.confirm', NULL, NULL);

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

--
-- Table structure for table `user_master`
--

CREATE TABLE `user_master` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `u_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `u_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `u_password` varchar(191) 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 `user_master`
--

INSERT INTO `user_master` (`id`, `u_name`, `u_email`, `u_password`, `created_at`, `updated_at`) VALUES
(9, 'qrolic goal', 'qrolic@gmail.com', '$2y$10$mCth2QMIJC/89jyhi5BNluLCjWC08rKuTvd746YUrqhout8tuzYvi', '2021-11-16 04:08:57', '2021-11-21 23:57:23'),
(14, 'qrolic', 'vatsalchotaliya8830@gmail.com', '$2y$10$z2qxp1p.pDUC43hyMaqJNuwsbOiWERFc.DX9NjlryxQ.fq27iZ/vG', '2021-11-20 06:53:10', '2021-11-20 06:53:10'),
(16, 'shruti', 'shrutipatel241@gmail.com', '$2y$10$Hlc9ibG0U3XmQ1DGqVMeqO13l9i/wvcHRK8h/gxpxkO5RczzN4INC', '2021-11-21 23:08:50', '2021-11-22 00:00:22'),
(17, 'harry potter', 'harry@gmail.com', '$2y$10$CzwGdus3UoMas6jLvX4zbOipwBy3/wbVOe1NsggsncCPQM9S9Fe7e', '2021-11-22 12:18:31', '2021-11-22 12:20:12');

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

--
-- Table structure for table `webhook_calls`
--

CREATE TABLE `webhook_calls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exception` text 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;

--
-- Indexes for dumped tables
--

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

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

--
-- 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`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_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`);

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

--
-- Indexes for table `smtp_setting`
--
ALTER TABLE `smtp_setting`
  ADD PRIMARY KEY (`ss_id`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `user_groups`
--
ALTER TABLE `user_groups`
  ADD PRIMARY KEY (`ug_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `smtp_setting`
--
ALTER TABLE `smtp_setting`
  MODIFY `ss_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `user_groups`
--
ALTER TABLE `user_groups`
  MODIFY `ug_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

