Molto Mike -
Thanks for your response. I'm using MySQL 4.1.7 and EA Build 744.
Here is a sample .sql file generated by EA.
-- -------------------------------------------
-- Generated by Enterprise Architect Ver. 4.01
-- Created On : Monday, 13 December, 2004
-- DBMS : MySql
-- -------------------------------------------
CREATE TABLE Areas11
(
RecID INTEGER NOT NULL COMMENT 'Record ID generated by system.',
AreaID CHAR(5) NOT NULL,
Desc VARCHAR(50) NOT NULL COMMENT 'Descriptio of Area.',
Nickname CHAR(15) NOT NULL,
SortField CHAR(15) NOT NULL,
GpsData TEXT,
AreaManagerID CHAR(6),
AreaOfficeLocClRecID INTEGER,
Comments78RecID INTEGER COMMENT 'Comments for all Tables are stored in Comments78. Comments can be up to 500 characters long and are stored as 2 250 variable character fields (Comment, Comment2).',
PRIMARY KEY (AreaID),
UNIQUE (RecID),
KEY (Comments78RecID)
) Type=InnoDB COMMENT='Master Table of defined Areas to be used by Client.'
;
It is very clear in the MySQL documentation that comments can only be structured in one of three ways. The above is not one of them. Appreciate any help.