[ic] autonumber with mySQL

[Jon Jensen]

On Wed, 14 Jan 2004, Stefan Hornburg wrote:

> > Database  correspondence  COLUMN_DEF  "code=INT(5) UNSIGNED AUTO_INCREMENT
> > PRIMARY_KEY"
> 
> Do I have another shot in the dark <g> ? I think you missing NOT NULL for
> the code column. 

PRIMARY KEY implies NOT NULL. But I notice he wrote PRIMARY_KEY with an 
underscore, which is invalid SQL IIRC.

> > I've got about 7 fields.  I let the rest use the default 128 setting.
>
> Where did you specify that default setting?

That's an Interchange built-in default: CHAR(128) unless otherwise
specified.

Just jumping into the fray.

Jon