/* 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_ar_lista
	DROP CONSTRAINT FK_vevo_art1_CIKKEK
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_ar_lista
	DROP CONSTRAINT FK_vevo_art1_BELEPES
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_ar_lista
	DROP CONSTRAINT FK_vevo_art1_vevo_arcsoport
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_ar_lista
	(
	arcsoport int NOT NULL,
	datum char(10) NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	netto_ar dbo.egyseg_ar NULL,
	brutto_ar dbo.egyseg_ar NULL,
	beszerz_ar dbo.egyseg_ar NULL,
	arres dbo.egyseg_ar NULL,
	kicsoda dbo.kicsoda NULL,
	modositva dbo.datum_ora NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.vevo_ar_lista)
	 EXEC('INSERT INTO dbo.Tmp_vevo_ar_lista (arcsoport, datum, cikk_szam, netto_ar, brutto_ar, beszerz_ar, arres, kicsoda, modositva)
		SELECT arcsoport, datum, cikk_szam, netto_ar, brutto_ar, beszerz_ar, arres, kicsoda, modositva FROM dbo.vevo_ar_lista WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_ar_lista
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_ar_lista', N'vevo_ar_lista', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_ar_lista ADD CONSTRAINT
	PK_vevo_ar_lista PRIMARY KEY CLUSTERED 
	(
	arcsoport,
	datum,
	cikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_ar_lista ADD CONSTRAINT
	FK_vevo_art1_vevo_arcsoport FOREIGN KEY
	(
	arcsoport
	) REFERENCES dbo.vevo_arcsoport
	(
	KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_ar_lista ADD CONSTRAINT
	FK_vevo_art1_BELEPES FOREIGN KEY
	(
	kicsoda
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_ar_lista ADD CONSTRAINT
	FK_vevo_art1_CIKKEK FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT