/*
   2016. január 6.13:28:59
   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.leltar
	DROP CONSTRAINT FK_leltar_cikkek
GO
ALTER TABLE dbo.cikkek SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.leltar
	DROP CONSTRAINT FK_leltar_raktarak
GO
ALTER TABLE dbo.raktarak SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_leltar
	(
	cikk_szam dbo.cikk_szam NOT NULL,
	raktar_kod dbo.kulcs NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	fellelt dbo.mennyiseg NOT NULL,
	szav_ido varchar(20) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_leltar SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.leltar)
	 EXEC('INSERT INTO dbo.Tmp_leltar (cikk_szam, raktar_kod, darab, fellelt, szav_ido)
		SELECT cikk_szam, raktar_kod, darab, fellelt, CONVERT(varchar(20), szav_ido) FROM dbo.leltar WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.leltar
GO
EXECUTE sp_rename N'dbo.Tmp_leltar', N'leltar', 'OBJECT' 
GO
ALTER TABLE dbo.leltar ADD CONSTRAINT
	PK_leltar_1 PRIMARY KEY CLUSTERED 
	(
	cikk_szam,
	raktar_kod,
	szav_ido
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX IX_leltar_cikk_szam ON dbo.leltar
	(
	cikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.leltar ADD CONSTRAINT
	FK_leltar_raktarak FOREIGN KEY
	(
	raktar_kod
	) REFERENCES dbo.raktarak
	(
	kod
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
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
go


/*
   2016. január 6.14:16:10
   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
CREATE TABLE dbo.Tmp_a_leltar_felv
	(
	oldal int NOT NULL,
	fazis int NOT NULL,
	raktar_kod dbo.kulcs NOT NULL,
	cikk_szam dbo.cikk_szam NOT NULL,
	darab dbo.mennyiseg NOT NULL,
	tetel int NOT NULL,
	cikk_nev dbo.cikk_nev NOT NULL,
	datum dbo.datum NOT NULL,
	szav_lejar varchar(20) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_a_leltar_felv SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.a_leltar_felv)
	 EXEC('INSERT INTO dbo.Tmp_a_leltar_felv (oldal, fazis, raktar_kod, cikk_szam, darab, tetel, cikk_nev, datum, szav_lejar)
		SELECT oldal, fazis, raktar_kod, cikk_szam, darab, tetel, cikk_nev, datum, CONVERT(varchar(20), szav_lejar) FROM dbo.a_leltar_felv WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.a_leltar_felv
GO
EXECUTE sp_rename N'dbo.Tmp_a_leltar_felv', N'a_leltar_felv', 'OBJECT' 
GO
CREATE NONCLUSTERED INDEX IX_a_leltar_felv_oldal_tetel ON dbo.a_leltar_felv
	(
	oldal,
	tetel
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_a_leltar_felv_cikk_szam ON dbo.a_leltar_felv
	(
	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_a_leltar_felv_cikk_nev ON dbo.a_leltar_felv
	(
	cikk_nev
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT
go



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