simonw / datasette-edit-schema

Datasette plugin for modifying table schemas
Apache License 2.0
16 stars 0 forks source link

Ability to set a default value for a column #48

Open simonw opened 8 months ago

simonw commented 8 months ago

In particular I want to be able to do this:

alter table notes add column created text default (strftime('%Y-%m-%d %H:%M:%fZ'));

This would be useful for creating tables in Datasette that track their own created times.