Mercurial > hg > rc2

comparison SQL/mssql/2016112200.sql @ 8:bf99236cc5cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
try to recover from upgrade fail
author Charlie Root
date Sat, 29 Dec 2018 07:07:34 -0500
parents
children
comparison
equal deleted inserted replaced
7:65fd7d441cf1 8:bf99236cc5cd
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