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

START TRANSACTION;



--
-- Database: `profile_management`
--

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

--
-- Table structure for table `bailbond`
--

CREATE TABLE `bailbond` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `money_receipt_number` varchar(100) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bailbond`
--

INSERT INTO `bailbond` (`id`, `user_id`, `money_receipt_number`, `amount`, `create_date`, `created_at`, `updated_at`) VALUES
(1, 331783, '4', 300, '2021-04-11', '2021-04-11 00:31:47', '2021-04-11 00:31:47'),
(2, 331783, '5', 300, '2021-04-11', '2021-04-11 00:32:04', '2021-04-11 00:32:04'),
(3, 331783, '4', 1000, '2021-04-11', '2021-04-11 00:34:02', '2021-04-11 00:34:02'),
(4, 331783, '8', 2005, '2021-04-11', '2021-04-11 00:34:43', '2021-04-11 00:34:43'),
(5, 634885, '9', 200, '2021-04-11', '2021-04-11 00:38:33', '2021-04-11 00:38:33');

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

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

CREATE TABLE `incomes` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `money_receipt_number` varchar(100) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `incomes`
--

INSERT INTO `incomes` (`id`, `user_id`, `money_receipt_number`, `amount`, `type`, `create_date`, `created_at`, `updated_at`) VALUES
(1, 331783, '7', 100, 'ocalotnama', '2021-04-08', '2021-04-08 02:21:13', '2021-04-08 02:21:13'),
(2, 331783, '5', 4000, 'billbond', '2021-04-08', '2021-04-08 02:22:23', '2021-04-08 02:22:23'),
(3, 331783, '2', 4000, 'ocalotnama', '2021-04-08', '2021-04-08 06:15:47', '2021-04-08 06:15:47'),
(4, 331783, '1', 100, 'ocalotnama', '2008-04-21', '2021-04-08 06:52:32', '2021-04-08 06:52:32'),
(5, 331783, '9', 100, 'ocalotnama', '2021-04-08', '2021-04-08 06:54:17', '2021-04-08 06:54:17'),
(6, 331783, '5', 300, 'billbond', '2021-04-11', '2021-04-11 00:32:04', '2021-04-11 00:32:04'),
(7, 331783, '4', 1000, 'billbond', '2021-04-11', '2021-04-11 00:34:02', '2021-04-11 00:34:02'),
(8, 331783, '8', 2005, 'billbond', '2021-04-11', '2021-04-11 00:34:43', '2021-04-11 00:34:43'),
(9, 634885, '4', 300, 'ocalotnama', '2021-04-11', '2021-04-11 00:38:08', '2021-04-11 00:38:08'),
(10, 634885, '9', 200, 'billbond', '2021-04-11', '2021-04-11 00:38:33', '2021-04-11 00:38:33'),
(11, 331783, '5', 200, 'ocalotnama', '2021-04-11', '2021-04-11 03:40:42', '2021-04-11 03:40:42');

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

--
-- Table structure for table `member_details`
--

CREATE TABLE `member_details` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `full_name` varchar(150) DEFAULT NULL,
  `phone_number` varchar(20) DEFAULT NULL,
  `e_mail` varchar(150) DEFAULT NULL,
  `nid` text DEFAULT NULL,
  `gender` int(1) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `profile_image` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_details`
--

INSERT INTO `member_details` (`id`, `user_id`, `full_name`, `phone_number`, `e_mail`, `nid`, `gender`, `address`, `profile_image`, `created_at`, `updated_at`) VALUES
(1, 331783, 'Tayfik Talukder', '01316104254', 'tayfik@gmail.com', '1234567891011', 1, 'Mirpur, Cantonment Dhaka-12016', '606ea4becc712.png', '2021-04-08 00:37:50', '2021-04-08 00:37:50'),
(2, 634885, 'Shonjoy Das', '01688430821', 'shonjoy@gmail.com', '123454987864', 1, 'Mipur', '60729941914ef.jpg', '2021-04-11 00:37:53', '2021-04-11 00:37:53');

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

--
-- 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, '2019_08_19_000000_create_failed_jobs_table', 1);

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

--
-- Table structure for table `okalotnama`
--

CREATE TABLE `okalotnama` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `money_receipt_number` varchar(100) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `okalotnama`
--

INSERT INTO `okalotnama` (`id`, `user_id`, `money_receipt_number`, `amount`, `create_date`, `created_at`, `updated_at`) VALUES
(1, 331783, '7', 100, '2021-04-08', '2021-04-08 02:21:13', '2021-04-08 02:21:13'),
(2, 331783, '5', 4000, '2021-04-08', '2021-04-08 02:22:23', '2021-04-08 02:22:23'),
(3, 331783, '2', 4000, '2021-04-08', '2021-04-08 06:15:47', '2021-04-08 06:15:47'),
(4, 331783, '4', 100, '2021-04-08', '2021-04-08 06:52:18', '2021-04-08 06:52:18'),
(5, 331783, '1', 100, '2021-04-08', '2021-04-08 06:52:32', '2021-04-08 06:52:32'),
(6, 331783, '4', 100, '2021-04-08', '2021-04-08 06:53:20', '2021-04-08 06:53:20'),
(7, 331783, '9', 100, '2021-04-08', '2021-04-08 06:54:17', '2021-04-08 06:54:17'),
(8, 634885, '4', 300, '2021-04-11', '2021-04-11 00:38:08', '2021-04-11 00:38:08'),
(9, 331783, '5', 200, '2021-04-11', '2021-04-11 03:40:42', '2021-04-11 03:40:42');

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

--
-- Table structure for table `voter_list`
--

CREATE TABLE `voter_list` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `voter_id` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `voter_list`
--

INSERT INTO `voter_list` (`id`, `user_id`, `voter_id`) VALUES
(1, 634885, '112756'),
(2, 331783, '571089');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bailbond`
--
ALTER TABLE `bailbond`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `incomes`
--
ALTER TABLE `incomes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

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

--
-- AUTO_INCREMENT for table `okalotnama`
--
ALTER TABLE `okalotnama`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `voter_list`
--
ALTER TABLE `voter_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

