Simplify `signups` table install & upgrade routines. See #5563. Props r-a-y. (trunk)

git-svn-id: https://buddypress.svn.wordpress.org/trunk@8310 cdf35c40-ae34-48e0-9cc9-0c9da1808c22