• CREATE TABLE [dbo].[cache](

    [token] [char](36) NULL,

    [type] [varchar](50) NOT NULL,

    [value] [nvarchar](max) NOT NULL,

    [cacheTime] [datetime] NULL

    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    CREATE NONCLUSTERED INDEX [IND_cache_token_type] ON [dbo].[cache]

    (

    [token] ASC,

    [type] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    GO