View difference between Paste ID: sjRe5TBT and TtL05teE

 -- Tworzenie tabeli urządzeń OZE
 
 CREATE TABLE Renewable_Energy_Devices (
     device_id NVARCHAR(26) PRIMARY KEY,
     device_status INT CHECK (device_status >= 0 AND device_status <= 6),
 	device_power DECIMAL(18,0),
 	company_id INT
 );
 
--- Wstawianie danych do tabeli urządzeń OZE
+
-INSERT INTO Renewable_Energy_Devices (device_id, device_status, device_power, company_id)
+
-VALUES
+
-('00000000000000000000000000',0,	1000,1),
+
-('00000000000000000000000001',0,	1000,1),
+
-('00000000000000000000000002',0,	1000,1),
+
-('00000000000000000000000003',1,	2000,1),
+
-('00000000000000000000000004',0,	1000,1),
+
-('00000000000000000000000005',0,	1000,1),
+
-('00000000000000000000000006',0,	1000,1),
+
-('00000000000000000000000007',3,	1000,1),
+
-('00000000000000000000000008',0,	5000,1),
+
-('00000000000000000000000009',0,	1000,1),
+
-('00000000000000000000000010',2,	1000,1),
+
-('00000000000000000000000011',0,	1000,1),
+
-('00000000000000000000000012',4,	1000,1),
+
-('00000000000000000000000013',0,	1000,1),
+
-('00000000000000000000000014',0,	1000,1),
+
-('00000000000000000000000015',2,	4000,1),
+
-('00000000000000000000000016',1,	1000,1),
+
-('00000000000000000000000017',0,	1000,1),
+
-('00000000000000000000000018',0,	1000,1),
+
-('00000000000000000000000019',0,	1000,1),
+
-('00000000000000000000000020',6,	7000,1),
+
-('00000000000000000000000021',0,	1000,1),
+
-('00000000000000000000000022',0,	1000,1),
+
-('00000000000000000000000023',0,	1000,1),
+
-('00000000000000000000000024',4,	1000,1),
+
-('00000000000000000000000025',0,	1000,1),
+
-('00000000000000000000000026',0,	1000,1),
+
-('00000000000000000000000027',0,	1000,1),
+
-('00000000000000000000000028',0,	1000,1),
+
-('00000000000000000000000029',0,	1000,1),
+
-('00000000000000000000000030',0,	1000,1),
+
-('00000000000000000000000031',2,	8000,1),
+
-('00000000000000000000000032',0,	1000,1),
+
-('00000000000000000000000033',3,	1000,1),
+
-('00000000000000000000000034',0,	1000,1),
+
-('00000000000000000000000035',0,	1000,1),
+
-('00000000000000000000000036',4,	1000,1),
+
-('00000000000000000000000037',0,	1000,1),
+
-('00000000000000000000000038',0,	1000,1),
+
-('00000000000000000000000039',0,	1000,1),
+
-('00000000000000000000000040',0,	1000,1),
+
-('00000000000000000000000041',5,	1000,1),
+
-('00000000000000000000000042',0,	1000,1),
+
-('00000000000000000000000043',0,	1000,1),
+
-('00000000000000000000000044',4,	1000,1),
+
-('00000000000000000000000045',0,	1000,1),
+
-('00000000000000000000000046',3,	9000,1),
+
-('00000000000000000000000047',0,	1000,1),
+
-('00000000000000000000000048',2,	1000,1),
+
-('00000000000000000000000049',0,	1000,1),
+
-('00000000000000000000000050',3,	7000,1);
+
 
 CREATE TABLE Servicing_Shifts (
     shift_number INT PRIMARY KEY IDENTITY,
     shift_date DATE,
     shift_type INT CHECK (shift_type >= 1 AND shift_type <= 3),
     start_time TIME,
     end_time TIME
 );
 
 
 
 -- Tworzenie tabeli napraw
 
--- Wstawianie danych do tabeli zgłoszeń awarii
+
     repair_id INT PRIMARY KEY IDENTITY,
-DECLARE @i INT = 0
+
-WHILE @i <= 9
+
-BEGIN
+
-    INSERT INTO Device_Failures (device_id, shift_number, failure_start, failure_end)
+
-    VALUES (CONCAT('0000000000000000000000000', @i), round(rand() * 2 + 1,0,0), DATEADD(DAY, -@i, GETDATE()), DATEADD(DAY, -@i+1, GETDATE()));
+
-    SET @i = @i + 1
+);