/*
   2015. december 30.14:25:10
   User: sa
   Server: 192.168.59.120,1450
   Database: bolt
   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.vevok ADD
	kerulet varchar(50) NULL,
	kozterulet_jellege varchar(50) NULL,
	hazszam varchar(50) NULL,
	epulet varchar(50) NULL,
	lepcsohaz varchar(50) NULL,
	szint varchar(50) NULL,
	ajto varchar(50) NULL
GO
ALTER TABLE dbo.vevok SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

update vevok
set kerulet = '',
kozterulet_jellege = '',
hazszam ='',
epulet ='',
lepcsohaz ='',
szint ='',
ajto =''
go


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