alter table regisztral add euadoszam varchar(50)
go
alter table regisztral add mukodesi varchar(50)
go
alter table regisztral add jovedeki varchar(50)
go
update regisztral set euadoszam=''
go
update regisztral set mukodesi =''
go
update regisztral set jovedeki =''
go
CREATE TABLE [dbo].[vevo_szall](
	[vevo_kod] [dbo].[kulcs] NOT NULL,
	[szall_kod] [dbo].[kulcs] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[vevo_szall]  WITH CHECK ADD  CONSTRAINT [FK_vevo_szall_szallito] FOREIGN KEY([szall_kod])
REFERENCES [dbo].[szallito] ([SZALL_KOD])
GO
ALTER TABLE [dbo].[vevo_szall] CHECK CONSTRAINT [FK_vevo_szall_szallito]
GO
ALTER TABLE [dbo].[vevo_szall]  WITH CHECK ADD  CONSTRAINT [FK_vevo_szall_vevok] FOREIGN KEY([vevo_kod])
REFERENCES [dbo].[vevok] ([VEVO_KOD])
GO
ALTER TABLE [dbo].[vevo_szall] CHECK CONSTRAINT [FK_vevo_szall_vevok]
GO



/* 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_akcio
	DROP CONSTRAINT FK_vevo_akcio_BELEPES
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_akcio
	DROP CONSTRAINT FK_vevo_akcio_vevo_akc_csoport
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.vevo_akcio
	DROP CONSTRAINT FK_vevo_akcio_CIKKEK
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_akcio
	(
	AKCIOCSOP int NOT NULL,
	AKCIO_TIP int NOT NULL,
	KDATUM dbo.datum NOT NULL,
	VDATUM dbo.datum NOT NULL,
	CIKK_SZAM dbo.cikk_szam NOT NULL,
	EGYSEG_AR dbo.egyseg_ar NOT NULL,
	SZOVEG dbo.megjegyzes NOT NULL,
	KE_KESZLET dbo.mennyiseg NOT NULL,
	KE_MARADEK dbo.mennyiseg NOT NULL,
	KICSODA dbo.kicsoda NOT NULL,
	MODOSITVA dbo.datum_ora NOT NULL,
	kulcs timestamp NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.vevo_akcio)
	 EXEC('INSERT INTO dbo.Tmp_vevo_akcio (AKCIOCSOP, AKCIO_TIP, KDATUM, VDATUM, CIKK_SZAM, EGYSEG_AR, SZOVEG, KE_KESZLET, KE_MARADEK, KICSODA, MODOSITVA)
		SELECT AKCIOCSOP, 1, KDATUM, VDATUM, CIKK_SZAM, EGYSEG_AR, SZOVEG, 0, 0, KICSODA, MODOSITVA FROM dbo.vevo_akcio WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_akcio
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_akcio', N'vevo_akcio', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_akcio ADD CONSTRAINT
	PK_vevo_akcio PRIMARY KEY CLUSTERED 
	(
	kulcs
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_akcio ADD CONSTRAINT
	FK_vevo_akcio_CIKKEK FOREIGN KEY
	(
	CIKK_SZAM
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_akcio ADD CONSTRAINT
	FK_vevo_akcio_vevo_akc_csoport FOREIGN KEY
	(
	AKCIOCSOP
	) REFERENCES dbo.vevo_akc_csoport
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.vevo_akcio ADD CONSTRAINT
	FK_vevo_akcio_BELEPES FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
GO


/* 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_arf
	DROP CONSTRAINT FK_szall_arf_deviza
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_arf
	DROP CONSTRAINT FK_SZAL_ARF_SZALLITO
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_arf
	DROP CONSTRAINT FK_SZAL_ARF_BELEPES
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_szall_arf
	(
	BIZSZAM dbo.bizonylat_szam NOT NULL,
	SZALLITO dbo.kulcs NOT NULL,
	TIPUS char(10) NOT NULL,
	penznem dbo.penznem NOT NULL,
	KDATUM dbo.datum NOT NULL,
	VDATUM dbo.datum NOT NULL,
	RKDATUM dbo.datum NOT NULL,
	RVDATUM dbo.datum NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	MEGJEGYZES dbo.megjegyzes NOT NULL,
	KICSODA dbo.kicsoda NOT NULL,
	MODOSITVA dbo.datum_ora NOT NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.szall_arf)
	 EXEC('INSERT INTO dbo.Tmp_szall_arf (BIZSZAM, SZALLITO, TIPUS, penznem, KDATUM, VDATUM, RKDATUM, RVDATUM, kedvezmeny, MEGJEGYZES, KICSODA, MODOSITVA)
		SELECT BIZSZAM, SZALLITO, ''normál'', penznem, KDATUM, '' '','' '','' '', kedvezmeny, MEGJEGYZES, KICSODA, MODOSITVA FROM dbo.szall_arf WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.szall_art
	DROP CONSTRAINT FK_SZAL_ART_SZAL_ARF
GO
DROP TABLE dbo.szall_arf
GO
EXECUTE sp_rename N'dbo.Tmp_szall_arf', N'szall_arf', 'OBJECT' 
GO
ALTER TABLE dbo.szall_arf ADD CONSTRAINT
	PK_SZAL_ARF PRIMARY KEY CLUSTERED 
	(
	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_ARF ON dbo.szall_arf
	(
	SZALLITO
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_SZAL_ARF_1 ON dbo.szall_arf
	(
	KDATUM
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szall_arf ADD CONSTRAINT
	FK_SZAL_ARF_BELEPES FOREIGN KEY
	(
	KICSODA
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_arf ADD CONSTRAINT
	FK_SZAL_ARF_SZALLITO FOREIGN KEY
	(
	SZALLITO
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_arf ADD CONSTRAINT
	FK_szall_arf_deviza FOREIGN KEY
	(
	penznem
	) REFERENCES dbo.deviza
	(
	penznem
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
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
COMMIT
GO