design: data_load.sql

INSERT INTO _user (name, email, login_provider, password_hash, verified, profile_complete, used_free_consultation, company_size, work_position, points)
VALUES
('Borjan Gjorgjievski', 'borjan@example.com', 'email', 'hash1', TRUE, TRUE, FALSE, '10-50', 'Software Engineer', 150),
('Davor Gjorgjievski', 'davor@example.com', 'google', 'hash2', TRUE, FALSE, TRUE, '51-200', 'Manager', 80);

INSERT INTO meeting_email_reminder (meeting_at, scheduled_at, sent, meeting_link, user_id)
VALUES
('2026-02-01 10:00:00', '2026-01-31 10:00:00', FALSE, 'https://meet.example.com/borjan', 1),
('2026-02-03 12:00:00', '2026-02-02 12:00:00', TRUE, 'https://meet.example.com/davor', 2);

INSERT INTO expert (name, email, login_provider, password_hash)
VALUES
('Aco Gjorgjievski', 'aco@example.com', 'email', 'hash3');

INSERT INTO course (image_url, color, difficulty, duration_minutes, price)
VALUES
('https://example.com/course1.png', '#FF5733', 'Beginner', 90, 49.99),
('https://example.com/course2.png', '#2ECC71', 'Intermediate', 180, 99.99);

INSERT INTO expert_course (course_id, expert_id)
VALUES
(1, 1),
(2, 1);

INSERT INTO course_version (version_number, active, course_id)
VALUES
(1, TRUE, 1),
(1, TRUE, 2);

INSERT INTO enrollment (enrollment_status, purchase_date, activation_date, completion_date, course_version_id, user_id)
VALUES
('active', '2026-01-05', '2026-01-06', NULL, 1, 1),
('completed', '2025-12-01', '2025-12-02', '2026-01-15', 1, 2);

INSERT INTO payment (amount, payment_method, payment_status, enrollment_id)
VALUES
(49.99, 'credit_card', 'completed', 1),
(49.99, 'paypal', 'completed', 2);

INSERT INTO review (rating, comment, enrollment_id)
VALUES
(5, 'Одличен курс!', 2);

INSERT INTO course_translate (language, title_short, title, description_short, description, description_long, course_id)
VALUES
('en', 'Intro', 'Business Fundamentals', 'Short description', 'Course description', 'Long course description', 1),
('mk', 'Voved', 'Основи на бизнис', 'Краток опис', 'Опис на курсот', 'Детален опис', 1),
('en', 'Growth', 'Business Growth Strategy', 'Short description', 'Course description', 'Long course description', 2),
('mk', 'Rast', 'Стратегија за раст на биснисот', 'Краток опис', 'Опис на курсот', 'Детален опис', 2);

INSERT INTO course_translate_what_will_be_learned (course_translate_id, what_will_be_learned)
VALUES
(1, 'Understand business basics'),
(1, 'Learn core concepts'),
(2, 'Разбирање на основите на бизнисот'),
(3, 'Scale a business'),
(4, 'Скалирање на вашиот бизнис');

INSERT INTO course_content (position, course_version_id)
VALUES
(1, 1),
(2, 1);

INSERT INTO course_content_translate (title, language, course_content_id)
VALUES
('Introduction Module', 'en', 1),
('Воведен модул', 'mk', 1),
('Growth Module', 'en', 2),
('Модул за раст', 'mk', 2);

INSERT INTO course_lecture (duration_minutes, position, content_type, course_content_id)
VALUES
(20, 1, 'video', 1),
(15, 2, 'text', 1),
(30, 1, 'video', 2);

INSERT INTO course_lecture_translate (title, language, content_file_name, description, content_text, course_lecture_id)
VALUES
('Welcome Video', 'en', 'welcome.mp4', 'Intro video', NULL, 1),
('Добредојде', 'mk', 'dobredojde.mp4', 'Воведно видео', NULL, 1),
('Business Basics', 'en', NULL, 'Lecture text', 'Business fundamentals explained', 2),
('Основи на бизнисот', 'mk', NULL, 'Текст лекција', 'Објаснување на основите', 2),
('Scaling Video', 'en', 'scale.mp4', 'Growth strategies', NULL, 3);

INSERT INTO user_course_progress (completed, completed_at, enrollment_id, course_lecture_id)
VALUES
(TRUE, '2026-01-10 14:00:00', 2, 1),
(FALSE, NULL, 1, 2);

INSERT INTO verification_token (expired_at, user_id)
VALUES
('2026-02-10 00:00:00', 1),
('2026-02-15 00:00:00', 2);

INSERT INTO tag (type)
VALUES
('skill'),
('interest');

INSERT INTO tag_translate (language, value, tag_id)
VALUES
('en', 'Leadership', 1),
('mk', 'Liderstvo', 1),
('en', 'Entrepreneurship', 2),
('mk', 'Претприемништво', 2);

INSERT INTO user_tag (tag_id, user_id)
VALUES
(1, 1),
(2, 1),
(2, 2);

INSERT INTO course_tag (tag_id, course_id)
VALUES
(1, 1),
(2, 2);

INSERT INTO user_favorite_course_ids (user_id, favorite_course_ids)
VALUES
(1, 1),
(1, 2),
(2, 2);