Tables to be removed
As part of our 2.5 db conversion, we are going to remove the following tables from our Production DB unless we are notified that they should be kept around
I am responsible for most of these and since they were all related to the assignments bug
that is now fixed they can be trashed. I will make a note below on the ones I
don't know anything about.
Next not Kirk's
DROP TABLE SAKAI_REALM_BACKUP CASCADE CONSTRAINTS;
DROP TABLE DUPLICATES_ALL4 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_COUNTS_ALL4 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_TEST_ALL4 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATES_ALL3 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_TEST_ALL3 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_COUNTS_ALL3 CASCADE CONSTRAINTS;
DROP TABLE SAM_ASSESSMENTGRADING_DELETED CASCADE CONSTRAINTS;
DROP TABLE DUPLICATES_ALL2 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_COUNTS_ALL2 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_TEST_ALL2 CASCADE CONSTRAINTS;
Next two not Kirk's
DROP TABLE SAKAI_REALM_RL_FN_SAK_1301 CASCADE CONSTRAINTS;
DROP TABLE SAKAI_REALM_RL_FN_TEST CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_TEST_ALL CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_COUNTS_ALL CASCADE CONSTRAINTS;
DROP TABLE DUPLICATES_ALL CASCADE CONSTRAINTS;
DROP TABLE DUPLICATES_SAS001 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_TEST_SAS001 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_COUNTS_SAS001 CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_TESTKDA CASCADE CONSTRAINTS;
DROP TABLE ASSIGNMENT_SUBMISSION_BACKUP CASCADE CONSTRAINTS;
DROP TABLE DUPLICATES CASCADE CONSTRAINTS;
DROP TABLE DUPLICATE_TEST CASCADE CONSTRAINTS;
Next 4 not Kirk's
DROP TABLE SAKAI_USER_ID_MAP_BACKUP CASCADE CONSTRAINTS;
DROP TABLE SAKAI_REALM_PROVIDER_BACKUP CASCADE CONSTRAINTS;
DROP TABLE BADSUBMITREC CASCADE CONSTRAINTS;
DROP TABLE JOINABLE_SAKAI_COURSES CASCADE CONSTRAINTS;