FOREIGN KEY (genre_id) REFERENCES genres(genre_id)
) type=InnoDB;
CREATE UNIQUE INDEX album_tracks ON tracks(album_id, track);
CREATE INDEX by_title ON tracks(title);
--
Andy Dustman PGP: 0x930B8AB6
@ .net http://dustman.net/andy
"Cogito, ergo sum." --
y can be compared without a type conversion."
> My understanding is that NOT NULL is only a column constraint and
> doesn't affect the data type.
>
> However... Even when I set the referring column to be SMALLINT NOT NULL,
> and create a new database, I still get the same
