root/trunk/SQL/Tables/ProvisionSettings.txt @ 761

Wersja 677, 0.6 KB (wprowadzona przez marek, 17 years temu)

re #178

Line 
1
2/****** Object:  Table [dbo].[ProvisionSettings]    Script Date: 06/03/2009 15:47:19 ******/
3SET ANSI_NULLS ON
4GO
5SET QUOTED_IDENTIFIER ON
6GO
7CREATE 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.