The down script drops the table:

DROP TABLE memberships;

We now need to add a table that stores messages that users have posted to the channels.