the following way we can generate schema's
automatically.here i used MySql membership provider
-
<membership defaultProvider="MySQLMembershipProvider">
<providers>
<clear />
<add connectionStringName="LocalMySqlServer"
applicationName="/" requiresUniqueEmail="false"
passwordFormat="Clear" maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="7" name="MySQLMembershipProvider"
autogenerateschema="true"
type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web,
Version=6.2.4.0, Culture=neutral,
PublicKeyToken=c5687fc88969c44d" />
</providers>
</membership>

autogenerateschema="true" enables generating tables
automatically.