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

START TRANSACTION;



--
-- Database: `special_services_exams`
--

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

--
-- Table structure for table `bdedu_students`
--

CREATE TABLE `bdedu_students` (
  `student_row_id` int(11) UNSIGNED NOT NULL,
  `student_id` bigint(20) DEFAULT NULL,
  `student_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `student_name_bangla` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `student_password_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `school_row_id` int(11) NOT NULL,
  `current_session` int(3) DEFAULT NULL,
  `current_class` tinyint(1) NOT NULL,
  `current_shift` tinyint(1) NOT NULL DEFAULT '1',
  `current_department` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=General, 2= Science, 3=Arts, 4=commerce, 5=other',
  `current_section` int(11) DEFAULT NULL,
  `current_rollnumber` int(11) DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `student_photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `student_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `student_gender` tinyint(1) NOT NULL,
  `student_blood_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `student_religion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nationality` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `father_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mother_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `student_dob` date DEFAULT NULL,
  `admission_date` date DEFAULT NULL,
  `guardian_row_id` int(11) DEFAULT NULL,
  `guardian_login_row_id` int(11) DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `active_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 = inactive, 1 = active',
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bdedu_students`
--

INSERT INTO `bdedu_students` (`student_row_id`, `student_id`, `student_name`, `student_name_bangla`, `email`, `status`, `password`, `student_password_text`, `school_row_id`, `current_session`, `current_class`, `current_shift`, `current_department`, `current_section`, `current_rollnumber`, `contact`, `student_photo`, `student_phone`, `student_gender`, `student_blood_group`, `student_religion`, `nationality`, `father_name`, `mother_name`, `student_dob`, `admission_date`, `guardian_row_id`, `guardian_login_row_id`, `remember_token`, `active_status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 80001, 'Naila Noshin', 'Naila Noshin', 'nailanoshin@gmail.com', 1, '$2y$10$nfnr1s6wgGbDqvcUu8jWa.qWC808VHRbCPzA9ArrspfsxlpavjBJO', '123456', 1, NULL, 8, 1, 1, 1, NULL, NULL, '1560407865_10117060002_FAHIMATASNIMMITA.png', '', 1, '1', '0', 'Bangladeshi', '', '', NULL, '2019-05-14', NULL, NULL, 'TBRhh2jievzdVp1SQnwOlJYFQscZLg4wCxmXuBjxJxKcGMgEgvpeekHqodXI', 1, 2, NULL, '2019-06-13 00:37:44', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bdedu_students`
--
ALTER TABLE `bdedu_students`
  ADD PRIMARY KEY (`student_row_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bdedu_students`
--
ALTER TABLE `bdedu_students`
  MODIFY `student_row_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

