summaryrefslogtreecommitdiff
path: root/task6_triggers.sql
diff options
context:
space:
mode:
authorAndrew <saintruler@gmail.com>2021-12-17 08:19:30 +0400
committerAndrew <saintruler@gmail.com>2021-12-17 08:19:30 +0400
commit15860fa29285ce48959f980dd44027f683f28b66 (patch)
tree5100c4bd4436799ce03e6675181a12a82c870a9a /task6_triggers.sql
parent9bd4a687c64c31dbed810e65297601d0233242f2 (diff)
Исправил шестую и седьмую лабы
Diffstat (limited to 'task6_triggers.sql')
-rw-r--r--task6_triggers.sql18
1 files changed, 0 insertions, 18 deletions
diff --git a/task6_triggers.sql b/task6_triggers.sql
index 67c79e3..3275880 100644
--- a/task6_triggers.sql
+++ b/task6_triggers.sql
@@ -63,24 +63,6 @@ GO
DELETE FROM Deliveries WHERE driver_id=2
GO
--- Add
-
-INSERT INTO Drivers (city_id, salary, on_delivery)
-VALUES (4, 35000, 0);
-GO
-
-INSERT INTO Vehicles (name, tonnage, gas_consumption)
-VALUES (N'KAMAZ', 30, 50);
-GO
-
-INSERT INTO Routes (city1_id, city2_id, distance)
-VALUES (1, 2, 900);
-GO
-
-INSERT INTO Deliveries (driver_id, vehicle_id, route_id, date)
-VALUES (1, 1, 1, '2021-09-08');
-GO
-
---------------
-- Задание 2 --
---------------