• Apple
• Store
• Mac
• iPod + iTunes
• iPhone
• Downloads
• Support

EM uses the classpath defined in the project the model you're editing
is in to determine how to call EOF -- Is the model's project setup
against 5.4 or 5.3?

CREATE TABLE GROUPS ("groupID" intNOT NULL, "name" varchar(80)NOT NULL, "parentGroupID" int);

CREATE TABLE PERSONS ("EMAIL" varchar(255), "groupID" int, "NAME" varchar(40)NOT NULL, "notes" varchar(255), "PASSWD" varchar(20)NOT NULL, "PRIMARY_KEY" intNOT NULL, "TYPE" varchar(20)NOT NULL, "USER_ID" varchar(40)NOT NULL);

CREATE TABLE SETTINGS ("ARCHIVE_DATE" dateNOT NULL, "UNIQUE_ID" intNOT NULL);

CREATE TABLE dates ("ARCHIVED" intNOT NULL, "COMMENTARY" varchar(120), "FROM_DATE" datetimeNOT NULL, "FROM_PERIOD" varchar(2), "PERSONS_ID" intNOT NULL, "TO_DATE" datetimeNOT NULL, "TO_PERIOD" varchar(2), "TOTAL_TIME" intNOT NULL, "TYPE" varchar(80)NOT NULL, "UNIQUE_ID" intNOT NULL);

CREATE TABLE YEARLY_DATA ("PERSON_ID" intNOT NULL, "VACATION_CO" intNOT NULL, "VACATION_ENT" intNOT NULL, "YEAR" intNOT NULL);

/* The 'Create Primary Key Support' option is unavailable. */;

ALTER TABLE GROUPS ADD PRIMARY KEY (groupID);

ALTER TABLE PERSONS ADD PRIMARY KEY (PRIMARY_KEY);

ALTER TABLE SETTINGS ADD PRIMARY KEY (UNIQUE_ID);

ALTER TABLE dates ADD PRIMARY KEY (UNIQUE_ID);

ALTER TABLE YEARLY_DATA ADD PRIMARY KEY (PERSON_ID, YEAR);

ALTER TABLE GROUPS ADD CONSTRAINT GROUPS_parentGroup_FK FOREIGN KEY (parentGroupID) REFERENCES GROUPS (groupID);

ALTER TABLE PERSONS ADD CONSTRAINT PERSONS_group_FK FOREIGN KEY (groupID) REFERENCES GROUPS (groupID);

ALTER TABLE dates ADD CONSTRAINT dates_person_FK FOREIGN KEY (PERSONS_ID) REFERENCES PERSONS (PRIMARY_KEY);

ALTER TABLE YEARLY_DATA ADD CONSTRAINT YEARLY_DATA_person_FK FOREIGN KEY (PERSON_ID) REFERENCES PERSONS (PRIMARY_KEY);