Something

  create_table "buildings", :force => true do |t|
    t.column "name", :string, :limit => 50
    t.column "code", :string, :limit => 20
  end

  create_table "floors", :force => true do |t|
    t.column "building_id", :integer
    t.column "number", :string, :limit => 10
    t.column "description", :string, :limit => 30
  end

  create_table "closets", :force => true do |t|
    t.column "floor_id", :integer
    t.column "number", :string, :limit => 10
    t.column "description", :string, :limit => 30
  end

  create_table "switches", :force => true do |t|
    t.column "closet_id", :integer
    t.column "model", :string, :limit => 5
    t.column "max_ports", :integer
    t.column "suffix", :integer
    t.column "locked", :boolean, :default => true
    t.column "description", :string, :limit => 30
  end

  create_table "ports", :force => true do |t|
    t.column "switch_id", :integer
    t.column "number", :integer
    t.column "description", :string, :limit => 30
  end