-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 10.123.0.165:3306
-- Generation Time: May 15, 2026 at 03:36 PM
-- Server version: 8.4.7
-- PHP Version: 8.2.31

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: `menthanecon_oddroadmin`
--

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

--
-- Table structure for table `celpip_questions`
--

CREATE TABLE `celpip_questions` (
  `id` int NOT NULL,
  `set_name` varchar(255) DEFAULT NULL,
  `section_name` varchar(255) DEFAULT NULL,
  `part_name` varchar(255) DEFAULT NULL,
  `question` text,
  `options` json DEFAULT NULL,
  `answer` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `celpip_questions`
--

INSERT INTO `celpip_questions` (`id`, `set_name`, `section_name`, `part_name`, `question`, `options`, `answer`) VALUES
(1, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 1: Listening to Problem Solving', 'Where is the recreation centre located?', '[\"(A) Oak Street and First Avenue\", \"(B) Oak Street and Third Avenue\", \"(C) Third Avenue and Maple Street\", \"(D) Riverside Drive and Oak Street\"]', 'B'),
(2, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 1: Listening to Problem Solving', 'Where should the man enter the parking lot?', '[\"(A) From Oak Street\", \"(B) From the front entrance off Riverside Drive\", \"(C) From Third Avenue\", \"(D) There is no parking at the centre\"]', 'C'),
(3, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 1: Listening to Problem Solving', 'What problem is the man reporting?', '[\"(A) His neighbour parks in his driveway\", \"(B) Loud music late at night for three nights\", \"(C) A neighbour is renovating during restricted hours\", \"(D) Street construction is disturbing his sleep\"]', 'B'),
(4, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 1: Listening to Problem Solving', 'What should the man do if the noise happens again tonight?', '[\"(A) Knock on the neighbour\'s door directly\", \"(B) Email the by-law office with a recording\", \"(C) Call 311 to request an immediate response\", \"(D) Wait until the 48-hour follow-up period ends\"]', 'C'),
(5, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 1: Listening to Problem Solving', 'What does the man need to get a library card?', '[\"(A) Passport and proof of income\", \"(B) Photo ID and proof of current address\", \"(C) Birth certificate and a bank statement\", \"(D) Health card and a recent phone bill\"]', 'B'),
(6, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 1: Listening to Problem Solving', 'What is the maximum number of physical items he can borrow?', '[\"(A) Fifteen\", \"(B) Ten\", \"(C) Twenty\", \"(D) Twenty-five\"]', 'C'),
(7, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 2: Listening to a Daily Life Conversation', 'Why are Sarah and Daniel planning the dinner?', '[\"(A) To celebrate Marcus\'s promotion\", \"(B) To mark Marcus\'s last day at the company\", \"(C) To say goodbye before Marcus moves to Vancouver\", \"(D) To welcome a new team member\"]', 'C'),
(8, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 2: Listening to a Daily Life Conversation', 'What is the issue with Casa Mia’s private room?', '[\"(A) The restaurant is fully booked on Fridays\", \"(B) The private room holds a maximum of twelve people\", \"(C) The menu does not include Italian food\", \"(D) The restaurant is too far from the office\"]', 'B'),
(9, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 2: Listening to a Daily Life Conversation', 'What gift does Daniel suggest?', '[\"(A) A gift card to a Vancouver restaurant\", \"(B) A team jersey with everyone\'s signatures\", \"(C) A framed photo from the office camping trip\", \"(D) A personalised notebook\"]', 'C'),
(10, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 2: Listening to a Daily Life Conversation', 'How will the team contribute to the gift?', '[\"(A) Each person will bring a wrapped gift to dinner\", \"(B) Each person will contribute twenty dollars via email\", \"(C) Team members will vote on a gift online\", \"(D) The manager will purchase the gift and reimburse staff later\"]', 'B'),
(11, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 2: Listening to a Daily Life Conversation', 'When will the dinner most likely take place?', '[\"(A) Five o\'clock\", \"(B) Six o\'clock\", \"(C) Seven o\'clock\", \"(D) Seven thirty\"]', 'C'),
(12, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 3: Listening for Information', 'What is the main finding of Dr. Khalil’s research?', '[\"(A) Green spaces reduce crime rates in urban areas\", \"(B) Regular access to urban green spaces lowers stress and anxiety\", \"(C) Urban residents exercise more when parks are nearby\", \"(D) Community gardens improve residents\' diets\"]', 'B'),
(13, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 3: Listening for Information', 'How much time in green space is recommended per week?', '[\"(A) One hour, in a single session\", \"(B) Three hours, spread across seven days\", \"(C) Approximately two hours total per week\", \"(D) Thirty minutes every morning\"]', 'C'),
(14, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 3: Listening for Information', 'Which type of green space provides the strongest benefits?', '[\"(A) Large forested parks on the city outskirts\", \"(B) Spaces with natural water features\", \"(C) Community gardens open to residents\", \"(D) Green rooftops on apartment buildings\"]', 'B'),
(15, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 3: Listening for Information', 'What inequality does Dr. Khalil highlight?', '[\"(A) Green spaces charge entry fees that lower-income residents cannot afford\", \"(B) Lower-income areas have 40% less green space per resident than higher-income areas\", \"(C) Green space programs are funded only by wealthy municipalities\", \"(D) Public transit doesn\'t reach most parks in lower-income areas\"]', 'B'),
(16, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 3: Listening for Information', 'What does “20-minute green access” mean?', '[\"(A) Spending at least 20 minutes in a park each day\", \"(B) Ensuring every resident is within a 20-minute walk of meaningful green space\", \"(C) Building parks within 20 kilometres of city centres\", \"(D) Opening green spaces for public access 20 hours per day\"]', 'B'),
(17, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 3: Listening for Information', 'What is one recommended solution?', '[\"(A) Converting school sports fields into public parks\", \"(B) Planting trees along every major street\", \"(C) Converting vacant lots into pocket parks\", \"(D) Requiring all new apartment buildings to have green roofs\"]', 'C'),
(18, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 4: Listening to a News Item', 'The new transit corridor will connect the ______.', '[\"(A) airport and the university campus\", \"(B) downtown transit hub and the university campus\", \"(C) downtown transit hub and the main hospital\", \"(D) city hall and the central shopping district\"]', 'B'),
(19, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 4: Listening to a News Item', 'The project will be funded ______.', '[\"(A) entirely by the city using reserve funds\", \"(B) sixty percent federal, forty percent split between province and city\", \"(C) fifty percent federal, fifty percent municipal\", \"(D) eighty percent provincial, twenty percent federal\"]', 'B'),
(20, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 4: Listening to a News Item', 'The new system will include ______.', '[\"(A) underground tunnels and automated trains\", \"(B) twelve new stations with real-time displays and platform-level fare payment\", \"(C) express lanes shared with emergency vehicles\", \"(D) a park-and-ride facility at every station\"]', 'B'),
(21, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 4: Listening to a News Item', 'The project is expected to reduce commute times by ______.', '[\"(A) up to eight minutes\", \"(B) about twelve minutes\", \"(C) up to eighteen minutes\", \"(D) over twenty-five minutes\"]', 'C'),
(22, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 4: Listening to a News Item', 'Public consultations will take place ______.', '[\"(A) during the final two weeks of this month\", \"(B) during the first two weeks of next month\", \"(C) starting in spring when construction begins\", \"(D) once the corridor opens to the public\"]', 'B'),
(23, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'What are the speakers mainly discussing?', '[\"(A) A company budget proposal\", \"(B) Two options for a company volunteer day\", \"(C) A new hiring strategy\", \"(D) Planning a fundraising event\"]', 'B'),
(24, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'Why does Priya prefer the food bank?', '[\"(A) It is closer to the office\", \"(B) The team has volunteered there before\", \"(C) It is understaffed and the team can make a real difference\", \"(D) It offers more structured activities\"]', 'C'),
(25, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'What new information changes Priya’s opinion?', '[\"(A) The garden is closer to public transit\", \"(B) The garden has a structured team project\", \"(C) The food bank has fewer volunteers this year\", \"(D) The garden provides free meals for volunteers\"]', 'B'),
(26, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'What advantage of the community garden does James mention?', '[\"(A) It requires less physical effort\", \"(B) It allows for more individual work\", \"(C) It promotes teamwork and collaboration\", \"(D) It is more affordable for the company\"]', 'C'),
(27, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'What concern does Claudia raise?', '[\"(A) The event may conflict with work deadlines\", \"(B) The location may not be accessible for all team members\", \"(C) The team may not be interested in volunteering\", \"(D) The food bank may cancel the event\"]', 'B'),
(28, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'What is Elena’s opinion about the social media aspect?', '[\"(A) It should be the main factor in the decision\", \"(B) It is not relevant to the discussion\", \"(C) It should not be the deciding factor\", \"(D) It will be handled by another team\"]', 'C'),
(29, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'What will Elena do next?', '[\"(A) Ask the team to vote immediately\", \"(B) Contact the food bank to confirm availability\", \"(C) Check accessibility details with the garden coordinator\", \"(D) Cancel the volunteer day\"]', 'C'),
(30, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 5: Listening to a Discussion', 'What has the team tentatively decided?', '[\"(A) To choose the food bank immediately\", \"(B) To cancel the event\", \"(C) To choose the garden regardless of conditions\", \"(D) To prefer the garden, depending on accessibility\"]', 'D'),
(31, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 6: Listening to Viewpoints', 'What is the main idea of the report?', '[\"(A) Plastic production should be banned worldwide\", \"(B) Cities are debating how to reduce single-use plastics\", \"(C) Recycling programs are ineffective in most cities\", \"(D) Industrial pollution is the biggest environmental issue\"]', 'B'),
(32, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 6: Listening to Viewpoints', 'Why do proponents support banning single-use plastics?', '[\"(A) Alternatives are easy to adopt and require little change\", \"(B) Plastic products are expensive to produce\", \"(C) Governments require strict environmental policies\", \"(D) Businesses benefit financially from bans\"]', 'A'),
(33, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 6: Listening to Viewpoints', 'What is one argument made by critics of plastic bans?', '[\"(A) Bans are too difficult to enforce\", \"(B) Alternatives are not available\", \"(C) Single-use plastics represent a small portion of total waste\", \"(D) Consumers prefer plastic products\"]', 'C'),
(34, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 6: Listening to Viewpoints', 'What concern is raised about alternatives like paper bags?', '[\"(A) They are not widely available\", \"(B) They are more expensive for consumers\", \"(C) They require more resources to produce\", \"(D) They cannot be recycled\"]', 'C'),
(35, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 6: Listening to Viewpoints', 'What is one advantage of tiered pricing systems?', '[\"(A) They eliminate plastic use entirely\", \"(B) They reduce consumption without strict bans\", \"(C) They are easier for businesses to ignore\", \"(D) They increase government revenue significantly\"]', 'B'),
(36, 'SET 1 – Set 1', 'SECTION 1: LISTENING TEST', 'Part 6: Listening to Viewpoints', 'What conclusion does the speaker reach?', '[\"(A) Plastic bans are the only effective solution\", \"(B) Cities should ignore plastic waste issues\", \"(C) A combination of policies is needed for real impact\", \"(D) Industrial plastics should be banned first\"]', 'C'),
(37, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 1: Reading Part 1 – Correspondence', 'What is the main purpose of this email?', '[]', 'B'),
(38, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 1: Reading Part 1 – Correspondence', 'Where can employees find the self-assessment form?', '[]', 'C'),
(39, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 1: Reading Part 1 – Correspondence', 'When must the self-assessment form be submitted?', '[]', 'C'),
(40, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 1: Reading Part 1 – Correspondence', 'What is new about this year\'s performance review?', '[]', 'B'),
(41, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 1: Reading Part 1 – Correspondence', 'Who should employees contact if they have not received their appointment time?', '[]', 'C'),
(42, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 2: Reading Part 2 – Diagram/Visual', 'Which month has the highest rainfall?', '[]', 'C'),
(43, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 2: Reading Part 2 – Diagram/Visual', 'What is the annual average rainfall shown on the chart?', '[]', 'B'),
(44, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 2: Reading Part 2 – Diagram/Visual', 'Which month receives the least rainfall?', '[]', 'D'),
(45, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 2: Reading Part 2 – Diagram/Visual', 'How many months receive ABOVE average rainfall?', '[]', 'C'),
(46, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 3: Reading Part 3 – Informational Text', 'What causes the aurora borealis?', '[]', 'C'),
(47, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 3: Reading Part 3 – Informational Text', 'What produces the green colour of the northern lights?', '[]', 'B'),
(48, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 3: Reading Part 3 – Informational Text', 'What Kp-index value is needed to see the lights at lower latitudes?', '[]', 'C'),
(49, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 3: Reading Part 3 – Informational Text', 'What is the best time of year to see the northern lights?', '[]', 'B'),
(50, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 3: Reading Part 3 – Informational Text', 'According to the passage, how do visitors compare seeing the lights in person to photographs?', '[]', 'C'),
(51, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 4: Reading Part 4 – In-Depth Exposition', 'What is the main subject of the passage?', '[]', 'B'),
(52, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 4: Reading Part 4 – In-Depth Exposition', 'What is a \'food desert\' as described in the passage?', '[]', 'C'),
(53, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 4: Reading Part 4 – In-Depth Exposition', 'Which cities are mentioned as implementing urban agriculture for food equity?', '[]', 'B'),
(54, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 4: Reading Part 4 – In-Depth Exposition', 'What is one economic challenge of urban farming mentioned in the passage?', '[]', 'C'),
(55, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 4: Reading Part 4 – In-Depth Exposition', 'How do hydroponic and aeroponic systems help urban farming?', '[]', 'B'),
(56, 'SET 1 – Set 1', 'SECTION 2: READING', 'Part 4: Reading Part 4 – In-Depth Exposition', 'What is vertical farming?', '[]', 'C');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `celpip_questions`
--
ALTER TABLE `celpip_questions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
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 */;
