commit | author | age
|
030ebe
|
1 |
ALTER TABLE [dbo].[cache] ADD [expires] [datetime] NULL
|
60b6d7
|
2 |
GO
|
030ebe
|
3 |
ALTER TABLE [dbo].[cache_shared] ADD [expires] [datetime] NULL
|
60b6d7
|
4 |
GO
|
030ebe
|
5 |
ALTER TABLE [dbo].[cache_index] ADD [expires] [datetime] NULL
|
60b6d7
|
6 |
GO
|
030ebe
|
7 |
ALTER TABLE [dbo].[cache_thread] ADD [expires] [datetime] NULL
|
60b6d7
|
8 |
GO
|
030ebe
|
9 |
ALTER TABLE [dbo].[cache_messages] ADD [expires] [datetime] NULL
|
60b6d7
|
10 |
GO
|
AM |
11 |
|
|
12 |
UPDATE [dbo].[cache] SET [expires] = DATEADD(second, 604800, [created])
|
|
13 |
GO
|
|
14 |
UPDATE [dbo].[cache_shared] SET [expires] = DATEADD(second, 604800, [created])
|
|
15 |
GO
|
|
16 |
UPDATE [dbo].[cache_index] SET [expires] = DATEADD(second, 604800, [changed])
|
|
17 |
GO
|
|
18 |
UPDATE [dbo].[cache_thread] SET [expires] = DATEADD(second, 604800, [changed])
|
|
19 |
GO
|
|
20 |
UPDATE [dbo].[cache_messages] SET [expires] = DATEADD(second, 604800, [changed])
|
|
21 |
GO
|
|
22 |
|
|
23 |
DROP INDEX [IX_cache_created]
|
|
24 |
GO
|
|
25 |
DROP INDEX [IX_cache_shared_created]
|
|
26 |
GO
|
|
27 |
ALTER TABLE [dbo].[cache_index] DROP COLUMN [changed]
|
|
28 |
GO
|
|
29 |
ALTER TABLE [dbo].[cache_thread] DROP COLUMN [changed]
|
|
30 |
GO
|
|
31 |
ALTER TABLE [dbo].[cache_messages] DROP COLUMN [changed]
|
|
32 |
GO
|
|
33 |
|
|
34 |
CREATE INDEX [IX_cache_expires] ON [dbo].[cache]([expires]) ON [PRIMARY]
|
|
35 |
GO
|
|
36 |
CREATE INDEX [IX_cache_shared_expires] ON [dbo].[cache_shared]([expires]) ON [PRIMARY]
|
|
37 |
GO
|
|
38 |
CREATE INDEX [IX_cache_index_expires] ON [dbo].[cache_index]([expires]) ON [PRIMARY]
|
|
39 |
GO
|
|
40 |
CREATE INDEX [IX_cache_thread_expires] ON [dbo].[cache_thread]([expires]) ON [PRIMARY]
|
|
41 |
GO
|
|
42 |
CREATE INDEX [IX_cache_messages_expires] ON [dbo].[cache_messages]([expires]) ON [PRIMARY]
|
|
43 |
GO
|
|
44 |
|