/****** Object:  UserDefinedDataType [dbo].[afakulcs]    Script Date: 2021. 05. 12. 14:55:25 ******/
CREATE TYPE [dbo].[afakulcs] FROM [varchar](15) NOT NULL
GO


/*
   2021. május 11., kedd11:15:19
   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.cikkek
	DROP CONSTRAINT FK_cikkek_STCIKK2
GO
ALTER TABLE dbo.stcikk2 SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_VEVO_SZLEF
GO
ALTER TABLE dbo.vevo_szlef SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_VEVO_SZLAF
GO
ALTER TABLE dbo.vevo_szlaf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_VEVO_PSZLAF
GO
ALTER TABLE dbo.vevo_pszlaf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_szbiz_szlef
GO
ALTER TABLE dbo.szbiz_szlef SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.webvevo_rent
	DROP CONSTRAINT FK_webvevo_rent_vevok
GO
ALTER TABLE dbo.vevok SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_szall_szlef
GO
ALTER TABLE dbo.szall_szlef SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_rent
	DROP CONSTRAINT FK_vevo_rent_vevo_renf
GO
ALTER TABLE dbo.vevo_renf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.bevett
	DROP CONSTRAINT FK_BEVETT_BEVETF
GO
ALTER TABLE dbo.bevetf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_szall_szlaf
GO
ALTER TABLE dbo.szall_szlaf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_arajant
	DROP CONSTRAINT FK_vevo_arajant_vevo_arajanf
GO
ALTER TABLE dbo.vevo_arajanf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_szall_renf
GO
ALTER TABLE dbo.szall_renf SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.wszall_szletm
	DROP CONSTRAINT FK_wszall_szletm_belepes
GO
ALTER TABLE dbo.wszall_szlet
	DROP CONSTRAINT FK_wszall_szlet_belepes
GO
ALTER TABLE dbo.wvevo_arajant
	DROP CONSTRAINT FK_WVEVO_ARAJANT_BELEPES
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_CIKKEK_BELEPES
GO
ALTER TABLE dbo.wvevo_rent
	DROP CONSTRAINT FK_wvevo_rent_belepes
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_CIKKEK_BELEPES1
GO
ALTER TABLE dbo.wvevo_szlat
	DROP CONSTRAINT FK_WVEVO_SZLAT_BELEPES
GO
ALTER TABLE dbo.wvevo_szlet
	DROP CONSTRAINT FK_WVEVO_SZLET_BELEPES
GO
ALTER TABLE dbo.belepes SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_afa_kulcs
	(
	AFAKULCS dbo.afakulcs NOT NULL,
	afaertek numeric(2, 0) 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.wszall_szletm
	DROP CONSTRAINT FK_wszall_szletm_afa_kulcs
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_afa_kulcs
GO
ALTER TABLE dbo.vevo_arajant
	DROP CONSTRAINT FK_vevo_arajant_afa_kulcs
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_afa_kulcs
GO
ALTER TABLE dbo.bevett
	DROP CONSTRAINT FK_BEVETT_afa_kulcs
GO
ALTER TABLE dbo.wbevett
	DROP CONSTRAINT FK_WBEVETT_afa_kulcs
GO
ALTER TABLE dbo.vevo_rent
	DROP CONSTRAINT FK_vevo_rent_afa_kulcs
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_afa_kulcs
GO
ALTER TABLE dbo.webvevo_rent
	DROP CONSTRAINT FK_webvevo_rent_afa_kulcs
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_afa_kulcs
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_afa_kulcs
GO
ALTER TABLE dbo.wszall_szlet
	DROP CONSTRAINT FK_wszall_szlet_afa_kulcs
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_afa_kulcs
GO
ALTER TABLE dbo.wvevo_arajant
	DROP CONSTRAINT FK_WVEVO_ARAJANT_afa_kulcs
GO
ALTER TABLE dbo.wvevo_rent
	DROP CONSTRAINT FK_wvevo_rent_afa_kulcs
GO
ALTER TABLE dbo.vevo_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_afa_kulcs
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_CIKKEK_afa_kulcs
GO
ALTER TABLE dbo.wvevo_szlat
	DROP CONSTRAINT FK_WVEVO_SZLAT_afa_kulcs
GO
ALTER TABLE dbo.wvevo_szlet
	DROP CONSTRAINT FK_WVEVO_SZLET_afa_kulcs
GO
ALTER TABLE dbo.wwvevo_szlet
	DROP CONSTRAINT FK_WWVEVO_SZLET_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
CREATE TABLE dbo.Tmp_cikkek
	(
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.cikk_nev NOT NULL,
	cikk_nev_ang dbo.cikk_nev NOT NULL,
	aru_szolg char(1) NOT NULL,
	MENNY_EGYS dbo.menny_egyseg NOT NULL,
	menny_egys_ang dbo.menny_egyseg NOT NULL,
	NORM_ME dbo.menny_egyseg NOT NULL,
	NORM_SZORZ dbo.mennyiseg NOT NULL,
	VTSZ varchar(14) NOT NULL,
	AFA_KULCS dbo.afakulcs NOT NULL,
	KIFUTOTT char(1) NOT NULL,
	RENDELHETO char(1) NOT NULL,
	JOVEDEKI char(1) NOT NULL,
	GONGYOLEG char(1) NOT NULL,
	ALLANDO char(1) NOT NULL,
	TGON char(14) NOT NULL,
	TGONSZOR int NOT NULL,
	NTGON char(14) NOT NULL,
	NTGONSZOR int NOT NULL,
	CIKKCSOP2 char(18) NOT NULL,
	GYARTO dbo.kulcs NOT NULL,
	raktar_kod dbo.kulcs NOT NULL,
	POLC char(14) NOT NULL,
	SZALLITO dbo.kulcs NOT NULL,
	VCIKKSZAM dbo.cikk_szam NOT NULL,
	ZSUGOR_DB int NOT NULL,
	DB_KART int NOT NULL,
	KART_SOR int NOT NULL,
	KART_RAKL int NOT NULL,
	MIN_RENCS char(10) NOT NULL,
	MIN_RENSZ numeric(18, 3) NOT NULL,
	db_sulya numeric(18, 3) NOT NULL,
	db_br_sulya numeric(18, 3) NULL,
	karton_hossz int NOT NULL,
	karton_szelesseg int NOT NULL,
	karton_magassag int NOT NULL,
	karton_sulya numeric(18, 3) NOT NULL,
	karton_br_sulya numeric(18, 3) NULL,
	rakat_mag int NOT NULL,
	akt_besz_ar dbo.egyseg_ar NULL,
	ut_besz_ar dbo.egyseg_ar NOT NULL,
	NAPI_FOGY numeric(18, 3) NOT NULL,
	MIN_KESZ numeric(18, 3) NOT NULL,
	letrehozta dbo.kicsoda NOT NULL,
	letrehozva dbo.datum_ora NOT NULL,
	modositotta dbo.kicsoda NOT NULL,
	MODOSITVA dbo.datum_ora NOT NULL,
	TIZEDES tinyint NULL,
	DAT_TIPUS char(1) NOT NULL,
	SZAV_IDO int NOT NULL,
	vpop_alkoholfok dbo.mennyiseg NULL,
	vpop_fajtakod varchar(10) NULL,
	vpop_urtartalom dbo.mennyiseg NULL,
	termekdijas char(1) NULL,
	linkfile varchar(500) NOT NULL,
	szarmazasi_hely varchar(50) NOT NULL,
	gycikk_szam dbo.cikk_szam NOT NULL,
	chips_ados char(1) NOT NULL,
	vpop_platofok dbo.mennyiseg NOT NULL,
	web char(1) NOT NULL,
	fordafa char(1) NOT NULL,
	kockazatos char(1) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_cikkek SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.cikkek)
	 EXEC('INSERT INTO dbo.Tmp_cikkek (CIKK_SZAM, CIKK_NEV, cikk_nev_ang, aru_szolg, MENNY_EGYS, menny_egys_ang, NORM_ME, NORM_SZORZ, VTSZ, AFA_KULCS, KIFUTOTT, RENDELHETO, JOVEDEKI, GONGYOLEG, ALLANDO, TGON, TGONSZOR, NTGON, NTGONSZOR, CIKKCSOP2, GYARTO, raktar_kod, POLC, SZALLITO, VCIKKSZAM, ZSUGOR_DB, DB_KART, KART_SOR, KART_RAKL, MIN_RENCS, MIN_RENSZ, db_sulya, db_br_sulya, karton_hossz, karton_szelesseg, karton_magassag, karton_sulya, karton_br_sulya, rakat_mag, akt_besz_ar, ut_besz_ar, NAPI_FOGY, MIN_KESZ, letrehozta, letrehozva, modositotta, MODOSITVA, TIZEDES, DAT_TIPUS, SZAV_IDO, vpop_alkoholfok, vpop_fajtakod, vpop_urtartalom, termekdijas, linkfile, szarmazasi_hely, gycikk_szam, chips_ados, vpop_platofok, web, fordafa, kockazatos)
		SELECT CIKK_SZAM, CIKK_NEV, cikk_nev_ang, aru_szolg, MENNY_EGYS, menny_egys_ang, NORM_ME, NORM_SZORZ, VTSZ, AFA_KULCS, KIFUTOTT, RENDELHETO, JOVEDEKI, GONGYOLEG, ALLANDO, TGON, TGONSZOR, NTGON, NTGONSZOR, CIKKCSOP2, GYARTO, raktar_kod, POLC, SZALLITO, VCIKKSZAM, ZSUGOR_DB, DB_KART, KART_SOR, KART_RAKL, MIN_RENCS, MIN_RENSZ, db_sulya, db_br_sulya, karton_hossz, karton_szelesseg, karton_magassag, karton_sulya, karton_br_sulya, rakat_mag, akt_besz_ar, ut_besz_ar, NAPI_FOGY, MIN_KESZ, letrehozta, letrehozva, modositotta, MODOSITVA, TIZEDES, DAT_TIPUS, SZAV_IDO, vpop_alkoholfok, vpop_fajtakod, vpop_urtartalom, termekdijas, linkfile, szarmazasi_hely, gycikk_szam, chips_ados, vpop_platofok, web, fordafa, kockazatos FROM dbo.cikkek WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_CCIKKEK
GO
ALTER TABLE dbo.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_FCIKKEK
GO
ALTER TABLE dbo.wszall_art
	DROP CONSTRAINT FK_wszall_art_cikkek
GO
ALTER TABLE dbo.wmerleg
	DROP CONSTRAINT FK_wmerleg_cikkek
GO
ALTER TABLE dbo.wszall_szlet
	DROP CONSTRAINT FK_wszall_szlet_cikkek
GO
ALTER TABLE dbo.wvevo_arajant
	DROP CONSTRAINT FK_WVEVO_ARAJANT_CIKKEK
GO
ALTER TABLE dbo.wvevo_rent
	DROP CONSTRAINT FK_wvevo_rent_cikkek
GO
ALTER TABLE dbo.wvevo_szlat
	DROP CONSTRAINT FK_WVEVO_SZLAT_CIKKEK
GO
ALTER TABLE dbo.wvevo_szlet
	DROP CONSTRAINT FK_WVEVO_SZLET_CIKKEK
GO
ALTER TABLE dbo.anyagszukseglet
	DROP CONSTRAINT FK_anyagszukseglet_cikkek
GO
ALTER TABLE dbo.anyagszukseglet
	DROP CONSTRAINT FK_anyagszukseglet_cikkek1
GO
ALTER TABLE dbo.wwvevo_szlet
	DROP CONSTRAINT FK_WWVEVO_SZLET_CIKKEK
GO
ALTER TABLE dbo.vevo_akcio_me
	DROP CONSTRAINT FK_vevo_akcio_me_cikkek
GO
ALTER TABLE dbo.keszre2
	DROP CONSTRAINT FK_keszre2_cikkek
GO
ALTER TABLE dbo.koltseg_keszletre
	DROP CONSTRAINT FK_koltseg_keszletre_cikkek
GO
ALTER TABLE dbo.wkivett
	DROP CONSTRAINT FK_WKIVETT_CIKKEK
GO
ALTER TABLE dbo.wszall_szletm
	DROP CONSTRAINT FK_wszall_szletm_cikkek
GO
ALTER TABLE dbo._web_kedvencek
	DROP CONSTRAINT FK__web_kedvencek_cikkek
GO
ALTER TABLE dbo.leltar
	DROP CONSTRAINT FK_leltar_cikkek
GO
ALTER TABLE dbo.diszpo
	DROP CONSTRAINT FK_diszpo_cikkek
GO
ALTER TABLE dbo.vevo_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_CIKKEK
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_CIKKEK
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_CIKKEK
GO
ALTER TABLE dbo.hcimke_csz
	DROP CONSTRAINT FK_hcimke_csz_cikkek
GO
ALTER TABLE dbo._web_kosar
	DROP CONSTRAINT FK__web_kosar_cikkek
GO
ALTER TABLE dbo._web_kosaruj
	DROP CONSTRAINT FK__web_kosaruj_cikkek
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_cikkek
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_cikkek
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_cikkek
GO
ALTER TABLE dbo.wrmozgast
	DROP CONSTRAINT FK_WRMOZGAST_CIKKEK
GO
ALTER TABLE dbo.leltar_felv
	DROP CONSTRAINT FK_leltar_felv_cikkek
GO
ALTER TABLE dbo.vevo_akcio_hh
	DROP CONSTRAINT FK_vevo_akcio_hh_cikkek
GO
ALTER TABLE dbo.rmozgast
	DROP CONSTRAINT FK_RMOZGAST_CIKKEK
GO
ALTER TABLE dbo.vevo_arajant
	DROP CONSTRAINT FK_vevo_arajant_cikkek
GO
ALTER TABLE dbo.leertekeles
	DROP CONSTRAINT FK_leertekeles_ccikkek
GO
ALTER TABLE dbo.leertekeles
	DROP CONSTRAINT FK_leertekeles_fcikkek
GO
ALTER TABLE dbo.foglalasok
	DROP CONSTRAINT FK_foglalasok_cikkek
GO
ALTER TABLE dbo.vevo_ar_lista
	DROP CONSTRAINT FK_vevo_art1_CIKKEK
GO
ALTER TABLE dbo.keszlet_negativ
	DROP CONSTRAINT FK_keszlet_negativ_cikkek
GO
ALTER TABLE dbo.vevo_arajanlatt
	DROP CONSTRAINT FK_vevo_arajanlatt_cikkek
GO
ALTER TABLE dbo.cikkek_kep
	DROP CONSTRAINT FK_cikkek_kep_cikkek
GO
ALTER TABLE dbo.cikkek_doc
	DROP CONSTRAINT FK_cikkek_doc_cikkek
GO
ALTER TABLE dbo.vonal
	DROP CONSTRAINT FK_VONAL_CIKKEK
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_cikkek
GO
ALTER TABLE dbo.szall_art
	DROP CONSTRAINT FK_SZAL_ART_CIKKEK
GO
ALTER TABLE dbo.csomagt
	DROP CONSTRAINT FK_csomagt_cikkek
GO
ALTER TABLE dbo.vevo_ido_szlat
	DROP CONSTRAINT FK_vevo_ido_szlat_cikkek
GO
ALTER TABLE dbo.vevo_akcio
	DROP CONSTRAINT FK_vevo_akcio_CIKKEK
GO
ALTER TABLE dbo.bevett
	DROP CONSTRAINT FK_BEVETT_CIKKEK
GO
ALTER TABLE dbo.keszlet
	DROP CONSTRAINT FK_KESZLET_CIKKEK
GO
ALTER TABLE dbo.vevo_csz
	DROP CONSTRAINT FK_vevo_csz_cikkek
GO
ALTER TABLE dbo.kivett
	DROP CONSTRAINT FK_KIVETT_CIKKEK
GO
ALTER TABLE dbo.vevo_arak
	DROP CONSTRAINT FK_vevo_arak_CIKKEK
GO
ALTER TABLE dbo.wbevett
	DROP CONSTRAINT FK_WBEVETT_CIKKEK
GO
ALTER TABLE dbo.webvevo_rent
	DROP CONSTRAINT FK_webvevo_rent_cikkek
GO
commit





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