-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: May 16, 2019 at 05:17 AM -- Server version: 8.0.15 -- PHP Version: 7.2.7 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: `clinicdb` -- -- -------------------------------------------------------- -- -- Table structure for table `appointment` -- CREATE TABLE `appointment` ( `id` int(11) NOT NULL, `department` varchar(255) NOT NULL, `date` datetime NOT NULL, `completed` tinyint(1) NOT NULL, `no_show` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `appointment` -- INSERT INTO `appointment` (`id`, `department`, `date`, `completed`, `no_show`) VALUES (1, 'Laboratory', '2019-05-21 08:00:00', 0, 0), (2, 'Radiology', '2018-11-21 15:00:00', 1, 0), (3, 'Optometry', '2019-02-13 10:30:00', 0, 1), (4, 'Cytology', '2019-06-29 11:00:00', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `department` -- CREATE TABLE `department` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `floor` int(11) NOT NULL, `poc_name` varchar(255) NOT NULL, `poc_phone` bigint(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `department` -- INSERT INTO `department` (`id`, `name`, `floor`, `poc_name`, `poc_phone`) VALUES (1, 'Medical Laboratory', 2, 'Mr Dracula', 7567443566), (2, 'Radiology', 2, 'Mrs Marie Curie', 7326888732), (3, 'Medical Logistics', 1, 'John Fastwalker III', 7326888733), (4, 'Pharmacy', 1, 'Dr Green Thumb', 8649371000); -- -------------------------------------------------------- -- -- Table structure for table `er` -- CREATE TABLE `er` ( `roomid` int(11) NOT NULL, `patient_id` int(11) NOT NULL, `entrance_time` datetime NOT NULL, `expected_wait_time` time NOT NULL, `doctor_assigned` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `erstaff` -- CREATE TABLE `erstaff` ( `id` int(11) NOT NULL, `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `phone_ext` int(11) NOT NULL, `job_title` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `home_phone` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `erstaff_is_oncall` -- CREATE TABLE `erstaff_is_oncall` ( `nr` int(11) NOT NULL, `erstaff` int(11) NOT NULL, `oncall.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `erstaff_works_in_er` -- CREATE TABLE `erstaff_works_in_er` ( `nr` int(11) NOT NULL, `erstaff.id` int(11) NOT NULL, `er.roomid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `er_has_room` -- CREATE TABLE `er_has_room` ( `nr` int(11) NOT NULL, `er.roomid` int(11) NOT NULL, `room.number` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `insurance` -- CREATE TABLE `insurance` ( `market_id` int(32) NOT NULL, `type` varchar(255) NOT NULL, `provider` varchar(255) NOT NULL, `start_date` date NOT NULL, `expiration_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `insurance` -- INSERT INTO `insurance` (`market_id`, `type`, `provider`, `start_date`, `expiration_date`) VALUES (4356756, 'free', 'Medicaid', '2018-11-27', '2019-06-27'), (7689045, 'pay', 'Blue Shield', '2018-12-25', '2019-11-04'), (98760001, 'free', 'Medicaid', '2018-09-04', '2019-05-19'), (999888777, 'pay', 'Blue Cross', '2018-03-11', '2019-02-25'); -- -------------------------------------------------------- -- -- Table structure for table `labstaff` -- CREATE TABLE `labstaff` ( `id` int(11) NOT NULL, `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `phone_ext` int(11) NOT NULL, `job_title` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `home_phone` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `labstaff_has_role` -- CREATE TABLE `labstaff_has_role` ( `nr` int(11) NOT NULL, `labstaff.id` int(11) NOT NULL, `role.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `labstaff_runs_labtest` -- CREATE TABLE `labstaff_runs_labtest` ( `nr` int(11) NOT NULL, `labstaff.id` int(11) NOT NULL, `labtest.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `labtest` -- CREATE TABLE `labtest` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `tat_hours` int(11) NOT NULL, `fasting` tinyint(1) NOT NULL, `stat` tinyint(1) NOT NULL, `asap` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `medicine` -- CREATE TABLE `medicine` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `concentration` float NOT NULL, `unit_of_measurement` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `controlled_substance` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `oncall` -- CREATE TABLE `oncall` ( `id` int(11) NOT NULL, `staff_id` int(11) NOT NULL, `department_id` int(11) NOT NULL, `start_time` datetime NOT NULL, `end_time` datetime NOT NULL, `phone` int(11) NOT NULL, `beeper` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `patient` -- CREATE TABLE `patient` ( `id` int(11) NOT NULL, `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `dob` date NOT NULL, `home_phone` int(32) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `patient` -- INSERT INTO `patient` (`id`, `fName`, `lName`, `dob`, `home_phone`) VALUES (1, 'Abe', 'Lincoln', '1900-01-30', 1111111111), (2, 'Albert', 'Einstein', '1905-03-08', 1111111112), (3, 'Leeroy', 'Jenkins', '1976-05-18', 1111111113), (4, 'Robert', 'Paulson', '1983-01-23', 1111111114); -- -------------------------------------------------------- -- -- Table structure for table `patientstatus` -- CREATE TABLE `patientstatus` ( `id` int(11) NOT NULL, `admitted` datetime NOT NULL, `discharged` datetime NOT NULL, `needs_labs` tinyint(1) NOT NULL, `needs_medication` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -------------------------------------------------------- -- -- Table structure for table `patient_has_appointment` -- CREATE TABLE `patient_has_appointment` ( `nr` int(11) NOT NULL, `patient_id` int(11) NOT NULL, `appointment_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `patient_has_appointment` -- INSERT INTO `patient_has_appointment` (`nr`, `patient_id`, `appointment_id`) VALUES (1, 1, 4), (2, 3, 3), (3, 1, 1), (4, 2, 2); -- -------------------------------------------------------- -- -- Table structure for table `patient_has_insurance` -- CREATE TABLE `patient_has_insurance` ( `nr` int(11) NOT NULL, `patient.id` int(11) NOT NULL, `insurance.market_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `patient_has_insurance` -- INSERT INTO `patient_has_insurance` (`nr`, `patient.id`, `insurance.market_id`) VALUES (1, 1, 4356756), (2, 2, 7689045), (3, 3, 999888777), (4, 4, 98760001); -- -------------------------------------------------------- -- -- Table structure for table `patient_has_patientstatus` -- CREATE TABLE `patient_has_patientstatus` ( `nr` int(11) NOT NULL, `patient.id` int(11) NOT NULL, `patientstatus.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `patient_needs_labtest` -- CREATE TABLE `patient_needs_labtest` ( `nr` int(11) NOT NULL, `patient.id` int(11) NOT NULL, `labtest.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `patient_needs_medicine` -- CREATE TABLE `patient_needs_medicine` ( `nr` int(11) NOT NULL, `patient.id` int(11) NOT NULL, `medicine.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `role` -- CREATE TABLE `role` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `critical_staff` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `room` -- CREATE TABLE `room` ( `number` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `floor` int(11) NOT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `storage_room` tinyint(1) NOT NULL, `isolation_room` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `student` -- CREATE TABLE `student` ( `id` int(11) NOT NULL, `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `dob` date NOT NULL, `intern` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -- Dumping data for table `student` -- INSERT INTO `student` (`id`, `fName`, `lName`, `dob`, `intern`) VALUES (1, 'Francisco', 'Franco', '1904-05-12', 0), (2, 'Mao', 'Zedong', '1892-09-23', 0), (3, 'Pol', 'Pot', '1925-02-26', 0), (4, 'Antonio', 'Alazar', '1901-12-08', 1); -- -------------------------------------------------------- -- -- Table structure for table `student_studies_in_department` -- CREATE TABLE `student_studies_in_department` ( `nr` int(11) NOT NULL, `student.id` int(11) NOT NULL, `department.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `supportstaff` -- CREATE TABLE `supportstaff` ( `id` int(11) NOT NULL, `fName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `lName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `phone_ext` int(11) NOT NULL, `job_title` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -- Dumping data for table `supportstaff` -- INSERT INTO `supportstaff` (`id`, `fName`, `lName`, `phone_ext`, `job_title`) VALUES (1, 'Henry', 'Ford', 1234, 'Lab Director'), (2, 'Harrison', 'Ford', 2222, 'Medical Logistics Apprentice'), (3, 'Jane', 'Fonda', 2132, 'Medical Logistics Journeyman'), (4, 'Huddie', 'Leadbetter', 5324, 'Custodian'); -- -------------------------------------------------------- -- -- Table structure for table `supportstaff_works_in_department` -- CREATE TABLE `supportstaff_works_in_department` ( `nr` int(11) NOT NULL, `supportStaff.id` int(11) NOT NULL, `department.id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT; -- -- Dumping data for table `supportstaff_works_in_department` -- INSERT INTO `supportstaff_works_in_department` (`nr`, `supportStaff.id`, `department.id`) VALUES (1, 1, 1), (2, 2, 3), (3, 3, 3); -- -- Indexes for dumped tables -- -- -- Indexes for table `appointment` -- ALTER TABLE `appointment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `department` -- ALTER TABLE `department` ADD PRIMARY KEY (`id`); -- -- Indexes for table `er` -- ALTER TABLE `er` ADD PRIMARY KEY (`roomid`); -- -- Indexes for table `erstaff` -- ALTER TABLE `erstaff` ADD PRIMARY KEY (`id`); -- -- Indexes for table `erstaff_is_oncall` -- ALTER TABLE `erstaff_is_oncall` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `erstaff_works_in_er` -- ALTER TABLE `erstaff_works_in_er` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `er_has_room` -- ALTER TABLE `er_has_room` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `insurance` -- ALTER TABLE `insurance` ADD PRIMARY KEY (`market_id`); -- -- Indexes for table `labstaff` -- ALTER TABLE `labstaff` ADD PRIMARY KEY (`id`); -- -- Indexes for table `labstaff_has_role` -- ALTER TABLE `labstaff_has_role` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `labstaff_runs_labtest` -- ALTER TABLE `labstaff_runs_labtest` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `labtest` -- ALTER TABLE `labtest` ADD PRIMARY KEY (`id`); -- -- Indexes for table `medicine` -- ALTER TABLE `medicine` ADD PRIMARY KEY (`id`); -- -- Indexes for table `oncall` -- ALTER TABLE `oncall` ADD PRIMARY KEY (`id`); -- -- Indexes for table `patient` -- ALTER TABLE `patient` ADD PRIMARY KEY (`id`); -- -- Indexes for table `patientstatus` -- ALTER TABLE `patientstatus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `patient_has_appointment` -- ALTER TABLE `patient_has_appointment` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `patient_has_insurance` -- ALTER TABLE `patient_has_insurance` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `patient_has_patientstatus` -- ALTER TABLE `patient_has_patientstatus` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `patient_needs_labtest` -- ALTER TABLE `patient_needs_labtest` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `patient_needs_medicine` -- ALTER TABLE `patient_needs_medicine` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `role` -- ALTER TABLE `role` ADD PRIMARY KEY (`id`); -- -- Indexes for table `room` -- ALTER TABLE `room` ADD PRIMARY KEY (`number`); -- -- Indexes for table `student` -- ALTER TABLE `student` ADD PRIMARY KEY (`id`); -- -- Indexes for table `student_studies_in_department` -- ALTER TABLE `student_studies_in_department` ADD PRIMARY KEY (`nr`); -- -- Indexes for table `supportstaff` -- ALTER TABLE `supportstaff` ADD PRIMARY KEY (`id`); -- -- Indexes for table `supportstaff_works_in_department` -- ALTER TABLE `supportstaff_works_in_department` ADD PRIMARY KEY (`nr`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `appointment` -- ALTER TABLE `appointment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `department` -- ALTER TABLE `department` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `er` -- ALTER TABLE `er` MODIFY `roomid` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `erstaff` -- ALTER TABLE `erstaff` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `erstaff_is_oncall` -- ALTER TABLE `erstaff_is_oncall` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `erstaff_works_in_er` -- ALTER TABLE `erstaff_works_in_er` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `er_has_room` -- ALTER TABLE `er_has_room` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `labstaff` -- ALTER TABLE `labstaff` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `labstaff_has_role` -- ALTER TABLE `labstaff_has_role` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `labstaff_runs_labtest` -- ALTER TABLE `labstaff_runs_labtest` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `medicine` -- ALTER TABLE `medicine` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `oncall` -- ALTER TABLE `oncall` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `patient` -- ALTER TABLE `patient` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `patientstatus` -- ALTER TABLE `patientstatus` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `patient_has_appointment` -- ALTER TABLE `patient_has_appointment` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `patient_has_insurance` -- ALTER TABLE `patient_has_insurance` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `patient_has_patientstatus` -- ALTER TABLE `patient_has_patientstatus` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `patient_needs_labtest` -- ALTER TABLE `patient_needs_labtest` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `patient_needs_medicine` -- ALTER TABLE `patient_needs_medicine` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `role` -- ALTER TABLE `role` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `student` -- ALTER TABLE `student` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `student_studies_in_department` -- ALTER TABLE `student_studies_in_department` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `supportstaff` -- ALTER TABLE `supportstaff` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `supportstaff_works_in_department` -- ALTER TABLE `supportstaff_works_in_department` MODIFY `nr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; 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 */;
Comments