/*
   2020. augusztus 27., csütörtök9:10:04
   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.oszla_naplo ADD
	statusz_int int NULL
GO
ALTER TABLE dbo.oszla_naplo SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
go



update oszla_naplo set statusz_int=0 where len(statusz)=0
update oszla_naplo set statusz_int=11 where statusz='RECEIVED'
update oszla_naplo set statusz_int=20 where statusz='ABORTED'
update oszla_naplo set statusz_int=11 where statusz='ELKULDVE' and valasz='ok'
update oszla_naplo set statusz_int=25 where statusz='DONE'
go



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