[
http://jira.jboss.com/jira/browse/JBIDE-1431?page=comments#action_12390565 ]
Jim Tyrrell commented on JBIDE-1431:
------------------------------------
This is the create script for the database.
CREATE TABLE Role (
RoleID int(10) unsigned NOT NULL auto_increment,
RoleName varchar(64) NOT NULL,
PRIMARY KEY (RoleID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE User (
UserID int(10) unsigned NOT NULL auto_increment,
UserName varchar(64) NOT NULL,
Password varchar(64) NOT NULL,
RoleID int(10) unsigned NOT NULL,
index(RoleID),
FOREIGN KEY (RoleID) REFERENCES Role(RoleID),
PRIMARY KEY (UserID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE Post (
PostID int(10) unsigned NOT NULL auto_increment,
UserID int(10) unsigned NOT NULL,
PostDate Date NOT NULL,
PostTitle varchar(256) NOT NULL,
PostBody Text NOT NULL,
PRIMARY KEY (PostID),
Index(UserID),
FOREIGN KEY (UserID) REFERENCES User(UserID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE Comment (
CommentID int(10) NOT NULL auto_increment,
PostID int(10) unsigned NOT NULL,
UserID int(10) unsigned NOT NULL,
CommentDate Date NOT NULL,
CommentTitle varchar(256) NOT NULL,
CommentBody Text NOT NULL,
PRIMARY KEY (CommentID),
Index(PostID, UserID),
FOREIGN KEY (PostID) REFERENCES Post(PostID),
FOREIGN KEY (UserID) REFERENCES User(UserID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Generate Entities of non Empty Tables creates weird UIs
-------------------------------------------------------
Key: JBIDE-1431
URL:
http://jira.jboss.com/jira/browse/JBIDE-1431
Project: JBoss Tools
Issue Type: Bug
Reporter: Jim Tyrrell
Attachments: ScreenShotBloggingOdd.png
When running reverse engineering of tables that have existing data odd UI components are
created as show in the attached screen shot. Extra tabs are created when trying to create
new records.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira