-- create extension if not exists "uuid-ossp";

Description: (Describe migration here.)
Created: 2016-10-13 05:36:59.592247 UTC
Depends: 
Apply: |
  create extension if not exists "uuid-ossp";
    
  create table if not exists users (
    id uuid primary key default uuid_generate_v4(),
    handle text not null,
    btc_addr text not null,
    email text not null  
  );
  create table if not exists projects (
    id uuid primary key default uuid_generate_v4(),
    project_name text not null,
    inception_date timestamp with time zone not null,
    initiator_id uuid references users (id) not null
  );

create table users (
  id uuid primary key default uuid_generate_v4(),
  handle text not null,
  btc_addr text not null,
  email text not null  
);

  create table if not exists project_companions (
    project_id uuid references projects(id) not null,
    user_id uuid references users(id) not null
  );

create table projects (
  id uuid primary key default uuid_generate_v4(),
  project_name text not null,
  inception_date timestamp with time zone not null,
  initiator_id uuid references users (id) not null
);

  create type event_t as enum ('start', 'stop');

create table project_companions (
  project_id uuid references projects(id) not null,
  user_id uuid references users(id) not null
);

  create table if not exists work_events (
    id uuid primary key default uuid_generate_v4(),
    project_id uuid references projects(id) not null,
    user_id uuid references users(id) not null,
    btc_addr text not null,
    event_type event_t not null,
    event_time timestamp with time zone not null,
    event_metadata json not null
  );

create type event_t as enum ('start', 'stop');

  create table if not exists auctions (
    id uuid primary key default uuid_generate_v4(),
    project_id uuid references projects(id) not null,
    initiator_id uuid references users (id) not null,
    raise_amount numeric not null,
    end_time timestamp with time zone not null
  );

create table work_events (
  id uuid primary key default uuid_generate_v4(),
  project_id uuid references projects(id) not null,
  user_id uuid references users(id) not null,
  btc_addr text not null,
  event_type event_t not null,
  event_time timestamp with time zone not null,
  event_metadata json not null
);

  create table if not exists bids (
    id uuid primary key default uuid_generate_v4(),
    auction_id uuid references projects (id) not null,
    bidder_id uuid references users (id) not null,
    bid_seconds integer not null,
    bid_amount numeric not null,
    bid_time timestamp with time zone not null
  );

create table auctions (
  id uuid primary key default uuid_generate_v4(),
  project_id uuid references projects(id) not null,
  initiator_id uuid references users (id) not null,
  raise_amount numeric not null,
  end_time timestamp with time zone not null
);

Revert: |
  drop table bids;
  drop table auctions;
  drop table work_events;
  drop table project_companions;
  drop table projects;
  drop table users;

create table bids (
  id uuid primary key default uuid_generate_v4(),
  auction_id uuid references projects (id) not null,
  bidder_id uuid references users (id) not null,
  bid_seconds integer not null,
  bid_amount numeric not null,
  bid_time timestamp with time zone not null
);

alter table projects add depreciation_fn json not null default '{"type": "LinearDepreciation", "arguments": {"undep": 6, "dep": 60}}';

Description: (Describe migration here.)
Created: 2016-10-14 02:11:28.829909 UTC
Depends: 2016-10-13_05-36-55_user-event-log
Apply: |
  alter table projects add depreciation_fn json not null default '{"type": "LinearDepreciation", "arguments": {"undep": 6, "dep": 60}}';
  alter table project_companions add invited_by uuid references users(id);
  update project_companions set invited_by = user_id; --
  alter table project_companions alter column invited_by set not null;

alter table project_companions add invited_by uuid references users(id);
update project_companions set invited_by = user_id; --
alter table project_companions alter column invited_by set not null;

  alter table project_companions 
  add joined_at timestamp with time zone not null 
  default (now() at time zone 'UTC');

alter table project_companions 
add joined_at timestamp with time zone not null 
default (now() at time zone 'UTC');

Revert: |
  alter table projects drop column depreciation_fn;
  alter table project_companions drop column invited_by;
  alter table project_companions drop column joined_at;

create table invitations (
  id uuid primary key default uuid_generate_v4(),
  project_id uuid references projects(id) not null,
  invitor_id uuid references users (id) not null,
  invitee_email text not null,
  invitation_key text not null,
  invitation_time timestamp with time zone not null default (now() at time zone 'UTC'),
  acceptance_time timestamp with time zone
);

Description: (Describe migration here.)
Created: 2016-10-14 02:14:22.631128 UTC
Depends: 2016-10-14_02-11-24_project_companions_invitations 2016-10-13_05-36-55_user-event-log
Apply: |
  create table if not exists invitations (
    id uuid primary key default uuid_generate_v4(),
    project_id uuid references projects(id) not null,
    invitor_id uuid references users (id) not null,
    invitee_email text not null,
    invitation_key text not null,
    invitation_time timestamp with time zone not null default (now() at time zone 'UTC'),
    acceptance_time timestamp with time zone
  );
Revert: |
  drop table invitations;