Mercurial > hg > rc1

comparison SQL/mssql/2016112200.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 DROP TABLE [dbo].[cache]
2 GO
3 DROP TABLE [dbo].[cache_shared]
4 GO
5
6 CREATE TABLE [dbo].[cache] (
7 [user_id] [int] NOT NULL ,
8 [cache_key] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
9 [expires] [datetime] NULL ,
10 [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
11 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
12 GO
13 CREATE TABLE [dbo].[cache_shared] (
14 [cache_key] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
15 [expires] [datetime] NULL ,
16 [data] [text] COLLATE Latin1_General_CI_AI NOT NULL
17 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
18 GO
19 ALTER TABLE [dbo].[cache] ADD
20 CONSTRAINT [DF_cache_user_id] DEFAULT ('0') FOR [user_id],
21 CONSTRAINT [DF_cache_cache_key] DEFAULT ('') FOR [cache_key],
22 GO
23 CREATE INDEX [IX_cache_expires] ON [dbo].[cache]([expires]) ON [PRIMARY]
24 GO
25 CREATE INDEX [IX_cache_shared_expires] ON [dbo].[cache_shared]([expires]) ON [PRIMARY]
26 GO
27 ALTER TABLE [dbo].[cache] WITH NOCHECK ADD
28 PRIMARY KEY CLUSTERED (
29 [user_id],[cache_key]
30 ) ON [PRIMARY]
31 GO
32 ALTER TABLE [dbo].[cache_shared] WITH NOCHECK ADD
33 PRIMARY KEY CLUSTERED (
34 [cache_key]
35 ) ON [PRIMARY]
36 GO