
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `phone` int(11) NOT NULL,
  `UserName` varchar(100) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO admin VALUES("1","Jahangir Alam","1712275079","01712275079","ja01712275079","Admin");
INSERT INTO admin VALUES("5","Dr. Sandip Chandra Roy","1966059932","01966059932","59932","BNI");
INSERT INTO admin VALUES("6","Nigamananda Deb","1710534153","01710534153","534153","BNI");
INSERT INTO admin VALUES("7","Jobayar Hossain","1714293603","01714293603","293603","BNI");
INSERT INTO admin VALUES("8","Forida Yesmin","1705818182","01705818182","818182","BNI");
INSERT INTO admin VALUES("9","SHOHEL","1728316734","01728316734","9090","BNI");



CREATE TABLE `attendance` (
  `attendance_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class_id` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `section_id` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `student_id` int(11) NOT NULL,
  `roll` int(11) NOT NULL,
  `status` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`attendance_id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1;

INSERT INTO attendance VALUES("65","Laxmon Debshorma ","Diploma In Nursing Science and Midwifery ","1st Year ","54","1","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("66","Mukul Chandra Pal ","Diploma In Nursing Science and Midwifery ","1st Year ","55","2","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("67","Sompa Chakraborty ","Diploma In Nursing Science and Midwifery ","1st Year ","56","3","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("68","Yeasmin Ara ","Diploma In Nursing Science and Midwifery ","1st Year ","57","4","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("69","Menara Parvin ","Diploma In Nursing Science and Midwifery ","1st Year ","58","5","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("70","Most. Shahanaj Khatun ","Diploma In Nursing Science and Midwifery ","1st Year ","59","6","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("71","Mst. Eti Akter ","Diploma In Nursing Science and Midwifery ","1st Year ","60","7","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("72","Jospin Tudu ","Diploma In Nursing Science and Midwifery ","1st Year ","61","8","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("73","Priya Roy ","Diploma In Nursing Science and Midwifery ","1st Year ","62","9","Present ","BNI ","2019-01-22");
INSERT INTO attendance VALUES("74","Samira Afrin ","Diploma In Nursing Science and Midwifery ","1st Year ","63","10","Present ","BNI ","2019-01-22");



CREATE TABLE `book` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `author` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class_id` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `price` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




CREATE TABLE `class` (
  `class_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name_numeric` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sectin` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

INSERT INTO class VALUES("2","Diploma In Nursing","57","DMI","1st Semester");
INSERT INTO class VALUES("3","Diploma In Nursing","57","DMI","2nd Semester");
INSERT INTO class VALUES("4","Diploma In Nursing","57","DMI","3rd Semester");
INSERT INTO class VALUES("5","Diploma In Nursing","57","DMI","4th Semester");
INSERT INTO class VALUES("6","Diploma In Nursing","57","DMI","5th Semester");
INSERT INTO class VALUES("7","Diploma In Nursing","57","DMI","6th Semester");
INSERT INTO class VALUES("8","Diploma In Dental","52","DMI","1st Semester");
INSERT INTO class VALUES("9","Diploma In Dental","52","DMI","2nd Semester");
INSERT INTO class VALUES("10","Diploma In Dental","52","DMI","3rd Semester");
INSERT INTO class VALUES("11","Diploma In Dental","52","DMI","4th Semester");
INSERT INTO class VALUES("12","Diploma In Dental","52","DMI","5th Semester");
INSERT INTO class VALUES("13","Diploma In Dental","52","DMI","6th Semester");
INSERT INTO class VALUES("14","Diploma In Laboratory","53","DMI","1st Semester");
INSERT INTO class VALUES("15","Diploma In Laboratory","53","DMI","2nd Semester");
INSERT INTO class VALUES("16","Diploma In Laboratory","53","DMI","3rd Semester");
INSERT INTO class VALUES("17","Diploma In Laboratory","53","DMI","5th Semester");
INSERT INTO class VALUES("19","Diploma In Laboratory","53","DMI","4th Semester");
INSERT INTO class VALUES("20","Diploma In Laboratory","53","DMI","6th Semester");
INSERT INTO class VALUES("21","Mats","00","DMI","1st Year");
INSERT INTO class VALUES("22","Mats","00","DMI","2nd Year");
INSERT INTO class VALUES("23","Mats","00","DMI","3rd Year");
INSERT INTO class VALUES("24","Diploma In Nursing Science and Midwifery","00","BNI","1st Year");
INSERT INTO class VALUES("25","Diploma In Nursing Science and Midwifery","00","BNI","2nd Year");
INSERT INTO class VALUES("26","Diploma In Nursing Science and Midwifery","00","BNI","3rd Year");



CREATE TABLE `class_routine` (
  `class_routine_id` int(11) NOT NULL AUTO_INCREMENT,
  `course` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `semester` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `a` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `b` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `c` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `d` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `e` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `f` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `g` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `h` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `i` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `j` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `k` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `l` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `m` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `n` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `o` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `p` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `q` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `r` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `s` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `t` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `u` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `v` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `w` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `x` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `y` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `z` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `aa` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bb` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cc` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dd` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ee` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ff` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `gg` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `hh` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ii` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `jj` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kk` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ll` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mm` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nn` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `oo` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `qq` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `rr` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ss` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tt` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `uu` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `vv` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ww` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `xx` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `yy` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `zz` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `aaa` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bbb` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ccc` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ddd` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `eee` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `fff` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ggg` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `hhh` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `iii` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `jjj` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kkk` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lll` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mmm` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nnn` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ooo` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ppp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `qqq` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `rrr` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sss` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ttt` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `uuu` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `vvv` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `www` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `xxx` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `yyy` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `zzz` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `aaaa` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bbbb` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cccc` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dddd` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `eeee` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ffff` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `gggg` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `hhhh` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `iiii` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `jjjj` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kkkk` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `llll` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mmmm` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nnnn` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `oooo` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pppp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `qqqq` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `rrrr` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`class_routine_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO class_routine VALUES("1","Diploma In Nursing","5th semester","DMI","9.00 to 09.45","CCU & ICU Nursing-1","9.45 to 10.30","Medical & Surgical Nursing-1","","","","","","","","","","","","","","Midwifery, Obstetrical Nursing & Family Planning-1","","Gerontology and Geriatric Nursing-1","","","","","","","","","","","","","","Psychiartic Nursing-1","","Forensic Medicine-1","","","","","","","","","","","","","","Midwifery, Obstetrical Nursing & Family Planning-1","","Pediatric and Neonatal Nursing-1","","","","","","","","","","","","","","Forensic Medicine-1","","Gerontology and Geriatric Nursing-1","","","","","","","","","","","","","","Exam","","Pediatric and Neonatal Nursing-1","","","","","","","","","","","","");
INSERT INTO class_routine VALUES("2","Diploma In Laboratory","3rd semester","DMI","9.00 to 10.00","","9.30 to 10.30","","10.30 to 11.30","Computer Application","11.00 to 12.00","Microbiology & Parasitology-1","","","","","","","","","","General Pathology-1","","Hematology-1","","","","","","","","","","","","","","","","","","","","Microbiology & Parasitology-1","","","","","","","","","","General Pathology-1","","Hematology-1","","Computer Application","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","");
INSERT INTO class_routine VALUES("3","Diploma In Dental","3rd semester","DMI","10.30 to 11.15","","11.15 to 12.00","Microbiology & Parasitology-1","11.45 to 12.30","","12.30 to 1.15","","","","","","","","","","","","","","","","","Nihar ","","","","","","","","","","","","Microbiology & Parasitology-1","","","","","","","","","","","","","","Computer Application","","Nihar ","","","","","","","","","","","","","","","","","","Nihar ","","","","","","","","","","","","","","","","Nihar ","","","","","","","","","","");
INSERT INTO class_routine VALUES("4","Diploma In Nursing","3rd semester","DMI","9.45 to 10.30","","10.30 to 11.15","Computer Application","11.15 to 12.00","Microbiology & Parasitology-1","12.00 to 12.45","Nursing Arts & Application-1","","","","","","","","","","","","","","Emergency Nursing and First Aid-1","","Community Health Nursing-1","","","","","","","","","","","","","","Microbiology & Parasitology-1","","Nursing Arts & Application-2","","","","","","","","","","","","Computer Application","","Community Health Nursing-1","","Exam","","","","","","","","","","Pharmacology-1","","Community Health Nursing-1","","Communicable Diseases, Immunization & Nutrition-1","","Emergency Nursing and First Aid-1","","","","","","","","","","","","Emergency Nursing and First Aid-1","","Communicable Diseases, Immunization & Nutrition-1","","Pharmacology-1","","","","","","","","");



CREATE TABLE `credit` (
  `sl` int(5) NOT NULL AUTO_INCREMENT,
  `cdate` date NOT NULL,
  `studentname` varchar(250) NOT NULL,
  `class` varchar(250) NOT NULL,
  `roll` int(250) NOT NULL,
  `time` varchar(250) NOT NULL,
  `credit` varchar(250) NOT NULL,
  `creditdiscription` varchar(250) NOT NULL,
  `institute` varchar(255) DEFAULT NULL,
  `creditamount` int(20) NOT NULL,
  PRIMARY KEY (`sl`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




CREATE TABLE `debit` (
  `sl` int(5) NOT NULL AUTO_INCREMENT,
  `ddate` date NOT NULL,
  `debit` varchar(250) NOT NULL,
  `debitdiscription` varchar(250) NOT NULL,
  `institute` varchar(255) DEFAULT NULL,
  `debitamount` int(20) NOT NULL,
  PRIMARY KEY (`sl`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO debit VALUES("1","2019-01-21","BANK DEPOSIT","Jumuna Bank","BNI","5000");
INSERT INTO debit VALUES("2","2019-01-21","TO DIRECTOR","Sir","BNI","5000");
INSERT INTO debit VALUES("3","2019-01-22","PAY BANK LOAN","Merkentail","BNI","2000");



CREATE TABLE `document` (
  `document_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `file_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `file_type` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class_id` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `teacher_id` int(11) NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




CREATE TABLE `invoice` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `section` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `roll` int(11) NOT NULL,
  `invoice` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `paymentdate` date NOT NULL,
  `paymentfield` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `amount` int(11) NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dueamount` int(11) NOT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

INSERT INTO invoice VALUES("1","Mst. Eti Akter","Diploma In Nursing Science and Midwifery","1st Year","7","403","60","2018-12-22","Admission/Re-Admission","December","10000","BNI","0");
INSERT INTO invoice VALUES("2","Most. Shahanaj Khatun","Diploma In Nursing Science and Midwifery","1st Year","6","404","59","2018-12-23","Admission/Re-Admission","December","4200","BNI","0");
INSERT INTO invoice VALUES("3","Jospin Tudu","Diploma In Nursing Science and Midwifery","1st Year","8","405","61","2018-12-24","Admission/Re-Admission","December","10200","BNI","0");
INSERT INTO invoice VALUES("4","Menara Parvin","Diploma In Nursing Science and Midwifery","1st Year","5","406","58","2018-12-24","Admission/Re-Admission","December","5200","BNI","0");
INSERT INTO invoice VALUES("5","Most. Shahanaj Khatun","Diploma In Nursing Science and Midwifery","1st Year","6","407","59","2018-12-26","Admission/Re-Admission","December","6000","BNI","0");
INSERT INTO invoice VALUES("6","Priya Roy","Diploma In Nursing Science and Midwifery","1st Year","9","408","62","2018-12-27","Admission/Re-Admission","December","5200","BNI","0");
INSERT INTO invoice VALUES("7","Samira Afrin","Diploma In Nursing Science and Midwifery","1st Year","10","409","63","2019-01-05","Admission/Re-Admission","Janurary","10200","BNI","0");
INSERT INTO invoice VALUES("8","Priya Roy","Diploma In Nursing Science and Midwifery","1st Year","9","411","62","2019-01-09","Admission/Re-Admission","Janurary","5000","BNI","0");
INSERT INTO invoice VALUES("9","Menara Parvin","Diploma In Nursing Science and Midwifery","1st Year","5","412","58","2019-01-12","Admission/Re-Admission","Janurary","5000","BNI","0");
INSERT INTO invoice VALUES("10","Priya Roy","Diploma In Nursing Science and Midwifery","1st Year","9","414","62","2019-01-19","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("11","Samira Afrin","Diploma In Nursing Science and Midwifery","1st Year","10","416","63","2019-01-19","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("12","Yeasmin Ara","Diploma In Nursing Science and Midwifery","1st Year","4","401","57","2018-12-20","Admission/Re-Admission","December","10000","BNI","0");
INSERT INTO invoice VALUES("13","Laxmon Debshorma","Diploma In Nursing Science and Midwifery","1st Year","1","402","54","2018-12-20","Admission/Re-Admission","December","10000","BNI","0");
INSERT INTO invoice VALUES("14","Sompa Chakraborty","Diploma In Nursing Science and Midwifery","1st Year","3","246","56","2019-09-08","Admission/Re-Admission","September","5000","BNI","0");
INSERT INTO invoice VALUES("15","Mukul Chandra Pal","Diploma In Nursing Science and Midwifery","1st Year","2","283","55","2018-09-29","Admission/Re-Admission","September","10100","BNI","0");
INSERT INTO invoice VALUES("16","Sumona Akther","Diploma In Nursing Science and Midwifery","1st Year","14","413","67","2019-01-17","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("17","Most. Siddika Khatun","Diploma In Nursing Science and Midwifery","1st Year","15","415","68","2019-01-19","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("18","Most. Shefali Khatun","Diploma In Nursing Science and Midwifery","1st Year","11","417","64","2019-01-20","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("19","Mst. Eti Akter","Diploma In Nursing Science and Midwifery","1st Year","7","418","60","2019-01-21","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("20","Most. shapla Akter Amrina","Diploma In Nursing Science and Midwifery","1st Year","13","419","66","2019-01-21","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("21","Jospin Tudu","Diploma In Nursing Science and Midwifery","1st Year","8","420","61","2019-01-21","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("22","Nipa Rani Roy","Diploma In Nursing Science and Midwifery","1st Year","12","421","65","2019-01-21","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("23","Mukti Rani Roy","Diploma In Nursing Science and Midwifery","1st Year","16","422","69","2019-01-21","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("24","Menara Parvin","Diploma In Nursing Science and Midwifery","1st Year","5","423","58","2019-01-22","Tuition Fee","Janurary","2000","BNI","0");
INSERT INTO invoice VALUES("26","Laxmon Debshorma","Diploma In Nursing Science and Midwifery","1st Year","1","424","54","2019-01-24","Tuition Fee","January","1000","BNI","0");
INSERT INTO invoice VALUES("27","Shapon Kumar Roy ","Diploma In Laboratory","3rd Semester","167","3621","10","2017-07-27","Admission/Re-Admission","July","10100","DMI","0");
INSERT INTO invoice VALUES("29","Jaba Rani Roy","Diploma In Nursing","3rd Semester","177","3635","17","2017-08-09","Admission/Re-Admission","August","10100","DMI","0");
INSERT INTO invoice VALUES("30","Jaba Rani Roy","Diploma In Nursing","3rd Semester","177","555","17","2019-02-26","Other","February","29000","DMI","0");
INSERT INTO invoice VALUES("31","Bipuna Rani","Diploma In Nursing","3rd Semester","183","3630","23","2017-08-06","Admission/Re-Admission","August","10100","DMI","0");
INSERT INTO invoice VALUES("32","Bipuna Rani","Diploma In Nursing","3rd Semester","183","523","23","2019-02-15","Other","February","29500","DMI","0");
INSERT INTO invoice VALUES("33","Shapon Kumar Roy ","Diploma In Laboratory","3rd Semester","167","570","10","2019-03-07","Other","March","29500","DMI","0");
INSERT INTO invoice VALUES("34","Sourov  Roy","Diploma In Dental","3rd Semester","166","3608","9","2017-07-17","Admission/Re-Admission","July","10100","DMI","0");
INSERT INTO invoice VALUES("35","Sourov  Roy","Diploma In Dental","3rd Semester","166","575","9","2019-03-09","Other","March","29500","DMI","0");
INSERT INTO invoice VALUES("36","Labonee Rani Roy","Diploma In Nursing","3rd Semester","179","3581","19","2017-06-12","Admission/Re-Admission","Jun","10100","DMI","0");
INSERT INTO invoice VALUES("37","Labonee Rani Roy","Diploma In Nursing","3rd Semester","179","586","19","2019-03-11","Other","March","29500","DMI","0");
INSERT INTO invoice VALUES("38","Polash Chandra Roy","Diploma In Laboratory","3rd Semester","172","3563","14","2017-04-04","Admission/Re-Admission","Jun","10100","DMI","0");
INSERT INTO invoice VALUES("39","Polash Chandra Roy","Diploma In Laboratory","3rd Semester","172","566","14","2019-03-05","Other","March","29500","DMI","0");
INSERT INTO invoice VALUES("40","Md. Anarul Islam","Diploma In Laboratory","3rd Semester","173","3520","15","2017-05-30","Admission/Re-Admission","May","10100","DMI","0");
INSERT INTO invoice VALUES("41","Md. Anarul Islam","Diploma In Laboratory","3rd Semester","173","583","15","2019-03-10","Other","March","29500","DMI","0");
INSERT INTO invoice VALUES("42","Alamin","Diploma In Laboratory","3rd Semester","174","748","16","2017-05-16","Admission/Re-Admission","May","10100","DMI","0");
INSERT INTO invoice VALUES("43","Alamin","Diploma In Laboratory","3rd Semester","174","582","16","2019-03-10","Other","March","29500","DMI","0");
INSERT INTO invoice VALUES("44","Md. Habibur Rahman","Diploma In Laboratory","3rd Semester","171","3508","13","2017-05-21","Admission/Re-Admission","May","10100","DMI","0");
INSERT INTO invoice VALUES("45","Md. Habibur Rahman","Diploma In Laboratory","3rd Semester","171","567","13","2019-03-05","Other","March","28500","DMI","0");
INSERT INTO invoice VALUES("46","Jaklin Chichiliya Das","Diploma In Laboratory","3rd Semester","169","3506","11","2017-05-15","Admission/Re-Admission","May","10100","DMI","0");
INSERT INTO invoice VALUES("47","Jaklin Chichiliya Das","Diploma In Laboratory","3rd Semester","169","569","11","2019-03-06","Other","March","29500","DMI","0");



CREATE TABLE `leaves` (
  `leave_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class` varchar(250) DEFAULT NULL,
  `section` varchar(250) DEFAULT NULL,
  `howlong` int(11) NOT NULL,
  `previusleave` int(11) NOT NULL,
  `aplydate` date NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `guardianmobile` int(11) NOT NULL,
  `leavedatea` date NOT NULL,
  `leavedateb` date NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('Approved','Pending') NOT NULL DEFAULT 'Pending',
  PRIMARY KEY (`leave_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO leaves VALUES("3","5","Md. Rezwanul Haque","Diploma In Dental","3rd Semester","2","0","2019-01-13","Health issue","1930704060","2019-01-14","2019-01-15","DMI","Approved");



CREATE TABLE `leavet` (
  `leave_id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` int(11) NOT NULL,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `designation` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `howlong` int(11) NOT NULL,
  `previusleave` int(11) NOT NULL,
  `aplydate` date NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `responsibility` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `leavedatea` date NOT NULL,
  `leavedateb` date NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('Approved','Pending') NOT NULL DEFAULT 'Pending',
  PRIMARY KEY (`leave_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




CREATE TABLE `noticeboard` (
  `notice_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_title` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `notice` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `create_timestamp` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO noticeboard VALUES("3","???????? ??????? ?????? ???  ??????? ? ???  ???? ???????","???????? ???? ???????????? ??? ?????-?????? ?????? ???? ?????? ?????? ??, ????? ??/??/???? ?? ????? ??? ??/??/?????? ????? ??????? ???????? ??????? ?????? ???  ??????? ? ???  ???? ???????","DMI","2018-12-09");
INSERT INTO noticeboard VALUES("4","????? ??/??/???? ?? ????? ???? ??????? ??????? ???????? ???","???????? ???? ???????????? ?? ?????? ?????-????????? ?????? ???? ?????? ?????? ??, ????? ??/??/???? ?? ????? ???? ??????? ??????? ???????? ???? ??????? ???????? ?? ????? ????? ???/- ???? ?????? ??? ????? ??/??/?????? ??????? ????? ?????? ??? ?????????? ????? ???? ???? ??? ????","DMI","2019-01-20");
INSERT INTO noticeboard VALUES("5","??????/???????/????","???????? ???? ???????????? ??? ?????-??????, ??????-???????? ? ?????????-??????????? ?????? ???? ?????? ?????? ??, ????? ??/??/???? ?? ????? ??? ??????????? ???? ???? ?????????? ? ??????????? ???????? ???? ????????? ?????? ??? ????????? ???? ?????? ??? ????? ??/??/???? ?? ????? ???? ?????? ??? ????????? ???????  ???? ?????
\n
\n","DMI","2019-02-20");
INSERT INTO noticeboard VALUES("6","???????","???????? ???? ???????????? ?????? ?????-?????? ?????? ???? ?????? ?????? ??, ???????? ??????? ?????, ????????????, ??????? ? ???????? ??? ????????? ??? ?????? ??? ????","DMI","2019-02-20");



CREATE TABLE `salari` (
  `salari_id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` int(11) NOT NULL,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `designation` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `paymentdate` date NOT NULL,
  `time` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `paymentfield` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `amount` int(11) NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `dueamount` int(11) NOT NULL,
  PRIMARY KEY (`salari_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




CREATE TABLE `section` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nick_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class_id` int(11) NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `teacher_id` int(11) NOT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




CREATE TABLE `student` (
  `student_id` int(11) NOT NULL AUTO_INCREMENT,
  `photo` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `birthday` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sex` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `religion` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `UserName` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `father_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mother_name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class_id` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `section_id` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `roll` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `coursefee` int(11) NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`student_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;

INSERT INTO student VALUES("5","1999-04-21Md. Rezwanul Haque","Md. Rezwanul Haque","1999-04-21","Male","Islam","Angarpara, Pajherhat, Khansama, Dinajpur","01763129183","","01763129183","r3456h","Md. Rajaul Karim","Rubina Akhter","Diploma In Dental","3rd Semester","940162","58100","DMI");
INSERT INTO student VALUES("6","1997-03-10Santosh Roy","Santosh Roy","1997-03-10","Male","Hindu","Shampur, Shemulbari, Pirganj, Thakurgoan","01767066654","","01767066654","8156","Basudeb Roy","Biddaerani","Diploma In Dental","3rd Semester","163","58100","DMI");
INSERT INTO student VALUES("7","1994-06-13Md. Nur Islam","Md. Nur Islam","1994-06-13","Male","Islam","Modho Vandara, Ranisankol, Thakurgoan","01738720782","","01738720782","4238","Md. Shaheb Ali","Nur Jahan Begum","Diploma In Dental","3rd Semester","164","58100","DMI");
INSERT INTO student VALUES("8","1992-05-07Md. Saddam Hossain","Md. Saddam Hossain","1992-05-07","Male","Islam","Rosulpur, Sadhubazar, Khaharul, Dinajpur","01717747676","","01717747676","9204","Md. Abdul Goni","Mst. Hamida Begum","Diploma In Dental","3rd Semester","165","58100","DMI");
INSERT INTO student VALUES("9","1996-10-15Sourov  Roy","Sourov  Roy","1996-10-15","Male","Hindu","Sordarpara, Bottolihat, Boda, Panchogor","01717264690","","01717264690","5430","khagenddra Nath Barman","Rekha Rani Roy","Diploma In Dental","3rd Semester","166","58100","DMI");
INSERT INTO student VALUES("10","2001-01-01Shapon Kumar Roy ","Shapon Kumar Roy ","2001-01-01","Male","Hindu","west begunbari , senpara","01764878539","","01764878539","1943","Deb Kumar Roy ","Rahdheka Rani ","Diploma In Laboratory","3rd Semester","167","58100","DMI");
INSERT INTO student VALUES("11","1998-03-07Jaklin Chichiliya Das","Jaklin Chichiliya Das","1998-03-07","Female","Christian","Mariumpur, Osmanpur, Ghoraghat, Dinajpur","01854718674","","01854718674","9230","Maikel Das","Anon Chiyata Hamda","Diploma In Laboratory","3rd Semester","169","58100","DMI");
INSERT INTO student VALUES("12","2002-04-02Tariqul","Tariqul","2002-04-02","Male","Islam","Golmunda, Sadar, Nilfamari","01757864165","","01757864165","3047","Mofiz Begum","Toskina Begum","Diploma In Laboratory","3rd Semester","170","58100","DMI");
INSERT INTO student VALUES("13","1999-05-29Md. Habibur Rahman","Md. Habibur Rahman","1999-05-29","Male","Islam","Murkhaganj, Vajonpur, Tetoliya, Panchagarh","01722937309","","01722937309","6972","Md. Ismaill Hosen","Mst. Kulsum Banu","Diploma In Laboratory","3rd Semester","171","58100","DMI");
INSERT INTO student VALUES("14","1998-09-06Polash Chandra Roy","Polash Chandra Roy","1998-09-06","Male","Hindu","Dhakesur, Araji Copukur, Birgonj, Dinajpur","01733072115","","01733072115","8429","Gobindo Cha. Roy","Kunti Rani Roy","Diploma In Laboratory","3rd Semester","172","58100","DMI");
INSERT INTO student VALUES("15","1998-10-03Md. Anarul Islam","Md. Anarul Islam","1998-10-03","Male","Islam","Bairagipara, Balandar, Biral, Dinajpur","01751024452","","01751024452","1834","Md. Kalim Uddin","Mst. Rabina Khatun","Diploma In Laboratory","3rd Semester","173","58100","DMI");
INSERT INTO student VALUES("16","1997-11-23Alamin","Alamin","1997-11-23","Male","Islam","Baltor, Shekpur, Sadar, Dinajpur","01774280993","","01774280993","3202","Kharojun Rahman","Arfa Khatun","Diploma In Laboratory","3rd Semester","174","58100","DMI");
INSERT INTO student VALUES("17","1999-04-16Jaba Rani Roy","Jaba Rani Roy","1999-04-16","Female","Hindu","Razpur, Basudebpur, Chiribondor","01744811679","","01744811679","2918","Mohini Mohan Roy","Joytika Rani Roy","Diploma In Nursing","3rd Semester","177","58100","DMI");
INSERT INTO student VALUES("18","1996-06-10Moriom Parvin","Moriom Parvin","1996-06-10","Female","Islam","North Balubari, Sadar, Dinajpur","01792931153","","01792931153","7316","Abdul Khaleque","Razia Begum","Diploma In Nursing","3rd Semester","178","58100","DMI");
INSERT INTO student VALUES("19","2000-07-05Labonee Rani Roy","Labonee Rani Roy","2000-07-05","Female","Hindu","Boro Balihar, Hatrampur, Bochagonj, Dinajpur","01744568723","","01744568723","3819","Khirat Candra Roy","Josoda Rani Roy","Diploma In Nursing","3rd Semester","179","58100","DMI");
INSERT INTO student VALUES("20","1999-02-10Mst. Roksana Akter","Mst. Roksana Akter","1999-02-10","Female","Islam","Shekarpur, Dhakamara, Panchagarh","01737571719","","01737571719","0234","Md. Goljan Hossain","Lotifa Begum","Diploma In Nursing","3rd Semester","180","58100","DMI");
INSERT INTO student VALUES("21","1996-08-25Aly Akter","Aly Akter","1996-08-25","Female","Islam","Rhiya Ghonimohespur, Thakurgon","01768825509","","01768825509","5082","Akramul Haque","Tahera Begum","Diploma In Nursing","3rd Semester","181","58100","DMI");
INSERT INTO student VALUES("22","1999-05-27Surovi Rani","Surovi Rani","1999-05-27","Female","Hindu","Alowakhoa, Boshalpara, Atowari, Panchgor","01740346655","","01740346655","4476","Dhaneshwar Barman","Bharoti Rani","Diploma In Nursing","3rd Semester","182","58100","DMI");
INSERT INTO student VALUES("23","1998-10-13Bipuna Rani","Bipuna Rani","1998-10-13","Female","Hindu","Alowakhoa, Boshalpara, Atowari, Panchgor","01796066163","","01796066163","3028","Binonda Barman","Urmila Rani","Diploma In Nursing","3rd Semester","183","58100","DMI");
INSERT INTO student VALUES("24","1995-03-10Topoty Bakla","Topoty Bakla","1995-03-10","Female","Christian","Ghira, chatinali, Pachbibi, Joypurhat","01751193596","","01751193596","4938","Daniyel  Bakla","Mahdalina Rispotta","Diploma In Nursing","3rd Semester","184","58100","DMI");
INSERT INTO student VALUES("25","1999-12-25Lalita Rani Pal","Lalita Rani Pal","1999-12-25","Female","Christian","Alowakhoa, Boshalpara, Atowari, Panchgor","01789505111","","01789505111","8078","Nirmal Chandra Pal","Kiron Rani Pal","Diploma In Nursing","3rd Semester","185","58100","DMI");
INSERT INTO student VALUES("26","1997-08-21Nipa Kujur","Nipa Kujur","1997-08-21","Female","Christian","Mariumpur, Osmanpur, Ghoraghat, Dinajpur","01706742001","","01706742001","1414","Surendranath Kujur","Raimoni Khalko","Diploma In Nursing","3rd Semester","186","58100","DMI");
INSERT INTO student VALUES("27","1999-02-02Shiuli Das","Shiuli Das","1999-02-02","Female","Christian","Molan Khuri, Khuribari, Thakurgaon","01701900434","","01701900434","6924","Alisuis Das","Rita Das","Diploma In Nursing","3rd Semester","187","58100","DMI");
INSERT INTO student VALUES("28","1998-08-23Bobita Mardi","Bobita Mardi","1998-08-23","Female","Christian","Shahpur, Rishikul, Godhagari, Rajshahi","01795136628","","01795136628","1002","Barjon mardi","Panmoni murmu","Diploma In Nursing","3rd Semester","189","58100","DMI");
INSERT INTO student VALUES("29","1987-08-03Md. Rubel Razzak","Md. Rubel Razzak","1987-08-03","Male","Islam","Boro Korimpur, Laterhat, Birganj, Dinajpur","01717804003","","01717804003","2084","Md. Mizanur Rahaman","Rezina Khatun","Diploma In Dental","5th Semester","118","83320","DMI");
INSERT INTO student VALUES("30","1989-10-27Md. Nur Alam Siddiki","Md. Nur Alam Siddiki","1989-10-27","Male","Islam","kengarpur, Birgonj, Dinajpur","01761876597","","01761876597","5319","Md,. Hafij Karim","Mst. Nur Nahar","Diploma In Dental","5th Semester","127","50000","DMI");
INSERT INTO student VALUES("31","1997-02-11Dipak Kumar Pahan","Dipak Kumar Pahan","1997-02-11","Male","Hindu","Alowakhoa, Boshalpara, Atowari, Panchgor","01722074428","","01722074428","1165","Naresh Pahan","Bina Rani","Diploma In Laboratory","5th Semester","132","83320","DMI");
INSERT INTO student VALUES("32","1999-02-01Md. Tahirul Islam","Md. Tahirul Islam","1999-02-01","Male","Islam","Narayongonj, Bouraburi, Tetoliya, Panchgor","01704279441","","01704279441","3035","Md. Kawsar Ali","Tahura Khatun","Diploma In Laboratory","5th Semester","133","83320","DMI");
INSERT INTO student VALUES("33","1997-09-19Pangkaj Kumar Pal","Pangkaj Kumar Pal","1997-09-19","Male","Hindu","Alowakhoa, Boshalpara, Atowari, Panchgor","01783214443","","01783214443","5249","Deb Kumar Pal","Ashwini Rani","Diploma In Laboratory","5th Semester","139","83320","DMI");
INSERT INTO student VALUES("34","1997-12-10Sumi Murmu","Sumi Murmu","1997-12-10","Female","Christian","Raninogor, Desma, Birampur, Dinajpur","0178303364","","0178303364","0219","Hakim Murmu","Surujmoni Powria","Diploma In Nursing","5th Semester","134","83320","DMI");
INSERT INTO student VALUES("35","1999-09-18Mst. Nur Naner","Mst. Nur Naner","1999-09-18","Female","Islam","Ronhata, Chorongi Bazar, Horipur, Thakurgoan","01797939172","","01797939172","3565","Md. Nuzrul Islam","Mst. Nilufa Begum","Diploma In Nursing","5th Semester","143","83320","DMI");
INSERT INTO student VALUES("36","1997-05-10Mst. Arifa Akter","Mst. Arifa Akter","1997-05-10","Female","Islam","Noholiyapara, Kholapara, Panchagarh","01762406417","","01762406417","7923","Md. Wassuddin","Most. Jobeda Begum","Diploma In Nursing","5th Semester","144","83320","DMI");
INSERT INTO student VALUES("37","1998-03-05Most. Bonna Khatun","Most. Bonna Khatun","1998-03-05","Female","Islam","Gandhipara, Tajnogor, Parbotipur, Dinajpur","0175928743","","0175928743","4712","Md. Aslam Ali","Most. Kohinur Begum","Diploma In Nursing","5th Semester","148","83320","DMI");
INSERT INTO student VALUES("38","1997-07-14Sriti Roy","Sriti Roy","1997-07-14","Female","Hindu","Jogdol, Birgonj, Dinajpur","01774343715","","01774343715","5654","Dinesh Roy","Mini Rani","Diploma In Nursing","5th Semester","149","83320","DMI");
INSERT INTO student VALUES("39","2000-04-04Sumi Ara","Sumi Ara","2000-04-04","Female","Islam","Teghra, Farakkabad, Biral, Dinajpur","01722093073","","01722093073","3161","Md. Somedul Islam","Miss. Mhochana Begum","Diploma In Nursing","5th Semester","152","83320","DMI");
INSERT INTO student VALUES("40","1997-02-05Most. Fatema Akter","Most. Fatema Akter","1997-02-05","Female","Islam","Doluyapara, Boda, Panchangare","01738390744","","01738390744","0420","Md. Chan Mia","Mst. Majeda Khatun","Diploma In Nursing","5th Semester","153","83320","DMI");
INSERT INTO student VALUES("41","1999-10-12Md. Firoje Ali","Md. Firoje Ali","1999-10-12","Male","Islam","khepara, Satmera, Panchagarh","01786817848","","01786817848","1024","Md. Soleman Ali","Mst. Ofijan Begum","Diploma In Laboratory","1st Semester","01","76100","DMI");
INSERT INTO student VALUES("42","2001-05-10Hriday Das","Hriday Das","2001-05-10","Male","Hindu","Molonkhuri, khoribari, Thakurgoan","01773508273","","01773508273","7292","Satish Das","Asneta Das","Diploma In Laboratory","1st Semester","02","76100","DMI");
INSERT INTO student VALUES("43","1997-05-18Mst. Nhida Akter Lubna","Mst. Nhida Akter Lubna","1997-05-18","Female","Islam","Angarpara, Khansama, Dinajpur","01717240418","","01717240418","2484","Md. Hamidul Haque","Mosa. Resma Haque Sima","Diploma In Dental","1st Semester","03","76100","DMI");
INSERT INTO student VALUES("44","2001-12-24Md. Taraq Hasan","Md. Taraq Hasan","2001-12-24","Male","Islam","9no Sator, Birgonj, Dinajpur","01773169378","","01773169378","0077","A.T.M. Anamul Hasan","Rasheda Begum","Diploma In Dental","1st Semester","04","76100","DMI");
INSERT INTO student VALUES("45","1997-10-15Arifin Sazzar Rifat","Arifin Sazzar Rifat","1997-10-15","Male","Islam","Pakerhat, Khansama, Dinajpur","01751343713","","01751343713","7499","F M A Rahim Sarkar","Jobaida Gulshan Jahn","Diploma In Dental","1st Semester","05","76100","DMI");
INSERT INTO student VALUES("46","1998-12-15Md. Alamin Islam","Md. Alamin Islam","1998-12-15","Male","Islam","Damdurpur, Komulpur, Sadar, Dinajpur","01838983469","","01838983469","3913","Md. Najrul Islam","Mst. Aklima Khatun","Diploma In Dental","1st Semester","06","76100","DMI");
INSERT INTO student VALUES("47","1998-05-28Monjur Rakib","Monjur Rakib","1998-05-28","Male","Islam","Patuyapara, Sadar, Dinajpur","01773694597","","01773694597","2012","Md. Safiur Rahaman","Rowson Ara Begum","Mats","2nd Year","01","58100","DMI");
INSERT INTO student VALUES("48","2001-03-23Sanjida Akter Shama","Sanjida Akter Shama","2001-03-23","Female","Islam","Coxba, Sadar, Dinajpur","01729977238","","01729977238","7032","Md. Shakihur Rahman","Mst. Rina Banu","Mats","3rd Year","01","88000","DMI");
INSERT INTO student VALUES("49","2000-11-15Md. Subuj Ali","Md. Subuj Ali","2000-11-15","Male","Islam","Kaprangapara, Amnahar, Panchagoar","01748479778","","01748479778","7755","Md. Johirul Islam","Mst. Mokseda Begum","Mats","3rd Year","02","127800","DMI");
INSERT INTO student VALUES("50","2000-01-15Ayasha Shaddika ","Ayasha Shaddika ","2000-01-15","Female","Islam","sujapur, fulbari , dinajpur","01773937570","","01773937570","9517","Md. Abdul Alim ","Shafali Begum ","Mats","3rd Year","03","88000","DMI");
INSERT INTO student VALUES("51","1998-11-25Md. Farhad Hossen","Md. Farhad Hossen","1998-11-25","Male","Islam","Balandar, Birol, Dinajpur","01796106951","","01796106951","1865","Md. Ainul Haque","Mst. Fulchera Khatun","Mats","3rd Year","04","104220","DMI");
INSERT INTO student VALUES("52","2000-03-11Mst. Farmina Aktar","Mst. Farmina Aktar","2000-03-11","Female","Islam","Motijapur, Bochagonj, Setabganj, Dinajpur","01744720350","","01744720350","9578","Md. Faruk Hosen","Toslima Begum","Mats","3rd Year","05","106200","DMI");
INSERT INTO student VALUES("54","1999-09-25Laxmon DebshormaLaxman.jpg","Laxmon Debshorma","1999-09-25","Male","Hindu","Kakdowa, Hat Madhobpur, Bochagonj, Dinajpur","01734036593","","01734036593","4579","Shadhin Debshorma","Mina Debshorma","Diploma In Nursing Science and Midwifery","1st Year","01","120200","BNI");
INSERT INTO student VALUES("55","1998-12-08Mukul Chandra PalMukul.jpg","Mukul Chandra Pal","1998-12-08","Male","Hindu","Alowakhoa, Boshalpara, Atowari, Panchgor","01738779317","","01738779317","4395","Suresh Chandra Pal","Milan Rani","Diploma In Nursing Science and Midwifery","1st Year","02","120200","BNI");
INSERT INTO student VALUES("56","01719367716Sompa ChakrabortySompa.jpg","Sompa Chakraborty","2001-06-05","Female","Hindu","North Balubari, Sadar, Dinajpur","01719367716","","01719367716","0328","Kanu Chakraborty","Baby Chakraborty","Diploma In Nursing Science and Midwifery","1st Year","03","100200","BNI");
INSERT INTO student VALUES("57","01701910805Yeasmin AraYesmin.jpg","Yeasmin Ara","1998-04-20","Female","Islam","North Balubari, Sadar, Dinajpur","01701910805","","01701910805","8946","Md. Abdur Rahman","Shahanaz Begum","Diploma In Nursing Science and Midwifery","1st Year","04","130200","BNI");
INSERT INTO student VALUES("58","01797501526Menara ParvinMinara.jpg","Menara Parvin","1999-01-24","Female","Islam","Komolpur, Sadar, Dinajpur","01797501526","","01797501526","2450","Md. Mynuddin","Serena Begum","Diploma In Nursing Science and Midwifery","1st Year","05","130200","BNI");
INSERT INTO student VALUES("59","01783090173Most. Shahanaj KhatunShanaj.jpg","Most. Shahanaj Khatun","1998-03-15","Female","Islam","Mohorajpur, Mazapara, Sadar, Dinajpur","01783090173","","01783090173","6065","Md. Shamsul Haque","Sahera Begum","Diploma In Nursing Science and Midwifery","1st Year","06","125200","BNI");
INSERT INTO student VALUES("60","01767022780Mst. Eti AkterEti.jpg","Mst. Eti Akter","2000-05-13","Female","Islam","Kalesorgao, Devipur, Thakurgaon","01767022780","","01767022780","4222","Md. Soleman Ali","Mst. Lovely Akter","Diploma In Nursing Science and Midwifery","1st Year","07","130200","BNI");
INSERT INTO student VALUES("61","01780893082Jospin TuduTudu.jpg","Jospin Tudu","1999-10-18","Female","Christian","Nundonpur, Osmanpur, Ghoraghat, Dinajpur","01780893082","","01780893082","6916","Jotin Tudu","Maloti Hasda","Diploma In Nursing Science and Midwifery","1st Year","08","120200","BNI");
INSERT INTO student VALUES("62","01767229025Priya RoyPiya.jpg","Priya Roy","1999-05-10","Female","Hindu","Murshedahat, setubganj, Bochagonj, Dinajpur","01767229025","","01767229025","3029","Gopal Roy","Gita Roy","Diploma In Nursing Science and Midwifery","1st Year","09","130200","BNI");
INSERT INTO student VALUES("63","01304655422Samira AfrinSamera Afrin.jpg","Samira Afrin","1999-09-28","Female","Islam","Changthi, Devigonj, Panchagarh","01304655422","","01304655422","4073","Md. Rofiqul Islam","Most. Aktara Banu","Diploma In Nursing Science and Midwifery","1st Year","10","120200","BNI");
INSERT INTO student VALUES("64","1999-05-03Most. Shefali Khatun","Most. Shefali Khatun","1999-05-03","Female","Islam"," Tajnogor, Parbotipur, Dinajpur","01997290429","","01997290429","4699","Md. Abdul Zabber","Most. Momena Khatun","Diploma In Nursing Science and Midwifery","1st Year","11","140000","BNI");
INSERT INTO student VALUES("65","2000-05-02Nipa Rani Roy","Nipa Rani Roy","2000-05-02","Female","Hindu","Ranipukur, Ruddopur, Birol, Dinajpur","01318977146","","01318977146","2350","Bhagiroth Roy","Protima Rani Roy","Diploma In Nursing Science and Midwifery","1st Year","12","140000","BNI");
INSERT INTO student VALUES("66","2001-10-20Most. shapla Akter Amrina","Most. shapla Akter Amrina","2001-10-20","Female","Islam","Amiapur, Dinajpur","01788072084","","01788072084","1801","Md. Sabedul shah","Mst. Rahima Begum","Diploma In Nursing Science and Midwifery","1st Year","13","140000","BNI");
INSERT INTO student VALUES("67","1999-03-27Sumona Akther","Sumona Akther","1999-03-27","Female","Islam","Modhochatnai, Dharagonj, Dimla, Nilphamari","01721324071","","01721324071","2983","Md. Golam Mostafa","Mst. Khaleda Begum","Diploma In Nursing Science and Midwifery","1st Year","14","130000","BNI");
INSERT INTO student VALUES("68","1998-11-19Most. Siddika Khatun","Most. Siddika Khatun","1998-11-19","Female","Islam","Dinajpur","01738223519","","01738223519","7165","Md. Anuarul Islam","Mst. Jahanara Begum","Diploma In Nursing Science and Midwifery","1st Year","15","140000","BNI");
INSERT INTO student VALUES("69","2019-01-21Mukti Rani Roy","Mukti Rani Roy","2019-01-21","Female","Hindu","Ranipukur, Ruddopur, Birol, Dinajpur","01749974623","","01749974623","1617","Sree Kanto Roy","Aroty Rani Roy","Diploma In Nursing Science and Midwifery","1st Year","16","140000","BNI");
INSERT INTO student VALUES("70","1999-05-07Mst. Sumsunnahar","Mst. Sumsunnahar","1999-05-07","Female","Islam","Uttor sigahmari, Hatibandha, Lalmonihat","01734010579","","01734010579","8173","Md. Abdur Sattar","Mst. Lovely Begum","Diploma In Nursing Science and Midwifery","1st Year","17","130000","BNI");



CREATE TABLE `subject` (
  `subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `code` int(11) NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subjectclass` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `semester` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=latin1;

INSERT INTO subject VALUES("1","Bangla-1","7611","DMI","Diploma In Dental","1st Semester");
INSERT INTO subject VALUES("2","English-1","7612","DMI","Diploma In Dental","1st Semester");
INSERT INTO subject VALUES("3","Physics-1","7613","DMI","Diploma In Dental","1st Semester");
INSERT INTO subject VALUES("4","Chemistry-1","7614","DMI","Diploma In Dental","1st Semester");
INSERT INTO subject VALUES("5","Biology-1","7615","DMI","Diploma In Dental","1st Semester");
INSERT INTO subject VALUES("6","Basic Human Anatomy-1","7616","DMI","Diploma In Dental","1st Semester");
INSERT INTO subject VALUES("7","Basic Human Physiology-1","7617","DMI","Diploma In Dental","1st Semester");
INSERT INTO subject VALUES("8","Bangla-2","7621","DMI","Diploma In Dental","2nd Semester");
INSERT INTO subject VALUES("9","English-2","7622","DMI","Diploma In Dental","2nd Semester");
INSERT INTO subject VALUES("10","Physics-2","7623","DMI","Diploma In Dental","2nd Semester");
INSERT INTO subject VALUES("11","Chemistry-2","7624","DMI","Diploma In Dental","2nd Semester");
INSERT INTO subject VALUES("12","Biology-2","7625","DMI","Diploma In Dental","2nd Semester");
INSERT INTO subject VALUES("13","Basic Human Anatomy-2","7626","DMI","Diploma In Dental","2nd Semester");
INSERT INTO subject VALUES("14","Basic Human Physiology-2","7627","DMI","Diploma In Dental","2nd Semester");
INSERT INTO subject VALUES("15","Computer Application","7631","DMI","Diploma In Dental","3rd Semester");
INSERT INTO subject VALUES("16","Microbiology & Parasitology-1","7632","DMI","Diploma In Dental","3rd Semester");
INSERT INTO subject VALUES("17","Oral & Dental Anatomy-1","5233","DMI","Diploma In Dental","3rd Semester");
INSERT INTO subject VALUES("18","Chemistry of Dental Materials-1","5234","DMI","Diploma In Dental","3rd Semester");
INSERT INTO subject VALUES("19","Technique of Partial Denture Proshesis-1","5235","DMI","Diploma In Dental","3rd Semester");
INSERT INTO subject VALUES("20","Technique of Complete Denture Proshesis-1","5236","DMI","Diploma In Dental","3rd Semester");
INSERT INTO subject VALUES("21","Community Dentistry-1","5237","DMI","Diploma In Dental","3rd Semester");
INSERT INTO subject VALUES("22","Community Medicine","7641","DMI","Diploma In Dental","4th Semester");
INSERT INTO subject VALUES("23","Microbiology & Parasitology-2","7642","DMI","Diploma In Dental","4th Semester");
INSERT INTO subject VALUES("24","Oral & Dental Anatomy-2","5243","DMI","Diploma In Dental","4th Semester");
INSERT INTO subject VALUES("25","Chemistry of Dental Materials-2","5244","DMI","Diploma In Dental","4th Semester");
INSERT INTO subject VALUES("26","Technique of Partial Denture Proshesis-2","5245","DMI","Diploma In Dental","4th Semester");
INSERT INTO subject VALUES("27","Technique of Complete Denture Proshesis-2","5246","DMI","Diploma In Dental","4th Semester");
INSERT INTO subject VALUES("28","Community Dentistry-2","5247","DMI","Diploma In Dental","4th Semester");
INSERT INTO subject VALUES("29","Oral Hygiene & Periodontology-1","5251","DMI","Diploma In Dental","5th Semester");
INSERT INTO subject VALUES("30","Clinical Practice in Dental Surgery & Dental Pharmacology-1","5252","DMI","Diploma In Dental","5th Semester");
INSERT INTO subject VALUES("31","Oral Pathology-1","5253","DMI","Diploma In Dental","5th Semester");
INSERT INTO subject VALUES("32","Conservative Dentistry & Radiology-1","5254","DMI","Diploma In Dental","5th Semester");
INSERT INTO subject VALUES("33","Orthodontics-1","5255","DMI","Diploma In Dental","5th Semester");
INSERT INTO subject VALUES("34","Applied Dental Prosthesis-1","5256","DMI","Diploma In Dental","5th Semester");
INSERT INTO subject VALUES("35","Children & Preventive Dentistry-1","5257","DMI","Diploma In Dental","5th Semester");
INSERT INTO subject VALUES("36","Oral Hygiene & Periodontology-2","5261","DMI","Diploma In Dental","6th Semester");
INSERT INTO subject VALUES("37","Clinical Practice in Dental Surgery & Dental Pharmacology-2","5262","DMI","Diploma In Dental","6th Semester");
INSERT INTO subject VALUES("38","Oral Pathology-2","5263","DMI","Diploma In Dental","6th Semester");
INSERT INTO subject VALUES("39","Conservative Dentistry & Radiology-2","5264","DMI","Diploma In Dental","6th Semester");
INSERT INTO subject VALUES("40","Orthodontics-2","5265","DMI","Diploma In Dental","6th Semester");
INSERT INTO subject VALUES("41","Applied Dental Prosthesis-2","5266","DMI","Diploma In Dental","6th Semester");
INSERT INTO subject VALUES("42","Children & Preventive Dentistry-2","5267","DMI","Diploma In Dental","6th Semester");
INSERT INTO subject VALUES("43","Bangla-1","7611","DMI","Diploma In Nursing","1st Semester");
INSERT INTO subject VALUES("44","English-1","7612","DMI","Diploma In Nursing","1st Semester");
INSERT INTO subject VALUES("45","Physics-1","7613","DMI","Diploma In Nursing","1st Semester");
INSERT INTO subject VALUES("46","Chemistry-1","7614","DMI","Diploma In Nursing","1st Semester");
INSERT INTO subject VALUES("47","Biology-1","7615","DMI","Diploma In Nursing","1st Semester");
INSERT INTO subject VALUES("48","Basic Human Anatomy-1","7616","DMI","Diploma In Nursing","1st Semester");
INSERT INTO subject VALUES("49","Basic Human Physiology-1","7617","DMI","Diploma In Nursing","1st Semester");
INSERT INTO subject VALUES("50","Bangla-2","7621","DMI","Diploma In Nursing","2nd Semester");
INSERT INTO subject VALUES("51","English-2","7622","DMI","Diploma In Nursing","2nd Semester");
INSERT INTO subject VALUES("52","Physics-2","7623","DMI","Diploma In Nursing","2nd Semester");
INSERT INTO subject VALUES("53","Chemistry-2","7624","DMI","Diploma In Nursing","2nd Semester");
INSERT INTO subject VALUES("54","Biology-2","7625","DMI","Diploma In Nursing","2nd Semester");
INSERT INTO subject VALUES("55","Basic Human Anatomy-2","7626","DMI","Diploma In Nursing","2nd Semester");
INSERT INTO subject VALUES("56","Basic Human Physiology-2","7627","DMI","Diploma In Nursing","2nd Semester");
INSERT INTO subject VALUES("57","Computer Application","7631","DMI","Diploma In Nursing","3rd Semester");
INSERT INTO subject VALUES("58","Microbiology & Parasitology-1","7632","DMI","Diploma In Nursing","3rd Semester");
INSERT INTO subject VALUES("59","Nursing Arts & Application-1","5731","DMI","Diploma In Nursing","3rd Semester");
INSERT INTO subject VALUES("60","Pharmacology-1","5634","DMI","Diploma In Nursing","3rd Semester");
INSERT INTO subject VALUES("61","Community Health Nursing-1","5733","DMI","Diploma In Nursing","3rd Semester");
INSERT INTO subject VALUES("62","Communicable Diseases, Immunization & Nutrition-1","5734","DMI","Diploma In Nursing","3rd Semester");
INSERT INTO subject VALUES("63","Emergency Nursing and First Aid-1","5735","DMI","Diploma In Nursing","3rd Semester");
INSERT INTO subject VALUES("64","Community Medicine","7641","DMI","Diploma In Nursing","4th Semester");
INSERT INTO subject VALUES("65","Microbiology & Parasitology-2","7642","DMI","Diploma In Nursing","4th Semester");
INSERT INTO subject VALUES("66","Nursing Arts & Application-2","5741","DMI","Diploma In Nursing","4th Semester");
INSERT INTO subject VALUES("67","Pharmacology-2","5644","DMI","Diploma In Nursing","4th Semester");
INSERT INTO subject VALUES("68","Community Health Nursing-2","5743","DMI","Diploma In Nursing","4th Semester");
INSERT INTO subject VALUES("69","Communicable Diseases, Immunization & Nutrition-2","5744","DMI","Diploma In Nursing","4th Semester");
INSERT INTO subject VALUES("70","Emergency Nursing and First Aid-2","5745","DMI","Diploma In Nursing","4th Semester");
INSERT INTO subject VALUES("71","Forensic Medicine-1","5751","DMI","Diploma In Nursing","5th Semester");
INSERT INTO subject VALUES("72","Medical & Surgical Nursing-1","5752","DMI","Diploma In Nursing","5th Semester");
INSERT INTO subject VALUES("73","Midwifery, Obstetrical Nursing & Family Planning-1","5753","DMI","Diploma In Nursing","5th Semester");
INSERT INTO subject VALUES("74","Psychiartic Nursing-1","5754","DMI","Diploma In Nursing","5th Semester");
INSERT INTO subject VALUES("75","Pediatric and Neonatal Nursing-1","5755","DMI","Diploma In Nursing","5th Semester");
INSERT INTO subject VALUES("76","Gerontology and Geriatric Nursing-1","5756","DMI","Diploma In Nursing","5th Semester");
INSERT INTO subject VALUES("77","CCU & ICU Nursing-1","5757","DMI","Diploma In Nursing","5th Semester");
INSERT INTO subject VALUES("78","Forensic Medicine-2","5761","DMI","Diploma In Nursing","6th Semester");
INSERT INTO subject VALUES("79","Medical & Surgical Nursing-2","5762","DMI","Diploma In Nursing","6th Semester");
INSERT INTO subject VALUES("80","Midwifery, Obstetrical Nursing & Family Planning-2","5763","DMI","Diploma In Nursing","6th Semester");
INSERT INTO subject VALUES("81","Psychiartic Nursing-2","5764","DMI","Diploma In Nursing","6th Semester");
INSERT INTO subject VALUES("82","Pediatric and Neonatal Nursing-2","5765","DMI","Diploma In Nursing","6th Semester");
INSERT INTO subject VALUES("83","Gerontology and Geriatric Nursing-2","5766","DMI","Diploma In Nursing","6th Semester");
INSERT INTO subject VALUES("84","CCU & ICU Nursing-2","5767","DMI","Diploma In Nursing","6th Semester");
INSERT INTO subject VALUES("85","Bangla-1","7611","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("86","English-1","7612","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("87","Physics-1","7613","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("88","Chemistry-1","7614","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("89","Biology-1","7615","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("90","Basic Human Anatomy-1","7616","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("91","Basic Human Physiology-1","7617","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("92","Bangla-2","7621","DMI","Diploma In Laboratory","1st Semester");
INSERT INTO subject VALUES("93","English-2","7622","DMI","Diploma In Laboratory","2nd Semester");
INSERT INTO subject VALUES("94","Physics-2","7623","DMI","Diploma In Laboratory","2nd Semester");
INSERT INTO subject VALUES("95","Chemistry-2","7624","DMI","Diploma In Laboratory","2nd Semester");
INSERT INTO subject VALUES("96","Biology-2","7625","DMI","Diploma In Laboratory","2nd Semester");
INSERT INTO subject VALUES("97","Basic Human Anatomy-2","7626","DMI","Diploma In Laboratory","2nd Semester");
INSERT INTO subject VALUES("98","Basic Human Physiology-2","7627","DMI","Diploma In Laboratory","2nd Semester");
INSERT INTO subject VALUES("99","Computer Application","7631","DMI","Diploma In Laboratory","3rd Semester");
INSERT INTO subject VALUES("100","Microbiology & Parasitology-1","7632","DMI","Diploma In Laboratory","3rd Semester");
INSERT INTO subject VALUES("101","General Pathology-1","5331","DMI","Diploma In Laboratory","3rd Semester");
INSERT INTO subject VALUES("102","Clinical  Pathology-1","5332","DMI","Diploma In Laboratory","3rd Semester");
INSERT INTO subject VALUES("103","Clinical Chemistry-1","5333","DMI","Diploma In Laboratory","3rd Semester");
INSERT INTO subject VALUES("104","Laboratory Technique-1","5334","DMI","Diploma In Laboratory","3rd Semester");
INSERT INTO subject VALUES("105","Hematology-1","5335","DMI","Diploma In Laboratory","3rd Semester");
INSERT INTO subject VALUES("106","Community Medicine","7641","DMI","Diploma In Laboratory","4th Semester");
INSERT INTO subject VALUES("107","Microbiology & Parasitology-2","7642","DMI","Diploma In Laboratory","4th Semester");
INSERT INTO subject VALUES("108","General Pathology-2","5341","DMI","Diploma In Laboratory","4th Semester");
INSERT INTO subject VALUES("109","Clinical  Pathology-2","5342","DMI","Diploma In Laboratory","4th Semester");
INSERT INTO subject VALUES("110","Clinical Chemistry-2","5343","DMI","Diploma In Laboratory","4th Semester");
INSERT INTO subject VALUES("111","Laboratory Technique-2","5344","DMI","Diploma In Laboratory","4th Semester");
INSERT INTO subject VALUES("112","Hematology-2","5345","DMI","Diploma In Laboratory","4th Semester");
INSERT INTO subject VALUES("113","Immunology, Serology & Hormonal Diagnostic Process-1","5351","DMI","Diploma In Laboratory","5th Semester");
INSERT INTO subject VALUES("114","Biochemistry-1","5352","DMI","Diploma In Laboratory","5th Semester");
INSERT INTO subject VALUES("115","Virology-1","5353","DMI","Diploma In Laboratory","5th Semester");
INSERT INTO subject VALUES("116","Blood Banking & Transfusion Medicine Service","5354","DMI","Diploma In Laboratory","5th Semester");
INSERT INTO subject VALUES("117","Systemic Pathology & Forensic Test-1","5355","DMI","Diploma In Laboratory","5th Semester");
INSERT INTO subject VALUES("118","Mycology-1","5356","DMI","Diploma In Laboratory","5th Semester");
INSERT INTO subject VALUES("119","Medical Genetics & Biotechnics Diagnosis-1","5357","DMI","Diploma In Laboratory","5th Semester");
INSERT INTO subject VALUES("120","Immunology, Serology & Hormonal Diagnostic Process-2","5361","DMI","Diploma In Laboratory","6th Semester");
INSERT INTO subject VALUES("121","Biochemistry-2","5362","DMI","Diploma In Laboratory","6th Semester");
INSERT INTO subject VALUES("122","Virology-2","5363","DMI","Diploma In Laboratory","6th Semester");
INSERT INTO subject VALUES("123","Histopathology & Cytology","5364","DMI","Diploma In Laboratory","6th Semester");
INSERT INTO subject VALUES("124","Systemic Pathology & Forensic Test-2","5365","DMI","Diploma In Laboratory","6th Semester");
INSERT INTO subject VALUES("125","Mycology-2","5366","DMI","Diploma In Laboratory","6th Semester");
INSERT INTO subject VALUES("126","Medical Genetics & Biotechnics Diagnosis-2","5367","DMI","Diploma In Laboratory","6th Semester");
INSERT INTO subject VALUES("127","Basic English Course","1","DMI","Mats","1st Year");
INSERT INTO subject VALUES("128","Basic Computer Science","2","DMI","Mats","1st Year");
INSERT INTO subject VALUES("129","Basic Community Health & Medical Ethics","3","DMI","Mats","1st Year");
INSERT INTO subject VALUES("130","Basic Anatomy & Physiology","4","DMI","Mats","1st Year");
INSERT INTO subject VALUES("131","Basic Pathology & Microbiology","1","DMI","Mats","2nd Year");
INSERT INTO subject VALUES("132","Basic Pharmaology","2","DMI","Mats","2nd Year");
INSERT INTO subject VALUES("133","Basic Medicine & Pendiatrics","1","DMI","Mats","3rd Year");
INSERT INTO subject VALUES("134","Basic Surgery","2","DMI","Mats","3rd Year");
INSERT INTO subject VALUES("135","Basic Gynecology & Obstetrics","3","DMI","Mats","3rd Year");
INSERT INTO subject VALUES("136","Basic Community Medicine & Health Management","4","DMI","Mats","3rd Year");



CREATE TABLE `tblbooks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `BookName` varchar(255) DEFAULT NULL,
  `CategoryName` varchar(255) DEFAULT NULL,
  `CatId` int(11) DEFAULT NULL,
  `AuthorId` int(11) DEFAULT NULL,
  `ISBNNumber` int(11) DEFAULT NULL,
  `BookPrice` int(11) DEFAULT NULL,
  `institute` varchar(255) DEFAULT NULL,
  `RegDate` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;

INSERT INTO tblbooks VALUES("2","Medilab","Medical Book","","","8","200","DMI","2019-01-10 01:03:41");
INSERT INTO tblbooks VALUES("3","A Hand Book of Anatomy","Medical Book","","","10","200","DMI","2019-01-10 01:04:36");
INSERT INTO tblbooks VALUES("4","A Hand Book of Physiology","Medical Book","","","8","200","DMI","2019-01-10 01:05:15");
INSERT INTO tblbooks VALUES("5","A Hand Book of Pharmacology","Medical Book","","","3","200","DMI","2019-01-10 01:06:06");
INSERT INTO tblbooks VALUES("6","A Hand Book of Clinical Pathology","Medical Book","","","5","200","DMI","2019-01-10 01:06:57");
INSERT INTO tblbooks VALUES("7","A Hand Book of Microbiology","Medical Book","","","8","200","DMI","2019-01-10 01:08:01");
INSERT INTO tblbooks VALUES("8","Basic Human Anatomy & Physiology","Medical Book","","","1","200","DMI","2019-01-10 01:18:23");
INSERT INTO tblbooks VALUES("9","Fandamantal of Nursing","Nursing","","","1","200","DMI","2019-01-10 01:20:00");
INSERT INTO tblbooks VALUES("10","Medical Technology Series-2 (Selim Reza)","Laboratory","","","3","200","DMI","2019-01-10 01:22:17");
INSERT INTO tblbooks VALUES("11","Medical Technology Serics-1 (Selim Reza)","Laboratory","","","2","200","DMI","2019-01-10 01:23:04");
INSERT INTO tblbooks VALUES("12","A Guide of Biochemistry (R. K. Agarwala)","Laboratory","","","1","200","DMI","2019-01-10 01:24:16");
INSERT INTO tblbooks VALUES("13","District Laboratory Practice in Tropical Countrics Part- 1 & 2 (Monica Cheesbrough)","Laboratory","","","2","200","DMI","2019-01-10 01:26:07");
INSERT INTO tblbooks VALUES("14","Microbiology & Immunology (Jahir Uddin Mohammed Sha","Laboratory","","","1","200","DMI","2019-01-10 01:28:44");
INSERT INTO tblbooks VALUES("15","Practice of Modern Allopathic Treatment","Medical Book","","","1","200","DMI","2019-01-10 01:29:38");
INSERT INTO tblbooks VALUES("16","Textbook of Community Medicine & Publick Health (Rashid Khabir Hyder)","Medical Book","","","1","200","DMI","2019-01-10 01:32:39");
INSERT INTO tblbooks VALUES("17","Dorland\'s Illustraten Medical Dictionary Twenty-Sixth Edition","Dictionary","","","1","200","DMI","2019-01-10 01:42:26");
INSERT INTO tblbooks VALUES("18","Practical Pathology and Microbiology (prof. K.A.Khaleque,K.Z.Mamun)","Laboratory","","","1","200","DMI","2019-01-10 01:43:55");
INSERT INTO tblbooks VALUES("19","Solution-An Exclusive Written Guide on Pathology & Microbiology","Laboratory","","","1","200","DMI","2019-01-10 01:45:01");
INSERT INTO tblbooks VALUES("20","Community Medicine (Selim Reza)","Medical Book","","","2","200","DMI","2019-01-10 01:46:03");
INSERT INTO tblbooks VALUES("21","Orbit Medical Technology Serics-4","Medical Book","","","1","200","DMI","2019-01-10 01:46:37");
INSERT INTO tblbooks VALUES("22","English-1 (3years Old)","All","","","2","200","DMI","2019-01-10 01:52:40");
INSERT INTO tblbooks VALUES("23","Bangla-1 (3years Old)","All","","","4","200","DMI","2019-01-10 01:53:11");
INSERT INTO tblbooks VALUES("24","Chemistry-1 (3years Old)","All","","","4","200","DMI","2019-01-10 01:53:37");
INSERT INTO tblbooks VALUES("25","Physics-1 (3years Old)","All","","","3","200","DMI","2019-01-10 01:54:09");
INSERT INTO tblbooks VALUES("26","Biology-1 (3years Old)","All","","","3","200","DMI","2019-01-10 01:55:42");
INSERT INTO tblbooks VALUES("27","Microbiology Parasitology First Aid-1","All","","","4","200","DMI","2019-01-10 02:02:52");
INSERT INTO tblbooks VALUES("28","community Medicine","All","","","4","200","DMI","2019-01-10 03:28:51");
INSERT INTO tblbooks VALUES("29","Human Physiology-1 (3years Old)","All","","","4","200","DMI","2019-01-13 01:27:02");
INSERT INTO tblbooks VALUES("30","Human Anatomy-1 (3years Old)","All","","","3","200","DMI","2019-01-13 01:27:33");
INSERT INTO tblbooks VALUES("31","English-2 (3years Old)","All","","","4","200","DMI","2019-01-13 01:28:23");
INSERT INTO tblbooks VALUES("32","Bangla-2 (3years Old)","All","","","4","200","DMI","2019-01-13 01:28:50");
INSERT INTO tblbooks VALUES("33","Biology-2 (3years Old)","All","","","3","200","DMI","2019-01-13 01:29:20");
INSERT INTO tblbooks VALUES("34","Physics-2 (3years Old)","All","","","3","200","DMI","2019-01-13 01:29:54");
INSERT INTO tblbooks VALUES("35","Chemistry-2 (3years Old)","All","","","3","200","DMI","2019-01-13 01:30:36");
INSERT INTO tblbooks VALUES("36","Community Medicine-2 (3years Old)","All","","","4","200","DMI","2019-01-13 01:46:07");
INSERT INTO tblbooks VALUES("37","Microbiology, Parasitology First Aid-2 (3years Old)","All","","","4","200","DMI","2019-01-13 01:47:00");
INSERT INTO tblbooks VALUES("38","Human Anatomy-2 (3years Old)","All","","","4","200","DMI","2019-01-13 01:47:31");
INSERT INTO tblbooks VALUES("39","Human Physiology-2 (3years Old)","All","","","4","200","DMI","2019-01-13 01:47:58");
INSERT INTO tblbooks VALUES("40","Pharmacology-1 (3years Old)","Nursing","","","1","200","DMI","2019-01-13 01:49:31");
INSERT INTO tblbooks VALUES("41","Forensic Medicine (3years Old)","Nursing","","","1","200","DMI","2019-01-13 01:50:10");
INSERT INTO tblbooks VALUES("42","Medical Surgical Nursing-1 (3years Old)","Nursing","","","1","200","DMI","2019-01-13 01:50:37");
INSERT INTO tblbooks VALUES("43","First Aid and Bandaging-1 (3years Old)","Nursing","","","1","200","DMI","2019-01-13 01:51:13");
INSERT INTO tblbooks VALUES("44","Immunization and Nursing-1 (3years Old)","Nursing","","","1","200","DMI","2019-01-13 01:51:58");
INSERT INTO tblbooks VALUES("45","Nursing Arts-1 (3years Old)","Nursing","","","1","200","DMI","2019-01-13 01:52:28");
INSERT INTO tblbooks VALUES("46","First Aid and Bandaging-2 (3years Old)","Nursing","","","1","200","DMI","2019-01-13 01:52:57");
INSERT INTO tblbooks VALUES("47","Medical and Surgical Nursing-2 (3years Old)","Nursing","","","1","200","DMI","2019-01-14 23:30:26");
INSERT INTO tblbooks VALUES("48","Pharmacology-2 (3years Old)","Nursing","","","1","200","DMI","2019-01-14 23:31:03");
INSERT INTO tblbooks VALUES("49","Serology, Immunology and Hormonal Assay-2 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:31:40");
INSERT INTO tblbooks VALUES("50","Clinical Pathology and Haematology-2 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:32:24");
INSERT INTO tblbooks VALUES("51","Virology-2 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:32:47");
INSERT INTO tblbooks VALUES("52","Special Microbiology-2 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:33:19");
INSERT INTO tblbooks VALUES("53","Special Microbiology-1 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:33:54");
INSERT INTO tblbooks VALUES("54","Clinical Chemistry (Special-1) - (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:34:50");
INSERT INTO tblbooks VALUES("55","Biochemistry-1 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:35:18");
INSERT INTO tblbooks VALUES("56","Serology, Immunology, Hormonal Assay-1 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:36:03");
INSERT INTO tblbooks VALUES("57","Laboratory Technique-1 (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:36:42");
INSERT INTO tblbooks VALUES("58","Human Physiology-1 (3years Old)","All","","","1","200","DMI","2019-01-14 23:37:59");
INSERT INTO tblbooks VALUES("59","Human Anatomy-1 (3years Old)","All","","","1","200","DMI","2019-01-14 23:38:23");
INSERT INTO tblbooks VALUES("60","Microbiology Parasitology and First Aid-1 (3years Old)","All","","","1","200","DMI","2019-01-14 23:39:49");
INSERT INTO tblbooks VALUES("61","Community Medicine-1 (3years Old)","All","","","1","200","DMI","2019-01-14 23:40:53");
INSERT INTO tblbooks VALUES("62","Clinical Pathology and Hematology (3years Old)","Laboratory","","","1","200","DMI","2019-01-14 23:42:09");
INSERT INTO tblbooks VALUES("63","Bangla-1 (small Book)","All","","","1","200","DMI","2019-01-14 23:44:02");
INSERT INTO tblbooks VALUES("64","Bangla-2 (small Book)","All","","","1","200","DMI","2019-01-14 23:44:49");
INSERT INTO tblbooks VALUES("65","Anatomy-1 (small Book)","All","","","1","200","DMI","2019-01-14 23:45:33");
INSERT INTO tblbooks VALUES("66","Anatomy-2 (small Book)","All","","","1","200","DMI","2019-01-14 23:45:58");
INSERT INTO tblbooks VALUES("67","Physiology-1 (small Book)","All","","","1","200","DMI","2019-01-14 23:46:24");
INSERT INTO tblbooks VALUES("68","Physiology-2 (small Book)","All","","","1","200","DMI","2019-01-14 23:47:05");
INSERT INTO tblbooks VALUES("69","English-1","All","","","1","200","DMI","2019-01-14 23:47:27");
INSERT INTO tblbooks VALUES("70","English-2 (small Book)","All","","","1","200","DMI","2019-01-14 23:47:50");
INSERT INTO tblbooks VALUES("71","Biology-1 (small Book)","All","","","1","200","DMI","2019-01-14 23:48:17");
INSERT INTO tblbooks VALUES("72","Biology-2 (small Book)","All","","","1","200","DMI","2019-01-14 23:48:41");
INSERT INTO tblbooks VALUES("73","Physics-1 (small Book)","All","","","1","200","DMI","2019-01-14 23:49:03");
INSERT INTO tblbooks VALUES("74","Physics-2 (small Book)","All","","","1","200","DMI","2019-01-14 23:49:21");
INSERT INTO tblbooks VALUES("75","Question (small Book)","All","","","1","200","DMI","2019-01-14 23:49:48");
INSERT INTO tblbooks VALUES("76","Bangal-1 (New 4 years )","All","","","13","200","DMI","2019-01-14 23:50:51");
INSERT INTO tblbooks VALUES("77","English-1 (New 4 years )","All","","","13","200","DMI","2019-01-14 23:51:10");
INSERT INTO tblbooks VALUES("78","Special Medical & Surgical Nursing (3years Old)","Nursing","","","1","200","DMI","2019-01-14 23:55:38");
INSERT INTO tblbooks VALUES("79","Hospital Management (3years Old)","Nursing","","","1","200","DMI","2019-01-14 23:56:14");
INSERT INTO tblbooks VALUES("80","Basic Computer Applications (3years Old)","All","","","1","200","DMI","2019-01-14 23:57:10");
INSERT INTO tblbooks VALUES("81","Basic Electronic (3years Old)","All","","","2","200","DMI","2019-01-14 23:57:39");
INSERT INTO tblbooks VALUES("82","Entrepreneurship (3years Old)","All","","","2","200","DMI","2019-01-14 23:58:16");
INSERT INTO tblbooks VALUES("83","Environmental Science (3years Old)","All","","","2","200","DMI","2019-01-15 00:22:31");
INSERT INTO tblbooks VALUES("84","Basic Pathology & Microbiology - 2nd Year","Mats","","","3","200","DMI","2019-01-15 00:23:14");
INSERT INTO tblbooks VALUES("85","Basic Pharmacology- 2nd Year","Mats","","","3","200","DMI","2019-01-15 00:24:09");
INSERT INTO tblbooks VALUES("86","Basic Anatomy & Pathology - 1st Year","Mats","","","3","200","DMI","2019-01-15 00:24:52");
INSERT INTO tblbooks VALUES("87","Basic Community Health & Medical Ethics- 1st Year","Mats","","","3","200","DMI","2019-01-15 00:25:42");
INSERT INTO tblbooks VALUES("88","Basic Computer Science - 1st Year","Mats","","","8","200","DMI","2019-01-15 00:26:26");
INSERT INTO tblbooks VALUES("89","Basic English Language - 1st Year","Mats","","","4","200","DMI","2019-01-15 00:27:12");
INSERT INTO tblbooks VALUES("90","BTEB Exam Aid-3 (Dr.A.A. Qayyum)","Laboratory","","","1","200","DMI","2019-01-15 00:28:14");
INSERT INTO tblbooks VALUES("91","An Easy Approach to  Communicutive English Grammar","All","","","2","200","DMI","2019-01-15 00:29:14");
INSERT INTO tblbooks VALUES("92","Laboratory Medical (Prime Publication)","Laboratory","","","1","200","DMI","2019-01-15 00:30:07");



CREATE TABLE `tblcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryName` varchar(150) DEFAULT NULL,
  `Status` int(1) DEFAULT NULL,
  `institute` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

INSERT INTO tblcategory VALUES("2","Nursing","1","DMI");
INSERT INTO tblcategory VALUES("3","Dental","1","DMI");
INSERT INTO tblcategory VALUES("4","Laboratory","1","DMI");
INSERT INTO tblcategory VALUES("5","Mats","1","DMI");
INSERT INTO tblcategory VALUES("6","Paramedical","1","DMI");
INSERT INTO tblcategory VALUES("7","Medical Book","1","DMI");
INSERT INTO tblcategory VALUES("8","Job Book","1","DMI");
INSERT INTO tblcategory VALUES("9","Note Book","1","DMI");
INSERT INTO tblcategory VALUES("10","Dictionary","1","DMI");
INSERT INTO tblcategory VALUES("11","All","1","DMI");
INSERT INTO tblcategory VALUES("12","Diploma In Nursing Science and Midwifery","1","DMI");



CREATE TABLE `tblissuedbookdetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studentname` varchar(150) DEFAULT NULL,
  `class` varchar(150) DEFAULT NULL,
  `book` varchar(150) DEFAULT NULL,
  `IssuesDate` date NOT NULL,
  `ReturnDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `RetrunStatus` int(1) NOT NULL,
  `institute` varchar(255) DEFAULT NULL,
  `fine` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




CREATE TABLE `teacher` (
  `teacher_id` int(11) NOT NULL AUTO_INCREMENT,
  `photo` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `birthday` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sex` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `address` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `phone` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `designation` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `institute` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `UserName` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `Password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`teacher_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

INSERT INTO teacher VALUES("24","1997-12-01Samma RaniPassport Pic.jpg","Samma Rani","1997-12-01","Female","Pharpur","01704181565","Office Assistant","DMI","01704181565","01704181565");
INSERT INTO teacher VALUES("25","2013-11-13Munira Shahnaz Chowdhury2016-02-21-13-00-21-485-1.jpg","Munira Shahnaz Chowdhury","2013-11-13","Female","Paharpur, Sadar, Dinajpur","01716844566","Teacher","DMI","01716844566","01716844566");
INSERT INTO teacher VALUES("26","1993-01-10Nihar Ranjan RoyNihar1028.jpg","Nihar Ranjan Roy","1993-01-10","Male","Maldhopotty, Dinajpur","01738374366","Librarian","DMI","01738374366","01738374366");
INSERT INTO teacher VALUES("27","01760306501Samma RaniRani.jpg","Samma Rani","1992-01-01","Male","Maldhopotty, Dinajpur","01760306501","Office Assistant","BNI","01761316501","61316501");
INSERT INTO teacher VALUES("28","01747060254Samima Akter Samima.jpg","Samima Akter ","1989-02-23","Female","Maldhopotty, Dinajpur","01747060254","Teacher","DMI","01747060254","60254");
INSERT INTO teacher VALUES("29","1973-06-30Md. Nurul AminaminId.jpg","Md. Nurul Amin","1973-06-30","Male","Maldhopotty, Dinajpur","01714570095","Accountant","DMI","01714570095","0095");
INSERT INTO teacher VALUES("30","1973-06-30Md. Nurul AminaminId.jpg","Md. Nurul Amin","1973-06-30","Male","Maldhopotty, Dinajpur","01714570095","Accountant","BNI","01704181564","81564");


