class CreateSupportModels

# File test/active_record2/support/models.rb, line 75
def self.down
end

# File test/active_record2/support/models.rb, line 2
def self.up

  create_table :authors do |t|
    t.string :name
  end

  create_table :books do |t|
    t.string :name
    t.string :type
    t.string :note
  end

  create_table :cities do |t|
    t.string :name
    t.string :my_slug
    t.integer :population
    t.index :my_slug, :unique => true
  end

  create_table :countries do |t|
    t.string :name
  end

  create_table :districts do |t|
    t.string :name
    t.string :note
    t.string :cached_slug
    t.index :cached_slug, :unique => true
  end

  create_table :events do |t|
    t.string :name
    t.datetime :event_date
  end

  create_table :houses do |t|
    t.string :name
    t.integer :user_id
  end

  create_table :legacy_table do |t|
    t.string :name
    t.string :note
  end

  create_table :people do |t|
    t.string :name
    t.string :note
  end

  create_table :posts do |t|
    t.string :name
    t.boolean :published
    t.string :note
  end

  create_table :residents do |t|
    t.string :name
    t.integer :country_id
  end

  create_table :users do |t|
    t.string :name
    t.index :name, :unique => true
  end

  create_table :blocks do |t|
    t.string :name
    t.string :note
  end

end