From 02c5cfc5f4e36dbd8d617443bf7f1b7c5fb29f34 Mon Sep 17 00:00:00 2001
From: Andrew <saintruler@gmail.com>
Date: Fri, 17 Dec 2021 04:03:54 +0400
Subject: =?UTF-8?q?=D0=94=D0=BE=D0=B1=D0=B0=D0=B2=D0=B8=D0=BB=20=D0=B7?=
 =?UTF-8?q?=D0=B0=D0=BF=D1=80=D0=BE=D1=81=D1=8B=20=D0=B4=D0=BB=D1=8F=20?=
 =?UTF-8?q?=D1=81=D0=BE=D0=B7=D0=B4=D0=B0=D0=BD=D0=B8=D1=8F=20=D0=BF=D1=80?=
 =?UTF-8?q?=D0=BE=D1=86=D0=B5=D0=B4=D1=83=D1=80=20=D1=81=D0=B5=D0=B4=D1=8C?=
 =?UTF-8?q?=D0=BC=D0=BE=D0=B9=20=D0=BB=D0=B0=D0=B1=D1=8B.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 task6_triggers.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'task6_triggers.sql')

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 --
 ---------------
-- 
cgit v1.2.3