﻿--Migration
/*============================================================================*/
/* Table : T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS                                  */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_OfUzenofalEngedelyezesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS                                  */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_OfCsatolasEngedelyezesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_OFEGYEDIERTEKELESTIPUS                                       */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_OFEGYEDIERTEKELESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_OfEgyediErtekelesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS                                  */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_HfUzenofalEngedelyezesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_ALKALMAZOTTBEALLITAS                                             */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_ALKALMAZOTTBEALLITAS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_AVATARELERES                    nvarchar(1000)                   NULL,
    C_AVATARTIPUSID                   int                              DEFAULT 0 NOT NULL,
    C_CSAKTANARIRHATUZENOFALRATIPU    int                              DEFAULT 0 NOT NULL,
    C_ELSOBELEPES                     datetime                         NOT NULL,
    C_EMAILCIM                        nvarchar(200)                    NOT NULL,
    C_HFBEADANDOTIPUSID               int                              DEFAULT 0 NOT NULL,
    C_HFCSATOLASENGEDELYEZESTIPUSI    int                              DEFAULT 0 NOT NULL,
    C_HFELOREBEIRTFELADATMEGJELENI    int                              DEFAULT 0 NOT NULL,
    C_HFERTEKLESTIPUSID               int                              DEFAULT 0 NOT NULL,
    C_HFUZENOFALENGEDELYEZESTIPUSI    int                              DEFAULT 0 NOT NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'T' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'T' NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_MINDENUZENETKOZPONTIFALONTIP    int                              DEFAULT 0 NOT NULL,
    C_NEV                             nvarchar(1000)                   NULL,
    C_OFBEADANDOTIPUSID               int                              DEFAULT 0 NOT NULL,
    C_OFCSATOLASENGEDELYEZESTIPUSI    int                              DEFAULT 0 NOT NULL,
    C_OFEGYEDIERTEKELESTIPUSID        int                              DEFAULT 0 NOT NULL,
    C_OFELOREBEIRTFELADATMEGJELENI    int                              DEFAULT 0 NOT NULL,
    C_OFERTEKELESTIPUSID              int                              DEFAULT 0 NOT NULL,
    C_OFUZENOFALENGEDELYEZESTIPUSI    int                              DEFAULT 0 NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_UTOLSOBELEPES                   datetime                         NOT NULL,
    C_UTOLSOELOTTIBELEPES             datetime                         NULL,
    C_ALKALMAZOTTID                   int                              NOT NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_AlkalmazottBeallitas PRIMARY KEY (ID)  
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_OFERTEKLESTIPUS                                              */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_OFERTEKLESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_OfErteklesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_OFBEADANDOTIPUS                                              */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_OFBEADANDOTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_OfBeadandoTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS                                  */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_HfCsatolasEngedelyezesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS                               */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_MindenUzenetKozpontiFalonTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS                                */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_CsakTanarIrhatUzenofalraTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_HFERTEKLESTIPUS                                              */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_HFERTEKLESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_HfErteklesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_AVATARTIPUS                                                  */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_AVATARTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_AvatarTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE                             */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_OfEloreBeirtFeladatMegjelenitese PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_TANULOFELADATBEADASSTATUSZ                                   */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_TANULOFELADATBEADASSTATUSZ (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_TanuloFeladatbeadasStatusz PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_TANULOFELADATBEADAS                                              */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_TANULOFELADATBEADAS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_FELADATERTEKELESTIPUSID         int                              NULL,
    C_INTEZMENYGUID                   uniqueidentifier                 NOT NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'T' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'T' NOT NULL,
    C_LETREHOZVA                      datetime                         DEFAULT GETDATE() NOT NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_PONTSZAM                        numeric(10,2)                    NULL,
    C_SZOVEG                          nvarchar(max)                    NULL,
    C_TANULOFELADATBEADASSTATUSZID    int                              NULL,
    C_UTOLSOMODOSITASIDOPONT          datetime                         DEFAULT GETDATE() NOT NULL,
    C_TANULOERTEKELESID               int                              NULL,
    C_TANULOID                        int                              NOT NULL,
    C_FELADATID                       int                              NOT NULL,
    C_JAVITOALKALMAZOTTID             int                              NULL,
    C_ERTEKELOALKALMAZOTTID           int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_TanuloFeladatbeadas PRIMARY KEY (ID)  
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE                             */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_HfEloreBeirtFeladatMegjelenitese PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_HFBEADANDOTIPUS                                              */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_HFBEADANDOTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_HfBeadandoTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_FELADAT                                                          */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_FELADAT (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_BEADASHATARIDO                  datetime                         DEFAULT GETDATE() NOT NULL,
    C_CIM                             nvarchar(255)                    NULL,
    C_DATUM                           datetime                         NULL,
    C_FELADATERTEKELESTIPUSID         int                              NULL,
    C_FELADATTIPUSID                  int                              NULL,
    C_IDOPONT                         datetime                         NULL,
    C_INTEZMENYGUID                   uniqueidentifier                 NOT NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISKRETAFELADAT                  char(1)                          DEFAULT 'F' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'T' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'T' NOT NULL,
    C_LATHATOSAGIDOPONT               datetime                         DEFAULT GETDATE() NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NULL,
    C_ORARENDIORAGROUPID              int                              NULL,
    C_ORASZAM                         int                              NULL,
    C_ROGZITESIDOPONT                 datetime                         DEFAULT GETDATE() NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SZOVEG                          nvarchar(max)                    NOT NULL,
    C_HFBEADANDOTIPUSID               int                              NULL,
    C_HFCSATOLASENGEDELYEZESTIPUSI    int                              NULL,
    C_HFELOREBEIRTFELADATMEGJELENI    int                              NULL,
    C_OFBEADANDOTIPUSID               int                              NULL,
    C_OFCSATOLASENGEDELYEZESTIPUSI    int                              NULL,
    C_OFELOREBEIRTFELADATMEGJELENI    int                              NULL,
    C_TANITASIORAID                   int                              NULL,
    C_TANTARGYID                      int                              NOT NULL,
    C_OSZTALYCSOPORTID                int                              NOT NULL,
    C_ALKALMAZOTTID                   int                              NOT NULL,
    C_HELYETTESITOALKALMAZOTTID       int                              NULL,
    C_ROGZITOALKALMAZOTTID            int                              NOT NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_Feladat PRIMARY KEY (ID)  
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_FELADATTIPUS                                                 */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_FELADATTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_FeladatTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO
/*============================================================================*/
/* Table : T_DKT_DIC_FELADATERTEKELESTIPUS                                        */
/*============================================================================*/
/* Package: Kreta */
  
CREATE TABLE  [dbo].T_DKT_DIC_FELADATERTEKELESTIPUS (
    ID                                int                              NOT NULL IDENTITY(1,1),
    C_ALIASNEV                        nvarchar(1000)                   NULL,
    C_ISAKTIV                         char(1)                          DEFAULT 'T' NOT NULL,
    C_ISLATHATO                       char(1)                          DEFAULT 'T' NOT NULL,
    C_ISMODOSITHATO                   char(1)                          DEFAULT 'F' NOT NULL,
    C_ISTOROLHETO                     char(1)                          DEFAULT 'F' NOT NULL,
    C_KATEGORIAID                     int                              DEFAULT 0 NOT NULL,
    C_LEIRAS                          nvarchar(1000)                   NULL,
    C_MEGJEGYZES                      nvarchar(1000)                   NULL,
    C_NEV                             nvarchar(1000)                   NOT NULL,
    C_ROVIDNEV                        nvarchar(255)                    NULL,
    C_SORSZAM                         int                              DEFAULT 0 NOT NULL,
    C_SZINKOD                         int                              NULL,
    C_INTEZMENYID                     int                              NOT NULL,
    C_TANEVID                         int                              NOT NULL,
    TOROLT                            char(1)                          NOT NULL DEFAULT 'F',
    SERIAL                            int                              DEFAULT 0 NOT NULL,
    LASTCHANGED                       datetime                         DEFAULT GETDATE() NOT NULL,
    CREATED                           datetime                         DEFAULT GETDATE() NOT NULL,
    MODIFIER                          int                              NULL,
    CREATOR                           int                              NULL,
    DELETER                           int                              NULL,
    DELETED                           datetime                         NULL,
    STATUSID                          int                              DEFAULT 0 NOT NULL,
    UNIQUEID                          uniqueidentifier                 DEFAULT NEWID() NOT NULL,
    ACLCODE                           NVARCHAR(1000) NULL,
    CONSTRAINT PK_DKT_DIC_FeladatErtekelesTipus PRIMARY KEY (ID, C_INTEZMENYID, C_TANEVID)
)
GO