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

START TRANSACTION;



--
-- Database: `jobastec_jsms_db`
--

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

--
-- Table structure for table `parent_tbl`
--

CREATE TABLE IF NOT EXISTS `parent_tbl` (
  `par_id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(100) NOT NULL,
  `std1` varchar(255) DEFAULT NULL,
  `std2` varchar(255) DEFAULT NULL,
  `std3` varchar(255) DEFAULT NULL,
  `std4` varchar(255) DEFAULT NULL,
  `std5` varchar(255) DEFAULT NULL,
  `creation_date` date NOT NULL,
  `created_by` varchar(100) NOT NULL,
  `updated_by` varchar(100) DEFAULT NULL,
  `update_dt` date DEFAULT NULL,
  PRIMARY KEY (`par_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `parent_tbl`
--

INSERT INTO `parent_tbl` (`par_id`, `username`, `email`, `password`, `std1`, `std2`, `std3`, `std4`, `std5`, `creation_date`, `created_by`, `updated_by`, `update_dt`) VALUES
(5, 'adeniyi', 'adeniyi@gmail.com', '123seun', 'GWS25096', 'GWS24049', 'GWS76412', 'GWS55456', 'GWS01051', '2022-07-12', 'ATANSUYI JOSHUA', 'ATANSUYI JOSHUA', '2025-07-04'),
(8, 'abdul', 'abdul@gmail.com', 'ab123', 'GWS93073', '', '', '', NULL, '2022-08-31', 'ATANSUYI JOSHUA', NULL, NULL);
COMMIT;

