Personally, I use (disclaimer: my own) DBIx::RunSQL to set up my databases from Perl. This makes it especially convenient for creating throwaway test databases for the regression tests.

As Class::DBI loads most of the information about fields from the database, you'll need to store the field definition somewhere. I find SQL a good Data Definition Language.