Okay. This is probably me being exceptionally stupid but with
MySQL 5.0.22 (I know...) with this schema:
DROP TABLE IF EXISTS vendors;
CREATE TABLE vendors (
idSERIAL NOT NULL PRIMARY KEY,
name VARCHAR(255) NOT NULL,
UNIQUE(name)
) TYPE =
On 3/28/07, Adrian Howard [EMAIL PROTECTED] wrote:
CREATE TABLE products (
id SERIAL NOT NULL PRIMARY KEY,
nameVARCHAR(255) NOT NULL,
vendor_id INT REFERENCES vendors (id),
UNIQUE(name)
) TYPE = InnoDB;
While it will happily accept
John Siracusa scribbled on 3/28/07 9:12 AM:
On 3/28/07, Adrian Howard [EMAIL PROTECTED] wrote:
CREATE TABLE products (
id SERIAL NOT NULL PRIMARY KEY,
nameVARCHAR(255) NOT NULL,
vendor_id INT REFERENCES vendors (id),
UNIQUE(name)
)
On 28 Mar 2007, at 15:12, John Siracusa wrote:
On 3/28/07, Adrian Howard [EMAIL PROTECTED] wrote:
CREATE TABLE products (
id SERIAL NOT NULL PRIMARY KEY,
nameVARCHAR(255) NOT NULL,
vendor_id INT REFERENCES vendors (id),
UNIQUE(name)