public static void Init_1_0_0_44(IDatabaseUpgrader du)
{
string sql = @"
";
du.AddColumnToTable("comment", "nvarchar(500)", "review", true);
//du.RunDDLCommands(sql);
}
public static void Init_1_0_0_39(IDatabaseUpgrader du)
{
//string sql = @"";
du.AddColumnToTable("SpecificContact", "nvarchar(100)", "watchdog", true);
//add new bank account
}
public static void Init_1_0_0_50(IDatabaseUpgrader du)
{
string sql = @"
";
//du.RunDDLCommands(sql);
du.AddColumnToTable("Created", "datetime", "Bookmarks", false);
}
public static void Init_1_0_0_40(IDatabaseUpgrader du)
{
du.AddColumnToTable("LatestRec", "datetime", "watchdog", true);
string sql = @"
update watchdog
set LatestRec = '2018-02-22'
where LatestRec is null
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_38(IDatabaseUpgrader du)
{
string sql = @"
update watchdog
set dataType = 'Smlouva'
where dataType is null
";
du.AddColumnToTable("dataType", "nvarchar(50)", "watchdog", true);
du.RunDDLCommands(sql);
//add new bank account
}
public static void Init_1_0_0_58(IDatabaseUpgrader du)
{
du.AddColumnToTable("priority", "int", "ItemToOcrQueue", true);
string sql = @"update ItemToOcrQueue set priority = 10";
//du.RunDDLCommands(sql);
}
public static void Init_1_0_0_56(IDatabaseUpgrader du)
{
du.AddColumnToTable("IP","nvarchar(15)","Audit",true);
}
public static void Init_1_0_0_52(IDatabaseUpgrader du)
{
du.AddColumnToTable("IsInRS", "smallint", "Firma", true);
//du.RunDDLCommands(sql);
}
public static void Init_1_0_0_2(IDatabaseUpgrader du)
{
du.AddColumnToTable("Source", "nvarchar(100)", "Firma", true);
du.AddColumnToTable("Popis", "nvarchar(100)", "Firma", true);
string sql = @"
/****** Object: StoredProcedure [dbo].[Firma_Save] Script Date: 24/10/16 23:18:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Firma_Save]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'ALTER PROCEDURE [dbo].[Firma_Save]
-- Add the parameters for the stored procedure here
@ICO nvarchar(30),
@DIC nvarchar(30),
@Datum_zapisu_OR date,
@Stav_subjektu tinyint,
@Jmeno nvarchar(500),
@Kod_PF int,
@Source nvarchar(100),
@Popis nvarchar(100),
@VersionUpdate int
AS
BEGIN
IF EXISTS(SELECT ico FROM firma WITH(NOLOCK)
WHERE ico = @ico)
BEGIN
UPDATE [dbo].[Firma]
SET
[DIC] = @DIC,
[Datum_zapisu_OR] = @Datum_zapisu_OR,
[Stav_subjektu] = @Stav_subjektu,
[Jmeno] = @Jmeno,
[Kod_PF] = @Kod_PF,
[Source] = @source,
[Popis] = @popis,
[VersionUpdate] = @VersionUpdate
WHERE [ICO] = @ico
END
ELSE
BEGIN
INSERT INTO [dbo].[Firma] ([ICO],[DIC],[Datum_zapisu_OR],[Stav_subjektu],[Jmeno],[Kod_PF],[VersionUpdate], source, popis)
VALUES (@ICO,@DIC,@Datum_zapisu_OR,@Stav_subjektu,@Jmeno,@Kod_PF,@VersionUpdate, @source, @popis)
END
END
'
END
";
du.RunDDLCommands(sql);
}