3006 lines
105 KiB
Transact-SQL
3006 lines
105 KiB
Transact-SQL
/*
|
|
The column [dbo].[T_DKT_FILE].[C_FILESIZEMB] is being dropped, data loss could occur.
|
|
*/
|
|
|
|
|
|
PRINT N'Dropping unnamed constraint on [dbo].[T_DKT_TANULOFELADATBEADASFILE]...';
|
|
|
|
|
|
GO
|
|
EXEC dev.uspDropDefaultConstraint @pTableName = 'T_DKT_TANULOFELADATBEADASFILE', @pColumnName = 'C_ISTOROLHETO'
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_AVATARTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_AVATARTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_CSAKTANARIRHATUZENOFALRATIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_FELADATERTEKELESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_FELADATERTEKELESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_FELADATTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_FELADATTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_HFBEADANDOTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_HFBEADANDOTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_HFCSATOLASENGEDELYEZESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_HFELOREBEIRTFELADATMEGJELENITESE] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_HFERTEKLESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_HFERTEKLESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_HFUZENOFALENGEDELYEZESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MINDENUZENETKOZPONTIFALONTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_OFBEADANDOTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_OFBEADANDOTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_OFCSATOLASENGEDELYEZESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_OFEGYEDIERTEKELESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_OFELOREBEIRTFELADATMEGJELENITESE] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_OFERTEKLESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_OFERTEKLESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_OFUZENOFALENGEDELYEZESTIPUS] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_DIC_TANULOFELADATBEADASSTATUSZ]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_TANULOFELADATBEADASSTATUSZ] ALTER COLUMN [C_NEV] NVARCHAR (1000) NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_FELADAT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_FELADAT]
|
|
ADD [C_ISERTESITESKIKULDVE] CHAR (1) DEFAULT ('F') NOT NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_FILE]...';
|
|
GO
|
|
|
|
|
|
ALTER TABLE [dbo].T_DKT_FILE ADD
|
|
C_FILESIZEBYTE int NULL
|
|
GO
|
|
/* valójában kB volt tárolva, nem MB */
|
|
|
|
UPDATE [T_DKT_FILE] SET C_FILESIZEBYTE = CAST([C_FILESIZEMB] * 1024 AS INT)
|
|
GO
|
|
|
|
ALTER TABLE [dbo].T_DKT_FILE DROP COLUMN [C_FILESIZEMB]
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_DKT_TANULOFELADATBEADASFILE]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOFELADATBEADASFILE] ALTER COLUMN [C_ISTOROLHETO] CHAR (1) NOT NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_TANULO]...';
|
|
|
|
|
|
GO
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_KATEGORIAID] INT NOT NULL,
|
|
[C_SORSZAM] INT NOT NULL,
|
|
[C_SZINKOD] INT 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_DIC_MunkaterTipus] PRIMARY KEY CLUSTERED ([ID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_KATEGORIAID] INT NOT NULL,
|
|
[C_SORSZAM] INT NOT NULL,
|
|
[C_SZINKOD] INT 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_DIC_UzenetForrasTipus] PRIMARY KEY CLUSTERED ([ID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_KATEGORIAID] INT NOT NULL,
|
|
[C_SORSZAM] INT NOT NULL,
|
|
[C_SZINKOD] INT 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_DIC_UzenetLathatosag] PRIMARY KEY CLUSTERED ([ID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_KATEGORIAID] INT NOT NULL,
|
|
[C_SORSZAM] INT NOT NULL,
|
|
[C_SZINKOD] INT 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_DIC_UzenofalTipus] PRIMARY KEY CLUSTERED ([ID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_INTEZMENYGUID] UNIQUEIDENTIFIER NOT NULL,
|
|
[C_TANULOID] INT NULL,
|
|
[C_ALKALMAZOTTID] INT NULL,
|
|
[C_UZENOFALID] 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_EgyediUzenofalFelhasznalo] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_TANULOBEALLITAS] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_AVATARELERES] NVARCHAR (1000) NULL,
|
|
[C_AVATARTIPUSID] INT NULL,
|
|
[C_ELSOBELEPES] DATETIME NOT NULL,
|
|
[C_EMAILCIM] NVARCHAR (200) NOT NULL,
|
|
[C_UTOLSOBELEPES] DATETIME NOT NULL,
|
|
[C_UTOLSOELOTTIBELEPES] DATETIME NULL,
|
|
[C_TANULOID] 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_TanuloBeallitas] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_DATUM] DATETIME NOT NULL,
|
|
[C_FORRASTIPUSID] INT NULL,
|
|
[C_INTEZMENYGUID] UNIQUEIDENTIFIER NOT NULL,
|
|
[C_LATHATOSAGID] INT NULL,
|
|
[C_SZOVEG] NVARCHAR (2000) NOT NULL,
|
|
[C_TANULOID] INT NULL,
|
|
[C_ALKALMAZOTTID] INT NULL,
|
|
[C_UZENETID] INT NULL,
|
|
[C_UZENOFALID] 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_DATUM] DATETIME NOT NULL,
|
|
[C_FORRASTIPUSID] INT NOT NULL,
|
|
[C_INTEZMENYGUID] UNIQUEIDENTIFIER NOT NULL,
|
|
[C_LATHATOSAGID] INT NULL,
|
|
[C_SZOVEG] NVARCHAR (20) NOT NULL,
|
|
[C_ALKALMAZOTTID] INT NULL,
|
|
[C_UZENOFALID] INT NULL,
|
|
[C_UZENETID] INT 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_UzenetAlkalmazottUzenofal] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_DATUM] DATETIME NOT NULL,
|
|
[C_FORRASTIPUSID] INT NOT NULL,
|
|
[C_INTEZMENYGUID] UNIQUEIDENTIFIER NOT NULL,
|
|
[C_LATHATOSAGID] INT NOT NULL,
|
|
[C_ORADATUM] DATETIME NULL,
|
|
[C_ORAIDOPONT] DATETIME NULL,
|
|
[C_ORARENDIORAGROUPID] INT NULL,
|
|
[C_ORASZAM] INT NULL,
|
|
[C_SZOVEG] NVARCHAR (2000) NOT NULL,
|
|
[C_TANULOID] INT NULL,
|
|
[C_UZENETID] INT NULL,
|
|
[C_TANITASIORAID] INT NULL,
|
|
[C_ALKALMAZOTTID] INT NULL,
|
|
[C_FELADATID] INT NULL,
|
|
[C_UZENOFALID] INT 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_UzenetMunkaterUzenofal] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_DKT_UZENOFAL] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_ISAKTIV] CHAR (1) NOT NULL,
|
|
[C_ISMODOSITHATO] CHAR (1) NOT NULL,
|
|
[C_ISTOROLHETO] CHAR (1) NOT NULL,
|
|
[C_ISLATHATO] CHAR (1) NOT NULL,
|
|
[C_NEV] NVARCHAR (1000) NULL,
|
|
[C_ROVIDNEV] NVARCHAR (255) NULL,
|
|
[C_ALIASNEV] NVARCHAR (1000) NULL,
|
|
[C_LEIRAS] NVARCHAR (1000) NULL,
|
|
[C_MEGJEGYZES] NVARCHAR (1000) NULL,
|
|
[C_ALKALMAZOTTGUID] UNIQUEIDENTIFIER NULL,
|
|
[C_INTEZMENYGUID] UNIQUEIDENTIFIER NOT NULL,
|
|
[C_TIPUSID] INT NOT NULL,
|
|
[C_TANTARGYID] INT NULL,
|
|
[C_FELADATID] INT NULL,
|
|
[C_ALKALMAZOTTID] INT NULL,
|
|
[C_OSZTALYCSOPORTID] INT NULL,
|
|
[C_TANULOFELADATBEADASID] INT 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,
|
|
[DELETER] INT NULL,
|
|
[DELETED] DATETIME NULL,
|
|
[STATUSID] INT NOT NULL,
|
|
[UNIQUEID] UNIQUEIDENTIFIER NOT NULL,
|
|
[ACLCODE] NVARCHAR (1000) NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
CONSTRAINT [PK_DKT_Uzenofal] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOFELADATBEADASFILE]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOFELADATBEADASFILE]
|
|
ADD DEFAULT ('T') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ('F') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ('F') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ((0)) FOR [C_SORSZAM];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ((0)) FOR [C_KATEGORIAID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_MUNKATERTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ((0)) FOR [C_SORSZAM];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ('F') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ('F') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ((0)) FOR [C_KATEGORIAID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ('F') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ('F') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ((0)) FOR [C_KATEGORIAID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ((0)) FOR [C_SORSZAM];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENETLATHATOSAG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ((0)) FOR [C_SORSZAM];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ('F') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ('F') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT ((0)) FOR [C_KATEGORIAID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_DIC_UZENOFALTIPUS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT ('T') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT ('T') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ('T') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ((0)) FOR [C_AVATARTIPUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ('T') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_TANULOBEALLITAS]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ((1)) FOR [C_FORRASTIPUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [C_DATUM];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ((1)) FOR [C_FORRASTIPUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [C_DATUM];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [C_DATUM];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ((1)) FOR [C_LATHATOSAGID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ((2)) FOR [C_FORRASTIPUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISTOROLHETO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT (newid()) FOR [UNIQUEID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISMODOSITHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [C_TIPUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISLATHATO];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ('T') FOR [C_ISAKTIV];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_DKT_UZENOFAL]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL]
|
|
ADD DEFAULT ((0)) FOR [STATUSID];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_MunkaterTipus_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
ALTER TABLE [DBO].T_DKT_TANULOBEALLITAS
|
|
ADD CONSTRAINT FK_DKT_TanuloBeallitas_TanuloId_REF_Tanulo FOREIGN KEY (C_TANULOID) REFERENCES [dbo].T_TANULO (ID)
|
|
GO
|
|
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_MunkaterTipus_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_MunkaterTipus_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_MunkaterTipus_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_UzenetForrasTipus_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_UzenetForrasTipus_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_UzenetForrasTipus_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_UzenetForrasTipus_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_UzenetLathatosag_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_UzenetLathatosag_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_UzenetLathatosag_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_UzenetLathatosag_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_UzenofalTipus_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_UzenofalTipus_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_DIC_UzenofalTipus_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_DIC_UzenofalTipus_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_EgyediUzenofalFelhasznalo_TanuloId_REF_Tanulo]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_TanuloId_REF_Tanulo] FOREIGN KEY ([C_TANULOID]) REFERENCES [dbo].[T_TANULO] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_EgyediUzenofalFelhasznalo_AlkalmazottId_REF_Alkalmazott]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_AlkalmazottId_REF_Alkalmazott] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_EgyediUzenofalFelhasznalo_UzenofalId_REF_DKT_Uzenofal]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_UzenofalId_REF_DKT_Uzenofal] FOREIGN KEY ([C_UZENOFALID]) REFERENCES [dbo].[T_DKT_UZENOFAL] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_EgyediUzenofalFelhasznalo_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_EgyediUzenofalFelhasznalo_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_TanuloBeallitas_AvatarTipusId_IntezmenyId_TanevId_REF_DKT_DIC_AvatarTipus]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_TanuloBeallitas_AvatarTipusId_IntezmenyId_TanevId_REF_DKT_DIC_AvatarTipus] FOREIGN KEY ([C_AVATARTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_AVATARTIPUS] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_TanuloBeallitas_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_TanuloBeallitas_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_TanuloBeallitas_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_TanuloBeallitas_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_TanuloId_REF_Tanulo]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_TanuloId_REF_Tanulo] FOREIGN KEY ([C_TANULOID]) REFERENCES [dbo].[T_TANULO] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_AlkalmazottId_REF_Alkalmazott]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_AlkalmazottId_REF_Alkalmazott] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_UzenetId_REF_DKT_UzenetAlkalmazottUzenofal]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_UzenetId_REF_DKT_UzenetAlkalmazottUzenofal] FOREIGN KEY ([C_UZENETID]) REFERENCES [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_UzenofalId_REF_DKT_Uzenofal]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_UzenofalId_REF_DKT_Uzenofal] FOREIGN KEY ([C_UZENOFALID]) REFERENCES [dbo].[T_DKT_UZENOFAL] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus] FOREIGN KEY ([C_FORRASTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag] FOREIGN KEY ([C_LATHATOSAGID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_UZENETLATHATOSAG] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus] FOREIGN KEY ([C_FORRASTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag] FOREIGN KEY ([C_LATHATOSAGID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_UZENETLATHATOSAG] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottUzenofal_AlkalmazottId_REF_Alkalmazott]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_AlkalmazottId_REF_Alkalmazott] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottUzenofal_UzenofalId_REF_DKT_Uzenofal]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_UzenofalId_REF_DKT_Uzenofal] FOREIGN KEY ([C_UZENOFALID]) REFERENCES [dbo].[T_DKT_UZENOFAL] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottUzenofal_UzenetId_REF_DKT_UzenetAlkalmazottUzenofal]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_UzenetId_REF_DKT_UzenetAlkalmazottUzenofal] FOREIGN KEY ([C_UZENETID]) REFERENCES [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottUzenofal_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetAlkalmazottUzenofal_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus] FOREIGN KEY ([C_FORRASTIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag] FOREIGN KEY ([C_LATHATOSAGID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_UZENETLATHATOSAG] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_TanuloId_REF_Tanulo]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_TanuloId_REF_Tanulo] FOREIGN KEY ([C_TANULOID]) REFERENCES [dbo].[T_TANULO] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_UzenetId_REF_DKT_UzenetMunkaterUzenofal]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_UzenetId_REF_DKT_UzenetMunkaterUzenofal] FOREIGN KEY ([C_UZENETID]) REFERENCES [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_TanitasiOraId_REF_TanitasiOra]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_TanitasiOraId_REF_TanitasiOra] FOREIGN KEY ([C_TANITASIORAID]) REFERENCES [dbo].[T_TANITASIORA] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_AlkalmazottId_REF_Alkalmazott]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_AlkalmazottId_REF_Alkalmazott] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_FeladatId_REF_DKT_Feladat]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_FeladatId_REF_DKT_Feladat] FOREIGN KEY ([C_FELADATID]) REFERENCES [dbo].[T_DKT_FELADAT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_UzenofalId_REF_DKT_Uzenofal]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_UzenofalId_REF_DKT_Uzenofal] FOREIGN KEY ([C_UZENOFALID]) REFERENCES [dbo].[T_DKT_UZENOFAL] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_UzenetMunkaterUzenofal_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_TantargyId_REF_Tantargy]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_TantargyId_REF_Tantargy] FOREIGN KEY ([C_TANTARGYID]) REFERENCES [dbo].[T_TANTARGY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_FeladatId_REF_DKT_Feladat]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_FeladatId_REF_DKT_Feladat] FOREIGN KEY ([C_FELADATID]) REFERENCES [dbo].[T_DKT_FELADAT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_TipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenofalTipus]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_TipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenofalTipus] FOREIGN KEY ([C_TIPUSID], [C_INTEZMENYID], [C_TANEVID]) REFERENCES [dbo].[T_DKT_DIC_UZENOFALTIPUS] ([ID], [C_INTEZMENYID], [C_TANEVID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_AlkalmazottId_REF_Alkalmazott]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_AlkalmazottId_REF_Alkalmazott] FOREIGN KEY ([C_ALKALMAZOTTID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_OsztalyCsoportId_REF_OsztalyCsoport]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_OsztalyCsoportId_REF_OsztalyCsoport] FOREIGN KEY ([C_OSZTALYCSOPORTID]) REFERENCES [dbo].[T_OSZTALYCSOPORT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_TanuloFeladatbeadasId_REF_DKT_TanuloFeladatbeadas]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_TanuloFeladatbeadasId_REF_DKT_TanuloFeladatbeadas] FOREIGN KEY ([C_TANULOFELADATBEADASID]) REFERENCES [dbo].[T_DKT_TANULOFELADATBEADAS] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_IntezmenyId_REF_Intezmeny]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_IntezmenyId_REF_Intezmeny] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_DKT_Uzenofal_TanevId_REF_Tanev]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_DKT_Uzenofal_TanevId_REF_Tanev] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_Tanulo_DKT_TanuloBeallitasId_REF_DKT_TanuloBeallitas]...';
|
|
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_MUNKATERTIPUS].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_MUNKATERTIPUS', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETFORRASTIPUS].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETFORRASTIPUS', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENETLATHATOSAG].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENETLATHATOSAG', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_DIC_UZENOFALTIPUS].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_DIC_UZENOFALTIPUS', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_EGYEDIUZENOFALFELHASZNALO', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_TANULOBEALLITAS].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_TANULOBEALLITAS', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETALKALMAZOTTUZENOFAL', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENETMUNKATERUZENOFAL].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENETMUNKATERUZENOFAL', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[ID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord egyedi azonosítója, generált IDENTITY(1, 1) (kivéve altáblák esetén, ahol a főtábla ID-ját kapja)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'ID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[C_INTEZMENYID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Az intézmény ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'C_INTEZMENYID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[C_TANEVID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A tanév ID-ja, amihez a rekord tartozik', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'C_TANEVID';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[TOROLT].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord logikai töröltségét jelző flag', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'TOROLT';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[SERIAL].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'Minden C# kódból történő módosítás esetén eggyel nő az értéke. Hogy párhuzamos módosítás esetnán ne íródjanak felül az adatok', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'SERIAL';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[LASTCHANGED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N' A rekord utolsó módosításának időpontja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'LASTCHANGED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[CREATED].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord létrehozásának időpontja ', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATED';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[MODIFIER].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot utoljára módosító felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'MODIFIER';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[CREATOR].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekordot létrehozó felhasználó ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'CREATOR';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_DKT_UZENOFAL].[ELOZOTANEVIREKORDID].[MS_Description]...';
|
|
|
|
|
|
GO
|
|
EXECUTE dev.uspAddOrUpdateExtendedProperty @name = N'MS_Description', @value = N'A rekord előző tanévben lévő ID-ja', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'T_DKT_UZENOFAL', @level2type = N'COLUMN', @level2name = N'ELOZOTANEVIREKORDID';
|
|
PRINT N'Checking existing data against newly created constraints';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_MunkaterTipus_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_DIC_MUNKATERTIPUS] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_MunkaterTipus_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_UzenetForrasTipus_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETFORRASTIPUS] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_UzenetForrasTipus_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_UzenetLathatosag_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENETLATHATOSAG] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_UzenetLathatosag_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_UzenofalTipus_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_DIC_UZENOFALTIPUS] WITH CHECK CHECK CONSTRAINT [FK_DKT_DIC_UzenofalTipus_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH CHECK CHECK CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_TanuloId_REF_Tanulo];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH CHECK CHECK CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_AlkalmazottId_REF_Alkalmazott];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH CHECK CHECK CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_UzenofalId_REF_DKT_Uzenofal];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH CHECK CHECK CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_EGYEDIUZENOFALFELHASZNALO] WITH CHECK CHECK CONSTRAINT [FK_DKT_EgyediUzenofalFelhasznalo_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS] WITH CHECK CHECK CONSTRAINT [FK_DKT_TanuloBeallitas_AvatarTipusId_IntezmenyId_TanevId_REF_DKT_DIC_AvatarTipus];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS] WITH CHECK CHECK CONSTRAINT [FK_DKT_TanuloBeallitas_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS] WITH CHECK CHECK CONSTRAINT [FK_DKT_TanuloBeallitas_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_TanuloId_REF_Tanulo];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_AlkalmazottId_REF_Alkalmazott];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_UzenetId_REF_DKT_UzenetAlkalmazottUzenofal];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_UzenofalId_REF_DKT_Uzenofal];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTTANULOPRIVATUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottTanuloPrivatUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_AlkalmazottId_REF_Alkalmazott];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_UzenofalId_REF_DKT_Uzenofal];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_UzenetId_REF_DKT_UzenetAlkalmazottUzenofal];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETALKALMAZOTTUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetAlkalmazottUzenofal_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_ForrasTipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetForrasTipus];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_LathatosagId_IntezmenyId_TanevId_REF_DKT_DIC_UzenetLathatosag];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_TanuloId_REF_Tanulo];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_UzenetId_REF_DKT_UzenetMunkaterUzenofal];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_TanitasiOraId_REF_TanitasiOra];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_AlkalmazottId_REF_Alkalmazott];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_FeladatId_REF_DKT_Feladat];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_UzenofalId_REF_DKT_Uzenofal];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENETMUNKATERUZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_UzenetMunkaterUzenofal_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_TantargyId_REF_Tantargy];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_FeladatId_REF_DKT_Feladat];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_TipusId_IntezmenyId_TanevId_REF_DKT_DIC_UzenofalTipus];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_AlkalmazottId_REF_Alkalmazott];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_OsztalyCsoportId_REF_OsztalyCsoport];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_TanuloFeladatbeadasId_REF_DKT_TanuloFeladatbeadas];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_IntezmenyId_REF_Intezmeny];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_UZENOFAL] WITH CHECK CHECK CONSTRAINT [FK_DKT_Uzenofal_TanevId_REF_Tanev];
|
|
|
|
ALTER TABLE [dbo].[T_DKT_TANULOBEALLITAS] WITH CHECK CHECK CONSTRAINT [FK_DKT_TanuloBeallitas_TanuloId_REF_Tanulo]
|
|
GO
|
|
|
|
GO
|
|
PRINT N'Update complete.';
|
|
|
|
GO
|