CREATE TABLE about_us (
id INT PRIMARY KEY DEFAULT 1,
about_text TEXT NOT NULL,
image_url TEXT NOT NULL,
image_key TEXT,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT single_row CHECK (id = 1)
);
CREATE TABLE tutors (
id SERIAL PRIMARY KEY,
name VARCHAR(255) NOT NULL,
qualifications VARCHAR(255) NOT NULL,
image_url TEXT NOT NULL,
image_key TEXT
);
CREATE TABLE reviews (
id SERIAL PRIMARY KEY,
name VARCHAR(100) NOT NULL,
rating INT NOT NULL CHECK (rating >= 1 AND rating <= 5),
text TEXT NOT NULL,
subject VARCHAR(255) NOT NULL
);
CREATE TABLE reasons (
num INT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
text TEXT NOT NULL
);
CREATE TABLE pricing_tabs (
id VARCHAR(50) PRIMARY KEY,
label VARCHAR(100) NOT NULL,
is_active BOOLEAN DEFAULT FALSE
);
CREATE TABLE pricing_plans (
id SERIAL PRIMARY KEY,
tab_id VARCHAR(50) REFERENCES pricing_tabs(id) ON DELETE CASCADE,
plan_name VARCHAR(100) NOT NULL,
amount VARCHAR(50) NOT NULL,
period VARCHAR(50) NOT NULL,
save_text VARCHAR(255),
features TEXT[] NOT NULL,
button_text VARCHAR(100) NOT NULL,
is_featured BOOLEAN DEFAULT FALSE,
badge VARCHAR(100)
);
INSERT INTO about_us (id, about_text, image_url) VALUES (
1,
'Welcome to FY Tutoring. We are dedicated to providing premier educational support tailored to unlock every student''s potential. Through our highly refined programs, we ensure students excel across school curricula, OC preparation, and Selective School examinations.',
'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'
);
INSERT INTO tutors (name, qualifications, image_url) VALUES
('Ms Shalini Vijeyakumar', 'BSc MDc', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'),
('Mr Lachlan Reardon', 'BA(Hons) PhDc', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'),
('Mr Ricky Purani', 'BEng(Elec)', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'),
('Dr Thomas Dixon', 'BAeroEng (Hons I) PhD', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'),
('Mr Aydin Kilic', 'BMechatronicsEng (Hons I)', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'),
('Ms Abarnika Sivasamy', 'BEng(Hons) MBiomedEng', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'),
('Mr Steven Liu', 'BActSt BCom', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg'),
('Ms Rachel Zhang', 'BCommerce', 'https://t3.ftcdn.net/jpg/02/99/04/20/360_F_299042079_vGBD7wIlSeNl7vOevWHiL93G4koMM967.jpg');
INSERT INTO reviews (name, rating, text, subject) VALUES
('Sarah M.', 5, 'FY Tutoring has been absolutely incredible for my daughter. Her confidence in maths has skyrocketed and she jumped two bands in her last assessment.', 'Year 5 Maths OC Prep'),
('James L.', 5, 'Our son got into his selective school of choice after just one term with FY Tutoring. The tutors are passionate and genuinely care about results.', 'Selective School Prep'),
('Priya K.', 5, 'Brilliant experience from start to finish. The lessons are well-structured and the tutors explain concepts in a way that actually sticks. Highly recommended!', 'Year 4 English OC Prep'),
('Michael T.', 5, 'FY Tutoring''s approach is completely different from other tutoring centres. Very personalised, very effective. My son loves going every week.', 'Year 6 Selective Prep'),
('Angela W.', 5, 'My twins both attend FY Tutoring and the improvement has been night and day. The tutors are warm, encouraging and clearly know the OC/Selective curriculum inside out.', 'Year 5 OC Prep'),
('David C.', 5, 'Incredible results. My daughter went from average marks to consistently scoring in the top percentile. The tutors are world class for what they charge.', 'Year 6 Maths & English'),
('Tina R.', 5, 'I was sceptical about tutoring at first but FY Tutoring changed my mind completely. Very professional, very passionate, and the results speak for themselves.', 'Year 4 Maths OC Prep'),
('Kevin H.', 5, 'My son is now at James Ruse after working with FY Tutoring. Worth every cent. The tutors are high achievers themselves and that energy rubs off on students.', 'Selective School Prep'),
('Lisa F.', 5, 'Absolutely love the personalised attention. The tutors took the time to understand exactly where my daughter was struggling and built a targeted plan around that.', 'Year 5 English OC Prep'),
('Omar A.', 5, 'FY Tutoring is the real deal. The tutors are relatable, smart, and incredibly effective. My son''s reading and comprehension have improved enormously.', 'Year 4 English');
INSERT INTO reasons (num, title, text) VALUES
(1, 'Experienced tutors', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.'),
(2, 'Personalised plans', 'Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.'),
(3, 'Proven results', 'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.'),
(4, 'Flexible scheduling', 'Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.');
INSERT INTO pricing_tabs (id, label, is_active) VALUES
('k2', 'K-2', TRUE),
('yr34', '3-4', FALSE),
('yr56', '5-6', FALSE),
('yr7', 'Year 7', FALSE);
INSERT INTO pricing_plans (tab_id, plan_name, amount, period, save_text, features, button_text, is_featured, badge)
VALUES
('k2', 'Homework Help', '$300', '/term', 'Payment Upfront Required', ARRAY['Weekly guided homework sessions', 'Review of school curriculum topics', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL),
('k2', 'Group Tutoring', '$350', '/term', 'Payment Upfront Required', ARRAY['Small group collaborative learning', 'Targeted skill building and worksheets', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', TRUE, 'Most Popular'),
('k2', '1-on-1 Tutoring', '$450', '/term', 'Payment Upfront Required', ARRAY['Fully personalised private lessons', 'Customised learning pace and goals', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL),
('yr34', 'Homework Help', '$300', '/term', 'Payment Upfront Required', ARRAY['Weekly guided homework sessions', 'Review of school curriculum topics', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL),
('yr34', 'Group Tutoring', '$350', '/term', 'Payment Upfront Required', ARRAY['Small group collaborative learning', 'Targeted skill building and worksheets', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', TRUE, 'Most Popular'),
('yr34', '1-on-1 Tutoring', '$450', '/term', 'Payment Upfront Required', ARRAY['Fully personalised private lessons', 'Customised learning pace and goals', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL),
('yr56', 'Homework Help', '$300', '/term', 'Payment Upfront Required', ARRAY['Weekly guided homework sessions', 'Review of school curriculum topics', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL),
('yr56', 'Group Tutoring', '$350', '/term', 'Payment Upfront Required', ARRAY['Small group collaborative learning', 'Targeted skill building and worksheets', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', TRUE, 'Most Popular'),
('yr56', '1-on-1 Tutoring', '$450', '/term', 'Payment Upfront Required', ARRAY['Fully personalised private lessons', 'Customised learning pace and goals', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL),
('yr7', 'Homework Help', '$300', '/term', 'Payment Upfront Required', ARRAY['Weekly guided homework sessions', 'Review of school curriculum topics', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL),
('yr7', 'Group Tutoring', '$350', '/term', 'Payment Upfront Required', ARRAY['Small group collaborative learning', 'Targeted skill building and worksheets', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', TRUE, 'Most Popular'),
('yr7', '1-on-1 Tutoring', '$450', '/term', 'Payment Upfront Required', ARRAY['Fully personalised private lessons', 'Customised learning pace and goals', '5% off if booked for full Term 3 in advance', 'Duo discount: 20% off each for same-grade pairs', 'Referral bonus: 5% off your next term'], 'Enrol Now', FALSE, NULL)