/*
   2012. április 13.18:00:53
   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.cikkek_kep
	DROP CONSTRAINT FK_cikkek_kep_cikkek
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_cikkek_kep
	(
	cikk_szam dbo.cikk_szam NOT NULL,
	file_nev varchar(255) NOT NULL,
	cikk_kep image NOT NULL
	)  ON [PRIMARY]
	 TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_cikkek_kep ADD CONSTRAINT
	DF_cikkek_kep_file_nev DEFAULT '' FOR file_nev
GO
IF EXISTS(SELECT * FROM dbo.cikkek_kep)
	 EXEC('INSERT INTO dbo.Tmp_cikkek_kep (cikk_szam, cikk_kep)
		SELECT cikk_szam, cikk_kep FROM dbo.cikkek_kep WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.cikkek_kep
GO
EXECUTE sp_rename N'dbo.Tmp_cikkek_kep', N'cikkek_kep', 'OBJECT' 
GO
ALTER TABLE dbo.cikkek_kep ADD CONSTRAINT
	PK_cikkek_kep 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.cikkek_kep ADD CONSTRAINT
	FK_cikkek_kep_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go




/*
   2012. április 13.17:59: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.cikkek_doc
	DROP CONSTRAINT FK_cikkek_doc_cikkek
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_cikkek_doc
	(
	cikk_szam dbo.cikk_szam NOT NULL,
	file_nev varchar(255) NOT NULL,
	cikk_doc image NOT NULL
	)  ON [PRIMARY]
	 TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_cikkek_doc ADD CONSTRAINT
	DF_cikkek_doc_file_nev DEFAULT '' FOR file_nev
GO
IF EXISTS(SELECT * FROM dbo.cikkek_doc)
	 EXEC('INSERT INTO dbo.Tmp_cikkek_doc (cikk_szam, cikk_doc)
		SELECT cikk_szam, cikk_doc FROM dbo.cikkek_doc WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.cikkek_doc
GO
EXECUTE sp_rename N'dbo.Tmp_cikkek_doc', N'cikkek_doc', 'OBJECT' 
GO
ALTER TABLE dbo.cikkek_doc ADD CONSTRAINT
	PK_cikkek_doc 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.cikkek_doc ADD CONSTRAINT
	FK_cikkek_doc_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go