Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Current »

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)
    )
    
  • No labels