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?