Исправил шестую и седьмую лабы

2 files changed, 4 insertions, 4 deletions

diff --git a/task6_triggers.sql b/task6_triggers.sql
index 3275880..20b1e6e 100644
--- a/task6_triggers.sql
+++ b/task6_triggers.sql
@@ -52,7 +52,7 @@ DROP TRIGGER RemoveDriverOnDelivery
 GO
 
 INSERT INTO Deliveries (driver_id, vehicle_id, route_id, date)
-VALUES (1, 1, 1, '2021-09-08')
+VALUES (1, 1, 1, '2021-04-15')
 GO
 
 UPDATE Deliveries
@@ -154,7 +154,7 @@ DROP TRIGGER UpdateOrdersView
 GO
 
 UPDATE OrdersView
-SET driver_id=2
+SET driver_id=1
 WHERE order_date='2021-09-12'
 GO
 
diff --git a/task7_procedures.sql b/task7_procedures.sql
index 891db18..f3d7e84 100644
--- a/task7_procedures.sql
+++ b/task7_procedures.sql
@@ -41,10 +41,10 @@ DROP PROCEDURE calculate_order_price
 GO
 
 INSERT INTO Boxes (order_id, warehouse_id, wrapping_id, volume, weight)
-VALUES (100020, 1, 1, 0.1, 10);
+VALUES (100022, 1, 1, 0.1, 10);
 
 DECLARE @price INT;
-EXEC calculate_order_price 100020, @price OUTPUT;
+EXEC calculate_order_price 100022, @price OUTPUT;
 PRINT @price
 GO