[Dbix-class] On the fly schema definition?

[Jim Spath]

My application will have some tables that include the date in the name, 
and only exist for a period of a few days, after which time they will be 
dropped.

eg: unique_user_view_20070327

The tables will be VERY simple in that they will have one primary key 
column called "user_key".

How can I define the schema for these tables on the fly as needed?  I 
obviously don't want to create physical schema files for them.

Secondarily, can I do the table creates and drops using DBIx::Class? 
These would only need to happen once a day.

It seems like I should be able to do all of this with DBIx::Class, but 
so far I have only really used it on a static schema for 
selecting/inserting/updating/deleting, and am a little lost in all the 
documentation.

Thanks!

-- 
Jim Spath
Lead Developer
Pangea Media
Em: jspath at pangeamedia.com
Ph: 617.314.6687
Fx: 617.390.7824
IM: panJimS (AIM)