konceptualenDizajnLogickiFizicki: polnenje.sql

-- Users
INSERT INTO users (first_name, last_name, email, password, role, phone, address, membership_level)
VALUES ('Ana', 'Petrova', 'ana@example.com', 'pass123', 'CUSTOMER', '070123456', 'Skopje', 'GOLD');

-- Restaurants
INSERT INTO restaurants (name, address, cuisine_type, phone, operating_hours, website, social_media_links, rating)
VALUES ('Sushi World', '101 Sushi Rd, Skopje', 'Japanese', '078987654', '10:00-23:00', 'www.sushiworld.com', 'instagram.com/sushiworld', 4.8);

-- Tables
INSERT INTO tables (restaurant_id, capacity, location, is_smoking_area, description)
VALUES (1, 4, 'Main Hall', false, 'Window-side table');

-- Menus
INSERT INTO menus (restaurant_id, item_name, category, price, description)
VALUES (1, 'California Roll', 'Sushi', 8.99, 'Crab, avocado, and cucumber');

-- Menu Tags
INSERT INTO menu_tags (menu_id, tag_name, tag_value)
VALUES (1, 'Spicy', 'No');

-- Reservation
INSERT INTO reservations (user_id, table_id, restaurant_id, reservation_date_time, party_size, status)
VALUES (1, 1, 1, NOW() + INTERVAL '1 day', 2, 'Confirmed');

-- Preordered Items
INSERT INTO reservation_preordered_items (reservation_id, name, quantity, price)
VALUES (1, 'California Roll', 1, 8.99);