Guest User

Untitled

a guest
Apr 19th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. createTable(`payments`, function(t){
  2. t.increments();
  3. t.integer('userId').references('id').inTable(`users`).unsigned().onDelete('cascade');
  4. t.integer('recordId')
  5. .references('id').inTable(`tickets`).unsigned().onDelete('cascade');
  6. t.integer('recordId')
  7. .references('id').inTable(`packages`).unsigned().onDelete('cascade');
  8. t.string('peyFro');
  9. t.string('gateway').notNullable();
  10. t.string('authority').notNullable();
  11. t.integer('amount').notNullable();
  12. t.string('status').notNullable();
  13. t.dateTime('createdAt').defaultTo(knex.fn.now());
  14. })
Add Comment
Please, Sign In to add comment