|
0
|
1 ALTER TABLE [dbo].[cache] ADD [expires] [datetime] NULL
|
|
|
2 GO
|
|
|
3 ALTER TABLE [dbo].[cache_shared] ADD [expires] [datetime] NULL
|
|
|
4 GO
|
|
|
5 ALTER TABLE [dbo].[cache_index] ADD [expires] [datetime] NULL
|
|
|
6 GO
|
|
|
7 ALTER TABLE [dbo].[cache_thread] ADD [expires] [datetime] NULL
|
|
|
8 GO
|
|
|
9 ALTER TABLE [dbo].[cache_messages] ADD [expires] [datetime] NULL
|
|
|
10 GO
|
|
|
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
|
