• Home
• io.gravitee.am.identityprovider
• gravitee-am-identityprovider-jdbc
• 4.6.0-alpha.2
• source code
• sqlserver.schema

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

database.sqlserver.schema Maven / Gradle / Ivy

--
-- Script to create SQL Server schema
-- Table & index names are suffixed by 3 underscores to define a
-- pattern to replace with the domain name
--
IF NOT EXISTS( SELECT 1 FROM sysobjects WHERE name = 'idp_users___' AND xtype = 'U' ) CREATE TABLE idp_users___ (id NVARCHAR(64) NOT NULL, username NVARCHAR(320) NOT NULL UNIQUE, password NVARCHAR(255) NULL, email NVARCHAR(320) NULL, metadata NVARCHAR(MAX) NULL, PRIMARY KEY (id), INDEX idp_users____username_idx NONCLUSTERED (username))