-- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Feb 28, 2019 at 06:05 PM -- Server version: 10.1.13-MariaDB -- PHP Version: 5.5.37 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `postmanagement` -- -- -------------------------------------------------------- -- -- Table structure for table `application` -- CREATE TABLE `application` ( `id` int(255) NOT NULL, `app_id` varchar(10) DEFAULT NULL, `name` varchar(255) NOT NULL, `fname` varchar(255) NOT NULL, `vname` varchar(255) NOT NULL, `phone` varchar(15) NOT NULL, `nid` varchar(30) NOT NULL, `scancopy` text NOT NULL, `date` varchar(150) NOT NULL, `sms2_date` varchar(150) DEFAULT NULL, `out_date` varchar(150) DEFAULT NULL, `day` varchar(255) NOT NULL, `sms1` text, `sms2` text, `comment` text, `status` int(2) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `application` -- INSERT INTO `application` (`id`, `app_id`, `name`, `fname`, `vname`, `phone`, `nid`, `scancopy`, `date`, `sms2_date`, `out_date`, `day`, `sms1`, `sms2`, `comment`, `status`) VALUES (1, 'A191111111', 'Amina Khatun', 'Abul Hossain', 'Amira Bari', '01776403419', '01999345217600080', 'is.jpg', 'February 11, 2019, 03:19:16', 'February 11, 2019, 06:19:41', 'February 11, 2019, 06:32:11', '737006', NULL, NULL, 'Right', 3), (2, 'A192222222', 'Al Kauser', 'Abul Hossain', 'Amira Bari', '01776403419', '019993452176000876', 'Capture.PNG', 'February 11, 2019, 03:21:33', 'February 11, 2019, 05:43:58', 'February 11, 2019, 16:15:43', '737006', NULL, NULL, 'ljlkjl', 4), (3, 'A193333333', 'Manuara Begum', 'Hossen Ali', 'narionpur', '01776403419', '019993452176000878', 'is.jpg', 'February 11, 2019, 03:22:07', 'February 11, 2019, 05:43:34', 'February 11, 2019, 16:14:45', '737006', NULL, NULL, 'khkjkj', 3), (4, 'A194444444', 'Mahim', 'Kobir', 'Amira Bari', '01776403419', '019993452176000879', 'is.jpg', 'February 11, 2019, 03:23:18', 'February 11, 2019, 05:43:04', 'February 11, 2019, 06:16:59', '737006', NULL, NULL, 'Rejected', 4), (5, 'A195555555', 'Sabbir', 'Dono', 'Amira Bari', '01776403419', '019993452176000877', 'is.jpg', 'February 11, 2019, 03:24:08', 'February 11, 2019, 05:42:24', 'February 11, 2019, 16:42:54', '737006', NULL, NULL, 'k;lk', 3), (6, 'A196666666', 'Al Kauser', 'Abul Hossain', 'Amira Bari', '01776403419', '01999345217600090', 'is.jpg', 'February 11, 2019, 03:25:01', 'February 11, 2019, 05:41:39', 'February 11, 2019, 06:11:33', '737006', NULL, NULL, 'This Application is right.', 3), (7, 'A197777777', 'Amina Khatun', 'Abul Hossain', 'Amira Bari', '01776403419', '01999345217600080', 'Capture.PNG', 'February 11, 2019, 06:38:13', 'February 11, 2019, 16:07:15', 'February 11, 2019, 16:33:11', '737006', NULL, NULL, ';kpo', 4), (8, 'A198888888', 'Amina Khatun', 'Amina', 'Amira Bari', '01776403419', '01999345217600080', 'is.jpg', 'February 11, 2019, 16:21:26', 'February 11, 2019, 16:21:48', 'February 11, 2019, 16:25:57', '737006', NULL, NULL, 'lkk', 4), (9, 'A199999999', 'Amina Khatun', 'Amina', 'Amira Bari', '01776403419', '01999345217600080', 'is.jpg', 'February 11, 2019, 16:43:52', 'February 11, 2019, 16:47:47', 'February 11, 2019, 16:49:41', '737006', NULL, NULL, ';k;lk', 4), (10, 'A190101010', 'Al Kauser', 'Amina', 'Amira Bari', '01776403419', '01999345217600080', 'is.jpg', 'ফেব্রুয়ারী ২১, ২০১৯, ৪:০৫ pm', 'February 11, 2019, 16:45:16', NULL, '737006', NULL, NULL, NULL, 2), (11, 'A000011', 'Amina Khatun', 'Abul Hossain', 'Amira Bari', '01776403419', '01999345217600080', 'is.jpg', 'February 12, 2019, 05:00:45', NULL, NULL, '737007', NULL, NULL, NULL, 1), (12, '000012', 'Amina Khatun', 'ৃুা্ত', 'Amira Bari', '০১৭৭৬৪০৩৪১৯', '', 'testpdf.pdf', 'February 21, 2019, 3:50 pm', 'ফেব্রুয়ারী ২২, ২০১৯, ৫:৩২ am', 'ফেব্রুয়ারী ২৫, ২০১৯, ১১:০৫:২০ এএম', '737016', NULL, NULL, 'fgfdg', 4), (13, '০০০০১৩', 'Amina Khatun', 'Amina', 'Amira Bari', '০১৭৭৬৪০৩৪১৯', '01999345217600080', 'testpdf.pdf', 'ফেব্রুয়ারী ২১, ২০১৯, ৪:০৫ pm', 'February 22, 2019, 5:16 am', 'ফেব্রুয়ারী ২২, ২০১৯, ১২:০৪:০৩ পিএম', '737016', NULL, NULL, 'Rejected', 2), (14, '০০০০১৪', 'Amina Khatun', 'Amina', 'Amira Bari', '০১৭৭৬৪০৩৪১৯', '01999345217600080', 'testpdf.pdf', 'ফেব্রুয়ারী ২২, ২০১৯, ৮:১৪ am', NULL, NULL, '737017', NULL, NULL, NULL, 1), (15, '০০০০১৫', 'Amina Khatun', 'Amina', 'Amira Bari', '০১৭৭৬৪০৩৪১৯', '01999345217600080', 'testpdf.pdf', 'ফেব্রুয়ারী ২২, ২০১৯, ০৮:২৮:১২ এএম', 'ফেব্রুয়ারী ২৫, ২০১৯, ১০:৪৫:৫৭ এএম', 'ফেব্রুয়ারী ২৫, ২০১৯, ১১:০৫:০১ এএম', '737017', NULL, NULL, 'fdhgf', 3), (16, '০০০০১৬', 'আমিন খাতুন', 'আবুল হোসেন', 'আমিরা বারী', '০১৭৭৬৪০৩৪১৯', '১৩২৪৮৬৭৯৮৫৯ ', 'scancopy/testpdf.pdf', 'ফেব্রুয়ারী ২৩, ২০১৯, ০৪:১৫:৪০ এএম', NULL, NULL, '737018', NULL, NULL, NULL, 1), (17, '০০০০১৭', 'Amina Khatun', 'Abul', 'Amira Bari', '01776403419', 'uiyuiy', 'scancopy/testpdf.pdf', 'ফেব্রুয়ারী ২৫, ২০১৯, ০৯:৪৯:৪৯ এএম', NULL, NULL, '737020', NULL, NULL, NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `processing` -- CREATE TABLE `processing` ( `id` int(255) NOT NULL, `department` varchar(255) NOT NULL, `application_id` int(255) NOT NULL, `comment` varchar(255) DEFAULT NULL, `in_date` varchar(150) DEFAULT NULL, `out_date` varchar(150) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '2' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `processing` -- INSERT INTO `processing` (`id`, `department`, `application_id`, `comment`, `in_date`, `out_date`, `status`) VALUES (2, 'Fish', 6, 'Done', 'February 11, 2019, 05:41:39', 'February 11, 2019, 05:49:41', 0), (3, 'Fish', 5, 'ljlkjkl', 'February 11, 2019, 05:42:24', 'February 11, 2019, 16:25:04', 0), (4, 'CSE', 5, 'Right', 'February 11, 2019, 05:42:24', 'February 11, 2019, 06:13:09', 0), (5, 'Fish', 4, 'This project has some error', 'February 11, 2019, 05:43:04', 'February 11, 2019, 05:49:25', 0), (6, 'CSE', 4, 'Right', 'February 11, 2019, 05:43:04', 'February 11, 2019, 06:13:20', 0), (7, 'Farmer', 4, 'Ok', 'February 11, 2019, 05:43:04', 'February 11, 2019, 06:14:25', 0), (8, 'Farmer', 3, 'Ok', 'February 11, 2019, 05:43:34', 'February 11, 2019, 06:14:33', 0), (9, 'CSE', 2, 'Right', 'February 11, 2019, 05:43:58', 'February 11, 2019, 06:13:31', 0), (10, 'Fish', 1, 'Complete the task.', 'February 11, 2019, 06:19:41', 'February 11, 2019, 06:21:52', 0), (11, 'CSE', 1, 'ok', 'February 11, 2019, 06:19:41', 'February 11, 2019, 06:27:55', 0), (12, 'Farmer', 1, 'ok', 'February 11, 2019, 06:19:41', 'February 11, 2019, 06:28:32', 0), (13, 'Fish', 7, 'l;'',', 'February 11, 2019, 16:07:15', 'February 11, 2019, 16:24:58', 0), (14, 'CSE', 7, 'hk', 'February 11, 2019, 16:07:15', 'February 11, 2019, 16:24:32', 0), (15, 'Farmer', 7, 'jmb', 'February 11, 2019, 16:07:15', 'February 11, 2019, 16:25:35', 0), (16, 'Fish', 8, 'ljlk', 'February 11, 2019, 16:21:48', 'February 11, 2019, 16:24:50', 0), (17, 'CSE', 8, ';k;', 'February 11, 2019, 16:21:48', 'February 11, 2019, 16:24:26', 0), (18, 'Farmer', 8, 'ljlk', 'February 11, 2019, 16:21:48', 'February 11, 2019, 16:25:28', 0), (19, 'Fish', 10, 'khk', 'February 11, 2019, 16:45:16', 'February 11, 2019, 16:48:55', 2), (20, 'CSE', 10, 'kjnkj', 'February 11, 2019, 16:45:16', 'February 11, 2019, 16:49:16', 2), (21, 'Farmer', 10, NULL, 'February 11, 2019, 16:45:16', NULL, 2), (22, 'CSE', 9, 'kkjkj', 'February 11, 2019, 16:47:47', 'February 11, 2019, 16:49:23', 0), (23, 'CSE', 13, 'এই আবেদন সম্পূর্ণ।', 'February 22, 2019, 5:16 am', 'ফেব্রুয়ারী ২২, ২০১৯, ০৯:৪২:১৫ এএম', 0), (24, 'CSE', 12, 'scancopy/testpdf.pdf', 'ফেব্রুয়ারী ২২, ২০১৯, ৫:৩২ am', 'ফেব্রুয়ারী ২৩, ২০১৯, ০৫:৩৫:৪৫ এএম', 0), (25, 'CSE', 19, 'scancopy/capture.PNG', 'ফেব্রুয়ারী ২৫, ২০১৯, ১০:৪৪:৩৬ এএম', 'ফেব্রুয়ারী ২৫, ২০১৯, ১১:০৩:৩০ এএম', 0), (26, 'CSE', 15, 'scancopy/testpdf.pdf', 'ফেব্রুয়ারী ২৫, ২০১৯, ১০:৪৫:৫৭ এএম', 'ফেব্রুয়ারী ২৫, ২০১৯, ১১:০৩:৫৫ এএম', 0); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(10) NOT NULL, `name` varchar(255) NOT NULL, `job_id` varchar(255) NOT NULL, `nid` varchar(255) NOT NULL, `department` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `status` int(1) NOT NULL DEFAULT '2' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `name`, `job_id`, `nid`, `department`, `username`, `password`, `email`, `status`) VALUES (1, ' MD. Nazrul Islam', '12102011', '', 'ইউএনও', 'nazrul', '1be3c6b5740709e02dbbc3d52cc0b787', 'mieclab21@gmail.com', 1), (2, 'Murad Hassan Tanvir', '12102019', '01999345217600080', 'Fish', 'murad', '76ae3ce0585ca0051126fd844cefbb30', 'tanvir.cse0906@gmail.com', 2), (3, 'Amina Khatun', '12102014', '19936119413000105', 'CSE', 'amina', 'bd82dd2a8b944f131d0a53bc1b473029', 'amina.cse.trishal@gmail.com', 2), (4, 'Al Kauser', '12102015', '019993452176000876', 'Farmer', 'kauser', 'f6368a828503720d7207b6bfa2e6c897', 'alkauser01@gmail.com', 2), (7, 'Arifa', '১২১০২০১০', '০১৯৯৯৩৪৫২১৭৬০০০৮৭৬', 'করণিক', 'arifa', 'be5f0c2d70d900bd491123d7b1eac072', 'aminakhatun617@gmail.com', 3); -- -- Indexes for dumped tables -- -- -- Indexes for table `application` -- ALTER TABLE `application` ADD PRIMARY KEY (`id`); -- -- Indexes for table `processing` -- ALTER TABLE `processing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `password` (`password`), ADD UNIQUE KEY `nid` (`nid`), ADD UNIQUE KEY `job_id` (`job_id`), ADD UNIQUE KEY `email` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `application` -- ALTER TABLE `application` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `processing` -- ALTER TABLE `processing` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;