/*
   2010. február 1.14:36:33
   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.vonal
	DROP CONSTRAINT FK_VONAL_CIKKEK
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vonal
	(
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	VONALKOD nvarchar(14) COLLATE Hungarian_CS_AS NOT NULL,
	SZORZO dbo.kulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	ALAP char(1) NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.vonal)
	 EXEC('INSERT INTO dbo.Tmp_vonal (CIKK_SZAM, VONALKOD, SZORZO, MENNY_EGYS, ALAP)
		SELECT CIKK_SZAM, CONVERT(nvarchar(14), VONALKOD), SZORZO, MENNY_EGYS, ALAP FROM dbo.vonal WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vonal
GO
EXECUTE sp_rename N'dbo.Tmp_vonal', N'vonal', 'OBJECT' 
GO
ALTER TABLE dbo.vonal ADD CONSTRAINT
	PK_VONAL PRIMARY KEY CLUSTERED 
	(
	VONALKOD
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_VONAL ON dbo.vonal
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.vonal ADD CONSTRAINT
	FK_VONAL_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT