34 lines
1002 B
C#
34 lines
1002 B
C#
using FluentMigrator;
|
|
|
|
namespace Kreta.DataAccess.Migrations.Migrations
|
|
{
|
|
[Migration(20200127163504)]
|
|
public class KRETA2_2311 : CustomMigration
|
|
{
|
|
public override void Up()
|
|
{
|
|
ExecuteScripts(
|
|
"sp_GetElozoOraAdatai.sql",
|
|
"sp_GetOraSorszamByOsztaly.sql",
|
|
"fnGetEvesOraszamLista.sql",
|
|
"fnGetEvesOraszamByTanitasiOraId.sql",
|
|
"fnGetEvesOraszamListaByTanitasiOraId.sql"
|
|
);
|
|
CreateSchemaSPFN(
|
|
"sp_GetElozoOraAdatai",
|
|
"sp_GetOraSorszamByOsztaly",
|
|
"fnGetEvesOraszamLista",
|
|
"fnGetEvesOraszamByTanitasiOraId",
|
|
"fnGetEvesOraszamListaByTanitasiOraId"
|
|
);
|
|
DeleteStoredProcedures("sp_GetOraEvesSorszama", "sp_GetOraEvesSorszamaLista");
|
|
DeleteFunctions("fnGetEvesOraszam");
|
|
}
|
|
|
|
public override void Down()
|
|
{
|
|
}
|
|
}
|
|
}
|
|
|