Логички и физички дизајн - Креирање база податоци (со SQL DDL): DML.sql

insert into online_shop.customers (email, first_name, last_name, phone, delivery_address, password)
values
    ('sanja.petrushevska@example.com', 'Сања', 'Петрушевска', '0771234567', 'Улица Орце Николов, Skopje', 'password123');

insert into online_shop.categories (category_name)
values
    ('Аксесоари'),
    ('Обувки'),
    ('Мајца');

insert into online_shop.products (id_category, product_name, color, price, description)
values
    (1, 'Часовник', 'Црн', 1599, 'Кожен часовник за рака'),
    (2, 'Патики', 'Бели', 2599, 'Елегантни бели патики'),
    (3, 'Мајца', 'Црна', 1900, 'Удобна памучна мајца');

insert into online_shop.stock (id_product, size, quantity)
values
    (1, 'Onesize', 1),
    (2, '39', 1),
    (3, 'M', 1);

insert into online_shop.orders (id_customer, payment_method, status, delivery_price, total_price, invoice_code, order_date)
values
    (1, 'Card', 'Completed', 1599, 1599 + 2599 + 1900, 'INV123456', '2024-12-22 14:30:00');

insert into online_shop.delivery (id_order, delivery_address, status)
values
    (1, 'Улица Орце Николов, Skopje', 'Shipped');

insert into online_shop."contains" (id_order, id_stock, quantity, size, price)
values
    (1, 1, 1, 'Onesize', 1599),
    (1, 2, 1, '39', 2599),
    (1, 3, 1, 'M', 1900);