Pretty cool those guys are, thinking ahead and all. I just noticed that my CS 1.0 database has all (or near all, not sure) the tables and stored procedures that get installed for ASP.NET 2.0 membership, profiles, role management and personalization.
To get it in your database, assuming you have the 2.0 framework installed is to run:
That will kick off a SQL Setup wizard to give you what you need.
I am not sure, but was Beta 1 even out yet when CS came out? Those ex-softies get all the goods early!