-- FFL seed — TEK NAKON uspješnog importa schema.sql
-- Ako greška 1146: nisi importao schema.sql ili kriva baza.
-- FFL seed data
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
INSERT INTO admin_users (email, password_hash, name, created_at, updated_at) VALUES ('admin@fitfor-life.eu', '$2b$10$cmmwVET//qG1XV0enK3XYuXsxukAWKecI1mW6eRWUHQHK.bWj2crm', 'Administrator', NOW(3), NOW(3));
INSERT INTO site_settings (id, phone, phone_alt, email, address, facebook_url, instagram_url, company_name, company_oib, company_person, company_seat, seo_title, seo_description, footer_text, updated_at) VALUES (1, '098 9988 217', '091 798 51 79', 'info@fitfor-life.eu', 'Kumičićeva 61, Rijeka', 'https://www.facebook.com/FitforlifeRijeka/', NULL, 'Društvo sportske rekreacije Fit for Life', '92351907933', 'Kristijan Torbarac', 'Slavke Raškaj 15', 'Fit for Life | Trening centar Rijeka', 'Fit for Life trening centar specijaliziran je za programe individualnih i grupnih treninga u Rijeci.', 'Copyright © FIT for LIFE. Sva prava pridržana.', NOW(3));
INSERT INTO page_contents (slug, title, headline, body, published, updated_at) VALUES ('home', 'Naslovnica', 'BITI FIT NIJE MIT', 'Fit for Life trening centar specijaliziran je za programe individualnih i grupnih treninga. Mali broj polaznika, individualan pristup i rezultati koji se vide.', 1, NOW(3));
INSERT INTO page_contents (slug, title, headline, body, published, updated_at) VALUES ('o-nama', 'O nama', 'O nama', 'Fit for life fitness centar je specijaliziran za programe individualnih i grupnih treninga. Smješten je u neposrednoj blizini Tete Rože, u atraktivnom dvoetažnom prostoru od 300 m².

## Dvorana
• Prostor od 300 m² na dvije etaže
• Privatni parking (20 mjesta)
• Dvije dvorane opremljene najsuvremenijim spravama Panatta Sport
• Prostrane i potpuno nove svlačionice s tuševima', 1, NOW(3));
INSERT INTO page_contents (slug, title, headline, body, published, updated_at) VALUES ('grupni-treninzi', 'Grupni treninzi', 'Grupni treninzi', 'Grupni treninzi odlični su za one kojima se je teško natjerati da treniraju sami.

## Programi
• Funkcionalni kružni trening (60 min)
• Tabata (45–60 min)
• Abs''N''Glutes (do 60 min)
• 60+ program (do 60 min)
• Cross trening', 1, NOW(3));
INSERT INTO page_contents (slug, title, headline, body, published, updated_at) VALUES ('individualni-treninzi', 'Individualni treninzi', 'Individualni treninzi', 'Individualni treninzi su tu kako bi se tvojim ciljevima posvetili 100%. Termine dogovaraš individualno.', 1, NOW(3));
INSERT INTO trainers (slug, name, role, bio, quote, photo_path, specialties, website_url, sort_order, published, created_at, updated_at) VALUES ('toni-beletic', 'Toni Beletić', 'Cross trening, individualni treninzi, prehrana', 'Toni vodi treninge mobilnosti, jakosti i funkcionalnosti. Dostupan i za plan prehrane.', NULL, '/media/trainers/toni_desktop.png', 'Crossfit, powerlifting, nutricionizam', 'https://tonibeletic.com/', 1, 1, NOW(3), NOW(3));
INSERT INTO trainers (slug, name, role, bio, quote, photo_path, specialties, website_url, sort_order, published, created_at, updated_at) VALUES ('ante-kapov', 'Ante Kapov', 'Individualni i fitness treninzi', 'Bivši profesionalni košarkaš. Zadnjih 9 godina trener je u Fit for Life-u.', 'U fitness svijet ulazite zbog sebe i svoga zdravlja.', '/media/trainers/ante_desktop.png', 'Fitness, kondicija', NULL, 2, 1, NOW(3), NOW(3));
INSERT INTO trainers (slug, name, role, bio, quote, photo_path, specialties, website_url, sort_order, published, created_at, updated_at) VALUES ('barbara-lipovscak', 'Barbara Lipovšćak', 'Instruktorica yoge', 'Certificirana instruktorica yoge. Od 2020. održava grupne i individualne satove.', 'Svatko ima svoj razlog dolaska na sat yoge.', '/media/trainers/barbara_desktop.png', 'Hatha, Vinyasa, Yin, Aerial', 'https://instagram.com/yoga_withb', 3, 1, NOW(3), NOW(3));
INSERT INTO trainers (slug, name, role, bio, quote, photo_path, specialties, website_url, sort_order, published, created_at, updated_at) VALUES ('morena-ladika-franciskovic', 'Morena Ladika Frančišković', 'Grupni i individualni treninzi, TRX, trčanje', 'Instruktorica grupnog fitnessa. Vodi funkcionalne, Tabata, AbsNGlutes, 60+.', 'Veni, vidi, vježbaj!', '/media/trainers/morena_desktop.png', 'Funkcionalni, Tabata, TRX, 60+', NULL, 4, 1, NOW(3), NOW(3));
INSERT INTO trainers (slug, name, role, bio, quote, photo_path, specialties, website_url, sort_order, published, created_at, updated_at) VALUES ('dora', 'Dora', 'Trenerica', 'Članica Fit for Life trenerskog tima.', NULL, '/media/trainers/dora_desktop.png', NULL, NULL, 5, 1, NOW(3), NOW(3));
SET @toni := (SELECT id FROM trainers WHERE slug='toni-beletic');
SET @morena := (SELECT id FROM trainers WHERE slug='morena-ladika-franciskovic');
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (1, '07:00', '08:00', 'Funkcionalni kružni', 'Svi nivoi', @morena, 1, 1, NOW(3));
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (1, '18:00', '19:00', 'Tabata', 'Svi nivoi', @morena, 2, 1, NOW(3));
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (2, '07:00', '08:00', 'Abs''N''Glutes', 'Svi nivoi', @morena, 1, 1, NOW(3));
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (2, '18:00', '19:00', 'Cross trening', 'Srednji/napredni', @toni, 2, 1, NOW(3));
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (3, '07:00', '08:00', 'Funkcionalni kružni', 'Svi nivoi', @morena, 1, 1, NOW(3));
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (3, '09:00', '10:00', '60+ program', '60+', @morena, 2, 1, NOW(3));
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (4, '18:00', '19:00', 'Cross trening', 'Srednji/napredni', @toni, 1, 1, NOW(3));
INSERT INTO schedule_entries (day_of_week, start_time, end_time, title, level, trainer_id, sort_order, published, updated_at) VALUES (5, '07:00', '08:00', 'Tabata', 'Svi nivoi', @morena, 1, 1, NOW(3));
INSERT INTO pricing_categories (name, note, sort_order, published) VALUES ('Grupni treninzi', 'Male grupe, isti trener.', 1, 1);
SET @c1 := LAST_INSERT_ID();
INSERT INTO pricing_items (category_id, label, price, sort_order, published) VALUES (@c1,'2x tjedno','50 €',1,1),(@c1,'3x tjedno','60 €',2,1),(@c1,'4x tjedno','65 €',3,1),(@c1,'5x tjedno','70 €',4,1);
INSERT INTO pricing_categories (name, note, sort_order, published) VALUES ('Studenti – no limit', 'Jutarnji grupni.', 2, 1);
SET @c2 := LAST_INSERT_ID();
INSERT INTO pricing_items (category_id, label, price, sort_order, published) VALUES (@c2,'Grupni treninzi','45 €',1,1);
INSERT INTO pricing_categories (name, note, sort_order, published) VALUES ('Individualni i poluindividualni', 'Dogovor s trenerom.', 3, 1);
SET @c3 := LAST_INSERT_ID();
INSERT INTO pricing_items (category_id, label, price, sort_order, published) VALUES (@c3,'8 dolazaka','250 €',1,1),(@c3,'10 dolazaka','280 €',2,1),(@c3,'12 dolazaka','330 €',3,1),(@c3,'1 sat','35 €',4,1);
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life15e1f.jpg', 'Fit for Life dvorana', 1, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life25e1f.jpg', 'Fit for Life dvorana', 2, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life35e1f.jpg', 'Fit for Life dvorana', 3, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life45e1f.jpg', 'Fit for Life dvorana', 4, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life55e1f.jpg', 'Fit for Life dvorana', 5, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life65e1f.jpg', 'Fit for Life dvorana', 6, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life75e1f.jpg', 'Fit for Life dvorana', 7, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life85e1f.jpg', 'Fit for Life dvorana', 8, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('o-nama', '/media/gallery/onama-fit-for-life95e1f.jpg', 'Fit for Life dvorana', 9, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('grupni', '/media/gallery/grupni-fit-for-life1_small.jpg', 'Grupni', 1, 1, NOW(3));
INSERT INTO gallery_images (album, path, caption, sort_order, published, created_at) VALUES ('grupni', '/media/gallery/grupni-fit-for-life2_small.jpg', 'Grupni', 2, 1, NOW(3));
SET FOREIGN_KEY_CHECKS=1;