Skip to content

Column alter/modify with CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP not working #14880

Closed
@maurobpt

Description

I was trying to generate a migrations with timestamp columns and one of my columns cannot execute the migration for column updated_at

new Column(
                        'created_at',
                        [
                            'type' => Column::TYPE_TIMESTAMP,
                            'default' => "CURRENT_TIMESTAMP",
                            'notNull' => true,
                            'after' => 'deleted_user_id'
                        ]
                    ),
                    new Column(
                        'updated_at',
                        [
                            'type' => Column::TYPE_TIMESTAMP,
                            'default' => "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP",
                            'notNull' => false,
                            'after' => 'created_at'
                        ]
                    ),
                    new Column(
                        'deleted_at',
                        [
                            'type' => Column::TYPE_TIMESTAMP,
                            'notNull' => false,
                            'after' => 'updated_at'
                        ]
                    )

Metadata

Assignees

Labels

Type

No type

Projects

  • Status

    Released

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions