bval

Employee:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    sf_guard_user_id:
      type: integer
    start_date:
      type: date

bval

sfGuardUser:
  sgu_admin:
    username:       admin
    password:       Client2009
    is_super_admin: true
  cwage:
    username: cwage
    password: changeme
    first_name: Chris
    last_name: Wage

bval

mysql> describe shipped_order;
+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| id                  | int(11)      | NO   | PRI | NULL    | auto_increment |
| ship_to_address     | varchar(255) | YES  |     | NULL    |                |
| total_weight        | bigint(20)   | YES  |     | NULL    |                |
| ups_tracking_number | bigint(20)   | YES  |     | NULL    |                |
| real_shipping_costs | varchar(10)  | YES  |     | NULL    |                |
| processing_date     | date         | YES  |     | NULL    |                |

bval

site = "www.website.com"
months = ["www.website.com/awstats042009.www.website.com.txt", "www.website.com/awstats052009.www.website.com.txt"]
# below works better
months.map! { |m| m[/#{site}\/awstats([0-9]{6})\.#{site}\.txt/,1] }
puts months