summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2014-09-04 13:26:10 +0200
committerAleksander Machniak <alec@alec.pl>2014-09-04 13:26:10 +0200
commit030ebec02fb97dedb78cb6ddb10f0edcc77b208a (patch)
tree3837fedcff81ef0da6c4f90b04a3d9716b866f09
parentf456c6e2d77e4c3a16eebbb754569aff2f85d43a (diff)
Fix error in MSSQL update script 2013061000.sql (#1490061)
-rw-r--r--CHANGELOG1
-rw-r--r--SQL/mssql/2013061000.sql10
2 files changed, 6 insertions, 5 deletions
diff --git a/CHANGELOG b/CHANGELOG
index d59ae5bc7..5e02d9370 100644
--- a/CHANGELOG
+++ b/CHANGELOG
@@ -59,6 +59,7 @@ CHANGELOG Roundcube Webmail
- 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 55b5ec3a5..5e8b791f1 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])