/*
   2016. május 17.11:48:16
   User: sa
   Server: 192.168.59.120,1450
   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.diszpo
	DROP CONSTRAINT FK_diszpo_raktarak
GO
ALTER TABLE dbo.raktarak SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.diszpo
	DROP CONSTRAINT FK_diszpo_belepes
GO
ALTER TABLE dbo.belepes SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.diszpo
	DROP CONSTRAINT FK_diszpo_cikkek
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_diszpo
	(
	kulcs dbo.kulcs NOT NULL IDENTITY (1, 1),
	prioritas bigint NOT NULL,
	raktar_kod dbo.kulcs NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	edarab numeric(18, 4) NOT NULL,
	darab numeric(18, 4) NOT NULL,
	megjegyzes dbo.megjegyzes NOT NULL,
	rogzitette dbo.kicsoda NOT NULL,
	rogzites dbo.datum_ora NOT NULL,
	rendeles_szam dbo.bizonylat_szam NOT NULL,
	rendeles_tetel dbo.bizonylat_tetel NOT NULL,
	visszaigazolas dbo.datum_ora NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_diszpo SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp_diszpo ON
GO
IF EXISTS(SELECT * FROM dbo.diszpo)
	 EXEC('INSERT INTO dbo.Tmp_diszpo (kulcs, prioritas, raktar_kod, cikk_szam, edarab, darab, megjegyzes, rogzitette, rogzites, rendeles_szam, rendeles_tetel, visszaigazolas)
		SELECT kulcs, prioritas, raktar_kod, cikk_szam, edarab, darab, megjegyzes, rogzitette, rogzites, CONVERT(char(10), keszrejelentette), CONVERT(int, keszrejelentes), visszaigazolas FROM dbo.diszpo WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_diszpo OFF
GO
ALTER TABLE dbo.keszre1
	DROP CONSTRAINT FK_keszre1_diszpo
GO
DROP TABLE dbo.diszpo
GO
EXECUTE sp_rename N'dbo.Tmp_diszpo', N'diszpo', 'OBJECT' 
GO
ALTER TABLE dbo.diszpo ADD CONSTRAINT
	PK_diszpo PRIMARY KEY CLUSTERED 
	(
	kulcs
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_diszpo ON dbo.diszpo
	(
	prioritas
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_diszpo_1 ON dbo.diszpo
	(
	raktar_kod
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_diszpo_2 ON dbo.diszpo
	(
	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_diszpo_3 ON dbo.diszpo
	(
	darab
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_diszpo_4 ON dbo.diszpo
	(
	rendeles_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_diszpo_5 ON dbo.diszpo
	(
	rogzitette
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.diszpo ADD CONSTRAINT
	FK_diszpo_cikkek FOREIGN KEY
	(
	cikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.diszpo ADD CONSTRAINT
	FK_diszpo_belepes FOREIGN KEY
	(
	rogzitette
	) REFERENCES dbo.belepes
	(
	ROVIDNEV
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.diszpo ADD CONSTRAINT
	FK_diszpo_raktarak FOREIGN KEY
	(
	raktar_kod
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.keszre1 ADD CONSTRAINT
	FK_keszre1_diszpo FOREIGN KEY
	(
	diszpo
	) REFERENCES dbo.diszpo
	(
	kulcs
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.keszre1 SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go





/*
   2016. május 26.10:31:29
   User: sa
   Server: 192.168.59.120,1450
   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.anyagszukseglet ADD
	egyseg_ar dbo.egyseg_ar NULL
GO
ALTER TABLE dbo.anyagszukseglet SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go


update anyagszukseglet set egyseg_ar=0
go

/*
   2016. június 1.11:03:47
   User: sa
   Server: 192.168.59.120,1450
   Database: aruker_hus
   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.keszre2
	DROP CONSTRAINT FK_keszre2_keszre1
GO
ALTER TABLE dbo.keszre1 SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.keszre2
	DROP CONSTRAINT FK_keszre2_cikkek
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_keszre2
	(
	kulcs dbo.kulcs NOT NULL,
	tetel dbo.bizonylat_tetel NULL,
	acikk_szam dbo.cikk_szam NOT NULL,
	darab numeric(18, 4) NOT NULL,
	egyseg_ar dbo.egyseg_ar NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_keszre2 SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.keszre2)
	 EXEC('INSERT INTO dbo.Tmp_keszre2 (kulcs, acikk_szam, darab)
		SELECT kulcs, acikk_szam, darab FROM dbo.keszre2 WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.keszre2
GO
EXECUTE sp_rename N'dbo.Tmp_keszre2', N'keszre2', 'OBJECT' 
GO
ALTER TABLE dbo.keszre2 ADD CONSTRAINT
	FK_keszre2_cikkek FOREIGN KEY
	(
	acikk_szam
	) REFERENCES dbo.cikkek
	(
	CIKK_SZAM
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.keszre2 ADD CONSTRAINT
	FK_keszre2_keszre1 FOREIGN KEY
	(
	kulcs
	) REFERENCES dbo.keszre1
	(
	kulcs
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT
go


update keszre2 set tetel=0, egyseg_ar=0
go


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