Bug #50034 Feature request: FOREIGN KEY and CONSTRAINT comments
Submitted: 3 Jan 2010 9:44 Modified: 3 Jan 2010 10:48
Reporter: Walter Stanish Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any
Tags: comments, constraint, foreign key

[3 Jan 2010 9:44] Walter Stanish
It would be nice to be able to add comments against constraints and foreign keys.

This allows for increased documentation which can assist with the long term maintenance of complex databases.

How to repeat:
-- fails
ALTER TABLE sometable ADD CONSTRAINT unique(col1,col2,col3) COMMENT 'This will be extended in future ... some explanation ...';

Suggested fix:
Add constraint and foreign key COMMENT support, as per columns.
[3 Jan 2010 10:48] Valeriy Kravchuk
Thank you for the feature request.