﻿PRINT N'Altering Table [dbo].[T_EPJTANULOIADAT]...';
Go

IF COL_LENGTH('dbo.T_EPJTANULOIADAT', 'C_SZAKKEPESITESMEGNEVEZES') <> 500 BEGIN
  ALTER TABLE [dbo].[T_EPJTANULOIADAT] ALTER COLUMN [C_SZAKKEPESITESMEGNEVEZES] NVARCHAR (250) NULL;
END
GO

PRINT N'Altering Table [dbo].[T_TANULO]...';
GO

ALTER TABLE [dbo].[T_TANULO]
  ADD [C_ISAPACZAISZERZODESES] CHAR (1) DEFAULT ('F') NOT NULL;
GO


EXEC dev.uspCreateSchemaViews 'T_EPJTANULOIADAT, T_TANULO'
GO

EXEC dev.sp_Global_GenerateAsyncAuditTriggerAll
GO

ALTER QUEUE auditLog.[AuditQueue]
WITH ACTIVATION (
  STATUS = ON,
  PROCEDURE_NAME = auditLog.usp_AuditProcessing,
  MAX_QUEUE_READERS = 10,
  EXECUTE AS 'Kreta_tech_user'
);
GO
