| Line | |
|---|
| 1 | USE [BAZA_REKLAM]
|
|---|
| 2 | GO
|
|---|
| 3 | /****** Object: Table [dbo].[ErrorLog] Script Date: 04/07/2009 16:41:58 ******/
|
|---|
| 4 | SET ANSI_NULLS ON
|
|---|
| 5 | GO
|
|---|
| 6 | SET QUOTED_IDENTIFIER ON
|
|---|
| 7 | GO
|
|---|
| 8 | CREATE TABLE [dbo].[ErrorLog](
|
|---|
| 9 | [Id] [int] IDENTITY(1,1) NOT NULL,
|
|---|
| 10 | [ErrorTypeId] [int] NOT NULL,
|
|---|
| 11 | [UserName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
|
|---|
| 12 | [DateTime] [datetime] NULL,
|
|---|
| 13 | [ErrorDetails] [text] COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
|
|---|
| 14 | CONSTRAINT [PK_ErrorLog] PRIMARY KEY CLUSTERED
|
|---|
| 15 | (
|
|---|
| 16 | [Id] ASC
|
|---|
| 17 | ) ON [PRIMARY]
|
|---|
| 18 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|---|
| 19 |
|
|---|
| 20 | GO
|
|---|
| 21 | USE [BAZA_REKLAM]
|
|---|
| 22 | GO
|
|---|
| 23 | ALTER TABLE [dbo].[ErrorLog] WITH CHECK ADD CONSTRAINT [FK_ErrorLog_ErrorType] FOREIGN KEY([ErrorTypeId])
|
|---|
| 24 | REFERENCES [dbo].[ErrorType] ([Id]) |
|---|
Notatka: Zobacz
TracBrowser
aby uzyskać więcej informacji.
