diff options
Diffstat (limited to 'SQL/mssql/2013061000.sql')
-rw-r--r-- | SQL/mssql/2013061000.sql | 44 |
1 files changed, 0 insertions, 44 deletions
diff --git a/SQL/mssql/2013061000.sql b/SQL/mssql/2013061000.sql deleted file mode 100644 index 5e8b791f1..000000000 --- a/SQL/mssql/2013061000.sql +++ /dev/null @@ -1,44 +0,0 @@ -ALTER TABLE [dbo].[cache] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_shared] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_index] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_thread] ADD [expires] [datetime] NULL
-GO
-ALTER TABLE [dbo].[cache_messages] ADD [expires] [datetime] NULL
-GO
-
-UPDATE [dbo].[cache] SET [expires] = DATEADD(second, 604800, [created])
-GO
-UPDATE [dbo].[cache_shared] SET [expires] = DATEADD(second, 604800, [created])
-GO
-UPDATE [dbo].[cache_index] SET [expires] = DATEADD(second, 604800, [changed])
-GO
-UPDATE [dbo].[cache_thread] SET [expires] = DATEADD(second, 604800, [changed])
-GO
-UPDATE [dbo].[cache_messages] SET [expires] = DATEADD(second, 604800, [changed])
-GO
-
-DROP INDEX [IX_cache_created]
-GO
-DROP INDEX [IX_cache_shared_created]
-GO
-ALTER TABLE [dbo].[cache_index] DROP COLUMN [changed]
-GO
-ALTER TABLE [dbo].[cache_thread] DROP COLUMN [changed]
-GO
-ALTER TABLE [dbo].[cache_messages] DROP COLUMN [changed]
-GO
-
-CREATE INDEX [IX_cache_expires] ON [dbo].[cache]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_shared_expires] ON [dbo].[cache_shared]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_index_expires] ON [dbo].[cache_index]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_thread_expires] ON [dbo].[cache_thread]([expires]) ON [PRIMARY]
-GO
-CREATE INDEX [IX_cache_messages_expires] ON [dbo].[cache_messages]([expires]) ON [PRIMARY]
-GO
-
\ No newline at end of file |