search

dylanpiera / CodenameIndigo

A project with unknown intentions. At least for now.
1 stars 1 forks source link

Possible issue with long names #7

Closed jdsaphir closed 6 years ago

jdsaphir commented 6 years ago

The DiscordUsername field is set as a VARCHAR(30), but Discord allows usernames up to 32 characters long. That may be an issue if a user tries to register with a (very) long name.

jdsaphir commented 6 years ago

Changed the type for the DiscordUsername field to VARCHAR(37), which leaves 32 characters for the username, 1 for the # sign and 4 for the discriminator.

Also changed the type for ShowdownUsername: it is now VARCHAR(18) since Showdown doesn't allow for longer names. The length of the user's input for this field should be checked on registration (#8).