Rails does not recognize sqlite3 REAL datatype

Question

I have created the following table in sqlite3:

CREATE TABLE Test ( Id TEXT PRIMARY KEY NOT NULL, Count REAL );

But when I try to generate a model for this table, the schema.rb gives the following error:

Could not dump table "Test" because of following StandardError: Unknown type 'REAL' for column 'Count'

Is there another datatype I can use instead of real that will work with rails?

Answer 1

Have you tried using Rails' inbuilt migrations to build your table?

Answer 2

Yes, use rake db:migrate

Also, for a count field, simply use an integer datatype instead of a float or REAL.