﻿GO
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;

SET NUMERIC_ROUNDABORT OFF;


GO
PRINT N'Dropping [dbo].[T_CREDITCARDREPLY].[UK_22935]...';


GO
DROP INDEX [UK_22935]
    ON [dbo].[T_CREDITCARDREPLY];


GO
PRINT N'Dropping [dbo].[T_CSENGETESIREND].[UK_4025457_4026183]...';


GO
DROP INDEX [UK_4025457_4026183]
    ON [dbo].[T_CSENGETESIREND];


GO
PRINT N'Dropping [dbo].[T_DICTIONARYITEMBASE].[UK_41498_3561258]...';


GO
DROP INDEX [UK_41498_3561258]
    ON [dbo].[T_DICTIONARYITEMBASE];


GO
PRINT N'Dropping [dbo].[T_FELHASZNALOBELEPES].[UK_4025364]...';


GO
DROP INDEX [UK_4025364]
    ON [dbo].[T_FELHASZNALOBELEPES];


GO
PRINT N'Dropping [dbo].[T_INTEZMENY].[UK_4026246]...';


GO
DROP INDEX [UK_4026246]
    ON [dbo].[T_INTEZMENY];


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


GO
DROP INDEX [UK_4025200]
    ON [dbo].[T_MUKODESIHELY];


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


GO
DROP INDEX [IX_NAPTARINAP_INTEZMENYID_TANEVID_NAPDATUMA_ORARENDINAP]
    ON [dbo].[T_NAPTARINAP];


IF (SELECT SUM(1) FROM sys.indexes WHERE name='IX_ORARENDIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID' AND object_id = OBJECT_ID('dbo.T_ORARENDIORA')) = 1
BEGIN
PRINT N'Dropping [dbo].[T_ORARENDIORA].[IX_ORARENDIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID]...';

DROP INDEX [IX_ORARENDIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID]
    ON [dbo].[T_ORARENDIORA];
END;

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


GO
DROP INDEX [UK_TANEV_OSZTALYNEV]
    ON [dbo].[T_OSZTALYCSOPORT];


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


GO
DROP INDEX [UK_993595]
    ON [dbo].[T_SCAPPLICATIONFORMBATCH];


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


GO
DROP INDEX [UK_993095]
    ON [dbo].[T_SCCARD];


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


GO
DROP INDEX [UK_991495]
    ON [dbo].[T_SCINSET];


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


GO
DROP INDEX [UK_991695]
    ON [dbo].[T_SCTEMPORARYCARD];


IF (SELECT SUM(1) FROM sys.indexes WHERE name='IX_TANITASIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID_TANTARGYID' AND object_id = OBJECT_ID('dbo.T_TANITASIORA')) = 1
BEGIN
PRINT N'Dropping [dbo].[T_TANITASIORA].[IX_TANITASIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID_TANTARGYID]...';

DROP INDEX [IX_TANITASIORA_INTEZMENYID_TANEVID_OSZTALYCSOPORTID_TANTARGYID]
    ON [dbo].[T_TANITASIORA];
END


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


GO
DROP INDEX [UK_4025402]
    ON [dbo].[T_TANTARGY];


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


GO
DROP INDEX [UK_4025398]
    ON [dbo].[T_TANTERV];


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


GO
DROP INDEX [UK_TANULOCSOPORT]
    ON [dbo].[T_TANULOCSOPORT];


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


GO
DROP INDEX [IDX_TANULOCSOPORT_INTEZMENYID_TANEVID_OSZTALYCSOPORTID]
    ON [dbo].[T_TANULOCSOPORT];


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


GO
DROP INDEX [IX_TANULOMULASZTAS_TIPUS_ORATANULOIID_TANITASIORAKID]
    ON [dbo].[T_TANULOMULASZTAS];


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


GO
DROP INDEX [UK_TEREMNEV]
    ON [dbo].[T_TEREM];


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_CREDITCARDREPLY].[UK_22935]...';


GO
CREATE UNIQUE NONCLUSTERED INDEX [UK_22935]
    ON [dbo].[T_CREDITCARDREPLY]([C_CREDITCARDPAYMENTID] ASC, [C_INTEZMENYID] ASC, [C_TANEVID] ASC) WHERE ([TOROLT]='F');


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


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

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

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

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


GO
PRINT N'Creating [dbo].[T_CSENGETESIREND].[UK_4025457_4026183]...';


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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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


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


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

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

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

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