summaryrefslogtreecommitdiffstats
path: root/projecttemplates/RelyingPartyLogic/CreateDatabase.sql
diff options
context:
space:
mode:
Diffstat (limited to 'projecttemplates/RelyingPartyLogic/CreateDatabase.sql')
-rw-r--r--projecttemplates/RelyingPartyLogic/CreateDatabase.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql
index 722740f..909315f 100644
--- a/projecttemplates/RelyingPartyLogic/CreateDatabase.sql
+++ b/projecttemplates/RelyingPartyLogic/CreateDatabase.sql
@@ -240,6 +240,22 @@ SET ANSI_NULLS, QUOTED_IDENTIFIER OFF;
GO
+PRINT N'Creating dbo.Log...';
+
+
+GO
+CREATE TABLE [dbo].[Log] (
+ [Id] INT IDENTITY (1, 1) NOT NULL,
+ [Date] DATETIME NOT NULL,
+ [Thread] VARCHAR (255) NOT NULL,
+ [Level] VARCHAR (50) NOT NULL,
+ [Logger] VARCHAR (255) NOT NULL,
+ [Message] VARCHAR (4000) NOT NULL,
+ [Exception] VARCHAR (2000) NULL
+);
+
+
+GO
PRINT N'Creating dbo.Nonce...';