1492 lines
30 KiB
Transact-SQL
1492 lines
30 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'Altering [dbo].[T_ELEARNINGELERHETOSEG]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_ELEARNINGELERHETOSEG]
|
|
ADD [C_ISGONDVISELONELMEGJELENIK] CHAR (1) DEFAULT ('F') NOT NULL,
|
|
[C_ISTANULONALMEGJELENIK] CHAR (1) DEFAULT ('F') NOT NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_INTEZMENYADATOK]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_INTEZMENYADATOK]
|
|
ADD [C_ISDOKUMENTUMFEJLECMEGJELENIT] CHAR (1) DEFAULT ('F') NOT NULL,
|
|
[C_ISDOKUMENTUMLABLECMEGJELENIT] CHAR (1) DEFAULT ('F') NOT NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Altering [dbo].[T_ORARENDIORA]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_ORARENDIORA]
|
|
ADD [C_ISKEZZELFELVETTEGYEDINAP] CHAR (1) DEFAULT ('F') NOT NULL;
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_FOGADOORA] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_EGYSEG] INT NULL,
|
|
[C_FOGADOORAKEZDETE] DATETIME NOT NULL,
|
|
[C_FOGADOORATIPUSID] INT NOT NULL,
|
|
[C_FOGADOORAVEGE] DATETIME NOT NULL,
|
|
[C_GROUPID] INT NOT NULL,
|
|
[C_RENDSZERESSEG] INT NOT NULL,
|
|
[C_NEMKOTOTTMUNKAIDOID] INT NULL,
|
|
[C_TANARID] INT NOT NULL,
|
|
[C_TEREMID] INT NOT NULL,
|
|
[C_INTEZMENYID] INT NOT NULL,
|
|
[C_TANEVID] INT NOT NULL,
|
|
[TOROLT] CHAR (1) NOT NULL,
|
|
[SERIAL] INT NOT NULL,
|
|
[LASTCHANGED] DATETIME NOT NULL,
|
|
[CREATED] DATETIME NOT NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
[NNID] INT NULL,
|
|
CONSTRAINT [PK_T_4028613] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA].[I_T_4028622_4028620]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028622_4028620]
|
|
ON [dbo].[T_FOGADOORA]([C_NEMKOTOTTMUNKAIDOID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA].[I_T_4028625_4028623]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028625_4028623]
|
|
ON [dbo].[T_FOGADOORA]([C_TANARID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA].[I_T_4028628_4028626]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028628_4028626]
|
|
ON [dbo].[T_FOGADOORA]([C_TEREMID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA].[I_T_402861302_402861300]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402861302_402861300]
|
|
ON [dbo].[T_FOGADOORA]([C_INTEZMENYID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA].[I_T_402861305_402861303]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402861305_402861303]
|
|
ON [dbo].[T_FOGADOORA]([C_TANEVID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA_OSZTALYCSOPORT]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_OSZTALYCSOPORTID] INT NOT NULL,
|
|
[C_FOGADOORAID] INT NOT NULL,
|
|
[C_INTEZMENYID] INT NOT NULL,
|
|
[C_TANEVID] INT NOT NULL,
|
|
[TOROLT] CHAR (1) NOT NULL,
|
|
[SERIAL] INT NOT NULL,
|
|
[LASTCHANGED] DATETIME NOT NULL,
|
|
[CREATED] DATETIME NOT NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
[NNID] INT NULL,
|
|
CONSTRAINT [PK_T_4028634] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA_OSZTALYCSOPORT].[I_T_4028647_4028645]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028647_4028645]
|
|
ON [dbo].[T_FOGADOORA_OSZTALYCSOPORT]([C_OSZTALYCSOPORTID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA_OSZTALYCSOPORT].[I_T_4028650_4028648]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028650_4028648]
|
|
ON [dbo].[T_FOGADOORA_OSZTALYCSOPORT]([C_FOGADOORAID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA_OSZTALYCSOPORT].[I_T_402863402_402863400]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402863402_402863400]
|
|
ON [dbo].[T_FOGADOORA_OSZTALYCSOPORT]([C_INTEZMENYID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA_OSZTALYCSOPORT].[I_T_402863405_402863403]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402863405_402863403]
|
|
ON [dbo].[T_FOGADOORA_OSZTALYCSOPORT]([C_TANEVID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_FOGADOORAIDOPONT] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_KEZDETE] DATETIME NOT NULL,
|
|
[C_VEGE] DATETIME NOT NULL,
|
|
[C_FOGADOORAID] INT NOT NULL,
|
|
[C_INTEZMENYID] INT NOT NULL,
|
|
[C_TANEVID] INT NOT NULL,
|
|
[TOROLT] CHAR (1) NOT NULL,
|
|
[SERIAL] INT NOT NULL,
|
|
[LASTCHANGED] DATETIME NOT NULL,
|
|
[CREATED] DATETIME NOT NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
[NNID] INT NULL,
|
|
CONSTRAINT [PK_T_4028629] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT].[I_T_4028638_4028636]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028638_4028636]
|
|
ON [dbo].[T_FOGADOORAIDOPONT]([C_FOGADOORAID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT].[I_T_402862902_402862900]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402862902_402862900]
|
|
ON [dbo].[T_FOGADOORAIDOPONT]([C_INTEZMENYID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT].[I_T_402862905_402862903]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402862905_402862903]
|
|
ON [dbo].[T_FOGADOORAIDOPONT]([C_TANEVID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]...';
|
|
|
|
|
|
GO
|
|
CREATE TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] (
|
|
[ID] INT IDENTITY (1, 1) NOT NULL,
|
|
[C_FOGADOORAIDOPONTID] INT NOT NULL,
|
|
[C_GONDVISELOID] INT NOT NULL,
|
|
[C_INTEZMENYID] INT NOT NULL,
|
|
[C_TANEVID] INT NOT NULL,
|
|
[TOROLT] CHAR (1) NOT NULL,
|
|
[SERIAL] INT NOT NULL,
|
|
[LASTCHANGED] DATETIME NOT NULL,
|
|
[CREATED] DATETIME NOT NULL,
|
|
[MODIFIER] INT NULL,
|
|
[CREATOR] INT NULL,
|
|
[ELOZOTANEVIREKORDID] INT NULL,
|
|
[NNID] INT NULL,
|
|
CONSTRAINT [PK_T_4028635] PRIMARY KEY CLUSTERED ([ID] ASC)
|
|
);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT_GONDVISELO].[I_T_4028641_4028639]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028641_4028639]
|
|
ON [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]([C_FOGADOORAIDOPONTID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT_GONDVISELO].[I_T_4028644_4028642]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_4028644_4028642]
|
|
ON [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]([C_GONDVISELOID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT_GONDVISELO].[I_T_402863502_402863500]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402863502_402863500]
|
|
ON [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]([C_INTEZMENYID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT_GONDVISELO].[I_T_402863505_402863503]...';
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_T_402863505_402863503]
|
|
ON [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]([C_TANEVID] ASC);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA_OSZTALYCSOPORT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA_OSZTALYCSOPORT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA_OSZTALYCSOPORT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORA_OSZTALYCSOPORT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]
|
|
ADD DEFAULT ((0)) FOR [SERIAL];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]
|
|
ADD DEFAULT ('F') FOR [TOROLT];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]
|
|
ADD DEFAULT (getdate()) FOR [LASTCHANGED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating unnamed constraint on [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO]
|
|
ADD DEFAULT (getdate()) FOR [CREATED];
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028622_4028620]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028622_4028620] FOREIGN KEY ([C_NEMKOTOTTMUNKAIDOID]) REFERENCES [dbo].[T_NEMKOTOTTMUNKAIDO] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028625_4028623]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028625_4028623] FOREIGN KEY ([C_TANARID]) REFERENCES [dbo].[T_ALKALMAZOTT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028628_4028626]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028628_4028626] FOREIGN KEY ([C_TEREMID]) REFERENCES [dbo].[T_TEREM] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402861302_402861300]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402861302_402861300] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402861305_402861303]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402861305_402861303] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028647_4028645]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028647_4028645] FOREIGN KEY ([C_OSZTALYCSOPORTID]) REFERENCES [dbo].[T_OSZTALYCSOPORT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028650_4028648]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028650_4028648] FOREIGN KEY ([C_FOGADOORAID]) REFERENCES [dbo].[T_FOGADOORA] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402863402_402863400]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402863402_402863400] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402863405_402863403]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402863405_402863403] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028638_4028636]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028638_4028636] FOREIGN KEY ([C_FOGADOORAID]) REFERENCES [dbo].[T_FOGADOORA] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402862902_402862900]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402862902_402862900] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402862905_402862903]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402862905_402862903] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028641_4028639]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028641_4028639] FOREIGN KEY ([C_FOGADOORAIDOPONTID]) REFERENCES [dbo].[T_FOGADOORAIDOPONT] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_4028644_4028642]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_4028644_4028642] FOREIGN KEY ([C_GONDVISELOID]) REFERENCES [dbo].[T_GONDVISELO] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402863502_402863500]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402863502_402863500] FOREIGN KEY ([C_INTEZMENYID]) REFERENCES [dbo].[T_INTEZMENY] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[FK_402863505_402863503]...';
|
|
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH NOCHECK
|
|
ADD CONSTRAINT [FK_402863505_402863503] FOREIGN KEY ([C_TANEVID]) REFERENCES [dbo].[T_TANEV] ([ID]);
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[T_ELEARNINGELERHETOSEG_OSSZES]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[T_ELEARNINGELERHETOSEG_OSSZES]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[T_INTEZMENYADATOK_OSSZES]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[T_INTEZMENYADATOK_OSSZES]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[T_ORARENDIORA_OSSZES]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[T_ORARENDIORA_OSSZES]';
|
|
|
|
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA_OSSZES]...';
|
|
|
|
|
|
GO
|
|
CREATE VIEW [dbo].T_FOGADOORA_OSSZES
|
|
AS
|
|
SELECT *
|
|
FROM dbo.T_FOGADOORA
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORA_OSZTALYCSOPORT_OSSZES]...';
|
|
|
|
|
|
GO
|
|
CREATE VIEW [dbo].T_FOGADOORA_OSZTALYCSOPORT_OSSZES
|
|
AS
|
|
SELECT *
|
|
FROM dbo.T_FOGADOORA_OSZTALYCSOPORT
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT_GONDVISELO_OSSZES]...';
|
|
|
|
|
|
GO
|
|
CREATE VIEW [dbo].T_FOGADOORAIDOPONT_GONDVISELO_OSSZES
|
|
AS
|
|
SELECT *
|
|
FROM dbo.T_FOGADOORAIDOPONT_GONDVISELO
|
|
GO
|
|
PRINT N'Creating [dbo].[T_FOGADOORAIDOPONT_OSSZES]...';
|
|
|
|
|
|
GO
|
|
CREATE VIEW [dbo].T_FOGADOORAIDOPONT_OSSZES
|
|
AS
|
|
SELECT *
|
|
FROM dbo.T_FOGADOORAIDOPONT
|
|
GO
|
|
PRINT N'Refreshing [dbo].[fnGetUtkozesByOsztalycsoport]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetUtkozesByOsztalycsoport]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[fnGetUtkozesByTanar]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetUtkozesByTanar]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[fnGetTanuloTantargyMulasztasOsszesOra]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetTanuloTantargyMulasztasOsszesOra]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[fnGetTanorak]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[fnGetTanorak]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetAttanitasok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetAttanitasok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetFenntartoIntezmenyei]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetFenntartoIntezmenyei]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetHozzatartozoJelszoAdatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetHozzatartozoJelszoAdatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetHozzatartozok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetHozzatartozok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetPedagogusStatuszRiport]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetPedagogusStatuszRiport]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTantargyStatuszRiport]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTantargyStatuszRiport]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanuloBelepesiAdatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanuloBelepesiAdatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanuloJelszoAdatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanuloJelszoAdatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_SetRendszerErtesitesek]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_SetRendszerErtesitesek]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetCsoportNaplo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetCsoportNaplo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetSzakmaiGyNaplo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetSzakmaiGyNaplo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetEgyuttmukodesiMeglallapodas]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetEgyuttmukodesiMeglallapodas]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetElfogadottTantargyfelosztasok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetElfogadottTantargyfelosztasok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanoranKivuliNaplo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanoranKivuliNaplo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetErtesitesAltEsMulAdatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetErtesitesAltEsMulAdatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetErtesitoNyomtatvany]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetErtesitoNyomtatvany]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanuloiAdatlapAdatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanuloiAdatlapAdatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanulokFeljegyzesekReszletezese]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanulokFeljegyzesekReszletezese]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanulokFelmentesekHatarozatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanulokFelmentesekHatarozatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanulokJegyeiReszletezes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanulokJegyeiReszletezes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanulokMulasztasokReszletezese]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanulokMulasztasokReszletezese]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanulokTantargyMulasztasokReszletezese]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanulokTantargyMulasztasokReszletezese]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanuloszerzodes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanuloszerzodes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetFogadooraInfo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetFogadooraInfo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTorzslap]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTorzslap]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetUzenofuzetErtekelolap]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetUzenofuzetErtekelolap]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetIskolalatogatasiIgazolas]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetIskolalatogatasiIgazolas]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetKozossegiJelentkezesLap]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetKozossegiJelentkezesLap]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetMunkaidoElszamoloLap]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetMunkaidoElszamoloLap]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetNapkozisNaplo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetNapkozisNaplo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_FollowUpIntezmenyAdatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_FollowUpIntezmenyAdatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_FollowUpMukodesiHely]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_FollowUpMukodesiHely]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetAdminDashboardAdminisztracio]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetAdminDashboardAdminisztracio]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetAdminDashboardNaplo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetAdminDashboardNaplo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetAdminDashboardStatisztika]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetAdminDashboardStatisztika]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetIktSzandeknyilatkozatAdatok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetIktSzandeknyilatkozatAdatok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetNebuloErtesito]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetNebuloErtesito]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanulokJelenletiIvAlkalmankent]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanulokJelenletiIvAlkalmankent]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTeremOrarend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTeremOrarend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTeremOrarendOsszes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTeremOrarendOsszes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendiOrakhozTartozoTanarok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendiOrakhozTartozoTanarok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendiorakhozTartozoTanulok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendiorakhozTartozoTanulok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_HelyettesitesekKeresese]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_HelyettesitesekKeresese]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetHelyettesitesekOrarend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetHelyettesitesekOrarend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetHelyettesitesekAjanlasa]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetHelyettesitesekAjanlasa]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetHelyettesitoTanarTanorahoz]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetHelyettesitoTanarTanorahoz]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetHianyzoOrabeirasok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetHianyzoOrabeirasok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetNaploEllenorzes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetNaploEllenorzes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetNaploEllenorzesTetelek]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetNaploEllenorzesTetelek]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOralatogatasok]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOralatogatasok]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOsszesNemBejegyzettOra]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOsszesNemBejegyzettOra]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanevrendjeErintettOrarendiOrai]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanevrendjeErintettOrarendiOrai]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetUpdateTantargyfelosztasVisszamenoleges]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetUpdateTantargyfelosztasVisszamenoleges]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_PedagogusNemBejegyzettOrai]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_PedagogusNemBejegyzettOrai]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_TeremKapacitasTullepesVizsgalat]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_TeremKapacitasTullepesVizsgalat]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_UpdateOrarendiOraToroltCsengetesiRend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_UpdateOrarendiOraToroltCsengetesiRend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_UpdateOrarendiOraVisszamenolegesen]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_UpdateOrarendiOraVisszamenolegesen]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[uspUpdateCsengetesiRend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[uspUpdateCsengetesiRend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[uspUpdateOrarendiOraAfterTantargyfelosztasUpdate]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[uspUpdateOrarendiOraAfterTantargyfelosztasUpdate]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetUtkozes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetUtkozes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_CsengetesiRendOrakTorles]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_CsengetesiRendOrakTorles]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendTanoranKivuli]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendTanoranKivuli]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetDokumentumHelyettesitesekByDateInterval]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetDokumentumHelyettesitesekByDateInterval]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_ImportASC]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_ImportASC]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_DeleteAllTTF]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_DeleteAllTTF]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_FizikaiTorlesOrarendek]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_FizikaiTorlesOrarendek]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_FizikaiTorlesTantargyfelosztas]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_FizikaiTorlesTantargyfelosztas]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetDokumentumTanuloOrarend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetDokumentumTanuloOrarend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetFoglalkozasokMegtartandoOraSzama]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetFoglalkozasokMegtartandoOraSzama]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetHelyettesitesiNaplo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetHelyettesitesiNaplo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendErvenyesseggelExcelExportData]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendErvenyesseggelExcelExportData]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendExcelExportData]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendExcelExportData]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendKereszttabla_Osztaly]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendKereszttabla_Osztaly]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendKereszttabla_Pedagogus]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendKereszttabla_Pedagogus]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendKereszttabla_Terem]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendKereszttabla_Terem]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOrarendOsztalyonkent]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOrarendOsztalyonkent]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetPedagogusOrarend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetPedagogusOrarend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetPedagogusOrarendje]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetPedagogusOrarendje]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetStatPedagogusTanuloinakTantargyiMulasztasaiMegtartott]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetStatPedagogusTanuloinakTantargyiMulasztasaiMegtartott]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanarOrarendLefedettseg]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanarOrarendLefedettseg]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTanulokMegtartandoOraSzama]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTanulokMegtartandoOraSzama]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetTeremrend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetTeremrend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_TantargyfelosztasImport]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_TantargyfelosztasImport]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[uspGetTanuloErtekelesDataSetByFotargyAltargy]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[uspGetTanuloErtekelesDataSetByFotargyAltargy]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[uspGetTanuloErtekelesDataSetByTanulo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[uspGetTanuloErtekelesDataSetByTanulo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_PedagogusNemBejegyzettOraiOsszes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_PedagogusNemBejegyzettOraiOsszes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_ImportTantargyFelosztas]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_ImportTantargyFelosztas]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetDokumentumTanuloOrarendOsztalyonkent]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetDokumentumTanuloOrarendOsztalyonkent]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOsztalyNaplo]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOsztalyNaplo]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOsztalyOrarend]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOsztalyOrarend]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetOsztalyOrarendOsszes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetOsztalyOrarendOsszes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_GetPedagogusOrarendOsszes]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_GetPedagogusOrarendOsszes]';
|
|
|
|
|
|
GO
|
|
PRINT N'Refreshing [dbo].[sp_OrarendImport]...';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_refreshsqlmodule N'[dbo].[sp_OrarendImport]';
|
|
|
|
|
|
GO
|
|
PRINT N'Checking existing data against newly created constraints';
|
|
|
|
GO
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH CHECK CHECK CONSTRAINT [FK_4028622_4028620];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH CHECK CHECK CONSTRAINT [FK_4028625_4028623];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH CHECK CHECK CONSTRAINT [FK_4028628_4028626];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH CHECK CHECK CONSTRAINT [FK_402861302_402861300];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA] WITH CHECK CHECK CONSTRAINT [FK_402861305_402861303];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_4028647_4028645];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_4028650_4028648];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402863402_402863400];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORA_OSZTALYCSOPORT] WITH CHECK CHECK CONSTRAINT [FK_402863405_402863403];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT] WITH CHECK CHECK CONSTRAINT [FK_4028638_4028636];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT] WITH CHECK CHECK CONSTRAINT [FK_402862902_402862900];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT] WITH CHECK CHECK CONSTRAINT [FK_402862905_402862903];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH CHECK CHECK CONSTRAINT [FK_4028641_4028639];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH CHECK CHECK CONSTRAINT [FK_4028644_4028642];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH CHECK CHECK CONSTRAINT [FK_402863502_402863500];
|
|
|
|
ALTER TABLE [dbo].[T_FOGADOORAIDOPONT_GONDVISELO] WITH CHECK CHECK CONSTRAINT [FK_402863505_402863503];
|
|
|
|
|
|
GO
|
|
PRINT N'Update complete.';
|
|
|
|
|
|
GO
|
|
--------------------
|
|
|
|
|
|
PRINT '--- intézményi view-k (dbo táblákkal megegyező nevű és a tábla_OSSZES nevűek) frissítése ---'
|
|
|
|
DECLARE @viewname nvarchar(100), @pureview nvarchar(100)
|
|
|
|
DECLARE semaviewk CURSOR LOCAL FOR
|
|
SELECT '['+TABLE_SCHEMA + '].[' + TABLE_NAME + ']', TABLE_NAME
|
|
FROM INFORMATION_SCHEMA.TABLES
|
|
WHERE TABLE_TYPE = 'VIEW' and TABLE_SCHEMA LIKE 'KR[_]%[_]Schema'
|
|
AND TABLE_NAME in ('T_ELEARNINGELERHETOSEG', 'T_ELEARNINGELERHETOSEG_OSSZES'
|
|
,'T_ORARENDIORA', 'T_ORARENDIORA_OSSZES'
|
|
,'T_INTEZMENYADATOK', 'T_INTEZMENYADATOK_OSSZES') -- ha csak néhány VIEW frissült, akkor a gyorsabb futásért ide fel lehet sorolni
|
|
ORDER BY TABLE_SCHEMA, TABLE_NAME
|
|
|
|
OPEN semaviewk
|
|
FETCH NEXT FROM semaviewk INTO @viewname, @pureview
|
|
|
|
WHILE @@FETCH_STATUS = 0 BEGIN
|
|
PRINT @viewname
|
|
EXEC sp_refreshview @viewname
|
|
|
|
FETCH NEXT FROM semaviewk INTO @viewname, @pureview
|
|
END
|
|
|
|
CLOSE semaviewk
|
|
DEALLOCATE semaviewk
|
|
GO
|
|
|
|
|
|
--------------------
|
|
|
|
EXEC dev.sp_Global_GenerateAsyncAuditTriggerAll
|
|
GO
|
|
|
|
|
|
ALTER QUEUE auditLog.[AuditQueue]
|
|
WITH ACTIVATION
|
|
(
|
|
STATUS = ON,
|
|
PROCEDURE_NAME = auditLog.usp_AuditProcessing,
|
|
MAX_QUEUE_READERS = 10,
|
|
EXECUTE AS 'Kreta_tech_user'
|
|
);
|
|
|
|
GO |