Pie/001_init.js at main · DMon9/Pie · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

exports.up = async function(knex) {
  await knex.schema.createTable('users', (t) => {
    t.increments('id').primary();
    t.string('google_id').unique();
    t.string('email').unique();
    t.string('name');
    t.string('picture');
    t.string('role').defaultTo('user');
    t.integer('balance').defaultTo(0); // dollars
    t.timestamps(true, true);
  });

  await knex.schema.createTable('matches', (t) => {
    t.increments('id').primary();
    t.string('home_team').notNullable();
    t.string('away_team').notNullable();
    t.timestamp('start_time').notNullable();
    t.string('status').defaultTo('scheduled'); // scheduled|live|finished
    t.integer('home_score');
    t.integer('away_score');
    t.timestamps(true, true);
  });

  await knex.schema.createTable('odds', (t) => {
    t.increments('id').primary();
    t.integer('match_id').references('id').inTable('matches').onDelete('CASCADE');
    t.string('market').defaultTo('moneyline');
    t.integer('odds_home').notNullable(); // american odds (e.g., -120, +140)
    t.integer('odds_away').notNullable();
    t.timestamp('updated_at').defaultTo(knex.fn.now());
  });

  await knex.schema.createTable('bets', (t) => {
    t.increments('id').primary();
    t.integer('user_id').references('id').inTable('users').onDelete('CASCADE');
    t.integer('match_id').references('id').inTable('matches').onDelete('CASCADE');
    t.integer('wager').notNullable(); // dollars
    t.string('selection').notNullable(); // home|away
    t.integer('odds_at_bet').notNullable(); // american odds snapshot
    t.string('status').defaultTo('pending'); // pending|won|lost|void
    t.timestamp('created_at').defaultTo(knex.fn.now());
  });

  await knex.schema.createTable('transactions', (t) => {
    t.increments('id').primary();
    t.integer('user_id').references('id').inTable('users').onDelete('CASCADE');
    t.string('type').notNullable(); // deposit|bet|payout
    t.integer('amount').notNullable(); // dollars (+ or -)
    t.timestamp('created_at').defaultTo(knex.fn.now());
  });
};

exports.down = async function(knex) {
  await knex.schema.dropTableIfExists('transactions');
  await knex.schema.dropTableIfExists('bets');
  await knex.schema.dropTableIfExists('odds');
  await knex.schema.dropTableIfExists('matches');
  await knex.schema.dropTableIfExists('users');
};