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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_NATKERDOIV] DROP CONSTRAINT [FK_4027951_4027949];


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


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


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


GO
ALTER TABLE [dbo].[T_OGORARENDIORA] DROP CONSTRAINT [FK_4027863_4027861];


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS] DROP CONSTRAINT [FK_4027815_4027814];


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] DROP CONSTRAINT [FK_4027771_4027769];


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


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


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_KOZOSSEGISZOLGALATKEZELO]     CHAR (1) DEFAULT ('F') NULL,
    [C_ELFOGADOTTSZANDEKNYILATKOZAT] CHAR (1) DEFAULT ('F') NULL,
    [C_KKKEPESITESID]                INT      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,
    [NNIDA]                          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_ORAKEGYHUZAMBAN], [C_KOZOSSEGISZOLGALATKEZELO], [C_ELFOGADOTTSZANDEKNYILATKOZAT], [C_ALINTEZMENYID], [C_ALTANEVID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR], [ELOZOTANEVIREKORDID], [ELOZOTANEVIREKORDIDA], [NNID], [NNIDA])
        SELECT   [ID],
                 [C_ALLANDOHELYETTESITESRE],
                 [C_FOALLAS],
                 [C_TANARIAUTOMATAMEGAJANLASENGE],
                 [C_TANARIERTEKELESHATARERTEK],
                 [C_DIAKOLIMPIA],
                 [C_SZAKERTOIVIZSGAELNOKI],
                 [C_SZAKVIZSGA],
                 [C_TOVABBKEPZES],
                 [C_ORAKEGYHUZAMBAN],
                 [C_KOZOSSEGISZOLGALATKEZELO],
                 [C_ELFOGADOTTSZANDEKNYILATKOZAT],
                 [C_ALINTEZMENYID],
                 [C_ALTANEVID],
                 [TOROLT],
                 [SERIAL],
                 [LASTCHANGED],
                 [CREATED],
                 [MODIFIER],
                 [CREATOR],
                 [ELOZOTANEVIREKORDID],
                 [ELOZOTANEVIREKORDIDA],
                 [NNID],
                 [NNIDA]
        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_4025139_4028418]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4025139_4028418]
    ON [dbo].[T_ALKALMAZOTT]([C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC, [C_KKKEPESITESID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMIELEKTROAKUTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028392] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMIELEKTROAKUTIPUS].[I_T_402839202_402839200]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839202_402839200]
    ON [dbo].[T_KKAMIELEKTROAKUTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIELEKTROAKUTIPUS].[I_T_402839205_402839203]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839205_402839203]
    ON [dbo].[T_KKAMIELEKTROAKUTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMIJAZZZENETIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028389] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMIJAZZZENETIPUS].[I_T_402838902_402838900]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838902_402838900]
    ON [dbo].[T_KKAMIJAZZZENETIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIJAZZZENETIPUS].[I_T_402838905_402838903]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838905_402838903]
    ON [dbo].[T_KKAMIJAZZZENETIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMIKLASSZIKUSTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028387] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMIKLASSZIKUSTIPUS].[I_T_402838702_402838700]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838702_402838700]
    ON [dbo].[T_KKAMIKLASSZIKUSTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIKLASSZIKUSTIPUS].[I_T_402838705_402838703]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838705_402838703]
    ON [dbo].[T_KKAMIKLASSZIKUSTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMINEPZENETIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028393] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMINEPZENETIPUS].[I_T_402839302_402839300]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839302_402839300]
    ON [dbo].[T_KKAMINEPZENETIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMINEPZENETIPUS].[I_T_402839305_402839303]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839305_402839303]
    ON [dbo].[T_KKAMINEPZENETIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMITERULETTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028390] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMITERULETTIPUS].[I_T_402839002_402839000]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839002_402839000]
    ON [dbo].[T_KKAMITERULETTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMITERULETTIPUS].[I_T_402839005_402839003]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839005_402839003]
    ON [dbo].[T_KKAMITERULETTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMIVEGZETTSEG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_KKAMIVEGZETTSEGTIPUSID] INT      NULL,
    [C_ALKALMAZOTTID]          INT      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_4028421] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMIVEGZETTSEG].[I_T_4028421_4028422]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028421_4028422]
    ON [dbo].[T_KKAMIVEGZETTSEG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_KKAMIVEGZETTSEGTIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIVEGZETTSEG].[I_T_4028450_4028448]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028450_4028448]
    ON [dbo].[T_KKAMIVEGZETTSEG]([C_ALKALMAZOTTID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIVEGZETTSEG].[I_T_402842102_402842100]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842102_402842100]
    ON [dbo].[T_KKAMIVEGZETTSEG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIVEGZETTSEG].[I_T_402842105_402842103]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842105_402842103]
    ON [dbo].[T_KKAMIVEGZETTSEG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMIVEGZETTSEGTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028391] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMIVEGZETTSEGTIPUS].[I_T_402839102_402839100]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839102_402839100]
    ON [dbo].[T_KKAMIVEGZETTSEGTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIVEGZETTSEGTIPUS].[I_T_402839105_402839103]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839105_402839103]
    ON [dbo].[T_KKAMIVEGZETTSEGTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKAMIZENEMUVKATTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028383] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKAMIZENEMUVKATTIPUS].[I_T_402838302_402838300]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838302_402838300]
    ON [dbo].[T_KKAMIZENEMUVKATTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKAMIZENEMUVKATTIPUS].[I_T_402838305_402838303]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838305_402838303]
    ON [dbo].[T_KKAMIZENEMUVKATTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKELEKTROAKUZENE] (
    [ID]                  INT      IDENTITY (1, 1) NOT NULL,
    [C_ELEKTRAKUTIPUSID]  INT      NULL,
    [C_KKAMIVEGZETTSEGID] INT      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_4028414] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKELEKTROAKUZENE].[I_T_4028414_4028415]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028414_4028415]
    ON [dbo].[T_KKELEKTROAKUZENE]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_ELEKTRAKUTIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKELEKTROAKUZENE].[I_T_4028444_4028442]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028444_4028442]
    ON [dbo].[T_KKELEKTROAKUZENE]([C_KKAMIVEGZETTSEGID] ASC);


GO
PRINT N'Creating [dbo].[T_KKELEKTROAKUZENE].[I_T_402841402_402841400]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841402_402841400]
    ON [dbo].[T_KKELEKTROAKUZENE]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKELEKTROAKUZENE].[I_T_402841405_402841403]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841405_402841403]
    ON [dbo].[T_KKELEKTROAKUZENE]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKGYOGYPEDTERTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028386] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKGYOGYPEDTERTIPUS].[I_T_402838602_402838600]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838602_402838600]
    ON [dbo].[T_KKGYOGYPEDTERTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKGYOGYPEDTERTIPUS].[I_T_402838605_402838603]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838605_402838603]
    ON [dbo].[T_KKGYOGYPEDTERTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] (
    [ID]                     INT      IDENTITY (1, 1) NOT NULL,
    [C_KKGYOGYPEDTERTIPUSID] INT      NULL,
    [C_ALKALMAZOTTID]        INT      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_4028419] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKGYOGYPEDVEGZETTSEG].[I_T_4028419_4028420]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028419_4028420]
    ON [dbo].[T_KKGYOGYPEDVEGZETTSEG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_KKGYOGYPEDTERTIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKGYOGYPEDVEGZETTSEG].[I_T_4028453_4028451]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028453_4028451]
    ON [dbo].[T_KKGYOGYPEDVEGZETTSEG]([C_ALKALMAZOTTID] ASC);


GO
PRINT N'Creating [dbo].[T_KKGYOGYPEDVEGZETTSEG].[I_T_402841902_402841900]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841902_402841900]
    ON [dbo].[T_KKGYOGYPEDVEGZETTSEG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKGYOGYPEDVEGZETTSEG].[I_T_402841905_402841903]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841905_402841903]
    ON [dbo].[T_KKGYOGYPEDVEGZETTSEG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKJAZZZENE] (
    [ID]                  INT      IDENTITY (1, 1) NOT NULL,
    [C_JAZZZENETIPUSID]   INT      NULL,
    [C_KKAMIVEGZETTSEGID] INT      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_4028425] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKJAZZZENE].[I_T_4028425_4028426]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028425_4028426]
    ON [dbo].[T_KKJAZZZENE]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_JAZZZENETIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKJAZZZENE].[I_T_4028459_4028457]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028459_4028457]
    ON [dbo].[T_KKJAZZZENE]([C_KKAMIVEGZETTSEGID] ASC);


GO
PRINT N'Creating [dbo].[T_KKJAZZZENE].[I_T_402842502_402842500]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842502_402842500]
    ON [dbo].[T_KKJAZZZENE]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKJAZZZENE].[I_T_402842505_402842503]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842505_402842503]
    ON [dbo].[T_KKJAZZZENE]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKKEPESITESJELLTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028427] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKKEPESITESJELLTIPUS].[I_T_402842702_402842700]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842702_402842700]
    ON [dbo].[T_KKKEPESITESJELLTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKKEPESITESJELLTIPUS].[I_T_402842705_402842703]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842705_402842703]
    ON [dbo].[T_KKKEPESITESJELLTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKKEPESITESTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028385] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKKEPESITESTIPUS].[I_T_402838502_402838500]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838502_402838500]
    ON [dbo].[T_KKKEPESITESTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKKEPESITESTIPUS].[I_T_402838505_402838503]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838505_402838503]
    ON [dbo].[T_KKKEPESITESTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKKLASSZIKUSZENE] (
    [ID]                      INT      IDENTITY (1, 1) NOT NULL,
    [C_KLASSZUKUSZENETIPUSID] INT      NULL,
    [C_KKAMIVEGZETTSEGID]     INT      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_4028423] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKKLASSZIKUSZENE].[I_T_4028423_4028424]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028423_4028424]
    ON [dbo].[T_KKKLASSZIKUSZENE]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_KLASSZUKUSZENETIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKKLASSZIKUSZENE].[I_T_4028456_4028454]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028456_4028454]
    ON [dbo].[T_KKKLASSZIKUSZENE]([C_KKAMIVEGZETTSEGID] ASC);


GO
PRINT N'Creating [dbo].[T_KKKLASSZIKUSZENE].[I_T_402842302_402842300]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842302_402842300]
    ON [dbo].[T_KKKLASSZIKUSZENE]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKKLASSZIKUSZENE].[I_T_402842305_402842303]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842305_402842303]
    ON [dbo].[T_KKKLASSZIKUSZENE]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKNEPZENE] (
    [ID]                  INT      IDENTITY (1, 1) NOT NULL,
    [C_NEPZENETIPUSID]    INT      NULL,
    [C_KKAMIVEGZETTSEGID] INT      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_4028416] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKNEPZENE].[I_T_4028416_4028417]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028416_4028417]
    ON [dbo].[T_KKNEPZENE]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_NEPZENETIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKNEPZENE].[I_T_4028447_4028445]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028447_4028445]
    ON [dbo].[T_KKNEPZENE]([C_KKAMIVEGZETTSEGID] ASC);


GO
PRINT N'Creating [dbo].[T_KKNEPZENE].[I_T_402841602_402841600]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841602_402841600]
    ON [dbo].[T_KKNEPZENE]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKNEPZENE].[I_T_402841605_402841603]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841605_402841603]
    ON [dbo].[T_KKNEPZENE]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKSZAKTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028384] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKSZAKTIPUS].[I_T_402838402_402838400]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838402_402838400]
    ON [dbo].[T_KKSZAKTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKSZAKTIPUS].[I_T_402838405_402838403]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838405_402838403]
    ON [dbo].[T_KKSZAKTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKTANARVEGZETTSEG] (
    [ID]                    INT            IDENTITY (1, 1) NOT NULL,
    [C_EGYEB]               NVARCHAR (MAX) NULL,
    [C_KKTANARVEGZETTSEGID] INT            NULL,
    [C_ALKALMAZOTTID]       INT            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_4028409] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKTANARVEGZETTSEG].[I_T_4028409_4028411]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028409_4028411]
    ON [dbo].[T_KKTANARVEGZETTSEG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_KKTANARVEGZETTSEGID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANARVEGZETTSEG].[I_T_4028435_4028433]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028435_4028433]
    ON [dbo].[T_KKTANARVEGZETTSEG]([C_ALKALMAZOTTID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANARVEGZETTSEG].[I_T_402840902_402840900]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402840902_402840900]
    ON [dbo].[T_KKTANARVEGZETTSEG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANARVEGZETTSEG].[I_T_402840905_402840903]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402840905_402840903]
    ON [dbo].[T_KKTANARVEGZETTSEG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKTANITOMUVTERTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028388] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKTANITOMUVTERTIPUS].[I_T_402838802_402838800]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838802_402838800]
    ON [dbo].[T_KKTANITOMUVTERTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANITOMUVTERTIPUS].[I_T_402838805_402838803]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402838805_402838803]
    ON [dbo].[T_KKTANITOMUVTERTIPUS]([C_ALTANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKTANITOVEZGETTSEG] (
    [ID]                       INT      IDENTITY (1, 1) NOT NULL,
    [C_KKTANIOTOMUVTERTIPUSID] INT      NULL,
    [C_ALKALMAZOTTID]          INT      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_4028407] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKTANITOVEZGETTSEG].[I_T_4028407_4028408]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028407_4028408]
    ON [dbo].[T_KKTANITOVEZGETTSEG]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_KKTANIOTOMUVTERTIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANITOVEZGETTSEG].[I_T_4028432_4028430]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028432_4028430]
    ON [dbo].[T_KKTANITOVEZGETTSEG]([C_ALKALMAZOTTID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANITOVEZGETTSEG].[I_T_402840702_402840700]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402840702_402840700]
    ON [dbo].[T_KKTANITOVEZGETTSEG]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANITOVEZGETTSEG].[I_T_402840705_402840703]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402840705_402840703]
    ON [dbo].[T_KKTANITOVEZGETTSEG]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKTANTARGYKATEGORIA] (
    [ID]                    INT      IDENTITY (1, 1) NOT NULL,
    [C_KKSZAKTIPUSID]       INT      NULL,
    [C_KKTANARVEGZETTSEGID] INT      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_4028428] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKTANTARGYKATEGORIA].[I_T_4028428_4028429]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028428_4028429]
    ON [dbo].[T_KKTANTARGYKATEGORIA]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_KKSZAKTIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANTARGYKATEGORIA].[I_T_4028438_4028436]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028438_4028436]
    ON [dbo].[T_KKTANTARGYKATEGORIA]([C_KKTANARVEGZETTSEGID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANTARGYKATEGORIA].[I_T_402842802_402842800]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842802_402842800]
    ON [dbo].[T_KKTANTARGYKATEGORIA]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTANTARGYKATEGORIA].[I_T_402842805_402842803]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402842805_402842803]
    ON [dbo].[T_KKTANTARGYKATEGORIA]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKTERULET] (
    [ID]                  INT      IDENTITY (1, 1) NOT NULL,
    [C_AMITERULETTIPUSID] INT      NULL,
    [C_KKAMIVEGZETTSEGID] INT      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_4028412] PRIMARY KEY CLUSTERED ([ID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKTERULET].[I_T_4028412_4028413]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028412_4028413]
    ON [dbo].[T_KKTERULET]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_AMITERULETTIPUSID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTERULET].[I_T_4028441_4028439]...';


GO
CREATE NONCLUSTERED INDEX [I_T_4028441_4028439]
    ON [dbo].[T_KKTERULET]([C_KKAMIVEGZETTSEGID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTERULET].[I_T_402841202_402841200]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841202_402841200]
    ON [dbo].[T_KKTERULET]([C_INTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKTERULET].[I_T_402841205_402841203]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402841205_402841203]
    ON [dbo].[T_KKTERULET]([C_TANEVID] ASC);


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


GO
CREATE TABLE [dbo].[T_KKVEGZETTSEGTIPUS] (
    [ID]                   INT      NOT NULL,
    [C_ALINTEZMENYID]      INT      NOT NULL,
    [C_ALTANEVID]          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,
    [ELOZOTANEVIREKORDIDA] INT      NULL,
    [NNID]                 INT      NULL,
    CONSTRAINT [PK_T_4028394] PRIMARY KEY CLUSTERED ([ID] ASC, [C_ALINTEZMENYID] ASC, [C_ALTANEVID] ASC)
);


GO
PRINT N'Creating [dbo].[T_KKVEGZETTSEGTIPUS].[I_T_402839402_402839400]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839402_402839400]
    ON [dbo].[T_KKVEGZETTSEGTIPUS]([C_ALINTEZMENYID] ASC);


GO
PRINT N'Creating [dbo].[T_KKVEGZETTSEGTIPUS].[I_T_402839405_402839403]...';


GO
CREATE NONCLUSTERED INDEX [I_T_402839405_402839403]
    ON [dbo].[T_KKVEGZETTSEGTIPUS]([C_ALTANEVID] ASC);


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_FOGLALKOZAS] WITH NOCHECK
    ADD CONSTRAINT [FK_4025437_4025435] FOREIGN KEY ([C_TANARID]) 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_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_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_4025633_4025631]...';


GO
ALTER TABLE [dbo].[T_TANITASIORA] WITH NOCHECK
    ADD CONSTRAINT [FK_4025633_4025631] FOREIGN KEY ([C_TANARID]) 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_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_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_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_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_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_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_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_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_4025139_4028418]...';


GO
ALTER TABLE [dbo].[T_ALKALMAZOTT] WITH NOCHECK
    ADD CONSTRAINT [FK_4025139_4028418] FOREIGN KEY ([C_KKKEPESITESID], [C_ALINTEZMENYID], [C_ALTANEVID]) REFERENCES [dbo].[T_KKKEPESITESTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKAMIVEGZETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_4028421_4028422] FOREIGN KEY ([C_KKAMIVEGZETTSEGTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKAMIVEGZETTSEGTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028444_4028442] FOREIGN KEY ([C_KKAMIVEGZETTSEGID]) REFERENCES [dbo].[T_KKAMIVEGZETTSEG] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028414_4028415] FOREIGN KEY ([C_ELEKTRAKUTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKAMIELEKTROAKUTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_4028419_4028420] FOREIGN KEY ([C_KKGYOGYPEDTERTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKGYOGYPEDTERTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_KKJAZZZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028459_4028457] FOREIGN KEY ([C_KKAMIVEGZETTSEGID]) REFERENCES [dbo].[T_KKAMIVEGZETTSEG] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKJAZZZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028425_4028426] FOREIGN KEY ([C_JAZZZENETIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKAMIJAZZZENETIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028456_4028454] FOREIGN KEY ([C_KKAMIVEGZETTSEGID]) REFERENCES [dbo].[T_KKAMIVEGZETTSEG] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028423_4028424] FOREIGN KEY ([C_KLASSZUKUSZENETIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKAMIKLASSZIKUSTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_KKNEPZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028447_4028445] FOREIGN KEY ([C_KKAMIVEGZETTSEGID]) REFERENCES [dbo].[T_KKAMIVEGZETTSEG] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKNEPZENE] WITH NOCHECK
    ADD CONSTRAINT [FK_4028416_4028417] FOREIGN KEY ([C_NEPZENETIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKAMINEPZENETIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_4028409_4028411] FOREIGN KEY ([C_KKTANARVEGZETTSEGID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKVEGZETTSEGTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


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


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


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


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


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


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


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


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] WITH NOCHECK
    ADD CONSTRAINT [FK_4028407_4028408] FOREIGN KEY ([C_KKTANIOTOMUVTERTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKTANITOMUVTERTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028438_4028436] FOREIGN KEY ([C_KKTANARVEGZETTSEGID]) REFERENCES [dbo].[T_KKTANARVEGZETTSEG] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] WITH NOCHECK
    ADD CONSTRAINT [FK_4028428_4028429] FOREIGN KEY ([C_KKSZAKTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKSZAKTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


GO
ALTER TABLE [dbo].[T_KKTERULET] WITH NOCHECK
    ADD CONSTRAINT [FK_4028441_4028439] FOREIGN KEY ([C_KKAMIVEGZETTSEGID]) REFERENCES [dbo].[T_KKAMIVEGZETTSEG] ([ID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKTERULET] WITH NOCHECK
    ADD CONSTRAINT [FK_4028412_4028413] FOREIGN KEY ([C_AMITERULETTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_KKAMITERULETTIPUS] ([ID], [C_ALINTEZMENYID], [C_ALTANEVID]);


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


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


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


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


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


GO
ALTER TABLE [dbo].[T_KKVEGZETTSEGTIPUS] WITH NOCHECK
    ADD CONSTRAINT [FK_402839405_402839403] FOREIGN KEY ([C_ALTANEVID]) 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].[fnGetDokumentumIntezmenyPedagogusok]...';


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


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


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


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


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

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

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

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_TANULOESEMENY] WITH CHECK CHECK CONSTRAINT [FK_4025714_4025713];

ALTER TABLE [dbo].[T_NATKERDOIV] WITH CHECK CHECK CONSTRAINT [FK_4027951_4027949];

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_TEREM] WITH CHECK CHECK CONSTRAINT [FK_4026131_4026130];

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

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

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

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

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

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

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_TANITASIORA] WITH CHECK CHECK CONSTRAINT [FK_4025633_4025631];

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

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

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

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

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

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

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

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

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

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

ALTER TABLE [dbo].[T_KKAMIELEKTROAKUTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028401];

ALTER TABLE [dbo].[T_KKAMIELEKTROAKUTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839202_402839200];

ALTER TABLE [dbo].[T_KKAMIELEKTROAKUTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839205_402839203];

ALTER TABLE [dbo].[T_KKAMIJAZZZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028400];

ALTER TABLE [dbo].[T_KKAMIJAZZZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838902_402838900];

ALTER TABLE [dbo].[T_KKAMIJAZZZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838905_402838903];

ALTER TABLE [dbo].[T_KKAMIKLASSZIKUSTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028396];

ALTER TABLE [dbo].[T_KKAMIKLASSZIKUSTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838702_402838700];

ALTER TABLE [dbo].[T_KKAMIKLASSZIKUSTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838705_402838703];

ALTER TABLE [dbo].[T_KKAMINEPZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028404];

ALTER TABLE [dbo].[T_KKAMINEPZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839302_402839300];

ALTER TABLE [dbo].[T_KKAMINEPZENETIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839305_402839303];

ALTER TABLE [dbo].[T_KKAMITERULETTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028406];

ALTER TABLE [dbo].[T_KKAMITERULETTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839002_402839000];

ALTER TABLE [dbo].[T_KKAMITERULETTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839005_402839003];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028450_4028448];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402842102_402842100];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402842105_402842103];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028421_4028422];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028402];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839102_402839100];

ALTER TABLE [dbo].[T_KKAMIVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839105_402839103];

ALTER TABLE [dbo].[T_KKAMIZENEMUVKATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028395];

ALTER TABLE [dbo].[T_KKAMIZENEMUVKATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838302_402838300];

ALTER TABLE [dbo].[T_KKAMIZENEMUVKATTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838305_402838303];

ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH CHECK CHECK CONSTRAINT [FK_4028444_4028442];

ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH CHECK CHECK CONSTRAINT [FK_402841402_402841400];

ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH CHECK CHECK CONSTRAINT [FK_402841405_402841403];

ALTER TABLE [dbo].[T_KKELEKTROAKUZENE] WITH CHECK CHECK CONSTRAINT [FK_4028414_4028415];

ALTER TABLE [dbo].[T_KKGYOGYPEDTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028399];

ALTER TABLE [dbo].[T_KKGYOGYPEDTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838602_402838600];

ALTER TABLE [dbo].[T_KKGYOGYPEDTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838605_402838603];

ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028453_4028451];

ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402841902_402841900];

ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402841905_402841903];

ALTER TABLE [dbo].[T_KKGYOGYPEDVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028419_4028420];

ALTER TABLE [dbo].[T_KKJAZZZENE] WITH CHECK CHECK CONSTRAINT [FK_4028459_4028457];

ALTER TABLE [dbo].[T_KKJAZZZENE] WITH CHECK CHECK CONSTRAINT [FK_402842502_402842500];

ALTER TABLE [dbo].[T_KKJAZZZENE] WITH CHECK CHECK CONSTRAINT [FK_402842505_402842503];

ALTER TABLE [dbo].[T_KKJAZZZENE] WITH CHECK CHECK CONSTRAINT [FK_4028425_4028426];

ALTER TABLE [dbo].[T_KKKEPESITESJELLTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028460];

ALTER TABLE [dbo].[T_KKKEPESITESJELLTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402842702_402842700];

ALTER TABLE [dbo].[T_KKKEPESITESJELLTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402842705_402842703];

ALTER TABLE [dbo].[T_KKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028405];

ALTER TABLE [dbo].[T_KKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838502_402838500];

ALTER TABLE [dbo].[T_KKKEPESITESTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838505_402838503];

ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] WITH CHECK CHECK CONSTRAINT [FK_4028456_4028454];

ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] WITH CHECK CHECK CONSTRAINT [FK_402842302_402842300];

ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] WITH CHECK CHECK CONSTRAINT [FK_402842305_402842303];

ALTER TABLE [dbo].[T_KKKLASSZIKUSZENE] WITH CHECK CHECK CONSTRAINT [FK_4028423_4028424];

ALTER TABLE [dbo].[T_KKNEPZENE] WITH CHECK CHECK CONSTRAINT [FK_4028447_4028445];

ALTER TABLE [dbo].[T_KKNEPZENE] WITH CHECK CHECK CONSTRAINT [FK_402841602_402841600];

ALTER TABLE [dbo].[T_KKNEPZENE] WITH CHECK CHECK CONSTRAINT [FK_402841605_402841603];

ALTER TABLE [dbo].[T_KKNEPZENE] WITH CHECK CHECK CONSTRAINT [FK_4028416_4028417];

ALTER TABLE [dbo].[T_KKSZAKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028403];

ALTER TABLE [dbo].[T_KKSZAKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838402_402838400];

ALTER TABLE [dbo].[T_KKSZAKTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838405_402838403];

ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028435_4028433];

ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402840902_402840900];

ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402840905_402840903];

ALTER TABLE [dbo].[T_KKTANARVEGZETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028409_4028411];

ALTER TABLE [dbo].[T_KKTANITOMUVTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028397];

ALTER TABLE [dbo].[T_KKTANITOMUVTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838802_402838800];

ALTER TABLE [dbo].[T_KKTANITOMUVTERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402838805_402838803];

ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028432_4028430];

ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402840702_402840700];

ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] WITH CHECK CHECK CONSTRAINT [FK_402840705_402840703];

ALTER TABLE [dbo].[T_KKTANITOVEZGETTSEG] WITH CHECK CHECK CONSTRAINT [FK_4028407_4028408];

ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_4028438_4028436];

ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_402842802_402842800];

ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_402842805_402842803];

ALTER TABLE [dbo].[T_KKTANTARGYKATEGORIA] WITH CHECK CHECK CONSTRAINT [FK_4028428_4028429];

ALTER TABLE [dbo].[T_KKTERULET] WITH CHECK CHECK CONSTRAINT [FK_4028441_4028439];

ALTER TABLE [dbo].[T_KKTERULET] WITH CHECK CHECK CONSTRAINT [FK_402841202_402841200];

ALTER TABLE [dbo].[T_KKTERULET] WITH CHECK CHECK CONSTRAINT [FK_402841205_402841203];

ALTER TABLE [dbo].[T_KKTERULET] WITH CHECK CHECK CONSTRAINT [FK_4028412_4028413];

ALTER TABLE [dbo].[T_KKVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_T_21038_4028398];

ALTER TABLE [dbo].[T_KKVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839402_402839400];

ALTER TABLE [dbo].[T_KKVEGZETTSEGTIPUS] WITH CHECK CHECK CONSTRAINT [FK_402839405_402839403];


GO
PRINT N'Update complete.';


GO


--------------------


PRINT '--- intézményi view-k (dbo táblákkal megegyezõ nevû és a tábla_OSSZES nevûek) frissítése ---'

DECLARE  @viewname nvarchar(100), @pureview nvarchar(100)

DECLARE semaviewk CURSOR LOCAL FOR 
  SELECT '['+TABLE_SCHEMA + '].[' + TABLE_NAME + ']', TABLE_NAME
  FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_TYPE = 'VIEW' and TABLE_SCHEMA LIKE 'KR[_]%[_]Schema'
  AND TABLE_NAME in ('T_ALKALMAZOTT', 'T_ALKALMAZOTT_OSSZES') -- ha csak néhány VIEW frissült, akkor a gyorsabb futásért ide fel lehet sorolni
  ORDER BY TABLE_SCHEMA, TABLE_NAME

OPEN semaviewk
FETCH NEXT FROM semaviewk INTO @viewname, @pureview

WHILE @@FETCH_STATUS = 0 BEGIN
    PRINT @viewname
    EXEC sp_refreshview @viewname

    FETCH NEXT FROM semaviewk INTO @viewname, @pureview
END             

CLOSE semaviewk
DEALLOCATE semaviewk
GO

