/*
   2009. szeptember 29.13:09:53
   User: sa
   Server: 192.168.1.85,1137
   Database: 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_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
CREATE TABLE dbo.Tmp_cikkek
	(
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	CIKK_NEV dbo.nev NOT NULL,
	aru_szolg char(1) COLLATE SQL_Hungarian_CP1250_CI_AS NOT NULL,
	MENNY_EGYS 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
	)  ON [PRIMARY]
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)
		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, CONVERT(varchar(20), 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 FROM dbo.cikkek WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.szall_szlat
	DROP CONSTRAINT FK_szall_szlat_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.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.wrmozgast
	DROP CONSTRAINT FK_WRMOZGAST_CIKKEK
GO
ALTER TABLE dbo.vonal
	DROP CONSTRAINT FK_VONAL_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.szall_rent
	DROP CONSTRAINT FK_szall_rent_cikkek
GO
ALTER TABLE dbo.wbevett
	DROP CONSTRAINT FK_WBEVETT_CIKKEK
GO
ALTER TABLE dbo.wvevo_rent
	DROP CONSTRAINT FK_wvevo_rent_cikkek
GO
ALTER TABLE dbo.vevo_arak
	DROP CONSTRAINT FK_vevo_arak_CIKKEK
GO
ALTER TABLE dbo.szall_art
	DROP CONSTRAINT FK_SZAL_ART_CIKKEK
GO
ALTER TABLE dbo.vevo_akcio_hh
	DROP CONSTRAINT FK_vevo_akcio_hh_cikkek
GO
ALTER TABLE dbo.wszall_szlet
	DROP CONSTRAINT FK_wszall_szlet_cikkek
GO
ALTER TABLE dbo.wvevo_szlat
	DROP CONSTRAINT FK_WVEVO_SZLAT_CIKKEK
GO
ALTER TABLE dbo.wkivett
	DROP CONSTRAINT FK_WKIVETT_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_ar_lista
	DROP CONSTRAINT FK_vevo_art1_CIKKEK
GO
ALTER TABLE dbo.wszall_art
	DROP CONSTRAINT FK_wszall_art_cikkek
GO
ALTER TABLE dbo.wvevo_szlet
	DROP CONSTRAINT FK_WVEVO_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.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_CCIKKEK
GO
ALTER TABLE dbo.wleertekelest
	DROP CONSTRAINT FK_wleertekelest_FCIKKEK
GO
ALTER TABLE dbo.wvevo_arajant
	DROP CONSTRAINT FK_WVEVO_ARAJANT_CIKKEK
GO
ALTER TABLE dbo.vevo_pszlat
	DROP CONSTRAINT FK_vevo_pszlat_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_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_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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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



/*
   2009. szeptember 29.13:13:59
   User: sa
   Server: 192.168.1.85,1137
   Database: 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.szall_art
	DROP CONSTRAINT FK_SZAL_ART_CIKKEK
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_art
	DROP CONSTRAINT FK_SZAL_ART_SZAL_ARF
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szall_art
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	VCIKKSZAM dbo.kicsoda NOT NULL,
	LISTA_AR dbo.egyseg_ar NOT NULL,
	KEDVEZMENY dbo.kedvezmeny NOT NULL,
	NETTO_AR dbo.egyseg_ar NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.szall_art)
	 EXEC('INSERT INTO dbo.Tmp_szall_art (BIZSZAM, CIKK_SZAM, VCIKKSZAM, LISTA_AR, KEDVEZMENY, NETTO_AR)
		SELECT BIZSZAM, CIKK_SZAM, CONVERT(varchar(20), VCIKKSZAM), LISTA_AR, KEDVEZMENY, NETTO_AR FROM dbo.szall_art WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.szall_art
GO
EXECUTE sp_rename N'dbo.Tmp_szall_art', N'szall_art', 'OBJECT' 
GO
CREATE NONCLUSTERED INDEX IX_SZAL_ART ON dbo.szall_art
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_SZAL_ART_1 ON dbo.szall_art
	(
	BIZSZAM,
	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_szall_art_bizszam ON dbo.szall_art
	(
	BIZSZAM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szall_art ADD CONSTRAINT
	FK_SZAL_ART_SZAL_ARF FOREIGN KEY
	(
	BIZSZAM
	) REFERENCES dbo.szall_arf
	(
	BIZSZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
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


/*
   2009. szeptember 29.13:15:26
   User: sa
   Server: 192.168.1.85,1137
   Database: 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.szall_rent
	DROP CONSTRAINT FK_szall_rent_afa_kulcs
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_szall_renf
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_cikkek
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 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
	)  ON [PRIMARY]
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, CONVERT(varchar(20), 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_cikkek FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) 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_afa_kulcs FOREIGN KEY
	(
	afa_kulcs
	) REFERENCES dbo.afa_kulcs
	(
	AFAKULCS
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT