﻿--Migration
ALTER TABLE [dbo].[T_ALKALMAZOTT]
    ADD [C_ISHRKEZELO] CHAR (1) DEFAULT ('F') NOT NULL;

GO
ALTER TABLE [dbo].[T_HAZIFELADATOK]
    ADD [C_ISERTESITESELKULDVE] CHAR (1) DEFAULT ('T') NOT NULL;

GO
ALTER TABLE [dbo].[T_SZAMONKERESELOREJELZES]
    ADD [C_ISERTESITESELKULDVE] CHAR (1) DEFAULT ('T') NOT NULL;


GO
ALTER TABLE [dbo].[T_TANULOHAZIFELADAT]
    ADD [C_ISERTESITESELKULDVE] CHAR (1) DEFAULT ('T') NOT NULL;

GO

EXEC dev.uspCreateSchemaViews 'T_TANULOHAZIFELADAT, T_SZAMONKERESELOREJELZES, T_HAZIFELADATOK, T_ALKALMAZOTT'
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

