314 lines
12 KiB
Transact-SQL
314 lines
12 KiB
Transact-SQL
GO
|
|
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
|
|
|
|
SET NUMERIC_ROUNDABORT OFF;
|
|
|
|
|
|
GO
|
|
PRINT N'Starting rebuilding table [stage].[T_OSZTALYCSOPORTLETSZAM_STAGE]...';
|
|
|
|
|
|
GO
|
|
BEGIN TRANSACTION;
|
|
|
|
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
|
|
|
|
SET XACT_ABORT ON;
|
|
|
|
CREATE TABLE [stage].[tmp_ms_xx_T_OSZTALYCSOPORTLETSZAM_STAGE] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_EVFOLYAMTIPUSA] INT NULL,
|
|
[C_INTEZMENYID] INT NULL,
|
|
[C_OSZTALYBONTASID] INT NULL,
|
|
[C_OSZTALYCSOPORTID] INT NULL,
|
|
[C_OSZTALYCSOPORTLETSZAM] INT NULL,
|
|
[C_OSZTALYCSOPORTNEV] NVARCHAR (255) NULL,
|
|
[C_TANEVNEV] NVARCHAR (20) NULL,
|
|
[C_CSOPORTTIPUS] INT NULL,
|
|
[C_TERVEZETTLETSZAM] INT NULL,
|
|
[C_OSZTALYCSOPORTTIPUS] NVARCHAR (2) NULL,
|
|
[C_FELADATELLATASIHELYID] INT NULL,
|
|
[C_VEGZOSEVFOLYAM] CHAR (1) NULL,
|
|
[TOROLT] CHAR (1) DEFAULT ('F') NULL,
|
|
[SERIAL] INT NULL,
|
|
[LASTCHANGED] DATETIME DEFAULT (getdate()) NULL,
|
|
[CREATED] DATETIME DEFAULT (getdate()) NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
CONSTRAINT [tmp_ms_xx_constraint_PK_T_40265741] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
IF EXISTS (SELECT TOP 1 1
|
|
FROM [stage].[T_OSZTALYCSOPORTLETSZAM_STAGE])
|
|
BEGIN
|
|
SET IDENTITY_INSERT [stage].[tmp_ms_xx_T_OSZTALYCSOPORTLETSZAM_STAGE] ON;
|
|
INSERT INTO [stage].[tmp_ms_xx_T_OSZTALYCSOPORTLETSZAM_STAGE] ([ID], [C_EVFOLYAMTIPUSA], [C_INTEZMENYID], [C_OSZTALYBONTASID], [C_OSZTALYCSOPORTID], [C_OSZTALYCSOPORTLETSZAM], [C_OSZTALYCSOPORTNEV], [C_TANEVNEV], [C_CSOPORTTIPUS], [C_TERVEZETTLETSZAM], [C_OSZTALYCSOPORTTIPUS], [C_FELADATELLATASIHELYID], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR])
|
|
SELECT [ID],
|
|
[C_EVFOLYAMTIPUSA],
|
|
[C_INTEZMENYID],
|
|
[C_OSZTALYBONTASID],
|
|
[C_OSZTALYCSOPORTID],
|
|
[C_OSZTALYCSOPORTLETSZAM],
|
|
[C_OSZTALYCSOPORTNEV],
|
|
[C_TANEVNEV],
|
|
[C_CSOPORTTIPUS],
|
|
[C_TERVEZETTLETSZAM],
|
|
[C_OSZTALYCSOPORTTIPUS],
|
|
[C_FELADATELLATASIHELYID],
|
|
[TOROLT],
|
|
[SERIAL],
|
|
[LASTCHANGED],
|
|
[CREATED],
|
|
[MODIFIER],
|
|
[CREATOR]
|
|
FROM [stage].[T_OSZTALYCSOPORTLETSZAM_STAGE]
|
|
ORDER BY [ID] ASC;
|
|
SET IDENTITY_INSERT [stage].[tmp_ms_xx_T_OSZTALYCSOPORTLETSZAM_STAGE] OFF;
|
|
END
|
|
|
|
DROP TABLE [stage].[T_OSZTALYCSOPORTLETSZAM_STAGE];
|
|
|
|
EXECUTE sp_rename N'[stage].[tmp_ms_xx_T_OSZTALYCSOPORTLETSZAM_STAGE]', N'T_OSZTALYCSOPORTLETSZAM_STAGE';
|
|
|
|
EXECUTE sp_rename N'[stage].[tmp_ms_xx_constraint_PK_T_40265741]', N'PK_T_4026574', N'OBJECT';
|
|
|
|
COMMIT TRANSACTION;
|
|
|
|
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
|
|
|
|
|
|
GO
|
|
PRINT N'Starting rebuilding table [stage].[T_TANARADATOK_STAGE]...';
|
|
|
|
|
|
GO
|
|
BEGIN TRANSACTION;
|
|
|
|
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
|
|
|
|
SET XACT_ABORT ON;
|
|
|
|
CREATE TABLE [stage].[tmp_ms_xx_T_TANARADATOK_STAGE] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_BETOLTETLENALLASHELY] CHAR (1) NULL,
|
|
[C_MUNKAVISZONYTIPUSA] INT NULL,
|
|
[C_INTEZMENYID] INT NULL,
|
|
[C_BESOROLASIFOKOZAT] INT NULL,
|
|
[C_KOTELEZOORASZAM] NUMERIC (10, 2) NULL,
|
|
[C_MUNKAKORTIPUSA] INT NULL,
|
|
[C_TANARANYJANEVE] NVARCHAR (100) NULL,
|
|
[C_TANARID] INT NULL,
|
|
[C_TANARNEME] INT NULL,
|
|
[C_TANARNEV] NVARCHAR (100) NULL,
|
|
[C_TANAROMKOD] NVARCHAR (20) NULL,
|
|
[C_TANARSZULETESIDATUM] DATETIME NULL,
|
|
[C_TANARSZULETESIHELY] NVARCHAR (100) NULL,
|
|
[C_TANARSZULETESINEV] NVARCHAR (100) NULL,
|
|
[C_TANEVNEV] NVARCHAR (20) NULL,
|
|
[C_MUNKAIDOKEDVEZMENYORASZAM] INT NULL,
|
|
[C_NYUGDIJAS] CHAR (1) NULL,
|
|
[C_TARTOSHELYETTESITES] CHAR (1) NULL,
|
|
[C_PEDAGOGUSSTATUSZA] INT NULL,
|
|
[C_FELADATELLATASIHELYID] INT NULL,
|
|
[C_ADOSZAM] NVARCHAR (30) NULL,
|
|
[C_MUNKAIDOKEDVEZMENYOKA] INT NULL,
|
|
[C_TANARFOKOZAT] INT NULL,
|
|
[C_SZAKERTOIVIZSGAELNOKI] CHAR (1) NULL,
|
|
[C_SZAKVIZSGA] CHAR (1) NULL,
|
|
[C_TOVABBKEPZES] CHAR (1) NULL,
|
|
[TOROLT] CHAR (1) DEFAULT ('F') NULL,
|
|
[SERIAL] INT NULL,
|
|
[LASTCHANGED] DATETIME DEFAULT (getdate()) NULL,
|
|
[CREATED] DATETIME DEFAULT (getdate()) NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
CONSTRAINT [tmp_ms_xx_constraint_PK_T_40267271] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
IF EXISTS (SELECT TOP 1 1
|
|
FROM [stage].[T_TANARADATOK_STAGE])
|
|
BEGIN
|
|
SET IDENTITY_INSERT [stage].[tmp_ms_xx_T_TANARADATOK_STAGE] ON;
|
|
INSERT INTO [stage].[tmp_ms_xx_T_TANARADATOK_STAGE] ([ID], [C_BETOLTETLENALLASHELY], [C_MUNKAVISZONYTIPUSA], [C_INTEZMENYID], [C_BESOROLASIFOKOZAT], [C_KOTELEZOORASZAM], [C_MUNKAKORTIPUSA], [C_TANARANYJANEVE], [C_TANARID], [C_TANARNEME], [C_TANARNEV], [C_TANAROMKOD], [C_TANARSZULETESIDATUM], [C_TANARSZULETESIHELY], [C_TANARSZULETESINEV], [C_TANEVNEV], [C_MUNKAIDOKEDVEZMENYORASZAM], [C_NYUGDIJAS], [C_TARTOSHELYETTESITES], [C_PEDAGOGUSSTATUSZA], [C_FELADATELLATASIHELYID], [C_ADOSZAM], [C_MUNKAIDOKEDVEZMENYOKA], [C_TANARFOKOZAT], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR])
|
|
SELECT [ID],
|
|
[C_BETOLTETLENALLASHELY],
|
|
[C_MUNKAVISZONYTIPUSA],
|
|
[C_INTEZMENYID],
|
|
[C_BESOROLASIFOKOZAT],
|
|
[C_KOTELEZOORASZAM],
|
|
[C_MUNKAKORTIPUSA],
|
|
[C_TANARANYJANEVE],
|
|
[C_TANARID],
|
|
[C_TANARNEME],
|
|
[C_TANARNEV],
|
|
[C_TANAROMKOD],
|
|
[C_TANARSZULETESIDATUM],
|
|
[C_TANARSZULETESIHELY],
|
|
[C_TANARSZULETESINEV],
|
|
[C_TANEVNEV],
|
|
[C_MUNKAIDOKEDVEZMENYORASZAM],
|
|
[C_NYUGDIJAS],
|
|
[C_TARTOSHELYETTESITES],
|
|
[C_PEDAGOGUSSTATUSZA],
|
|
[C_FELADATELLATASIHELYID],
|
|
[C_ADOSZAM],
|
|
[C_MUNKAIDOKEDVEZMENYOKA],
|
|
[C_TANARFOKOZAT],
|
|
[TOROLT],
|
|
[SERIAL],
|
|
[LASTCHANGED],
|
|
[CREATED],
|
|
[MODIFIER],
|
|
[CREATOR]
|
|
FROM [stage].[T_TANARADATOK_STAGE]
|
|
ORDER BY [ID] ASC;
|
|
SET IDENTITY_INSERT [stage].[tmp_ms_xx_T_TANARADATOK_STAGE] OFF;
|
|
END
|
|
|
|
DROP TABLE [stage].[T_TANARADATOK_STAGE];
|
|
|
|
EXECUTE sp_rename N'[stage].[tmp_ms_xx_T_TANARADATOK_STAGE]', N'T_TANARADATOK_STAGE';
|
|
|
|
EXECUTE sp_rename N'[stage].[tmp_ms_xx_constraint_PK_T_40267271]', N'PK_T_4026727', N'OBJECT';
|
|
|
|
COMMIT TRANSACTION;
|
|
|
|
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
|
|
|
|
|
|
GO
|
|
PRINT N'Starting rebuilding table [stage].[T_TANULOADATOK_STAGE]...';
|
|
|
|
|
|
GO
|
|
BEGIN TRANSACTION;
|
|
|
|
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
|
|
|
|
SET XACT_ABORT ON;
|
|
|
|
CREATE TABLE [stage].[tmp_ms_xx_T_TANULOADATOK_STAGE] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_INTEZMENYID] INT NULL,
|
|
[C_TANEVNEV] NVARCHAR (20) NULL,
|
|
[C_TANULOID] INT NULL,
|
|
[C_TANULONEME] INT NULL,
|
|
[C_TANULOSZULETESIDATUM] DATETIME NULL,
|
|
[C_BTMLETSZAMSULY] NUMERIC (10, 2) NULL,
|
|
[C_BTMPROBLEMAS] CHAR (1) NULL,
|
|
[C_SAJATOSNEVELESU] CHAR (1) NULL,
|
|
[C_SNILETSZAMSULY] NUMERIC (10, 2) NULL,
|
|
[C_OKTATASIAZONOSITO] NVARCHAR (20) NULL,
|
|
[C_EGYEBDONTO] CHAR (1) NULL,
|
|
[C_EVISMETLO] CHAR (1) NULL,
|
|
[C_FELADATELLATASIHELYID] CHAR (1) NULL,
|
|
[C_MEGALLAPODASOS] CHAR (1) NULL,
|
|
[C_NYOMTATASINEV] NVARCHAR (255) NULL,
|
|
[C_OSZTV] CHAR (1) NULL,
|
|
[C_SZETVAGAZAT] CHAR (1) NULL,
|
|
[C_SZINTVIZSGA] NUMERIC (10, 2) NULL,
|
|
[C_SZKTV] CHAR (1) NULL,
|
|
[C_TANULOSZERZODESES] CHAR (1) NULL,
|
|
[C_TECHNIKUSIEVFOLYAM] CHAR (1) NULL,
|
|
[TOROLT] CHAR (1) DEFAULT ('F') NULL,
|
|
[SERIAL] INT NULL,
|
|
[LASTCHANGED] DATETIME DEFAULT (getdate()) NULL,
|
|
[CREATED] DATETIME DEFAULT (getdate()) NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
CONSTRAINT [tmp_ms_xx_constraint_PK_T_40268331] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
IF EXISTS (SELECT TOP 1 1
|
|
FROM [stage].[T_TANULOADATOK_STAGE])
|
|
BEGIN
|
|
SET IDENTITY_INSERT [stage].[tmp_ms_xx_T_TANULOADATOK_STAGE] ON;
|
|
INSERT INTO [stage].[tmp_ms_xx_T_TANULOADATOK_STAGE] ([ID], [C_INTEZMENYID], [C_TANEVNEV], [C_TANULOID], [C_TANULONEME], [C_TANULOSZULETESIDATUM], [C_BTMLETSZAMSULY], [C_BTMPROBLEMAS], [C_SAJATOSNEVELESU], [C_SNILETSZAMSULY], [C_OKTATASIAZONOSITO], [TOROLT], [SERIAL], [LASTCHANGED], [CREATED], [MODIFIER], [CREATOR])
|
|
SELECT [ID],
|
|
[C_INTEZMENYID],
|
|
[C_TANEVNEV],
|
|
[C_TANULOID],
|
|
[C_TANULONEME],
|
|
[C_TANULOSZULETESIDATUM],
|
|
[C_BTMLETSZAMSULY],
|
|
[C_BTMPROBLEMAS],
|
|
[C_SAJATOSNEVELESU],
|
|
[C_SNILETSZAMSULY],
|
|
[C_OKTATASIAZONOSITO],
|
|
[TOROLT],
|
|
[SERIAL],
|
|
[LASTCHANGED],
|
|
[CREATED],
|
|
[MODIFIER],
|
|
[CREATOR]
|
|
FROM [stage].[T_TANULOADATOK_STAGE]
|
|
ORDER BY [ID] ASC;
|
|
SET IDENTITY_INSERT [stage].[tmp_ms_xx_T_TANULOADATOK_STAGE] OFF;
|
|
END
|
|
|
|
DROP TABLE [stage].[T_TANULOADATOK_STAGE];
|
|
|
|
EXECUTE sp_rename N'[stage].[tmp_ms_xx_T_TANULOADATOK_STAGE]', N'T_TANULOADATOK_STAGE';
|
|
|
|
EXECUTE sp_rename N'[stage].[tmp_ms_xx_constraint_PK_T_40268331]', N'PK_T_4026833', N'OBJECT';
|
|
|
|
COMMIT TRANSACTION;
|
|
|
|
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [stage].[T_INTEZMENYADATSZOLG_STAGE]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [stage].[T_INTEZMENYADATSZOLG_STAGE] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_SZAKBEIRATKFELVETT] INT NULL,
|
|
[C_SZAKBEIRATKJELENTKEZETT] INT NULL,
|
|
[C_INTEZMENYADATSZOLGID] INT NULL,
|
|
[C_INTEZMENYID] INT NULL,
|
|
[C_TANEVNEV] NVARCHAR (20) NULL,
|
|
[TOROLT] CHAR (1) NULL,
|
|
[SERIAL] INT NULL,
|
|
[LASTCHANGED] DATETIME NULL,
|
|
[CREATED] DATETIME NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
CONSTRAINT [PK_T_4027654] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [stage].[T_INTEZMENYADATSZOLG_STAGE]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [stage].[T_INTEZMENYADATSZOLG_STAGE]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [stage].[T_INTEZMENYADATSZOLG_STAGE]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [stage].[T_INTEZMENYADATSZOLG_STAGE]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [stage].[T_INTEZMENYADATSZOLG_STAGE]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [stage].[T_INTEZMENYADATSZOLG_STAGE]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Update complete.';
|
|
|
|
|
|
GO
|