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:10 +0200 |
| commit | 030ebec02fb97dedb78cb6ddb10f0edcc77b208a (patch) | |
| tree | 3837fedcff81ef0da6c4f90b04a3d9716b866f09 /SQL/mssql/2013061000.sql | |
| parent | f456c6e2d77e4c3a16eebbb754569aff2f85d43a (diff) | |
Fix error in MSSQL update script 2013061000.sql (#1490061)
Diffstat (limited to 'SQL/mssql/2013061000.sql')
| -rw-r--r-- | SQL/mssql/2013061000.sql | 10 |
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])
|