﻿--Migration
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_AvatarTipusId_IntezmenyId_TanevId_REF_DKT_DIC_AvatarTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_AvatarTipusId_IntezmenyId_TanevId_REF_DKT_DIC_AvatarTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_CsakTanarIrhatUzenofalraTipusId_IntezmenyId_TanevId_REF_DKT_DIC_CsakTanarIrhatUzenofalraTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_CsakTanarIrhatUzenofalraTipusId_IntezmenyId_TanevId_REF_DKT_DIC_CsakTanarIrhatUzenofalraTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_FeladatErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatErtekelesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_FeladatErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatErtekelesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_HfErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatErtekelesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_HfErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatErtekelesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_OfErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatErtekelesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_OfErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatErtekelesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_FeladatTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_FeladatTipusId_IntezmenyId_TanevId_REF_DKT_DIC_FeladatTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_HfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfBeadandoTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_HfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfBeadandoTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_HfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfBeadandoTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_HfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfBeadandoTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_HfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfCsatolasEngedelyezesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_HfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfCsatolasEngedelyezesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_HfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfCsatolasEngedelyezesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_HfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfCsatolasEngedelyezesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_HfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_HfEloreBeirtFeladatMegjelenitese]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_HfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_HfEloreBeirtFeladatMegjelenitese];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_HfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_HfEloreBeirtFeladatMegjelenitese]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_HfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_HfEloreBeirtFeladatMegjelenitese];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_HfUzenofalEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfUzenofalEngedelyezesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_HfUzenofalEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_HfUzenofalEngedelyezesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_MindenUzenetKozpontiFalonTipusId_IntezmenyId_TanevId_REF_DKT_DIC_MindenUzenetKozpontiFalonTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_MindenUzenetKozpontiFalonTipusId_IntezmenyId_TanevId_REF_DKT_DIC_MindenUzenetKozpontiFalonTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_OfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfBeadandoTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_OfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfBeadandoTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_OfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfBeadandoTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_OfBeadandoTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfBeadandoTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_OfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfCsatolasEngedelyezesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_OfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfCsatolasEngedelyezesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_OfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfCsatolasEngedelyezesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_OfCsatolasEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfCsatolasEngedelyezesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_OfEgyediErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfEgyediErtekelesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_OfEgyediErtekelesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfEgyediErtekelesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_Feladat_OfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_OfEloreBeirtFeladatMegjelenitese]...';


GO
ALTER TABLE [dbo].[T_DKT_FELADAT] DROP CONSTRAINT IF EXISTS  [FK_DKT_Feladat_OfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_OfEloreBeirtFeladatMegjelenitese];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_OfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_OfEloreBeirtFeladatMegjelenitese]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_OfEloreBeirtFeladatMegjeleniteseId_IntezmenyId_TanevId_REF_DKT_DIC_OfEloreBeirtFeladatMegjelenitese];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_OfUzenofalEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfUzenofalEngedelyezesTipus]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_OfUzenofalEngedelyezesTipusId_IntezmenyId_TanevId_REF_DKT_DIC_OfUzenofalEngedelyezesTipus];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_AlkalmazottId_REF_Alkalmazott]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_AlkalmazottId_REF_Alkalmazott];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_AlkalmazottBeallitas_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_ALKALMAZOTTBEALLITAS] DROP CONSTRAINT IF EXISTS  [FK_DKT_AlkalmazottBeallitas_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_AvatarTipus_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_AVATARTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_AvatarTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_AvatarTipus_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_AVATARTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_AvatarTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_CsakTanarIrhatUzenofalraTipus_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_CsakTanarIrhatUzenofalraTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_CsakTanarIrhatUzenofalraTipus_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_CsakTanarIrhatUzenofalraTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_FeladatErtekelesTipus_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_FELADATERTEKELESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_FeladatErtekelesTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_FeladatErtekelesTipus_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_FELADATERTEKELESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_FeladatErtekelesTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_FeladatTipus_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_FELADATTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_FeladatTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_FeladatTipus_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_FELADATTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_FeladatTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfBeadandoTipus_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_HFBEADANDOTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfBeadandoTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfBeadandoTipus_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_HFBEADANDOTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfBeadandoTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfCsatolasEngedelyezesTipus_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfCsatolasEngedelyezesTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfCsatolasEngedelyezesTipus_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfCsatolasEngedelyezesTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfEloreBeirtFeladatMegjelenitese_IntezmenyId_REF_Intezmeny]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfEloreBeirtFeladatMegjelenitese_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfEloreBeirtFeladatMegjelenitese_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfEloreBeirtFeladatMegjelenitese_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfUzenofalEngedelyezesTipus_TanevId_REF_Tanev]...';


GO
ALTER TABLE [dbo].[T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfUzenofalEngedelyezesTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_HfUzenofalEngedelyezesTipus_IntezmenyId_REF_Intezmeny]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_HfUzenofalEngedelyezesTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_MindenUzenetKozpontiFalonTipus_IntezmenyId_REF_Intezmeny]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_MindenUzenetKozpontiFalonTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_MindenUzenetKozpontiFalonTipus_TanevId_REF_Tanev]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_MindenUzenetKozpontiFalonTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfBeadandoTipus_IntezmenyId_REF_Intezmeny]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFBEADANDOTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFBEADANDOTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfBeadandoTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfBeadandoTipus_TanevId_REF_Tanev]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFBEADANDOTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFBEADANDOTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfBeadandoTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfCsatolasEngedelyezesTipus_IntezmenyId_REF_Intezmeny]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfCsatolasEngedelyezesTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfCsatolasEngedelyezesTipus_TanevId_REF_Tanev]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfCsatolasEngedelyezesTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfEgyediErtekelesTipus_IntezmenyId_REF_Intezmeny]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfEgyediErtekelesTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfEgyediErtekelesTipus_TanevId_REF_Tanev]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfEgyediErtekelesTipus_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfEloreBeirtFeladatMegjelenitese_IntezmenyId_REF_Intezmeny]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfEloreBeirtFeladatMegjelenitese_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfEloreBeirtFeladatMegjelenitese_TanevId_REF_Tanev]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfEloreBeirtFeladatMegjelenitese_TanevId_REF_Tanev];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfUzenofalEngedelyezesTipus_IntezmenyId_REF_Intezmeny]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfUzenofalEngedelyezesTipus_IntezmenyId_REF_Intezmeny];


GO
PRINT N'Dropping [dbo].[FK_DKT_DIC_OfUzenofalEngedelyezesTipus_TanevId_REF_Tanev]...';


GO
IF OBJECT_ID('[dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS]') IS NOT NULL
ALTER TABLE [dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS] DROP CONSTRAINT IF EXISTS  [FK_DKT_DIC_OfUzenofalEngedelyezesTipus_TanevId_REF_Tanev];



GO
PRINT N'Dropping [dbo].[T_DKT_ALKALMAZOTTBEALLITAS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_ALKALMAZOTTBEALLITAS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_AVATARTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_AVATARTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_FELADATERTEKELESTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_FELADATERTEKELESTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_FELADATTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_FELADATTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_HFBEADANDOTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_HFBEADANDOTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_OFBEADANDOTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_OFBEADANDOTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE];


GO
PRINT N'Dropping [dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS]...';


GO
DROP TABLE  IF EXISTS [dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS];


GO
PRINT N'Update complete.';


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
