Скрипт создания базы данных

USE [Abonka]
GO
/****** Object:  Table [dbo].[znuwku]    Script Date: 12/19/2010 18:45:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[znuwku](
[id] [int] IDENTITY(1,1) NOT NULL,
[vidsotok] [int] NULL,
[abonStaw] [int] NULL,
 CONSTRAINT [PK_znuwku] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[poslygu]    Script Date: 12/19/2010 18:45:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[poslygu](
[id] [int] IDENTITY(1,1) NOT NULL,
[opus] [nvarchar](50) NULL,
[truvalist] [datetime] NULL,
[vartist] [money] NULL,
 CONSTRAINT [PK_poslygu] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[taruf]    Script Date: 12/19/2010 18:45:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[taruf](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nchar](10) NULL,
[vartist] [money] NULL,
 CONSTRAINT [PK_taruf] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[client]    Script Date: 12/19/2010 18:45:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[client](
[id] [int] IDENTITY(1,1) NOT NULL,
[idTaruf] [int] NULL,
[pib] [nvarchar](50) NULL,
[kilkPC] [int] NULL,
[dateConnect] [datetime] NULL CONSTRAINT [DF_client_dateConnect]  DEFAULT (getdate()),
[numberZnawku] [int] NULL,
[abonPlata] [money] NULL,
[stanClient] [nvarchar](50) NULL,
[summaNaRaxynky] [money] NULL,
[idAccount] [int] NULL,
[Misve] [varchar](50) NULL,
 CONSTRAINT [PK_Client] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[poslugeClient]    Script Date: 12/19/2010 18:45:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[poslugeClient](
[id] [int] IDENTITY(1,1) NOT NULL,
[idClient] [int] NULL,
[idPoslugu] [int] NULL,
 CONSTRAINT [PK_poslugeClient] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[oplata]    Script Date: 12/19/2010 18:45:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[oplata](
[id] [int] IDENTITY(1,1) NOT NULL,
[idClient] [int] NOT NULL,
[dateTimeOplatu] [datetime] NOT NULL CONSTRAINT [DF_oplata_dateTimeOplatu]  DEFAULT (getdate()),
[oplachenoDo] [datetime] NOT NULL,
[idOperator] [int] NULL,
[numberPopovnenna] [int] NULL,
[summa] [money] NOT NULL,
 CONSTRAINT [PK_oplata] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  ForeignKey [FK_client_taruf]    Script Date: 12/19/2010 18:45:31 ******/
ALTER TABLE [dbo].[client]  WITH CHECK ADD  CONSTRAINT [FK_client_taruf] FOREIGN KEY([idTaruf])
REFERENCES [dbo].[taruf] ([id])
GO
ALTER TABLE [dbo].[client] CHECK CONSTRAINT [FK_client_taruf]
GO
/****** Object:  ForeignKey [FK_client_znuwku]    Script Date: 12/19/2010 18:45:31 ******/
ALTER TABLE [dbo].[client]  WITH CHECK ADD  CONSTRAINT [FK_client_znuwku] FOREIGN KEY([numberZnawku])
REFERENCES [dbo].[znuwku] ([id])
GO
ALTER TABLE [dbo].[client] CHECK CONSTRAINT [FK_client_znuwku]
GO
/****** Object:  ForeignKey [FK_oplata_client]    Script Date: 12/19/2010 18:45:33 ******/
ALTER TABLE [dbo].[oplata]  WITH CHECK ADD  CONSTRAINT [FK_oplata_client] FOREIGN KEY([idClient])
REFERENCES [dbo].[client] ([id])
GO
ALTER TABLE [dbo].[oplata] CHECK CONSTRAINT [FK_oplata_client]
GO
/****** Object:  ForeignKey [FK_poslugeClient_poslygu]    Script Date: 12/19/2010 18:45:34 ******/
ALTER TABLE [dbo].[poslugeClient]  WITH CHECK ADD  CONSTRAINT [FK_poslugeClient_poslygu] FOREIGN KEY([idPoslugu])
REFERENCES [dbo].[poslygu] ([id])
GO
ALTER TABLE [dbo].[poslugeClient] CHECK CONSTRAINT [FK_poslugeClient_poslygu]
GO

--------------------------------------------------------------------------------------------------

USE [Account]

GO

/****** Object:  Table [dbo].[posada]    Script Date: 12/19/2010 18:46:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[posada](

[id] [int] IDENTITY(1,1) NOT NULL,

[posada] [nchar](10) NULL,

 CONSTRAINT [PK_posada] PRIMARY KEY CLUSTERED 

(

[id] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[popovnennaRaxynky]    Script Date: 12/19/2010 18:46:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[popovnennaRaxynky](

[id] [int] IDENTITY(1,1) NOT NULL,

[numberPopodnenna] [nvarchar](50) NULL,

[summa] [money] NULL,

[stan] [bit] NULL,

 CONSTRAINT [PK_popovnennaRaxynky] PRIMARY KEY CLUSTERED 

(

[id] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Account]    Script Date: 12/19/2010 18:46:56 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Account](

[id] [int] IDENTITY(1,1) NOT NULL,

[login] [nvarchar](50) NULL,

[password] [nvarchar](50) NULL,

[ip] [nvarchar](50) NULL,

[idPosadu] [int] NULL,

[idClient] [int] NULL,

 CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED 

(

[id] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  ForeignKey [FK_Account_posada1]    Script Date: 12/19/2010 18:46:56 ******/

ALTER TABLE [dbo].[Account]  WITH CHECK ADD  CONSTRAINT [FK_Account_posada1] FOREIGN KEY([idPosadu])

REFERENCES [dbo].[posada] ([id])

GO

ALTER TABLE [dbo].[Account] CHECK CONSTRAINT [FK_Account_posada1]

GO