 , name                  text                        NOT NULL
 , homepage              text                        NOT NULL
 , product_or_service    text                        NOT NULL
-, getting_involved      text                        NOT NULL
-, getting_paid          text                        NOT NULL
+, getting_involved      text
+, getting_paid          text
 , owner                 text                        NOT NULL REFERENCES participants
                                                         ON UPDATE CASCADE ON DELETE RESTRICT
 , is_closed             boolean                     NOT NULL DEFAULT FALSE

-- https://github.com/gratipay/gratipay.com/pull/4033

ALTER TABLE participants ADD COLUMN has_verified_identity bool NOT NULL DEFAULT false;

-- https://github.com/gratipay/gratipay.com/pull/4072

BEGIN;
    ALTER TABLE teams ADD COLUMN available numeric(35,2) NOT NULL DEFAULT 0;
    ALTER TABLE teams ADD CONSTRAINT available_not_negative CHECK ((available >= (0)::numeric));
END;


-- https://github.com/gratipay/gratipay.com/pull/4074


, nreceiving_from       integer                     NOT NULL DEFAULT 0
, distributing          numeric(35,2)               NOT NULL DEFAULT 0
, ndistributing_to      integer                     NOT NULL DEFAULT 0
, revenue_model         text                        DEFAULT ''
, onboarding_url        text                        NOT NULL DEFAULT ''
, review_url            text                        DEFAULT NULL
, image_oid_original    oid                         NOT NULL DEFAULT 0
, image_oid_large       oid                         NOT NULL DEFAULT 0
, image_oid_small       oid                         NOT NULL DEFAULT 0
, image_type            supported_image_types
, available             numeric(35,2)               NOT NULL DEFAULT 0
, CONSTRAINT            available_not_negative CHECK ((available >= (0)::numeric))
 );


