Added DDL scripts
diff --git a/employee/employee.model/createDDL.jdbc b/employee/employee.model/createDDL.jdbc
new file mode 100644
index 0000000..7335d41
--- /dev/null
+++ b/employee/employee.model/createDDL.jdbc
@@ -0,0 +1,23 @@
+CREATE TABLE PROJECT (PROJ_ID INTEGER NOT NULL, PROJ_TYPE VARCHAR(31), DESCRIP VARCHAR(255), PROJ_NAME VARCHAR(255), VERSION BIGINT, LEADER_ID INTEGER, PRIMARY KEY (PROJ_ID))
+CREATE TABLE ADDRESS (ADDRESS_ID INTEGER NOT NULL, CITY VARCHAR(255), COUNTRY CLOB(2147483647), P_CODE VARCHAR(255), PROVINCE VARCHAR(255), STREET VARCHAR(255), PRIMARY KEY (ADDRESS_ID))
+CREATE TABLE EMPLOYEE (EMP_ID INTEGER NOT NULL, F_NAME VARCHAR(255), GENDER VARCHAR(255), L_NAME VARCHAR(255), VERSION BIGINT, END_DATE DATE, START_DATE DATE, MANAGER_ID INTEGER, ADDR_ID INTEGER, PRIMARY KEY (EMP_ID))
+CREATE TABLE SALARY (EMP_ID INTEGER NOT NULL, SALARY FLOAT, PRIMARY KEY (EMP_ID))
+CREATE TABLE PHONE (TYPE VARCHAR(255) NOT NULL, AREA_CODE VARCHAR(255), EMP_ID INTEGER NOT NULL, P_NUMBER VARCHAR(255), PRIMARY KEY (TYPE, EMP_ID))
+CREATE TABLE LPROJECT (PROJ_ID INTEGER NOT NULL, BUDGET FLOAT, MILESTONE TIMESTAMP, PRIMARY KEY (PROJ_ID))
+CREATE TABLE RESPONS (Employee_EMP_ID INTEGER, RESPONSIBILITIES VARCHAR(255))
+CREATE TABLE PROJ_EMP (EMP_ID INTEGER NOT NULL, PROJ_ID INTEGER NOT NULL, PRIMARY KEY (EMP_ID, PROJ_ID))
+ALTER TABLE PROJECT ADD CONSTRAINT PROJECT_LEADER_ID FOREIGN KEY (LEADER_ID) REFERENCES EMPLOYEE (EMP_ID)
+ALTER TABLE EMPLOYEE ADD CONSTRAINT EMPLOYEEMANAGER_ID FOREIGN KEY (MANAGER_ID) REFERENCES EMPLOYEE (EMP_ID)
+ALTER TABLE EMPLOYEE ADD CONSTRAINT EMPLOYEE_ADDR_ID FOREIGN KEY (ADDR_ID) REFERENCES ADDRESS (ADDRESS_ID)
+ALTER TABLE SALARY ADD CONSTRAINT FK_SALARY_EMP_ID FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE (EMP_ID)
+ALTER TABLE PHONE ADD CONSTRAINT FK_PHONE_EMP_ID FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE (EMP_ID)
+ALTER TABLE LPROJECT ADD CONSTRAINT LPROJECT_PROJ_ID FOREIGN KEY (PROJ_ID) REFERENCES PROJECT (PROJ_ID)
+ALTER TABLE RESPONS ADD CONSTRAINT RSPONSmployeeEMPID FOREIGN KEY (Employee_EMP_ID) REFERENCES EMPLOYEE (EMP_ID)
+ALTER TABLE PROJ_EMP ADD CONSTRAINT FK_PROJ_EMP_EMP_ID FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE (EMP_ID)
+ALTER TABLE PROJ_EMP ADD CONSTRAINT PROJ_EMP_PROJ_ID FOREIGN KEY (PROJ_ID) REFERENCES PROJECT (PROJ_ID)
+CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(15), PRIMARY KEY (SEQ_NAME))
+CREATE SEQUENCE ADDR_SEQ INCREMENT BY 50 START WITH 50
+INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)
+CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(15), PRIMARY KEY (SEQ_NAME))
+CREATE SEQUENCE ADDR_SEQ INCREMENT BY 50 START WITH 50
+INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)
diff --git a/employee/employee.model/dropDDL.jdbc b/employee/employee.model/dropDDL.jdbc
new file mode 100644
index 0000000..c4e8cbe
--- /dev/null
+++ b/employee/employee.model/dropDDL.jdbc
@@ -0,0 +1,19 @@
+ALTER TABLE PROJECT DROP CONSTRAINT PROJECT_LEADER_ID
+ALTER TABLE EMPLOYEE DROP CONSTRAINT EMPLOYEEMANAGER_ID
+ALTER TABLE EMPLOYEE DROP CONSTRAINT EMPLOYEE_ADDR_ID
+ALTER TABLE SALARY DROP CONSTRAINT FK_SALARY_EMP_ID
+ALTER TABLE PHONE DROP CONSTRAINT FK_PHONE_EMP_ID
+ALTER TABLE LPROJECT DROP CONSTRAINT LPROJECT_PROJ_ID
+ALTER TABLE RESPONS DROP CONSTRAINT RSPONSmployeeEMPID
+ALTER TABLE PROJ_EMP DROP CONSTRAINT FK_PROJ_EMP_EMP_ID
+ALTER TABLE PROJ_EMP DROP CONSTRAINT PROJ_EMP_PROJ_ID
+DROP TABLE PROJECT
+DROP TABLE ADDRESS
+DROP TABLE EMPLOYEE
+DROP TABLE SALARY
+DROP TABLE PHONE
+DROP TABLE LPROJECT
+DROP TABLE RESPONS
+DROP TABLE PROJ_EMP
+DROP SEQUENCE ADDR_SEQ RESTRICT
+DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
diff --git a/employee/employee.model/src/test/java/example/PersistenceTesting.java b/employee/employee.model/src/test/java/example/PersistenceTesting.java
index e2185fe..c0b7730 100644
--- a/employee/employee.model/src/test/java/example/PersistenceTesting.java
+++ b/employee/employee.model/src/test/java/example/PersistenceTesting.java
@@ -49,7 +49,7 @@
if (replaceTables) {
props.put(PersistenceUnitProperties.DDL_GENERATION, PersistenceUnitProperties.DROP_AND_CREATE);
- props.put(PersistenceUnitProperties.DDL_GENERATION_MODE, PersistenceUnitProperties.DDL_DATABASE_GENERATION);
+ props.put(PersistenceUnitProperties.DDL_GENERATION_MODE, PersistenceUnitProperties.DDL_BOTH_GENERATION);
}
return Persistence.createEntityManagerFactory("employee", props);
