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

START TRANSACTION;



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

--
-- Table structure for table `quiz_responses`
--

CREATE TABLE `quiz_responses` (
  `id` int(11) NOT NULL,
  `student_name` varchar(100) NOT NULL,
  `student_surname` varchar(100) NOT NULL,
  `start_time` datetime NOT NULL,
  `submit_time` datetime NOT NULL,
  `q1_answer` varchar(255) DEFAULT NULL,
  `q2_answer` varchar(255) DEFAULT NULL,
  `q3_answer` varchar(255) DEFAULT NULL,
  `q4_answer` varchar(255) DEFAULT NULL,
  `q5_answer` text DEFAULT NULL,
  `q6_answer` varchar(255) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `total_score` int(11) DEFAULT 30
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quiz_responses`
--

INSERT INTO `quiz_responses` (`id`, `student_name`, `student_surname`, `start_time`, `submit_time`, `q1_answer`, `q2_answer`, `q3_answer`, `q4_answer`, `q5_answer`, `q6_answer`, `score`, `total_score`) VALUES
(1, 'James', 'Mtungwa', '2025-11-13 07:45:35', '2025-11-13 07:52:05', 'a', 'c', 'b', 'c', '$number = $_POST[\'number\'];\r\nif($number>0){\r\necho\"The number is positive\";\r\nelse if($number<0){\r\necho\"The number is negative\";\r\n}else {\r\necho\"The number is equal to zero\";\r\n}', 'a', 30, 30);

--
-- Indexes for table `quiz_responses`
--
ALTER TABLE `quiz_responses`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `quiz_responses`
--
ALTER TABLE `quiz_responses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

