message 'default' causes create table error

When installing, support_nag gave me an error message because "text" columns (used for the message field) cannot have default values:
http://dev.mysql.com/doc/refman/5.0/en/blob.html

I took the install schema and wrote it into sql and manually created the table, removing the "default" statement for the message field.

create table support_nags (
    nagid serial not null,
    action int unsigned  not null  default  '0',
    clients varchar (255) not null default '',        
    states  varchar (255) not null default '',
    priorities varchar (255) not null default '',
    assigned  varchar (255) not null default '',
    mailto  varchar (255) not null  default '',
    subject  varchar (128) not null default '',
    message  text not null,
    frequency  int unsigned not null  default '0',
    last int unsigned not null default  '0',
    count int unsigned not null default  '0',
    primary key  (nagid),
  );

I also had a problem with the nagid field. I could not create the table with "unsigned" included in the create statement. I don't know why. I removed "unsigned" and the table was created. I know that "SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE."
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

I hope you find any of this helpful. If I have missed something (which is perfectly possible..heck, it's likely!), I'd be happy to learn.

mrweaver