Re: Duplicate values being created

[Robert Summerfield]

the tables (relevant rows) are created as follows:

postId INT UNSIGNED not null auto_increment
PRIMARY KEY (postId)

imgId INT UNSIGNED not null auto_increment
postId INT UNSIGNED null
displayOrder SMALLINT not null
PRIMARY KEY (imgId)
INDEX (postId)
FOREIGN KEY (postId)
REFERENCES posts(postId)
ON DELETE CASCADE
ON UPDATE CASCADE

Anything look out of place? Would this structure not prevent concurrency?