| Line | |
|---|
| 1 |
|
|---|
| 2 | /****** Object: Table [dbo].[ProvisionSettings] Script Date: 06/03/2009 15:47:19 ******/
|
|---|
| 3 | SET ANSI_NULLS ON
|
|---|
| 4 | GO
|
|---|
| 5 | SET QUOTED_IDENTIFIER ON
|
|---|
| 6 | GO
|
|---|
| 7 | CREATE TABLE [dbo].[ProvisionSettings](
|
|---|
| 8 | [AgencyId] [int] NOT NULL,
|
|---|
| 9 | [Year] [int] NOT NULL,
|
|---|
| 10 | [Month] [int] NOT NULL,
|
|---|
| 11 | [IsBlocked] [bit] NULL,
|
|---|
| 12 | [UpdatedBy] [nvarchar](100) COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
|
|---|
| 13 | [UpdatedOn] [datetime] NULL,
|
|---|
| 14 | [CreatedBy] [nvarchar](100) COLLATE SQL_Latin1_General_CP1250_CI_AS NULL,
|
|---|
| 15 | [CreatedOn] [datetime] NULL,
|
|---|
| 16 | CONSTRAINT [PK_ProvisionSettings] PRIMARY KEY CLUSTERED
|
|---|
| 17 | (
|
|---|
| 18 | [AgencyId] ASC,
|
|---|
| 19 | [Year] ASC,
|
|---|
| 20 | [Month] ASC
|
|---|
| 21 | ) ON [PRIMARY]
|
|---|
| 22 | ) ON [PRIMARY]
|
|---|
Notatka: Zobacz
TracBrowser
aby uzyskać więcej informacji.