/*
   2012. október 10.12:19:55
   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
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_stcikk2
	(
	cikk_szam char(18) NOT NULL,
	cikk_nev dbo.nev NOT NULL,
	cikk_nev_eng dbo.nev NOT NULL,
	kicsoda dbo.kicsoda NOT NULL,
	modositva dbo.datum_ora NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_stcikk2 ADD CONSTRAINT
	DF_stcikk2_cikk_nev_eng DEFAULT '' FOR cikk_nev_eng
GO
IF EXISTS(SELECT * FROM dbo.stcikk2)
	 EXEC('INSERT INTO dbo.Tmp_stcikk2 (cikk_szam, cikk_nev, kicsoda, modositva)
		SELECT cikk_szam, cikk_nev, kicsoda, modositva FROM dbo.stcikk2 WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_cikkek_STCIKK2
GO
DROP TABLE dbo.stcikk2
GO
EXECUTE sp_rename N'dbo.Tmp_stcikk2', N'stcikk2', 'OBJECT' 
GO
ALTER TABLE dbo.stcikk2 ADD CONSTRAINT
	PK_STCIKK2 PRIMARY KEY CLUSTERED 
	(
	cikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.stcikk2 ADD CONSTRAINT
	FK_stcikk2_BELEPES FOREIGN KEY
	(
	kicsoda
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.cikkek ADD CONSTRAINT
	FK_cikkek_STCIKK2 FOREIGN KEY
	(
	CIKKCSOP2
	) REFERENCES dbo.stcikk2
	(
	cikk_szam
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT