diff options
author | Aleksander Machniak <alec@alec.pl> | 2014-09-04 13:26:10 +0200 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2014-09-04 13:26:55 +0200 |
commit | 25207f5a650ab29e0a7b667d61a721e7e6e1f8b8 (patch) | |
tree | 0ac3c6a73db96a4faad046d96770220c07327d44 | |
parent | 574f416076d5ea65f8720d4680135c4f50d19f29 (diff) |
Fix error in MSSQL update script 2013061000.sql (#1490061)
-rw-r--r-- | CHANGELOG | 1 | ||||
-rw-r--r-- | SQL/mssql/2013061000.sql | 10 |
2 files changed, 6 insertions, 5 deletions
@@ -14,6 +14,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])
|