Index: backend/index.js =================================================================== --- backend/index.js (revision 3dfc0fe259a057856206daa8d25445f3cc6a113f) +++ backend/index.js (revision 6d216e3600e9b1267a63df82095c722036eb0fbf) @@ -19,8 +19,10 @@ [username, email, password, firstName, lastName] ); - - const userId = result.rows[0].user_id; - res.json({ success: true, userId }); + res.json({ success: true, userId: result.rows[0].user_id }); } catch (err) { + if (err.code === "23505") { + // Violated UNIQUE (email/username) + return res.status(409).json({ success: false, error: "Email or username already in use" }); + } console.error(err); res.status(500).json({ success: false, error: "Server error" }); @@ -30,23 +32,17 @@ // 2) Register Instructor app.post("/api/register-instructor", async (req, res) => { - const { - instructorEmail, - instructorPassword, - firstName, - lastName, - biography, - } = req.body; + const { instructorEmail, instructorPassword, firstName, lastName, biography } = req.body; try { const result = await pool.query( - `INSERT INTO "Instructor" - (instructor_email, instructor_password_hash, first_name, last_name, biography) + `INSERT INTO "Instructor" (instructor_email, instructor_password_hash, first_name, last_name, biography) VALUES ($1, $2, $3, $4, $5) RETURNING instructor_id`, [instructorEmail, instructorPassword, firstName, lastName, biography] ); - - const instructorId = result.rows[0].instructor_id; - res.json({ success: true, instructorId }); + res.json({ success: true, instructorId: result.rows[0].instructor_id }); } catch (err) { + if (err.code === "23505") { + return res.status(409).json({ success: false, error: "Instructor email already in use" }); + } console.error(err); res.status(500).json({ success: false, error: "Server error" }); Index: frontend/src/App.js =================================================================== --- frontend/src/App.js (revision 3dfc0fe259a057856206daa8d25445f3cc6a113f) +++ frontend/src/App.js (revision 6d216e3600e9b1267a63df82095c722036eb0fbf) @@ -19,6 +19,5 @@ const [instBio, setInstBio] = useState(""); - // We'll keep track of the current userId (for a student) - // If we want to handle instructor, we might store instructorId separately + // Keep track of the current userId (for a student) const [userId, setUserId] = useState(null); @@ -26,7 +25,6 @@ const [events, setEvents] = useState([]); - ////////////////////////////////////////////////// // 1) Register as Student - ////////////////////////////////////////////////// + const handleStudentRegister = async () => { try { @@ -60,7 +58,6 @@ }; - ////////////////////////////////////////////////// // 2) Register as Instructor - ////////////////////////////////////////////////// + const handleInstructorRegister = async () => { try { @@ -82,5 +79,5 @@ if (data.success) { alert("Instructor registered. instructorId = " + data.instructorId); - // If you want to do something else, do it here + setView("home"); } else { @@ -93,7 +90,6 @@ }; - ////////////////////////////////////////////////// // 3) Load Events - ////////////////////////////////////////////////// + const loadEvents = async () => { try { @@ -111,7 +107,6 @@ }; - ////////////////////////////////////////////////// // 4) Register for an event - ////////////////////////////////////////////////// + const handleRegisterEvent = async (eventId) => { if (!userId) { @@ -139,7 +134,6 @@ }; - ////////////////////////////////////////////////// // Render pages - ////////////////////////////////////////////////// + if (view === "home") { return ( @@ -240,5 +234,5 @@ } - // After student registers, let's show them the events + // After student registers, show them the events if (view === "studentEvents") { return ( Index: sql_scripts/create.sql =================================================================== --- sql_scripts/create.sql (revision 6d216e3600e9b1267a63df82095c722036eb0fbf) +++ sql_scripts/create.sql (revision 6d216e3600e9b1267a63df82095c722036eb0fbf) @@ -0,0 +1,160 @@ +-- create.sql (BlissCore) + +-- RESET (optional): + +/* +-- Drop NEW bridge tables (if they exist) +DROP TABLE IF EXISTS "User_Booked_Class" CASCADE; +DROP TABLE IF EXISTS "Class_Includes_Training" CASCADE; +DROP TABLE IF EXISTS "User_Purchased_Package" CASCADE; +DROP TABLE IF EXISTS "User_Purchased_Merch" CASCADE; +DROP TABLE IF EXISTS "Package_Includes_Class" CASCADE; + +-- Drop OLD bridge tables (from previous versions) just in case +DROP TABLE IF EXISTS "User_Class" CASCADE; +DROP TABLE IF EXISTS "Class_Training" CASCADE; +DROP TABLE IF EXISTS "User_Package" CASCADE; +DROP TABLE IF EXISTS "User_Merch" CASCADE; +DROP TABLE IF EXISTS "Package_Class" CASCADE; +DROP TABLE IF EXISTS "User_Event" CASCADE; + +-- Drop base tables (order matters due to FKs) +DROP TABLE IF EXISTS "Merch_Items" CASCADE; +DROP TABLE IF EXISTS "Package" CASCADE; +DROP TABLE IF EXISTS "Event" CASCADE; +DROP TABLE IF EXISTS "Class" CASCADE; +DROP TABLE IF EXISTS "Training" CASCADE; +DROP TABLE IF EXISTS "Instructor" CASCADE; +DROP TABLE IF EXISTS "User" CASCADE; +*/ + + +-- CREATE TABLES + +CREATE TABLE IF NOT EXISTS "User" ( + user_id BIGSERIAL PRIMARY KEY, + username VARCHAR(50) NOT NULL, + email VARCHAR(100) NOT NULL, + password_hash VARCHAR(150) NOT NULL, + first_name VARCHAR(50), + last_name VARCHAR(50) +); + + +CREATE TABLE IF NOT EXISTS "Instructor" ( + instructor_id BIGSERIAL PRIMARY KEY, + instructor_email VARCHAR(100) NOT NULL, + instructor_password_hash VARCHAR(150) NOT NULL, + first_name VARCHAR(50) NOT NULL, + last_name VARCHAR(50) NOT NULL, + biography TEXT +); + + +CREATE TABLE IF NOT EXISTS "Training" ( + training_id BIGSERIAL PRIMARY KEY, + training_name VARCHAR(100) NOT NULL, + description TEXT, + duration INT, + intensity_level VARCHAR(50) +); + + +CREATE TABLE IF NOT EXISTS "Class" ( + class_id BIGSERIAL PRIMARY KEY, + date DATE NOT NULL, + start_time TIME NOT NULL, + end_time TIME NOT NULL, + location VARCHAR(100) NOT NULL, + capacity INT, + seats_available INT, + instructor_id BIGINT, + CONSTRAINT fk_instructor + FOREIGN KEY (instructor_id) + REFERENCES "Instructor"(instructor_id) + ON DELETE SET NULL +); + + +CREATE TABLE IF NOT EXISTS "Event" ( + event_id BIGSERIAL PRIMARY KEY, + event_name VARCHAR(100) NOT NULL, + description TEXT, + date DATE NOT NULL, + time TIME NOT NULL, + location VARCHAR(100) NOT NULL +); + + +CREATE TABLE IF NOT EXISTS "Package" ( + package_id BIGSERIAL PRIMARY KEY, + package_name VARCHAR(100) NOT NULL, + price DECIMAL(10,2) NOT NULL, + num_classes INT NOT NULL +); + + +CREATE TABLE IF NOT EXISTS "Merch_Items" ( + merch_id BIGSERIAL PRIMARY KEY, + item_name VARCHAR(100) NOT NULL, + description TEXT, + price DECIMAL(10,2) NOT NULL, + quantity_in_stock INT +); + +-- M:N BRIDGE TABLES (new names) +---------------------------------------------------- + +-- (1) User books a Class +CREATE TABLE IF NOT EXISTS "User_Booked_Class" ( + user_id BIGINT, + class_id BIGINT, + PRIMARY KEY(user_id, class_id), + FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, + FOREIGN KEY (class_id) REFERENCES "Class"(class_id) ON DELETE CASCADE +); + +-- (2) A Class includes one or more Trainings +CREATE TABLE IF NOT EXISTS "Class_Includes_Training" ( + class_id BIGINT, + training_id BIGINT, + PRIMARY KEY(class_id, training_id), + FOREIGN KEY (class_id) REFERENCES "Class"(class_id) ON DELETE CASCADE, + FOREIGN KEY (training_id) REFERENCES "Training"(training_id) ON DELETE CASCADE +); + +-- (3) User registers for an Event +CREATE TABLE IF NOT EXISTS "User_Event" ( + user_id BIGINT, + event_id BIGINT, + PRIMARY KEY(user_id, event_id), + FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, + FOREIGN KEY (event_id) REFERENCES "Event"(event_id) ON DELETE CASCADE +); + +-- (4) User purchases a Package +CREATE TABLE IF NOT EXISTS "User_Purchased_Package" ( + user_id BIGINT, + package_id BIGINT, + PRIMARY KEY(user_id, package_id), + FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, + FOREIGN KEY (package_id) REFERENCES "Package"(package_id) ON DELETE CASCADE +); + +-- (5) User purchases Merch +CREATE TABLE IF NOT EXISTS "User_Purchased_Merch" ( + user_id BIGINT, + merch_id BIGINT, + PRIMARY KEY(user_id, merch_id), + FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, + FOREIGN KEY (merch_id) REFERENCES "Merch_Items"(merch_id) ON DELETE CASCADE +); + +-- (6) Package includes specific Classes +CREATE TABLE IF NOT EXISTS "Package_Includes_Class" ( + package_id BIGINT, + class_id BIGINT, + PRIMARY KEY(package_id, class_id), + FOREIGN KEY (package_id) REFERENCES "Package"(package_id) ON DELETE CASCADE, + FOREIGN KEY (class_id) REFERENCES "Class"(class_id) ON DELETE CASCADE +); Index: sql_scripts/fill_in.sql =================================================================== --- sql_scripts/fill_in.sql (revision 6d216e3600e9b1267a63df82095c722036eb0fbf) +++ sql_scripts/fill_in.sql (revision 6d216e3600e9b1267a63df82095c722036eb0fbf) @@ -0,0 +1,149 @@ +-- fill_in.sql (robust, ID-agnostic) + +-- Optional: clear data if re-running +-- (Do bridges first to avoid FK issues) +DELETE FROM "User_Purchased_Package"; +DELETE FROM "User_Purchased_Merch"; +DELETE FROM "User_Event"; +DELETE FROM "User_Booked_Class"; +DELETE FROM "Class_Includes_Training"; + +DELETE FROM "Merch_Items"; +DELETE FROM "Package"; +DELETE FROM "Event"; +DELETE FROM "Class"; +DELETE FROM "Training"; +DELETE FROM "Instructor"; +DELETE FROM "User"; + + +INSERT INTO "User" (username, email, password_hash, first_name, last_name) +VALUES +('ana123', 'ana@example.com', 'hashA1', 'Ana', 'Naumovska'), +('mikiYoga', 'miki@example.com', 'hashA2', 'Miki', 'Trajkov'), +('davidG', 'david@example.com', 'hashA3', 'David', 'Georgiev'); + + +INSERT INTO "Instructor" (instructor_email, instructor_password_hash, first_name, last_name, biography) +VALUES +('elena@studio.com', 'passElena', 'Elena', 'Petrova', 'Certified in Vinyasa Yoga'), +('stefan@studio.com', 'passStefan', 'Stefan', 'Ristov', 'Hatha & Yin Yoga Teacher'); + + +INSERT INTO "Training" (training_name, description, duration, intensity_level) +VALUES +('Vinyasa Flow', 'Linking breath to movement', 60, 'Intermediate'), +('Hatha Basics', 'Focus on foundational poses', 45, 'Beginner'); + + +INSERT INTO "Class" (date, start_time, end_time, location, capacity, seats_available, instructor_id) +VALUES +('2025-06-10', '08:00', '09:00', 'Studio A', 20, 20, + (SELECT instructor_id FROM "Instructor" WHERE instructor_email='elena@studio.com')), +('2025-06-10', '09:30', '10:30', 'Studio B', 15, 15, + (SELECT instructor_id FROM "Instructor" WHERE instructor_email='stefan@studio.com')); + + +INSERT INTO "Event" (event_name, description, date, time, location) +VALUES +('Summer Yoga Workshop', 'Outdoor event for all levels', '2025-07-05', '09:00', 'City Park'), +('Meditation Retreat', 'Weekend retreat with meditation', '2025-08-01', '08:00', 'Mountain Lodge'); + + +INSERT INTO "Package" (package_name, price, num_classes) +VALUES +('5-Class Pass', 25.00, 5), +('10-Class Pass', 45.00, 10); + + +INSERT INTO "Merch_Items" (item_name, description, price, quantity_in_stock) +VALUES +('Yoga Mat', 'Eco-friendly TPE mat', 30.00, 50), +('Yoga Block', 'Cork block for alignment', 12.00, 30); + + +-- Bridge tables (via sub-selects, no hardcoded IDs) + +-- User_Booked_Class (books) +INSERT INTO "User_Booked_Class" (user_id, class_id) +VALUES +( + (SELECT user_id FROM "User" WHERE email='ana@example.com'), + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='08:00' AND location='Studio A') +), +( + (SELECT user_id FROM "User" WHERE email='miki@example.com'), + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='08:00' AND location='Studio A') +), +( + (SELECT user_id FROM "User" WHERE email='david@example.com'), + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='09:30' AND location='Studio B') +); + +-- Class_Includes_Training (is_scheduled_for) +INSERT INTO "Class_Includes_Training" (class_id, training_id) +VALUES +( + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='08:00' AND location='Studio A'), + (SELECT training_id FROM "Training" WHERE training_name='Vinyasa Flow') +), +( + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='09:30' AND location='Studio B'), + (SELECT training_id FROM "Training" WHERE training_name='Hatha Basics') +); + +-- User_Event (registers) (backend expects this table name) +INSERT INTO "User_Event" (user_id, event_id) +VALUES +( + (SELECT user_id FROM "User" WHERE email='ana@example.com'), + (SELECT event_id FROM "Event" WHERE event_name='Summer Yoga Workshop' AND date='2025-07-05') +), +( + (SELECT user_id FROM "User" WHERE email='miki@example.com'), + (SELECT event_id FROM "Event" WHERE event_name='Meditation Retreat' AND date='2025-08-01') +); + +-- User_Purchased_Package (buys) +INSERT INTO "User_Purchased_Package" (user_id, package_id) +VALUES +( + (SELECT user_id FROM "User" WHERE email='ana@example.com'), + (SELECT package_id FROM "Package" WHERE package_name='5-Class Pass') +), +( + (SELECT user_id FROM "User" WHERE email='miki@example.com'), + (SELECT package_id FROM "Package" WHERE package_name='10-Class Pass') +); + +-- User_Purchased_Merch (purchases) +INSERT INTO "User_Purchased_Merch" (user_id, merch_id) +VALUES +( + (SELECT user_id FROM "User" WHERE email='ana@example.com'), + (SELECT merch_id FROM "Merch_Items" WHERE item_name='Yoga Mat') +), +( + (SELECT user_id FROM "User" WHERE email='ana@example.com'), + (SELECT merch_id FROM "Merch_Items" WHERE item_name='Yoga Block') +), +( + (SELECT user_id FROM "User" WHERE email='miki@example.com'), + (SELECT merch_id FROM "Merch_Items" WHERE item_name='Yoga Block') +); + +-- Package_Includes_Class (is_for) +INSERT INTO "Package_Includes_Class" (package_id, class_id) +VALUES +( + (SELECT package_id FROM "Package" WHERE package_name='5-Class Pass'), + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='08:00' AND location='Studio A') +), +( + (SELECT package_id FROM "Package" WHERE package_name='5-Class Pass'), + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='09:30' AND location='Studio B') +), +( + (SELECT package_id FROM "Package" WHERE package_name='10-Class Pass'), + (SELECT class_id FROM "Class" WHERE date='2025-06-10' AND start_time='08:00' AND location='Studio A') +); Index: l_scripts/kreiranje.sql =================================================================== --- sql_scripts/kreiranje.sql (revision 3dfc0fe259a057856206daa8d25445f3cc6a113f) +++ (revision ) @@ -1,156 +1,0 @@ --- kreiranje.sql - ---------------------------------------------------------- --- 1) USER TABLE ---------------------------------------------------------- -CREATE TABLE IF NOT EXISTS "User" ( - user_id BIGSERIAL PRIMARY KEY, - username VARCHAR(50) NOT NULL, - email VARCHAR(100) NOT NULL, - password_hash VARCHAR(150) NOT NULL, - first_name VARCHAR(50), - last_name VARCHAR(50) -); - ---------------------------------------------------------- --- 2) INSTRUCTOR TABLE ---------------------------------------------------------- -CREATE TABLE IF NOT EXISTS "Instructor" ( - instructor_id BIGSERIAL PRIMARY KEY, - instructor_email VARCHAR(100) NOT NULL, - instructor_password_hash VARCHAR(150) NOT NULL, - first_name VARCHAR(50) NOT NULL, - last_name VARCHAR(50) NOT NULL, - biography TEXT -); - ---------------------------------------------------------- --- 3) TRAINING TABLE ---------------------------------------------------------- -CREATE TABLE IF NOT EXISTS "Training" ( - training_id BIGSERIAL PRIMARY KEY, - training_name VARCHAR(100) NOT NULL, - description TEXT, - duration INT, - intensity_level VARCHAR(50) -); - ---------------------------------------------------------- --- 4) CLASS TABLE ---------------------------------------------------------- -CREATE TABLE IF NOT EXISTS "Class" ( - class_id BIGSERIAL PRIMARY KEY, - date DATE NOT NULL, - start_time TIME NOT NULL, - end_time TIME NOT NULL, - location VARCHAR(100) NOT NULL, - capacity INT, - seats_available INT, - instructor_id BIGINT, - CONSTRAINT fk_instructor - FOREIGN KEY (instructor_id) - REFERENCES "Instructor"(instructor_id) - ON DELETE SET NULL -); - ---------------------------------------------------------- --- 5) EVENT TABLE ---------------------------------------------------------- -CREATE TABLE IF NOT EXISTS "Event" ( - event_id BIGSERIAL PRIMARY KEY, - event_name VARCHAR(100) NOT NULL, - description TEXT, - date DATE NOT NULL, - time TIME NOT NULL, - location VARCHAR(100) NOT NULL -); - ---------------------------------------------------------- --- 6) PACKAGE TABLE ---------------------------------------------------------- -CREATE TABLE IF NOT EXISTS "Package" ( - package_id BIGSERIAL PRIMARY KEY, - package_name VARCHAR(100) NOT NULL, - price DECIMAL(10,2) NOT NULL, - num_classes INT NOT NULL -); - ---------------------------------------------------------- --- 7) MERCH_ITEMS TABLE ---------------------------------------------------------- -CREATE TABLE IF NOT EXISTS "Merch_Items" ( - merch_id BIGSERIAL PRIMARY KEY, - item_name VARCHAR(100) NOT NULL, - description TEXT, - price DECIMAL(10,2) NOT NULL, - quantity_in_stock INT -); - ---------------------------------------------------------- --- M:N RELATIONSHIP TABLES ---------------------------------------------------------- - --- (1) USER_CLASS (books) -CREATE TABLE IF NOT EXISTS "User_Class" ( - user_id BIGINT, - class_id BIGINT, - PRIMARY KEY(user_id, class_id), - FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, - FOREIGN KEY (class_id) REFERENCES "Class"(class_id) ON DELETE CASCADE -); - --- (2) CLASS_TRAINING (is_scheduled_for) -CREATE TABLE IF NOT EXISTS "Class_Training" ( - class_id BIGINT, - training_id BIGINT, - PRIMARY KEY(class_id, training_id), - FOREIGN KEY (class_id) REFERENCES "Class"(class_id) ON DELETE CASCADE, - FOREIGN KEY (training_id) REFERENCES "Training"(training_id) ON DELETE CASCADE -); - --- (3) USER_EVENT (registers) -CREATE TABLE IF NOT EXISTS "User_Event" ( - user_id BIGINT, - event_id BIGINT, - PRIMARY KEY(user_id, event_id), - FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, - FOREIGN KEY (event_id) REFERENCES "Event"(event_id) ON DELETE CASCADE -); - --- (4) USER_PACKAGE (buys) -CREATE TABLE IF NOT EXISTS "User_Package" ( - user_id BIGINT, - package_id BIGINT, - PRIMARY KEY(user_id, package_id), - FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, - FOREIGN KEY (package_id) REFERENCES "Package"(package_id) ON DELETE CASCADE -); - --- (5) USER_MERCH (purchases) -CREATE TABLE IF NOT EXISTS "User_Merch" ( - user_id BIGINT, - merch_id BIGINT, - PRIMARY KEY(user_id, merch_id), - FOREIGN KEY (user_id) REFERENCES "User"(user_id) ON DELETE CASCADE, - FOREIGN KEY (merch_id) REFERENCES "Merch_Items"(merch_id) ON DELETE CASCADE -); - --- (6) PACKAGE_CLASS (is_for) -CREATE TABLE IF NOT EXISTS "Package_Class" ( - package_id BIGINT, - class_id BIGINT, - PRIMARY KEY(package_id, class_id), - FOREIGN KEY (package_id) REFERENCES "Package"(package_id) ON DELETE CASCADE, - FOREIGN KEY (class_id) REFERENCES "Class"(class_id) ON DELETE CASCADE -); - ---------------------------------------------------------- --- Optional: Drop Statements (Commented Out) ---------------------------------------------------------- --- DROP TABLE IF NOT EXISTS "Package_Class" CASCADE; --- DROP TABLE IF NOT EXISTS "User_Merch" CASCADE; --- DROP TABLE IF NOT EXISTS "User_Class" CASCADE; --- DROP TABLE IF NOT EXISTS "User" CASCADE; --- etc. - --- End of kreiranje.sql Index: l_scripts/polnenje.sql =================================================================== --- sql_scripts/polnenje.sql (revision 3dfc0fe259a057856206daa8d25445f3cc6a113f) +++ (revision ) @@ -1,109 +1,0 @@ --- polnenje.sql - ---------------------------------------------------------- --- SAMPLE DATA for BLISSCORE ---------------------------------------------------------- - ------------------------- --- 1) INSERT Users ------------------------- -INSERT INTO "User" (username, email, password_hash, first_name, last_name) -VALUES -('ana123', 'ana@example.com', 'hash_ana', 'Ana', 'Naumovska'), -('mikiYoga', 'miki@example.com', 'hash_miki', 'Miki', 'Trajkov'), -('davidG', 'david@example.com', 'hash_david', 'David', 'Georgiev'); - ------------------------- --- 2) INSERT Instructors ------------------------- --- Now includes instructor_email and instructor_password_hash -INSERT INTO "Instructor" (instructor_email, instructor_password_hash, first_name, last_name, biography) -VALUES -('elena@blisscore.com', 'hash_elena', 'Elena', 'Petrova', 'Certified Vinyasa Yoga Instructor'), -('stefan@blisscore.com', 'hash_stefan', 'Stefan', 'Ristov', 'Hatha & Yin Yoga Teacher'); - ------------------------- --- 3) INSERT Trainings ------------------------- -INSERT INTO "Training" (training_name, description, duration, intensity_level) -VALUES -('Vinyasa Flow', 'Linking breath to movement', 60, 'Intermediate'), -('Hatha Basics', 'Slower practice, foundational poses', 45, 'Beginner'); - ------------------------- --- 4) INSERT Classes ------------------------- -INSERT INTO "Class" (date, start_time, end_time, location, capacity, seats_available, instructor_id) -VALUES -('2025-05-15', '08:00', '09:00', 'Studio A', 20, 20, 1), -('2025-05-15', '09:30', '10:30', 'Studio B', 15, 15, 2); - ------------------------- --- 5) INSERT Events ------------------------- -INSERT INTO "Event" (event_name, description, date, time, location) -VALUES -('Spring Yoga Workshop', 'Outdoor session for all levels', '2025-04-10', '09:00', 'City Park'), -('Meditation Retreat', 'Weekend retreat with guided meditation', '2025-08-01', '08:00', 'Mountain Lodge'); - ------------------------- --- 6) INSERT Packages ------------------------- -INSERT INTO "Package" (package_name, price, num_classes) -VALUES -('5-Class Pass', 25.00, 5), -('10-Class Pass', 45.00, 10); - ------------------------- --- 7) INSERT Merch Items ------------------------- -INSERT INTO "Merch_Items" (item_name, description, price, quantity_in_stock) -VALUES -('Yoga Mat', 'Eco-friendly mat', 30.00, 50), -('Yoga Block', 'Cork block for alignment', 12.00, 30); - -------------------------------------------------------- --- M:N BRIDGE TABLES -------------------------------------------------------- - --- user_class (books) -INSERT INTO "User_Class" (user_id, class_id) -VALUES -(1, 1), -- Ana books Class 1 -(2, 1), -- Miki also books Class 1 -(3, 2); -- David books Class 2 - --- class_training (is_scheduled_for) -INSERT INTO "Class_Training" (class_id, training_id) -VALUES -(1, 1), -- Class 1 includes Vinyasa Flow -(2, 2); -- Class 2 includes Hatha Basics - --- user_event (registers) -INSERT INTO "User_Event" (user_id, event_id) -VALUES -(1, 1), -- Ana registers for Spring Yoga Workshop -(2, 2); -- Miki registers for Meditation Retreat - --- user_package (buys) -INSERT INTO "User_Package" (user_id, package_id) -VALUES -(1, 1), -- Ana buys 5-Class Pass -(2, 1), -- Miki also buys 5-Class Pass -(3, 2); -- David buys 10-Class Pass - --- user_merch (purchases) -INSERT INTO "User_Merch" (user_id, merch_id) -VALUES -(1, 1), -- Ana buys a Yoga Mat -(1, 2), -- Ana also buys a Yoga Block -(2, 2); -- Miki buys a Yoga Block - --- package_class (is_for) -INSERT INTO "Package_Class" (package_id, class_id) -VALUES -(1, 1), -- 5-Class Pass includes Class 1 -(1, 2), -- 5-Class Pass includes Class 2 -(2, 1); -- 10-Class Pass includes Class 1 - --- End of polnenje.sql