diff options
| author | Aleksander Machniak <alec@alec.pl> | 2014-09-08 20:25:14 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2014-09-08 20:25:14 +0200 |
| commit | 871a26d3285f771279e2efb0ea96baf88b952213 (patch) | |
| tree | e4e592d700a29c8b8672ee01d3ff09fb60868151 /SQL/mssql | |
| parent | 1dafdff79a4da2ddc634b43814c746193fa6fbc4 (diff) | |
| parent | 25207f5a650ab29e0a7b667d61a721e7e6e1f8b8 (diff) | |
Merge branch 'release-1.0' of github.com:roundcube/roundcubemail into release-1.0
Diffstat (limited to 'SQL/mssql')
| -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])
|