Revision: 3234
Author: silva.josemanuel1
Date: Tue Jan 19 10:45:11 2010
Log: FIXED - bug 2323: Issue with COMMENT DDL for MySQL
http://trillian.sqlpower.ca/bugzilla/show_bug.cgi?id=2323
http://code.google.com/p/power-architect/source/detail?r=3234
Modified:
/trunk/src/ca/sqlpower/architect/ddl/MySqlDDLGenerator.java
=======================================
--- /trunk/src/ca/sqlpower/architect/ddl/MySqlDDLGenerator.java Tue Jan 19
09:27:32 2010
+++ /trunk/src/ca/sqlpower/architect/ddl/MySqlDDLGenerator.java Tue Jan 19
10:45:11 2010
@@ -507,6 +507,22 @@
addColumnComments(t);
}
}
+
+ @Override
+ public void addComment(SQLColumn c) {
+ if (c.getRemarks() != null && c.getRemarks().trim().length() > 0) {
+ print("\nALTER TABLE ");
+ print(toQualifiedName(c.getParent()));
+ print(" MODIFY COLUMN ");
+ print(c.getPhysicalName());
+ print(" ");
+ print(c.getTypeName());
+ print(" COMMENT '");
+ print(c.getRemarks().replaceAll("'", "''"));
+ print("'");
+ endStatement(DDLStatement.StatementType.ALTER, c);
+ }
+ }
@Override
public void addColumn(SQLColumn c) {
