commit | author | age
|
50abd5
|
1 |
CREATE TABLE [dbo].[cache_shared] (
|
AM |
2 |
[cache_key] [varchar] (255) COLLATE Latin1_General_CI_AI NOT NULL ,
|
|
3 |
[created] [datetime] NOT NULL ,
|
|
4 |
[data] [text] COLLATE Latin1_General_CI_AI NOT NULL
|
|
5 |
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|
6 |
GO
|
|
7 |
|
|
8 |
ALTER TABLE [dbo].[cache_shared] ADD
|
|
9 |
CONSTRAINT [DF_cache_shared_created] DEFAULT (getdate()) FOR [created]
|
|
10 |
GO
|
|
11 |
|
|
12 |
CREATE INDEX [IX_cache_shared_cache_key] ON [dbo].[cache_shared]([cache_key]) ON [PRIMARY]
|
|
13 |
GO
|
|
14 |
|
|
15 |
CREATE INDEX [IX_cache_shared_created] ON [dbo].[cache_shared]([created]) ON [PRIMARY]
|
|
16 |
GO
|
|
17 |
|