Datamapper DataMapper

If using migrations w/ SQLite3 the Serial data type doesn't create an auto-incrementing column.

Here's my code:

require 'rubygems'
require 'dm-core'
require 'dm-migrations'
require 'migration_runner'

include DataMapper::Types

DataMapper.logger = DataMapper::Logger.new(STDOUT, :debug)
DataMapper.setup(:default, "sqlite3:///foo.db")

class User
  include DataMapper::Resource
  
  property :id, Serial
end

# User.auto_migrate!

migration 1, :create_user do
  
  up do
    create_table :users do
      column :id, Serial
    end
  end
  
end

migrate_up!

It generates the following output:

Mon, 04 Aug 2008 17:53:32 GMT ~ debug ~ PRAGMA table_info('migration_info')
 == Performing Up Migration #1: create_user
   CREATE TABLE "users" ("id" INTEGER NOT NULL DEFAULT NULL)
Mon, 04 Aug 2008 17:53:32 GMT ~ debug ~ CREATE TABLE "users" ("id" INTEGER NOT NULL DEFAULT NULL)
   -> 0.0018s
 -> 0.0021s
Mon, 04 Aug 2008 17:53:32 GMT ~ debug ~ PRAGMA table_info('migration_info')
Mon, 04 Aug 2008 17:53:32 GMT ~ debug ~ CREATE TABLE "migration_info" ("migration_name" VARCHAR(255) UNIQUE)
Mon, 04 Aug 2008 17:53:32 GMT ~ debug ~ INSERT INTO "migration_info" ("migration_name") VALUES ('create_user')

If I were to run this using auto_migrate! I get the following:

Mon, 04 Aug 2008 17:56:28 GMT ~ debug ~ CREATE TABLE "users" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT)

Which is correct.