/
2-5-x DDL NOTES

2-5-x DDL NOTES

May 15, 2008

Things that Hibernate auto.ddl did not create

  • Assignment needs to include the UNIQUE index in auto ddl : SAK-11821

    • SAK-11821 - eliminate duplicates in ASSIGNMENT_SUBMISSION

      • CREATE UNIQUE INDEX ASN_SUB_SUB_INDEX ON ASSIGNMENT_SUBMISSION ( CONTEXT,SUBMITTER_ID );

  • SEARCHBUIDERITEM

    • Add columns to search to improve performance SAK-9865

      • create index isearchbuilderitem_sco on searchbuilderitem (itemscope);

  • Gradebook

    • create index GB_CATEGORY_GB_IDX on GB_CATEGORY_T (GRADEBOOK_ID); create index GB_GRADABLE_OBJ_CT_IDX on GB_GRADABLE_OBJECT_T (CATEGORY_ID);

  • Messages/Forums (MFR)

    • SAK-13137

      • create index MFR_MEMBERSHIP_ITEM_I01_I on MFR_MEMBERSHIP_ITEM_T (t_surrogateKey); create index MFR_MEMBERSHIP_ITEM_I02_I on MFR_MEMBERSHIP_ITEM_T (a_surrogateKey);

    • SAK-13138

      • create index MFR_MESSAGE_T_IN_REPLY_TO_I on MFR_MESSAGE_T (IN_REPLY_TO); create index MFR_TOPIC_T_UUID_I on MFR_TOPIC_T (UUID); create index MFR_UNREAD_STATUS_I2 on MFR_UNREAD_STATUS_T (MESSAGE_C, USER_C, READ_C);

Things that Hibernate auto.ddl created but weren't added by the 2.4.0 to 2.5.0 upgrade script

  • CREATE SEQUENCE ENTITY_PROP_ID_SEQ START WITH 1 MAXVALUE 999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20 NOORDER;
  • -- warehouse module CREATE TABLE DW_ASSIGNMENT_STATUS ( USER_ID VARCHAR2(99 BYTE) NOT NULL, ASSIGNMENT_ID VARCHAR2(99 BYTE) NOT NULL, COURSE_TITLE VARCHAR2(256 BYTE), ASSIGNMENT_TITLE VARCHAR2(256 BYTE), ASSIGNMENT_STATUS VARCHAR2(64 BYTE), ASSIGNMENT_GRADE VARCHAR2(64 BYTE), STUDENT_FIRST_NAME VARCHAR2(128 BYTE), STUDENT_LAST_NAME VARCHAR2(128 BYTE), SCHOOL VARCHAR2(128 BYTE), DISTRICT VARCHAR2(128 BYTE), CLASS_YEAR VARCHAR2(128 BYTE), ADVISOR VARCHAR2(128 BYTE), COURSE_TERM VARCHAR2(128 BYTE), COURSE_CODE VARCHAR2(128 BYTE), COURSE_SECTION VARCHAR2(128 BYTE), COURSE_START_DATE VARCHAR2(128 BYTE), INSTRUCTOR VARCHAR2(128 BYTE) )