Add support for marking columns unique when creating database tables

[LukeTowers]

Would be nice to add a checkbox to indicate that a given column should have a unique index added to it when building the table schema

[WebVPF]

unique and index

$table->unique('email');
$table->index('state');

[IsaiahPaget]

@LukeTowers I am thinking of tackling this last one hopefully before the deadline for the challenge, but even if I can't finish it by the end of today, I'll finish it anyways.

What are the requirements for this? I was able to create a migration and use the unique() method on it and run the migration. Given this is labelled as fullstack I get the sense there might be something in the backend I am not aware of?

        Schema::create('subscriptions', function (Blueprint $table) {
            // ...
            $table->string('stripe_id')->collation('utf8_bin')->unique();
            // ...
        });

[LukeTowers]

Did you add the checkbox to the UI in the backend for building the table?

[IsaiahPaget]

Did you add the checkbox to the UI in the backend for building the table?

That is essentially my question, where should this checkbox be, from the original comment on this issue it sound like there is a schema manager in the backend?

I guess I am basically asking if you could give me a user story effectively lol

EDIT:
I now see that this issue is on the wn-builder-plugin, I was poring over the code in winter and just could not figure out what was going on lol, whoops ok let me look into this further.

[IsaiahPaget]

@LukeTowers When I make this pr, should I use google translate for the lang translations, or is it best that I just leave that to people who speak those languages?

[LukeTowers]

@IsaiahPaget our general approach is to only provide translations that you're comfortable with, other people will eventually provide translations for new keys when they come across them.