Index: trunk/SQL/Tables/ErrorLog.txt
===================================================================
--- trunk/SQL/Tables/ErrorLog.txt (revision 553)
+++ trunk/SQL/Tables/ErrorLog.txt (revision 553)
@@ -0,0 +1,24 @@
+USE [BAZA_REKLAM]
+GO
+/****** Object:  Table [dbo].[ErrorLog]    Script Date: 04/07/2009 16:41:58 ******/
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [dbo].[ErrorLog](
+	[Id] [int] IDENTITY(1,1) NOT NULL,
+	[ErrorTypeId] [int] NOT NULL,
+	[UserName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
+	[DateTime] [datetime] NULL,
+	[ErrorDetails] [text] COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
+ CONSTRAINT [PK_ErrorLog] PRIMARY KEY CLUSTERED 
+(
+	[Id] ASC
+) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+
+GO
+USE [BAZA_REKLAM]
+GO
+ALTER TABLE [dbo].[ErrorLog]  WITH CHECK ADD  CONSTRAINT [FK_ErrorLog_ErrorType] FOREIGN KEY([ErrorTypeId])
+REFERENCES [dbo].[ErrorType] ([Id])
Index: trunk/SQL/Tables/ErrorType.txt
===================================================================
--- trunk/SQL/Tables/ErrorType.txt (revision 553)
+++ trunk/SQL/Tables/ErrorType.txt (revision 553)
@@ -0,0 +1,15 @@
+USE [BAZA_REKLAM]
+GO
+/****** Object:  Table [dbo].[ErrorType]    Script Date: 04/07/2009 16:42:19 ******/
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+CREATE TABLE [dbo].[ErrorType](
+	[Id] [int] IDENTITY(1,1) NOT NULL,
+	[ErrorMessage] [nvarchar](100) COLLATE SQL_Latin1_General_CP1250_CI_AS NOT NULL,
+ CONSTRAINT [PK_ErrorType] PRIMARY KEY CLUSTERED 
+(
+	[Id] ASC
+) ON [PRIMARY]
+) ON [PRIMARY]
Index: trunk/SQL/StoredProcedures/sp_LogException.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_LogException.txt (revision 554)
+++ trunk/SQL/StoredProcedures/sp_LogException.txt (revision 554)
@@ -0,0 +1,43 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+-- =============================================
+-- Author:		marek
+-- Create date: 07/04/2009
+-- Description:	Dodaje wyjatek do tabeli ErrorLog, 
+--				jesli istnieje juz taki wyjatek w tabeli ErrorType to uzywa go jako katogorii,
+--				jesli nie, to wstawia nowa kategorie wyjatku
+-- =============================================
+ALTER PROCEDURE [dbo].[sp_LogException]
+	-- Add the parameters for the stored procedure here
+	@errorMessage nvarchar(100),
+	@userName nvarchar(50),
+	@dateTime datetime,
+	@errorDetails nvarchar(4000)
+AS
+BEGIN
+
+	DECLARE @errorTypeId INT
+
+	SELECT @errorTypeId=Id FROM dbo.ErrorType WHERE ErrorMessage=@errorMessage
+
+	IF (@errorTypeId IS NULL OR @errorTypeId<=0)
+		BEGIN
+			INSERT INTO dbo.ErrorType(ErrorMessage) VALUES (@errorMessage)
+			SELECT @errorTypeId=SCOPE_IDENTITY()
+		END
+
+	INSERT INTO dbo.ErrorLog(ErrorTypeId, UserName, [DateTime], ErrorDetails) 
+	VALUES (@errorTypeId, @userName, @dateTime, @errorDetails)
+
+END
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+