-- 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_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_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 `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 `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 `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_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_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`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 `user_groups`
--
ALTER TABLE `user_groups`
  ADD PRIMARY KEY (`ug_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_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 `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 `user_groups`
--
ALTER TABLE `user_groups`
  MODIFY `ug_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

