2.0.0-beta.293.js 420 B

12345678910111213
  1. exports.up = knex => {
  2. return knex.schema
  3. .createTable('pageLinks', table => {
  4. table.increments('id').primary()
  5. table.integer('sourcePageId').unsigned().references('id').inTable('pages').onDelete('CASCADE')
  6. table.integer('targetPageId').unsigned().references('id').inTable('pages').onDelete('CASCADE')
  7. })
  8. }
  9. exports.down = knex => {
  10. return knex.schema
  11. .dropTableIfExists('pageLinks')
  12. }