JRuby

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: None
• Fix Version/s: None
• Component/s: None
• Labels:

  None
• Environment:

  activerecord-jdbcsqlite3-adapter (0.9)
  

The migration as created by the scaffold:

class CreateRequests < ActiveRecord::Migration
  def self.up
    create_table :requests do |t|
      t.string :cvsroot
      t.string :start_tag
      t.string :end_tag
      t.string :modules
      t.string :email
      t.date :time_requested
      t.date :time_submitted
      t.date :time_completed
      t.boolean :successful

      t.timestamps
    end
  end

  def self.down
    drop_table :requests
  end
end

Notice that the three time_* columns are INTEGERs

sqlite> .schema
CREATE TABLE requests (id INTEGER PRIMARY KEY AUTOINCREMENT, cvsroot text(0), start_tag text(0), end_tag text(0), modules text(0), email text(0), time_requested INTEGER, time_submitted INTEGER, time_completed INTEGER, successful INTEGER(1), created_at INTEGER, updated_at INTEGER);
CREATE TABLE schema_migrations (version text(0) NOT NULL);
CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations (version);

• Assignee:

  Thomas E Enebo

  Reporter:

  Valerie Maher

• Created:

  20/Dec/08 3:42 PM

  Updated:

  27/Oct/09 1:49 PM

  Resolved:

  20/Dec/08 4:47 PM