/*
   2013. május 16.13:29:49
   User: sa
   Server: 192.168.59.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.vevo_szlaf_export
	DROP CONSTRAINT FK_vevo_szlaf_export_vevo_szlaf
GO
ALTER TABLE dbo.vevo_szlaf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlaf_export
	DROP CONSTRAINT DF_vevo_szlaf_export_vevotel
GO
CREATE TABLE dbo.Tmp_vevo_szlaf_export
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	vevotel char(4) NOT NULL,
	rendszam varchar(50) NOT NULL,
	szall_felt varchar(50) NOT NULL,
	szall_mod varchar(50) NOT NULL,
	csomag varchar(50) NOT NULL,
	suly varchar(80) NOT NULL,
	zaradek varchar(1500) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_szlaf_export SET (LOCK_ESCALATION = TABLE)
GO
ALTER TABLE dbo.Tmp_vevo_szlaf_export ADD CONSTRAINT
	DF_vevo_szlaf_export_vevotel DEFAULT ('0') FOR vevotel
GO
IF EXISTS(SELECT * FROM dbo.vevo_szlaf_export)
	 EXEC('INSERT INTO dbo.Tmp_vevo_szlaf_export (BIZSZAM, vevotel, rendszam, szall_felt, szall_mod, csomag, suly, zaradek)
		SELECT BIZSZAM, vevotel, rendszam, szall_felt, szall_mod, csomag, suly, zaradek FROM dbo.vevo_szlaf_export WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_szlaf_export
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_szlaf_export', N'vevo_szlaf_export', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_szlaf_export ADD CONSTRAINT
	PK_vevo_szlaf_export PRIMARY KEY CLUSTERED 
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_szlaf_export ADD CONSTRAINT
	FK_vevo_szlaf_export_vevo_szlaf FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_szlaf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT