-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Aug 01, 2023 at 06:45 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `staffrecord` -- -- -------------------------------------------------------- -- -- Table structure for table `administrativestaff` -- CREATE TABLE `administrativestaff` ( `administrativestaff_id` int(11) NOT NULL, `fname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, `middlename` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `rank` varchar(255) NOT NULL, `department` varchar(255) NOT NULL, `qualification1` varchar(255) NOT NULL, `qualification2` varchar(255) NOT NULL, `qualification3` varchar(255) NOT NULL, `qualification4` varchar(255) NOT NULL, `course_assigned` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `images2` varchar(255) NOT NULL, `images3` varchar(255) NOT NULL, `images4` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `architechturaldesign` -- CREATE TABLE `architechturaldesign` ( `architechturaldesign_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `architechturaldesign` -- INSERT INTO `architechturaldesign` (`architechturaldesign_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Business Adminstration', 'school layout', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `businessadminbooks` -- CREATE TABLE `businessadminbooks` ( `businessadminbooks_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `businessadminbooks` -- INSERT INTO `businessadminbooks` (`businessadminbooks_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Business Adminstration', 'introduction to Business3', 'Alideen.pdf', ''), (2, 'Business Adminstration', 'introduction to Business2', 'Ahossi joseph.pdf', ''), (3, 'Business Adminstration', 'introduction to Business1', 'Ahossi joseph.pdf', ''), (4, 'Business Adminstration', 'introduction to Business', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `computerengineeringbooks` -- CREATE TABLE `computerengineeringbooks` ( `comengineering_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `computerengineeringbooks` -- INSERT INTO `computerengineeringbooks` (`comengineering_id`, `department`, `title1`, `images1`, `downloads`) VALUES (3, 'Computer Engineering', 'introduction to engineering', 'Ahossi joseph.pdf', ''), (4, 'Computer Engineering', 'introduction to engineering1', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `computersciencebook` -- CREATE TABLE `computersciencebook` ( `computersciencebook_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `computersciencebook` -- INSERT INTO `computersciencebook` (`computersciencebook_id`, `department`, `title1`, `images1`, `downloads`) VALUES (4, 'Computer Science', 'introduction to coding', 'Ahossi joseph.pdf', ''), (5, 'Computer Science', 'introduction to coding1', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `corestaff` -- CREATE TABLE `corestaff` ( `corestaff_id` int(11) NOT NULL, `fname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, `middlename` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `rank` varchar(255) NOT NULL, `department` varchar(255) NOT NULL, `qualification1` varchar(255) NOT NULL, `qualification2` varchar(255) NOT NULL, `qualification3` varchar(255) NOT NULL, `qualification4` varchar(255) NOT NULL, `course_assigned` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `images2` varchar(255) NOT NULL, `images3` varchar(255) NOT NULL, `images4` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `curriculum` -- CREATE TABLE `curriculum` ( `Curriculum_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `curriculum` -- INSERT INTO `curriculum` (`Curriculum_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Marine Engineering', 'introduction to coding', 'Alideen.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `electricalelectronicsbooks` -- CREATE TABLE `electricalelectronicsbooks` ( `electricalelectronicsbooks_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `electricalelectronicsbooks` -- INSERT INTO `electricalelectronicsbooks` (`electricalelectronicsbooks_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Electrical/Electronic Engineering', 'introduction to Electrical4', 'Alideen.pdf', ''), (2, 'Electrical/Electronic Engineering', 'introduction to Electrical3', 'Ahossi joseph.pdf', ''), (3, 'Electrical/Electronic Engineering', 'introduction to Electrical2', 'Ahossi joseph.pdf', ''), (4, 'Electrical/Electronic Engineering', 'introduction to Electrical1', 'Ahossi joseph.pdf', ''), (5, 'Electrical/Electronic Engineering', 'introduction to Electrical', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `equipment` -- CREATE TABLE `equipment` ( `equip_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `equipment` -- INSERT INTO `equipment` (`equip_id`, `department`, `title1`, `images1`, `downloads`) VALUES (5, 'Computer Engineering', 'introduction to coding', 'Alideen.pdf', '29'); -- -------------------------------------------------------- -- -- Table structure for table `generalstudybooks` -- CREATE TABLE `generalstudybooks` ( `generalstudybooks_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `generalstudybooks` -- INSERT INTO `generalstudybooks` (`generalstudybooks_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Marine Engineering', 'introduction to coding', 'Alideen.pdf', ''), (2, 'Marine Engineering', 'document', 'Ahossi joseph.pdf', ''), (3, 'Marine Engineering', 'document', 'Ahossi joseph.pdf', ''), (4, 'Electrical/Electronic Engineering', 'document', 'Ahossi joseph.pdf', ''), (5, 'Computer Engineering', 'document', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `handbook` -- CREATE TABLE `handbook` ( `handbook_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `handbook` -- INSERT INTO `handbook` (`handbook_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Business Adminstration', 'introduction to coding', 'Ahossi joseph.pdf', ''), (2, 'Computer Engineering', 'introduction to coding', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `markingscheme` -- CREATE TABLE `markingscheme` ( `MarkingScheme_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `markingscheme` -- INSERT INTO `markingscheme` (`MarkingScheme_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Marine Engineering', 'introduction to coding', 'afliersword.docx', ''); -- -------------------------------------------------------- -- -- Table structure for table `practicals` -- CREATE TABLE `practicals` ( `practicals_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `practicals` -- INSERT INTO `practicals` (`practicals_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Business Adminstration', 'introduction to coding', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `projectwork` -- CREATE TABLE `projectwork` ( `projectwork_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `projectwork` -- INSERT INTO `projectwork` (`projectwork_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Business Adminstration', 'introduction to coding', 'Ahossi joseph.pdf', ''), (2, 'Business Adminstration', 'introduction to coding', 'Ahossi joseph.pdf', ''), (3, 'Electrical/Electronic Engineering', 'introduction to coding', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `servicestaff` -- CREATE TABLE `servicestaff` ( `servicestaff_id` int(11) NOT NULL, `fname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, `middlename` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `rank` varchar(255) NOT NULL, `department` varchar(255) NOT NULL, `qualification1` varchar(255) NOT NULL, `qualification2` varchar(255) NOT NULL, `qualification3` varchar(255) NOT NULL, `qualification4` varchar(255) NOT NULL, `course_assigned` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `images2` varchar(255) NOT NULL, `images3` varchar(255) NOT NULL, `images4` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `stafftable` -- CREATE TABLE `stafftable` ( `staff_id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `pass` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `stafftable` -- INSERT INTO `stafftable` (`staff_id`, `email`, `pass`) VALUES (1, 'josephaustin105@gmail.com', '12345'); -- -------------------------------------------------------- -- -- Table structure for table `studentlist` -- CREATE TABLE `studentlist` ( `studentlist_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `studentlist` -- INSERT INTO `studentlist` (`studentlist_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Marine Engineering', 'introduction to coding', 'Ahossi joseph.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `studentprojectwork` -- CREATE TABLE `studentprojectwork` ( `studentprojectwork_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `studentprojectwork` -- INSERT INTO `studentprojectwork` (`studentprojectwork_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Marine Engineering', 'introduction to coding', 'Alideen.pdf', ''), (2, 'Marine Engineering', 'document', 'Ahossi joseph.pdf', ''), (3, 'Marine Engineering', 'document', 'Ahossi joseph.pdf', ''), (4, 'Electrical/Electronic Engineering', 'document', 'Ahossi joseph.pdf', ''), (5, 'Computer Engineering', 'document', 'Ahossi joseph.pdf', ''), (6, 'Computer Science', 'document', 'Alideen.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `successrate` -- CREATE TABLE `successrate` ( `successrate_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `successrate` -- INSERT INTO `successrate` (`successrate_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Electrical/Electronic Engineering', 'introduction to coding', 'Alideen.pdf', ''); -- -------------------------------------------------------- -- -- Table structure for table `technicalstaff` -- CREATE TABLE `technicalstaff` ( `technicalstaff_id` int(11) NOT NULL, `fname` varchar(255) NOT NULL, `lname` varchar(255) NOT NULL, `middlename` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `rank` varchar(255) NOT NULL, `department` varchar(255) NOT NULL, `qualification1` varchar(255) NOT NULL, `qualification2` varchar(255) NOT NULL, `qualification3` varchar(255) NOT NULL, `qualification4` varchar(255) NOT NULL, `course_assigned` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `images2` varchar(255) NOT NULL, `images3` varchar(255) NOT NULL, `images4` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `timetable` -- CREATE TABLE `timetable` ( `timetable_id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `title1` varchar(255) NOT NULL, `images1` varchar(255) NOT NULL, `downloads` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `timetable` -- INSERT INTO `timetable` (`timetable_id`, `department`, `title1`, `images1`, `downloads`) VALUES (1, 'Computer Engineering', 'introduction to coding', 'Ahossi joseph.pdf', ''); -- -- Indexes for dumped tables -- -- -- Indexes for table `administrativestaff` -- ALTER TABLE `administrativestaff` ADD PRIMARY KEY (`administrativestaff_id`); -- -- Indexes for table `architechturaldesign` -- ALTER TABLE `architechturaldesign` ADD PRIMARY KEY (`architechturaldesign_id`); -- -- Indexes for table `businessadminbooks` -- ALTER TABLE `businessadminbooks` ADD PRIMARY KEY (`businessadminbooks_id`); -- -- Indexes for table `computerengineeringbooks` -- ALTER TABLE `computerengineeringbooks` ADD PRIMARY KEY (`comengineering_id`); -- -- Indexes for table `computersciencebook` -- ALTER TABLE `computersciencebook` ADD PRIMARY KEY (`computersciencebook_id`); -- -- Indexes for table `corestaff` -- ALTER TABLE `corestaff` ADD PRIMARY KEY (`corestaff_id`); -- -- Indexes for table `curriculum` -- ALTER TABLE `curriculum` ADD PRIMARY KEY (`Curriculum_id`); -- -- Indexes for table `electricalelectronicsbooks` -- ALTER TABLE `electricalelectronicsbooks` ADD PRIMARY KEY (`electricalelectronicsbooks_id`); -- -- Indexes for table `equipment` -- ALTER TABLE `equipment` ADD PRIMARY KEY (`equip_id`); -- -- Indexes for table `generalstudybooks` -- ALTER TABLE `generalstudybooks` ADD PRIMARY KEY (`generalstudybooks_id`); -- -- Indexes for table `handbook` -- ALTER TABLE `handbook` ADD PRIMARY KEY (`handbook_id`); -- -- Indexes for table `markingscheme` -- ALTER TABLE `markingscheme` ADD PRIMARY KEY (`MarkingScheme_id`); -- -- Indexes for table `practicals` -- ALTER TABLE `practicals` ADD PRIMARY KEY (`practicals_id`); -- -- Indexes for table `projectwork` -- ALTER TABLE `projectwork` ADD PRIMARY KEY (`projectwork_id`); -- -- Indexes for table `servicestaff` -- ALTER TABLE `servicestaff` ADD PRIMARY KEY (`servicestaff_id`); -- -- Indexes for table `stafftable` -- ALTER TABLE `stafftable` ADD PRIMARY KEY (`staff_id`); -- -- Indexes for table `studentlist` -- ALTER TABLE `studentlist` ADD PRIMARY KEY (`studentlist_id`); -- -- Indexes for table `studentprojectwork` -- ALTER TABLE `studentprojectwork` ADD PRIMARY KEY (`studentprojectwork_id`); -- -- Indexes for table `successrate` -- ALTER TABLE `successrate` ADD PRIMARY KEY (`successrate_id`); -- -- Indexes for table `technicalstaff` -- ALTER TABLE `technicalstaff` ADD PRIMARY KEY (`technicalstaff_id`); -- -- Indexes for table `timetable` -- ALTER TABLE `timetable` ADD PRIMARY KEY (`timetable_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `administrativestaff` -- ALTER TABLE `administrativestaff` MODIFY `administrativestaff_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `architechturaldesign` -- ALTER TABLE `architechturaldesign` MODIFY `architechturaldesign_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `businessadminbooks` -- ALTER TABLE `businessadminbooks` MODIFY `businessadminbooks_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `computerengineeringbooks` -- ALTER TABLE `computerengineeringbooks` MODIFY `comengineering_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `computersciencebook` -- ALTER TABLE `computersciencebook` MODIFY `computersciencebook_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `corestaff` -- ALTER TABLE `corestaff` MODIFY `corestaff_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `curriculum` -- ALTER TABLE `curriculum` MODIFY `Curriculum_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `electricalelectronicsbooks` -- ALTER TABLE `electricalelectronicsbooks` MODIFY `electricalelectronicsbooks_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `equipment` -- ALTER TABLE `equipment` MODIFY `equip_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `generalstudybooks` -- ALTER TABLE `generalstudybooks` MODIFY `generalstudybooks_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `handbook` -- ALTER TABLE `handbook` MODIFY `handbook_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `markingscheme` -- ALTER TABLE `markingscheme` MODIFY `MarkingScheme_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `practicals` -- ALTER TABLE `practicals` MODIFY `practicals_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `projectwork` -- ALTER TABLE `projectwork` MODIFY `projectwork_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `servicestaff` -- ALTER TABLE `servicestaff` MODIFY `servicestaff_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `stafftable` -- ALTER TABLE `stafftable` MODIFY `staff_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `studentlist` -- ALTER TABLE `studentlist` MODIFY `studentlist_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `studentprojectwork` -- ALTER TABLE `studentprojectwork` MODIFY `studentprojectwork_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `successrate` -- ALTER TABLE `successrate` MODIFY `successrate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `technicalstaff` -- ALTER TABLE `technicalstaff` MODIFY `technicalstaff_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `timetable` -- ALTER TABLE `timetable` MODIFY `timetable_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;