-- ==========================================
-- 1. DATABASE SETUP
-- ==========================================
CREATE DATABASE IF NOT EXISTS japantourhub CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE japantourhub;

-- Drop old tables (Clean slate)
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS reviews;
DROP TABLE IF EXISTS wishlists;
DROP TABLE IF EXISTS orders;
DROP TABLE IF EXISTS tours;
DROP TABLE IF EXISTS cities;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS sessions;
DROP TABLE IF EXISTS cache;
DROP TABLE IF EXISTS cache_locks;
DROP TABLE IF EXISTS jobs;
DROP TABLE IF EXISTS job_batches;
DROP TABLE IF EXISTS failed_jobs;
DROP TABLE IF EXISTS password_reset_tokens;
SET FOREIGN_KEY_CHECKS = 1;

-- ==========================================
-- 2. CREATE TABLES
-- ==========================================

-- Users table
CREATE TABLE users (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    email_verified_at TIMESTAMP NULL DEFAULT NULL,
    password VARCHAR(255) NOT NULL,
    role ENUM('user','admin') NOT NULL DEFAULT 'user',
    remember_token VARCHAR(100) NULL DEFAULT NULL,
    created_at TIMESTAMP NULL DEFAULT NULL,
    updated_at TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY users_email_unique (email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Cities table
CREATE TABLE cities (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    slug VARCHAR(255) NOT NULL,
    image_url VARCHAR(2048) NOT NULL,
    description TEXT NULL,
    is_active TINYINT(1) NOT NULL DEFAULT 1,
    created_at TIMESTAMP NULL DEFAULT NULL,
    updated_at TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY cities_slug_unique (slug)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Tours table (Includes all GetYourGuide style details)
CREATE TABLE tours (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(255) NOT NULL,
    description TEXT NULL,
    highlights TEXT NULL,
    includes TEXT NULL,
    meeting_point VARCHAR(255) NULL,
    guide_languages VARCHAR(255) NULL,
    group_size VARCHAR(255) NULL,
    not_suitable_for TEXT NULL,
    price INT UNSIGNED NOT NULL COMMENT 'Price in Yen',
    city_id BIGINT UNSIGNED NOT NULL,
    duration VARCHAR(255) NOT NULL DEFAULT '2h',
    image_url VARCHAR(2048) NULL,
    is_active TINYINT(1) NOT NULL DEFAULT 1,
    avg_rating DECIMAL(3,2) NOT NULL DEFAULT 0.00,
    reviews_count INT UNSIGNED NOT NULL DEFAULT 0,
    created_at TIMESTAMP NULL DEFAULT NULL,
    updated_at TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY tours_slug_unique (slug),
    KEY tours_city_id_foreign (city_id),
    CONSTRAINT tours_city_id_foreign FOREIGN KEY (city_id) REFERENCES cities (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Orders table
CREATE TABLE orders (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    user_id BIGINT UNSIGNED NOT NULL,
    tour_id BIGINT UNSIGNED NOT NULL,
    total_amount INT UNSIGNED NOT NULL,
    persons SMALLINT UNSIGNED NOT NULL DEFAULT 1,
    booking_date DATE NULL DEFAULT NULL,
    booking_time VARCHAR(10) NULL DEFAULT NULL,
    status ENUM('pending','completed','cancelled') NOT NULL DEFAULT 'pending',
    paypal_order_id VARCHAR(255) NULL DEFAULT NULL,
    created_at TIMESTAMP NULL DEFAULT NULL,
    updated_at TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (id),
    KEY orders_user_id_foreign (user_id),
    KEY orders_tour_id_foreign (tour_id),
    CONSTRAINT orders_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE,
    CONSTRAINT orders_tour_id_foreign FOREIGN KEY (tour_id) REFERENCES tours (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Reviews table
CREATE TABLE reviews (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    user_id BIGINT UNSIGNED NOT NULL,
    tour_id BIGINT UNSIGNED NOT NULL,
    order_id BIGINT UNSIGNED NULL DEFAULT NULL,
    rating TINYINT UNSIGNED NOT NULL,
    comment TEXT NULL,
    created_at TIMESTAMP NULL DEFAULT NULL,
    updated_at TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY reviews_user_tour_unique (user_id, tour_id),
    KEY reviews_tour_id_foreign (tour_id),
    CONSTRAINT reviews_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE,
    CONSTRAINT reviews_tour_id_foreign FOREIGN KEY (tour_id) REFERENCES tours (id) ON DELETE CASCADE,
    CONSTRAINT reviews_order_id_foreign FOREIGN KEY (order_id) REFERENCES orders (id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Wishlists table
CREATE TABLE wishlists (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    user_id BIGINT UNSIGNED NOT NULL,
    tour_id BIGINT UNSIGNED NOT NULL,
    created_at TIMESTAMP NULL DEFAULT NULL,
    updated_at TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY wishlists_user_tour_unique (user_id, tour_id),
    CONSTRAINT wishlists_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE,
    CONSTRAINT wishlists_tour_id_foreign FOREIGN KEY (tour_id) REFERENCES tours (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Laravel System Tables
CREATE TABLE password_reset_tokens (
    email VARCHAR(255) NOT NULL,
    token VARCHAR(255) NOT NULL,
    created_at TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE sessions (
    id VARCHAR(255) NOT NULL,
    user_id BIGINT UNSIGNED NULL DEFAULT NULL,
    ip_address VARCHAR(45) NULL DEFAULT NULL,
    user_agent TEXT NULL,
    payload LONGTEXT NOT NULL,
    last_activity INT NOT NULL,
    PRIMARY KEY (id),
    KEY sessions_user_id_index (user_id),
    KEY sessions_last_activity_index (last_activity)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE cache (
    key VARCHAR(255) NOT NULL,
    value MEDIUMTEXT NOT NULL,
    expiration INT NOT NULL,
    PRIMARY KEY (key)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE cache_locks (
    key VARCHAR(255) NOT NULL,
    owner VARCHAR(255) NOT NULL,
    expiration INT NOT NULL,
    PRIMARY KEY (key)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ==========================================
-- 3. INSERT USERS (Password is 'password')
-- ==========================================
INSERT INTO users (name, email, password, role, created_at, updated_at) VALUES
('Admin', 'admin@japantourhub.test', '$2y$12$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin', NOW(), NOW()),
('Test User', 'user@japantourhub.test', '$2y$12$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'user', NOW(), NOW());

-- ==========================================
-- 4. INSERT CITIES
-- ==========================================
INSERT INTO cities (name, slug, image_url, description, is_active, created_at, updated_at) VALUES
('Tokyo', 'tokyo', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 'Neon-lit capital of Japan.', 1, NOW(), NOW()),
('Kanazawa', 'kanazawa', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 'Gold leaf, gardens, samurai streets.', 1, NOW(), NOW()),
('Nagano', 'nagano', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 'Snowy mountains and friendly monkeys.', 1, NOW(), NOW()),
('Takayama', 'takayama', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 'Preserved Edo-period streets.', 1, NOW(), NOW()),
('Kyoto', 'kyoto', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 'Ancient temples and geisha districts.', 1, NOW(), NOW()),
('Osaka', 'osaka', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 'Street food capital.', 1, NOW(), NOW()),
('Nara', 'nara', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 'Friendly deer and old temples.', 1, NOW(), NOW());

-- ==========================================
-- 5. INSERT TOURS (84 Tours across 7 cities)
-- ==========================================

-- TOKYO (city_id = 1)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(1, 'Tokyo Private Walking Tour', 'tokyo-private-walking', 11500, '4h', 'Private luxury tour with flexible itinerary and expert local guide.', 'Explore hidden alleys of Shibuya\nVisit a historic shrine\nTaste local street food', 'Professional guide\nTrain tickets\nSnacks', 'Shibuya Crossing Station', 'English, Japanese', 'Private Group', 'Wheelchair users', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW()),
(1, 'Tokyo Street Food Group Tour', 'tokyo-street-food', 6500, '3h', 'Join a small group to taste 10 dishes in Shinjuku.', 'Taste Takoyaki\nTry Okonomiyaki\nDrink local sake', 'Food tastings\n1 drink\nGuide', 'Shinjuku Station East Exit', 'English', 'Small group up to 8 people', 'Vegans, Wheelchair users', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(1, 'Mount Fuji & Hakone Private Tour', 'mt-fuji-hakone', 85000, '10h', 'Full-day private car tour to Mt. Fuji and Hakone.', 'See Mount Fuji\nCruise on Lake Ashi\nRide the Hakone Ropeway', 'Private car\nDriver\nPickup and drop-off', 'Your hotel in Tokyo', 'English, Chinese', 'Private group up to 6', 'Wheelchair users', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(1, 'Tokyo Sumo Morning Practice', 'tokyo-sumo', 8000, '2h', 'Watch sumo wrestlers train up close.', 'Watch live sumo training\nLearn about sumo traditions', 'Entrance ticket\nGuide', 'Ryogoku Station', 'English', 'Up to 15 people', 'Children under 5', 'https://images.unsplash.com/photo-1570459027562-4a916cc6113f?w=800', 1, NOW(), NOW()),
(1, 'Shibuya & Harajuku Walking Tour', 'tokyo-shibuya', 7000, '3h', 'Explore the pop culture centers of Tokyo.', 'Walk down Takeshita Street\nSee the Hachiko statue', 'Local guide\n1 Crepe', 'Harajuku Station', 'English', 'Small group up to 10', 'None', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW()),
(1, 'Tsukiji Fish Market Food Tour', 'tokyo-tsukiji', 9000, '2.5h', 'Taste fresh sushi and street food at the famous market.', 'Eat fresh tuna\nTry tamagoyaki\nVisit the outer market', '6 Food tastings\nGreen tea', 'Tsukiji Station', 'English', 'Up to 8 people', 'Wheelchair users', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(1, 'Tokyo Bay Sunset Cruise', 'tokyo-bay-cruise', 6000, '1.5h', 'Relaxing boat ride with views of the Rainbow Bridge.', 'See the sunset over Tokyo\nPass under the Rainbow Bridge', 'Boat ticket\n1 Drink', 'Hinode Pier', 'None', 'Up to 50 people', 'None', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(1, 'Meiji Shrine & Yoyogi Park Walk', 'tokyo-meiji', 5500, '2h', 'Peaceful nature walk in the heart of the city.', 'Walk through the giant torii gate\nSee traditional sake barrels', 'Guide', 'Harajuku Station', 'English', 'Up to 15 people', 'None', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(1, 'Akihabara Anime & Gaming Tour', 'tokyo-akihabara', 7500, '3h', 'Discover the electronic and otaku culture district.', 'Visit retro game stores\nExplore anime shops\nTry a maid cafe', 'Guide\nMaid cafe entry', 'Akihabara Station', 'English', 'Up to 8 people', 'Children under 12', 'https://images.unsplash.com/photo-1590050752117-238cb0fb12b1?w=800', 1, NOW(), NOW()),
(1, 'TeamLab Planets Digital Art Ticket', 'tokyo-teamlab', 4800, '2h', 'Skip the line entry to the immersive digital museum.', 'Walk through water\nSee infinite mirrored rooms', 'Entry ticket', 'TeamLab Planets', 'None', 'Standard entry', 'Wheelchair users, Pregnant women', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 1, NOW(), NOW()),
(1, 'Tokyo Tower & Zojoji Temple', 'tokyo-tower', 5000, '2h', 'Visit the iconic tower and a historic temple.', 'View from Tokyo Tower\nExplore Zojoji Temple', 'Tokyo Tower Main Deck ticket', 'Tokyo Tower Base', 'None', 'Up to 20', 'None', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(1, 'Roppongi Nightlife Bar Hopping', 'tokyo-roppongi', 12000, '3h', 'Visit 3 hidden bars with a local guide.', 'Visit 3 unique bars\nDrink with locals', '3 Drinks\nGuide', 'Roppongi Crossing', 'English', 'Up to 6 people', 'Children under 20', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(1, 'Ueno Park & Museums Tour', 'tokyo-ueno', 6000, '4h', 'Explore the cultural heart of Tokyo.', 'Visit the Tokyo National Museum\nWalk through Ueno Park', 'Museum entry\nGuide', 'Ueno Station', 'English', 'Up to 10', 'None', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(1, 'Asakusa Temple & Kimono Rental', 'tokyo-asakusa', 8500, '3h', 'Wear a kimono and visit Senso-ji temple.', 'Wear a traditional kimono\nVisit Senso-ji temple', 'Kimono rental\nGuide', 'Asakusa Station', 'English, Chinese', 'Up to 8 people', 'None', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW());

-- KANAZAWA (city_id = 2)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(2, 'Shirakawa-go & Takayama Private Tour', 'shirakawago-takayama', 85000, '8h', 'Private luxury tour visiting UNESCO villages and Takayama.', 'Explore the UNESCO village\nSee traditional thatched-roof houses\nWalk the streets of Takayama', 'Private transport\nEnglish-speaking driver', 'Kanazawa Station', 'English, Japanese', 'Private group up to 4', 'Wheelchair users', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(2, 'Kanazawa Gold Leaf Workshop', 'kanazawa-gold', 6000, '1.5h', 'Craft your own gold-leaf souvenir in Higashi Chaya.', 'Apply gold leaf to a souvenir\nLearn about the craft', 'Workshop materials\nInstructor', 'Higashi Chaya District', 'Japanese, English', 'Up to 10', 'Children under 5', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(2, 'Kenrokuen Tea Ceremony', 'kanazawa-tea', 8000, '1h', 'Traditional matcha ceremony in a historic garden.', 'Learn the tea ceremony\nDrink traditional matcha\nEat Japanese sweets', 'Matcha and sweets', 'Kenrokuen Garden Entrance', 'English, Japanese', 'Up to 15', 'None', 'https://images.unsplash.com/photo-1582784673235-9c3b6f12fc98?w=800', 1, NOW(), NOW()),
(2, 'Kanazawa Castle Group Walk', 'kanazawa-castle', 10000, '3h', 'Explore samurai history and beautiful gardens.', 'Walk through Kanazawa Castle\nExplore Kenrokuen Garden', 'Castle entry\nGuide', 'Kanazawa Castle Park', 'English', 'Up to 20', 'Wheelchair users', 'https://images.unsplash.com/photo-1590050752117-238cb0fb12b1?w=800', 1, NOW(), NOW()),
(2, 'Omicho Market Food Tour', 'kanazawa-omicho', 7000, '2h', 'Taste fresh seafood and local delicacies.', 'Taste fresh sushi\nTry local crab', 'Food tastings', 'Omicho Market', 'English', 'Up to 8', 'None', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(2, 'Higashi Chaya Geisha District Walk', 'kanazawa-geisha', 6500, '2h', 'Explore the historic teahouse districts.', 'Explore the historic teahouses\nLearn about geisha culture', 'Guide', 'Higashi Chaya District', 'English', 'Up to 15', 'None', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(2, '21st Century Museum Entry & Tour', 'kanazawa-museum', 5000, '1.5h', 'Discover contemporary art in Kanazawa.', 'Visit the famous swimming pool art\nExplore modern exhibits', 'Museum entry', 'Museum Entrance', 'None', 'Standard entry', 'None', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 1, NOW(), NOW()),
(2, 'Nagamachi Samurai District Tour', 'kanazawa-samurai', 5500, '2h', 'Walk through preserved samurai residences.', 'Walk through samurai streets\nVisit a former samurai house', 'Guide', 'Nagamachi District', 'English', 'Up to 10', 'Wheelchair users', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(2, 'Kanazawa Nighttime Izakaya Tour', 'kanazawa-izakaya', 9000, '2.5h', 'Drink and eat with locals in hidden bars.', 'Visit 3 local izakayas\nEat authentic Japanese food', 'Food and drinks', 'Kanazawa Station', 'English', 'Up to 6', 'Children under 20', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(2, 'E-Bike Tour: Castle & Garden', 'kanazawa-ebike', 7500, '3h', 'Cycle through the city highlights.', 'Ride an e-bike through Kanazawa\nVisit the castle and garden', 'E-bike rental\nGuide', 'Kanazawa Station', 'English', 'Up to 8', 'Children under 12', 'https://images.unsplash.com/photo-1570459027562-4a916cc6113f?w=800', 1, NOW(), NOW()),
(2, 'Private 6-Hour Walking Tour', 'kanazawa-private-walk', 25000, '6h', 'Custom private walking tour in English.', 'Create your own itinerary\nExplore hidden gems', 'Private guide', 'Your hotel', 'English', 'Private group', 'Wheelchair users', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW()),
(2, 'Manga Drawing Class', 'kanazawa-manga', 6000, '1.5h', 'Learn to draw manga with an instructor.', 'Learn from a professional manga artist\nCreate your own character', 'Drawing materials', 'Kanazawa Studio', 'Japanese, English', 'Up to 10', 'None', 'https://images.unsplash.com/photo-1590050752117-238cb0fb12b1?w=800', 1, NOW(), NOW()),
(2, 'Fukui Castle & Cliffs Day Trip', 'kanazawa-fukui', 35000, '8h', 'Private tour to Fukui scenic spots.', 'Visit Fukui Castle\nSee the Tojinbo Cliffs', 'Private transport\nDriver', 'Kanazawa Station', 'English, Japanese', 'Private group up to 4', 'Wheelchair users', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(2, 'Lantern-Lit Historic Night Walk', 'kanazawa-night-walk', 5500, '2.5h', 'Evening stroll with folklore stories.', 'Explore the historic districts at night\nHear local folklore', 'Guide', 'Higashi Chaya District', 'English', 'Up to 12', 'Children under 8', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW());

-- KYOTO (city_id = 3)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(3, 'Kyoto Private Temple Walk', 'kyoto-private-temple', 20000, '4h', 'Private tour of 5 iconic temples with a local guide.', 'Visit Kinkaku-ji\nExplore Zen gardens\nSee historic wooden temples', 'Private guide\nTemple entry fees', 'Kyoto Station', 'English, Japanese', 'Private group', 'Wheelchair users', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(3, 'Kyoto Tea Ceremony Group', 'kyoto-tea-group', 6000, '1h', 'Traditional tea ceremony in a machiya.', 'Learn the art of tea\nTaste matcha and sweets', 'Matcha and sweets', 'Gion District', 'English', 'Up to 10', 'None', 'https://images.unsplash.com/photo-1582784673235-9c3b6f12fc98?w=800', 1, NOW(), NOW()),
(3, 'Fushimi Inari & Gion Walk', 'kyoto-inari-gion', 7500, '3h', 'Walk through thousands of torii gates and geisha districts.', 'Walk through the torii gates\nSpot geisha in Gion', 'Guide', 'Fushimi Inari Station', 'English', 'Up to 15', 'Wheelchair users', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(3, 'Kyoto Private Photoshoot Tour', 'kyoto-photoshoot', 35000, '2h', 'Professional photographer for your trip.', 'Professional photos in Kyoto\nVisit scenic spots', 'Photographer\nEdited photos', 'Your hotel', 'English', 'Private group', 'None', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(3, 'Arashiyama Bamboo Grove Tour', 'kyoto-arashiyama', 6500, '2.5h', 'Explore the famous bamboo forest and monkey park.', 'Walk through the bamboo grove\nSee the monkeys', 'Guide', 'Arashiyama Station', 'English', 'Up to 12', 'None', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW()),
(3, 'Kinkaku-ji (Golden Pavilion)', 'kyoto-kinkakuji', 5000, '1.5h', 'Visit the stunning gold-leafed temple.', 'See the Golden Pavilion\nWalk through the gardens', 'Temple entry', 'Kinkaku-ji Entrance', 'None', 'Standard entry', 'Wheelchair users', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(3, 'Nishiki Market Food Tour', 'kyoto-nishiki', 8000, '2h', 'Taste local specialties in Kyoto kitchen.', 'Taste pickles and tofu\nTry Japanese sweets', 'Food tastings', 'Nishiki Market', 'English', 'Up to 8', 'Vegans', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(3, 'Kiyomizu-dera Temple Walk', 'kyoto-kiyomizu', 5500, '2h', 'Visit the iconic wooden stage temple.', 'See the wooden stage\nWalk the historic streets', 'Temple entry\nGuide', 'Kiyomizu-michi', 'English', 'Up to 15', 'Wheelchair users', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(3, 'Kyoto Night Gion Walking Tour', 'kyoto-gion-night', 7000, '2h', 'Spot geisha and learn about the district.', 'Explore Gion at night\nLearn about geisha culture', 'Guide', 'Gion Shijo Station', 'English', 'Up to 10', 'Children under 8', 'https://images.unsplash.com/photo-1570459027562-4a916cc6113f?w=800', 1, NOW(), NOW()),
(3, 'Philosopher Path & Ginkaku-ji', 'kyoto-philosophers', 6000, '3h', 'Peaceful walk along the canal.', 'Walk the Philosopher Path\nSee the Silver Pavilion', 'Guide\nTemple entry', 'Ginkaku-ji', 'English', 'Up to 12', 'Wheelchair users', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 1, NOW(), NOW()),
(3, 'Kyoto Sake Tasting Experience', 'kyoto-sake', 9000, '1.5h', 'Sample local sake varieties.', 'Taste 5 types of sake\nLearn about brewing', 'Sake tastings\nSnacks', 'Fushimi Sake District', 'English', 'Up to 10', 'Children under 20', 'https://images.unsplash.com/photo-1590050752117-238cb0fb12b1?w=800', 1, NOW(), NOW()),
(3, 'Nijo Castle & Ninomaru Palace', 'kyoto-nijo', 5000, '2h', 'Explore the shogun historic residence.', 'See the nightingale floors\nWalk through the palace', 'Castle entry', 'Nijo Castle', 'None', 'Standard entry', 'Wheelchair users', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(3, 'Private Kyoto Custom Tour by Car', 'kyoto-private-car', 65000, '6h', 'Tailor your own itinerary with a private driver.', 'Custom itinerary\nPrivate car', 'Private car\nDriver', 'Your hotel', 'English, Japanese', 'Private group', 'None', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(3, 'Kimono Rental & Walking Tour', 'kyoto-kimono', 8500, '4h', 'Dress in traditional style and explore.', 'Wear a kimono\nWalk through historic streets', 'Kimono rental\nGuide', 'Gion District', 'English', 'Up to 8', 'Wheelchair users', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW());

-- OSAKA (city_id = 4)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(4, 'Osaka Castle & Dotonbori Private', 'osaka-private-tour', 25000, '4h', 'Private tour of Osaka highlights, including pickup.', 'Visit Osaka Castle\nExplore Dotonbori at night', 'Private guide\nTrain tickets', 'Your hotel', 'English, Japanese', 'Private group', 'Wheelchair users', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(4, 'Osaka Street Food Crawl', 'osaka-food', 8000, '2.5h', 'Taste takoyaki, okonomiyaki, and more.', 'Eat Takoyaki\nTry Okonomiyaki\nDrink local beer', '5 Food tastings\n1 Drink', 'Namba Station', 'English', 'Up to 8', 'Vegans', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(4, 'Universal Studios Day Ticket', 'osaka-universal', 9800, '8h', 'Skip the line entry to Universal Studios Japan.', 'Skip the ticket line\nRide the rollercoasters', '1-Day Studio Pass', 'USJ Entrance', 'None', 'Standard entry', 'None', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 1, NOW(), NOW()),
(4, 'Osaka Bar Hopping Group', 'osaka-bar', 7000, '3h', 'Discover hidden izakayas in Tenma.', 'Visit 3 local bars\nDrink with locals', '3 Drinks\nSnacks', 'Tenma Station', 'English', 'Up to 6', 'Children under 20', 'https://images.unsplash.com/photo-1590050752117-238cb0fb12b1?w=800', 1, NOW(), NOW()),
(4, 'Osaka Castle Park Walking Tour', 'osaka-castle-walk', 5500, '2h', 'Learn the history of the castle and park.', 'Explore the castle grounds\nLearn about samurai history', 'Guide', 'Osaka Castle Park', 'English', 'Up to 15', 'Wheelchair users', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(4, 'Kuromon Market Food Tour', 'osaka-kuromon', 7500, '2h', 'Explore the bustling market with a guide.', 'Taste fresh seafood\nTry Wagyu beef skewers', 'Food tastings', 'Kuromon Market', 'English', 'Up to 10', 'None', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(4, 'Umeda Sky Building Ticket', 'osaka-umeda', 4500, '1.5h', 'Amazing views from the floating garden.', 'See panoramic views\nWalk the floating garden', 'Observation deck entry', 'Umeda Sky Building', 'None', 'Standard entry', 'None', '-- OSAKA CONTINUED (city_id = 4)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(4, 'Shinsekai & Tsutenkaku Walk', 'osaka-shinsekai', 5000, '2h', 'Explore the retro-futuristic district.', 'Visit Tsutenkaku Tower\nEat Kushikatsu', 'Guide\n1 Snack', 'Shinsekai Entrance', 'English', 'Up to 12', 'Wheelchair users', 'https://images.unsplash.com/photo-1570459027562-4a916cc6113f?w=800', 1, NOW(), NOW()),
(4, 'Osaka Sushi Making Class', 'osaka-sushi', 6500, '2h', 'Learn to make authentic sushi.', 'Learn to make sushi\nEat your creations', 'Ingredients\nInstructor', 'Cooking Studio', 'English', 'Up to 8', 'Vegans', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(4, 'Namba & Shinsaibashi Shopping Tour', 'osaka-shopping', 4000, '3h', 'Find the best local shops and cafes.', 'Shop in Shinsaibashi\nExplore Namba', 'Guide', 'Namba Station', 'English', 'Up to 10', 'None', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW()),
(4, 'Osaka River Cruise (Tombori)', 'osaka-cruise', 3500, '1h', 'See the city lights from the water.', 'Cruise the Dotonbori River\nSee the Glico sign', 'Boat ticket', 'Tombori River Walk', 'None', 'Up to 20', 'None', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(4, 'Sumo Wrestling Experience', 'osaka-sumo', 11000, '2h', 'Meet wrestlers and learn about sumo.', 'Meet real sumo wrestlers\nLearn the rules', 'Entrance\nGuide', 'Osaka Sumo Hall', 'English', 'Up to 15', 'Children under 5', 'https://images.unsplash.com/photo-1570459027562-4a916cc6113f?w=800', 1, NOW(), NOW()),
(4, 'Minami District Night Walk', 'osaka-night-walk', 5000, '2h', 'See the neon lights of Osaka nightlife.', 'Walk through neon streets\nSee the Glico Man', 'Guide', 'Namba Station', 'English', 'Up to 12', 'Children under 8', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(4, 'Private Osaka Custom Tour', 'osaka-custom', 45000, '5h', 'Build your own perfect day in Osaka.', 'Custom itinerary\nPrivate car', 'Private car\nDriver', 'Your hotel', 'English, Japanese', 'Private group', 'Wheelchair users', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW());

-- NARA (city_id = 5)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(5, 'Nara Park & Todai-ji Private', 'nara-private-tour', 20000, '3h', 'Private tour feeding the deer and visiting the giant Buddha.', 'Feed the friendly deer\nSee the Giant Buddha', 'Private guide\nTemple entry', 'Nara Station', 'English, Japanese', 'Private group', 'Wheelchair users', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(5, 'Nara Deer Park Group Walk', 'nara-group-deer', 6000, '2h', 'Join others to explore the park and feed the deer.', 'Feed the deer\nWalk through Nara Park', 'Guide\nDeer crackers', 'Nara Station', 'English', 'Up to 15', 'None', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(5, 'Yoshino Cherry Blossom Tour', 'nara-yoshino', 9500, '6h', 'Day trip to the most famous cherry blossom spot.', 'See thousands of cherry trees\nExplore Yoshino Mountain', 'Guide\nTrain tickets', 'Yoshino Station', 'English', 'Up to 12', 'Wheelchair users', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(5, 'Nara Calligraphy Workshop', 'nara-calligraphy', 6000, '1.5h', 'Learn traditional Japanese calligraphy.', 'Learn from a master\nCreate your own art', 'Materials\nInstructor', 'Nara Studio', 'English, Japanese', 'Up to 8', 'None', 'https://images.unsplash.com/photo-1582784673235-9c3b6f12fc98?w=800', 1, NOW(), NOW()),
(5, 'Kasuga Taisha Shrine Tour', 'nara-kasuga', 5000, '2h', 'Visit the lantern-lined shrine.', 'See thousands of stone lanterns\nWalk through the forest', 'Guide', 'Kasuga Taisha', 'English', 'Up to 15', 'None', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW()),
(5, 'Isuien Garden & Neiraku Museum', 'nara-garden', 4500, '1.5h', 'Stroll through beautiful traditional gardens.', 'Explore the traditional garden\nVisit the museum', 'Garden entry', 'Isuien Garden', 'None', 'Standard entry', 'None', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(5, 'Naramachi Historic District Walk', 'nara-naramachi', 5500, '2h', 'Explore the old merchant townhouses.', 'Walk through historic streets\nVisit local shops', 'Guide', 'Naramachi', 'English', 'Up to 10', 'None', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(5, 'Todai-ji Temple & Big Buddha', 'nara-todaiji', 4000, '1.5h', 'See the massive bronze Buddha statue.', 'See the Giant Buddha\nWalk through the temple', 'Temple entry', 'Todai-ji Entrance', 'None', 'Standard entry', 'Wheelchair users', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(5, 'Mount Wakakusa Sunset Hike', 'nara-wakakusa', 7000, '2.5h', 'Hike up for panoramic views of the city.', 'Watch the sunset\nSee panoramic views', 'Guide', 'Nara Park', 'English', 'Up to 12', 'Children under 8', 'https://images.unsplash.com/photo-1570459027562-4a916cc6113f?w=800', 1, NOW(), NOW()),
(5, 'Nara Food & Sake Tasting', 'nara-food', 8500, '2.5h', 'Taste local Nara specialties and sake.', 'Taste local sake\nTry traditional snacks', 'Food and drinks', 'Naramachi', 'English', 'Up to 8', 'Children under 20', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 1, NOW(), NOW()),
(5, 'Private Nara Custom Tour by Car', 'nara-private-car', 35000, '4h', 'Flexible private tour with a driver.', 'Custom itinerary\nPrivate car', 'Private car\nDriver', 'Your hotel', 'English, Japanese', 'Private group', 'None', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(5, 'Nara Park Morning Walking Tour', 'nara-morning', 4000, '2h', 'Early morning walk before the crowds arrive.', 'See the deer in the morning\nPeaceful walk', 'Guide', 'Nara Park', 'English', 'Up to 15', 'None', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(5, 'Kofuku-ji Temple & National Treasure', 'nara-kofukuji', 5000, '1.5h', 'Visit one of Japan oldest temples.', 'See the 5-story pagoda\nExplore the National Treasure Hall', 'Temple entry', 'Kofuku-ji', 'None', 'Standard entry', 'None', 'https://images.unsplash.com/photo-1590050752117-238cb0fb12b1?w=800', 1, NOW(), NOW()),
(5, 'Nara E-Bike Tour', 'nara-ebike', 7500, '3h', 'Cycle around the park and temples.', 'Ride an e-bike\nVisit hidden temples', 'E-bike rental\nGuide', 'Nara Station', 'English', 'Up to 8', 'Children under 12', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW());

-- NAGANO (city_id = 6)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(6, 'Nagano Snow Monkey Park Private Tour', 'nagano-snow-monkey', 25000, '6h', 'Private transport to see the famous hot-spring monkeys.', 'See the snow monkeys\nWalk through the forest', 'Private transport\nGuide', 'Nagano Station', 'English, Japanese', 'Private group', 'Wheelchair users', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 1, NOW(), NOW()),
(6, 'Matsumoto Castle Day Trip', 'nagano-matsumoto', 12000, '7h', 'Visit one of Japan most beautiful original castles.', 'Explore Matsumoto Castle\nWalk through the city', 'Train tickets\nGuide', 'Nagano Station', 'English', 'Up to 10', 'Wheelchair users', 'https://images.unsplash.com/photo-1480796927426-f609979314bd?w=800', 1, NOW(), NOW()),
(6, 'Jigokudani Snow Monkey Group Tour', 'nagano-group-monkey', 8000, '5h', 'Join a group to hike to the monkey park.', 'Hike to the monkey park\nSee the monkeys in the onsen', 'Bus transport\nGuide', 'Nagano Station', 'English', 'Up to 20', 'Children under 5', 'https://images.unsplash.com/photo-1542051841857-5f90071e7989?w=800', 1, NOW(), NOW()),
(6, 'Nagano Winter Ski Resort Transfer', 'nagano-ski', 15000, '4h', 'Private transfer to Hakuba ski resort.', 'Comfortable transfer\nDoor-to-door service', 'Private transfer', 'Your hotel', 'None', 'Private group', 'None', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(6, 'Zenko-ji Temple Morning Tour', 'nagano-zenkoji', 5000, '2h', 'Visit the historic Buddhist temple.', 'Explore the temple\nSee the hidden Buddha', 'Guide', 'Zenko-ji', 'English', 'Up to 15', 'None', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(6, 'Togakushi Shrine Forest Walk', 'nagano-togakushi', 6500, '3h', 'Walk the cedar-lined path to the shrine.', 'Walk through the giant cedars\nVisit the shrine', 'Guide', 'Togakushi', 'English', 'Up to 10', 'Wheelchair users', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(6, 'Obuse Town & Hokusai Museum', 'nagano-obuse', 7000, '4h', 'Explore the charming town and art museum.', 'Visit the Hokusai Museum\nTaste local chestnuts', 'Train tickets\nMuseum entry', 'Obuse Station', 'English', 'Up to 12', 'None', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(6, 'Nagano Soba Noodle Making Class', 'nagano-soba', 6000, '2h', 'Learn to make traditional buckwheat noodles.', 'Make your own soba\nEat your creation', 'Ingredients\nInstructor', 'Nagano Studio', 'English, Japanese', 'Up to 8', 'Vegans', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW());

-- TAKAYAMA (city_id = 7)
INSERT INTO tours (city_id, title, slug, price, duration, description, highlights, includes, meeting_point, guide_languages, group_size, not_suitable_for, image_url, is_active, created_at, updated_at) VALUES
(7, 'Takayama Old Town Private Tour', 'takayama-old-town', 20000, '3h', 'Private guide through preserved Edo-period streets.', 'Walk through historic streets\nVisit local artisans', 'Private guide', 'Takayama Station', 'English, Japanese', 'Private group', 'Wheelchair users', 'https://images.unsplash.com/photo-1493976040374-85c8e12f0c0e?w=800', 1, NOW(), NOW()),
(7, 'Hida Folk Village Group Tour', 'takayama-folk', 8000, '3h', 'Explore traditional thatched-roof houses.', 'See traditional houses\nLearn about mountain life', 'Bus transport\nGuide', 'Takayama Station', 'English', 'Up to 15', 'None', 'https://images.unsplash.com/photo-1526481280693-3bfa7568e0f3?w=800', 1, NOW(), NOW()),
(7, 'Takayama Morning Market Walk', 'takayama-market', 4500, '1.5h', 'Taste local snacks and meet the locals.', 'Visit the morning market\nTaste local snacks', 'Guide', 'Miyagawa Market', 'English', 'Up to 10', 'None', 'https://images.unsplash.com/photo-1590559899731-a382839e5549?w=800', 1, NOW(), NOW()),
(7, 'Shirakawa-go Day Trip', 'takayama-shirakawago', 12000, '6h', 'Bus tour to the UNESCO World Heritage village.', 'Explore the UNESCO village\nSee the gassho-zukuri houses', 'Bus transport\nGuide', 'Takayama Station', 'English', 'Up to 20', 'Wheelchair users', 'https://images.unsplash.com/photo-1528360983277-13d401cdc186?w=800', 1, NOW(), NOW()),
(7, 'Takayama Jinya Governor House', 'takayama-jinya', 4000, '1h', 'Tour the historic government building.', 'See the historic offices\nWalk through the gardens', 'Entrance ticket', 'Takayama Jinya', 'None', 'Standard entry', 'None', 'https://images.unsplash.com/photo-1540959733332-eab4deabeeaf?w=800', 1, NOW(), NOW()),
(7, 'Higashiyama Walking Course', 'takayama-higashiyama', 5000, '2.5h', 'Walk through temples and nature trails.', 'Visit historic temples\nWalk through the forest', 'Guide', 'Takayama Station', 'English', 'Up to 12', 'Wheelchair users', 'https://images.unsplash.com/photo-1554797589-7241bb691973?w=800', 1, NOW(), NOW()),
(7, 'Takayama Sake Brewery Tour', 'takayama-sake', 6000, '1.5h', 'Taste local sake in historic breweries.', 'Taste local sake\nLearn about brewing', 'Sake tastings', 'Takayama Old Town', 'English', 'Up to 8', 'Children under 20', 'https://images.unsplash.com/photo-1590050752117-238cb0fb12b1?w=800', 1, NOW(), NOW()),
(7, 'Private Takayama Custom Tour', 'takayama-custom', 35000, '5h', 'Custom itinerary with private transport.', 'Custom itinerary\nPrivate car', 'Private car\nDriver', 'Your hotel', 'English, Japanese', 'Private group', 'None', 'https://images.unsplash.com/photo-1570459027562-4a916cc6113f?w=800', 1, NOW(), NOW());



-- Should return 7 cities
SELECT COUNT(*) AS total_cities FROM cities;

-- Should return 84 tours
SELECT COUNT(*) AS total_tours FROM tours;

-- Should return the number of tours for each city
SELECT c.name AS city, COUNT(t.id) AS tour_count 
FROM cities c
LEFT JOIN tours t ON t.city_id = c.id
GROUP BY c.id, c.name;