﻿GO
PRINT N'Altering [dbo].[T_KIZAROCSOPORT]...';


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORT] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KIZAROCSOPORT] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KIZAROCSOPORT] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_KIZAROCSOPORT] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_KIZAROCSOPORTTIPUS]...';


GO
ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_KIZAROCSOPORTTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_KOZOSSEGISZOLGALATTIPUS]...';


GO
ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_KOZOSSEGISZOLGALATTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_KOZTERULETJELLEG]...';


GO
ALTER TABLE [dbo].[T_KOZTERULETJELLEG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KOZTERULETJELLEG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KOZTERULETJELLEG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_KOZTERULETJELLEG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_KRETATIPUS]...';


GO
ALTER TABLE [dbo].[T_KRETATIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KRETATIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KRETATIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_KRETATIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_KULFOLDISTATUSZTIPUS]...';


GO
ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_KULFOLDISTATUSZTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_LANGUAGE]...';


GO
ALTER TABLE [dbo].[T_LANGUAGE] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LANGUAGE] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LANGUAGE] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_LANGUAGE] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_LATASSERULTTIPUS]...';


GO
ALTER TABLE [dbo].[T_LATASSERULTTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LATASSERULTTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LATASSERULTTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_LATASSERULTTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_LOG]...';


GO
ALTER TABLE [dbo].[T_LOG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_LOG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_LOGEVENTTYPE]...';


GO
ALTER TABLE [dbo].[T_LOGEVENTTYPE] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGEVENTTYPE] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGEVENTTYPE] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_LOGEVENTTYPE] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_LOGINLINKS]...';


GO
ALTER TABLE [dbo].[T_LOGINLINKS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGINLINKS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGINLINKS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_LOGINLINKS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_LOGINNEWS]...';


GO
ALTER TABLE [dbo].[T_LOGINNEWS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGINNEWS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGINNEWS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_LOGINNEWS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_LOGLEVELTYPE]...';


GO
ALTER TABLE [dbo].[T_LOGLEVELTYPE] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGLEVELTYPE] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_LOGLEVELTYPE] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_LOGLEVELTYPE] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MAGANTANULOSAGOKA]...';


GO
ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MAGANTANULOSAGOKA] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MAGATARTASERTEKELESTIPUS]...';


GO
ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MAGATARTASERTEKELESTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MARITALSTATUS]...';


GO
ALTER TABLE [dbo].[T_MARITALSTATUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MARITALSTATUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MARITALSTATUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MARITALSTATUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MEGYE]...';


GO
ALTER TABLE [dbo].[T_MEGYE] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MEGYE] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MEGYE] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MEGYE] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MERTEKEGYSEGTIPUS]...';


GO
ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MERTEKEGYSEGTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MESSAGE]...';


GO
ALTER TABLE [dbo].[T_MESSAGE] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MESSAGE] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MESSAGE] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MESSAGE] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MESSAGESTATUS]...';


GO
ALTER TABLE [dbo].[T_MESSAGESTATUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MESSAGESTATUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MESSAGESTATUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MESSAGESTATUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MUKODESIHELY]...';


GO
ALTER TABLE [dbo].[T_MUKODESIHELY] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELY] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELY] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELY] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Creating [dbo].[T_MUKODESIHELY].[UK_4025200]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_4025200]
    ON [dbo].[T_MUKODESIHELY]([C_NEV] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


GO
PRINT N'Altering [dbo].[T_MUKODESIHELYADATSZOLGALTATAS]...';


GO
ALTER TABLE [dbo].[T_MUKODESIHELYADATSZOLGALTATAS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELYADATSZOLGALTATAS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELYADATSZOLGALTATAS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELYADATSZOLGALTATAS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MUKODESIHELYTIPUS]...';


GO
ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUKODESIHELYTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MULASZTASSTATISZTIKATIPUS]...';


GO
ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MULASZTASSTATISZTIKATIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MULASZTASTIPUS]...';


GO
ALTER TABLE [dbo].[T_MULASZTASTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MULASZTASTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MULASZTASTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MULASZTASTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MUNKAIDOKEDVEZMENYOKA]...';


GO
ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUNKAIDOKEDVEZMENYOKA] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MUNKAKORTIPUS]...';


GO
ALTER TABLE [dbo].[T_MUNKAKORTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAKORTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAKORTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUNKAKORTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MUNKAUGYIADATOK]...';


GO
ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUNKAUGYIADATOK] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MUNKAVISZONYJELLEGE]...';


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUNKAVISZONYJELLEGE] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_MUNKAVISZONYTIPUS]...';


GO
ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_MUNKAVISZONYTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_NAPLOELLENORZES]...';


GO
ALTER TABLE [dbo].[T_NAPLOELLENORZES] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPLOELLENORZES] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPLOELLENORZES] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NAPLOELLENORZES] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_NAPTARIHET]...';


GO
ALTER TABLE [dbo].[T_NAPTARIHET] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPTARIHET] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPTARIHET] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NAPTARIHET] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_NAPTARINAP]...';


GO
ALTER TABLE [dbo].[T_NAPTARINAP] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPTARINAP] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPTARINAP] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NAPTARINAP] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Creating [dbo].[T_NAPTARINAP].[IX_NAPTARINAP_INTEZMENYID_TANEVID_NAPDATUMA_ORARENDINAP]...';


GO
CREATE NONCLUSTERED INDEX [IX_NAPTARINAP_INTEZMENYID_TANEVID_NAPDATUMA_ORARENDINAP]
    ON [dbo].[T_NAPTARINAP]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_NAPDATUMA] ASC, [C_ORARENDINAP] ASC)
    INCLUDE([TOROLT], [C_HETNAPJA], [C_HETIREND]);


GO
PRINT N'Altering [dbo].[T_NAPTIPUS]...';


GO
ALTER TABLE [dbo].[T_NAPTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NAPTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NAPTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_NATIONALITY]...';


GO
ALTER TABLE [dbo].[T_NATIONALITY] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NATIONALITY] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NATIONALITY] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NATIONALITY] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_NEBULO]...';


GO
ALTER TABLE [dbo].[T_NEBULO] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NEBULO] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NEBULO] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NEBULO] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_NEM]...';


GO
ALTER TABLE [dbo].[T_NEM] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NEM] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NEM] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NEM] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_NEMKOTOTTMUNKAIDO]...';


GO
ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_NEMKOTOTTMUNKAIDO] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGEXPORTORAREND] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGEXPORTORAREND] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGEXPORTORAREND] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGEXPORTORAREND] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZAS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZAS_TEREM] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALKOZASFOGLALTSAG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGFOGLALTSAGTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGGENERATORALAP] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGGENERATORALAP] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGGENERATORALAP] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGGENERATORALAP] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGINTEZMENYFOGLALTSAG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGORARENDIORA] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGORARENDIORA] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGORARENDIORA] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGORARENDIORA] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORT] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGOSZTALYCSOPORTFOGLALTSAG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGTANARFOGLALTSAG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGTANTARGYFOGLALTSAG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGTEREM_TANTARGY] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


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


GO
ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OGTEREMFOGLALTSAG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_OKTATASINEVELESIFELADAT]...';


GO
ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OKTATASINEVELESIFELADAT] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_OLDALLATOGATOTTSAG]...';


GO
ALTER TABLE [dbo].[T_OLDALLATOGATOTTSAG] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OLDALLATOGATOTTSAG] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OLDALLATOGATOTTSAG] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OLDALLATOGATOTTSAG] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_ONLINEUSER]...';


GO
ALTER TABLE [dbo].[T_ONLINEUSER] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ONLINEUSER] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ONLINEUSER] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_ONLINEUSER] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_ORALATOGATAS]...';


GO
ALTER TABLE [dbo].[T_ORALATOGATAS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORALATOGATAS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORALATOGATAS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_ORALATOGATAS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_ORARENDIORA]...';


GO
ALTER TABLE [dbo].[T_ORARENDIORA] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORARENDIORA] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORARENDIORA] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_ORARENDIORA] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Creating [dbo].[T_ORARENDIORA].[IX_ORARENDIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID]...';


GO
CREATE NONCLUSTERED INDEX [IX_ORARENDIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID]
    ON [dbo].[T_ORARENDIORA]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_OSZTALYCSOPORTID] ASC)
    INCLUDE([TOROLT], [C_HETIREND], [C_HETNAPJA], [C_ORAERVENYESSEGKEZDETE], [C_ORAERVENYESSEGVEGE]);


GO
PRINT N'Altering [dbo].[T_ORATERV]...';


GO
ALTER TABLE [dbo].[T_ORATERV] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORATERV] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORATERV] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_ORATERV] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_ORATERVTARGY]...';


GO
ALTER TABLE [dbo].[T_ORATERVTARGY] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORATERVTARGY] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORATERVTARGY] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_ORATERVTARGY] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_ORSZAGTIPUS]...';


GO
ALTER TABLE [dbo].[T_ORSZAGTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORSZAGTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_ORSZAGTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_ORSZAGTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_OSSZEGTULLEPESTIPUS]...';


GO
ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OSSZEGTULLEPESTIPUS] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;


GO
PRINT N'Altering [dbo].[T_OSZTALY]...';


GO
ALTER TABLE [dbo].[T_OSZTALY] ALTER COLUMN [CREATED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OSZTALY] ALTER COLUMN [LASTCHANGED] DATETIME NOT NULL;

ALTER TABLE [dbo].[T_OSZTALY] ALTER COLUMN [SERIAL] INT NOT NULL;

ALTER TABLE [dbo].[T_OSZTALY] ALTER COLUMN [TOROLT] CHAR (1) NOT NULL;
