From 25207f5a650ab29e0a7b667d61a721e7e6e1f8b8 Mon Sep 17 00:00:00 2001 From: Aleksander Machniak Date: Thu, 4 Sep 2014 13:26:10 +0200 Subject: Fix error in MSSQL update script 2013061000.sql (#1490061) --- SQL/mssql/2013061000.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'SQL') 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]) -- cgit v1.2.3