/****** Object:  Table [dbo].[keszlet_negativ]    Script Date: 05/04/2012 15:51:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[keszlet_negativ](
	[sorszam] [bigint] IDENTITY(1,1) NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[edarab] [dbo].[mennyiseg] NOT NULL,
	[darab] [dbo].[mennyiseg] NOT NULL,
	[raktar_kod] [dbo].[kulcs] NOT NULL,
	[biz_tipus] [varchar](20) NOT NULL,
	[bizszam] [dbo].[bizonylat_szam] NOT NULL,
	[tetel] [dbo].[bizonylat_tetel] NOT NULL,
 CONSTRAINT [PK_keszlet_negativ] PRIMARY KEY CLUSTERED 
(
	[sorszam] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[keszlet_negativ]  WITH CHECK ADD  CONSTRAINT [FK_keszlet_negativ_cikkek] FOREIGN KEY([cikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO

ALTER TABLE [dbo].[keszlet_negativ] CHECK CONSTRAINT [FK_keszlet_negativ_cikkek]
GO

ALTER TABLE [dbo].[keszlet_negativ]  WITH CHECK ADD  CONSTRAINT [FK_keszlet_negativ_raktarak] FOREIGN KEY([raktar_kod])
REFERENCES [dbo].[raktarak] ([kod])
GO

ALTER TABLE [dbo].[keszlet_negativ] CHECK CONSTRAINT [FK_keszlet_negativ_raktarak]
GO


/*
   2012. május 3.13:27:38
   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_linkfile
GO
CREATE TABLE dbo.Tmp_cikkek
	(
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.nev NOT NULL,
	cikk_nev_ang dbo.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
	)  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
IF EXISTS(SELECT * FROM dbo.cikkek)
	 EXEC('INSERT INTO dbo.Tmp_cikkek (CIKK_SZAM, CIKK_NEV, aru_szolg, MENNY_EGYS, 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)
		SELECT CIKK_SZAM, CIKK_NEV, aru_szolg, MENNY_EGYS, 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 FROM dbo.cikkek WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.vevo_arak
	DROP CONSTRAINT FK_vevo_arak_CIKKEK
GO
ALTER TABLE dbo.kivett
	DROP CONSTRAINT FK_KIVETT_CIKKEK
GO
ALTER TABLE dbo.vevo_csz
	DROP CONSTRAINT FK_vevo_csz_cikkek
GO
ALTER TABLE dbo.keszlet
	DROP CONSTRAINT FK_KESZLET_CIKKEK
GO
ALTER TABLE dbo.bevett
	DROP CONSTRAINT FK_BEVETT_CIKKEK
GO
ALTER TABLE dbo.wbevett
	DROP CONSTRAINT FK_WBEVETT_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.webvevo_rent
	DROP CONSTRAINT FK_webvevo_rent_cikkek
GO
ALTER TABLE dbo.vevo_akcio
	DROP CONSTRAINT FK_vevo_akcio_CIKKEK
GO
ALTER TABLE dbo.leltar
	DROP CONSTRAINT FK_leltar_cikkek
GO
ALTER TABLE dbo.szbiz_szlet
	DROP CONSTRAINT FK_szbiz_szlet_cikkek
GO
ALTER TABLE dbo.vevo_ido_szlat
	DROP CONSTRAINT FK_vevo_ido_szlat_cikkek
GO
ALTER TABLE dbo.szall_szlet
	DROP CONSTRAINT FK_szall_szlet_cikkek
GO
ALTER TABLE dbo.csomagt
	DROP CONSTRAINT FK_csomagt_cikkek
GO
ALTER TABLE dbo.wkivett
	DROP CONSTRAINT FK_WKIVETT_CIKKEK
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_cikkek
GO
ALTER TABLE dbo.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_CCIKKEK
GO
ALTER TABLE dbo.szall_art
	DROP CONSTRAINT FK_SZAL_ART_CIKKEK
GO
ALTER TABLE dbo.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_FCIKKEK
GO
ALTER TABLE dbo.wrmozgast
	DROP CONSTRAINT FK_WRMOZGAST_CIKKEK
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_cikkek
GO
ALTER TABLE dbo.wszall_art
	DROP CONSTRAINT FK_wszall_art_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.vonal
	DROP CONSTRAINT FK_VONAL_CIKKEK
GO
ALTER TABLE dbo.wvevo_szlet
	DROP CONSTRAINT FK_WVEVO_SZLET_CIKKEK
GO
ALTER TABLE dbo.cikkek_doc
	DROP CONSTRAINT FK_cikkek_doc_cikkek
GO
ALTER TABLE dbo.cikkek_kep
	DROP CONSTRAINT FK_cikkek_kep_cikkek
GO
ALTER TABLE dbo.vevo_arajanlatt
	DROP CONSTRAINT FK_vevo_arajanlatt_cikkek
GO
ALTER TABLE dbo.keszlet_negativ
	DROP CONSTRAINT FK_keszlet_negativ_cikkek
GO
ALTER TABLE dbo.vevo_ar_lista
	DROP CONSTRAINT FK_vevo_art1_CIKKEK
GO
ALTER TABLE dbo.foglalasok
	DROP CONSTRAINT FK_foglalasok_cikkek
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_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_arajant
	DROP CONSTRAINT FK_vevo_arajant_cikkek
GO
ALTER TABLE dbo.vevo_szlat
	DROP CONSTRAINT FK_VEVO_SZLAT_CIKKEK
GO
ALTER TABLE dbo.vevo_szlet
	DROP CONSTRAINT FK_VEVO_SZLET_CIKKEK
GO
ALTER TABLE dbo.rmozgast
	DROP CONSTRAINT FK_RMOZGAST_CIKKEK
GO
ALTER TABLE dbo.vevo_akcio_hh
	DROP CONSTRAINT FK_vevo_akcio_hh_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_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
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_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.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_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.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_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.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_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.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_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.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.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.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.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_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.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_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.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.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.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.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_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.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_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.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.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.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.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.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.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.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.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.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.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.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.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.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.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_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
go