diff options
Diffstat (limited to 'task6_triggers.sql')
| -rw-r--r-- | task6_triggers.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/task6_triggers.sql b/task6_triggers.sql index 1c1a5f6..c6519d8 100644 --- a/task6_triggers.sql +++ b/task6_triggers.sql @@ -63,6 +63,24 @@ 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 -- --------------- |