 , 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
-, balance               numeric(35,2)               NOT NULL DEFAULT 0.0
 , goal                  numeric(35,2)               DEFAULT NULL
 , balanced_customer_href  text                      DEFAULT NULL
 , last_ach_result       text                        DEFAULT NULL

  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)
, CONSTRAINT not_negative CHECK ((amount >= (0)::numeric))
 );

CREATE VIEW current_takes AS
