taskcafe/migrations/0041_add-role_code-column-to-project_member-table.up.sql

ALTER TABLE project_member ADD COLUMN role_code TEXT
  NOT NULL REFERENCES role(code) ON DELETE CASCADE DEFAULT 'member';