Feature Request: Database Table Creation – Column Attribute Options

Feature Request
,
1

Dear Team,

I’d like to request an enhancement in the Database Table Creation UI. Currently, when defining columns, there is no direct way to set MySQL column attributes. It would be very useful to have a dropdown or option set for column attributes such as:

  • UNSIGNED

  • UNSIGNED ZEROFILL

  • BINARY

  • AUTO_INCREMENT

  • ON UPDATE CURRENT_TIMESTAMP

  • CHARACTER SET

  • COLLATE

  • STORAGE (e.g., STORAGE DISK, STORAGE MEMORY)

  • VIRTUAL / STORED (for generated columns)

This feature would make schema design more complete within Wappler, avoiding the need to manually adjust attributes later via SQL.

Thank you for considering this improvement.

image
image336×327 10.3 KB

image
image317×424 7.9 KB

2

Some of us manually edit the migration file after creation instead of directly adjusting attributes in the database :wink:

The migration file uses Knex

3

But if there will be an option to directly choose attributes in the UI, it will be far better for newbie users.