001_BaseSchema.rb for blog post

gistfile1.rb

# migrations/001_BaseSchema.rb

Sequel.migration do
  up do
    create_table(:accounts) do
      primary_key :id
      String      :name,          :size => 50, :null => false
      TrueClass   :enabled,                    :null => false, :default => false
      DateTime    :created_at,                 :null => false
      DateTime    :updated_at,                 :null => false
    end

    create_table(:users) do
      primary_key :id
      String      :username,      :size => 20, :null => false
      String      :password,      :size => 80, :null => false
      String      :email,         :size => 60, :null => true
      String      :firstname,     :size => 20, :null => true
      String      :lastname,      :size => 40, :null => true
      String      :api_token,     :size => 40, :null => false
      String      :confirm_token, :size => 40, :null => false
      TrueClass   :email_is_username,          :null => false, :default => true
      TrueClass   :enabled,                    :null => false, :default => false
      TrueClass   :confirmed,                  :null => false, :default => false
      DateTime    :created_at,                 :null => false
      DateTime    :updated_at,                 :null => false
      DateTime    :confirmed_at,               :null => true
      DateTime    :visited_at,                 :null => true
    end

    create_table(:actions) do
      primary_key :id
      String      :name,          :size => 20, :null => false 
    end

    create_table(:transactions) do
      DateTime    :timestamp,                  :null => false
      foreign_key :account_id, :accounts
      foreign_key :user_id, :users
      foreign_key :action_id, :actions
    end
  end

  down do
    drop_table(:transactions, :actions, :accounts, :users, :cascade => true)
  end
end