dev
Last change
on this file since ad058b3 was ad058b3, checked in by Стојков Марко <mst@…>, 3 years ago |
Hangfire is supported
|
-
Property mode
set to
100644
|
File size:
418 bytes
|
Line | |
---|
1 | CREATE TABLE [HangFire].[List] (
|
---|
2 | [Id] BIGINT IDENTITY (1, 1) NOT NULL,
|
---|
3 | [Key] NVARCHAR (100) NOT NULL,
|
---|
4 | [Value] NVARCHAR (MAX) NULL,
|
---|
5 | [ExpireAt] DATETIME NULL,
|
---|
6 | CONSTRAINT [PK_HangFire_List] PRIMARY KEY CLUSTERED ([Key] ASC, [Id] ASC)
|
---|
7 | );
|
---|
8 |
|
---|
9 |
|
---|
10 | GO
|
---|
11 | CREATE NONCLUSTERED INDEX [IX_HangFire_List_ExpireAt]
|
---|
12 | ON [HangFire].[List]([ExpireAt] ASC) WHERE ([ExpireAt] IS NOT NULL);
|
---|
13 |
|
---|
Note:
See
TracBrowser
for help on using the repository browser.