Mercurial > hg > rc1

comparison SQL/mssql/2013061000.sql @ 0:1e000243b222

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:50:29 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:1e000243b222
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