/*
   2021. október 1., péntek9:20:59
   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.szall_renf
	DROP CONSTRAINT FK_szall_renf_deviza
GO
ALTER TABLE dbo.deviza SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_renf
	DROP CONSTRAINT FK_szall_renf_belepes
GO
ALTER TABLE dbo.belepes SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_renf
	DROP CONSTRAINT FK_szall_renf_raktarak
GO
ALTER TABLE dbo.stelephely SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_renf
	DROP CONSTRAINT FK_szall_renf_szallito
GO
ALTER TABLE dbo.szallito SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.szall_renf
	DROP CONSTRAINT DF_szall_renf_afamentes
GO
CREATE TABLE dbo.Tmp_szall_renf
	(
	bizszam dbo.bizonylat_szam NOT NULL,
	szallito dbo.kulcs NOT NULL,
	datum dbo.datum NOT NULL,
	szall_dat dbo.datum NOT NULL,
	raktar_k dbo.kulcs NOT NULL,
	penznem dbo.penznem NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	allapot varchar(15) NOT NULL,
	megjegyzes varchar(512) NOT NULL,
	afamentes bit NOT NULL,
	kicsoda dbo.kicsoda NOT NULL,
	modositva dbo.datum_ora NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_renf SET (LOCK_ESCALATION = TABLE)
GO
ALTER TABLE dbo.Tmp_szall_renf ADD CONSTRAINT
	DF_szall_renf_afamentes DEFAULT ('0') FOR afamentes
GO
IF EXISTS(SELECT * FROM dbo.szall_renf)
	 EXEC('INSERT INTO dbo.Tmp_szall_renf (bizszam, szallito, datum, szall_dat, raktar_k, penznem, kedvezmeny, allapot, megjegyzes, afamentes, kicsoda, modositva)
		SELECT bizszam, szallito, datum, szall_dat, raktar_k, penznem, kedvezmeny, allapot, megjegyzes, afamentes, kicsoda, modositva FROM dbo.szall_renf WITH (HOLDLOCK TABLOCKX)')
GO
ALTER TABLE dbo.szall_rent
	DROP CONSTRAINT FK_szall_rent_szall_renf
GO
DROP TABLE dbo.szall_renf
GO
EXECUTE sp_rename N'dbo.Tmp_szall_renf', N'szall_renf', 'OBJECT' 
GO
ALTER TABLE dbo.szall_renf ADD CONSTRAINT
	PK_szall_renf 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_szall_renf ON dbo.szall_renf
	(
	datum
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_szall_renf_1 ON dbo.szall_renf
	(
	szallito
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.szall_renf ADD CONSTRAINT
	FK_szall_renf_szallito FOREIGN KEY
	(
	szallito
	) REFERENCES dbo.szallito
	(
	SZALL_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_renf ADD CONSTRAINT
	FK_szall_renf_raktarak FOREIGN KEY
	(
	raktar_k
	) REFERENCES dbo.stelephely
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_renf ADD CONSTRAINT
	FK_szall_renf_belepes FOREIGN KEY
	(
	kicsoda
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.szall_renf ADD CONSTRAINT
	FK_szall_renf_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_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 SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go




/*
   2021. október 1., péntek9:53:26
   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
CREATE TABLE dbo.Tmp_szall_renf_torol
	(
	bizszam dbo.bizonylat_szam NOT NULL,
	szallito dbo.kulcs NOT NULL,
	datum dbo.datum NOT NULL,
	szall_dat dbo.datum NOT NULL,
	raktar_k dbo.kulcs NOT NULL,
	penznem dbo.penznem NOT NULL,
	kedvezmeny dbo.kedvezmeny NOT NULL,
	allapot varchar(15) NOT NULL,
	megjegyzes varchar(512) NOT NULL,
	afamentes bit NOT NULL,
	kicsoda dbo.kicsoda NOT NULL,
	modositva dbo.datum_ora NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_szall_renf_torol SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.szall_renf_torol)
	 EXEC('INSERT INTO dbo.Tmp_szall_renf_torol (bizszam, szallito, datum, szall_dat, raktar_k, penznem, kedvezmeny, allapot, megjegyzes, afamentes, kicsoda, modositva)
		SELECT bizszam, szallito, datum, szall_dat, raktar_k, penznem, kedvezmeny, allapot, megjegyzes, afamentes, kicsoda, modositva FROM dbo.szall_renf_torol WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.szall_renf_torol
GO
EXECUTE sp_rename N'dbo.Tmp_szall_renf_torol', N'szall_renf_torol', 'OBJECT' 
GO
COMMIT
go




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