Syntax migration - knex

Created by: woanversace

Below is my code for create a table

  up () {
    this.dropIfExists('skills_projects')
    this.create('skills_projects', (table) => {
        table.increments('id').first()
table.integer('id_project').references('id').inTable('projects').onUpdate('CURRENT_TIMESTAMP').onDelete('CASCADE')
        table.integer('id_skill').references('id').inTable('skills').onUpdate('CURRENT_TIMESTAMP').onDelete('CASCADE')
    })
  }

error:

alter table "skills_projects" add constraint skills_projects_id_project_foreign foreign key ("id_project") references "projects" ("id") on update CURRENT_TIMESTAMP on delete CASCADE - syntax error at or near "CURRENT_TIMESTAMP"

So what is correct way to do it?

Assignee Loading
Time tracking Loading