   ON transfers
   USING btree
   (tipper, tippee, timestamp DESC);
-
-
-CREATE TABLE emails
-( id            serial                          PRIMARY KEY
-, email         email_address_with_confirmation NOT NULL
-, ctime         timestamp with time zone        NOT NULL
-                                                DEFAULT CURRENT_TIMESTAMP
-, participant   text                            NOT NULL
-                                                REFERENCES participants
-                                                ON UPDATE CASCADE
-                                                ON DELETE RESTRICT
- );

                                                ON UPDATE CASCADE
                                                ON DELETE RESTRICT
, CONSTRAINT no_team_recursion CHECK (team != member)
 );

CREATE VIEW current_takes AS

, ctime                 timestamp with time zone    NOT NULL DEFAULT CURRENT_TIMESTAMP
, claimed_time          timestamp with time zone    DEFAULT NULL
, is_admin              boolean                     NOT NULL DEFAULT FALSE
, balance               numeric(35,2)               NOT NULL DEFAULT 0.0
, anonymous_giving      boolean                     NOT NULL DEFAULT FALSE
, goal                  numeric(35,2)               DEFAULT NULL
, balanced_customer_href  text                      DEFAULT NULL
, last_ach_result       text                        DEFAULT NULL
