summaryrefslogtreecommitdiff
path: root/SQL/mssql
diff options
context:
space:
mode:
Diffstat (limited to 'SQL/mssql')
-rw-r--r--SQL/mssql/2013061000.sql10
1 files changed, 5 insertions, 5 deletions
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])