/*
   2012. május 11.12:00:32
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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_a_leltar_felv
	(
	oldal int NOT NULL,
	fazis int NOT NULL,
	raktar_kod dbo.kulcs NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	tetel int NOT NULL,
	cikk_nev dbo.cikk_nev NOT NULL,
	datum dbo.datum NOT NULL,
	szav_lejar dbo.datum NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.a_leltar_felv)
	 EXEC('INSERT INTO dbo.Tmp_a_leltar_felv (oldal, fazis, raktar_kod, cikk_szam, darab, tetel, cikk_nev, datum, szav_lejar)
		SELECT oldal, fazis, raktar_kod, cikk_szam, darab, tetel, cikk_nev, datum, szav_lejar FROM dbo.a_leltar_felv WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.a_leltar_felv
GO
EXECUTE sp_rename N'dbo.Tmp_a_leltar_felv', N'a_leltar_felv', 'OBJECT' 
GO
CREATE NONCLUSTERED INDEX IX_a_leltar_felv_oldal_tetel ON dbo.a_leltar_felv
	(
	oldal,
	tetel
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_a_leltar_felv_cikk_szam ON dbo.a_leltar_felv
	(
	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_a_leltar_felv_cikk_nev ON dbo.a_leltar_felv
	(
	cikk_nev
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT
go


/*
   2012. május 11.12:02:54
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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_afa_kulcs
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_CIKKEK_BELEPES
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_CIKKEK_BELEPES1
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT FK_cikkek_STCIKK2
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT DF_cikkek_cikk_nev_ang
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT DF_cikkek_menny_egys_ang
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT DF_cikkek_linkfile
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT DF_cikkek_szarmazasi_hely
GO
ALTER TABLE dbo.cikkek
	DROP CONSTRAINT DF_cikkek_jellemzo1
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) COLLATE SQL_Hungarian_CP1250_CI_AS 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) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	AFA_KULCS varchar(2) NOT NULL,
	KIFUTOTT char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	RENDELHETO char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	JOVEDEKI char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	GONGYOLEG char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	ALLANDO char(1) NOT NULL,
	TGON char(14) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	TGONSZOR int NOT NULL,
	NTGON char(14) COLLATE SQL_Hungarian_CP1250_CI_AS 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.kicsoda 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,
	jellemzo1 varchar(50) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_cikkek ADD CONSTRAINT
	DF_cikkek_cikk_nev_ang DEFAULT ('') FOR cikk_nev_ang
GO
ALTER TABLE dbo.Tmp_cikkek ADD CONSTRAINT
	DF_cikkek_menny_egys_ang DEFAULT ('') FOR menny_egys_ang
GO
ALTER TABLE dbo.Tmp_cikkek ADD CONSTRAINT
	DF_cikkek_linkfile DEFAULT ('') FOR linkfile
GO
ALTER TABLE dbo.Tmp_cikkek ADD CONSTRAINT
	DF_cikkek_szarmazasi_hely DEFAULT ('') FOR szarmazasi_hely
GO
ALTER TABLE dbo.Tmp_cikkek ADD CONSTRAINT
	DF_cikkek_jellemzo1 DEFAULT ('') FOR jellemzo1
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, jellemzo1)
		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, jellemzo1 FROM dbo.cikkek WITH (HOLDLOCK TABLOCKX)')
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_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_CIKKEK
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_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.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_CIKKEK
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.wvevo_szlet
	DROP CONSTRAINT FK_WVEVO_SZLET_CIKKEK
GO
ALTER TABLE dbo.vonal
	DROP CONSTRAINT FK_VONAL_CIKKEK
GO
ALTER TABLE dbo.wvevo_szlat
	DROP CONSTRAINT FK_WVEVO_SZLAT_CIKKEK
GO
ALTER TABLE dbo.wvevo_rent
	DROP CONSTRAINT FK_wvevo_rent_cikkek
GO
ALTER TABLE dbo.wvevo_arajant
	DROP CONSTRAINT FK_WVEVO_ARAJANT_CIKKEK
GO
ALTER TABLE dbo.wszall_szlet
	DROP CONSTRAINT FK_wszall_szlet_cikkek
GO
ALTER TABLE dbo.wszall_art
	DROP CONSTRAINT FK_wszall_art_cikkek
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_cikkek
GO
ALTER TABLE dbo.wrmozgast
	DROP CONSTRAINT FK_WRMOZGAST_CIKKEK
GO
ALTER TABLE dbo.szall_art
	DROP CONSTRAINT FK_SZAL_ART_CIKKEK
GO
ALTER TABLE dbo.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_CCIKKEK
GO
ALTER TABLE dbo.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_FCIKKEK
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_cikkek
GO
ALTER TABLE dbo.wkivett
	DROP CONSTRAINT FK_WKIVETT_CIKKEK
GO
ALTER TABLE dbo.csomagt
	DROP CONSTRAINT FK_csomagt_cikkek
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_cikkek
GO
ALTER TABLE dbo.vevo_ido_szlat
	DROP CONSTRAINT FK_vevo_ido_szlat_cikkek
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_cikkek
GO
ALTER TABLE dbo.leltar
	DROP CONSTRAINT FK_leltar_cikkek
GO
ALTER TABLE dbo.vevo_akcio
	DROP CONSTRAINT FK_vevo_akcio_CIKKEK
GO
ALTER TABLE dbo.webvevo_rent
	DROP CONSTRAINT FK_webvevo_rent_cikkek
GO
ALTER TABLE dbo.leltar_felv
	DROP CONSTRAINT FK_a_leltar_felv_cikkek
GO
ALTER TABLE dbo.leltar_felv
	DROP CONSTRAINT FK_leltar_felv_cikkek
GO
ALTER TABLE dbo.wbevett
	DROP CONSTRAINT FK_WBEVETT_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
DROP TABLE dbo.cikkek
GO
EXECUTE sp_rename N'dbo.Tmp_cikkek', N'cikkek', 'OBJECT' 
GO
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_STCIKK2 FOREIGN KEY
	(
	CIKKCSOP2
	) REFERENCES dbo.stcikk2
	(
	cikk_szam
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
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
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
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
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
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
COMMIT
BEGIN TRANSACTION
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
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
ALTER TABLE dbo.leltar_felv ADD CONSTRAINT
	FK_a_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 ADD CONSTRAINT
	FK_leltar_felv_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.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
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
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
COMMIT
BEGIN TRANSACTION
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
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
COMMIT
BEGIN TRANSACTION
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.csomagt ADD CONSTRAINT
	FK_csomagt_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.wkivett ADD CONSTRAINT
	FK_WKIVETT_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 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.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
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
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
COMMIT
BEGIN TRANSACTION
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
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
COMMIT
BEGIN TRANSACTION
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
COMMIT
BEGIN TRANSACTION
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
COMMIT
BEGIN TRANSACTION
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
COMMIT
BEGIN TRANSACTION
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
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
COMMIT
BEGIN TRANSACTION
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
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
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
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
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
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
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
COMMIT
BEGIN TRANSACTION
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
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
COMMIT
BEGIN TRANSACTION
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
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
COMMIT
BEGIN TRANSACTION
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
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
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
COMMIT
go


/*
   2012. május 11.12:06:07
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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.leltar_felv
	DROP CONSTRAINT FK_leltar_felv_raktarak
GO
ALTER TABLE dbo.leltar_felv
	DROP CONSTRAINT FK_a_leltar_felv_raktarak
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.leltar_felv
	DROP CONSTRAINT FK_a_leltar_felv_cikkek
GO
ALTER TABLE dbo.leltar_felv
	DROP CONSTRAINT FK_leltar_felv_cikkek
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_leltar_felv
	(
	oldal int NOT NULL,
	fazis int NOT NULL,
	raktar_kod dbo.kulcs NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	tetel int NOT NULL IDENTITY (1, 1),
	cikk_nev dbo.cikk_nev NOT NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_leltar_felv ON
GO
IF EXISTS(SELECT * FROM dbo.leltar_felv)
	 EXEC('INSERT INTO dbo.Tmp_leltar_felv (oldal, fazis, raktar_kod, cikk_szam, darab, tetel, cikk_nev)
		SELECT oldal, fazis, raktar_kod, cikk_szam, darab, tetel, cikk_nev FROM dbo.leltar_felv WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_leltar_felv OFF
GO
DROP TABLE dbo.leltar_felv
GO
EXECUTE sp_rename N'dbo.Tmp_leltar_felv', N'leltar_felv', 'OBJECT' 
GO
ALTER TABLE dbo.leltar_felv ADD CONSTRAINT
	PK_leltar_felv PRIMARY KEY CLUSTERED 
	(
	fazis,
	raktar_kod,
	tetel
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_leltar_felv_cikk_szam ON dbo.leltar_felv
	(
	cikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.leltar_felv ADD CONSTRAINT
	FK_a_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 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 ADD CONSTRAINT
	FK_leltar_felv_raktarak FOREIGN KEY
	(
	raktar_kod
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.leltar_felv ADD CONSTRAINT
	FK_a_leltar_felv_raktarak FOREIGN KEY
	(
	raktar_kod
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go


/*
   2012. május 11.12:07:06
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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 varchar(2) 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
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


/*
   2012. május 11.12:07:50
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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 varchar(2) 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
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


/*
   2012. május 11.12:09:43
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_cikkek
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_szall_szlaf
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_afa_kulcs
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 varchar(2) 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
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
COMMIT
go


/*
   2012. május 11.12:10:27
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_szall_szlef
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_afa_kulcs
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_cikkek
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 varchar(2) 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 ADD CONSTRAINT
	DF_szall_szlet_CIKK_NEV DEFAULT '' FOR CIKK_NEV
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.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_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
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
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
COMMIT
go


/*
   2012. május 11.12:11:20
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_afa_kulcs
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_szbiz_szlef
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_cikkek
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 varchar(2) 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 ADD CONSTRAINT
	DF_szbiz_szlet_CIKK_NEV DEFAULT '' FOR CIKK_NEV
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_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
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
COMMIT
go


/*
   2012. május 11.12:13:56
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_VEVO_PSZLAF
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_afa_kulcs
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_CIKKEK
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 varchar(2) 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 ADD CONSTRAINT
	DF_vevo_pszlat_CIKK_NEV DEFAULT '' FOR CIKK_NEV
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
go


/*
   2012. május 11.12:14:48
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_VEVO_SZLAF
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_afa_kulcs
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_CIKKEK
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 varchar(2) 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 ADD CONSTRAINT
	DF_vevo_szlat_CIKK_NEV DEFAULT '' FOR CIKK_NEV
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_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 ADD CONSTRAINT
	FK_VEVO_SZLAT_VEVO_SZLAF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.vevo_szlaf
	(
	BIZSZAM
	) 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
COMMIT
go


/*
   2012. május 11.12:15:19
   User: sa
   Server: 192.168.1.85,1137
   Database: aruker_negativ
   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_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_VEVO_SZLEF
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_afa_kulcs
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_CIKKEK
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 varchar(2) 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 ADD CONSTRAINT
	DF_vevo_szlet_CIKK_NEV DEFAULT '' FOR CIKK_NEV
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
COMMIT
go