Changes between Version 3 and Version 4 of dmlScript-with-help-of-AI.sql

Timestamp:

01/09/26 20:32:37 (11 days ago)

Author:

235018

Comment:

--

dmlScript-with-help-of-AI.sql

@@ -96 +96 @@
 INSERT INTO delivery_address (client_ID, address, city, postcode, country, is_default) VALUES
 (1001, 'st.Partizanska 10', 'Skopje', '1000', 'Macedonia', TRUE),
-(1002, 'st.Turisticka 5', 'Bitola', '7000', 'Macedonia', TRUE),
+(1002, 'st.Turisticka 5', 'Bitola', '1700', 'Macedonia', TRUE),
 (1003, 'st.32 br.4', 'Cucer-Sandevo', '1011', 'Macedonia', TRUE),
 (1004, 'st.Bul.Kuzman Josifovski Pitu 15', 'Skopje', '1000', 'Macedonia', TRUE),
-(1006, 'st.Makedonska Brigada 22', 'Ohrid', '6000', 'Macedonia', TRUE),
-(1003, 'Campus Dormitory, Room 305', 'Skopje', '1000', 'Macedonia', FALSE); -- Second address for client 3
+(1006, 'st.Makedonska Brigada 22', 'Ohrid', '1600', 'Macedonia', TRUE),
+(1003, 'Campus Dormitory "Goce Delcev", Room 305', 'Skopje', '1000', 'Macedonia', FALSE); -- Second address for client 3
 
 -- ORDER
-INSERT INTO "order" (order_num, client_ID, status, last_date_mod, payment_method, discount) VALUES
-('002202500001', 1001, 'placed order', '2025-12-01 10:15:00', 'credit card ****6750', 0.00),
-('002202500002', 1001, 'being processed', '2025-12-10 18:00:00', 'PayPal account user123', 0.00),
-('001202500001', 1002, 'delivered', '2025-12-02 14:30:00', 'cash', 4.00),
-('003202500001', 1003, 'shipping', '2025-12-05 09:45:00', 'credit card ****1234', 10.00),
-('002202500003', 1004, 'canceled', '2025-12-03 16:20:00', 'credit card ****9876', 0.00),
-('001202500002', 1006, 'delivered', '2025-12-08 11:30:00', 'bank transfer', 5.50);
+INSERT INTO "order" (order_num, client_ID, status, last_date_mod, payment_method, discount, delivery_address) VALUES
+('002202500001', 1001, 'placed order', '2025-12-01 10:15:00', 'credit card ****6750', 0.00, 'st.Partizanska 10, Skopje 1000'),
+('002202500002', 1001, 'being processed', '2025-12-10 18:00:00', 'PayPal account user123', 0.00, 'st.Partizanska 10, Skopje 1000'),
+('001202500001', 1002, 'delivered', '2025-12-02 14:30:00', 'cash', 4.00, 'st.Turisticka 5, Bitola 1700'),
+('003202500001', 1003, 'shipping', '2025-12-05 09:45:00', 'credit card ****1234', 10.00, 'Campus Dormitory "Goce Delcev", Room 305, Skopje 1000'),
+('002202500003', 1004, 'canceled', '2025-12-03 16:20:00', 'credit card ****9876', 0.00, 'st.Bul. Kuzman Josifovski Pitu 15, Skopje 1000'),
+('001202500002', 1006, 'delivered', '2025-12-08 11:30:00', 'bank transfer', 5.50, 'st.Makedonska Brigada 22, Ohrid 1600');
 
 -- REPORT