-- ellenőrizni a cikkek kapcsolatait, ha van akkortörölni kell a megmeradt kapcsolatokat!!!


-- ezt külön:

DROP TABLE dbo.cikkek
GO
EXECUTE sp_rename N'dbo.Tmp_cikkek', N'cikkek', 'OBJECT' 
GO


-- ezeket már egyben



BEGIN TRANSACTION
ALTER TABLE dbo.cikkek ADD CONSTRAINT
	PK_CIKKEK PRIMARY KEY CLUSTERED 
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_Cikkek_Cikk_Nev ON dbo.cikkek
	(
	CIKK_NEV
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_cikkek_cikkcsop2 ON dbo.cikkek
	(
	CIKKCSOP2
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_cikkek_GYARTO ON dbo.cikkek
	(
	GYARTO
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_cikkek_SZALLITO ON dbo.cikkek
	(
	SZALLITO
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.cikkek ADD CONSTRAINT
	FK_CIKKEK_BELEPES FOREIGN KEY
	(
	letrehozta
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.cikkek ADD CONSTRAINT
	FK_CIKKEK_BELEPES1 FOREIGN KEY
	(
	modositotta
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.cikkek ADD CONSTRAINT
	FK_CIKKEK_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.cikkek ADD CONSTRAINT
	FK_cikkek_STCIKK2 FOREIGN KEY
	(
	CIKKCSOP2
	) REFERENCES dbo.stcikk2
	(
	cikk_szam
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arak ADD CONSTRAINT
	FK_vevo_arak_CIKKEK FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_arak SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

BEGIN TRANSACTION
GO
ALTER TABLE dbo.kivett ADD CONSTRAINT
	FK_KIVETT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.kivett SET (LOCK_ESCALATION = TABLE)
GO
COMMIT





BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_csz ADD CONSTRAINT
	FK_vevo_csz_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_csz SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.keszlet ADD CONSTRAINT
	FK_KESZLET_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.keszlet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_akcio ADD CONSTRAINT
	FK_vevo_akcio_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_akcio SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_ido_szlat ADD CONSTRAINT
	FK_vevo_ido_szlat_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_ido_szlat SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.csomagt ADD CONSTRAINT
	FK_csomagt_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.csomagt SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_art ADD CONSTRAINT
	FK_SZAL_ART_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_art SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vonal ADD CONSTRAINT
	FK_VONAL_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vonal SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
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
ALTER TABLE dbo.cikkek_doc SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
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
ALTER TABLE dbo.cikkek_kep SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arajanlatt ADD CONSTRAINT
	FK_vevo_arajanlatt_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_arajanlatt SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.keszlet_negativ ADD CONSTRAINT
	FK_keszlet_negativ_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.keszlet_negativ SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_ar_lista ADD CONSTRAINT
	FK_vevo_art1_CIKKEK FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_ar_lista SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.foglalasok ADD CONSTRAINT
	FK_foglalasok_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.foglalasok SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.leertekeles ADD CONSTRAINT
	FK_leertekeles_ccikkek FOREIGN KEY
	(
	ccikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.leertekeles ADD CONSTRAINT
	FK_leertekeles_fcikkek FOREIGN KEY
	(
	fcikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.leertekeles SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.rmozgast ADD CONSTRAINT
	FK_RMOZGAST_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.rmozgast SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_akcio_hh ADD CONSTRAINT
	FK_vevo_akcio_hh_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_akcio_hh SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.leltar_felv ADD CONSTRAINT
	FK_leltar_felv_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.leltar_felv SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wrmozgast ADD CONSTRAINT
	FK_WRMOZGAST_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wrmozgast SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo._web_kosaruj ADD CONSTRAINT
	FK__web_kosaruj_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo._web_kosaruj SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo._web_kosar ADD CONSTRAINT
	FK__web_kosar_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo._web_kosar SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.hcimke_csz ADD CONSTRAINT
	FK_hcimke_csz_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.hcimke_csz SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.diszpo ADD CONSTRAINT
	FK_diszpo_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.diszpo SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.leltar ADD CONSTRAINT
	FK_leltar_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.leltar SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo._web_kedvencek ADD CONSTRAINT
	FK__web_kedvencek_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo._web_kedvencek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wkivett ADD CONSTRAINT
	FK_WKIVETT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wkivett SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.keszre2 ADD CONSTRAINT
	FK_keszre2_cikkek FOREIGN KEY
	(
	acikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.keszre2 SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_akcio_me ADD CONSTRAINT
	FK_vevo_akcio_me_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_akcio_me SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wwvevo_szlet
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NOT NULL,
	rendel_ssz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL,
	KICSODA dbo.kicsoda NOT NULL,
	sarzs varchar(50) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wwvevo_szlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wwvevo_szlet)
	 EXEC('INSERT INTO dbo.Tmp_wwvevo_szlet (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_ssz, rendel_tet, KICSODA, sarzs)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_ssz, rendel_tet, KICSODA, sarzs FROM dbo.wwvevo_szlet WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wwvevo_szlet
GO
EXECUTE sp_rename N'dbo.Tmp_wwvevo_szlet', N'wwvevo_szlet', 'OBJECT' 
GO
ALTER TABLE dbo.wwvevo_szlet ADD CONSTRAINT
	PK_wwvevo_szlet_1 PRIMARY KEY CLUSTERED 
	(
	TETEL,
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_WWVEVO_SZLET ON dbo.wwvevo_szlet
	(
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.wwvevo_szlet ADD CONSTRAINT
	FK_WWVEVO_SZLET_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wwvevo_szlet ADD CONSTRAINT
	FK_WWVEVO_SZLET_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.anyagszukseglet ADD CONSTRAINT
	FK_anyagszukseglet_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.anyagszukseglet ADD CONSTRAINT
	FK_anyagszukseglet_cikkek1 FOREIGN KEY
	(
	acikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.anyagszukseglet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wvevo_szlet
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NOT NULL,
	rendel_ssz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL,
	KICSODA dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wvevo_szlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wvevo_szlet)
	 EXEC('INSERT INTO dbo.Tmp_wvevo_szlet (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_ssz, rendel_tet, KICSODA)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_ssz, rendel_tet, KICSODA FROM dbo.wvevo_szlet WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wvevo_szlet
GO
EXECUTE sp_rename N'dbo.Tmp_wvevo_szlet', N'wvevo_szlet', 'OBJECT' 
GO
ALTER TABLE dbo.wvevo_szlet ADD CONSTRAINT
	PK_wvevo_szlet_1 PRIMARY KEY CLUSTERED 
	(
	TETEL,
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_WVEVO_SZLET ON dbo.wvevo_szlet
	(
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.wvevo_szlet ADD CONSTRAINT
	FK_WVEVO_SZLET_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_szlet ADD CONSTRAINT
	FK_WVEVO_SZLET_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_szlet ADD CONSTRAINT
	FK_WVEVO_SZLET_BELEPES FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wvevo_szlat
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	EDARAB dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NULL,
	akcio nchar(1) NULL,
	KICSODA dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wvevo_szlat SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wvevo_szlat)
	 EXEC('INSERT INTO dbo.Tmp_wvevo_szlat (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, EDARAB, DARAB, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, KICSODA)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, EDARAB, DARAB, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, KICSODA FROM dbo.wvevo_szlat WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wvevo_szlat
GO
EXECUTE sp_rename N'dbo.Tmp_wvevo_szlat', N'wvevo_szlat', 'OBJECT' 
GO
ALTER TABLE dbo.wvevo_szlat ADD CONSTRAINT
	PK_wvevo_szlat_1 PRIMARY KEY CLUSTERED 
	(
	TETEL,
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_WVEVO_SZLAT ON dbo.wvevo_szlat
	(
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.wvevo_szlat ADD CONSTRAINT
	FK_WVEVO_SZLAT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_szlat ADD CONSTRAINT
	FK_WVEVO_SZLAT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_szlat ADD CONSTRAINT
	FK_WVEVO_SZLAT_BELEPES FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wmerleg ADD CONSTRAINT
	FK_wmerleg_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wmerleg SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wszall_art ADD CONSTRAINT
	FK_wszall_art_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wszall_art SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wleertekelest ADD CONSTRAINT
	FK_wleertekelest_CCIKKEK FOREIGN KEY
	(
	CCIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wleertekelest ADD CONSTRAINT
	FK_wleertekelest_FCIKKEK FOREIGN KEY
	(
	FCIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wleertekelest SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_szlet
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NULL,
	rendel_bsz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_szlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_szlet)
	 EXEC('INSERT INTO dbo.Tmp_vevo_szlet (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_bsz, rendel_tet)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_bsz, rendel_tet FROM dbo.vevo_szlet WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.vevo_szlet_td
	DROP CONSTRAINT FK_vevo_szlet_td_vevo_szlet
GO
DROP TABLE dbo.vevo_szlet
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_szlet', N'vevo_szlet', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_szlet ADD CONSTRAINT
	PK_VEVO_SZLET PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_VEVO_SZLET ON dbo.vevo_szlet
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.vevo_szlet ADD CONSTRAINT
	FK_VEVO_SZLET_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlet ADD CONSTRAINT
	FK_VEVO_SZLET_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlet ADD CONSTRAINT
	FK_VEVO_SZLET_VEVO_SZLEF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_szlef
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlet_td ADD CONSTRAINT
	FK_vevo_szlet_td_vevo_szlet FOREIGN KEY
	(
	BIZSZAM,
	TETEL
	) REFERENCES dbo.vevo_szlet
	(
	BIZSZAM,
	TETEL
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlet_td SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wvevo_rent
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	cikk_nev dbo.cikk_nev NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EDARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	visszaig_dat dbo.datum NOT NULL,
	AKCIO char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	kicsoda dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wvevo_rent SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wvevo_rent)
	 EXEC('INSERT INTO dbo.Tmp_wvevo_rent (BIZSZAM, TETEL, CIKK_SZAM, cikk_nev, afa_kulcs, MENNY_EGYS, SZORZO, DARAB, EDARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO, kicsoda)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, cikk_nev, afa_kulcs, MENNY_EGYS, SZORZO, DARAB, EDARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO, kicsoda FROM dbo.wvevo_rent WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wvevo_rent
GO
EXECUTE sp_rename N'dbo.Tmp_wvevo_rent', N'wvevo_rent', 'OBJECT' 
GO
ALTER TABLE dbo.wvevo_rent ADD CONSTRAINT
	PK_wvevo_rent PRIMARY KEY CLUSTERED 
	(
	TETEL,
	kicsoda
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.wvevo_rent ADD CONSTRAINT
	FK_wvevo_rent_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_rent ADD CONSTRAINT
	FK_wvevo_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_rent ADD CONSTRAINT
	FK_wvevo_rent_belepes FOREIGN KEY
	(
	kicsoda
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wvevo_arajant
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NULL,
	KICSODA dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wvevo_arajant SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wvevo_arajant)
	 EXEC('INSERT INTO dbo.Tmp_wvevo_arajant (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, DARAB, EGYSEG_AR, kedvezmeny, megjegyzes, KICSODA)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, DARAB, EGYSEG_AR, kedvezmeny, megjegyzes, KICSODA FROM dbo.wvevo_arajant WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wvevo_arajant
GO
EXECUTE sp_rename N'dbo.Tmp_wvevo_arajant', N'wvevo_arajant', 'OBJECT' 
GO
ALTER TABLE dbo.wvevo_arajant ADD CONSTRAINT
	PK_wvevo_arajanlt PRIMARY KEY CLUSTERED 
	(
	TETEL,
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.wvevo_arajant ADD CONSTRAINT
	FK_WVEVO_ARAJANT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_arajant ADD CONSTRAINT
	FK_WVEVO_ARAJANT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_arajant ADD CONSTRAINT
	FK_WVEVO_ARAJANT_BELEPES FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_szlat
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_szlat SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_szlat)
	 EXEC('INSERT INTO dbo.Tmp_vevo_szlat (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio FROM dbo.vevo_szlat WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.vevo_szlat_td
	DROP CONSTRAINT FK_vevo_szlat_td_vevo_szlat
GO
DROP TABLE dbo.vevo_szlat
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_szlat', N'vevo_szlat', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_szlat ADD CONSTRAINT
	PK_VEVO_SZLAT PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_VEVO_SZLAT ON dbo.vevo_szlat
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.vevo_szlat ADD CONSTRAINT
	FK_VEVO_SZLAT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
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 ADD CONSTRAINT
	FK_VEVO_SZLAT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlat_td ADD CONSTRAINT
	FK_vevo_szlat_td_vevo_szlat FOREIGN KEY
	(
	BIZSZAM,
	TETEL
	) REFERENCES dbo.vevo_szlat
	(
	BIZSZAM,
	TETEL
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlat_td SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wszall_szlet
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	VCIKKSZAM dbo.kicsoda NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	rendel_bsz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL,
	KICSODA dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wszall_szlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wszall_szlet)
	 EXEC('INSERT INTO dbo.Tmp_wszall_szlet (BIZSZAM, TETEL, VCIKKSZAM, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, edarab, DARAB, EGYSEG_AR, kedvezmeny, rendel_bsz, rendel_tet, KICSODA)
		SELECT BIZSZAM, TETEL, VCIKKSZAM, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, edarab, DARAB, EGYSEG_AR, kedvezmeny, rendel_bsz, rendel_tet, KICSODA FROM dbo.wszall_szlet WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wszall_szlet
GO
EXECUTE sp_rename N'dbo.Tmp_wszall_szlet', N'wszall_szlet', 'OBJECT' 
GO
ALTER TABLE dbo.wszall_szlet ADD CONSTRAINT
	PK_wszall_szleto PRIMARY KEY CLUSTERED 
	(
	TETEL,
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.wszall_szlet ADD CONSTRAINT
	FK_wszall_szlet_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wszall_szlet ADD CONSTRAINT
	FK_wszall_szlet_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wszall_szlet ADD CONSTRAINT
	FK_wszall_szlet_belepes FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_pszlat
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_pszlat SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_pszlat)
	 EXEC('INSERT INTO dbo.Tmp_vevo_pszlat (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio FROM dbo.vevo_pszlat WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_pszlat
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_pszlat', N'vevo_pszlat', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_pszlat ADD CONSTRAINT
	PK_vevo_pszlat PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_pszlat ADD CONSTRAINT
	FK_vevo_pszlat_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_pszlat ADD CONSTRAINT
	FK_vevo_pszlat_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_pszlat ADD CONSTRAINT
	FK_vevo_pszlat_VEVO_PSZLAF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_pszlaf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szbiz_szlet
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO int NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	rendel_bsz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szbiz_szlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szbiz_szlet)
	 EXEC('INSERT INTO dbo.Tmp_szbiz_szlet (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, edarab, DARAB, rendel_bsz, rendel_tet)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, edarab, DARAB, rendel_bsz, rendel_tet FROM dbo.szbiz_szlet WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.szbiz_szlet
GO
EXECUTE sp_rename N'dbo.Tmp_szbiz_szlet', N'szbiz_szlet', 'OBJECT' 
GO
ALTER TABLE dbo.szbiz_szlet ADD CONSTRAINT
	PK_szall_szletb PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.szbiz_szlet ADD CONSTRAINT
	FK_szbiz_szlet_szbiz_szlef FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.szbiz_szlef
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szbiz_szlet ADD CONSTRAINT
	FK_szbiz_szlet_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szbiz_szlet ADD CONSTRAINT
	FK_szbiz_szlet_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_webvevo_rent
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	cikk_nev dbo.cikk_nev NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EDARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	visszaig_dat dbo.datum NOT NULL,
	AKCIO char(1) NOT NULL,
	vevo dbo.kulcs NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_webvevo_rent SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.webvevo_rent)
	 EXEC('INSERT INTO dbo.Tmp_webvevo_rent (BIZSZAM, TETEL, CIKK_SZAM, cikk_nev, afa_kulcs, MENNY_EGYS, SZORZO, DARAB, EDARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO, vevo)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, cikk_nev, afa_kulcs, MENNY_EGYS, SZORZO, DARAB, EDARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO, vevo FROM dbo.webvevo_rent WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.webvevo_rent
GO
EXECUTE sp_rename N'dbo.Tmp_webvevo_rent', N'webvevo_rent', 'OBJECT' 
GO
ALTER TABLE dbo.webvevo_rent ADD CONSTRAINT
	PK_webvevo_rent PRIMARY KEY CLUSTERED 
	(
	TETEL,
	vevo
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.webvevo_rent ADD CONSTRAINT
	FK_webvevo_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.webvevo_rent ADD CONSTRAINT
	FK_webvevo_rent_vevok FOREIGN KEY
	(
	vevo
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.webvevo_rent ADD CONSTRAINT
	FK_webvevo_rent_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szall_szlet
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO int NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	rendel_bsz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_szlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szall_szlet)
	 EXEC('INSERT INTO dbo.Tmp_szall_szlet (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, edarab, DARAB, rendel_bsz, rendel_tet)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, edarab, DARAB, rendel_bsz, rendel_tet FROM dbo.szall_szlet WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.koltseg_keszletre
	DROP CONSTRAINT FK_koltseg_keszletre_szall_szlet
GO
ALTER TABLE dbo.koltseg_keszletre
	DROP CONSTRAINT FK_koltseg_keszletre_szall_szlet1
GO
ALTER TABLE dbo.szall_szlet_td
	DROP CONSTRAINT FK_szall_szlet_td_szall_szlet
GO
DROP TABLE dbo.szall_szlet
GO
EXECUTE sp_rename N'dbo.Tmp_szall_szlet', N'szall_szlet', 'OBJECT' 
GO
ALTER TABLE dbo.szall_szlet ADD CONSTRAINT
	PK_szall_szlet PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_szall_szlet ON dbo.szall_szlet
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szall_szlet ADD CONSTRAINT
	FK_szall_szlet_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlet ADD CONSTRAINT
	FK_szall_szlet_szall_szlef FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.szall_szlef
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlet ADD CONSTRAINT
	FK_szall_szlet_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlet_td ADD CONSTRAINT
	FK_szall_szlet_td_szall_szlet FOREIGN KEY
	(
	BIZSZAM,
	TETEL
	) REFERENCES dbo.szall_szlet
	(
	BIZSZAM,
	TETEL
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlet_td SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.koltseg_keszletre ADD CONSTRAINT
	FK_koltseg_keszletre_cikkek FOREIGN KEY
	(
	kolt_cikk
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.koltseg_keszletre ADD CONSTRAINT
	FK_koltseg_keszletre_szall_szlet FOREIGN KEY
	(
	kolt_bizszam,
	kolt_tetel
	) REFERENCES dbo.szall_szlet
	(
	BIZSZAM,
	TETEL
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.koltseg_keszletre ADD CONSTRAINT
	FK_koltseg_keszletre_szall_szlet1 FOREIGN KEY
	(
	terh_bizszam,
	terh_tetel
	) REFERENCES dbo.szall_szlet
	(
	BIZSZAM,
	TETEL
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.koltseg_keszletre SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_rent
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO int NOT NULL,
	EDARAB dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	visszaig_dat dbo.datum NOT NULL,
	AKCIO char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_rent SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_rent)
	 EXEC('INSERT INTO dbo.Tmp_vevo_rent (BIZSZAM, TETEL, CIKK_SZAM, afa_kulcs, MENNY_EGYS, SZORZO, EDARAB, DARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, afa_kulcs, MENNY_EGYS, SZORZO, EDARAB, DARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO FROM dbo.vevo_rent WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_rent
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_rent', N'vevo_rent', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_rent ADD CONSTRAINT
	PK_vevo_rent PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_rent ADD CONSTRAINT
	FK_vevo_rent_vevo_renf FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_renf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_rent ADD CONSTRAINT
	FK_vevo_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wbevett
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	kicsoda dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wbevett SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wbevett)
	 EXEC('INSERT INTO dbo.Tmp_wbevett (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, EGYSEG_AR, DARAB, kicsoda)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, EGYSEG_AR, DARAB, kicsoda FROM dbo.wbevett WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wbevett
GO
EXECUTE sp_rename N'dbo.Tmp_wbevett', N'wbevett', 'OBJECT' 
GO
ALTER TABLE dbo.wbevett ADD CONSTRAINT
	PK_wbevett_1 PRIMARY KEY CLUSTERED 
	(
	TETEL,
	kicsoda
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.wbevett ADD CONSTRAINT
	FK_WBEVETT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wbevett ADD CONSTRAINT
	FK_WBEVETT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_bevett
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	DARAB dbo.mennyiseg NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_bevett SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.bevett)
	 EXEC('INSERT INTO dbo.Tmp_bevett (BIZSZAM, TETEL, CIKK_SZAM, AFA_KULCS, MENNY_EGYS, SZORZO, EGYSEG_AR, DARAB)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, AFA_KULCS, MENNY_EGYS, SZORZO, EGYSEG_AR, DARAB FROM dbo.bevett WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.bevett
GO
EXECUTE sp_rename N'dbo.Tmp_bevett', N'bevett', 'OBJECT' 
GO
ALTER TABLE dbo.bevett ADD CONSTRAINT
	PK_BEVETT PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_BEVETT ON dbo.bevett
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.bevett ADD CONSTRAINT
	FK_BEVETT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
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
ALTER TABLE dbo.bevett ADD CONSTRAINT
	FK_BEVETT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szall_szlat
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO int NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	rendel_bsz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_szlat SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szall_szlat)
	 EXEC('INSERT INTO dbo.Tmp_szall_szlat (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, edarab, DARAB, rendel_bsz, rendel_tet)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, edarab, DARAB, rendel_bsz, rendel_tet FROM dbo.szall_szlat WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.szall_szlat_td
	DROP CONSTRAINT FK_szall_szlat_td_szall_szlat
GO
DROP TABLE dbo.szall_szlat
GO
EXECUTE sp_rename N'dbo.Tmp_szall_szlat', N'szall_szlat', 'OBJECT' 
GO
ALTER TABLE dbo.szall_szlat ADD CONSTRAINT
	PK_szall_szlat PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_szall_szlat ON dbo.szall_szlat
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szall_szlat ADD CONSTRAINT
	FK_szall_szlat_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlat ADD CONSTRAINT
	FK_szall_szlat_szall_szlaf FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.szall_szlaf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlat ADD CONSTRAINT
	FK_szall_szlat_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlat_td ADD CONSTRAINT
	FK_szall_szlat_td_szall_szlat FOREIGN KEY
	(
	BIZSZAM,
	TETEL
	) REFERENCES dbo.szall_szlat
	(
	BIZSZAM,
	TETEL
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlat_td SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_arajant
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_arajant SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_arajant)
	 EXEC('INSERT INTO dbo.Tmp_vevo_arajant (BIZSZAM, TETEL, CIKK_SZAM, AFA_KULCS, MENNY_EGYS, SZORZO, darab, EGYSEG_AR, kedvezmeny, megjegyzes)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, AFA_KULCS, MENNY_EGYS, SZORZO, darab, EGYSEG_AR, kedvezmeny, megjegyzes FROM dbo.vevo_arajant WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_arajant
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_arajant', N'vevo_arajant', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_arajant ADD CONSTRAINT
	PK_VEVO_ARAJANLT PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_arajant ADD CONSTRAINT
	FK_vevo_arajant_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_arajant ADD CONSTRAINT
	FK_vevo_arajant_vevo_arajanf FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_arajanf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_arajant ADD CONSTRAINT
	FK_vevo_arajant_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szall_rent
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	VCIKKSZAM dbo.kicsoda NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO int NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	EDARAB dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_rent SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szall_rent)
	 EXEC('INSERT INTO dbo.Tmp_szall_rent (BIZSZAM, TETEL, CIKK_SZAM, VCIKKSZAM, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, EDARAB, DARAB)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, VCIKKSZAM, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, EDARAB, DARAB FROM dbo.szall_rent WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.szall_rent
GO
EXECUTE sp_rename N'dbo.Tmp_szall_rent', N'szall_rent', 'OBJECT' 
GO
ALTER TABLE dbo.szall_rent ADD CONSTRAINT
	PK_szall_rent PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_szall_rent ON dbo.szall_rent
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szall_rent ADD CONSTRAINT
	FK_szall_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_rent ADD CONSTRAINT
	FK_szall_rent_szall_renf FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.szall_renf
	(
	bizszam
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_rent ADD CONSTRAINT
	FK_szall_rent_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_wszall_szletm
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	VCIKKSZAM dbo.kicsoda NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	rendel_bsz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL,
	KICSODA dbo.kicsoda NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_wszall_szletm SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.wszall_szletm)
	 EXEC('INSERT INTO dbo.Tmp_wszall_szletm (BIZSZAM, TETEL, VCIKKSZAM, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, edarab, DARAB, EGYSEG_AR, kedvezmeny, rendel_bsz, rendel_tet, KICSODA)
		SELECT BIZSZAM, TETEL, VCIKKSZAM, CIKK_SZAM, CIKK_NEV, afa_kulcs, MENNY_EGYS, SZORZO, edarab, DARAB, EGYSEG_AR, kedvezmeny, rendel_bsz, rendel_tet, KICSODA FROM dbo.wszall_szletm WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.wszall_szletm
GO
EXECUTE sp_rename N'dbo.Tmp_wszall_szletm', N'wszall_szletm', 'OBJECT' 
GO
ALTER TABLE dbo.wszall_szletm ADD CONSTRAINT
	PK_wszall_szletm PRIMARY KEY CLUSTERED 
	(
	TETEL,
	KICSODA
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.wszall_szletm ADD CONSTRAINT
	FK_wszall_szletm_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wszall_szletm ADD CONSTRAINT
	FK_wszall_szletm_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wszall_szletm ADD CONSTRAINT
	FK_wszall_szletm_belepes FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go


/*
   2021. május 11., kedd11:17:58
   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_afa_kulcs
	(
	AFAKULCS dbo.afakulcs NOT NULL,
	afaertek numeric(5, 2) NOT NULL,
	engedelyez char(1) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_afa_kulcs SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.afa_kulcs)
	 EXEC('INSERT INTO dbo.Tmp_afa_kulcs (AFAKULCS, afaertek, engedelyez)
		SELECT AFAKULCS, afaertek, engedelyez FROM dbo.afa_kulcs WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.wwvevo_szlet
	DROP CONSTRAINT FK_WWVEVO_SZLET_afa_kulcs
GO
ALTER TABLE dbo.wvevo_szlet
	DROP CONSTRAINT FK_WVEVO_SZLET_afa_kulcs
GO
ALTER TABLE dbo.wvevo_szlat
	DROP CONSTRAINT FK_WVEVO_SZLAT_afa_kulcs
GO
ALTER TABLE dbo.vevo_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_afa_kulcs
GO
ALTER TABLE dbo.wvevo_rent
	DROP CONSTRAINT FK_wvevo_rent_afa_kulcs
GO
ALTER TABLE dbo.wvevo_arajant
	DROP CONSTRAINT FK_WVEVO_ARAJANT_afa_kulcs
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_afa_kulcs
GO
ALTER TABLE dbo.wszall_szlet
	DROP CONSTRAINT FK_wszall_szlet_afa_kulcs
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_afa_kulcs
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_afa_kulcs
GO
ALTER TABLE dbo.webvevo_rent
	DROP CONSTRAINT FK_webvevo_rent_afa_kulcs
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_afa_kulcs
GO
ALTER TABLE dbo.vevo_rent
	DROP CONSTRAINT FK_vevo_rent_afa_kulcs
GO
ALTER TABLE dbo.wbevett
	DROP CONSTRAINT FK_WBEVETT_afa_kulcs
GO
ALTER TABLE dbo.bevett
	DROP CONSTRAINT FK_BEVETT_afa_kulcs
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_afa_kulcs
GO
ALTER TABLE dbo.vevo_arajant
	DROP CONSTRAINT FK_vevo_arajant_afa_kulcs
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_afa_kulcs
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_CIKKEK_afa_kulcs
GO
ALTER TABLE dbo.wszall_szletm
	DROP CONSTRAINT FK_wszall_szletm_afa_kulcs
GO
DROP TABLE dbo.afa_kulcs
GO
EXECUTE sp_rename N'dbo.Tmp_afa_kulcs', N'afa_kulcs', 'OBJECT' 
GO
ALTER TABLE dbo.afa_kulcs ADD CONSTRAINT
	PK_afa_kulcs PRIMARY KEY CLUSTERED 
	(
	AFAKULCS
	) 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.wszall_szletm ADD CONSTRAINT
	FK_wszall_szletm_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wszall_szletm SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.cikkek ADD CONSTRAINT
	FK_CIKKEK_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_rent ADD CONSTRAINT
	FK_szall_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_rent SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arajant ADD CONSTRAINT
	FK_vevo_arajant_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_arajant SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlat ADD CONSTRAINT
	FK_szall_szlat_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlat SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.bevett ADD CONSTRAINT
	FK_BEVETT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.bevett SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wbevett ADD CONSTRAINT
	FK_WBEVETT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wbevett SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_rent ADD CONSTRAINT
	FK_vevo_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_rent SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlet ADD CONSTRAINT
	FK_szall_szlet_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_szlet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.webvevo_rent ADD CONSTRAINT
	FK_webvevo_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.webvevo_rent SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szbiz_szlet ADD CONSTRAINT
	FK_szbiz_szlet_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szbiz_szlet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_pszlat ADD CONSTRAINT
	FK_vevo_pszlat_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_pszlat SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wszall_szlet ADD CONSTRAINT
	FK_wszall_szlet_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wszall_szlet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlat ADD CONSTRAINT
	FK_VEVO_SZLAT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) 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.wvevo_arajant ADD CONSTRAINT
	FK_WVEVO_ARAJANT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_arajant SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wvevo_rent ADD CONSTRAINT
	FK_wvevo_rent_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_rent SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlet ADD CONSTRAINT
	FK_VEVO_SZLET_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_szlet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wvevo_szlat ADD CONSTRAINT
	FK_WVEVO_SZLAT_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_szlat SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wvevo_szlet ADD CONSTRAINT
	FK_WVEVO_SZLET_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wvevo_szlet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wwvevo_szlet ADD CONSTRAINT
	FK_WWVEVO_SZLET_afa_kulcs FOREIGN KEY
	(
	AFA_KULCS
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.wwvevo_szlet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go


/*
   2021. május 11., kedd11:00:58
   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._web_kosar
	DROP CONSTRAINT FK__web_kosar_cikkek
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp__web_kosar
	(
	kulcs int NOT NULL IDENTITY (1, 1),
	cikk_szam char(14) NOT NULL,
	cikk_nev varchar(80) NOT NULL,
	brutto_ar numeric(18, 2) NOT NULL,
	netto_ar numeric(18, 2) NOT NULL,
	kedvezmeny dbo.kedvezmeny NULL,
	darab numeric(18, 3) NOT NULL,
	menny_egys varchar(8) NOT NULL,
	afa_kulcs dbo.afakulcs NULL,
	gongyoleg_csz dbo.cikk_szam NULL,
	gongyoleg_ar dbo.egyseg_ar NULL,
	akcio varchar(1) NULL,
	vevo_kod int NOT NULL,
	session_id varchar(50) NOT NULL,
	kosarba_kerul dbo.datum_ora NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp__web_kosar SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp__web_kosar ON
GO
IF EXISTS(SELECT * FROM dbo._web_kosar)
	 EXEC('INSERT INTO dbo.Tmp__web_kosar (kulcs, cikk_szam, cikk_nev, brutto_ar, netto_ar, kedvezmeny, darab, menny_egys, afa_kulcs, gongyoleg_csz, gongyoleg_ar, akcio, vevo_kod, session_id, kosarba_kerul)
		SELECT kulcs, cikk_szam, cikk_nev, brutto_ar, netto_ar, kedvezmeny, darab, menny_egys, afa_kulcs, gongyoleg_csz, gongyoleg_ar, akcio, vevo_kod, session_id, kosarba_kerul FROM dbo._web_kosar WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp__web_kosar OFF
GO
DROP TABLE dbo._web_kosar
GO
EXECUTE sp_rename N'dbo.Tmp__web_kosar', N'_web_kosar', 'OBJECT' 
GO
ALTER TABLE dbo._web_kosar ADD CONSTRAINT
	PK__web_kosar PRIMARY KEY CLUSTERED 
	(
	kulcs
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX__web_kosar ON dbo._web_kosar
	(
	cikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX__web_kosar_1 ON dbo._web_kosar
	(
	session_id
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX__web_kosar_2 ON dbo._web_kosar
	(
	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__web_kosar_3 ON dbo._web_kosar
	(
	kosarba_kerul
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo._web_kosar ADD CONSTRAINT
	FK__web_kosar_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go


/*
   2021. május 11., kedd11:01:55
   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._web_kosaruj
	DROP CONSTRAINT FK__web_kosaruj_cikkek
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp__web_kosaruj
	(
	kulcs int NOT NULL IDENTITY (1, 1),
	cikk_szam char(14) NOT NULL,
	cikk_nev varchar(80) NOT NULL,
	brutto_ar numeric(18, 2) NOT NULL,
	netto_ar numeric(18, 2) NOT NULL,
	kedvezmeny dbo.kedvezmeny NULL,
	rend_darab numeric(18, 3) NULL,
	rend_csomag varchar(8) NULL,
	rend_egyseg int NULL,
	darab numeric(18, 3) NOT NULL,
	menny_egys varchar(8) NOT NULL,
	afa_kulcs dbo.afakulcs NULL,
	gongyoleg_csz dbo.cikk_szam NULL,
	gongyoleg_ar dbo.egyseg_ar NULL,
	ntgongyoleg_csz dbo.cikk_szam NULL,
	ntgongyoleg_ar dbo.egyseg_ar NULL,
	akcio varchar(1) NULL,
	vevo_kod int NOT NULL,
	session_id varchar(50) NOT NULL,
	kosarba_kerul dbo.datum_ora NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp__web_kosaruj SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp__web_kosaruj ON
GO
IF EXISTS(SELECT * FROM dbo._web_kosaruj)
	 EXEC('INSERT INTO dbo.Tmp__web_kosaruj (kulcs, cikk_szam, cikk_nev, brutto_ar, netto_ar, kedvezmeny, rend_darab, rend_csomag, rend_egyseg, darab, menny_egys, afa_kulcs, gongyoleg_csz, gongyoleg_ar, ntgongyoleg_csz, ntgongyoleg_ar, akcio, vevo_kod, session_id, kosarba_kerul)
		SELECT kulcs, cikk_szam, cikk_nev, brutto_ar, netto_ar, kedvezmeny, rend_darab, rend_csomag, rend_egyseg, darab, menny_egys, afa_kulcs, gongyoleg_csz, gongyoleg_ar, ntgongyoleg_csz, ntgongyoleg_ar, akcio, vevo_kod, session_id, kosarba_kerul FROM dbo._web_kosaruj WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp__web_kosaruj OFF
GO
DROP TABLE dbo._web_kosaruj
GO
EXECUTE sp_rename N'dbo.Tmp__web_kosaruj', N'_web_kosaruj', 'OBJECT' 
GO
ALTER TABLE dbo._web_kosaruj ADD CONSTRAINT
	PK__web_kosaruj PRIMARY KEY CLUSTERED 
	(
	kulcs
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo._web_kosaruj ADD CONSTRAINT
	FK__web_kosaruj_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go



/*
   2021. május 11., kedd11:23:22
   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.kivett
	DROP CONSTRAINT FK_KIVETT_CIKKEK
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.kivett
	DROP CONSTRAINT FK_KIVETT_KIVETF
GO
ALTER TABLE dbo.kivetf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_kivett
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	AFA_KULCS dbo.afakulcs NULL,
	EGYSEG_AR dbo.egyseg_ar NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_kivett SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.kivett)
	 EXEC('INSERT INTO dbo.Tmp_kivett (BIZSZAM, TETEL, CIKK_SZAM, MENNY_EGYS, SZORZO, DARAB, AFA_KULCS, EGYSEG_AR)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, MENNY_EGYS, SZORZO, DARAB, AFA_KULCS, EGYSEG_AR FROM dbo.kivett WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.kivett
GO
EXECUTE sp_rename N'dbo.Tmp_kivett', N'kivett', 'OBJECT' 
GO
ALTER TABLE dbo.kivett ADD CONSTRAINT
	PK_KIVETT PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_KIVETT ON dbo.kivett
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_KIVETT_Bizszam ON dbo.kivett
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
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
ALTER TABLE dbo.kivett ADD CONSTRAINT
	FK_KIVETT_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go



/*
   2021. május 11., kedd11:26:15
   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_nb_vevo_rent
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO int NOT NULL,
	EDARAB dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	visszaig_dat dbo.datum NOT NULL,
	AKCIO char(1) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_nb_vevo_rent SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.nb_vevo_rent)
	 EXEC('INSERT INTO dbo.Tmp_nb_vevo_rent (BIZSZAM, TETEL, CIKK_SZAM, afa_kulcs, MENNY_EGYS, SZORZO, EDARAB, DARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, afa_kulcs, MENNY_EGYS, SZORZO, EDARAB, DARAB, EGYSEG_AR, kedvezmeny, visszaig_dat, AKCIO FROM dbo.nb_vevo_rent WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.nb_vevo_rent
GO
EXECUTE sp_rename N'dbo.Tmp_nb_vevo_rent', N'nb_vevo_rent', 'OBJECT' 
GO
COMMIT
go




/*
   2021. május 11., kedd11:27:16
   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_nb_vevo_szlat
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_nb_vevo_szlat SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.nb_vevo_szlat)
	 EXEC('INSERT INTO dbo.Tmp_nb_vevo_szlat (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio FROM dbo.nb_vevo_szlat WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.nb_vevo_szlat
GO
EXECUTE sp_rename N'dbo.Tmp_nb_vevo_szlat', N'nb_vevo_szlat', 'OBJECT' 
GO
ALTER TABLE dbo.nb_vevo_szlat ADD CONSTRAINT
	PK_nb_VEVO_SZLAT PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_nb_vevo_szlat_bizszam ON dbo.nb_vevo_szlat
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT
go


/*
   2021. május 11., kedd11:27:52
   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_nb_vevo_szlet
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO dbo.szorzo NOT NULL,
	edarab dbo.mennyiseg NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NULL,
	rendel_bsz dbo.bizonylat_szam NOT NULL,
	rendel_tet dbo.bizonylat_tetel NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_nb_vevo_szlet SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.nb_vevo_szlet)
	 EXEC('INSERT INTO dbo.Tmp_nb_vevo_szlet (BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_bsz, rendel_tet)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, CIKK_NEV, AFA_KULCS, MENNY_EGYS, SZORZO, edarab, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio, rendel_bsz, rendel_tet FROM dbo.nb_vevo_szlet WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.nb_vevo_szlet
GO
EXECUTE sp_rename N'dbo.Tmp_nb_vevo_szlet', N'nb_vevo_szlet', 'OBJECT' 
GO
ALTER TABLE dbo.nb_vevo_szlet ADD CONSTRAINT
	PK_nb_VEVO_SZLET PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_nb_vevo_szlet_Bizszam ON dbo.nb_vevo_szlet
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT
go


/*
   2021. május 11., kedd11:30:21
   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_szall_rent_torol
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	VCIKKSZAM dbo.kicsoda NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	SZORZO int NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	EDARAB dbo.mennyiseg NOT NULL,
	DARAB dbo.mennyiseg NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_rent_torol SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szall_rent_torol)
	 EXEC('INSERT INTO dbo.Tmp_szall_rent_torol (BIZSZAM, TETEL, CIKK_SZAM, VCIKKSZAM, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, EDARAB, DARAB)
		SELECT BIZSZAM, TETEL, CIKK_SZAM, VCIKKSZAM, afa_kulcs, MENNY_EGYS, SZORZO, EGYSEG_AR, kedvezmeny, EDARAB, DARAB FROM dbo.szall_rent_torol WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.szall_rent_torol
GO
EXECUTE sp_rename N'dbo.Tmp_szall_rent_torol', N'szall_rent_torol', 'OBJECT' 
GO
COMMIT
go



/*
   2021. május 11., kedd11:31:16
   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_szall_szla_afa
	(
	bizszam dbo.bizonylat_szam NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	netto decimal(18, 2) NOT NULL,
	afa decimal(18, 2) NOT NULL,
	brutto decimal(18, 2) NOT NULL,
	fizetendo decimal(18, 2) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_szla_afa SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szall_szla_afa)
	 EXEC('INSERT INTO dbo.Tmp_szall_szla_afa (bizszam, afa_kulcs, netto, afa, brutto, fizetendo)
		SELECT bizszam, afa_kulcs, netto, afa, brutto, fizetendo FROM dbo.szall_szla_afa WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.szall_szla_afa
GO
EXECUTE sp_rename N'dbo.Tmp_szall_szla_afa', N'szall_szla_afa', 'OBJECT' 
GO
ALTER TABLE dbo.szall_szla_afa ADD CONSTRAINT
	PK_szall_szla_afa PRIMARY KEY CLUSTERED 
	(
	bizszam,
	afa_kulcs
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
go



/*
   2021. május 11., kedd11:33:57
   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_arajanlatt
	DROP CONSTRAINT FK_vevo_arajanlatt_vevo_arajanf
GO
ALTER TABLE dbo.vevo_arajanlatf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arajanlatt
	DROP CONSTRAINT FK_vevo_arajanlatt_cikk_tipusok
GO
ALTER TABLE dbo.cikk_tipusok SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arajanlatt
	DROP CONSTRAINT FK_vevo_arajanlatt_cikkek
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_arajanlatt
	(
	bizszam dbo.bizonylat_szam NOT NULL,
	tetel dbo.bizonylat_tetel NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	cikk_tipus int NOT NULL,
	mennyiseg dbo.mennyiseg NOT NULL,
	belfoldi_ar dbo.egyseg_ar NOT NULL,
	belfoldi_penznem dbo.penznem NOT NULL,
	belfoldi_szallito dbo.kulcs NOT NULL,
	belfoldi_keszlet dbo.mennyiseg NOT NULL,
	belfoldi_szallitas_nap int NOT NULL,
	kozbesz_ar dbo.egyseg_ar NOT NULL,
	beszerzesi_bizszam dbo.bizonylat_szam NULL,
	beszerzesi_tetel dbo.bizonylat_tetel NULL,
	beszerzesi_ar dbo.egyseg_ar NOT NULL,
	beszerzesi_penznem dbo.penznem NOT NULL,
	beszerzesi_szallito dbo.kulcs NOT NULL,
	beszerzesi_keszlet dbo.mennyiseg NOT NULL,
	beszerzesi_kurzus dbo.kurzus NOT NULL,
	beszerzesi_szallitas_nap int NOT NULL,
	kiajanlott_ar dbo.egyseg_ar NOT NULL,
	kiajanlott_szallitas_nap int NOT NULL,
	afa_kulcs dbo.afakulcs NOT NULL,
	menny_egys dbo.menny_egyseg NOT NULL,
	szorzo dbo.szorzo NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	garancia varchar(20) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_arajanlatt SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_arajanlatt)
	 EXEC('INSERT INTO dbo.Tmp_vevo_arajanlatt (bizszam, tetel, cikk_szam, cikk_tipus, mennyiseg, belfoldi_ar, belfoldi_penznem, belfoldi_szallito, belfoldi_keszlet, belfoldi_szallitas_nap, kozbesz_ar, beszerzesi_bizszam, beszerzesi_tetel, beszerzesi_ar, beszerzesi_penznem, beszerzesi_szallito, beszerzesi_keszlet, beszerzesi_kurzus, beszerzesi_szallitas_nap, kiajanlott_ar, kiajanlott_szallitas_nap, afa_kulcs, menny_egys, szorzo, kedvezmeny, megjegyzes, garancia)
		SELECT bizszam, tetel, cikk_szam, cikk_tipus, mennyiseg, belfoldi_ar, belfoldi_penznem, belfoldi_szallito, belfoldi_keszlet, belfoldi_szallitas_nap, kozbesz_ar, beszerzesi_bizszam, beszerzesi_tetel, beszerzesi_ar, beszerzesi_penznem, beszerzesi_szallito, beszerzesi_keszlet, beszerzesi_kurzus, beszerzesi_szallitas_nap, kiajanlott_ar, kiajanlott_szallitas_nap, afa_kulcs, menny_egys, szorzo, kedvezmeny, megjegyzes, garancia FROM dbo.vevo_arajanlatt WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_arajanlatt
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_arajanlatt', N'vevo_arajanlatt', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_arajanlatt ADD CONSTRAINT
	PK_vevo_arajanlatt PRIMARY KEY CLUSTERED 
	(
	bizszam,
	tetel
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_arajanlatt ADD CONSTRAINT
	FK_vevo_arajanlatt_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_arajanlatt ADD CONSTRAINT
	FK_vevo_arajanlatt_cikk_tipusok FOREIGN KEY
	(
	cikk_tipus
	) REFERENCES dbo.cikk_tipusok
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_arajanlatt ADD CONSTRAINT
	FK_vevo_arajanlatt_vevo_arajanf FOREIGN KEY
	(
	bizszam
	) REFERENCES dbo.vevo_arajanlatf
	(
	bizszam
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go



/*
   2021. május 11., kedd12:34:09
   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_vevo_szlat_nyomt
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	TETEL dbo.bizonylat_tetel NOT NULL,
	VTSZ varchar(10) NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	CIKK_NEV_ANG dbo.cikk_nev NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	MENNY_EGYS_ANG dbo.menny_egyseg NOT NULL,
	szorzo int NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	akcio char(1) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_szlat_nyomt SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_szlat_nyomt)
	 EXEC('INSERT INTO dbo.Tmp_vevo_szlat_nyomt (BIZSZAM, TETEL, VTSZ, CIKK_SZAM, CIKK_NEV, CIKK_NEV_ANG, AFA_KULCS, MENNY_EGYS, MENNY_EGYS_ANG, szorzo, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio)
		SELECT BIZSZAM, TETEL, VTSZ, CIKK_SZAM, CIKK_NEV, CIKK_NEV_ANG, AFA_KULCS, MENNY_EGYS, MENNY_EGYS_ANG, szorzo, darab, EGYSEG_AR, kedvezmeny, megjegyzes, akcio FROM dbo.vevo_szlat_nyomt WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_szlat_nyomt
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_szlat_nyomt', N'vevo_szlat_nyomt', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_szlat_nyomt ADD CONSTRAINT
	PK_vevo_szlat_nyomt PRIMARY KEY CLUSTERED 
	(
	BIZSZAM,
	TETEL
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_vevo_szlat_nyomt ON dbo.vevo_szlat_nyomt
	(
	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_szlat_nyomt_1 ON dbo.vevo_szlat_nyomt
	(
	CIKK_SZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT
go


/*
   2021. május 12., szerda9:26:26
   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_VEVO_REND_TERM_AR_2014
	(
	CIKK_SZAM nvarchar(14) NULL,
	CIKK_NEV nvarchar(45) NULL,
	MENNY_EGYS nvarchar(8) NULL,
	VTSZ nvarchar(14) NULL,
	AFA_KULCS dbo.afakulcs NULL,
	CIKKCSOP2 nvarchar(18) NULL,
	ZSUGOR_DB float(53) NULL,
	DB_KART float(53) NULL,
	KART_SOR float(53) NULL,
	KART_RAKL float(53) NULL,
	TGON nvarchar(14) NULL,
	NTGON nvarchar(14) NULL,
	TGONSZOR float(53) NULL,
	NTGONSZOR float(53) NULL,
	BESZERZ_AR float(53) NULL,
	BESZERZ_BR_AR float(53) NULL,
	EGYSEG_AR float(53) NULL,
	BRUTTO_AR float(53) NULL,
	AKCIO nvarchar(1) NULL,
	AKCIOS_AR float(53) NULL,
	FELT_DB float(53) NULL,
	AJAN_CSZ nvarchar(14) NULL,
	KESZLET float(53) NULL,
	NORM_ME nvarchar(8) NULL,
	NORM_SZORZ float(53) NULL,
	SZALLITO dbo.kulcs NULL,
	GONGYOLEG char(1) NULL,
	gyarto dbo.kulcs NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_VEVO_REND_TERM_AR_2014 SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.VEVO_REND_TERM_AR_2014)
	 EXEC('INSERT INTO dbo.Tmp_VEVO_REND_TERM_AR_2014 (CIKK_SZAM, CIKK_NEV, MENNY_EGYS, VTSZ, AFA_KULCS, CIKKCSOP2, ZSUGOR_DB, DB_KART, KART_SOR, KART_RAKL, TGON, NTGON, TGONSZOR, NTGONSZOR, BESZERZ_AR, BESZERZ_BR_AR, EGYSEG_AR, BRUTTO_AR, AKCIO, AKCIOS_AR, FELT_DB, AJAN_CSZ, KESZLET, NORM_ME, NORM_SZORZ, SZALLITO, GONGYOLEG, gyarto)
		SELECT CIKK_SZAM, CIKK_NEV, MENNY_EGYS, VTSZ, CONVERT(varchar(15), AFA_KULCS), CIKKCSOP2, ZSUGOR_DB, DB_KART, KART_SOR, KART_RAKL, TGON, NTGON, TGONSZOR, NTGONSZOR, BESZERZ_AR, BESZERZ_BR_AR, EGYSEG_AR, BRUTTO_AR, AKCIO, AKCIOS_AR, FELT_DB, AJAN_CSZ, KESZLET, NORM_ME, NORM_SZORZ, SZALLITO, GONGYOLEG, gyarto FROM dbo.VEVO_REND_TERM_AR_2014 WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.VEVO_REND_TERM_AR_2014
GO
EXECUTE sp_rename N'dbo.Tmp_VEVO_REND_TERM_AR_2014', N'VEVO_REND_TERM_AR_2014', 'OBJECT' 
GO
COMMIT
go





INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'AAM', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'ÁTK', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'EAM', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'EUFAD37', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'EUFADE', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'HO', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'KBAET', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'NAM', CAST(0.00 AS Numeric(5, 2)), N'1')
GO
INSERT [dbo].[afa_kulcs] ([AFAKULCS], [afaertek], [engedelyez]) VALUES (N'TAM', CAST(0.00 AS Numeric(5, 2)), N'1')
GO

exec tolt_vcikk_arak
go

exec tolt_wcikk_arak_web
go




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