﻿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_4025320_4025319]...';


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025320_4025319];


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


GO
ALTER TABLE [dbo].[T_OSZTALY] DROP CONSTRAINT [FK_4025323_4025322];


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


GO
ALTER TABLE [dbo].[T_ESZKOZ] DROP CONSTRAINT [FK_4025281_4025280];


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


GO
ALTER TABLE [dbo].[T_IGAZOLAS] DROP CONSTRAINT [FK_4025761_4025759];


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


GO
ALTER TABLE [dbo].[T_ORALATOGATAS] DROP CONSTRAINT [FK_4025792_4025791];


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


GO
ALTER TABLE [dbo].[T_TANARITANTARGY] DROP CONSTRAINT [FK_4025945_4025944];


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


GO
ALTER TABLE [dbo].[T_HELYETTESITESIIDOSZAK] DROP CONSTRAINT [FK_4026291_4026289];


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


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


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


GO
ALTER TABLE [dbo].[T_TOVABBIMUNKAUGYIADATOK] DROP CONSTRAINT [FK_4027571_4027569];


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


GO
ALTER TABLE [dbo].[T_JOGYAKORLAT] DROP CONSTRAINT [FK_4025910_4025909];


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


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


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


GO
ALTER TABLE [dbo].[T_ORAK_TANAROK] DROP CONSTRAINT [FK_4025633_4025631];


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZASOK_TANAROK] DROP CONSTRAINT [FK_4025437_4025435];


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


GO
ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] DROP CONSTRAINT [FK_4026129_4026127];


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


GO
ALTER TABLE [dbo].[T_PEDAGOGUSIKTADATSZOLGALTATAS] DROP CONSTRAINT [FK_4027463_4027462];


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


GO
ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] DROP CONSTRAINT [FK_4026685_4026684];


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] DROP CONSTRAINT [FK_4025670_4025669];


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


GO
ALTER TABLE [dbo].[T_TANITASIORA] DROP CONSTRAINT [FK_4025629_4025628];


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


GO
ALTER TABLE [dbo].[T_TEVEKENYSEG] DROP CONSTRAINT [FK_4025850_4025849];


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


GO
ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT [FK_T_8935_4025165];


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


GO
ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT [FK_402513902_402513900];


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


GO
ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT [FK_402513905_402513903];


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


GO
ALTER TABLE [dbo].[T_TANMENET] DROP CONSTRAINT [FK_4025605_4025604];


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


GO
ALTER TABLE [dbo].[T_ORARENDIORA] DROP CONSTRAINT [FK_4026327_4026325];


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


GO
ALTER TABLE [dbo].[T_TEREM] DROP CONSTRAINT [FK_4026131_4026130];


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


GO
BEGIN TRANSACTION;

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

SET XACT_ABORT ON;

CREATE TABLE [dbo].[tmp_ms_xx_T_ALKALMAZOTT] (
    [ID]                             INT      NOT NULL,
    [C_ALLANDOHELYETTESITESRE]       CHAR (1) DEFAULT ('F') NULL,
    [C_FOALLAS]                      CHAR (1) DEFAULT ('T') NOT NULL,
    [C_TANARIAUTOMATAMEGAJANLASENGE] CHAR (1) NULL,
    [C_TANARIERTEKELESHATARERTEK]    INT      NULL,
    [C_DIAKOLIMPIA]                  CHAR (1) DEFAULT ('F') NULL,
    [C_SZAKERTOIVIZSGAELNOKI]        CHAR (1) DEFAULT ('F') NULL,
    [C_SZAKVIZSGA]                   CHAR (1) DEFAULT ('F') NULL,
    [C_TOVABBKEPZES]                 CHAR (1) DEFAULT ('F') NULL,
    [C_ORAKEGYHUZAMBAN]              CHAR (1) NULL,
    [C_ALINTEZMENYID]                INT      NOT NULL,
    [C_ALTANEVID]                    INT      NOT NULL,
    [TOROLT]                         CHAR (1) DEFAULT ('F') NULL,
    [SERIAL]                         INT      NULL,
    [LASTCHANGED]                    DATETIME DEFAULT (getdate()) NULL,
    [CREATED]                        DATETIME DEFAULT (getdate()) NULL,
    [MODIFIER]                       INT      NULL,
    [CREATOR]                        INT      NULL,
    CONSTRAINT [tmp_ms_xx_constraint_PK_T_40251391] PRIMARY KEY CLUSTERED ([ID] ASC)
);

IF EXISTS (SELECT TOP 1 1 
           FROM   [dbo].[T_ALKALMAZOTT])
    BEGIN
        INSERT INTO [dbo].[tmp_ms_xx_T_ALKALMAZOTT] ([ID], [C_ALLANDOHELYETTESITESRE], [C_FOALLAS], [C_TANARIAUTOMATAMEGAJANLASENGE], [C_TANARIERTEKELESHATARERTEK], [C_DIAKOLIMPIA], [C_SZAKERTOIVIZSGAELNOKI], [C_SZAKVIZSGA], [C_TOVABBKEPZES], [C_ALINTEZMENYID], [C_ALTANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR])
        SELECT   [ID],
                 [C_ALLANDOHELYETTESITESRE],
                 [C_FOALLAS],
                 [C_TANARIAUTOMATAMEGAJANLASENGE],
                 [C_TANARIERTEKELESHATARERTEK],
                 [C_DIAKOLIMPIA],
                 [C_SZAKERTOIVIZSGAELNOKI],
                 [C_SZAKVIZSGA],
                 [C_TOVABBKEPZES],
                 [C_ALINTEZMENYID],
                 [C_ALTANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR]
        FROM     [dbo].[T_ALKALMAZOTT]
        ORDER BY [ID] ASC;
    END

DROP TABLE [dbo].[T_ALKALMAZOTT];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_T_ALKALMAZOTT]', N'T_ALKALMAZOTT';

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_constraint_PK_T_40251391]', N'PK_T_4025139', N'OBJECT';

COMMIT TRANSACTION;

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;


GO
PRINT N'Creating [dbo].[T_ALKALMAZOTT].[I_T_402513902_402513900]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402513902_402513900]
    ON [dbo].[T_ALKALMAZOTT]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_ALKALMAZOTT].[I_T_402513905_402513903]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402513905_402513903]
    ON [dbo].[T_ALKALMAZOTT]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGEXPORTORAREND] (
    [ID]                  INT            IDENTITY (1, 1) NOT NULL,
    [C_CIM]               NVARCHAR (200) NULL,
    [C_XML]               NVARCHAR (MAX) NULL,
    [C_OGGENERATORALAPID] INT            NOT NULL,
    [C_INTEZMENYID]       INT            NOT NULL,
    [C_TANEVID]           INT            NOT NULL,
    [TOROLT]              CHAR (1)       NULL,
    [SERIAL]              INT            NULL,
    [LASTCHANGED]         DATETIME       NULL,
    [CREATED]             DATETIME       NULL,
    [MODIFIER]            INT            NULL,
    [CREATOR]             INT            NULL,
    CONSTRAINT [PK_T_4027838] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGEXPORTORAREND].[I_T_4027869_4027867]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027869_4027867]
    ON [dbo].[T_OGEXPORTORAREND]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGEXPORTORAREND].[I_T_402783802_402783800]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402783802_402783800]
    ON [dbo].[T_OGEXPORTORAREND]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGEXPORTORAREND].[I_T_402783805_402783803]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402783805_402783803]
    ON [dbo].[T_OGEXPORTORAREND]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGFOGLALKOZAS] (
    [ID]                   INT      IDENTITY (1, 1) NOT NULL,
    [C_ELHELYEZESTAVOL]    CHAR (1) NULL,
    [C_LEHETDUPLA]         CHAR (1) NULL,
    [C_ORASZAM]            INT      NULL,
    [C_TANTARGYID]         INT      NOT NULL,
    [C_OGGENERATORALAPID]  INT      NOT NULL,
    [C_ALKALMAZOTTID]      INT      NOT NULL,
    [C_OGOSZTALYCSOPORTID] INT      NOT NULL,
    [C_INTEZMENYID]        INT      NOT NULL,
    [C_TANEVID]            INT      NOT NULL,
    [TOROLT]               CHAR (1) NULL,
    [SERIAL]               INT      NULL,
    [LASTCHANGED]          DATETIME NULL,
    [CREATED]              DATETIME NULL,
    [MODIFIER]             INT      NULL,
    [CREATOR]              INT      NULL,
    CONSTRAINT [PK_T_4027741] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS].[I_T_4027782_4027781]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027782_4027781]
    ON [dbo].[T_OGFOGLALKOZAS]([C_TANTARGYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS].[I_T_4027809_4027808]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027809_4027808]
    ON [dbo].[T_OGFOGLALKOZAS]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS].[I_T_4027815_4027814]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027815_4027814]
    ON [dbo].[T_OGFOGLALKOZAS]([C_ALKALMAZOTTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS].[I_T_4027892_4027890]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027892_4027890]
    ON [dbo].[T_OGFOGLALKOZAS]([C_OGOSZTALYCSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS].[I_T_402774102_402774100]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402774102_402774100]
    ON [dbo].[T_OGFOGLALKOZAS]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS].[I_T_402774105_402774103]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402774105_402774103]
    ON [dbo].[T_OGFOGLALKOZAS]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] (
    [ID]                INT      IDENTITY (1, 1) NOT NULL,
    [C_PRIORITAS]       INT      NULL,
    [C_TEREMID]         INT      NOT NULL,
    [C_OGFOGLALKOZASID] INT      NOT NULL,
    [C_INTEZMENYID]     INT      NOT NULL,
    [C_TANEVID]         INT      NOT NULL,
    [TOROLT]            CHAR (1) NULL,
    [SERIAL]            INT      NULL,
    [LASTCHANGED]       DATETIME NULL,
    [CREATED]           DATETIME NULL,
    [MODIFIER]          INT      NULL,
    [CREATOR]           INT      NULL,
    CONSTRAINT [PK_T_4027734] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS_TEREM].[I_T_4027801_4027799]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027801_4027799]
    ON [dbo].[T_OGFOGLALKOZAS_TEREM]([C_TEREMID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS_TEREM].[I_T_4027804_4027802]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027804_4027802]
    ON [dbo].[T_OGFOGLALKOZAS_TEREM]([C_OGFOGLALKOZASID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS_TEREM].[I_T_402773402_402773400]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402773402_402773400]
    ON [dbo].[T_OGFOGLALKOZAS_TEREM]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZAS_TEREM].[I_T_402773405_402773403]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402773405_402773403]
    ON [dbo].[T_OGFOGLALKOZAS_TEREM]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_HETNAPJA]               INT      NULL,
    [C_ORARENDFOGLALTSAG]      INT      NULL,
    [C_ORARENDFOGLALTSAGERTEK] INT      NULL,
    [C_ORASZAM]                INT      NULL,
    [C_HETIREND]               INT      NULL,
    [C_OGFOGLALKOZASID]        INT      NOT NULL,
    [C_OGGENERATORALAPID]      INT      NOT NULL,
    [C_INTEZMENYID]            INT      NOT NULL,
    [C_TANEVID]                INT      NOT NULL,
    [TOROLT]                   CHAR (1) NULL,
    [SERIAL]                   INT      NULL,
    [LASTCHANGED]              DATETIME NULL,
    [CREATED]                  DATETIME NULL,
    [MODIFIER]                 INT      NULL,
    [CREATOR]                  INT      NULL,
    CONSTRAINT [PK_T_4027842] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZASFOGLALTSAG].[I_T_4027842_4027844]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027842_4027844]
    ON [dbo].[T_OGFOGLALKOZASFOGLALTSAG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ORARENDFOGLALTSAG] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZASFOGLALTSAG].[I_T_4027872_4027870]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027872_4027870]
    ON [dbo].[T_OGFOGLALKOZASFOGLALTSAG]([C_OGFOGLALKOZASID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZASFOGLALTSAG].[I_T_4027878_4027876]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027878_4027876]
    ON [dbo].[T_OGFOGLALKOZASFOGLALTSAG]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZASFOGLALTSAG].[I_T_402784202_402784200]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402784202_402784200]
    ON [dbo].[T_OGFOGLALKOZASFOGLALTSAG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALKOZASFOGLALTSAG].[I_T_402784205_402784203]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402784205_402784203]
    ON [dbo].[T_OGFOGLALKOZASFOGLALTSAG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGFOGLALTSAGTIPUS] (
    [ID]              INT      NOT NULL,
    [C_ALINTEZMENYID] INT      NOT NULL,
    [C_ALTANEVID]     INT      NOT NULL,
    [TOROLT]          CHAR (1) NULL,
    [SERIAL]          INT      NULL,
    [LASTCHANGED]     DATETIME NULL,
    [CREATED]         DATETIME NULL,
    [MODIFIER]        INT      NULL,
    [CREATOR]         INT      NULL,
    CONSTRAINT [PK_T_4027745] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGFOGLALTSAGTIPUS].[I_T_402774502_402774500]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402774502_402774500]
    ON [dbo].[T_OGFOGLALTSAGTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGFOGLALTSAGTIPUS].[I_T_402774505_402774503]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402774505_402774503]
    ON [dbo].[T_OGFOGLALTSAGTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGGENERATORALAP] (
    [ID]                  INT           IDENTITY (1, 1) NOT NULL,
    [C_ELSOTANORASZAMA]   INT           NULL,
    [C_HETKEZDONAPJA]     INT           NULL,
    [C_HETNAPJA]          INT           NULL,
    [C_NEV]               NVARCHAR (50) NULL,
    [C_UTOLSOTANORASZAMA] INT           NULL,
    [C_HETIRENDEKSZAMA]   INT           NULL,
    [C_INTEZMENYID]       INT           NOT NULL,
    [C_TANEVID]           INT           NOT NULL,
    [TOROLT]              CHAR (1)      NULL,
    [SERIAL]              INT           NULL,
    [LASTCHANGED]         DATETIME      NULL,
    [CREATED]             DATETIME      NULL,
    [MODIFIER]            INT           NULL,
    [CREATOR]             INT           NULL,
    CONSTRAINT [PK_T_4027751] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGGENERATORALAP].[I_T_402775102_402775100]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402775102_402775100]
    ON [dbo].[T_OGGENERATORALAP]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGGENERATORALAP].[I_T_402775105_402775103]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402775105_402775103]
    ON [dbo].[T_OGGENERATORALAP]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_HETNAPJA]               INT      NULL,
    [C_ORARENDFOGLALTSAG]      INT      NULL,
    [C_ORARENDFOGLALTSAGERTEK] INT      NULL,
    [C_ORASZAM]                INT      NULL,
    [C_HETIREND]               INT      NULL,
    [C_OGGENERATORALAPID]      INT      NOT NULL,
    [C_INTEZMENYID]            INT      NOT NULL,
    [C_TANEVID]                INT      NOT NULL,
    [TOROLT]                   CHAR (1) NULL,
    [SERIAL]                   INT      NULL,
    [LASTCHANGED]              DATETIME NULL,
    [CREATED]                  DATETIME NULL,
    [MODIFIER]                 INT      NULL,
    [CREATOR]                  INT      NULL,
    CONSTRAINT [PK_T_4027761] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGINTEZMENYFOGLALTSAG].[I_T_4027761_4027763]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027761_4027763]
    ON [dbo].[T_OGINTEZMENYFOGLALTSAG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ORARENDFOGLALTSAG] ASC);


GO
PRINT N'Creating [dbo].[T_OGINTEZMENYFOGLALTSAG].[I_T_4027831_4027829]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027831_4027829]
    ON [dbo].[T_OGINTEZMENYFOGLALTSAG]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGINTEZMENYFOGLALTSAG].[I_T_402776102_402776100]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402776102_402776100]
    ON [dbo].[T_OGINTEZMENYFOGLALTSAG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGINTEZMENYFOGLALTSAG].[I_T_402776105_402776103]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402776105_402776103]
    ON [dbo].[T_OGINTEZMENYFOGLALTSAG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGORARENDIORA] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_HETNAPJA]               INT      NULL,
    [C_ORARENDFOGLALTSAG]      INT      NULL,
    [C_ORARENDFOGLALTSAGERTEK] INT      NULL,
    [C_ORASZAM]                INT      NULL,
    [C_HETIREND]               INT      NULL,
    [C_TANTARGYID]             INT      NOT NULL,
    [C_OGOSZTALYCSOPORTID]     INT      NOT NULL,
    [C_TEREMID]                INT      NOT NULL,
    [C_ALKALMAZOTTID]          INT      NOT NULL,
    [C_OGGENERATORALAPID]      INT      NOT NULL,
    [C_INTEZMENYID]            INT      NOT NULL,
    [C_TANEVID]                INT      NOT NULL,
    [TOROLT]                   CHAR (1) NULL,
    [SERIAL]                   INT      NULL,
    [LASTCHANGED]              DATETIME NULL,
    [CREATED]                  DATETIME NULL,
    [MODIFIER]                 INT      NULL,
    [CREATOR]                  INT      NULL,
    CONSTRAINT [PK_T_4027833] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_4027833_4027835]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027833_4027835]
    ON [dbo].[T_OGORARENDIORA]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ORARENDFOGLALTSAG] ASC);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_4027854_4027852]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027854_4027852]
    ON [dbo].[T_OGORARENDIORA]([C_TANTARGYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_4027857_4027855]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027857_4027855]
    ON [dbo].[T_OGORARENDIORA]([C_OGOSZTALYCSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_4027860_4027858]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027860_4027858]
    ON [dbo].[T_OGORARENDIORA]([C_TEREMID] ASC);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_4027863_4027861]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027863_4027861]
    ON [dbo].[T_OGORARENDIORA]([C_ALKALMAZOTTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_4027866_4027864]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027866_4027864]
    ON [dbo].[T_OGORARENDIORA]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_402783302_402783300]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402783302_402783300]
    ON [dbo].[T_OGORARENDIORA]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGORARENDIORA].[I_T_402783305_402783303]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402783305_402783303]
    ON [dbo].[T_OGORARENDIORA]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGOSZTALYCSOPORT] (
    [ID]                  INT      IDENTITY (1, 1) NOT NULL,
    [C_HETIREND]          INT      NULL,
    [C_ISOSZTALY]         CHAR (1) NULL,
    [C_LETSZAM]           INT      NULL,
    [C_OSZTALYCSOPORTID]  INT      NOT NULL,
    [C_OGGENERATORALAPID] INT      NOT NULL,
    [C_INTEZMENYID]       INT      NOT NULL,
    [C_TANEVID]           INT      NOT NULL,
    [TOROLT]              CHAR (1) NULL,
    [SERIAL]              INT      NULL,
    [LASTCHANGED]         DATETIME NULL,
    [CREATED]             DATETIME NULL,
    [MODIFIER]            INT      NULL,
    [CREATOR]             INT      NULL,
    CONSTRAINT [PK_T_4027730] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORT].[I_T_4027789_4027787]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027789_4027787]
    ON [dbo].[T_OGOSZTALYCSOPORT]([C_OSZTALYCSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORT].[I_T_4027792_4027790]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027792_4027790]
    ON [dbo].[T_OGOSZTALYCSOPORT]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORT].[I_T_402773002_402773000]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402773002_402773000]
    ON [dbo].[T_OGOSZTALYCSOPORT]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORT].[I_T_402773005_402773003]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402773005_402773003]
    ON [dbo].[T_OGOSZTALYCSOPORT]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO] (
    [C_OGOSZTALYCSOPORTID] INT NOT NULL,
    [C_KIZAROCSOPORTID]    INT NOT NULL,
    CONSTRAINT [PK_T_T_OGOSZTALYCSOPORT_KIZARO] PRIMARY KEY CLUSTERED ([C_OGOSZTALYCSOPORTID] ASC, [C_KIZAROCSOPORTID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO].[I_T_4027794_4027730]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027794_4027730]
    ON [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO]([C_OGOSZTALYCSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO].[I_T_4027795_4026005]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027795_4026005]
    ON [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO]([C_KIZAROCSOPORTID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_HETNAPJA]               INT      NULL,
    [C_ORARENDFOGLALTSAG]      INT      NULL,
    [C_ORARENDFOGLALTSAGERTEK] INT      NULL,
    [C_ORASZAM]                INT      NULL,
    [C_HETIREND]               INT      NULL,
    [C_OGOSZTALYCSOPORTID]     INT      NOT NULL,
    [C_OGGENERATORALAPID]      INT      NOT NULL,
    [C_INTEZMENYID]            INT      NOT NULL,
    [C_TANEVID]                INT      NOT NULL,
    [TOROLT]                   CHAR (1) NULL,
    [SERIAL]                   INT      NULL,
    [LASTCHANGED]              DATETIME NULL,
    [CREATED]                  DATETIME NULL,
    [MODIFIER]                 INT      NULL,
    [CREATOR]                  INT      NULL,
    CONSTRAINT [PK_T_4027746] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG].[I_T_4027746_4027748]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027746_4027748]
    ON [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ORARENDFOGLALTSAG] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG].[I_T_4027798_4027796]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027798_4027796]
    ON [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG]([C_OGOSZTALYCSOPORTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG].[I_T_4027822_4027820]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027822_4027820]
    ON [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG].[I_T_402774602_402774600]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402774602_402774600]
    ON [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG].[I_T_402774605_402774603]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402774605_402774603]
    ON [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGTANARFOGLALTSAG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_HETNAPJA]               INT      NULL,
    [C_ORARENDFOGLALTSAG]      INT      NULL,
    [C_ORARENDFOGLALTSAGERTEK] INT      NULL,
    [C_ORSZAM]                 INT      NULL,
    [C_HETIREND]               INT      NULL,
    [C_OGGENERATORALAPID]      INT      NOT NULL,
    [C_ALKALMAZOTTID]          INT      NOT NULL,
    [C_INTEZMENYID]            INT      NOT NULL,
    [C_TANEVID]                INT      NOT NULL,
    [TOROLT]                   CHAR (1) NULL,
    [SERIAL]                   INT      NULL,
    [LASTCHANGED]              DATETIME NULL,
    [CREATED]                  DATETIME NULL,
    [MODIFIER]                 INT      NULL,
    [CREATOR]                  INT      NULL,
    CONSTRAINT [PK_T_4027724] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGTANARFOGLALTSAG].[I_T_4027724_4027726]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027724_4027726]
    ON [dbo].[T_OGTANARFOGLALTSAG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ORARENDFOGLALTSAG] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANARFOGLALTSAG].[I_T_4027767_4027766]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027767_4027766]
    ON [dbo].[T_OGTANARFOGLALTSAG]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANARFOGLALTSAG].[I_T_4027771_4027769]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027771_4027769]
    ON [dbo].[T_OGTANARFOGLALTSAG]([C_ALKALMAZOTTID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANARFOGLALTSAG].[I_T_402772402_402772400]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402772402_402772400]
    ON [dbo].[T_OGTANARFOGLALTSAG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANARFOGLALTSAG].[I_T_402772405_402772403]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402772405_402772403]
    ON [dbo].[T_OGTANARFOGLALTSAG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_HETNAPJA]               INT      NULL,
    [C_ORARENDFOGLALTSAG]      INT      NULL,
    [C_ORARENDFOGLALTSAGERTEK] INT      NULL,
    [C_ORASZAM]                INT      NULL,
    [C_HETIREND]               INT      NULL,
    [C_TANTARGYID]             INT      NOT NULL,
    [C_OGGENERATORALAPID]      INT      NOT NULL,
    [C_INTEZMENYID]            INT      NOT NULL,
    [C_TANEVID]                INT      NOT NULL,
    [TOROLT]                   CHAR (1) NULL,
    [SERIAL]                   INT      NULL,
    [LASTCHANGED]              DATETIME NULL,
    [CREATED]                  DATETIME NULL,
    [MODIFIER]                 INT      NULL,
    [CREATOR]                  INT      NULL,
    CONSTRAINT [PK_T_4027736] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGTANTARGYFOGLALTSAG].[I_T_4027736_4027738]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027736_4027738]
    ON [dbo].[T_OGTANTARGYFOGLALTSAG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ORARENDFOGLALTSAG] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANTARGYFOGLALTSAG].[I_T_4027786_4027784]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027786_4027784]
    ON [dbo].[T_OGTANTARGYFOGLALTSAG]([C_TANTARGYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANTARGYFOGLALTSAG].[I_T_4027807_4027805]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027807_4027805]
    ON [dbo].[T_OGTANTARGYFOGLALTSAG]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANTARGYFOGLALTSAG].[I_T_402773602_402773600]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402773602_402773600]
    ON [dbo].[T_OGTANTARGYFOGLALTSAG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTANTARGYFOGLALTSAG].[I_T_402773605_402773603]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402773605_402773603]
    ON [dbo].[T_OGTANTARGYFOGLALTSAG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGTEREM_TANTARGY] (
    [ID]                  INT      IDENTITY (1, 1) NOT NULL,
    [C_TANTARGYID]        INT      NOT NULL,
    [C_OGGENERATORALAPID] INT      NOT NULL,
    [C_TEREMID]           INT      NOT NULL,
    [C_INTEZMENYID]       INT      NOT NULL,
    [C_TANEVID]           INT      NOT NULL,
    [TOROLT]              CHAR (1) NULL,
    [SERIAL]              INT      NULL,
    [LASTCHANGED]         DATETIME NULL,
    [CREATED]             DATETIME NULL,
    [MODIFIER]            INT      NULL,
    [CREATOR]             INT      NULL,
    CONSTRAINT [PK_T_4027729] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGTEREM_TANTARGY].[I_T_4027774_4027772]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027774_4027772]
    ON [dbo].[T_OGTEREM_TANTARGY]([C_TANTARGYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREM_TANTARGY].[I_T_4027777_4027775]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027777_4027775]
    ON [dbo].[T_OGTEREM_TANTARGY]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREM_TANTARGY].[I_T_4027779_4027778]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027779_4027778]
    ON [dbo].[T_OGTEREM_TANTARGY]([C_TEREMID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREM_TANTARGY].[I_T_402772902_402772900]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402772902_402772900]
    ON [dbo].[T_OGTEREM_TANTARGY]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREM_TANTARGY].[I_T_402772905_402772903]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402772905_402772903]
    ON [dbo].[T_OGTEREM_TANTARGY]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_OGTEREMFOGLALTSAG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_HETNAPJA]               INT      NULL,
    [C_ORARENDFOGLALTSAG]      INT      NULL,
    [C_ORARENDFOGLALTSAGERTEK] INT      NULL,
    [C_ORASZAM]                INT      NULL,
    [C_HETIREND]               INT      NULL,
    [C_TEREMID]                INT      NOT NULL,
    [C_OGGENERATORALAPID]      INT      NOT NULL,
    [C_INTEZMENYID]            INT      NOT NULL,
    [C_TANEVID]                INT      NOT NULL,
    [TOROLT]                   CHAR (1) NULL,
    [SERIAL]                   INT      NULL,
    [LASTCHANGED]              DATETIME NULL,
    [CREATED]                  DATETIME NULL,
    [MODIFIER]                 INT      NULL,
    [CREATOR]                  INT      NULL,
    CONSTRAINT [PK_T_4027847] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_OGTEREMFOGLALTSAG].[I_T_4027847_4027849]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027847_4027849]
    ON [dbo].[T_OGTEREMFOGLALTSAG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ORARENDFOGLALTSAG] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREMFOGLALTSAG].[I_T_4027875_4027873]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027875_4027873]
    ON [dbo].[T_OGTEREMFOGLALTSAG]([C_TEREMID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREMFOGLALTSAG].[I_T_4027881_4027879]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4027881_4027879]
    ON [dbo].[T_OGTEREMFOGLALTSAG]([C_OGGENERATORALAPID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREMFOGLALTSAG].[I_T_402784702_402784700]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402784702_402784700]
    ON [dbo].[T_OGTEREMFOGLALTSAG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_OGTEREMFOGLALTSAG].[I_T_402784705_402784703]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402784705_402784703]
    ON [dbo].[T_OGTEREMFOGLALTSAG]([C_TANEVID] ASC);


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM]
    ADD DEFAULT ((1)) FOR [C_PRIORITAS];


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG]
    ADD DEFAULT ((1)) FOR [C_ORARENDFOGLALTSAGERTEK];


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGGENERATORALAP]
    ADD DEFAULT ((1)) FOR [C_HETIRENDEKSZAMA];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG]
    ADD DEFAULT ((1)) FOR [C_ORARENDFOGLALTSAGERTEK];


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


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


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


GO
ALTER TABLE [dbo].[T_OGORARENDIORA]
    ADD DEFAULT ((1)) FOR [C_ORARENDFOGLALTSAGERTEK];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT]
    ADD DEFAULT ((0)) FOR [C_LETSZAM];


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT]
    ADD DEFAULT ((1)) FOR [C_HETIREND];


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG]
    ADD DEFAULT ((1)) FOR [C_ORARENDFOGLALTSAGERTEK];


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


GO
ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG]
    ADD DEFAULT ((1)) FOR [C_ORARENDFOGLALTSAGERTEK];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG]
    ADD DEFAULT ((1)) FOR [C_ORARENDFOGLALTSAGERTEK];


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG]
    ADD DEFAULT ((1)) FOR [C_ORARENDFOGLALTSAGERTEK];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025320_4025319] FOREIGN KEY ([C_OSZTALYFONOKID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025323_4025322] FOREIGN KEY ([C_OFOHELYETTESID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ESZKOZ] WITH NOCHECK
    ADD CONSTRAINT [FK_4025281_4025280] FOREIGN KEY ([C_FELELOSID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_IGAZOLAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4025761_4025759] FOREIGN KEY ([C_ROGZITOID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ORALATOGATAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4025792_4025791] FOREIGN KEY ([C_ERTEKELOID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_TANARITANTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025945_4025944] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_HELYETTESITESIIDOSZAK] WITH NOCHECK
    ADD CONSTRAINT [FK_4026291_4026289] FOREIGN KEY ([C_HELYETTESTANAROKID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_CSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_4025326_4025325] FOREIGN KEY ([C_CSOPORTVEZETOID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_TOVABBIMUNKAUGYIADATOK] WITH NOCHECK
    ADD CONSTRAINT [FK_4027571_4027569] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_JOGYAKORLAT] WITH NOCHECK
    ADD CONSTRAINT [FK_4025910_4025909] FOREIGN KEY ([C_JOGYAKORLATTULAJDONOSID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_TANULOESEMENY] WITH NOCHECK
    ADD CONSTRAINT [FK_4025714_4025713] FOREIGN KEY ([C_FELJEGYZOID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ORAK_TANAROK] WITH NOCHECK
    ADD CONSTRAINT [FK_4025633_4025631] FOREIGN KEY ([C_TANAROKID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZASOK_TANAROK] WITH NOCHECK
    ADD CONSTRAINT [FK_4025437_4025435] FOREIGN KEY ([C_TANAROKID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] WITH NOCHECK
    ADD CONSTRAINT [FK_4026129_4026127] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_PEDAGOGUSIKTADATSZOLGALTATAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4027463_4027462] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH NOCHECK
    ADD CONSTRAINT [FK_4025670_4025669] FOREIGN KEY ([C_ERTEKELOID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_TEVEKENYSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_4025850_4025849] FOREIGN KEY ([C_ESEMENYTULAJDONOSID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_ALKALMAZOTT] WITH NOCHECK
    ADD CONSTRAINT [FK_T_8935_4025165] FOREIGN KEY ([ID]) REFERENCES [dbo].[T_FELHASZNALO] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_TANMENET] WITH NOCHECK
    ADD CONSTRAINT [FK_4025605_4025604] FOREIGN KEY ([C_FELTOLTOID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_TEREM] WITH NOCHECK
    ADD CONSTRAINT [FK_4026131_4026130] FOREIGN KEY ([C_TEREMFELELOSID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGEXPORTORAREND] WITH NOCHECK
    ADD CONSTRAINT [FK_4027869_4027867] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4027809_4027808] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4027815_4027814] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4027892_4027890] FOREIGN KEY ([C_OGOSZTALYCSOPORTID]) REFERENCES [dbo].[T_OGOSZTALYCSOPORT] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] WITH NOCHECK
    ADD CONSTRAINT [FK_4027804_4027802] FOREIGN KEY ([C_OGFOGLALKOZASID]) REFERENCES [dbo].[T_OGFOGLALKOZAS] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027872_4027870] FOREIGN KEY ([C_OGFOGLALKOZASID]) REFERENCES [dbo].[T_OGFOGLALKOZAS] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027878_4027876] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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_402774502_402774500]...';


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027831_4027829] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGORARENDIORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4027857_4027855] FOREIGN KEY ([C_OGOSZTALYCSOPORTID]) REFERENCES [dbo].[T_OGOSZTALYCSOPORT] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_OGORARENDIORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4027863_4027861] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGORARENDIORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4027866_4027864] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] WITH NOCHECK
    ADD CONSTRAINT [FK_4027792_4027790] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO] WITH NOCHECK
    ADD CONSTRAINT [FK_4027794_4027793] FOREIGN KEY ([C_OGOSZTALYCSOPORTID]) REFERENCES [dbo].[T_OGOSZTALYCSOPORT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO] WITH NOCHECK
    ADD CONSTRAINT [FK_4027795_4027793] FOREIGN KEY ([C_KIZAROCSOPORTID]) REFERENCES [dbo].[T_KIZAROCSOPORT] ([ID]);


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


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


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027798_4027796] FOREIGN KEY ([C_OGOSZTALYCSOPORTID]) REFERENCES [dbo].[T_OGOSZTALYCSOPORT] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027822_4027820] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027767_4027766] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


GO
ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027771_4027769] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027807_4027805] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH NOCHECK
    ADD CONSTRAINT [FK_4027777_4027775] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] WITH NOCHECK
    ADD CONSTRAINT [FK_4027881_4027879] FOREIGN KEY ([C_OGGENERATORALAPID]) REFERENCES [dbo].[T_OGGENERATORALAP] ([ID]);


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025320_4025319];

ALTER TABLE [dbo].[T_OSZTALY] WITH CHECK CHECK CONSTRAINT [FK_4025323_4025322];

ALTER TABLE [dbo].[T_ESZKOZ] WITH CHECK CHECK CONSTRAINT [FK_4025281_4025280];

ALTER TABLE [dbo].[T_IGAZOLAS] WITH CHECK CHECK CONSTRAINT [FK_4025761_4025759];

ALTER TABLE [dbo].[T_ORALATOGATAS] WITH CHECK CHECK CONSTRAINT [FK_4025792_4025791];

ALTER TABLE [dbo].[T_TANARITANTARGY] WITH CHECK CHECK CONSTRAINT [FK_4025945_4025944];

ALTER TABLE [dbo].[T_HELYETTESITESIIDOSZAK] WITH CHECK CHECK CONSTRAINT [FK_4026291_4026289];

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

ALTER TABLE [dbo].[T_TOVABBIMUNKAUGYIADATOK] WITH CHECK CHECK CONSTRAINT [FK_4027571_4027569];

ALTER TABLE [dbo].[T_JOGYAKORLAT] WITH CHECK CHECK CONSTRAINT [FK_4025910_4025909];

ALTER TABLE [dbo].[T_TANULOESEMENY] WITH CHECK CHECK CONSTRAINT [FK_4025714_4025713];

ALTER TABLE [dbo].[T_ORAK_TANAROK] WITH CHECK CHECK CONSTRAINT [FK_4025633_4025631];

ALTER TABLE [dbo].[T_FOGLALKOZASOK_TANAROK] WITH CHECK CHECK CONSTRAINT [FK_4025437_4025435];

ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] WITH CHECK CHECK CONSTRAINT [FK_4026129_4026127];

ALTER TABLE [dbo].[T_PEDAGOGUSIKTADATSZOLGALTATAS] WITH CHECK CHECK CONSTRAINT [FK_4027463_4027462];

ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] WITH CHECK CHECK CONSTRAINT [FK_4026685_4026684];

ALTER TABLE [dbo].[T_TANULOERTEKELES] WITH CHECK CHECK CONSTRAINT [FK_4025670_4025669];

ALTER TABLE [dbo].[T_TANITASIORA] WITH CHECK CHECK CONSTRAINT [FK_4025629_4025628];

ALTER TABLE [dbo].[T_TEVEKENYSEG] WITH CHECK CHECK CONSTRAINT [FK_4025850_4025849];

ALTER TABLE [dbo].[T_ALKALMAZOTT] WITH CHECK CHECK CONSTRAINT [FK_T_8935_4025165];

ALTER TABLE [dbo].[T_ALKALMAZOTT] WITH CHECK CHECK CONSTRAINT [FK_402513902_402513900];

ALTER TABLE [dbo].[T_ALKALMAZOTT] WITH CHECK CHECK CONSTRAINT [FK_402513905_402513903];

ALTER TABLE [dbo].[T_TANMENET] WITH CHECK CHECK CONSTRAINT [FK_4025605_4025604];

ALTER TABLE [dbo].[T_ORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_4026327_4026325];

ALTER TABLE [dbo].[T_TEREM] WITH CHECK CHECK CONSTRAINT [FK_4026131_4026130];

ALTER TABLE [dbo].[T_OGEXPORTORAREND] WITH CHECK CHECK CONSTRAINT [FK_4027869_4027867];

ALTER TABLE [dbo].[T_OGEXPORTORAREND] WITH CHECK CHECK CONSTRAINT [FK_402783802_402783800];

ALTER TABLE [dbo].[T_OGEXPORTORAREND] WITH CHECK CHECK CONSTRAINT [FK_402783805_402783803];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_4027782_4027781];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_4027809_4027808];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_4027815_4027814];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_4027892_4027890];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_402774102_402774100];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] WITH CHECK CHECK CONSTRAINT [FK_402774105_402774103];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] WITH CHECK CHECK CONSTRAINT [FK_4027801_4027799];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] WITH CHECK CHECK CONSTRAINT [FK_4027804_4027802];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] WITH CHECK CHECK CONSTRAINT [FK_402773402_402773400];

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] WITH CHECK CHECK CONSTRAINT [FK_402773405_402773403];

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027842_4027844];

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027872_4027870];

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027878_4027876];

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402784202_402784200];

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402784205_402784203];

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

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

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

ALTER TABLE [dbo].[T_OGGENERATORALAP] WITH CHECK CHECK CONSTRAINT [FK_402775102_402775100];

ALTER TABLE [dbo].[T_OGGENERATORALAP] WITH CHECK CHECK CONSTRAINT [FK_402775105_402775103];

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027761_4027763];

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027831_4027829];

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402776102_402776100];

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402776105_402776103];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_4027833_4027835];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_4027854_4027852];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_4027857_4027855];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_4027860_4027858];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_4027863_4027861];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_4027866_4027864];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_402783302_402783300];

ALTER TABLE [dbo].[T_OGORARENDIORA] WITH CHECK CHECK CONSTRAINT [FK_402783305_402783303];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_4027789_4027787];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_4027792_4027790];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402773002_402773000];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402773005_402773003];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO] WITH CHECK CHECK CONSTRAINT [FK_4027794_4027793];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT_KIZAROCSOPO] WITH CHECK CHECK CONSTRAINT [FK_4027795_4027793];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027746_4027748];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027798_4027796];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027822_4027820];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402774602_402774600];

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402774605_402774603];

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027724_4027726];

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027767_4027766];

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027771_4027769];

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402772402_402772400];

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402772405_402772403];

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027736_4027738];

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027786_4027784];

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027807_4027805];

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402773602_402773600];

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402773605_402773603];

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH CHECK CHECK CONSTRAINT [FK_4027774_4027772];

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH CHECK CHECK CONSTRAINT [FK_4027777_4027775];

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH CHECK CHECK CONSTRAINT [FK_4027779_4027778];

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH CHECK CHECK CONSTRAINT [FK_402772902_402772900];

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] WITH CHECK CHECK CONSTRAINT [FK_402772905_402772903];

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027847_4027849];

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027875_4027873];

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_4027881_4027879];

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402784702_402784700];

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] WITH CHECK CHECK CONSTRAINT [FK_402784705_402784703];


GO
PRINT N'Update complete.';


GO
