From 030ebec02fb97dedb78cb6ddb10f0edcc77b208a Mon Sep 17 00:00:00 2001 From: Aleksander Machniak <alec@alec.pl> Date: Thu, 04 Sep 2014 07:26:10 -0400 Subject: [PATCH] Fix error in MSSQL update script 2013061000.sql (#1490061) --- CHANGELOG | 1 + SQL/mssql/2013061000.sql | 10 +++++----- 2 files changed, 6 insertions(+), 5 deletions(-) diff --git a/CHANGELOG b/CHANGELOG index d59ae5b..5e02d93 100644 --- a/CHANGELOG +++ b/CHANGELOG @@ -59,6 +59,7 @@ - Fix contacts list update after adding/deleting/moving a contact (#1490028, #1490033) - Fix handling of email addresses with quoted domain part (#1490040) - Fix comm_path update on task switch (#1490041) +- Fix error in MSSQL update script 2013061000.sql (#1490061) RELEASE 1.0.2 ------------- diff --git a/SQL/mssql/2013061000.sql b/SQL/mssql/2013061000.sql index 55b5ec3..5e8b791 100644 --- a/SQL/mssql/2013061000.sql +++ b/SQL/mssql/2013061000.sql @@ -1,12 +1,12 @@ -ALTER TABLE [dbo].[cache] ADD COLUMN [expires] [datetime] NULL +ALTER TABLE [dbo].[cache] ADD [expires] [datetime] NULL GO -ALTER TABLE [dbo].[cache_shared] ADD COLUMN [expires] [datetime] NULL +ALTER TABLE [dbo].[cache_shared] ADD [expires] [datetime] NULL GO -ALTER TABLE [dbo].[cache_index] ADD COLUMN [expires] [datetime] NULL +ALTER TABLE [dbo].[cache_index] ADD [expires] [datetime] NULL GO -ALTER TABLE [dbo].[cache_thread] ADD COLUMN [expires] [datetime] NULL +ALTER TABLE [dbo].[cache_thread] ADD [expires] [datetime] NULL GO -ALTER TABLE [dbo].[cache_messages] ADD COLUMN [expires] [datetime] NULL +ALTER TABLE [dbo].[cache_messages] ADD [expires] [datetime] NULL GO UPDATE [dbo].[cache] SET [expires] = DATEADD(second, 604800, [created]) -- Gitblit v1.9.1