initial commit
[CPE_learningsite] / CPE / CPE.App / CPE.App.Notify / Database / NotifyLog_TableCreate.sql
1 USE [webcpe_reporting]
2 GO
3
4 /****** Object:  Table [dbo].[NotifyLog]    Script Date: 8/24/2016 9:17:16 AM ******/
5 SET ANSI_NULLS ON
6 GO
7
8 SET QUOTED_IDENTIFIER ON
9 GO
10
11 SET ANSI_PADDING ON
12 GO
13
14 CREATE TABLE [dbo].[NotifyLog](
15         [Id] [int] IDENTITY(1,1) NOT NULL,
16         [Date] [datetime] NOT NULL,
17         [Thread] [varchar](255) NOT NULL,
18         [Level] [varchar](50) NOT NULL,
19         [Logger] [varchar](255) NOT NULL,
20         [Message] [varchar](4000) NOT NULL,
21         [Exception] [varchar](2000) NULL
22 ) ON [PRIMARY]
23
24 GO
25
26 SET ANSI_PADDING OFF
27 GO