...
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