/* 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.bevetf
	DROP CONSTRAINT FK_BEVETF_raktarak
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.bevetf
	DROP CONSTRAINT FK_BEVETF_BEVETJOG
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.bevetf
	DROP CONSTRAINT FK_BEVETF_BELEPES1
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_bevetf
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	hivszam varchar(50) NULL,
	RAKTAR_K dbo.kulcs NOT NULL,
	DATUM dbo.datum NOT NULL,
	BEVET_KOD dbo.kulcs NOT NULL,
	MEGJEGYZES dbo.megjegyzes NOT NULL,
	KICSODA dbo.kicsoda NULL,
	MODIDO dbo.datum_ora NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.bevetf)
	 EXEC('INSERT INTO dbo.Tmp_bevetf (BIZSZAM, RAKTAR_K, DATUM, BEVET_KOD, MEGJEGYZES, KICSODA, MODIDO)
		SELECT BIZSZAM, RAKTAR_K, DATUM, BEVET_KOD, MEGJEGYZES, KICSODA, MODIDO FROM dbo.bevetf WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.bevett
	DROP CONSTRAINT FK_BEVETT_BEVETF
GO
DROP TABLE dbo.bevetf
GO
EXECUTE sp_rename N'dbo.Tmp_bevetf', N'bevetf', 'OBJECT' 
GO
ALTER TABLE dbo.bevetf ADD CONSTRAINT
	PK_BEVETF PRIMARY KEY CLUSTERED 
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_BEVETF ON dbo.bevetf
	(
	DATUM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_BEVETF_1 ON dbo.bevetf
	(
	RAKTAR_K
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.bevetf ADD CONSTRAINT
	FK_BEVETF_BELEPES1 FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.bevetf ADD CONSTRAINT
	FK_BEVETF_BEVETJOG FOREIGN KEY
	(
	BEVET_KOD
	) REFERENCES dbo.bevetjog
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.bevetf ADD CONSTRAINT
	FK_BEVETF_raktarak FOREIGN KEY
	(
	RAKTAR_K
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.bevett ADD CONSTRAINT
	FK_BEVETT_BEVETF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.bevetf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT


/* 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.kivetf
	DROP CONSTRAINT FK_KIVETF_RAKTARAK
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.kivetf
	DROP CONSTRAINT FK_KIVETF_KIVETJOG
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.kivetf
	DROP CONSTRAINT FK_KIVETF_BELEPES1
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_kivetf
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	hivszam varchar(50) NULL,
	RAKTAR_K dbo.kulcs NOT NULL,
	DATUM dbo.datum NOT NULL,
	KIVET_KOD dbo.kulcs NOT NULL,
	MEGJEGYZES dbo.megjegyzes NOT NULL,
	KICSODA dbo.kicsoda NULL,
	MODIDO dbo.datum_ora NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.kivetf)
	 EXEC('INSERT INTO dbo.Tmp_kivetf (BIZSZAM, RAKTAR_K, DATUM, KIVET_KOD, MEGJEGYZES, KICSODA, MODIDO)
		SELECT BIZSZAM, RAKTAR_K, DATUM, KIVET_KOD, MEGJEGYZES, KICSODA, MODIDO FROM dbo.kivetf WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.kivett
	DROP CONSTRAINT FK_KIVETT_KIVETF
GO
DROP TABLE dbo.kivetf
GO
EXECUTE sp_rename N'dbo.Tmp_kivetf', N'kivetf', 'OBJECT' 
GO
ALTER TABLE dbo.kivetf ADD CONSTRAINT
	PK_KIVETF PRIMARY KEY CLUSTERED 
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_KIVETF ON dbo.kivetf
	(
	DATUM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_KIVETF_1 ON dbo.kivetf
	(
	KIVET_KOD
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_KIVETF_2 ON dbo.kivetf
	(
	RAKTAR_K
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.kivetf ADD CONSTRAINT
	FK_KIVETF_BELEPES1 FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.kivetf ADD CONSTRAINT
	FK_KIVETF_KIVETJOG FOREIGN KEY
	(
	KIVET_KOD
	) REFERENCES dbo.kivetjog
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.kivetf ADD CONSTRAINT
	FK_KIVETF_RAKTARAK FOREIGN KEY
	(
	RAKTAR_K
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.kivett ADD CONSTRAINT
	FK_KIVETT_KIVETF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.kivetf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT




/* 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.rmozgasf
	DROP CONSTRAINT FK_RMOZGASF_RAKTARAK
GO
ALTER TABLE dbo.rmozgasf
	DROP CONSTRAINT FK_RMOZGASF_RAKTARAK1
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.rmozgasf
	DROP CONSTRAINT FK_RMOZGASF_BELEPES
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_rmozgasf
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	hivszam varchar(50) NULL,
	FRAKTAR_K dbo.kulcs NOT NULL,
	CRAKTAR_K dbo.kulcs NOT NULL,
	DATUM dbo.datum NOT NULL,
	MEGJEGYZES dbo.megjegyzes NOT NULL,
	KICSODA dbo.kicsoda NOT NULL,
	modido dbo.datum_ora NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.rmozgasf)
	 EXEC('INSERT INTO dbo.Tmp_rmozgasf (BIZSZAM, FRAKTAR_K, CRAKTAR_K, DATUM, MEGJEGYZES, KICSODA, modido)
		SELECT BIZSZAM, FRAKTAR_K, CRAKTAR_K, DATUM, MEGJEGYZES, KICSODA, modido FROM dbo.rmozgasf WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.rmozgast
	DROP CONSTRAINT FK_RMOZGAST_RMOZGASF
GO
DROP TABLE dbo.rmozgasf
GO
EXECUTE sp_rename N'dbo.Tmp_rmozgasf', N'rmozgasf', 'OBJECT' 
GO
ALTER TABLE dbo.rmozgasf ADD CONSTRAINT
	PK_RMOZGASF PRIMARY KEY CLUSTERED 
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_RMOZGASF ON dbo.rmozgasf
	(
	DATUM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_RMOZGASF_1 ON dbo.rmozgasf
	(
	CRAKTAR_K
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_RMOZGASF_2 ON dbo.rmozgasf
	(
	FRAKTAR_K
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.rmozgasf ADD CONSTRAINT
	FK_RMOZGASF_BELEPES FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.rmozgasf ADD CONSTRAINT
	FK_RMOZGASF_RAKTARAK FOREIGN KEY
	(
	FRAKTAR_K
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.rmozgasf ADD CONSTRAINT
	FK_RMOZGASF_RAKTARAK1 FOREIGN KEY
	(
	CRAKTAR_K
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.rmozgast ADD CONSTRAINT
	FK_RMOZGAST_RMOZGASF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.rmozgasf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT