:date is stored as integer (not date) in sqlite3
------------------------------------------------
Key: JRUBY-3260
URL: http://jira.codehaus.org/browse/JRUBY-3260
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Environment: activerecord-jdbcsqlite3-adapter (0.9)
Reporter: Valerie
The migration as created by the scaffold:
{noformat}
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
{noformat}
Notice that the three time_* columns are INTEGERs
{noformat}
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);
{noformat}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
