/*
   2017. január 24., kedd11:40:01
   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.vevo_tel
	DROP CONSTRAINT FK_VEVO_TEL_VEVOK
GO
ALTER TABLE dbo.vevok SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_vevo_tel
	(
	VEVO_KOD int NOT NULL,
	TELEP_KOD char(4) NOT NULL,
	TELEP_NEV nvarchar(50) NOT NULL,
	VAROS nvarchar(50) NOT NULL,
	IRANYITO nvarchar(50) NOT NULL,
	CIM nvarchar(50) NOT NULL,
	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,
	KAPCSOLAT nvarchar(50) NOT NULL,
	TELEFON nvarchar(50) NOT NULL,
	EMAIL nvarchar(50) NOT NULL,
	KARTYA nvarchar(50) NOT NULL,
	LIMIT real NULL,
	jovedeki nvarchar(50) NOT NULL,
	TOROLT char(1) NULL,
	vevo_csoport dbo.kulcs NULL,
	vevo_lanc dbo.kulcs NULL,
	vevo_cegjelleg dbo.kulcs NULL,
	vevo_terulet dbo.kulcs NULL,
	idokapu varchar(30) NULL,
	iso char(2) NULL,
	allam varchar(255) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevo_tel SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevo_tel)
	 EXEC('INSERT INTO dbo.Tmp_vevo_tel (VEVO_KOD, TELEP_KOD, TELEP_NEV, VAROS, IRANYITO, CIM, KAPCSOLAT, TELEFON, EMAIL, KARTYA, LIMIT, jovedeki, TOROLT, vevo_csoport, vevo_lanc, vevo_cegjelleg, vevo_terulet, idokapu, iso, allam)
		SELECT VEVO_KOD, TELEP_KOD, TELEP_NEV, VAROS, IRANYITO, CIM, KAPCSOLAT, TELEFON, EMAIL, KARTYA, LIMIT, jovedeki, TOROLT, vevo_csoport, vevo_lanc, vevo_cegjelleg, vevo_terulet, idokapu, iso, allam FROM dbo.vevo_tel WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevo_tel
GO
EXECUTE sp_rename N'dbo.Tmp_vevo_tel', N'vevo_tel', 'OBJECT' 
GO
ALTER TABLE dbo.vevo_tel ADD CONSTRAINT
	PK_VEVO_TEL PRIMARY KEY CLUSTERED 
	(
	VEVO_KOD,
	TELEP_KOD
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
ALTER TABLE dbo.vevo_tel ADD CONSTRAINT
	FK_VEVO_TEL_VEVOK FOREIGN KEY
	(
	VEVO_KOD
	) REFERENCES dbo.vevok
	(
	VEVO_KOD
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
COMMIT


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




/****** Object:  Table [dbo].[nb_vevo_tel]    Script Date: 2017. 01. 27. 15:23:03 ******/
DROP TABLE [dbo].[nb_vevo_tel]
GO

/****** Object:  Table [dbo].[nb_vevo_tel]    Script Date: 2017. 01. 27. 15:23:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[nb_vevo_tel](
	[VEVO_KOD] [int] NOT NULL,
	[TELEP_KOD] [char](4) NOT NULL,
	[TELEP_NEV] [nvarchar](50) NOT NULL,
	[VAROS] [nvarchar](50) NOT NULL,
	[IRANYITO] [nvarchar](50) NOT NULL,
	[CIM] [nvarchar](50) NOT NULL,
	[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,
	[KAPCSOLAT] [nvarchar](50) NOT NULL,
	[TELEFON] [nvarchar](50) NOT NULL,
	[EMAIL] [nvarchar](50) NOT NULL,
	[KARTYA] [nvarchar](50) NOT NULL,
	[LIMIT] [real] NULL,
	[jovedeki] [nvarchar](50) NOT NULL,
	[TOROLT] [char](1) NULL,
	[vevo_csoport] [dbo].[kulcs] NULL,
	[vevo_lanc] [dbo].[kulcs] NULL,
	[vevo_cegjelleg] [dbo].[kulcs] NULL,
	[vevo_terulet] [dbo].[kulcs] NULL,
	[idokapu] [varchar](30) NULL,
	[iso] [char](2) NULL,
	[allam] [varchar](255) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO



update vevo_tel set vevo_csoport=0 where vevo_csoport is null
update vevo_tel set vevo_lanc=0 where vevo_lanc is null
update vevo_tel set vevo_cegjelleg=0 where vevo_cegjelleg is null
update vevo_tel set vevo_terulet=0 where vevo_terulet is null



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