using FluentMigrator;

namespace Kreta.DataAccess.Migrations.Migrations
{
    [Migration(20170604075207)]
    public class KRETA_1612 : CustomMigration
    {
        public override void Up()
        {
            ExecuteScripts("create.elozotanevirekordid.sql", "sp_Global_GenerateTanevAdatokFromExistingTanev.sql", "AddNewTanev.sql");
            ExecuteScripts("refreshallschemaview.sql");

            ExecuteScripts("sp_FollowUpIntezmenyAdatok.sql");
            CreateSchemaStoredProcedures("sp_FollowUpIntezmenyAdatok");
            ExecuteScripts("sp_FollowUpMukodesiHely.sql");
            CreateSchemaStoredProcedures("sp_FollowUpMukodesiHely");
            ExecuteScripts("sp_FollowUpFeladatellatasiHely.sql");
            CreateSchemaStoredProcedures("sp_FollowUpFeladatellatasiHely");
            ExecuteScripts("sp_FollowUpAlkalmazott.sql");
            CreateSchemaStoredProcedures("sp_FollowUpAlkalmazott");
            ExecuteScripts("sp_FollowUpEszkoz.sql");
            CreateSchemaStoredProcedures("sp_FollowUpEszkoz");
            ExecuteScripts("sp_FollowUpOraterv.sql");
            CreateSchemaStoredProcedures("sp_FollowUpOraterv");
            ExecuteScripts("sp_FollowUpTantargy.sql");
            CreateSchemaStoredProcedures("sp_FollowUpTantargy");
            ExecuteScripts("sp_FollowUpTanterv.sql");
            CreateSchemaStoredProcedures("sp_FollowUpTanterv");
            ExecuteScripts("sp_FollowUpTerem.sql");
            CreateSchemaStoredProcedures("sp_FollowUpTerem");
        }

        public override void Down()
        {
        }
    }
}