/*
   2010. március 29.17:51:29
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_karacs
   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_vevok
	(
	VEVO_KOD dbo.kulcs NOT NULL IDENTITY (1, 1),
	VEVO_NEV dbo.nev NOT NULL,
	IRANYITO dbo.nev NOT NULL,
	VAROS dbo.nev NOT NULL,
	orszag char(3) NOT NULL,
	CIM dbo.nev NOT NULL,
	TELEFON dbo.nev NOT NULL,
	FAX dbo.nev NOT NULL,
	KAPCSOLAT dbo.nev NOT NULL,
	EMAIL dbo.nev NOT NULL,
	ADOSZAM dbo.nev NOT NULL,
	eu_adoszam dbo.nev NULL,
	BANK dbo.nev NOT NULL,
	JOVEDEKI dbo.nev NOT NULL,
	vevo_arcsoport dbo.kulcs NOT NULL,
	vevo_akc_csoport dbo.kulcs NULL,
	KEDVEZMENY dbo.kedvezmeny NOT NULL,
	FIZMOD char(1) NOT NULL,
	FIZHAT int NOT NULL,
	vevo_csoport dbo.kulcs NOT NULL,
	vevo_lanc dbo.kulcs NOT NULL,
	vevo_cegjelleg dbo.kulcs NOT NULL,
	vevo_terulet dbo.kulcs NOT NULL,
	vevo_cszcsoport dbo.kulcs NOT NULL,
	Viszontelado char(1) NULL,
	sajat_bolt char(1) NULL,
	KICSODA dbo.kicsoda NOT NULL,
	MODOSITVA dbo.datum_ora NOT NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_vevok ON
GO
IF EXISTS(SELECT * FROM dbo.vevok)
	 EXEC('INSERT INTO dbo.Tmp_vevok (VEVO_KOD, VEVO_NEV, IRANYITO, VAROS, orszag, CIM, TELEFON, FAX, KAPCSOLAT, EMAIL, ADOSZAM, eu_adoszam, BANK, JOVEDEKI, vevo_arcsoport, vevo_akc_csoport, KEDVEZMENY, FIZMOD, FIZHAT, vevo_csoport, vevo_lanc, vevo_cegjelleg, vevo_terulet, vevo_cszcsoport, Viszontelado, KICSODA, MODOSITVA)
		SELECT VEVO_KOD, VEVO_NEV, IRANYITO, VAROS, orszag, CIM, TELEFON, FAX, KAPCSOLAT, EMAIL, ADOSZAM, eu_adoszam, BANK, JOVEDEKI, vevo_arcsoport, vevo_akc_csoport, KEDVEZMENY, FIZMOD, FIZHAT, vevo_csoport, vevo_lanc, vevo_cegjelleg, vevo_terulet, vevo_cszcsoport, Viszontelado, KICSODA, MODOSITVA FROM dbo.vevok WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_vevok OFF
GO
ALTER TABLE dbo.vevo_szlaf
	DROP CONSTRAINT FK_VEVO_SZLAF_VEVOK
GO
ALTER TABLE dbo.vevo_szlef
	DROP CONSTRAINT FK_VEVO_SZLEF_VEVOK
GO
ALTER TABLE dbo.vevo_szall
	DROP CONSTRAINT FK_vevo_szall_vevok
GO
ALTER TABLE dbo.vevo_pszlaf
	DROP CONSTRAINT FK_vevo_pszlaf_VEVOK
GO
ALTER TABLE dbo.vevo_uzenet
	DROP CONSTRAINT FK_vevo_uzenet_vevok
GO
ALTER TABLE dbo.vevo_bank
	DROP CONSTRAINT FK_vevo_bank_VEVOK
GO
ALTER TABLE dbo.vevo_tel
	DROP CONSTRAINT FK_VEVO_TEL_VEVOK
GO
ALTER TABLE dbo.vevo_ido_szlat
	DROP CONSTRAINT FK_vevo_ido_szlat_vevok
GO
ALTER TABLE dbo.vevo_renf
	DROP CONSTRAINT FK_vevo_renf_vevok
GO
ALTER TABLE dbo.vevo_arajanlatf
	DROP CONSTRAINT FK_vevo_arajanlatf_vevok
GO
ALTER TABLE dbo.vevo_arajanf
	DROP CONSTRAINT FK_vevo_arajanf_vevok
GO
ALTER TABLE dbo.foglalasok
	DROP CONSTRAINT FK_foglalasok_vevok
GO
DROP TABLE dbo.vevok
GO
EXECUTE sp_rename N'dbo.Tmp_vevok', N'vevok', 'OBJECT' 
GO
ALTER TABLE dbo.vevok ADD CONSTRAINT
	PK_VEVOK PRIMARY KEY CLUSTERED 
	(
	VEVO_KOD
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_vevok_Vevo_Nev ON dbo.vevok
	(
	VEVO_NEV
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.foglalasok ADD CONSTRAINT
	FK_foglalasok_vevok FOREIGN KEY
	(
	vevo
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arajanf ADD CONSTRAINT
	FK_vevo_arajanf_vevok FOREIGN KEY
	(
	VEVO
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arajanlatf ADD CONSTRAINT
	FK_vevo_arajanlatf_vevok FOREIGN KEY
	(
	vevo_kod
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_renf ADD CONSTRAINT
	FK_vevo_renf_vevok FOREIGN KEY
	(
	VEVO
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_ido_szlat ADD CONSTRAINT
	FK_vevo_ido_szlat_vevok FOREIGN KEY
	(
	vevo_kod
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_tel ADD CONSTRAINT
	FK_VEVO_TEL_VEVOK FOREIGN KEY
	(
	VEVO_KOD
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_bank ADD CONSTRAINT
	FK_vevo_bank_VEVOK FOREIGN KEY
	(
	vevo_kod
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_uzenet ADD CONSTRAINT
	FK_vevo_uzenet_vevok FOREIGN KEY
	(
	vevo_kod
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_pszlaf ADD CONSTRAINT
	FK_vevo_pszlaf_VEVOK FOREIGN KEY
	(
	VEVO
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szall ADD CONSTRAINT
	FK_vevo_szall_vevok FOREIGN KEY
	(
	vevo_kod
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlef ADD CONSTRAINT
	FK_VEVO_SZLEF_VEVOK FOREIGN KEY
	(
	VEVO
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlaf ADD CONSTRAINT
	FK_VEVO_SZLAF_VEVOK FOREIGN KEY
	(
	VEVO
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
 
BEGIN TRANSACTION
GO
update vevok set sajat_bolt='0'
	
GO
COMMIT