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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_TANITASIORA].[IX_TANITASIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID_TANTARGYID]...';


GO
CREATE NONCLUSTERED INDEX [IX_TANITASIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID_TANTARGYID]
    ON [dbo].[T_TANITASIORA]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_OSZTALYCSOPORTID] ASC, [C_TANTARGYID] ASC)
    INCLUDE([TOROLT], [C_DATUM]);


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_TANTARGY].[UK_4025402]...';


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


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_TANTERV].[UK_4025398]...';


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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_TANULOCSOPORT].[UK_TANULOCSOPORT]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_TANULOCSOPORT]
    ON [dbo].[T_TANULOCSOPORT]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_OSZTALYCSOPORTID] ASC, [C_TANULOID] ASC) WHERE ([C_KILEPESDATUM] IS NULL AND [TOROLT]='F');


GO
PRINT N'Creating [dbo].[T_TANULOCSOPORT].[IDX_TANULOCSOPORT_INTEZMENYID_TANEVID_OSZTALYCSOPORTID]...';


GO
CREATE NONCLUSTERED INDEX [IDX_TANULOCSOPORT_INTEZMENYID_TANEVID_OSZTALYCSOPORTID]
    ON [dbo].[T_TANULOCSOPORT]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_OSZTALYCSOPORTID] ASC)
    INCLUDE([C_TANULOID], [C_BELEPESDATUM], [C_KILEPESDATUM], [TOROLT]);


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_TANULOMULASZTAS].[IX_TANULOMULASZTAS_TIPUS_ORATANULOIID_TANITASIORAKID]...';


GO
CREATE NONCLUSTERED INDEX [IX_TANULOMULASZTAS_TIPUS_ORATANULOIID_TANITASIORAKID]
    ON [dbo].[T_TANULOMULASZTAS]([C_INTEZMENYID] ASC, [C_TANEVID] ASC, [C_TIPUS] ASC, [C_ORATANULOIID] ASC, [C_TANITASIORAKID] ASC)
    INCLUDE([TOROLT], [C_KESESPERCBEN]);


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_TEREM].[UK_TEREMNEV]...';


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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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