﻿GO
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;

SET NUMERIC_ROUNDABORT OFF;


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


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] DROP CONSTRAINT [FK_T_21038_4025243];


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


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] DROP CONSTRAINT [FK_402519102_402519100];


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


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] DROP CONSTRAINT [FK_402519105_402519103];


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


GO
ALTER TABLE [dbo].[T_TANTERV] DROP CONSTRAINT [FK_4025392_4025393];


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


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS_FOGLALKOZASTIPU] DROP CONSTRAINT [FK_4026541_4026540];


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


GO
ALTER TABLE [dbo].[T_CSOPORT] DROP CONSTRAINT [FK_4025277_4025300];


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


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORT] DROP CONSTRAINT [FK_4026005_4026006];


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


GO
ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] DROP CONSTRAINT [FK_T_21038_4025414];


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


GO
ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] DROP CONSTRAINT [FK_T_21038_4027517];


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


GO
ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] DROP CONSTRAINT [FK_T_21038_4027832];


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


GO
ALTER TABLE [dbo].[T_PRIORITAS] DROP CONSTRAINT [FK_T_21038_4026956];


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


GO
ALTER TABLE [dbo].[T_ORSZAGTIPUS] DROP CONSTRAINT [FK_T_21038_1291259];


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] DROP CONSTRAINT [FK_T_21038_2846551];


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


GO
ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] DROP CONSTRAINT [FK_T_21038_48373];


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


GO
ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] DROP CONSTRAINT [FK_T_21038_4027466];


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


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] DROP CONSTRAINT [FK_T_21038_4026039];


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


GO
ALTER TABLE [dbo].[T_FORRAS] DROP CONSTRAINT [FK_T_21038_4026954];


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


GO
ALTER TABLE [dbo].[T_ROKONSAGIFOK] DROP CONSTRAINT [FK_T_21038_4025189];


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


GO
ALTER TABLE [dbo].[T_LANGUAGE] DROP CONSTRAINT [FK_T_21038_48362];


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


GO
ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] DROP CONSTRAINT [FK_T_21038_4027468];


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


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] DROP CONSTRAINT [FK_T_21038_4025811];


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


GO
ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] DROP CONSTRAINT [FK_T_21038_4026714];


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


GO
ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] DROP CONSTRAINT [FK_T_21038_2740820];


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


GO
ALTER TABLE [dbo].[T_CIMTIPUS] DROP CONSTRAINT [FK_T_21038_48323];


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


GO
ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4025640];


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


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] DROP CONSTRAINT [FK_T_21038_4025812];


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


GO
ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] DROP CONSTRAINT [FK_T_21038_1257632];


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


GO
ALTER TABLE [dbo].[T_ENAPLOTIPUS] DROP CONSTRAINT [FK_T_21038_4026713];


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


GO
ALTER TABLE [dbo].[T_NEM] DROP CONSTRAINT [FK_T_21038_48370];


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


GO
ALTER TABLE [dbo].[T_ERRORTYPE] DROP CONSTRAINT [FK_T_21038_48468];


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


GO
ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] DROP CONSTRAINT [FK_T_21038_4025391];


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


GO
ALTER TABLE [dbo].[T_WIFIELERES] DROP CONSTRAINT [FK_T_21038_4027469];


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


GO
ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] DROP CONSTRAINT [FK_T_21038_4025798];


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


GO
ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] DROP CONSTRAINT [FK_T_21038_1029472];


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


GO
ALTER TABLE [dbo].[T_ENAPLOFORRAS] DROP CONSTRAINT [FK_T_21038_4026712];


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


GO
ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] DROP CONSTRAINT [FK_T_21038_4025374];


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


GO
ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] DROP CONSTRAINT [FK_T_21038_4027465];


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


GO
ALTER TABLE [dbo].[T_SZEREPKORTIPUS] DROP CONSTRAINT [FK_T_21038_4026190];


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


GO
ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] DROP CONSTRAINT [FK_T_21038_4025375];


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


GO
ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] DROP CONSTRAINT [FK_T_21038_4027467];


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


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] DROP CONSTRAINT [FK_T_21038_4025927];


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


GO
ALTER TABLE [dbo].[T_ENAPLOINFRA] DROP CONSTRAINT [FK_T_21038_4026711];


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


GO
ALTER TABLE [dbo].[T_LATASSERULTTIPUS] DROP CONSTRAINT [FK_T_21038_4025373];


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


GO
ALTER TABLE [dbo].[T_TAGOZATTIPUS] DROP CONSTRAINT [FK_T_21038_4027401];


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


GO
ALTER TABLE [dbo].[T_PARTFILLSTATUS] DROP CONSTRAINT [FK_T_21038_4026163];


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


GO
ALTER TABLE [dbo].[T_MUNKAKORTIPUS] DROP CONSTRAINT [FK_T_21038_4025164];


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


GO
ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] DROP CONSTRAINT [FK_T_21038_2491313];


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


GO
ALTER TABLE [dbo].[T_ORATULAJDONSAGTIPUS] DROP CONSTRAINT [FK_T_21038_4028045];


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


GO
ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] DROP CONSTRAINT [FK_T_21038_4025361];


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


GO
ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] DROP CONSTRAINT [FK_T_21038_4025363];


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


GO
ALTER TABLE [dbo].[T_EVENTTYPE] DROP CONSTRAINT [FK_T_21038_4025902];


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


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] DROP CONSTRAINT [FK_2103802_2103800];


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


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] DROP CONSTRAINT [FK_2103805_2103803];


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


GO
ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] DROP CONSTRAINT [FK_T_21038_2488607];


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


GO
ALTER TABLE [dbo].[T_VALLAS] DROP CONSTRAINT [FK_T_21038_4025362];


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


GO
ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025744];


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


GO
ALTER TABLE [dbo].[T_VEZETOIORASZAMOKTIPUS] DROP CONSTRAINT [FK_T_21038_4027637];


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


GO
ALTER TABLE [dbo].[T_ESLADATTIPUS] DROP CONSTRAINT [FK_T_21038_4026676];


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


GO
ALTER TABLE [dbo].[T_KOZTERULETJELLEG] DROP CONSTRAINT [FK_T_21038_2425121];


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZTATASTIPUSA] DROP CONSTRAINT [FK_T_21038_4027630];


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


GO
ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] DROP CONSTRAINT [FK_T_21038_4027400];


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


GO
ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] DROP CONSTRAINT [FK_T_21038_4026110];


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


GO
ALTER TABLE [dbo].[T_FORMTYPE] DROP CONSTRAINT [FK_T_21038_4025014];


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


GO
ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025745];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGISZINT] DROP CONSTRAINT [FK_T_21038_4027625];


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


GO
ALTER TABLE [dbo].[T_ANYANYELV] DROP CONSTRAINT [FK_T_21038_4025161];


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


GO
ALTER TABLE [dbo].[T_SOROLASOKATIPUS] DROP CONSTRAINT [FK_T_21038_4026543];


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


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] DROP CONSTRAINT [FK_T_21038_539881];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGITIPUS] DROP CONSTRAINT [FK_T_21038_4027623];


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


GO
ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] DROP CONSTRAINT [FK_T_21038_4025162];


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


GO
ALTER TABLE [dbo].[T_IDOKERET] DROP CONSTRAINT [FK_T_21038_4027209];


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


GO
ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] DROP CONSTRAINT [FK_T_21038_4026079];


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


GO
ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] DROP CONSTRAINT [FK_T_21038_4027912];


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


GO
ALTER TABLE [dbo].[T_FEETYPE] DROP CONSTRAINT [FK_T_21038_283802];


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


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] DROP CONSTRAINT [FK_T_21038_4025716];


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


GO
ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] DROP CONSTRAINT [FK_T_21038_3832194];


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


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] DROP CONSTRAINT [FK_T_21038_4025163];


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


GO
ALTER TABLE [dbo].[T_HETNAPJATIPUS] DROP CONSTRAINT [FK_T_21038_4025455];


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] DROP CONSTRAINT [FK_T_21038_2026498];


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


GO
ALTER TABLE [dbo].[T_TANTERVIJELLEG] DROP CONSTRAINT [FK_T_21038_4025337];


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


GO
ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] DROP CONSTRAINT [FK_T_21038_228252];


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


GO
ALTER TABLE [dbo].[T_IGAZOLASTIPUS] DROP CONSTRAINT [FK_T_21038_4025697];


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


GO
ALTER TABLE [dbo].[T_MEGYE] DROP CONSTRAINT [FK_T_21038_3715847];


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


GO
ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] DROP CONSTRAINT [FK_T_21038_4027210];


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


GO
ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] DROP CONSTRAINT [FK_T_21038_4026367];


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


GO
ALTER TABLE [dbo].[T_SCSTICKERSTATUS] DROP CONSTRAINT [FK_T_21038_2026496];


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


GO
ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025290];


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


GO
ALTER TABLE [dbo].[T_EMAILTIPUS] DROP CONSTRAINT [FK_T_21038_48446];


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


GO
ALTER TABLE [dbo].[T_ERETTSEGITANTARGY] DROP CONSTRAINT [FK_T_21038_4027624];


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


GO
ALTER TABLE [dbo].[T_BESOROLASIFOKOZATTIPUS] DROP CONSTRAINT [FK_T_21038_4026357];


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


GO
ALTER TABLE [dbo].[T_ERTESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4025883];


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


GO
ALTER TABLE [dbo].[T_ESZKOZTIPUS] DROP CONSTRAINT [FK_T_21038_4025131];


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


GO
ALTER TABLE [dbo].[T_HETIRENDTIPUS] DROP CONSTRAINT [FK_T_21038_4025453];


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


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] DROP CONSTRAINT [FK_T_21038_1931621];


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


GO
ALTER TABLE [dbo].[T_ESZKOZJELLEG] DROP CONSTRAINT [FK_T_21038_4025292];


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


GO
ALTER TABLE [dbo].[T_TELEFONTIPUS] DROP CONSTRAINT [FK_T_21038_48448];


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


GO
ALTER TABLE [dbo].[T_MULASZTASTIPUS] DROP CONSTRAINT [FK_T_21038_4025677];


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


GO
ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] DROP CONSTRAINT [FK_T_21038_4027208];


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


GO
ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] DROP CONSTRAINT [FK_T_21038_4025132];


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


GO
ALTER TABLE [dbo].[T_NAPTIPUS] DROP CONSTRAINT [FK_T_21038_4025454];


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


GO
ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] DROP CONSTRAINT [FK_T_21038_1768082];


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


GO
ALTER TABLE [dbo].[T_PAYINGTYPE] DROP CONSTRAINT [FK_T_21038_48355];


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


GO
ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4027552];


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


GO
ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] DROP CONSTRAINT [FK_T_21038_4025882];


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


GO
ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] DROP CONSTRAINT [FK_T_21038_4026345];


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] DROP CONSTRAINT [FK_T_21038_4025438];


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


GO
ALTER TABLE [dbo].[T_ESZKOZCEL] DROP CONSTRAINT [FK_T_21038_4025291];


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


GO
ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] DROP CONSTRAINT [FK_T_21038_48368];


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


GO
ALTER TABLE [dbo].[T_ERTEKELESMOD] DROP CONSTRAINT [FK_T_21038_4025675];


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


GO
ALTER TABLE [dbo].[T_HONAPOK] DROP CONSTRAINT [FK_T_21038_3044532];


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


GO
ALTER TABLE [dbo].[T_AGAZATTIPUS] DROP CONSTRAINT [FK_T_21038_4027554];


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


GO
ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] DROP CONSTRAINT [FK_T_21038_4026040];


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


GO
ALTER TABLE [dbo].[T_KRETATIPUS] DROP CONSTRAINT [FK_T_21038_4026341];


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


GO
ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] DROP CONSTRAINT [FK_T_21038_4025289];


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


GO
ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] DROP CONSTRAINT [FK_T_21038_4025097];


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


GO
ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] DROP CONSTRAINT [FK_T_21038_48328];


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


GO
ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] DROP CONSTRAINT [FK_T_21038_4025678];


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


GO
ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] DROP CONSTRAINT [FK_T_21038_4027553];


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


GO
ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] DROP CONSTRAINT [FK_T_21038_4025861];


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


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] DROP CONSTRAINT [FK_T_21038_1364185];


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


GO
ALTER TABLE [dbo].[T_TEREMTIPUS] DROP CONSTRAINT [FK_T_21038_4025095];


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


GO
ALTER TABLE [dbo].[T_NATIONALITY] DROP CONSTRAINT [FK_T_21038_48367];


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


GO
ALTER TABLE [dbo].[T_ERTEKELESTIPUS] DROP CONSTRAINT [FK_T_21038_4025676];


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


GO
ALTER TABLE [dbo].[T_STUDENTCARDTYPE] DROP CONSTRAINT [FK_T_21038_48470];


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


GO
ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] DROP CONSTRAINT [FK_T_21038_4025413];


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


GO
ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] DROP CONSTRAINT [FK_T_21038_4027551];


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


GO
ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] DROP CONSTRAINT [FK_T_21038_4026955];


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


GO
ALTER TABLE [dbo].[T_FENNTARTOTIPUS] DROP CONSTRAINT [FK_T_21038_4025245];


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


GO
ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] DROP CONSTRAINT [FK_T_21038_1312031];


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


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] DROP CONSTRAINT [FK_T_21038_2847546];


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


GO
ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] DROP CONSTRAINT [FK_T_21038_4025094];


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


GO
ALTER TABLE [dbo].[T_MARITALSTATUS] DROP CONSTRAINT [FK_T_21038_48369];


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


GO
ALTER TABLE [dbo].[T_TANULOESEMENY] DROP CONSTRAINT [FK_4025699_4025708];


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


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] DROP CONSTRAINT [FK_402569802_402569800];


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


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] DROP CONSTRAINT [FK_402569805_402569803];


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


GO
ALTER TABLE [dbo].[T_NAPTARINAP] DROP CONSTRAINT [FK_4025562_4025567];


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


GO
ALTER TABLE [dbo].[T_NAPTARINAP] DROP CONSTRAINT [FK_4025562_4026272];


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


GO
ALTER TABLE [dbo].[T_TANEVRENDJE] DROP CONSTRAINT [FK_4025441_4025447];


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


GO
ALTER TABLE [dbo].[T_NAPTIPUS] DROP CONSTRAINT [FK_402543902_402543900];


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


GO
ALTER TABLE [dbo].[T_NAPTIPUS] DROP CONSTRAINT [FK_402543905_402543903];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4027977_4027984];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4027977_4027986];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4028002_4028000];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4028005_4028003];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4028016_4028015];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4028032_4028030];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4028035_4028033];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_4028041_4028039];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_402797702_402797700];


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


GO
ALTER TABLE [dbo].[T_TANORA] DROP CONSTRAINT [FK_402797705_402797703];


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


GO
ALTER TABLE [dbo].[T_TANORAORATULAJDONSAG] DROP CONSTRAINT [FK_4028011_4028009];


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


GO
ALTER TABLE [dbo].[T_TANORA_OSZTALYCSOPORT] DROP CONSTRAINT [FK_4028043_4028042];


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


GO
ALTER TABLE [dbo].[T_TANORA_OSZTALYCSOPORT] DROP CONSTRAINT [FK_4028044_4028042];


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


GO
DROP TABLE [dbo].[T_TANORA_OSZTALYCSOPORT];


GO
PRINT N'Starting rebuilding table [dbo].[T_CSOPORTTIPUS]...';


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_CSOPORTTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ISTANORAICELU]      CHAR (1) DEFAULT ('F') NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          INT      NOT NULL,
    [TOROLT]               CHAR (1) DEFAULT ('F') NOT NULL,
    [SERIAL]               INT      DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]          DATETIME DEFAULT (getdate()) NOT NULL,
    [CREATED]              DATETIME DEFAULT (getdate()) NOT NULL,
    [MODIFIER]             INT      NULL,
    [CREATOR]              INT      NULL,
    [ELOZOTANEVIREKORDID]  INT      NULL,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40251911] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_CSOPORTTIPUS])
    BEGIN
        INSERT INTO [dbo].[tmp_ms_xx_T_CSOPORTTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [ELOZOTANEVIREKORDIDA], [NNID])
        SELECT   [ID],
                 [C_ALINTEZMENYID],
                 [C_ALTANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [ELOZOTANEVIREKORDIDA],
                 [NNID]
        FROM     [dbo].[T_CSOPORTTIPUS]
        ORDER BY [ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC;
    END

DROP TABLE [dbo].[T_CSOPORTTIPUS];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_CSOPORTTIPUS]', N'T_CSOPORTTIPUS';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40251911]', N'PK_T_4025191', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_CSOPORTTIPUS].[I_T_402519102_402519100]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402519102_402519100]
    ON [dbo].[T_CSOPORTTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_CSOPORTTIPUS].[I_T_402519105_402519103]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402519105_402519103]
    ON [dbo].[T_CSOPORTTIPUS]([C_ALTANEVID] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYTYPE]...';


GO
CREATE TABLE [dbo].[T_DICTIONARYTYPE] (
    [ID]                    INT            IDENTITY (1, 1) NOT NULL,
    [C_CODENAME]            NVARCHAR (30)  NOT NULL,
    [C_DESCRIPTION]         NVARCHAR (255) NULL,
    [C_ISCOLOREDITABLE]     CHAR (1)       NOT NULL,
    [C_ISCUSTOMITEMALLOWED] CHAR (1)       NOT NULL,
    [C_NAME]                NVARCHAR (50)  NOT NULL,
    [C_INTEZMENYID]         INT            NOT NULL,
    [C_TANEVID]             INT            NOT NULL,
    [TOROLT]                CHAR (1)       NOT NULL,
    [SERIAL]                INT            NOT NULL,
    [LASTCHANGED]           DATETIME       NOT NULL,
    [CREATED]               DATETIME       NOT NULL,
    [MODIFIER]              INT            NULL,
    [CREATOR]               INT            NULL,
    [ELOZOTANEVIREKORDID]   INT            NULL,
    [NNID]                  INT            NULL,
    CONSTRAINT [PK_T_4028083] PRIMARY KEY CLUSTERED ([C_INTEZMENYID], [C_TANEVID], [ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_DICTIONARYTYPE].[I_T_402808302_402808300]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402808302_402808300]
    ON [dbo].[T_DICTIONARYTYPE]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYTYPE].[I_T_402808305_402808303]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402808305_402808303]
    ON [dbo].[T_DICTIONARYTYPE]([C_TANEVID] ASC);


GO
PRINT N'Creating unnamed constraint on [dbo].[T_DICTIONARYTYPE]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE]
    ADD DEFAULT ('F') FOR [C_ISCOLOREDITABLE];


GO
PRINT N'Creating unnamed constraint on [dbo].[T_DICTIONARYTYPE]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE]
    ADD DEFAULT ('F') FOR [C_ISCUSTOMITEMALLOWED];


GO
PRINT N'Creating unnamed constraint on [dbo].[T_DICTIONARYTYPE]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE]
    ADD DEFAULT (getdate()) FOR [CREATED];


GO
PRINT N'Creating unnamed constraint on [dbo].[T_DICTIONARYTYPE]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE]
    ADD DEFAULT ('F') FOR [TOROLT];


GO
PRINT N'Creating unnamed constraint on [dbo].[T_DICTIONARYTYPE]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE]
    ADD DEFAULT ((0)) FOR [SERIAL];


GO
PRINT N'Creating unnamed constraint on [dbo].[T_DICTIONARYTYPE]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE]
    ADD DEFAULT (getdate()) FOR [LASTCHANGED];


CREATE UNIQUE INDEX UK_DICTIONARYTYPE_INTEZMENYID_TANEVID_CODENAME ON [dbo].[T_DICTIONARYTYPE] (C_INTEZMENYID, C_TANEVID, C_CODENAME) WHERE TOROLT = 'F'

--SELECT
--   ROW_NUMBER() OVER (ORDER BY x.ID) AS ID
--  ,x.C_TYPE AS C_CODENAME
--  ,x.C_TYPE AS C_NAME
--  ,NULL AS C_DESCRIPTION
--  ,'F' AS C_ISCOLORENABLED
--  ,'F' AS C_ISCUSTOMITEMALLOWED
--INTO #DictionaryTypeTemp
--FROM (
--  SELECT MIN(ID) AS ID, C_TYPE 
--  FROM T_DICTIONARYITEMBASE
--  GROUP BY C_TYPE
--) x

DECLARE @DictionaryTypeTemp TABLE (ID int, C_CODENAME nvarchar(255), C_NAME nvarchar(255), C_DESCRIPTION nvarchar(255), C_ISCOLOREDITABLE nvarchar(1), C_ISCUSTOMITEMALLOWED nvarchar(1))

INSERT INTO @DictionaryTypeTemp
(ID, C_CODENAME, C_NAME, C_DESCRIPTION, C_ISCOLOREDITABLE, C_ISCUSTOMITEMALLOWED) VALUES
(1, N'Nem', N'Felhasználó neme', NULL, 'F', 'F'), 
(2, N'IngyenesTankonyvEllatas', N'Ingyenes tankönyvellátás típusa', NULL, 'F', 'F'), 
(3, N'MessageStatus', N'Message státusz', NULL, 'F', 'F'), 
(4, N'EsemenyStatusz', N'Esemény státuszok', NULL, 'F', 'F'), 
(5, N'SMSMessageStatus', N'SMS message státusz', NULL, 'F', 'F'), 
(6, N'EszkozTipus', N'Eszköz típus', NULL, 'F', 'F'), 
(7, N'EszkozKategoria', N'Eszköz kategória', NULL, 'F', 'F'), 
(8, N'TeremTipus', N'Terem típusai', NULL, 'F', 'F'), 
(9, N'Allampolgarsag', N'Állampolgárság', NULL, 'F', 'F'), 
(10, N'Anyanyelv', N'Anyanyelv', NULL, 'F', 'F'), 
(11, N'IgazolvanyTipus', N'Igazolvány típusok', NULL, 'F', 'F'), 
(12, N'MunkakorTipus', N'MunkakorTipus', NULL, 'F', 'F'), 
(13, N'MunkaviszonyTipus', N'Munkakör típusok', NULL, 'F', 'F'), 
(14, N'MagantanulosagOka', N'Magántanulóság okai', NULL, 'F', 'F'), 
(15, N'OrszagTipus', N'Országok', NULL, 'F', 'F'), 
(16, N'CimTipus', N'Címek típusai', NULL, 'F', 'F'), 
(17, N'KozteruletJelleg', N'Közterület jellege', NULL, 'F', 'F'), 
(18, N'RokonsagiFok', N'Rokonsági fokok', NULL, 'F', 'F'), 
(19, N'FenntartoTipus', N'Fenntartó típusai', NULL, 'F', 'F'), 
(20, N'TelefonTipus', N'Telefon típusai', NULL, 'F', 'F'), 
(21, N'EmailTipus', N'E-mail típusai', NULL, 'F', 'F'), 
(22, N'CsoportTipus', N'Csoport típusok', NULL, 'F', 'F'), 
(23, N'EszkozJelleg', N'Eszköz jellegek', NULL, 'F', 'F'), 
(24, N'EszkozCel', N'Eszköz céljai', NULL, 'F', 'F'), 
(25, N'MertekegysegTipus', N'Mértékegységek', NULL, 'F', 'F'), 
(26, N'TestnevelesTipus', N'Testnevelés típusok', NULL, 'F', 'F'), 
(27, N'TanterviJelleg', N'Tantervi jellegek', NULL, 'F', 'F'), 
(28, N'EtkezesiKedvezmenyTipus', N'Étkezési kedvezmény típusok', NULL, 'F', 'F'), 
(29, N'HatranyosHelyzetTipus', N'Hátrányos helyzet típusok', NULL, 'F', 'F'), 
(30, N'Vallas', N'Vallások', NULL, 'F', 'F'), 
(31, N'ErtelmiFogyatekosTipus', N'Értelmi fogyatékos típusok', NULL, 'F', 'F'), 
(32, N'HallasserultTipus', N'Hallássérült típusok', NULL, 'F', 'F'), 
(33, N'LatasserultTipus', N'Látássérült típusok', NULL, 'F', 'F'), 
(34, N'DiakigazolvanyIgenyTipus', N'Diákigazolvány igény típusok', NULL, 'F', 'F'), 
(35, N'OktatasiNevelesiFeladat', N'Oktatási-nevelési feladatok', NULL, 'F', 'F'), 
(36, N'TargyKategoriaTipus', N'Tárgy kategóriák', NULL, 'F', 'F'), 
(37, N'EvfolyamTipus', N'Évfolyam típusok', NULL, 'F', 'F'), 
(38, N'FoglalkozasTipus', N'Foglalkozás típusok', NULL, 'F', 'F'), 
(39, N'NapTipus', N'Nap típusok', NULL, 'F', 'F'), 
(40, N'HetNapjaTipus', N'Hét napjai', NULL, 'F', 'F'), 
(41, N'SorolasOkaTipus', N'Be/kisorolás okok', NULL, 'F', 'F'), 
(42, N'HelyettesitesTipus', N'Helyettesítés típus', NULL, 'F', 'F'), 
(43, N'MulasztasTipus', N'Mulasztás típusok', NULL, 'F', 'F'), 
(44, N'OsztalyzatTipus', N'Osztályzat', NULL, 'F', 'F'), 
(45, N'ErtekelesMod', N'Értékelés módjai', NULL, 'F', 'F'), 
(46, N'ErtekelesTipus', N'Értékelés típusai', NULL, 'F', 'F'), 
(47, N'IgazolasTipus', N'Igazolás típusok', NULL, 'F', 'F'), 
(48, N'EsemenyTipus', N'Esemény típusok', NULL, 'F', 'F'), 
(49, N'HetiRendTipus', N'Heti rend típusai', NULL, 'F', 'F'), 
(50, N'MagatartasErtekelesTipus', N'Magatartás típusok', NULL, 'F', 'F'), 
(51, N'SzorgalomErtekelesTipus', N'Szorgalom típusok', NULL, 'F', 'F'), 
(52, N'DiakigazolvanyIgenyStatusz', N'Diákigazolvány igénylés státuszok', NULL, 'F', 'F'), 
(53, N'EletpalyamodellFokozatTipus', N'Pedagógus életpályamodell fokozatok', NULL, 'F', 'F'), 
(54, N'EletpalyamodellStatuszok', N'Pedagógus életpályamodell portfólió státuszok', NULL, 'F', 'F'), 
(55, N'Honapok', N'Hónapok', NULL, 'F', 'F'), 
(56, N'ErtesitesSzinTipus', N'Értesítés színtípusok', NULL, 'F', 'F'), 
(57, N'ErtesitesTipus', N'Értesítés típusok', NULL, 'F', 'F'), 
(58, N'TevekenysegTipus', N'Tevékenységek típusai', NULL, 'F', 'F'), 
(59, N'KizaroCsoportTipus', N'Kizáró csoport típusa', NULL, 'F', 'F'), 
(60, N'MulasztasStatisztikaTipus', N'Mulasztás statisztika típusok', NULL, 'F', 'F'), 
(61, N'RendszerBeallitasTipus', N'Rendszer beállítás típusok', NULL, 'F', 'F'), 
(62, N'SystemSettingsControlType', N'Rendszer beállításokhoz használt vezérlő típusok', NULL, 'F', 'F'), 
(63, N'ImpositionStatus', N'Kiírt tétel státusza', NULL, 'F', 'F'), 
(64, N'PartfillStatus', N'Pénzügyi részteljesítés státuszai', NULL, 'F', 'F'), 
(65, N'PayingType', N'Pénzügyi fizetés típusai', NULL, 'F', 'F'), 
(66, N'TransactionStatus', N'Pénzügyi tranzakció státuszai', NULL, 'F', 'F'), 
(67, N'SzerepkorTipus', N'Szerepkör típusok', NULL, 'F', 'F'), 
(68, N'KretaTipus', N'Kréta típus', NULL, 'F', 'F'), 
(69, N'PedagogusStatusz', N'Pedagógus státusz', NULL, 'F', 'F'), 
(70, N'BesorolasiFokozatTipus', N'Besorolási fokozat', NULL, 'F', 'F'), 
(71, N'MunkaidoKedvezmenyOka', N'Feladattal terhelt óraszám oka', NULL, 'F', 'F'), 
(72, N'ESLAdatTipus', N'ESL adat típus', NULL, 'F', 'F'), 
(73, N'ENaploTipus', N'Elektronikus napló típusa', NULL, 'F', 'F'), 
(74, N'ENaploInfra', N'Elektronikus napló infrastruktúrája', NULL, 'F', 'F'), 
(75, N'ENaploForras', N'Elektronikus napló forrása', NULL, 'F', 'F'), 
(76, N'SzerzodoSzemelyPozicio', N'Szerződő személy pozíciója', NULL, 'F', 'F'), 
(77, N'HibajegyStatusz', N'Hibajegy státusz', NULL, 'F', 'F'), 
(78, N'Prioritas', N'Prioritás', NULL, 'F', 'F'), 
(79, N'Forras', N'Forrás', NULL, 'F', 'F'), 
(80, N'Idokeret', N'Időkeret', NULL, 'F', 'F'), 
(81, N'OsszegTullepesTipus', N'Összeg túllépés típusa', NULL, 'F', 'F'), 
(82, N'EPenztarcaTetelStatusz', N'Elektronikus pénztárca tétel státusz', NULL, 'F', 'F'), 
(83, N'TagozatTipus', N'Tagozat típus', NULL, 'F', 'F'), 
(84, N'FelvetelStatuszaTipus', N'Felvétel státusza', NULL, 'F', 'F'), 
(85, N'ENaploHasznalat', N'Használnak-e az intézményben elektronikus naplót?', NULL, 'F', 'F'), 
(86, N'IKTKompetenciaSzint', N'IKT kompetencia szint', NULL, 'F', 'F'), 
(87, N'IKTEszkozhasznalatMod', N'IKT eszközhasználat módja', NULL, 'F', 'F'), 
(88, N'ElsodlegesIKTEszkoz', N'Pedagógus elsődleges IKT eszköze', NULL, 'F', 'F'), 
(89, N'WiFiEleres', N'WiFi elérés', NULL, 'F', 'F'), 
(90, N'MukodesiHelyTipus', N'Működési hely típus', NULL, 'F', 'F'), 
(91, N'AgazatTipus', N'Ágazat', NULL, 'F', 'F'), 
(92, N'SzakkepesitesTipus', N'Szakképesítés', NULL, 'F', 'F'), 
(93, N'SzakmacsoportTipus', N'Szakmacsoport', NULL, 'F', 'F'), 
(94, N'ReszszakkepesitesTipus', N'Részszakképesítés', NULL, 'F', 'F'), 
(95, N'FoglalkoztatasTipusa', N'Foglalkoztatás típusa', NULL, 'F', 'F'), 
(96, N'VezetoiOraszamokTipus', N'Vezetői óraszám típusa', NULL, 'F', 'F'), 
(97, N'ErettsegiSzint', N'Érettségi szint', NULL, 'F', 'F'), 
(98, N'ErettsegiTipus', N'Érettségi tipus', NULL, 'F', 'F'), 
(99, N'ErettsegiTantargy', N'Érettségi tantárgy', NULL, 'F', 'F'), 
(100, N'OgFoglaltsagTipus', N'Órarend szerkesztő foglaltság típus', NULL, 'F', 'F'), 
(101, N'KozossegiszolgalatTipus', N'Közösségi szolgálat típus', NULL, 'F', 'F'), 
(102, N'OraTulajdonsagTipus', N'Óra tulajdonság típus', NULL, 'F', 'F')

SET IDENTITY_INSERT T_DICTIONARYTYPE ON

INSERT INTO T_DICTIONARYTYPE (ID, C_CODENAME, C_DESCRIPTION, C_ISCOLOREDITABLE, C_ISCUSTOMITEMALLOWED, C_NAME, C_INTEZMENYID, C_TANEVID)
SELECT
   a.ID
  ,a.C_CODENAME
  ,a.C_DESCRIPTION
  ,a.C_ISCOLOREDITABLE
  ,a.C_ISCUSTOMITEMALLOWED
  ,a.C_NAME
  ,t.C_INTEZMENYID
  ,t.ID AS C_TANEVID
FROM @DictionaryTypeTemp a
CROSS JOIN T_TANEV t

SET IDENTITY_INSERT T_DICTIONARYTYPE OFF

GO
PRINT N'Starting rebuilding table [dbo].[T_DICTIONARYITEMBASE]...';


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] (
    [ID]                  INT            IDENTITY (1, 1) NOT NULL,
    [C_VALUE]             INT            NULL,
    [C_NAME]              NVARCHAR (250) NOT NULL,
    [C_NAME_1]            NVARCHAR (250) NULL,
    [C_NAME_2]            NVARCHAR (250) NULL,
    [C_NAME_3]            NVARCHAR (250) NULL,
    [C_NAME_4]            NVARCHAR (250) NULL,
    [C_VISIBLE]           CHAR (1)       DEFAULT ('T') NOT NULL,
    [C_CODE]              NVARCHAR (20)  NULL,
    [C_TYPE]              NVARCHAR (32)  NOT NULL,
    [C_PROTECTED]         CHAR (1)       DEFAULT ('T') NOT NULL,
    [C_COLOR]             NVARCHAR (6)   NULL,
    [C_ORDER]             INT            NULL,
    [C_BGCOLOR]           NVARCHAR (6)   NULL,
    [C_DESCRIPTION]       NVARCHAR (255) NULL,
    [C_ISACTIVE]          CHAR (1)       DEFAULT ('T') NOT NULL,
    [C_SHORTNAME]         NVARCHAR (30)  NULL,
    [C_DICTIONARYTYPEID]  INT            NOT NULL,
    [C_INTEZMENYID]       INT            NOT NULL,
    [C_TANEVID]           INT            NOT NULL,
    [TOROLT]              CHAR (1)       DEFAULT ('F') NOT NULL,
    [SERIAL]              INT            DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]         DATETIME       DEFAULT (getdate()) NOT NULL,
    [CREATED]             DATETIME       DEFAULT (getdate()) NOT NULL,
    [MODIFIER]            INT            NULL,
    [CREATOR]             INT            NULL,
    [ELOZOTANEVIREKORDID] INT            NULL,
    [NNID]                INT            NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_210381] PRIMARY KEY CLUSTERED ([ID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC)
);


IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_DICTIONARYITEMBASE])
    BEGIN
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] ON;
        INSERT INTO [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID], [C_VALUE], [C_NAME], [C_NAME_1], [C_NAME_2], [C_NAME_3], [C_NAME_4], [C_VISIBLE], [C_CODE], [C_TYPE], [C_PROTECTED], [C_COLOR], [C_ORDER], [C_DICTIONARYTYPEID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [NNID])
        SELECT   [T_DICTIONARYITEMBASE].[ID],
                 [T_DICTIONARYITEMBASE].[C_INTEZMENYID],
                 [T_DICTIONARYITEMBASE].[C_TANEVID],
                 [C_VALUE],
                 [T_DICTIONARYITEMBASE].[C_NAME],
                 [C_NAME_1],
                 [C_NAME_2],
                 [C_NAME_3],
                 [C_NAME_4],
                 [C_VISIBLE],
                 [C_CODE],
                 [C_TYPE],
                 [C_PROTECTED],
                 [C_COLOR],
                 [C_ORDER],
				 DictType.ID,
                 [T_DICTIONARYITEMBASE].[TOROLT],
                 [T_DICTIONARYITEMBASE].[SERIAL],
                 [T_DICTIONARYITEMBASE].[LASTCHANGED],
                 [T_DICTIONARYITEMBASE].[CREATED],
                 [T_DICTIONARYITEMBASE].[MODIFIER],
                 [T_DICTIONARYITEMBASE].[CREATOR],
                 [T_DICTIONARYITEMBASE].[ELOZOTANEVIREKORDID],
                 [T_DICTIONARYITEMBASE].[NNID]
        FROM     [dbo].[T_DICTIONARYITEMBASE]
		  INNER JOIN T_DICTIONARYTYPE DictType ON DictType.C_CODENAME = [T_DICTIONARYITEMBASE].C_TYPE
            AND DictType.C_INTEZMENYID = [T_DICTIONARYITEMBASE].C_INTEZMENYID
            AND DictType.C_TANEVID = [T_DICTIONARYITEMBASE].C_TANEVID
        ORDER BY [T_DICTIONARYITEMBASE].[ID] ASC, [T_DICTIONARYITEMBASE].[C_INTEZMENYID] ASC, [T_DICTIONARYITEMBASE].[C_TANEVID] ASC;
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE] OFF;
    END

DROP TABLE [dbo].[T_DICTIONARYITEMBASE];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_DICTIONARYITEMBASE]', N'T_DICTIONARYITEMBASE';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_210381]', N'PK_T_21038', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[I_T_21038_1]...';


GO
CREATE NONCLUSTERED INDEX [I_T_21038_1]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_NAME] ASC, [C_TYPE] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[I_T_4028090_4028089]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028090_4028089]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_DICTIONARYTYPEID] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[I_T_2103802_2103800]...';


GO
CREATE NONCLUSTERED INDEX [I_T_2103802_2103800]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[I_T_2103805_2103803]...';


GO
CREATE NONCLUSTERED INDEX [I_T_2103805_2103803]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_TANEVID] ASC);


GO
PRINT N'Creating [dbo].[T_DICTIONARYITEMBASE].[UK_41498_3561258]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_41498_3561258]
    ON [dbo].[T_DICTIONARYITEMBASE]([C_NAME] ASC, [C_TYPE] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


GO
PRINT N'Starting rebuilding table [dbo].[T_ESEMENYTIPUS]...';


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_ESEMENYTIPUS] (
    [ID]                         INT      NOT NULL,
    [C_ISELLENORZOBENMEGJELENIK] CHAR (1) DEFAULT ('F') NOT NULL,
    [C_ISNAPLOBANMEGJELENIK]     CHAR (1) DEFAULT ('F') NOT NULL,
    [C_ISTORZSLAPONMEGJELENIK]   CHAR (1) DEFAULT ('F') NOT NULL,
    [C_ALINTEZMENYID]            INT      NOT NULL,
    [C_ALTANEVID]                INT      NOT NULL,
    [TOROLT]                     CHAR (1) DEFAULT ('F') NOT NULL,
    [SERIAL]                     INT      DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]                DATETIME DEFAULT (getdate()) NOT NULL,
    [CREATED]                    DATETIME DEFAULT (getdate()) NOT NULL,
    [MODIFIER]                   INT      NULL,
    [CREATOR]                    INT      NULL,
    [ELOZOTANEVIREKORDID]        INT      NULL,
    [ELOZOTANEVIREKORDIDA]       INT      NULL,
    [NNID]                       INT      NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40256981] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_ESEMENYTIPUS])
    BEGIN
        INSERT INTO [dbo].[tmp_ms_xx_T_ESEMENYTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [ELOZOTANEVIREKORDIDA], [NNID])
        SELECT   [ID],
                 [C_ALINTEZMENYID],
                 [C_ALTANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [ELOZOTANEVIREKORDIDA],
                 [NNID]
        FROM     [dbo].[T_ESEMENYTIPUS]
        ORDER BY [ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC;
    END

DROP TABLE [dbo].[T_ESEMENYTIPUS];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_ESEMENYTIPUS]', N'T_ESEMENYTIPUS';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40256981]', N'PK_T_4025698', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_ESEMENYTIPUS].[I_T_402569802_402569800]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402569802_402569800]
    ON [dbo].[T_ESEMENYTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_ESEMENYTIPUS].[I_T_402569805_402569803]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402569805_402569803]
    ON [dbo].[T_ESEMENYTIPUS]([C_ALTANEVID] ASC);


GO
PRINT N'Starting rebuilding table [dbo].[T_NAPTIPUS]...';


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_NAPTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ISSORSZAMOZANDO]    CHAR (1) DEFAULT ('F') NOT NULL,
    [C_ISTANITASINAP]      CHAR (1) DEFAULT ('F') NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          INT      NOT NULL,
    [TOROLT]               CHAR (1) DEFAULT ('F') NOT NULL,
    [SERIAL]               INT      DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]          DATETIME DEFAULT (getdate()) NOT NULL,
    [CREATED]              DATETIME DEFAULT (getdate()) NOT NULL,
    [MODIFIER]             INT      NULL,
    [CREATOR]              INT      NULL,
    [ELOZOTANEVIREKORDID]  INT      NULL,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40254391] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_NAPTIPUS])
    BEGIN
        INSERT INTO [dbo].[tmp_ms_xx_T_NAPTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [ELOZOTANEVIREKORDIDA], [NNID])
        SELECT   [ID],
                 [C_ALINTEZMENYID],
                 [C_ALTANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [ELOZOTANEVIREKORDIDA],
                 [NNID]
        FROM     [dbo].[T_NAPTIPUS]
        ORDER BY [ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC;
    END

DROP TABLE [dbo].[T_NAPTIPUS];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_NAPTIPUS]', N'T_NAPTIPUS';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40254391]', N'PK_T_4025439', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_NAPTIPUS].[I_T_402543902_402543900]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402543902_402543900]
    ON [dbo].[T_NAPTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_NAPTIPUS].[I_T_402543905_402543903]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402543905_402543903]
    ON [dbo].[T_NAPTIPUS]([C_ALTANEVID] ASC);


GO
PRINT N'Starting rebuilding table [dbo].[T_TANORA]...';


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_TANORA] (
    [ID]                    INT             IDENTITY (1, 1) NOT NULL,
    [C_ADMINALTALKIIRT]     CHAR (1)        DEFAULT ('F') NOT NULL,
    [C_CSENGETESIRENDID]    INT             NULL,
    [C_CSENGETESIRENDORAID] INT             NULL,
    [C_ELMARADTORA]         CHAR (1)        DEFAULT ('F') NOT NULL,
    [C_HAZIFELADAT]         NVARCHAR (MAX)  NULL,
    [C_HELYETTESITESOKA]    NVARCHAR (1000) NULL,
    [C_HELYETTESITESTIPUSA] INT             NULL,
    [C_HELYETTESITETT]      CHAR (1)        DEFAULT ('F') NOT NULL,
    [C_HETNAPJA]            INT             NULL,
    [C_MEGJEGYZES]          NVARCHAR (1000) NULL,
    [C_MOBILNAPLOZOTT]      CHAR (1)        DEFAULT ('F') NOT NULL,
    [C_NAPLOZASIDEJE]       DATETIME        NULL,
    [C_NAPLOZOTT]           CHAR (1)        DEFAULT ('F') NOT NULL,
    [C_ORAKEZDETE]          DATETIME        NOT NULL,
    [C_ORAOSSZEVONASID]     INT             NULL,
    [C_ORASZAM]             INT             NOT NULL,
    [C_ORAVEGE]             DATETIME        NOT NULL,
    [C_SORSZAMOZANDO]       CHAR (1)        DEFAULT ('T') NOT NULL,
    [C_TEMA]                NVARCHAR (1000) NULL,
    [C_TANMENETID]          INT             NULL,
    [C_TANTARGYID]          INT             NULL,
    [C_ORARENDID]           INT             NULL,
    [C_TANARID]             INT             NULL,
    [C_HELYETTESITOTANARID] INT             NULL,
    [C_TEREMID]             INT             NULL,
    [C_OSZTALYCSOPORTID]    INT             NULL,
    [C_INTEZMENYID]         INT             NOT NULL,
    [C_TANEVID]             INT             NOT NULL,
    [TOROLT]                CHAR (1)        DEFAULT ('F') NOT NULL,
    [SERIAL]                INT             DEFAULT ((0)) NOT NULL,
    [LASTCHANGED]           DATETIME        DEFAULT (getdate()) NOT NULL,
    [CREATED]               DATETIME        DEFAULT (getdate()) NOT NULL,
    [MODIFIER]              INT             NULL,
    [CREATOR]               INT             NULL,
    [ELOZOTANEVIREKORDID]   INT             NULL,
    [NNID]                  INT             NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40279771] PRIMARY KEY CLUSTERED ([ID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_TANORA])
    BEGIN
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_TANORA] ON;
        INSERT INTO [dbo].[tmp_ms_xx_T_TANORA] ([ID], [C_ADMINALTALKIIRT], [C_CSENGETESIRENDID], [C_CSENGETESIRENDORAID], [C_ELMARADTORA], [C_HAZIFELADAT], [C_HELYETTESITESOKA], [C_HELYETTESITESTIPUSA], [C_HELYETTESITETT], [C_HETNAPJA], [C_MEGJEGYZES], [C_MOBILNAPLOZOTT], [C_NAPLOZASIDEJE], [C_NAPLOZOTT], [C_ORAKEZDETE], [C_ORAOSSZEVONASID], [C_ORASZAM], [C_ORAVEGE], [C_SORSZAMOZANDO], [C_TEMA], [C_TANMENETID], [C_TANTARGYID], [C_ORARENDID], [C_TANARID], [C_HELYETTESITOTANARID], [C_TEREMID], [C_INTEZMENYID], [C_TANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [NNID])
        SELECT   [ID],
                 [C_ADMINALTALKIIRT],
                 [C_CSENGETESIRENDID],
                 [C_CSENGETESIRENDORAID],
                 [C_ELMARADTORA],
                 [C_HAZIFELADAT],
                 [C_HELYETTESITESOKA],
                 [C_HELYETTESITESTIPUSA],
                 [C_HELYETTESITETT],
                 [C_HETNAPJA],
                 [C_MEGJEGYZES],
                 [C_MOBILNAPLOZOTT],
                 [C_NAPLOZASIDEJE],
                 [C_NAPLOZOTT],
                 [C_ORAKEZDETE],
                 [C_ORAOSSZEVONASID],
                 [C_ORASZAM],
                 [C_ORAVEGE],
                 [C_SORSZAMOZANDO],
                 [C_TEMA],
                 [C_TANMENETID],
                 [C_TANTARGYID],
                 [C_ORARENDID],
                 [C_TANARID],
                 [C_HELYETTESITOTANARID],
                 [C_TEREMID],
                 [C_INTEZMENYID],
                 [C_TANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [NNID]
        FROM     [dbo].[T_TANORA]
        ORDER BY [ID] ASC;
        SET IDENTITY_INSERT [dbo].[tmp_ms_xx_T_TANORA] OFF;
    END

DROP TABLE [dbo].[T_TANORA];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_TANORA]', N'T_TANORA';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40279771]', N'PK_T_4027977', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4027977_4027984]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027977_4027984]
    ON [dbo].[T_TANORA]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_HELYETTESITESTIPUSA] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4027977_4027986]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027977_4027986]
    ON [dbo].[T_TANORA]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_HETNAPJA] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4028002_4028000]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028002_4028000]
    ON [dbo].[T_TANORA]([C_TANMENETID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4028005_4028003]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028005_4028003]
    ON [dbo].[T_TANORA]([C_TANTARGYID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4028016_4028015]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028016_4028015]
    ON [dbo].[T_TANORA]([C_ORARENDID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4028032_4028030]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028032_4028030]
    ON [dbo].[T_TANORA]([C_TANARID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4028035_4028033]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028035_4028033]
    ON [dbo].[T_TANORA]([C_HELYETTESITOTANARID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4028041_4028039]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028041_4028039]
    ON [dbo].[T_TANORA]([C_TEREMID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_4028044_4028042]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028044_4028042]
    ON [dbo].[T_TANORA]([C_OSZTALYCSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_402797702_402797700]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402797702_402797700]
    ON [dbo].[T_TANORA]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_TANORA].[I_T_402797705_402797703]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402797705_402797703]
    ON [dbo].[T_TANORA]([C_TANEVID] ASC);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025243]...';


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025243] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_402519102_402519100]...';


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402519102_402519100] FOREIGN KEY ([C_ALINTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402519105_402519103]...';


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402519105_402519103] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4025392_4025393]...';


GO
ALTER TABLE [dbo].[T_TANTERV] WITH NOCHECK
    ADD CONSTRAINT [FK_4025392_4025393] FOREIGN KEY ([C_CSOPORTTIPUSA], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_CSOPORTTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4026541_4026540]...';


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS_FOGLALKOZASTIPU] WITH NOCHECK
    ADD CONSTRAINT [FK_4026541_4026540] FOREIGN KEY ([C_CSOPORTTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_CSOPORTTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025277_4025300]...';


GO
ALTER TABLE [dbo].[T_CSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_4025277_4025300] FOREIGN KEY ([C_TIPUSA], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_CSOPORTTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4026005_4026006]...';


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_4026005_4026006] FOREIGN KEY ([C_CSOPORTOKTIPUSA], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_CSOPORTTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025414]...';


GO
ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025414] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027517]...';


GO
ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027517] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027832]...';


GO
ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027832] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026956]...';


GO
ALTER TABLE [dbo].[T_PRIORITAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026956] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1291259]...';


GO
ALTER TABLE [dbo].[T_ORSZAGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1291259] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2846551]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2846551] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48373]...';


GO
ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48373] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027466]...';


GO
ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027466] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026039]...';


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026039] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026954]...';


GO
ALTER TABLE [dbo].[T_FORRAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026954] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025189]...';


GO
ALTER TABLE [dbo].[T_ROKONSAGIFOK] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025189] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48362]...';


GO
ALTER TABLE [dbo].[T_LANGUAGE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48362] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027468]...';


GO
ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027468] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025811]...';


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025811] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026714]...';


GO
ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026714] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2740820]...';


GO
ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2740820] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48323]...';


GO
ALTER TABLE [dbo].[T_CIMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48323] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025640]...';


GO
ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025640] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025812]...';


GO
ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025812] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1257632]...';


GO
ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1257632] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026713]...';


GO
ALTER TABLE [dbo].[T_ENAPLOTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026713] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48370]...';


GO
ALTER TABLE [dbo].[T_NEM] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48370] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48468]...';


GO
ALTER TABLE [dbo].[T_ERRORTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48468] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025391]...';


GO
ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025391] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027469]...';


GO
ALTER TABLE [dbo].[T_WIFIELERES] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027469] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025798]...';


GO
ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025798] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1029472]...';


GO
ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1029472] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026712]...';


GO
ALTER TABLE [dbo].[T_ENAPLOFORRAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026712] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025374]...';


GO
ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025374] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027465]...';


GO
ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027465] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026190]...';


GO
ALTER TABLE [dbo].[T_SZEREPKORTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026190] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025375]...';


GO
ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025375] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027467]...';


GO
ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027467] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025927]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025927] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026711]...';


GO
ALTER TABLE [dbo].[T_ENAPLOINFRA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026711] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025373]...';


GO
ALTER TABLE [dbo].[T_LATASSERULTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025373] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027401]...';


GO
ALTER TABLE [dbo].[T_TAGOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027401] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026163]...';


GO
ALTER TABLE [dbo].[T_PARTFILLSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026163] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025164]...';


GO
ALTER TABLE [dbo].[T_MUNKAKORTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025164] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2491313]...';


GO
ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2491313] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4028045]...';


GO
ALTER TABLE [dbo].[T_ORATULAJDONSAGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4028045] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025361]...';


GO
ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025361] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025363]...';


GO
ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025363] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025902]...';


GO
ALTER TABLE [dbo].[T_EVENTTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025902] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_2103802_2103800]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH NOCHECK
    ADD CONSTRAINT [FK_2103802_2103800] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_2103805_2103803]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH NOCHECK
    ADD CONSTRAINT [FK_2103805_2103803] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2488607]...';


GO
ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2488607] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025362]...';


GO
ALTER TABLE [dbo].[T_VALLAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025362] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025744]...';


GO
ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025744] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027637]...';


GO
ALTER TABLE [dbo].[T_VEZETOIORASZAMOKTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027637] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026676]...';


GO
ALTER TABLE [dbo].[T_ESLADATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026676] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2425121]...';


GO
ALTER TABLE [dbo].[T_KOZTERULETJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2425121] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027630]...';


GO
ALTER TABLE [dbo].[T_FOGLALKOZTATASTIPUSA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027630] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027400]...';


GO
ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027400] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026110]...';


GO
ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026110] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025014]...';


GO
ALTER TABLE [dbo].[T_FORMTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025014] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025745]...';


GO
ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025745] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027625]...';


GO
ALTER TABLE [dbo].[T_ERETTSEGISZINT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027625] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025161]...';


GO
ALTER TABLE [dbo].[T_ANYANYELV] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025161] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026543]...';


GO
ALTER TABLE [dbo].[T_SOROLASOKATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026543] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_539881]...';


GO
ALTER TABLE [dbo].[T_ERRORSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_539881] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027623]...';


GO
ALTER TABLE [dbo].[T_ERETTSEGITIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027623] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025162]...';


GO
ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025162] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027209]...';


GO
ALTER TABLE [dbo].[T_IDOKERET] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027209] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026079]...';


GO
ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026079] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027912]...';


GO
ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027912] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_283802]...';


GO
ALTER TABLE [dbo].[T_FEETYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_283802] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025716]...';


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025716] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_3832194]...';


GO
ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_3832194] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025163]...';


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025163] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025455]...';


GO
ALTER TABLE [dbo].[T_HETNAPJATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025455] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2026498]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2026498] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025337]...';


GO
ALTER TABLE [dbo].[T_TANTERVIJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025337] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_228252]...';


GO
ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_228252] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025697]...';


GO
ALTER TABLE [dbo].[T_IGAZOLASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025697] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_3715847]...';


GO
ALTER TABLE [dbo].[T_MEGYE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_3715847] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027210]...';


GO
ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027210] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026367]...';


GO
ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026367] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2026496]...';


GO
ALTER TABLE [dbo].[T_SCSTICKERSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2026496] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025290]...';


GO
ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025290] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48446]...';


GO
ALTER TABLE [dbo].[T_EMAILTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48446] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027624]...';


GO
ALTER TABLE [dbo].[T_ERETTSEGITANTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027624] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026357]...';


GO
ALTER TABLE [dbo].[T_BESOROLASIFOKOZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026357] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025883]...';


GO
ALTER TABLE [dbo].[T_ERTESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025883] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025131]...';


GO
ALTER TABLE [dbo].[T_ESZKOZTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025131] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025453]...';


GO
ALTER TABLE [dbo].[T_HETIRENDTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025453] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1931621]...';


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1931621] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025292]...';


GO
ALTER TABLE [dbo].[T_ESZKOZJELLEG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025292] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48448]...';


GO
ALTER TABLE [dbo].[T_TELEFONTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48448] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025677]...';


GO
ALTER TABLE [dbo].[T_MULASZTASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025677] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027208]...';


GO
ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027208] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025132]...';


GO
ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025132] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025454]...';


GO
ALTER TABLE [dbo].[T_NAPTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025454] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1768082]...';


GO
ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1768082] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48355]...';


GO
ALTER TABLE [dbo].[T_PAYINGTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48355] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027552]...';


GO
ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027552] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025882]...';


GO
ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025882] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026345]...';


GO
ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026345] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025438]...';


GO
ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025438] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025291]...';


GO
ALTER TABLE [dbo].[T_ESZKOZCEL] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025291] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48368]...';


GO
ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48368] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025675]...';


GO
ALTER TABLE [dbo].[T_ERTEKELESMOD] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025675] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_3044532]...';


GO
ALTER TABLE [dbo].[T_HONAPOK] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_3044532] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027554]...';


GO
ALTER TABLE [dbo].[T_AGAZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027554] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026040]...';


GO
ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026040] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026341]...';


GO
ALTER TABLE [dbo].[T_KRETATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026341] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025289]...';


GO
ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025289] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025097]...';


GO
ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025097] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48328]...';


GO
ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48328] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025678]...';


GO
ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025678] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027553]...';


GO
ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027553] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025861]...';


GO
ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025861] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1364185]...';


GO
ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1364185] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025095]...';


GO
ALTER TABLE [dbo].[T_TEREMTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025095] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48367]...';


GO
ALTER TABLE [dbo].[T_NATIONALITY] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48367] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025676]...';


GO
ALTER TABLE [dbo].[T_ERTEKELESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025676] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48470]...';


GO
ALTER TABLE [dbo].[T_STUDENTCARDTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48470] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025413]...';


GO
ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025413] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4027551]...';


GO
ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4027551] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4026955]...';


GO
ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4026955] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025245]...';


GO
ALTER TABLE [dbo].[T_FENNTARTOTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025245] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_1312031]...';


GO
ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_1312031] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_2847546]...';


GO
ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_2847546] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_4025094]...';


GO
ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_4025094] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_T_21038_48369]...';


GO
ALTER TABLE [dbo].[T_MARITALSTATUS] WITH NOCHECK
    ADD CONSTRAINT [FK_T_21038_48369] FOREIGN KEY ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_DICTIONARYITEMBASE] ([ID], [C_INTEZMENYID], [C_TANEVID]);


GO
PRINT N'Creating [dbo].[FK_4028090_4028089]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028090_4028089] FOREIGN KEY ([C_INTEZMENYID], [C_TANEVID], [C_DICTIONARYTYPEID]) REFERENCES [dbo].[T_DICTIONARYTYPE] ([C_INTEZMENYID], [C_TANEVID], [ID]);


GO
PRINT N'Creating [dbo].[FK_4025699_4025708]...';


GO
ALTER TABLE [dbo].[T_TANULOESEMENY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025699_4025708] FOREIGN KEY ([C_TIPUS], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_ESEMENYTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_402569802_402569800]...';


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402569802_402569800] FOREIGN KEY ([C_ALINTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402569805_402569803]...';


GO
ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402569805_402569803] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4025562_4025567]...';


GO
ALTER TABLE [dbo].[T_NAPTARINAP] WITH NOCHECK
    ADD CONSTRAINT [FK_4025562_4025567] FOREIGN KEY ([C_NAPTIPUSA], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_NAPTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025562_4026272]...';


GO
ALTER TABLE [dbo].[T_NAPTARINAP] WITH NOCHECK
    ADD CONSTRAINT [FK_4025562_4026272] FOREIGN KEY ([C_ALAPNAPTIPUSA], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_NAPTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4025441_4025447]...';


GO
ALTER TABLE [dbo].[T_TANEVRENDJE] WITH NOCHECK
    ADD CONSTRAINT [FK_4025441_4025447] FOREIGN KEY ([C_NAPTIPUSA], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_NAPTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_402543902_402543900]...';


GO
ALTER TABLE [dbo].[T_NAPTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402543902_402543900] FOREIGN KEY ([C_ALINTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402543905_402543903]...';


GO
ALTER TABLE [dbo].[T_NAPTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402543905_402543903] FOREIGN KEY ([C_ALTANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4027977_4027984]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4027977_4027984] FOREIGN KEY ([C_HELYETTESITESTIPUSA], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_HELYETTESITESTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4027977_4027986]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4027977_4027986] FOREIGN KEY ([C_HETNAPJA], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_HETNAPJATIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


GO
PRINT N'Creating [dbo].[FK_4028002_4028000]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028002_4028000] FOREIGN KEY ([C_TANMENETID]) REFERENCES [dbo].[T_TANMENET] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028005_4028003]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028005_4028003] FOREIGN KEY ([C_TANTARGYID]) REFERENCES [dbo].[T_TANTARGY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028016_4028015]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028016_4028015] FOREIGN KEY ([C_ORARENDID]) REFERENCES [dbo].[T_ORAREND] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028032_4028030]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028032_4028030] FOREIGN KEY ([C_TANARID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028035_4028033]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028035_4028033] FOREIGN KEY ([C_HELYETTESITOTANARID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028041_4028039]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028041_4028039] FOREIGN KEY ([C_TEREMID]) REFERENCES [dbo].[T_TEREM] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402797702_402797700]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_402797702_402797700] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402797705_402797703]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_402797705_402797703] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028011_4028009]...';


GO
ALTER TABLE [dbo].[T_TANORAORATULAJDONSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4028011_4028009] FOREIGN KEY ([C_TANORAID]) REFERENCES [dbo].[T_TANORA] ([ID]);


GO
PRINT N'Creating [dbo].[FK_4028044_4028042]...';


GO
ALTER TABLE [dbo].[T_TANORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028044_4028042] FOREIGN KEY ([C_OSZTALYCSOPORTID]) REFERENCES [dbo].[T_OSZTALYCSOPORT] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402808302_402808300]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_402808302_402808300] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);


GO
PRINT N'Creating [dbo].[FK_402808305_402808303]...';


GO
ALTER TABLE [dbo].[T_DICTIONARYTYPE] WITH NOCHECK
    ADD CONSTRAINT [FK_402808305_402808303] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);


GO
PRINT N'Refreshing [dbo].[T_CSOPORTTIPUS_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_CSOPORTTIPUS_OSSZES]';


GO
PRINT N'Refreshing [dbo].[T_DICTIONARYITEMBASE_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_DICTIONARYITEMBASE_OSSZES]';


GO
PRINT N'Refreshing [dbo].[T_ESEMENYTIPUS_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_ESEMENYTIPUS_OSSZES]';


GO
PRINT N'Refreshing [dbo].[T_NAPTIPUS_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_NAPTIPUS_OSSZES]';


GO
PRINT N'Refreshing [dbo].[T_TANORA_OSSZES]...';


GO
EXECUTE sp_refreshsqlmodule N'[dbo].[T_TANORA_OSSZES]';


GO
PRINT N'Checking existing data against newly created constraints';


GO
ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025243];

ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402519102_402519100];

ALTER TABLE [dbo].[T_CSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402519105_402519103];

ALTER TABLE [dbo].[T_TANTERV] WITH CHECK CHECK CONSTRAINT [FK_4025392_4025393];

ALTER TABLE [dbo].[T_CSOPORTTIPUS_FOGLALKOZASTIPU] WITH CHECK CHECK CONSTRAINT [FK_4026541_4026540];

ALTER TABLE [dbo].[T_CSOPORT] WITH CHECK CHECK CONSTRAINT [FK_4025277_4025300];

ALTER TABLE [dbo].[T_KIZAROCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_4026005_4026006];

ALTER TABLE [dbo].[T_EVFOLYAMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025414];

ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027517];

ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027832];

ALTER TABLE [dbo].[T_PRIORITAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026956];

ALTER TABLE [dbo].[T_ORSZAGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1291259];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2846551];

ALTER TABLE [dbo].[T_IMPOSITIONSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48373];

ALTER TABLE [dbo].[T_IKTESZKOZHASZNALATMOD] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027466];

ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026039];

ALTER TABLE [dbo].[T_FORRAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026954];

ALTER TABLE [dbo].[T_ROKONSAGIFOK] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025189];

ALTER TABLE [dbo].[T_LANGUAGE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48362];

ALTER TABLE [dbo].[T_ELSODLEGESIKTESZKOZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027468];

ALTER TABLE [dbo].[T_ELETPALYAMODELLFOKOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025811];

ALTER TABLE [dbo].[T_SZERZODOSZEMELYPOZICIO] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026714];

ALTER TABLE [dbo].[T_SYSTEMPARAMETERTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2740820];

ALTER TABLE [dbo].[T_CIMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48323];

ALTER TABLE [dbo].[T_HELYETTESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025640];

ALTER TABLE [dbo].[T_ELETPALYAMODELLSTATUSZOK] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025812];

ALTER TABLE [dbo].[T_ESEMENYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1257632];

ALTER TABLE [dbo].[T_ENAPLOTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026713];

ALTER TABLE [dbo].[T_NEM] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48370];

ALTER TABLE [dbo].[T_ERRORTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48468];

ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025391];

ALTER TABLE [dbo].[T_WIFIELERES] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027469];

ALTER TABLE [dbo].[T_ESEMENYZARADEKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025798];

ALTER TABLE [dbo].[T_TRANSACTIONSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1029472];

ALTER TABLE [dbo].[T_ENAPLOFORRAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026712];

ALTER TABLE [dbo].[T_ERTELMIFOGYATEKOSTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025374];

ALTER TABLE [dbo].[T_IKTKOMPETENCIASZINT] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027465];

ALTER TABLE [dbo].[T_SZEREPKORTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026190];

ALTER TABLE [dbo].[T_HALLASSERULTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025375];

ALTER TABLE [dbo].[T_ENAPLOHASZNALAT] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027467];

ALTER TABLE [dbo].[T_MESSAGESTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025927];

ALTER TABLE [dbo].[T_ENAPLOINFRA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026711];

ALTER TABLE [dbo].[T_LATASSERULTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025373];

ALTER TABLE [dbo].[T_TAGOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027401];

ALTER TABLE [dbo].[T_PARTFILLSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026163];

ALTER TABLE [dbo].[T_MUNKAKORTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025164];

ALTER TABLE [dbo].[T_OTPJELENTESSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2491313];

ALTER TABLE [dbo].[T_ORATULAJDONSAGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028045];

ALTER TABLE [dbo].[T_ETKEZESIKEDVEZMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025361];

ALTER TABLE [dbo].[T_HATRANYOSHELYZETTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025363];

ALTER TABLE [dbo].[T_EVENTTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025902];

ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH CHECK CHECK CONSTRAINT [FK_2103802_2103800];

ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH CHECK CHECK CONSTRAINT [FK_2103805_2103803];

ALTER TABLE [dbo].[T_OTPJELENTESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2488607];

ALTER TABLE [dbo].[T_VALLAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025362];

ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025744];

ALTER TABLE [dbo].[T_VEZETOIORASZAMOKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027637];

ALTER TABLE [dbo].[T_ESLADATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026676];

ALTER TABLE [dbo].[T_KOZTERULETJELLEG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2425121];

ALTER TABLE [dbo].[T_FOGLALKOZTATASTIPUSA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027630];

ALTER TABLE [dbo].[T_FELVETELSTATUSZATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027400];

ALTER TABLE [dbo].[T_SYSTEMSETTINGSCONTROLTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026110];

ALTER TABLE [dbo].[T_FORMTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025014];

ALTER TABLE [dbo].[T_SZORGALOMERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025745];

ALTER TABLE [dbo].[T_ERETTSEGISZINT] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027625];

ALTER TABLE [dbo].[T_ANYANYELV] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025161];

ALTER TABLE [dbo].[T_SOROLASOKATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026543];

ALTER TABLE [dbo].[T_ERRORSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_539881];

ALTER TABLE [dbo].[T_ERETTSEGITIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027623];

ALTER TABLE [dbo].[T_IGAZOLVANYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025162];

ALTER TABLE [dbo].[T_IDOKERET] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027209];

ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026079];

ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027912];

ALTER TABLE [dbo].[T_FEETYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_283802];

ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025716];

ALTER TABLE [dbo].[T_SCCARDBEVONASOKA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_3832194];

ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025163];

ALTER TABLE [dbo].[T_HETNAPJATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025455];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2026498];

ALTER TABLE [dbo].[T_TANTERVIJELLEG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025337];

ALTER TABLE [dbo].[T_PAYMENTTITLETYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_228252];

ALTER TABLE [dbo].[T_IGAZOLASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025697];

ALTER TABLE [dbo].[T_MEGYE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_3715847];

ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027210];

ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026367];

ALTER TABLE [dbo].[T_SCSTICKERSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2026496];

ALTER TABLE [dbo].[T_TESTNEVELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025290];

ALTER TABLE [dbo].[T_EMAILTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48446];

ALTER TABLE [dbo].[T_ERETTSEGITANTARGY] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027624];

ALTER TABLE [dbo].[T_BESOROLASIFOKOZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026357];

ALTER TABLE [dbo].[T_ERTESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025883];

ALTER TABLE [dbo].[T_ESZKOZTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025131];

ALTER TABLE [dbo].[T_HETIRENDTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025453];

ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1931621];

ALTER TABLE [dbo].[T_ESZKOZJELLEG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025292];

ALTER TABLE [dbo].[T_TELEFONTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48448];

ALTER TABLE [dbo].[T_MULASZTASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025677];

ALTER TABLE [dbo].[T_EPENZTARCATETELSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027208];

ALTER TABLE [dbo].[T_ESZKOZKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025132];

ALTER TABLE [dbo].[T_NAPTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025454];

ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1768082];

ALTER TABLE [dbo].[T_PAYINGTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48355];

ALTER TABLE [dbo].[T_RESZSZAKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027552];

ALTER TABLE [dbo].[T_ERTESITESSZINTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025882];

ALTER TABLE [dbo].[T_PEDAGOGUSSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026345];

ALTER TABLE [dbo].[T_FOGLALKOZASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025438];

ALTER TABLE [dbo].[T_ESZKOZCEL] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025291];

ALTER TABLE [dbo].[T_ALLAMPOLGARSAG] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48368];

ALTER TABLE [dbo].[T_ERTEKELESMOD] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025675];

ALTER TABLE [dbo].[T_HONAPOK] WITH CHECK CHECK CONSTRAINT [FK_T_21038_3044532];

ALTER TABLE [dbo].[T_AGAZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027554];

ALTER TABLE [dbo].[T_RENDSZERBEALLITASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026040];

ALTER TABLE [dbo].[T_KRETATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026341];

ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025289];

ALTER TABLE [dbo].[T_INGYENESTANKONYVELLATAS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025097];

ALTER TABLE [dbo].[T_STUDENTCARDSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48328];

ALTER TABLE [dbo].[T_OSZTALYZATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025678];

ALTER TABLE [dbo].[T_SZAKMACSOPORTTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027553];

ALTER TABLE [dbo].[T_TEVEKENYSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025861];

ALTER TABLE [dbo].[T_SMSMESSAGESTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1364185];

ALTER TABLE [dbo].[T_TEREMTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025095];

ALTER TABLE [dbo].[T_NATIONALITY] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48367];

ALTER TABLE [dbo].[T_ERTEKELESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025676];

ALTER TABLE [dbo].[T_STUDENTCARDTYPE] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48470];

ALTER TABLE [dbo].[T_TARGYKATEGORIATIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025413];

ALTER TABLE [dbo].[T_SZAKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4027551];

ALTER TABLE [dbo].[T_HIBAJEGYSTATUSZ] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4026955];

ALTER TABLE [dbo].[T_FENNTARTOTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025245];

ALTER TABLE [dbo].[T_TRANSACTIONANALYSISFILESTATU] WITH CHECK CHECK CONSTRAINT [FK_T_21038_1312031];

ALTER TABLE [dbo].[T_DIAKIGAZOLVANYIGENYHIBASTATU] WITH CHECK CHECK CONSTRAINT [FK_T_21038_2847546];

ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4025094];

ALTER TABLE [dbo].[T_MARITALSTATUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_48369];

ALTER TABLE [dbo].[T_DICTIONARYITEMBASE] WITH CHECK CHECK CONSTRAINT [FK_4028090_4028089];

ALTER TABLE [dbo].[T_TANULOESEMENY] WITH CHECK CHECK CONSTRAINT [FK_4025699_4025708];

ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402569802_402569800];

ALTER TABLE [dbo].[T_ESEMENYTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402569805_402569803];

ALTER TABLE [dbo].[T_NAPTARINAP] WITH CHECK CHECK CONSTRAINT [FK_4025562_4025567];

ALTER TABLE [dbo].[T_NAPTARINAP] WITH CHECK CHECK CONSTRAINT [FK_4025562_4026272];

ALTER TABLE [dbo].[T_TANEVRENDJE] WITH CHECK CHECK CONSTRAINT [FK_4025441_4025447];

ALTER TABLE [dbo].[T_NAPTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402543902_402543900];

ALTER TABLE [dbo].[T_NAPTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402543905_402543903];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4027977_4027984];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4027977_4027986];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4028002_4028000];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4028005_4028003];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4028016_4028015];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4028032_4028030];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4028035_4028033];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4028041_4028039];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_402797702_402797700];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_402797705_402797703];

ALTER TABLE [dbo].[T_TANORAORATULAJDONSAG] WITH CHECK CHECK CONSTRAINT [FK_4028011_4028009];

ALTER TABLE [dbo].[T_TANORA] WITH CHECK CHECK CONSTRAINT [FK_4028044_4028042];

ALTER TABLE [dbo].[T_DICTIONARYTYPE] WITH CHECK CHECK CONSTRAINT [FK_402808302_402808300];

ALTER TABLE [dbo].[T_DICTIONARYTYPE] WITH CHECK CHECK CONSTRAINT [FK_402808305_402808303];


GO
PRINT N'Update complete.';


GO
