uid  =  S a

 uid  =  S a

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ЛюдиЖД_ПродажаЖД]') and OBJECTPROPERTY(id, N'IsForeignKey') =  1 )
ALTER TABLE [dbo].[ЛюдиЖД] DROP CONSTRAINT FK_ЛюдиЖД_ПродажаЖД
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ЛюдиЖД]') and OBJECTPROPERTY(id, N'IsUserTable') =  1 )
drop table [dbo].[ЛюдиЖД]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ПродажаЖД]') and OBJECTPROPERTY(id, N'IsUserTable') =  1 )
drop table [dbo].[ПродажаЖД]
GO

CREATE TABLE [dbo].[ЛюдиЖД] (
	[Код_человека] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[ФИО] [varchar] ( 100 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Номер_бланка] [varchar] ( 20 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Дата1] [smalldatetime] NULL ,
	[Дата2] [smalldatetime] NULL ,
	[Класс] [int] NULL ,
	[Число_мест] [int] NULL ,
	[Город1] [int] NULL ,
	[Город2] [int] NULL ,
	[Город3] [int] NULL ,
	[Тариф] [money] NULL ,
	[КомСбор] [money] NULL ,
	[Код_продажи] [int] NULL ,
	[ВТЧСтВзнос] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ПродажаЖД] (
	[Код_продажи] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Код_контрагента] [int] NULL ,
	[Форма_оплаты] [int] NULL ,
	[Номер_накладной] [varchar] ( 12 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Дата_от] [smalldatetime] NULL ,
	[Оператор] [varchar] ( 32 ) COLLATE Cyrillic_General_CI_AS NULL ,
	[Сотруднику] [int] NULL ,
	[Дата_создания] [smalldatetime] NULL ,
	[Код] [int] NOT NULL ,
	[Префикс] [varchar] ( 10 ) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[К_уделению] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ЛюдиЖД] WITH NOCHECK ADD 
	CONSTRAINT [PK_ЛюдиЖД] PRIMARY KEY  CLUSTERED 
	(
		[Код_человека]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ПродажаЖД] WITH NOCHECK ADD 
	CONSTRAINT [PK_ПродажаЖД] PRIMARY KEY  CLUSTERED 
	(
		[Код_продажи]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ЛюдиЖД] WITH NOCHECK ADD 
	CONSTRAINT [DF_ЛюдиЖД_ВТЧСтВзнос] DEFAULT ( 2 . 30 ) FOR [ВТЧСтВзнос]
GO

ALTER TABLE [dbo].[ПродажаЖД] WITH NOCHECK ADD 
	CONSTRAINT [DF_ПродажаЖД_Сотруднику] DEFAULT (null) FOR [Сотруднику],
	CONSTRAINT [DF_ПродажаЖД_Дата_создания] DEFAULT (getdate()) FOR [Дата_создания],
	CONSTRAINT [DF_ПродажаЖД_К_уделению] DEFAULT ( 0 ) FOR [К_уделению]
GO

 CREATE  INDEX [IX_ЛюдиЖД] ON [dbo].[ЛюдиЖД]([Код_человека]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [IX_ПродажаЖД] ON [dbo].[ПродажаЖД]([Код_продажи]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ЛюдиЖД] ADD 
	CONSTRAINT [FK_ЛюдиЖД_Города] FOREIGN KEY 
	(
		[Город1]
	) REFERENCES [dbo].[Города] (
		[Код_города]
	),
	CONSTRAINT [FK_ЛюдиЖД_Города1] FOREIGN KEY 
	(
		[Город2]
	) REFERENCES [dbo].[Города] (
		[Код_города]
	),
	CONSTRAINT [FK_ЛюдиЖД_Города2] FOREIGN KEY 
	(
		[Город3]
	) REFERENCES [dbo].[Города] (
		[Код_города]
	),
	CONSTRAINT [FK_ЛюдиЖД_Классы] FOREIGN KEY 
	(
		[Класс]
	) REFERENCES [dbo].[Классы] (
		[Код_класса]
	),
	CONSTRAINT [FK_ЛюдиЖД_ПродажаЖД] FOREIGN KEY 
	(
		[Код_продажи]
	) REFERENCES [dbo].[ПродажаЖД] (
		[Код_продажи]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
GO

ALTER TABLE [dbo].[ПродажаЖД] ADD 
	CONSTRAINT [FK_ПродажаЖД_Контрагенты] FOREIGN KEY 
	(
		[Код_контрагента]
	) REFERENCES [dbo].[Контрагенты] (
		[Код_контрагента]
	),
	CONSTRAINT [FK_ПродажаЖД_Сотрудники] FOREIGN KEY 
	(
		[Сотруднику]
	) REFERENCES [dbo].[Сотрудники] (
		[Код_сотрудника]
	),
	CONSTRAINT [FK_ПродажаЖД_ФормыОплаты] FOREIGN KEY 
	(
		[Форма_оплаты]
	) REFERENCES [dbo].[ФормыОплаты] (
		[Код_формы]
	)
GO

 uid  =  S a

 uid  =  S a