データベース定義

ログを兼ねてdb/schema.rb を掲載しておきます。

ActiveRecord::Schema.define(:version => 1) do

  create_table "items", :force => true do |t|
    t.column "title", :binary, :null => false
    t.column "created_on", :datetime
    t.column "update_at", :datetime
    t.column "text", :binary
    t.column "label_color", :text, :limit => 6
    t.column "font_size", :text, :limit => 16
    t.column "text_decoration", :text, :limit => 16
    t.column "font_style", :text, :limit => 16
    t.column "user_id", :text, :limit => 45
    t.column "tag_list", :text
    t.column "entry_year", :text, :limit => 4
    t.column "entry_month", :text, :limit => 2
    t.column "entry_day", :text, :limit => 2
  end

  create_table "users", :force => true do |t|
    t.column "hashed_email", :string, :limit => 45, :default => "", :null => false
    t.column "hashed_passwd", :string, :limit => 45, :default => "", :null => false
    t.column "created_at", :datetime
    t.column "update_at", :datetime
    t.column "lastlogin_at", :datetime
    t.column "name", :string
    t.column "status", :boolean
    t.column "transaction_id", :string, :limit => 45
  end

  add_index "users", ["hashed_email"], :name => "users_hashed_email_index", :unique => true

end