--Migration ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT IF EXISTS [DF__T_ALKALMA__C_DIA__6D381B7D]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_ALKALMAZOTT]...'; GO ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT IF EXISTS [DF__T_ALKALMA__C_ELF__71FCD09A]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_ALKALMAZOTT]...'; GO ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT IF EXISTS [DF__T_ALKALMA__C_KOZ__7108AC61]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_ALKALMAZOTT]...'; GO ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT IF EXISTS [DF__T_ALKALMA__C_SZA__6E2C3FB6]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_ALKALMAZOTT]...'; GO ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT IF EXISTS [DF__T_ALKALMA__C_SZA__6F2063EF]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_ALKALMAZOTT]...'; GO ALTER TABLE [dbo].[T_ALKALMAZOTT] DROP CONSTRAINT IF EXISTS [DF__T_ALKALMA__C_TOV__70148828]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_BTMP__3BA0BFE9]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_EGYE__40657506]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_EGYU__461E4E5C]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_HALM__3C94E422]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_ISKO__47127295]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_KOLL__3D89085B]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_MEGA__4159993F]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_OSZT__424DBD78]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_SAJA__3E7D2C94]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_SZET__4341E1B1]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_SZKT__443605EA]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_TECH__452A2A23]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] DROP CONSTRAINT IF EXISTS [DF__T_TANULO__C_VESZ__3F7150CD]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_FELHASZNALO]...'; GO ALTER TABLE [dbo].[T_FELHASZNALO] DROP CONSTRAINT IF EXISTS [DF__T_FELHASZ__C_ANY__0347582D]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_FELHASZNALO]...'; GO ALTER TABLE [dbo].[T_FELHASZNALO] DROP CONSTRAINT IF EXISTS [DF__T_FELHASZ__C_SZU__025333F4]; GO PRINT N'Dropping unnamed constraint on [dbo].[T_FELHASZNALO]...'; GO ALTER TABLE [dbo].[T_FELHASZNALO] DROP CONSTRAINT IF EXISTS [DF__T_FELHASZ__C_NEV__09003183]; GO PRINT N'Altering [dbo].[T_ALKALMAZOTT]...'; GO ALTER TABLE [dbo].[T_ALKALMAZOTT] ALTER COLUMN [C_DIAKOLIMPIA] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_ALKALMAZOTT] ALTER COLUMN [C_ELFOGADOTTSZANDEKNYILATKOZAT] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_ALKALMAZOTT] ALTER COLUMN [C_KOZOSSEGISZOLGALATKEZELO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_ALKALMAZOTT] ALTER COLUMN [C_SZAKERTOIVIZSGAELNOKI] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_ALKALMAZOTT] ALTER COLUMN [C_SZAKVIZSGA] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_ALKALMAZOTT] ALTER COLUMN [C_TOVABBKEPZES] CHAR (1) NOT NULL; GO PRINT N'Altering [dbo].[T_TANULO]...'; GO ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_ALLAMIGONDOZOTT] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_BEILLESZKEDESINEHEZSEG] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_BEILLESZKEDESIPROBLEMAVALKUZ] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_BEJARO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_BTMPROBLEMAS] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_DIAKSPORTKOROS] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_EGYEBDONTO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_EGYUTTMUKODESES] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_EVISMETLO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_HALMOZOTTANFOGYATEKOS] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_ISKOLAIKERETEKKOZOTT] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_JOGVISZONYATSZUNETELTETO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_KOLLEGIUMIELLATASOS] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_KOZEPFOKUOKTATASBATIZENHATOD] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_MAGANTANULO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_MAGATARTASIPROBLEMAVALKUZD] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_MEGALLAPODASOS] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_MENEDEKJOGGALRENDELKEZO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_OSZTV] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_POLGARISZERZODESES] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_SAJATOSNEVELESU] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_SZAKMAIGYAKORLATON] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_SZETVAGAZAT] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_SZKTV] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_SZOCIALISTAMOGATAS] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TANDIJATFIZETO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TANKOTELEZETT] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TANULASIPROBLEMADISZGRAFIA] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TANULASIPROBLEMAVALKUZD] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TANULASIPROBLEMAVALKUZDDISZK] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TANULASIPROBLEMAVALKUZDDISZL] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TANULOSZERZODESES] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TECHNIKUSIEVFOLYAM] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_TERITESIDIJATFIZETO] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_VENDEG] CHAR (1) NOT NULL; ALTER TABLE [dbo].[T_TANULO] ALTER COLUMN [C_VESZELYEZTETETT] CHAR (1) NOT NULL; GO GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_ALKALMAZOTT' AND COLUMN_NAME = 'C_FOALLAS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_ALKALMAZOTT ADD DEFAULT ('T')FOR C_FOALLAS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_ALKALMAZOTT' AND COLUMN_NAME = 'C_DIAKOLIMPIA' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_ALKALMAZOTT ADD DEFAULT ('F')FOR C_DIAKOLIMPIA; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_ALKALMAZOTT' AND COLUMN_NAME = 'C_SZAKERTOIVIZSGAELNOKI' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_ALKALMAZOTT ADD DEFAULT ('F')FOR C_SZAKERTOIVIZSGAELNOKI; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_ALKALMAZOTT' AND COLUMN_NAME = 'C_SZAKVIZSGA' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_ALKALMAZOTT ADD DEFAULT ('F')FOR C_SZAKVIZSGA; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_ALKALMAZOTT' AND COLUMN_NAME = 'C_TOVABBKEPZES' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_ALKALMAZOTT ADD DEFAULT ('F')FOR C_TOVABBKEPZES; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_ALKALMAZOTT' AND COLUMN_NAME = 'C_KOZOSSEGISZOLGALATKEZELO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_ALKALMAZOTT ADD DEFAULT ('F')FOR C_KOZOSSEGISZOLGALATKEZELO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_ALKALMAZOTT' AND COLUMN_NAME = 'C_ELFOGADOTTSZANDEKNYILATKOZAT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_ALKALMAZOTT ADD DEFAULT ('F')FOR C_ELFOGADOTTSZANDEKNYILATKOZAT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALO' AND COLUMN_NAME = 'C_SZULETESINEVSORREND' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALO ADD DEFAULT ('F')FOR C_SZULETESINEVSORREND; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALO' AND COLUMN_NAME = 'C_ANYJANEVESORREND' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALO ADD DEFAULT ('F')FOR C_ANYJANEVESORREND; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALO' AND COLUMN_NAME = 'C_LATASSERULTWEBHASZNALATA' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALO ADD DEFAULT ('F')FOR C_LATASSERULTWEBHASZNALATA; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALO' AND COLUMN_NAME = 'C_KELLADSZINKRONIZALAS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALO ADD DEFAULT ('T')FOR C_KELLADSZINKRONIZALAS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALO' AND COLUMN_NAME = 'C_IMPORTALT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALO ADD DEFAULT ('F')FOR C_IMPORTALT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALO' AND COLUMN_NAME = 'C_BELUGYALTALAZONOSITOTT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALO ADD DEFAULT ('F')FOR C_BELUGYALTALAZONOSITOTT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALOBELEPES' AND COLUMN_NAME = 'C_ELFOGADOTTGDPRNYILATKOZAT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALOBELEPES ADD DEFAULT ('F')FOR C_ELFOGADOTTGDPRNYILATKOZAT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_FELHASZNALOBELEPES' AND COLUMN_NAME = 'C_IMPORTALT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_FELHASZNALOBELEPES ADD DEFAULT ('F')FOR C_IMPORTALT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_ALLAMIGONDOZOTT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_ALLAMIGONDOZOTT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_BEILLESZKEDESINEHEZSEG' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_BEILLESZKEDESINEHEZSEG; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_BEJARO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_BEJARO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_EVISMETLO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_EVISMETLO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_JOGVISZONYATSZUNETELTETO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_JOGVISZONYATSZUNETELTETO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_MAGANTANULO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_MAGANTANULO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_POLGARISZERZODESES' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_POLGARISZERZODESES; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_SZAKMAIGYAKORLATON' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_SZAKMAIGYAKORLATON; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_SZOCIALISTAMOGATAS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_SZOCIALISTAMOGATAS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TANDIJATFIZETO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TANDIJATFIZETO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TANKOTELEZETT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('T')FOR C_TANKOTELEZETT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TANULOSZERZODESES' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TANULOSZERZODESES; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TERITESIDIJATFIZETO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TERITESIDIJATFIZETO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_VENDEG' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_VENDEG; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_BTMPROBLEMAS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_BTMPROBLEMAS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_DIAKSPORTKOROS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_DIAKSPORTKOROS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_HALMOZOTTANFOGYATEKOS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_HALMOZOTTANFOGYATEKOS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_KOLLEGIUMIELLATASOS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_KOLLEGIUMIELLATASOS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_SAJATOSNEVELESU' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_SAJATOSNEVELESU; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_VESZELYEZTETETT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_VESZELYEZTETETT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_BEILLESZKEDESIPROBLEMAVALKUZ' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_BEILLESZKEDESIPROBLEMAVALKUZ; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_MAGATARTASIPROBLEMAVALKUZD' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_MAGATARTASIPROBLEMAVALKUZD; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TANULASIPROBLEMADISZGRAFIA' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TANULASIPROBLEMADISZGRAFIA; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TANULASIPROBLEMAVALKUZD' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TANULASIPROBLEMAVALKUZD; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TANULASIPROBLEMAVALKUZDDISZK' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TANULASIPROBLEMAVALKUZDDISZK; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TANULASIPROBLEMAVALKUZDDISZL' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TANULASIPROBLEMAVALKUZDDISZL; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_KOZEPFOKUOKTATASBATIZENHATOD' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_KOZEPFOKUOKTATASBATIZENHATOD; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_MENEDEKJOGGALRENDELKEZO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_MENEDEKJOGGALRENDELKEZO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_EGYEBDONTO' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_EGYEBDONTO; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_MEGALLAPODASOS' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_MEGALLAPODASOS; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_OSZTV' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_OSZTV; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_SZETVAGAZAT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_SZETVAGAZAT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_SZKTV' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_SZKTV; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_TECHNIKUSIEVFOLYAM' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_TECHNIKUSIEVFOLYAM; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_EGYUTTMUKODESES' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_EGYUTTMUKODESES; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_ISKOLAIKERETEKKOZOTT' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_ISKOLAIKERETEKKOZOTT; END GO IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS c WHERE TABLE_NAME = 'T_TANULO' AND COLUMN_NAME = 'C_ISSZAKMAIGYAKORLATHIANY' AND COLUMN_DEFAULT IS NULL AND TABLE_SCHEMA = 'dbo' ) BEGIN ALTER TABLE T_TANULO ADD DEFAULT ('F')FOR C_ISSZAKMAIGYAKORLATHIANY; END GO