482 lines
20 KiB
Transact-SQL
482 lines
20 KiB
Transact-SQL
--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
|
|
|