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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_OSZTALYCSOPORT].[UK_TANEV_OSZTALYNEV]...';


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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_SCAPPLICATIONFORMBATCH].[UK_993595]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_993595]
    ON [dbo].[T_SCAPPLICATIONFORMBATCH]([C_SERIALNUMBER] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_SCCARD].[UK_993095]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_993095]
    ON [dbo].[T_SCCARD]([C_SERIALNUMBER] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_SCINSET].[UK_991495]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_991495]
    ON [dbo].[T_SCINSET]([C_SERIALNUMBER] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_SCTEMPORARYCARD].[UK_991695]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_991695]
    ON [dbo].[T_SCTEMPORARYCARD]([C_SERIALNUMBER] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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