Skip to content

Instantly share code, notes, and snippets.

@timdows

timdows/IdentityServer4 MySQL database auto_increment

Created August 11, 2017 16:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timdows/17b411a2f3955002e8dc3cbcc2d464f6 to your computer and use it in GitHub Desktop.
Save timdows/17b411a2f3955002e8dc3cbcc2d464f6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
IdentityServer4 MySQL database auto_increment
ALTER TABLE ApiClaims MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ApiResources MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ApiScopeClaims MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ApiScopes MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ApiSecrets MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientClaims MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientCorsOrigins MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientGrantTypes MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientIdPRestrictions MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientPostLogoutRedirectUris MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientRedirectUris MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE Clients MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientScopes MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE ClientSecrets MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE IdentityClaims MODIFY COLUMN Id int(11) AUTO_INCREMENT;
ALTER TABLE IdentityResources MODIFY COLUMN Id int(11) AUTO_INCREMENT;
--ALTER TABLE PersistedGrants MODIFY COLUMN Id int(11) AUTO_INCREMENT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment