/*
   2017. december 18., hétfő14:43:48
   User: sa
   Server: 192.168.58.1,1450
   Database: _f_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_regisztral
	(
	felhasznalo varchar(55) NOT NULL,
	varos varchar(50) NULL,
	cim varchar(50) NULL,
	iranyito varchar(20) NULL,
	telefon varchar(20) NULL,
	fax varchar(20) NULL,
	adoszam varchar(50) NULL,
	bank varchar(50) NULL,
	rovidnev varchar(10) NOT NULL,
	dijszint varchar(1) NOT NULL,
	ellenorzo varchar(20) NOT NULL,
	euadoszam varchar(50) NULL,
	mukodesi varchar(50) NULL,
	jovedeki varchar(50) NULL,
	kerulet varchar(50) NULL,
	kozterulet_jellege varchar(50) NULL,
	hazszam varchar(50) NULL,
	epulet varchar(50) NULL,
	lepcsohaz varchar(50) NULL,
	szint varchar(50) NULL,
	ajto varchar(50) NULL,
	bank1 varchar(50) NULL,
	ev_nev varchar(50) NULL,
	ev_szam varchar(50) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_regisztral SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.regisztral)
	 EXEC('INSERT INTO dbo.Tmp_regisztral (felhasznalo, varos, cim, iranyito, telefon, fax, adoszam, bank, rovidnev, dijszint, ellenorzo, euadoszam, mukodesi, jovedeki, kerulet, kozterulet_jellege, hazszam, epulet, lepcsohaz, szint, ajto, bank1, ev_nev, ev_szam)
		SELECT felhasznalo, varos, cim, iranyito, telefon, fax, adoszam, bank, rovidnev, dijszint, ellenorzo, euadoszam, mukodesi, jovedeki, kerulet, kozterulet_jellege, hazszam, epulet, lepcsohaz, szint, ajto, bank1, ev_nev, ev_szam FROM dbo.regisztral WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.regisztral
GO
EXECUTE sp_rename N'dbo.Tmp_regisztral', N'regisztral', 'OBJECT' 
GO
COMMIT
go


/*
   2017. november 30., csütörtök13:08:34
   User: sa
   Server: 192.168.58.1,1450
   Database: _f_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.vevo_szlaf
	DROP CONSTRAINT FK_VEVO_SZLAF_deviza
GO
ALTER TABLE dbo.deviza SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlaf
	DROP CONSTRAINT FK_VEVO_SZLAF_BELEPES
GO
ALTER TABLE dbo.belepes SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlaf
	DROP CONSTRAINT FK_VEVO_SZLAF_VEVOK
GO
ALTER TABLE dbo.vevok SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_szlaf
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	VEVO dbo.kulcs NOT NULL,
	VEVO_NEV dbo.nev NULL,
	TELJ_DATUM dbo.datum NOT NULL,
	SZLA_DATUM dbo.datum NOT NULL,
	FIZ_MODJA char(1) NOT NULL,
	FIZ_ESED dbo.datum NOT NULL,
	penznem dbo.penznem NOT NULL,
	kurzus dbo.kurzus NOT NULL,
	afamentes bit NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	TIPUS dbo.kulcs NOT NULL,
	UZLETKOTO dbo.kulcs NOT NULL,
	MEGJEGYZES dbo.megjegyzes NOT NULL,
	TOROLT char(1) NOT NULL,
	TORLO char(1) NOT NULL,
	TOR_SSZ dbo.bizonylat_szam NOT NULL,
	VISSZARU char(1) NOT NULL,
	penzugyi char(1) NOT NULL,
	KOTEG_SZ int NOT NULL,
	KICSODA dbo.kicsoda NOT NULL,
	MODOSITVA dbo.datum_ora NOT NULL,
	peldany int NULL,
	Eszamla char(1) NULL,
	iranyito dbo.nev NULL,
	varos dbo.nev NULL,
	cim dbo.nev NULL,
	iso char(2) NULL,
	adoszam dbo.nev NULL,
	kerulet varchar(50) NULL,
	kozterulet_jellege varchar(50) NULL,
	hazszam varchar(50) NULL,
	epulet varchar(50) NULL,
	lepcsohaz varchar(50) NULL,
	szint varchar(50) NULL,
	ajto varchar(50) NULL,
	kadoszam varchar(50) NULL,
	knev varchar(55) NULL,
	kiranyito varchar(50) NULL,
	kvaros varchar(50) NULL,
	kkerulet varchar(50) NULL,
	kkozterulet varchar(50) NULL,
	kkozterulet_jellege varchar(50) NULL,
	khazszam varchar(50) NULL,
	kepulet varchar(50) NULL,
	klepcsohaz varchar(50) NULL,
	kszint varchar(50) NULL,
	kajto varchar(50) NULL,
	ev_nev varchar(50) NULL,
	ev_szam varchar(50) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_szlaf SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_szlaf)
	 EXEC('INSERT INTO dbo.Tmp_vevo_szlaf (BIZSZAM, VEVO, VEVO_NEV, TELJ_DATUM, SZLA_DATUM, FIZ_MODJA, FIZ_ESED, penznem, kurzus, afamentes, kedvezmeny, TIPUS, UZLETKOTO, MEGJEGYZES, TOROLT, TORLO, TOR_SSZ, VISSZARU, penzugyi, KOTEG_SZ, KICSODA, MODOSITVA, peldany, Eszamla, iranyito, varos, cim, iso, adoszam, kerulet, kozterulet_jellege, hazszam, epulet, lepcsohaz, szint, ajto, kadoszam, knev, kiranyito, kvaros, kkerulet, kkozterulet, kkozterulet_jellege, khazszam, kepulet, klepcsohaz, kszint, kajto, ev_nev, ev_szam)
		SELECT BIZSZAM, VEVO, VEVO_NEV, TELJ_DATUM, SZLA_DATUM, FIZ_MODJA, FIZ_ESED, penznem, kurzus, afamentes, kedvezmeny, TIPUS, UZLETKOTO, MEGJEGYZES, TOROLT, TORLO, TOR_SSZ, VISSZARU, penzugyi, KOTEG_SZ, KICSODA, MODOSITVA, peldany, Eszamla, iranyito, varos, cim, iso, adoszam, kerulet, kozterulet_jellege, hazszam, epulet, lepcsohaz, szint, ajto, kadoszam, knev, kiranyito, kvaros, kkerulet, kkozterulet, kkozterulet_jellege, khazszam, kepulet, klepcsohaz, kszint, kajto, ev_nev, ev_szam FROM dbo.vevo_szlaf WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.vevo_szlaf_export
	DROP CONSTRAINT FK_vevo_szlaf_export_vevo_szlaf
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_VEVO_SZLAF
GO
DROP TABLE dbo.vevo_szlaf
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_szlaf', N'vevo_szlaf', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_szlaf ADD CONSTRAINT
	PK_VEVO_SZLAF 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_VEVO_SZLAF ON dbo.vevo_szlaf
	(
	VEVO
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_VEVO_SZLAF_1 ON dbo.vevo_szlaf
	(
	SZLA_DATUM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_vevo_szlaf_2 ON dbo.vevo_szlaf
	(
	TELJ_DATUM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_vevo_szlaf_3 ON dbo.vevo_szlaf
	(
	FIZ_MODJA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
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
ALTER TABLE dbo.vevo_szlaf ADD CONSTRAINT
	FK_VEVO_SZLAF_BELEPES FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlaf ADD CONSTRAINT
	FK_VEVO_SZLAF_deviza FOREIGN KEY
	(
	penznem
	) REFERENCES dbo.deviza
	(
	penznem
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlat ADD CONSTRAINT
	FK_VEVO_SZLAT_VEVO_SZLAF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_szlaf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlat SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlaf_export ADD CONSTRAINT
	FK_vevo_szlaf_export_vevo_szlaf FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_szlaf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlaf_export SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go



insert into verzio values('upg','Ver. 2.48', dbo.mygetdatetime())
go