public static void Init_1_0_0_51(IDatabaseUpgrader du)
{
string sql = @"
CREATE NONCLUSTERED INDEX [idx_audit_date] ON [dbo].[Audit]
(
[date] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
CREATE NONCLUSTERED INDEX [idx_audit_userid] ON [dbo].[Audit]
(
[userId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
CREATE NONCLUSTERED INDEX [idx_audit_objectId] ON [dbo].[Audit]
(
[objectId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_70(IDatabaseUpgrader du)
{
string sql = @"
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
BEGIN
CREATE TABLE dbo.ClassificationOverride
(
Id int IDENTITY(1,1) NOT NULL PRIMARY KEY,
IdSmlouvy nvarchar(50) NOT NULL,
OriginalCat1 int NULL,
OriginalCat2 int NULL,
CorrectCat1 int NULL,
CorrectCat2 int NULL,
CreatedBy nvarchar(150) NULL,
Created datetime NULL
) ON [PRIMARY]
END
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_8(IDatabaseUpgrader du)
{
string sql = @"
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DumpData]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[DumpData](
[pk] [int] IDENTITY(1,1) NOT NULL,
[Created] [datetime] NOT NULL,
[Processed] [datetime] NULL,
[mesic] [int] NOT NULL,
[rok] [int] NOT NULL,
[hash] [nvarchar](65) NOT NULL,
[velikost] [bigint] NOT NULL,
[casGenerovani] [datetime] NOT NULL,
CONSTRAINT [PK_DumpData] PRIMARY KEY CLUSTERED
(
[pk] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_63(IDatabaseUpgrader du)
{
string sql = @"
CREATE TABLE EventType(
Id int,
Name nvarchar(200),
PRIMARY KEY(Id)
);
--inserty do event type
insert into EventType(Id,Name) values (0,N'Speciální')
insert into EventType(Id,Name) values (1,N'Volená funkce')
insert into EventType(Id,Name) values (2,N'Soukromá pracovní')
insert into EventType(Id,Name) values (3,N'Sponzor')
insert into EventType(Id,Name) values (4,N'Osobní')
insert into EventType(Id,Name) values (6,N'Veřejná správa pracovní')
insert into EventType(Id,Name) values (7,N'Politická')
insert into EventType(Id,Name) values (9,N'Politická pracovní')
insert into EventType(Id,Name) values (10,N'Veřejná správa jiné')
insert into EventType(Id,Name) values (11,N'Jiné')
alter table OsobaEvent
add Organizace nvarchar(max);
-- přejmenovat description na note
EXEC sp_RENAME 'OsobaEvent.Description' , 'Note', 'COLUMN'
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_22(IDatabaseUpgrader du)
{
//fix of 1.0.0.14 script
string sql = @"
ALTER TABLE dbo.OsobaVazby ADD
VazbakOsobaId int NULL
GO
ALTER TABLE dbo.OsobaVazby ADD
RucniZapis int NULL
GO
ALTER TABLE dbo.OsobaVazby ADD
Poznamka nvarchar(500) NULL
GO
ALTER TABLE dbo.FirmaVazby ADD
RucniZapis int NULL
GO
ALTER TABLE dbo.FirmaVazby ADD
Poznamka nvarchar(500) NULL
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_37(IDatabaseUpgrader du)
{
string sql = @"
/****** Object: Table [dbo].[NespolehlivyPlatceDPH] Script Date: 04.01.2018 23:49:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NespolehlivyPlatceDPH]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[NespolehlivyPlatceDPH](
[Ico] [nvarchar](50) NOT NULL,
[FromDate] [date] NULL,
[ToDate] [date] NULL,
CONSTRAINT [PK_NespolehlivyPlatceDPH] PRIMARY KEY CLUSTERED
(
[Ico] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
";
du.RunDDLCommands(sql);
//add new bank account
}
public static void Init_1_0_0_78(IDatabaseUpgrader du)
{
string sql = @"
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.DumpData ADD
den int NULL
GO
ALTER TABLE dbo.DumpData ADD CONSTRAINT
DF_DumpData_den DEFAULT 0 FOR den
GO
ALTER TABLE dbo.DumpData SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_85(IDatabaseUpgrader du)
{
string sql = @"ALTER TABLE dbo.AutocompleteSynonyms ADD active int NOT NULL CONSTRAINT DF_AutocompleteSynonyms_active DEFAULT 1
";
du.RunDDLCommands(sql);
}
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_76(IDatabaseUpgrader du)
{
string sql = @"ALTER TABLE OsobaEvent ADD
Ico NVARCHAR(20) NULL,
CEO int NULL;" ;
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_0(IDatabaseUpgrader du)
{
string sql = @"
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_49(IDatabaseUpgrader du)
{
string sql = @"
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_Bookmarks_Folder]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Bookmarks] DROP CONSTRAINT [DF_Bookmarks_Folder]
END
GO
/****** Object: Table [dbo].[Bookmarks] Script Date: 26/09/2018 09:12:47 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Bookmarks]') AND type in (N'U'))
DROP TABLE [dbo].[Bookmarks]
GO
/****** Object: Table [dbo].[Bookmarks] Script Date: 26/09/2018 09:12:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Bookmarks]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Bookmarks](
[Id] [uniqueidentifier] NOT NULL,
[UserId] [nvarchar](256) NOT NULL,
[Folder] [nvarchar](50) NOT NULL,
[Name] [nvarchar](250) NOT NULL,
[Url] [varchar](4000) NOT NULL,
[ItemType] [int] NOT NULL,
[ItemId] [nvarchar](256) NOT NULL,
CONSTRAINT [PK_Bookmarks] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_Bookmarks_Folder]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Bookmarks] ADD CONSTRAINT [DF_Bookmarks_Folder] DEFAULT ('') FOR [Folder]
END
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_77(IDatabaseUpgrader du)
{
string sql = @"BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.SSMQ
(
pk int NOT NULL,
qname nvarchar(255) NOT NULL,
itemid nvarchar(500) NOT NULL,
itemstatus int NOT NULL,
itemvalue nvarchar(MAX) NOT NULL,
created datetime NOT NULL,
createdby nvarchar(255) NOT NULL,
priority int NOT NULL,
changed datetime NOT NULL,
changedBy nvarchar(255) NOT NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE dbo.SSMQ ADD CONSTRAINT
DF_SSMQ_created DEFAULT GetDate() FOR created
GO
ALTER TABLE dbo.SSMQ ADD CONSTRAINT
DF_SSMQ_priority DEFAULT 1 FOR priority
GO
ALTER TABLE dbo.SSMQ ADD CONSTRAINT
PK_SSMQ PRIMARY KEY CLUSTERED
(
pk
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_qname ON dbo.SSMQ
(
qname
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_created_priority ON dbo.SSMQ
(
created
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE dbo.SSMQ SET (LOCK_ESCALATION = TABLE)
GO
COMMIT";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_4(IDatabaseUpgrader du)
{
string sql = @"
/****** Object: Table [dbo].[__MigrationHistory] Script Date: 26/10/16 22:57:23 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[__MigrationHistory]') AND type in (N'U'))
DROP TABLE [dbo].[__MigrationHistory]
GO
/****** Object: Table [dbo].[DatoveSchranky] Script Date: 26/10/16 23:11:19 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DatoveSchranky]') AND type in (N'U'))
DROP TABLE [dbo].[DatoveSchranky]
GO
/****** Object: Table [dbo].[DatoveSchranky] Script Date: 26/10/16 23:11:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DatoveSchranky]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[DatoveSchranky](
[DS] [nvarchar](50) NOT NULL,
[Identifikator] [nvarchar](50) NOT NULL,
[DetailJson] [nvarchar](max) NULL,
[Url] [nvarchar](100) NULL,
CONSTRAINT [PK_DatoveSchranky] PRIMARY KEY CLUSTERED
(
[DS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** Object: Index [IX_DatoveSchranky_url] Script Date: 27/10/16 09:52:52 ******/
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[DatoveSchranky]') AND name = N'IX_DatoveSchranky_url')
DROP INDEX [IX_DatoveSchranky_url] ON [dbo].[DatoveSchranky]
GO
/****** Object: Index [IX_DatoveSchranky_url] Script Date: 27/10/16 09:52:52 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[DatoveSchranky]') AND name = N'IX_DatoveSchranky_url')
CREATE NONCLUSTERED INDEX [IX_DatoveSchranky_url] ON [dbo].[DatoveSchranky]
(
[Url] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_6(IDatabaseUpgrader du)
{
string sql = @"
/****** Object: Table [dbo].[WatchDog] Script Date: 29.01.2017 18:28:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WatchDog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[WatchDog](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserId] [nvarchar](128) NOT NULL,
[Created] [datetime] NOT NULL,
[Expires] [datetime] NULL,
[StatusId] [int] NOT NULL,
[SearchTerm] [nvarchar](1000) NOT NULL,
[SearchRawQuery] [nvarchar](max) NULL,
[RunCount] [int] NOT NULL CONSTRAINT [DF_WatchDog_RunCount] DEFAULT ((0)),
[SentCount] [int] NOT NULL CONSTRAINT [DF_WatchDog_SentCount] DEFAULT ((0)),
[PeriodId] [int] NOT NULL,
[LastSent] [datetime] NULL,
[LastSearched] [datetime] NULL,
[ToEmail] [int] NOT NULL CONSTRAINT [DF_WatchDog_ToEmail] DEFAULT ((1)),
[ShowPublic] [int] NOT NULL CONSTRAINT [DF_WatchDog_Public] DEFAULT ((0)),
CONSTRAINT [PK_WatchDog] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IX_WatchDog_UserId] Script Date: 29.01.2017 18:28:48 ******/
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WatchDog]') AND name = N'IX_WatchDog_UserId')
CREATE NONCLUSTERED INDEX [IX_WatchDog_UserId] ON [dbo].[WatchDog]
(
[UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_36(IDatabaseUpgrader du)
{
string sql = @"
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_Audit_date]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Audit] DROP CONSTRAINT [DF_Audit_date]
END
GO
/****** Object: Table [dbo].[Audit] Script Date: 06.11.2017 22:43:41 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Audit]') AND type in (N'U'))
DROP TABLE [dbo].[Audit]
GO
/****** Object: Table [dbo].[Audit] Script Date: 06.11.2017 22:43:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Audit]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Audit](
[pk] [int] IDENTITY(1,1) NOT NULL,
[date] [datetime] NOT NULL,
[userId] [nvarchar](50) NOT NULL,
[operation] [nvarchar](50) NOT NULL,
[objectType] [nvarchar](150) NOT NULL,
[objectId] [nvarchar](150) NOT NULL,
[valueBefore] [nvarchar](max) NULL,
[valueAfter] [nvarchar](max) NULL,
CONSTRAINT [PK_Audit] PRIMARY KEY CLUSTERED
(
[pk] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_Audit_date]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Audit] ADD CONSTRAINT [DF_Audit_date] DEFAULT (getdate()) FOR [date]
END
GO
";
du.RunDDLCommands(sql);
//add new bank account
}
public static void Init_1_0_0_72(IDatabaseUpgrader du)
{
string sql = @"
ALTER TABLE dbo.FirmaEvent ADD Note nvarchar(max);
GO
COMMIT
";
du.RunDDLCommands(sql);
}
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_66(IDatabaseUpgrader du)
{
string sql = @"
ALTER TABLE dbo.OsobaEvent ADD Status int;
GO
COMMIT
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_24(IDatabaseUpgrader du)
{
string sql = @"
";
du.RunDDLCommands(sql);
//add new bank account
}
public static void Init_1_0_0_18(IDatabaseUpgrader du)
{
//fix of 1.0.0.14 script
string sql = @"
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
GO
CREATE TABLE dbo.Tmp_OsobaEvent
(
pk int NOT NULL,
OsobaId int NOT NULL,
Title nvarchar(200) NULL,
Description nvarchar(MAX) NULL,
DatumOd date NULL,
DatumDo date NULL,
Type int NOT NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_OsobaEvent SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.OsobaEvent)
EXEC('INSERT INTO dbo.Tmp_OsobaEvent (pk, OsobaId, Title, Description, DatumOd, DatumDo, Type)
SELECT pk, OsobaId, Title, Description, DatumOd, DatumDo, Type FROM dbo.OsobaEvent WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.OsobaEvent
GO
EXECUTE sp_rename N'dbo.Tmp_OsobaEvent', N'OsobaEvent', 'OBJECT'
GO
ALTER TABLE dbo.OsobaEvent ADD CONSTRAINT
PK_OsobaEvent_1 PRIMARY KEY CLUSTERED
(
pk
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX IX_OsobaEvent_Osoba ON dbo.OsobaEvent
(
OsobaId
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_3(IDatabaseUpgrader du)
{
string sql = @"
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_Orders_Created]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Orders] DROP CONSTRAINT [DF_Orders_Created]
END
GO
/****** Object: Table [dbo].[Orders] Script Date: 26/10/16 13:18:41 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type in (N'U'))
DROP TABLE [dbo].[Orders]
GO
/****** Object: Table [dbo].[Orders] Script Date: 26/10/16 13:18:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Orders]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Orders](
[OrderId] [int] IDENTITY(2016,1) NOT NULL,
[ICO] [nvarchar](20) NULL,
[DIC] [nvarchar](50) NULL,
[Jmeno] [nvarchar](150) NULL,
[Created] [datetime] NOT NULL,
[PaidUntil] [date] NULL,
[Deleted] [datetime] NULL,
[UserId] [nvarchar](128) NOT NULL,
CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED
(
[OrderId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[DF_Orders_Created]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[Orders] ADD CONSTRAINT [DF_Orders_Created] DEFAULT (getdate()) FOR [Created]
END
GO
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_71(IDatabaseUpgrader du)
{
string sql = @"
ALTER TABLE dbo.Osoba ADD ManuallyUpdated DateTime;
ALTER TABLE dbo.Osoba ADD ManuallyUpdatedBy nvarchar(150);
GO
COMMIT
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_81(IDatabaseUpgrader du)
{
string sql = @"
CREATE INDEX idx_sponzoring_OsobaIdDarce ON Sponzoring (OsobaIdDarce);
CREATE INDEX idx_sponzoring_IcoDarce ON Sponzoring (IcoDarce);
CREATE INDEX idx_sponzoring_OsobaIdPrijemce ON Sponzoring (OsobaIdPrijemce);
CREATE INDEX idx_sponzoring_IcoPrijemce ON Sponzoring (IcoPrijemce);
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_23(IDatabaseUpgrader du)
{
//fix of 1.0.0.14 script
string sql = @"
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1486017, '26014343',99, 'Spravce AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (800730, '26014343',99, 'Protektor AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1461247, '26014343',99, 'Protektor AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1032422, '26014343',99, 'Protektor AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1486017, '26185610',99, 'Spravce AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (800730, '26185610',99, 'Protektor AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1461247, '26185610',99, 'Protektor AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1032422, '26185610',99, 'Protektor AB private trust I', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1032422, '26185610',99, 'Spravce AB private trust II', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (800730, '26185610',99, 'Protektor AB private trust II', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1461247, '26185610',99, 'Protektor AB private trust II', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis, Zdroj)
values (1486017, '26185610',99, 'Protektor AB private trust II', '2017-02-03',1, 'bit.ly/AB_private_trust')
insert into OsobaVazby(OsobaID, VazbakICO, VazbakOsobaId, TypVazby, PojmenovaniVazby, DatumOd, RucniZapis)
values (2097081,'', 1461247,-3, 'Partnerka/manželka', null,1 )
insert into OsobaEvent(OsobaId, Title, DatumOd, [Type], AddInfo)
values (1461247, 'Partnerka', '1994-01-01',4,'2097081')
insert into OsobaEvent(OsobaId, Title, DatumOd, [Type], AddInfo)
values (2097081, 'Partner', '1994-01-01',4,'1461247')
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_20(IDatabaseUpgrader du)
{
//fix of 1.0.0.14 script
string sql = @"
";
du.RunDDLCommands(sql);
}
public static void Init_1_0_0_31(IDatabaseUpgrader du)
{
string sql = @"
ALTER TABLE dbo.WatchDog ADD
FocusId int NOT NULL CONSTRAINT DF_WatchDog_FocusId DEFAULT 0
";
du.RunDDLCommands(sql);
//add new bank account
}
public static IDatabaseUpgrader Create(IDatabaseUpgrader[] children)
{
if (children == null || children.Length == 0) {
return null;
}
if (children.Length == 1) {
return children.First();
}
return new aggregate_upgrader(children);
}
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_7(IDatabaseUpgrader du)
{
string sql = @"
ALTER TABLE dbo.WatchDog ADD
Name nvarchar(50) NULL
";
du.RunDDLCommands(sql);
}
private aggregate_upgrader(IDatabaseUpgrader[] children)
{
_children = children;
}
