diff options
| author | Andrew Arnott <andrewarnott@gmail.com> | 2009-12-16 09:41:05 -0800 |
|---|---|---|
| committer | Andrew Arnott <andrewarnott@gmail.com> | 2009-12-16 09:41:05 -0800 |
| commit | 5293721eabaa66854d9f66871ef5e9df727e5553 (patch) | |
| tree | 20dd05adc42c3f631aae7b182691cf36baaae449 /projecttemplates/RelyingPartyDatabase | |
| parent | 1dcd4637ae7e8fe791a3a862c37ca79a9f4e3e22 (diff) | |
| download | DotNetOpenAuth-5293721eabaa66854d9f66871ef5e9df727e5553.zip DotNetOpenAuth-5293721eabaa66854d9f66871ef5e9df727e5553.tar.gz DotNetOpenAuth-5293721eabaa66854d9f66871ef5e9df727e5553.tar.bz2 | |
Added a logging table to the project template database.
Diffstat (limited to 'projecttemplates/RelyingPartyDatabase')
| -rw-r--r-- | projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.dbproj | 3 | ||||
| -rw-r--r-- | projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Log.table.sql | 9 |
2 files changed, 12 insertions, 0 deletions
diff --git a/projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.dbproj b/projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.dbproj index 2488a51..b791198 100644 --- a/projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.dbproj +++ b/projecttemplates/RelyingPartyDatabase/RelyingPartyDatabase.dbproj @@ -246,6 +246,9 @@ <Build Include="Schema Objects\Schemas\dbo\Tables\Keys\PK_UserRole.pkey.sql"> <SubType>Code</SubType> </Build> + <Build Include="Schema Objects\Schemas\dbo\Tables\Log.table.sql"> + <SubType>Code</SubType> + </Build> <Build Include="Schema Objects\Schemas\dbo\Tables\Nonce.table.sql"> <SubType>Code</SubType> <AnsiNulls>On</AnsiNulls> diff --git a/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Log.table.sql b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Log.table.sql new file mode 100644 index 0000000..84fd97a --- /dev/null +++ b/projecttemplates/RelyingPartyDatabase/Schema Objects/Schemas/dbo/Tables/Log.table.sql @@ -0,0 +1,9 @@ +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 +) |