-- phpMyAdmin SQL Dump -- version 4.9.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Feb 05, 2023 at 10:01 PM -- Server version: 10.5.16-MariaDB -- PHP Version: 7.3.32 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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: `id20254435_pems` -- -- -------------------------------------------------------- -- -- Table structure for table `adminlogin` -- CREATE TABLE `adminlogin` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `adminlogin` -- INSERT INTO `adminlogin` (`id`, `username`, `password`) VALUES (1, 'admin', 'admin'); -- -------------------------------------------------------- -- -- Table structure for table `demo` -- CREATE TABLE `demo` ( `smatric` int(6) NOT NULL, `subtotal` varchar(5) DEFAULT NULL, `subtotal1` varchar(5) DEFAULT NULL, `subtotal2` varchar(5) DEFAULT NULL, `subtotal3` varchar(5) DEFAULT NULL, `subtotal4` varchar(5) DEFAULT NULL, `subtotal5` varchar(5) DEFAULT NULL, `subtotal6` varchar(5) DEFAULT NULL, `subtotal7` varchar(5) DEFAULT NULL, `subtotal8` varchar(5) DEFAULT NULL, `subtotal9` varchar(5) DEFAULT NULL, `subtotal10` varchar(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `demo` -- INSERT INTO `demo` (`smatric`, `subtotal`, `subtotal1`, `subtotal2`, `subtotal3`, `subtotal4`, `subtotal5`, `subtotal6`, `subtotal7`, `subtotal8`, `subtotal9`, `subtotal10`) VALUES (199945, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (273651, '', '', '', '', '', '', '', '', '', '', ''), (280490, '', '', '', '', '', '', '', '', '', '', ''), (280725, '', '', '', '', '', '', '', '', '', '', ''), (281016, '', '', '', '', '', '', '', '', '', '', ''), (281032, '', '', '', '', '', '', '', '', '', '', ''), (281058, '', '', '', '', '', '', '', '', '', '', ''), (281352, '', '', '', '', '', '', '', '', '', '', ''), (281916, '3.33', '1.25', '1.00', '0.00', '0.67', '0.60', '0.25', '0.67', '1.00', '1.43', '2.00'), (281918, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (281999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (282108, '', '', '', '', '', '', '', '', '', '', ''), (282133, '', '', '', '', '', '', '', '', '', '', ''), (282428, '', '', '', '', '', '', '', '', '', '', ''), (282848, '', '', '', '', '', '', '', '', '', '', ''), (282932, '', '', '', '', '', '', '', '', '', '', ''), (282993, '', '', '', '', '', '', '', '', '', '', ''), (283106, '', '', '', '', '', '', '', '', '', '', ''), (283149, '', '', '', '', '', '', '', '', '', '', ''), (283605, '', '', '', '', '', '', '', '', '', '', ''), (283879, '', '', '', '', '', '', '', '', '', '', ''), (284360, '', '', '', '', '', '', '', '', '', '', ''), (284396, '', '', '', '', '', '', '', '', '', '', ''), (284502, '', '', '', '', '', '', '', '', '', '', ''), (284629, '', '', '', '', '', '', '', '', '', '', ''), (284851, '', '', '', '', '', '', '', '', '', '', ''), (284950, '', '', '', '', '', '', '', '', '', '', ''), (285137, '', '', '', '', '', '', '', '', '', '', ''), (285257, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (285648, '', '', '', '', '', '', '', '', '', '', ''), (285690, '', '', '', '', '', '', '', '', '', '', ''), (285896, '', '', '', '', '', '', '', '', '', '', ''), (286260, '', '', '', '', '', '', '', '', '', '', ''), (286261, '', '', '', '', '', '', '', '', '', '', ''), (286411, '', '', '', '', '', '', '', '', '', '', ''), (286560, '', '', '', '', '', '', '', '', '', '', ''), (286716, '', '', '', '', '', '', '', '', '', '', ''), (287029, '', '', '', '', '', '', '', '', '', '', ''), (287220, '', '', '', '', '', '', '', '', '', '', ''), (287229, '1.11', '1.25', '0.00', '1.88', '0.17', '0.60', '0.38', '0.67', '1.00', '1.43', '2.00'), (287237, '', '', '', '', '', '', '', '', '', '', ''), (287446, '', '', '', '', '', '', '', '', '', '', ''), (287910, '', '', '', '', '', '', '', '', '', '', ''), (288115, '1.11', '1.25', '1.00', '2.50', '0.00', '1.20', '1.00', '0.00', '1.33', '1.43', '2.00'), (288135, '', '', '', '', '', '', '', '', '', '', ''), (288366, '', '', '', '', '', '', '', '', '', '', ''), (288401, '4.44', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00'), (288408, '', '', '', '', '', '', '', '', '', '', ''), (288410, '', '', '', '', '', '', '', '', '', '', ''), (288519, '4.44', '10.00', '3.00', '10.00', '0.67', '3.00', '0.50', '0.00', '0.00', '0.00', '0.00'), (288971, '', '', '', '', '', '', '', '', '', '', ''), (289111, '', '', '', '', '', '', '', '', '', '', ''), (289172, '', '', '', '', '', '', '', '', '', '', ''), (289472, '', '', '', '', '', '', '', '', '', '', ''), (289546, '', '', '', '', '', '', '', '', '', '', ''), (289902, '', '', '', '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `democom` -- CREATE TABLE `democom` ( `smatric` int(6) NOT NULL, `subtotal` varchar(5) DEFAULT NULL, `subtotal1` varchar(5) DEFAULT NULL, `subtotal2` varchar(5) DEFAULT NULL, `subtotal3` varchar(5) DEFAULT NULL, `subtotal4` varchar(5) DEFAULT NULL, `subtotal5` varchar(5) DEFAULT NULL, `subtotal6` varchar(5) DEFAULT NULL, `subtotal7` varchar(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `democom` -- INSERT INTO `democom` (`smatric`, `subtotal`, `subtotal1`, `subtotal2`, `subtotal3`, `subtotal4`, `subtotal5`, `subtotal6`, `subtotal7`) VALUES (199945, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (273651, '', '', '', '', '', '', '', ''), (280490, '', '', '', '', '', '', '', ''), (280725, '', '', '', '', '', '', '', ''), (281016, '', '', '', '', '', '', '', ''), (281032, '', '', '', '', '', '', '', ''), (281058, '', '', '', '', '', '', '', ''), (281352, '', '', '', '', '', '', '', ''), (281916, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (281918, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (281999, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (282108, '', '', '', '', '', '', '', ''), (282133, '', '', '', '', '', '', '', ''), (282428, '', '', '', '', '', '', '', ''), (282848, '', '', '', '', '', '', '', ''), (282932, '', '', '', '', '', '', '', ''), (282993, '', '', '', '', '', '', '', ''), (283106, '', '', '', '', '', '', '', ''), (283149, '', '', '', '', '', '', '', ''), (283605, '', '', '', '', '', '', '', ''), (283879, '', '', '', '', '', '', '', ''), (284360, '', '', '', '', '', '', '', ''), (284396, '', '', '', '', '', '', '', ''), (284502, '', '', '', '', '', '', '', ''), (284629, '', '', '', '', '', '', '', ''), (284851, '', '', '', '', '', '', '', ''), (284950, '', '', '', '', '', '', '', ''), (285137, '', '', '', '', '', '', '', ''), (285257, '4.00', '4.00', '3.00', '2.00', '4.00', '3.00', '7.78', '2.50'), (285648, '', '', '', '', '', '', '', ''), (285690, '', '', '', '', '', '', '', ''), (285896, '', '', '', '', '', '', '', ''), (286260, '', '', '', '', '', '', '', ''), (286261, '', '', '', '', '', '', '', ''), (286411, '', '', '', '', '', '', '', ''), (286560, '', '', '', '', '', '', '', ''), (286716, '', '', '', '', '', '', '', ''), (287029, '', '', '', '', '', '', '', ''), (287220, '', '', '', '', '', '', '', ''), (287229, '4.00', '4.00', '3.00', '2.88', '4.00', '3.00', '10.00', '9.38'), (287237, '', '', '', '', '', '', '', ''), (287446, '', '', '', '', '', '', '', ''), (287910, '', '', '', '', '', '', '', ''), (288115, '', '', '', '', '', '', '', ''), (288135, '', '', '', '', '', '', '', ''), (288366, '', '', '', '', '', '', '', ''), (288401, '3.00', '4.00', '3.00', '3.00', '2.67', '3.00', '10.00', '10.00'), (288408, '', '', '', '', '', '', '', ''), (288410, '', '', '', '', '', '', '', ''), (288519, '', '', '', '', '', '', '', ''), (288971, '', '', '', '', '', '', '', ''), (289111, '', '', '', '', '', '', '', ''), (289172, '', '', '', '', '', '', '', ''), (289472, '', '', '', '', '', '', '', ''), (289546, '', '', '', '', '', '', '', ''), (289902, '', '', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `tbl_comsup` -- CREATE TABLE `tbl_comsup` ( `user_id` int(10) NOT NULL, `com_email` varchar(100) NOT NULL, `user_name` varchar(100) NOT NULL, `user_number` varchar(20) NOT NULL, `user_pass` varchar(40) NOT NULL, `user_staffid` varchar(10) NOT NULL, `comname` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_comsup` -- INSERT INTO `tbl_comsup` (`user_id`, `com_email`, `user_name`, `user_number`, `user_pass`, `user_staffid`, `comname`) VALUES (24, 'raydemo@gmail.com', 'raydemo', '654321', '3c8db6101331f4394651499dcf0f04b91cdcb6cf', 'E1259', 'JGC (Malaysia) Sdn. Bhd.'), (25, 'ray1@gmail.com', 'Rayhan', '0459632147', '90af5f034f71bdf5149d885d94636f37bf04f3cc', 'E5655', 'SOC'), (26, 'shi@gmail.com', 'Shimul', '045963215', 'a01cfc813b2a5c299b8871035cf553b25866d016', '546378', 'SOC'), (27, 'rays1@gmail.com', 'Rayhan', '0459632147', '90af5f034f71bdf5149d885d94636f37bf04f3cc', 'E5678', 'SOC'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_tutors` -- CREATE TABLE `tbl_tutors` ( `tutor_id` int(5) NOT NULL, `smatric` int(6) NOT NULL, `tutor_name` varchar(50) NOT NULL, `tutor_email` varchar(50) NOT NULL, `tutor_phone` varchar(15) NOT NULL, `eva` varchar(10) DEFAULT NULL, `eva1` varchar(10) DEFAULT NULL, `suumsup` varchar(200) NOT NULL, `user_email` varchar(100) NOT NULL, `scompany` varchar(250) NOT NULL, `scomsup` varchar(100) NOT NULL, `com_email` varchar(100) NOT NULL, `sproname` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_tutors` -- INSERT INTO `tbl_tutors` (`tutor_id`, `smatric`, `tutor_name`, `tutor_email`, `tutor_phone`, `eva`, `eva1`, `suumsup`, `user_email`, `scompany`, `scomsup`, `com_email`, `sproname`) VALUES (1, 287910, 'Keely', 'keely816@yahoo.com', '985-4932', NULL, NULL, 'Prof. Madya Dr. Azman B Yasin', 'yazman@uum.edu.my', 'Lacus Ut Industries', 'Guy', 'guy3707@hotmail.com', 'Image encryption using the AES algorithm'), (2, 287237, 'Victor', 'victor@yahoo.com', '131-6201', NULL, NULL, 'Prof. Madya Dr. Fauziah Bt Baharom', 'fauziah@uum.edu.my', 'Montes Nascetur Ridiculus Associates', 'Perry', 'perry@gmail.com', 'Weather forecasting system'), (3, 284360, 'Georgia', 'georgia@hotmail.com', '780-0613', NULL, NULL, 'Prof. Madya Dr. Haslina Bt Mohd', 'haslina@uum.edu.my', 'Lorem Company', 'Callie', 'callie7294@icloud.com', 'Smart health prediction system'), (4, 288971, 'Channing', 'channing288@gmail.com', '871-2482', NULL, NULL, 'Prof. Madya Dr. Husniza binti Husni', 'husniza@uum.edu.my', 'Lorem Ac Institute', 'Chastity', 'chastity2908@gmail.com', 'e-Learning platform'), (5, 280725, 'Asher', 'asher@hotmail.com', '391-3947', NULL, NULL, 'Prof. Madya Dr. Mazida Binti Ahmad', 'mazida@uum.edu.my', 'Amet Ante Limited', 'Samson', 'samson@yahoo.com', 'Credit card fraud detection'), (6, 284629, 'Ivana', 'ivana@yahoo.com', '757-5585', NULL, NULL, 'Prof. Madya Dr. Mohd Khairudin Bin Kasiran', 'mkasiran@uum.edu.my', 'Malesuada Malesuada Foundation', 'Kelly', 'kelly@gmail.com', 'Weather forecasting system'), (7, 281032, 'Clarke', 'clarke@hotmail.com', '454-6504', NULL, NULL, 'Prof. Madya Ts. Dr. Mohd. Hasbullah bin Omar', 'mhomar@uum.edu.my', 'Tellus Imperdiet Institute', 'Whoopi', 'whoopi@icloud.com', 'Camera motion sensor system'), (8, 285896, 'Tate', 'tate@yahoo.com', '466-1251', NULL, NULL, 'Prof. Madya Ts. Dr. Muhamad Shahbani bin Abu Bakar', 'shahbani@uum.edu.my', 'Nec Ante Corporation', 'Cooper', 'cooper@hotmail.com', 'Android Patient Tracker'), (9, 286261, 'Quinn', 'quinn8596@yahoo.com', '568-3138', NULL, NULL, 'Prof. Madya Dr. Roshidi bin Din', 'roshidi@uum.edu.my\r\n', 'Sed Consequat Associates', 'Maggy', 'maggy@yahoo.com', 'Image encryption using the AES algorithm'), (10, 283879, 'Cole', 'cole@hotmail.com', '623-9348', NULL, NULL, 'Prof. Madya Dr. Shahrul Azmi bin Mohd. Yusof', 'shahrulazmi@uum.edu.my', 'Aliquet Proin Company', 'Amery', 'amery@gmail.com', 'Face detector'), (11, 285648, 'Charles', 'charles581@yahoo.com', '175-2684', NULL, NULL, 'Prof. Madya Dr. Siti Sakira Binti Kamaruddin', 'sakira@uum.edu.my\r\n\r\n', 'Bibendum Inc.', 'Nigel', 'nigel@icloud.com', 'Image encryption using the AES algorithm'), (12, 288366, 'Lyle', 'lyle@icloud.com', '253-3284', NULL, NULL, 'Prof. Madya Dr. Yuhanis binti Yusof', 'yuhanis@uum.edu.my', 'Eget Odio Foundation', 'Rinah', 'rinah8603@gmail.com', 'Sentiment analysis for product rating'), (13, 287446, 'Philip', 'philip2957@icloud.com', '852-6274', NULL, NULL, 'Prof. Madya Ts. Dr. Norliza Katuk', 'k.norliza@uum.edu.my\r\n\r\n', 'Viverra Maecenas Iaculis LLC', 'Risa', 'risa3813@hotmail.com', 'Credit card fraud detection'), (14, 286716, 'Kirk', 'kirk@yahoo.com', '310-1736', NULL, NULL, 'Prof. Madya Nor Iadah Yusop', 'noriadah@uum.edu.my', 'Cursus Diam At Corporation', 'Uma', 'uma9442@gmail.com', 'Automated payroll system with GPS tracking and image capture'), (15, 282993, 'Maxine', 'maxine@icloud.com', '313-8954', NULL, NULL, 'Prof. Madya. Ts Dr. Azman Ta\'a', 'azman@uum.edu.my', 'Egestas Rhoncus Foundation', 'Bradley', 'bradley@icloud.com', 'Camera motion sensor system'), (16, 282108, 'Nerea', 'nerea4566@icloud.com', '405-0141', NULL, NULL, 'Prof. Madya. Dr. Massudi Mahmuddin', 'ady@uum.edu.my', 'Gravida Inc.', 'Colette', 'colette@yahoo.com', 'Android task monitoring'), (17, 288408, 'Nathaniel', 'nathaniel5837@gmail.com', '645-6087', NULL, NULL, 'Prof. Madya. Dr. Nur Haryani Zakaria', 'haryani@uum.edu.my', 'Neque Nullam Industries', 'Charissa', 'charissa9299@icloud.com', 'Chatbots'), (18, 289172, 'Cullen', 'cullen@hotmail.com', '935-8257', NULL, NULL, 'Prof. Madya. Dr. Rohaida Romli', 'aida@uum.edu.my', 'Non Lacinia At Incorporated', 'Magee', 'magee493@icloud.com', 'Image encryption using the AES algorithm'), (19, 289546, 'Melissa', 'melissa@gmail.com', '680-5934', NULL, NULL, '', 'mazni@uum.edu.my', 'Mauris Ipsum Porta Inc.', 'Thomas', 'thomas5412@hotmail.com', 'Voice Recognition'), (20, 283605, 'Inez', 'inez6080@gmail.com', '224-7636', NULL, NULL, 'Prof. Madya Ts. Dr. Mohamad Fadli bin Zolkipli', 'm.fadli.zolkipli@uum.edu.my', 'Vestibulum Ante Ipsum Incorporated', 'Rina', 'rina9838@hotmail.com', 'AI shopping system'), (21, 287029, 'Lyle', 'lyle6500@icloud.com', '933-6404', NULL, NULL, 'Prof. Madya. Ts. Dr. Nor Laily Hashim', 'laily@uum.edu.my', 'Vivamus Associates', 'Leilani', 'leilani@yahoo.com', 'Chatbots'), (22, 281058, 'Allen', 'allen5499@gmail.com', '716-6588', NULL, NULL, 'Prof. Madya. Dr. Zahurin Mat Aji @ Akon', 'zahurin@uum.edu.my', 'Pellentesque Habitant Morbi Inc.', 'Kevin', 'kevin9662@icloud.com', 'AI shopping system'), (23, 282428, 'Chadwick', 'chadwick4306@yahoo.com', '446-3434', NULL, NULL, 'Prof. Madya. Dr. Rahayu Ahmad', 'rahayu@uum.edu.my', 'Laoreet Inc.', 'Jameson', 'jameson6599@gmail.com', 'Android task monitoring'), (24, 285137, 'Jordan', 'jordan2668@yahoo.com', '263-1661', NULL, NULL, '\r\nProf. Madya. Ts. Dr. Maslinda Mohd Nadzir\r\n', 'maslinda@uum.edu.my', 'Sed Libero Limited', 'Julian', 'julian@gmail.com', 'Data leakage detection system'), (25, 284396, 'Hiroko', 'hiroko4924@hotmail.com', '282-2223', NULL, NULL, 'Prof. Madya. Ts. Dr. Nor Hazlyna Harun', 'hazlyna@uum.edu.my', 'Amet Corp.', 'Heather', 'heather@hotmail.com', 'Railway tracking and arrival time prediction system'), (26, 284950, 'Anjolie', 'anjolie@yahoo.com', '957-7052', NULL, NULL, '', '', 'Est Ac Institute', 'Brenna', 'brenna5114@hotmail.com', 'Camera motion sensor system'), (27, 281352, 'Ayanna', 'ayanna@gmail.com', '263-3688', NULL, NULL, '', '', 'Nisi Magna Sed Associates', 'Melvin', 'melvin@yahoo.com', 'Data leakage detection system'), (28, 286560, 'Michelle', 'michelle7829@yahoo.com', '884-4491', NULL, NULL, '', '', 'Gravida Mauris Ut Ltd', 'Giacomo', 'giacomo7780@gmail.com', 'Weather forecasting system'), (29, 288135, 'Aaron', 'aaron7643@icloud.com', '232-7836', NULL, NULL, '', '', 'Nunc Sollicitudin Limited', 'Jesse', 'jesse9711@icloud.com', 'Automated payroll system with GPS tracking and image capture'), (30, 289902, 'Kimberly', 'kimberly33@hotmail.com', '638-8679', NULL, NULL, '', '', 'Ut Sem Corp.', 'Shafira', 'shafira6281@yahoo.com', 'Smart health prediction system'), (31, 289111, 'Emmanuel', 'emmanuel@icloud.com', '171-2346', NULL, NULL, '', '', 'Pede Ltd', 'Rae', 'rae4652@hotmail.com', 'Data leakage detection system'), (32, 286411, 'Unity', 'unity8406@hotmail.com', '311-5764', NULL, NULL, '', '', 'Amet Dapibus Id Industries', 'Ignacia', 'ignacia@gmail.com', 'Image encryption using the AES algorithm'), (33, 286260, 'Daniel', 'daniel2800@yahoo.com', '578-7304', NULL, NULL, '', '', 'Ultrices Mauris Ipsum Ltd', 'Murphy', 'murphy@yahoo.com', 'Software piracy protection system'), (34, 287220, 'Jemima', 'jemima6179@yahoo.com', '940-3789', NULL, NULL, '', '', 'Ullamcorper Eu Ltd', 'Alfonso', 'alfonso@hotmail.com', ''), (35, 285690, 'Nehru', 'nehru@gmail.com', '392-3726', NULL, NULL, '', '', 'Risus Associates', 'Remedios', 'remedios@icloud.com', 'Fingerprint-based ATM system'), (36, 283149, 'Indigo', 'indigo@icloud.com', '728-3142', NULL, NULL, '', '', 'Non Sapien Molestie Industries', 'Hall', 'hall7126@yahoo.com', 'Android task monitoring'), (37, 281016, 'Rebekah', 'rebekah@icloud.com', '521-2844', NULL, NULL, '', '', 'Arcu Industries', 'Ori', 'ori6876@hotmail.com', 'Face detector'), (38, 284502, 'Carla', 'carla4706@yahoo.com', '172-6286', NULL, NULL, '', '', 'Iaculis LLP', 'Sasha', 'sasha@gmail.com', 'Chatbots'), (39, 282932, 'Bruno', 'bruno@yahoo.com', '623-6561', NULL, NULL, '', '', 'Risus Ltd', 'Lionel', 'lionel2688@icloud.com', 'Automated payroll system with GPS tracking and image capture'), (40, 282848, 'Trevor', 'trevor@hotmail.com', '236-2818', NULL, NULL, '', '', 'Aliquet Diam Sed Corporation', 'Isaiah', 'isaiah4000@yahoo.com', 'Data leakage detection system'), (41, 289472, 'Dorian', 'dorian8687@yahoo.com', '497-5725', NULL, NULL, '', '', 'Luctus Et Ltd', 'Jordan', 'jordan@icloud.com', 'Camera motion sensor system'), (42, 280490, 'Vivien', 'vivien3327@gmail.com', '551-7157', NULL, NULL, '', '', 'Netus Et Malesuada Inc.', 'Cassandra', 'cassandra6159@yahoo.com', 'Android task monitoring'), (43, 288410, 'Blaze', 'blaze5723@gmail.com', '581-0284', NULL, NULL, '', '', 'Suscipit Est Consulting', 'Lareina', 'lareina7160@hotmail.com', 'Software piracy protection system'), (44, 282133, 'Katell', 'katell@yahoo.com', '868-5321', NULL, NULL, '', '', 'Amet Faucibus Ut Industries', 'Echo', 'echo9263@gmail.com', 'Sentiment analysis for product rating'), (45, 284851, 'Cole', 'cole7630@gmail.com', '994-1229', NULL, NULL, '', '', 'Odio Company', 'Bryar', 'bryar@yahoo.com', 'Fingerprint-based ATM system'), (46, 288519, 'Vladimir', 'vladimir@icloud.com', '221-0123', NULL, NULL, '', '', 'Scelerisque Sed Sapien PC', 'Arden', 'arden@icloud.com', 'Data leakage detection system'), (47, 283106, 'Vincent', 'vincent@yahoo.com', '623-3972', NULL, NULL, '', '', 'Praesent Eu PC', 'Chanda', 'chanda@yahoo.com', 'AI shopping system'), (48, 288401, 'Emily', 'emily4138@yahoo.com', '371-2944', NULL, NULL, 'DR Rayhan Uddin', 'Uddin@gmail.com', 'Fusce Ltd', 'Paki', 'raydemo@gmail.com', 'Chatbots'), (49, 287229, 'Grant', 'grant@hotmail.com', '739-5211', 'EVALUATED', NULL, '', '', 'Ultrices Duis Volutpat Corporation', 'Jackson', 'rays1@gmail.com', 'Software piracy protection system'), (50, 288115, 'Heather', 'heather7607@icloud.com', '773-1630', NULL, 'EVALUATED', 'DR Rayhan Uddin', 'Uddin@gmail.com', 'Elit Erat Vitae LLC', 'Malik', 'malik9255@gmail.com', 'Weather forecasting system'), (139, 281999, 'Laura', 'bekah@gmail.com', '01151102897', NULL, NULL, 'Dr Saifullah', 'Uddin@gmail.com', 'SOC', 'Mahmaud', 'rays1@gmail.com', 'Mobile App'), (140, 281918, 'sakib', 'dg@gmail.com', '0169457896', NULL, NULL, 'Dr Saifullah', 'Uddin@gmail.com', 'SA', 'Mahmaud', 'raydemo@gmail.com', 'Mobile App'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_user` -- CREATE TABLE `tbl_user` ( `user_id` int(10) NOT NULL, `user_email` varchar(50) NOT NULL, `user_name` varchar(50) NOT NULL, `user_number` varchar(20) NOT NULL, `user_pass` varchar(40) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_user` -- INSERT INTO `tbl_user` (`user_id`, `user_email`, `user_name`, `user_number`, `user_pass`) VALUES (20, 'Uddin@gmail.com', 'Dr Uddin', 'E2110200', '90af5f034f71bdf5149d885d94636f37bf04f3cc'), (21, '1@gmail.com', 'symlercooksbake', '123', '90af5f034f71bdf5149d885d94636f37bf04f3cc'), (22, 'a1@gmail.com', 'Deborah', 'S1245', '90af5f034f71bdf5149d885d94636f37bf04f3cc'), (23, 'hrid@gmail.com', 'hrid', '245645', 'a7168ea41078cc5f34ea94e7386f3e100f53e6c6'), (25, '21@gmail.com', 'symlercooksbake', '123', '90af5f034f71bdf5149d885d94636f37bf04f3cc'); -- -- Indexes for dumped tables -- -- -- Indexes for table `adminlogin` -- ALTER TABLE `adminlogin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `demo` -- ALTER TABLE `demo` ADD PRIMARY KEY (`smatric`); -- -- Indexes for table `democom` -- ALTER TABLE `democom` ADD PRIMARY KEY (`smatric`); -- -- Indexes for table `tbl_comsup` -- ALTER TABLE `tbl_comsup` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `tbl_tutors` -- ALTER TABLE `tbl_tutors` ADD PRIMARY KEY (`tutor_id`), ADD UNIQUE KEY `tutor_email` (`tutor_email`), ADD UNIQUE KEY `smatric` (`smatric`); -- -- Indexes for table `tbl_user` -- ALTER TABLE `tbl_user` ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `user_email` (`user_email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `adminlogin` -- ALTER TABLE `adminlogin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_comsup` -- ALTER TABLE `tbl_comsup` MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- AUTO_INCREMENT for table `tbl_tutors` -- ALTER TABLE `tbl_tutors` MODIFY `tutor_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141; -- -- AUTO_INCREMENT for table `tbl_user` -- ALTER TABLE `tbl_user` MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; COMMIT; /*!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 */;