Index: trunk/SQL/Triggers/KLIENCI_DELETE.txt
===================================================================
--- trunk/SQL/Triggers/KLIENCI_DELETE.txt (revision 614)
+++ trunk/SQL/Triggers/KLIENCI_DELETE.txt (revision 614)
@@ -0,0 +1,27 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER TRIGGER [KLIENCI_DELETE]
+ON [dbo].[KLIENCI]
+FOR DELETE 
+AS
+
+DECLARE @id INT
+DECLARE @Klient nvarchar(50)
+SELECT @id=CustomerId, @Klient=FirstName FROM deleted
+
+-- zapis do logu
+INSERT INTO dbo.[LOG](OPERACJA, TABELA, OPIS)
+VALUES('DELETE', 'KLIENCI', 'ID: ' + CAST(@id AS varchar) + ' | Name: ' + @Klient + ' | User: ' + USER_NAME())
+
+
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+