Remove Duplicate and Temporary Tables
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
TABLE |
CAN DELETE |
OWNER |
COMMENTS |
|---|---|---|---|
DROP TABLE SAKAI_REALM_BACKUP CASCADE CONSTRAINTS |
|
? |
 |
DROP TABLE DUPLICATES_ALL4 CASCADE CONSTRAINTS |
|
? |
see footnote [1] |
DROP TABLE DUPLICATE_COUNTS_ALL4 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_TEST_ALL4 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATES_ALL3 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_TEST_ALL3 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_COUNTS_ALL3 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE SAM_ASSESSMENTGRADING_DELETED CASCADE CONSTRAINTS |
|
? |
 |
DROP TABLE DUPLICATES_ALL2 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_COUNTS_ALL2 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_TEST_ALL2 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE SAKAI_REALM_RL_FN_SAK_1301 CASCADE CONSTRAINTS |
|
Jon |
[2] |
DROP TABLE SAKAI_REALM_RL_FN_TEST CASCADE CONSTRAINTS |
|
Jon |
[3] |
DROP TABLE DUPLICATE_TEST_ALL CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_COUNTS_ALL CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATES_ALL CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATES_SAS001 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_TEST_SAS001 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_COUNTS_SAS001 CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_TESTKDA CASCADE CONSTRAINTS |
|
'KDA' suggests that this is kirk's |
[1]] |
DROP TABLE ASSIGNMENT_SUBMISSION_BACKUP CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATES CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE DUPLICATE_TEST CASCADE CONSTRAINTS |
|
? |
[1] |
DROP TABLE SAKAI_USER_ID_MAP_BACKUP CASCADE CONSTRAINTS |
|
kdalex |
 |
DROP TABLE SAKAI_REALM_PROVIDER_BACKUP CASCADE CONSTRAINTS |
|
kdalex |
 |
DROP TABLE BADSUBMITREC CASCADE CONSTRAINTS |
|
kdalex |
 |
DROP TABLE JOINABLE_SAKAI_COURSES CASCADE CONSTRAINTS |
|
kdalex |
 |
Footnotes:
1) This was either kirk or patrick... Jon recalls them both saying all the dup's tables could be dropped
2) This was actually part of the a script that Jon created to get run in production but never was...see the jira for more info
3) this is from a test of the script mentioned in footnote #2