create table hipchat_scopes (
  key text primary key not null,
  created_at timestamptz not null default now()
);

insert into hipchat_scopes (key) values ('send_message');
insert into hipchat_scopes (key) values ('send_notification');