spartak

2006-12-09

Re: Rails4Days(ChineseVersion)

关键字: rails,sql,activerecord

spartak 写道

pdf中第三天内容缺少一段sql
从英文版帖一个过来

CREATE TABLE items (
id smallint(5) unsigned NOT NULL auto_increment,
done tinyint(1) unsigned NOT NULL default '0',
priority tinyint(1) unsigned NOT NULL default '3',
description varchar(40) NOT NULL default '',
due_date date default NULL,
category_id smallint(5) unsigned NOT NULL default '0',
note_id smallint(5) unsigned default NULL,
private tinyint(3) unsigned NOT NULL default '0',
created_on timestamp(14) NOT NULL,
updated_on timestamp(14) NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM COMMENT='List of items to be done';

自己做了一遍，发现有点问题，rails会把mysql里的 tinyint(1)映射成boolean，我看了作者主页上的代码也是如此.

我把上面sql里priority和private的定义应改为

priority tinyint(3) unsigned NOT NULL default '3',
private tinyint(1) unsigned NOT NULL default '0',

就ok了。也许是版本问题？我用的rails 1.1.6,mysql4.0