DROP TYPE IF EXISTS freedom_rep_spec_description_type;
CREATE TYPE freedom_rep_spec_description_type AS enum
(
  'SponsorFee', 'LeaderFee'
);
ALTER TYPE freedom_rep_spec_description_type owner TO sunrise;


DROP TABLE IF EXISTS freedom_rep_spec_descriptions;
CREATE TABLE freedom_rep_spec_descriptions
(
  report_id INTEGER NOT NULL REFERENCES freedom_rep(id),
  recever_id INTEGER NOT NULL REFERENCES accounts(id),
  account_id INTEGER NOT NULL REFERENCES accounts(id),
  amount BIGINT NOT NULL,
  TYPE freedom_rep_spec_description_type NOT NULL
);
ALTER TABLE freedom_rep_spec_descriptions owner TO sunrise;
GRANT ALL ON TABLE freedom_rep_spec_descriptions TO sunrise;
GRANT ALL ON TABLE freedom_rep_spec_descriptions TO sunrise_admin;
GRANT SELECT, INSERT ON TABLE freedom_rep_spec_descriptions TO wui;