Re: CREATE TABLE Inv_Id

[Gabriel PREDA]

I would try:

CREATE TABLE Inv_Id (
 ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
 MID INT NOT NULL,
 FOREIGN (MID) REFERENCES 'Model' (ID)
);

Note the UNSIGNED and ZEROFILL flags !

-- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer