-- Xsular Watch - Seed Data for Watches Table
-- Run this after schema.sql to populate the watches table

USE xsular_watch;

-- Clear existing data (optional - comment out if you want to keep existing data)
-- TRUNCATE TABLE watches;

-- Insert watch data
INSERT INTO watches (id, name, brand, price, image, category, tag, description, spec_material, spec_size, spec_movement, spec_resist) VALUES
(1, 'Royal Oak Perpetual', 'Audemars Piguet', 145000.00, 'https://www.luxurybazaar.com/grey-market/wp-content/uploads/2025/06/26574or-2-1024x683.jpg', 'Luxury', 'Best Seller', 'The Royal Oak Perpetual Calendar features a titanium case, a blue ''Grande Tapisserie'' dial, and a matching titanium bracelet. It is powered by the ultra-thin self-winding Calibre 5134.', 'Titanium', '41mm', 'Auto', '20m'),

(2, 'Nautilus Travel Time', 'Patek Philippe', 210000.00, 'https://images.unsplash.com/photo-1614164185128-e4ec99c436d7?q=80&w=1974&auto=format&fit=crop', 'Luxury', 'Rare Find', 'Incorporating the Travel Time dual time zone mechanism, this Nautilus invites you to travel with style. The chronograph functionality complements its sporty chic appeal.', 'Rose Gold', '40.5mm', 'Auto', '120m'),

(3, 'Speedmaster Pro', 'Omega', 7600.00, 'https://hodinkee.imgix.net/uploads/images/1613490871637-2kbsyff6c-677a64e25f6a4a47a745eef5f46a5efa/hero_2?ixlib=rails-1.1.0&fm=jpg&q=55&auto=format&usm=12', 'Sport', 'New Arrival', 'The Moonwatch is one of the most iconic timepieces in world. Having been a part of all six lunar missions, the legendary Speedmaster is an impressive representation of the brand''s pioneering spirit.', 'Steel', '42mm', 'Manual', '50m'),

(4, 'Submariner Date', 'Rolex', 14500.00, 'https://images.unsplash.com/photo-1526045431048-f857369baa09?q=80&w=2070&auto=format&fit=crop', 'Sport', 'Classic', 'The Oyster Perpetual Submariner Date in Oystersteel with a Cerachrom bezel insert in black ceramic and a black dial with large luminescent hour markers.', 'Oystersteel', '41mm', 'Auto', '300m'),

(5, 'Tank Louis', 'Cartier', 12800.00, 'https://images.unsplash.com/photo-1620625515032-6ed0c1790c75?q=80&w=1964&auto=format&fit=crop', 'Classic', '', 'Worn by Louis Cartier himself, the ''Tank Louis Cartier'' watch sets the standard for all Tank watches. In contrast to the assertive choice of the Rectangle, the tops of the lugs were rounded.', 'Yellow Gold', '33.7mm', 'Manual', '30m'),

(6, 'Big Pilot', 'IWC Schaffhausen', 13200.00, 'https://images.unsplash.com/photo-1548171915-e79a380a2a4b?q=80&w=1996&auto=format&fit=crop', 'Classic', '', 'The Big Pilot''s Watch 43 features a stainless steel case, a ''racing green'' dial, rhodium-plated hands and a green rubber strap with EasX-CHANGE system.', 'Steel', '43mm', 'Auto', '100m'),

(7, 'Daytona Panda', 'Rolex', 34500.00, 'https://monochrome-watches.com/app/uploads/2021/04/Rolex-Daytona-Meteorite-dial-white-gold-ceramic-bezel-oysterflex-bracelet-116519ln-6-2048x1382.jpg', 'Sport', 'Iconic', 'The Oyster Perpetual Cosmograph Daytona in Oystersteel with a white dial and contrasting black sub-dials. A legend in the world of motor sport.', 'Oystersteel', '40mm', 'Auto', '100m'),

(8, 'Reverso Tribute', 'Jaeger-LeCoultre', 11400.00, 'https://www.luxurybazaar.com/grey-market/wp-content/uploads/2024/10/2024-Jaeger-Le-Coultre-Reverso-Tribute-1024x819.jpg', 'Classic', 'Elegant', 'A tribute to the early Reverso models, featuring a deep blue sunray-brushed dial and a matching leather strap. The back offers a blank canva for personalization.', 'Steel', '45.6mm', 'Manual', '30m'),

(9, 'Carrera Chronograph', 'TAG Heuer', 6450.00, 'https://hodinkee.imgix.net/uploads/images/a9d7b752-fdae-41d9-88c3-b30db0edd2f7/20250110_TAGHeuerCarreraPurple_005.jpg?ixlib=rails-1.1.0&fm=jpg&q=55&auto=format&usm=12&fit=crop&ch=Width%2CDPR%2CSave-Data&alt=&ar=16%3A9&w=1200', 'Sport', '', 'The classic Carrera Chronograph with a modern twist. Features a black dial with rose gold accents and a high-performance in-house movement.', 'Steel', '42mm', 'Auto', '100m'),

(10, 'Seamaster Diver', 'Omega', 5900.00, 'https://hodinkee.imgix.net/uploads/images/1548193448566-okeyt5somya-f8b3d83685f16a6e4a5f87c4704b5bff/omega_h.jpg?ixlib=rails-1.1.0&fm=jpg&q=55&auto=format&usm=12&fit=crop&ch=Width%2CDPR%2CSave-Data&alt=', 'Sport', 'Popular', 'The Seamaster Professional Diver 300M has enjoyed a legendary following since 1993. This model features a black wave-pattern dial and a helium escape valve.', 'Steel', '42mm', 'Auto', '300m'),

(11, 'Overseas Self-Winding', 'Vacheron Constantin', 25000.00, 'https://i0.wp.com/deployant.com/wp-content/uploads/2020/12/vc-overseas-rg-scrolls.jpg?resize=702%2C459&ssl=1', 'Luxury', '', 'The perfect daily wearer from the Holy Trinity. Features a stunning blue dial, interchangeable strap system, and the Maltese cross bezel.', 'Steel', '41mm', 'Auto', '150m'),

(12, 'Santos de Cartier', 'Cartier', 8250.00, 'https://img.chrono24.com/images/uhren/34075351-ewn7gbzhngjdsvsr6yap3q6o-ExtraLarge.jpg', 'Classic', 'Timeless', 'The first modern wristwatch, reimagined. Defined by its geometric shape and exposed screws, featuring a SmartLink adjustment system.', 'Steel', '39.8mm', 'Auto', '100m'),

(13, 'Black Bay 58', 'Tudor', 3950.00, 'https://images.unsplash.com/photo-1622434641406-a158123450f9?q=80&w=2008&auto=format&fit=crop', 'Sport', 'Value', 'A tribute to the brand''s first divers'' watches with 200m waterproofness. Features a warm vintage-inspired color scheme and 39mm case.', 'Steel', '39mm', 'Auto', '200m'),

(14, 'Pilot''s Watch Mark XX', 'IWC Schaffhausen', 5250.00, 'https://uhren-miquel.com/media/3a/aa/b1/1744795024/IWC-Pilots-Watch-Mark-XX-Ref.IW328204-edited_2.png', 'Classic', '', 'The quintessence of a pilot''s watch. Minimalist design, high legibility, and a robust movement with 120-hour power reserve.', 'Steel', '40mm', 'Auto', '100m'),

(15, 'GMT-Master II', 'Rolex', 16800.00, 'https://swisshour.com.my/wp-content/uploads/2019/02/GMT-II-Y13-Green-5-e1588586877356-scaled.jpg', 'Sport', 'Batgirl', 'Designed to show the time in two different time zones simultaneously using the Jubilee bracelet and the black and blue ceramic bezel.', 'Oystersteel', '40mm', 'Auto', '100m'),

(16, 'Lange 1', 'A. Lange & Söhne', 45900.00, 'https://i0.wp.com/deployant.com/wp-content/uploads/2020/10/lange1-yg.jpg?resize=702%2C520&ssl=1', 'Luxury', 'Masterpiece', 'The icon of Saxon watchmaking. Features an off-center dial, outsize date, and a movement finishing that is second to none.', 'Pink Gold', '38.5mm', 'Manual', '30m')

ON DUPLICATE KEY UPDATE
    name = VALUES(name),
    brand = VALUES(brand),
    price = VALUES(price),
    image = VALUES(image),
    category = VALUES(category),
    tag = VALUES(tag),
    description = VALUES(description),
    spec_material = VALUES(spec_material),
    spec_size = VALUES(spec_size),
    spec_movement = VALUES(spec_movement),
    spec_resist = VALUES(spec_resist);

-- Verify the data was inserted
SELECT COUNT(*) as total_watches FROM watches;
