Option for exporting migrations including StoredAs parameter on columns

[KirePetrov]

Hi,

Is there any option for exporting migrations including StoredAs parameter on columns?

Now i receive it like normal columns...

Thanks.

[bennett-treptow]

Could you give an example of a column with a storedAs parameter and it's accompanying MySQL syntax?

e.g. if you have a migration currently that uses one and then also your table's structure using SHOW CREATE TABLE tablename?

[KirePetrov]

Check out version 3.2.0 and let me know if that works for you! @KirePetrov

@bennett-treptow
seems like, there is some quote escaping problem.

can you try with this column example?

`full_name` varchar(150) COLLATE utf8mb4_unicode_ci GENERATED ALWAYS AS (concat(`first_name`,' ',`last_name`)) STORED,

i've got this

correct one is
$table->string('full_name', 150)->storedAs("CONCAT(first_name,' ',last_name)");

[bennett-treptow]

Alright give 3.2.1 a try! @KirePetrov

[KirePetrov]

Alright give 3.2.1 a try! @KirePetrov

this causes php error, coz outside and inside quotes should be different. (single/double)

in migration got this

which can't be processed

[bennett-treptow]

Ah didn't even think of that. Alright, 3.2.2 should be the final say here @KirePetrov

[KirePetrov]

Ah didn't even think of that. Alright, 3.2.2 should be the final say here @KirePetrov

thanks, all good now.