/*
   2010. február 2.13:12:11
   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
CREATE TABLE dbo.Tmp_fizmodok
	(
	KOD char(1) NOT NULL,
	NEV varchar(20) NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.fizmodok)
	 EXEC('INSERT INTO dbo.Tmp_fizmodok (KOD, NEV)
		SELECT CONVERT(char(1), KOD), NEV FROM dbo.fizmodok WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.fizmodok
GO
EXECUTE sp_rename N'dbo.Tmp_fizmodok', N'fizmodok', 'OBJECT' 
GO
ALTER TABLE dbo.fizmodok ADD CONSTRAINT
	PK_fizmodok PRIMARY KEY CLUSTERED 
	(
	KOD
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
go

/*
   2010. február 5.14:58:09
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_galatea
   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
CREATE TABLE dbo.Tmp_stcikk2
	(
	cikk_szam char(18) NOT NULL,
	cikk_nev dbo.nev NOT NULL,
	kicsoda dbo.kicsoda NOT NULL,
	modositva dbo.datum_ora NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.stcikk2)
	 EXEC('INSERT INTO dbo.Tmp_stcikk2 (cikk_szam, cikk_nev, kicsoda, modositva)
		SELECT cikk_szam, CONVERT(varchar(50), cikk_nev), CONVERT(varchar(20), kicsoda), modositva FROM dbo.stcikk2 WITH (HOLDLOCK TABLOCKX)')
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
COMMIT
go


/*
   2010. február 5.15:03:17
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_galatea
   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.orszag ADD CONSTRAINT
	PK_orszag PRIMARY KEY CLUSTERED 
	(
	Kod
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
go