...
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 kdalex | [2] | ||
DROP TABLE SAKAI_REALM_RL_FN_TEST CASCADE CONSTRAINTS | | ? Jon kdalex | [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 | 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