Last commit for halo-eclipse-EAR_halo-se-EJB_halo_persist_dropDDL.jdbc: 3de7bf120e205e4e87d48368a921e8dceccbb123

commented out user restriction until it's fixed

Miriam Melnick [2011-09-19 18:32:42]
commented out user restriction until it's fixed
  1. ALTER TABLE studentAsisgnment DROP FOREIGN KEY FK_studentAsisgnment_COURSE_ID
  2. ALTER TABLE ACHIEVEMENT DROP FOREIGN KEY FK_ACHIEVEMENT_RESULTTITLE_ID
  3. ALTER TABLE ACHIEVEMENTRECORD DROP FOREIGN KEY FK_ACHIEVEMENTRECORD_USER_ID
  4. ALTER TABLE ACHIEVEMENTRECORD DROP FOREIGN KEY FK_ACHIEVEMENTRECORD_ACHIEVEMENT_ID
  5. ALTER TABLE CAUSUALRELATION DROP FOREIGN KEY FK_CAUSUALRELATION_ACHIEVEMENTCAUSE_ID
  6. ALTER TABLE CAUSUALRELATION DROP FOREIGN KEY FK_CAUSUALRELATION_TASKRESULT_ID
  7. ALTER TABLE CAUSUALRELATION DROP FOREIGN KEY FK_CAUSUALRELATION_TASKCAUSE_ID
  8. ALTER TABLE CAUSUALRELATION DROP FOREIGN KEY FK_CAUSUALRELATION_ACHIEVEMENTRESULT_ID
  9. ALTER TABLE QUEST DROP FOREIGN KEY FK_QUEST_ASSIGNMENT_ID
  10. ALTER TABLE QUEST DROP FOREIGN KEY FK_QUEST_PARENT_ID
  11. ALTER TABLE TITLE DROP FOREIGN KEY FK_TITLE_COMESFROM_ID
  12. ALTER TABLE LOGENTRY DROP FOREIGN KEY FK_LOGENTRY_CREATEDBY_ID
  13. ALTER TABLE LOGENTRY DROP FOREIGN KEY FK_LOGENTRY_ACTION_ID
  14. ALTER TABLE QUESTPROGRESS DROP FOREIGN KEY FK_QUESTPROGRESS_TASK_ID
  15. ALTER TABLE QUESTPROGRESS DROP FOREIGN KEY FK_QUESTPROGRESS_QUEST_ID
  16. ALTER TABLE QUESTPROGRESS DROP FOREIGN KEY FK_QUESTPROGRESS_USER_ID
  17. ALTER TABLE TASK DROP FOREIGN KEY FK_TASK_QUEST_ID
  18. ALTER TABLE TASK DROP FOREIGN KEY FK_TASK_PARENT_ID
  19. ALTER TABLE h_user DROP FOREIGN KEY FK_h_user_LEVEL_ID
  20. ALTER TABLE h_user DROP FOREIGN KEY FK_h_user_ACTIVETITLE_ID
  21. ALTER TABLE ENROLLMENT DROP FOREIGN KEY FK_ENROLLMENT_USER_ID
  22. ALTER TABLE ENROLLMENT DROP FOREIGN KEY FK_ENROLLMENT_COURSE_ID
  23. ALTER TABLE h_user_TITLE DROP FOREIGN KEY FK_h_user_TITLE_User_ID
  24. ALTER TABLE h_user_TITLE DROP FOREIGN KEY FK_h_user_TITLE_titles_ID
  25. DROP TABLE studentAsisgnment
  26. DROP TABLE ACHIEVEMENT
  27. DROP TABLE ACHIEVEMENTRECORD
  28. DROP TABLE CAUSUALRELATION
  29. DROP TABLE COURSE
  30. DROP TABLE QUEST
  31. DROP TABLE LEVEL
  32. DROP TABLE TITLE
  33. DROP TABLE LOGACTION
  34. DROP TABLE LOGENTRY
  35. DROP TABLE QUESTPROGRESS
  36. DROP TABLE TASK
  37. DROP TABLE h_user
  38. DROP TABLE ENROLLMENT
  39. DROP TABLE h_user_TITLE