Is there any way to use MiddleKit's spreadsheeting feature to designate
a field UNIQUE? I make a the username column UNIQUE in MySQL so that it
will throw an error if someone tries to create a new user account with
a taken username - this is by far the safest way to prevent duplicate
usernames. But I don't know how to get MiddleKit to recognize a column
as requiring a unique value. So I go into the GeneratedSQL/Create.sql
and manually change the username column to UNIQUE. I wish however I
didn't have to do this. Could you automate this option in the next
version of MiddleKit?
|