Versions Compared

Old Version 10

changes.mady.by.user Thomas Amsler

Saved on

compared with

New Version 11

changes.mady.by.user Thomas Amsler

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • Assignment needs to include the UNIQUE index in auto ddl : SAK-11821
    • SAK-11821 - eliminate duplicates in ASSIGNMENT_SUBMISSION
      • No Format
        CREATE UNIQUE INDEX ASN_SUB_SUB_INDEX ON ASSIGNMENT_SUBMISSION
(
	CONTEXT,SUBMITTER_ID
);
  • SEARCHBUIDERITEM
    • Add columns to search to improve performance SAK-9865
      • No Format
        create index isearchbuilderitem_sco on searchbuilderitem (itemscope);
  • Gradebook
    • No Format
      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
      • No Format
        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
      • No Format
        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);