Spring Security oauth2 - SQLServer 2014 Table Script

SpringSecurityoauth2SqlServer.sql

USE [DBNAME]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[oauth_refresh_token](
	[token_id] [varchar](256) NULL,
	[token] [varbinary](max) NULL,
	[authentication] [varbinary](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO




---------------------------------------------------------


USE [DBNAME]
GO


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[oauth_code](
	[code] [varchar](256) NULL,
	[authentication] [varbinary](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

---------------------------------------------------------


USE [DBNAME]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[oauth_client_token](
	[token_id] [varchar](256) NULL,
	[token] [varbinary](max) NULL,
	[authentication_id] [varchar](256) NOT NULL,
	[user_name] [varchar](256) NULL,
	[client_id] [varchar](256) NULL,
PRIMARY KEY CLUSTERED 
(
	[authentication_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

---------------------------------------------------------


USE [DBNAME]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[oauth_client_details](
	[client_id] [varchar](256) NOT NULL,
	[resource_ids] [varchar](256) NULL,
	[client_secret] [varchar](256) NULL,
	[scope] [varchar](256) NULL,
	[authorized_grant_types] [varchar](256) NULL,
	[web_server_redirect_uri] [varchar](256) NULL,
	[authorities] [varchar](256) NULL,
	[access_token_validity] [int] NULL,
	[refresh_token_validity] [int] NULL,
	[additional_information] [varchar](4096) NULL,
	[autoapprove] [varchar](256) NULL,
PRIMARY KEY CLUSTERED 
(
	[client_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


---------------------------------------------------------


USE [DBNAME]
GO

/****** Object:  Table [dbo].[oauth_access_token]    Script Date: 19/04/2017 08.41.06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[oauth_access_token](
	[token_id] [varchar](256) NULL,
	[token] [varbinary](max) NULL,
	[authentication_id] [varchar](256) NOT NULL,
	[user_name] [varchar](256) NULL,
	[client_id] [varchar](256) NULL,
	[authentication] [varbinary](max) NULL,
	[refresh_token] [varchar](256) NULL,
PRIMARY KEY CLUSTERED 
(
	[authentication_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


---------------------------------------------------------

Thanks for your sharing, it works for my project.