SQL & DDL: V1.1__data_init.txt.2.txt

-- Customer
INSERT INTO Customer (CustomerID, CustomerName, CustomerSurName, Email, Address, CustomerContact) VALUES
(1, 'Marko', 'Markovski', 'marko@example.com', 'Street 123, Skopje', '070123456'),
(2, 'Elena', 'Stojanova', 'elena@example.com', 'Boulevard 45, Bitola', '071987654');

-- Employee
INSERT INTO Employee (EmployeeID, EmployeeName, EmployeeSurName, Position, Department) VALUES
(1, 'Ivan', 'Petrov', 'Sales Manager', 'Sales'),
(2, 'Ana', 'Kostova', 'Maintenance Specialist', 'Maintenance');

-- Product
INSERT INTO Product (ProductID, Model, Price, LicensePlate, Status) VALUES
(1, 'Volvo FH16', 120000.00, 'SK-1234-AB', 'available'),
(2, 'Scania R500', 95000.00, 'BT-5678-CD', 'rented'),
(3, 'Kögel Trailer', 30000.00, 'SK-2468-EF', 'available');

-- Truck
INSERT INTO Truck (ProductID, HP) VALUES
(1, 750),
(2, 500);

-- Trailer
INSERT INTO Trailer (ProductID, Capacity) VALUES
(3, 20.5);

-- Procurement
INSERT INTO Procurement (TransactionID, EmployeeID, CustomerID, ProductID, ProcurementDate, Quantity) VALUES
(1, 1, 1, 1, '2025-04-01', 1),
(2, 1, 2, 2, '2025-04-10', 1);
(3, 1, 2, 3, '2025-05-04', 1);

-- T_Type
INSERT INTO T_Type (TransactionID, Type, Duration, MonthlyPay, TotalPrice) VALUES
(1, 'Buy', NULL, NULL, 120000.00),
(2, 'Rent', 12, 3000.00, NULL);
(3, 'Buy', NULL, NULL, 30000.00);

-- Customer Feedback
INSERT INTO CustomerFeedback (FeedbackID, CustomerID, ProductID, Rating, Comment, FeedbackDate, TransactionID) VALUES
(1, 1, 1, 5, 'Odlichen kamion, mnogu zadovolen!', '2025-04-05', '1'),
(2, 2, 2, 4, 'Dobar kamion, no malo skapo.', '2025-04-15', '2');

-- Maintenance
INSERT INTO Maintenance (MainID, EmployeeID, ProductID, MainDate) VALUES
(1, 2, 1, '2025-04-20'),
(2, 2, 2, '2025-04-22');

-- Views
INSERT INTO Views (CustomerID, ProductID) VALUES
(1, 1),
(2, 2),
(1, 3);