/* 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_art
	DROP CONSTRAINT FK_VEVO_ART_VEVO_ARF
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_art
	DROP CONSTRAINT FK_VEVO_ART_vevo_arcsoport
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_art
	(
	ARCSOPORT int NOT NULL,
	sorrend int NOT NULL,
	szallito dbo.kulcs NOT NULL,
	gyarto dbo.kulcs NULL,
	CIKK_CSOP char(18) NOT NULL,
	FELAR dbo.kedvezmeny NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.vevo_art)
	 EXEC('INSERT INTO dbo.Tmp_vevo_art (ARCSOPORT, sorrend, szallito, CIKK_CSOP, FELAR)
		SELECT ARCSOPORT, sorrend, szallito, CIKK_CSOP, FELAR FROM dbo.vevo_art WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_art
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_art', N'vevo_art', 'OBJECT' 
GO
CREATE NONCLUSTERED INDEX IX_vevo_art ON dbo.vevo_art
	(
	ARCSOPORT
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.vevo_art ADD CONSTRAINT
	FK_VEVO_ART_vevo_arcsoport FOREIGN KEY
	(
	ARCSOPORT
	) REFERENCES dbo.vevo_arcsoport
	(
	KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_art ADD CONSTRAINT
	FK_VEVO_ART_VEVO_ARF FOREIGN KEY
	(
	ARCSOPORT
	) REFERENCES dbo.vevo_arf
	(
	ARCSOPORT
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT

update vevo_art set gyarto=0
go