/*
   2010. március 19.10:12:42
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker
   Application: 
*/

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlef
	DROP CONSTRAINT FK_szall_szlef_szallito
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlef
	DROP CONSTRAINT FK_szall_szlef_deviza
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlef
	DROP CONSTRAINT FK_szall_szlef_raktarak
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlef
	DROP CONSTRAINT FK_szall_szlef_belepes
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szall_szlef
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	HIVSZAM varchar(50) NOT NULL,
	szlaszam dbo.bizonylat_szam NOT NULL,
	rendszam dbo.bizonylat_szam NULL,
	SZALLITO dbo.kulcs NOT NULL,
	SZALL_NEV dbo.nev NULL,
	TELJ_DATUM dbo.datum NOT NULL,
	BEV_DATUM dbo.datum NOT NULL,
	RAKTAR_KOD dbo.kulcs NOT NULL,
	penznem dbo.penznem NOT NULL,
	kurzus dbo.kurzus NOT NULL,
	afamentes bit NOT NULL,
	MEGJEGYZES dbo.megjegyzes NOT NULL,
	KICSODA dbo.kicsoda NOT NULL,
	MODOSITVA dbo.datum_ora NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	TOROLT char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	TORLO char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	TOR_SSZ dbo.bizonylat_szam NOT NULL,
	VISSZARU char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	okmany_tip char(1) NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.szall_szlef)
	 EXEC('INSERT INTO dbo.Tmp_szall_szlef (BIZSZAM, HIVSZAM, szlaszam, rendszam, SZALLITO, SZALL_NEV, TELJ_DATUM, BEV_DATUM, RAKTAR_KOD, penznem, kurzus, afamentes, MEGJEGYZES, KICSODA, MODOSITVA, kedvezmeny, TOROLT, TORLO, TOR_SSZ, VISSZARU, okmany_tip)
		SELECT BIZSZAM, CONVERT(varchar(50), HIVSZAM), szlaszam, rendszam, SZALLITO, SZALL_NEV, TELJ_DATUM, BEV_DATUM, RAKTAR_KOD, penznem, kurzus, afamentes, MEGJEGYZES, KICSODA, MODOSITVA, kedvezmeny, TOROLT, TORLO, TOR_SSZ, VISSZARU, okmany_tip FROM dbo.szall_szlef WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_szall_szlef
GO
DROP TABLE dbo.szall_szlef
GO
EXECUTE sp_rename N'dbo.Tmp_szall_szlef', N'szall_szlef', 'OBJECT' 
GO
ALTER TABLE dbo.szall_szlef ADD CONSTRAINT
	PK_szall_szlef PRIMARY KEY CLUSTERED 
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_szall_szlef ON dbo.szall_szlef
	(
	SZALLITO
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_szall_szlef_1 ON dbo.szall_szlef
	(
	TELJ_DATUM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_szall_szlef_2 ON dbo.szall_szlef
	(
	RAKTAR_KOD
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szall_szlef ADD CONSTRAINT
	FK_szall_szlef_belepes FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlef ADD CONSTRAINT
	FK_szall_szlef_raktarak FOREIGN KEY
	(
	RAKTAR_KOD
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlef ADD CONSTRAINT
	FK_szall_szlef_deviza FOREIGN KEY
	(
	penznem
	) REFERENCES dbo.deviza
	(
	penznem
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlef ADD CONSTRAINT
	FK_szall_szlef_szallito FOREIGN KEY
	(
	SZALLITO
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlet ADD CONSTRAINT
	FK_szall_szlet_szall_szlef FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.szall_szlef
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT