Remove Duplicate and Temporary Tables

Owned by James Renfro
Last updated: May 23, 2008 by Jon Gorrono (Unlicensed)Version comment
2 min read

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

(question)

?

 

DROP TABLE DUPLICATES_ALL4 CASCADE CONSTRAINTS

(tick)

?

see footnote [1]

DROP TABLE DUPLICATE_COUNTS_ALL4 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_TEST_ALL4 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATES_ALL3 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_TEST_ALL3 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_COUNTS_ALL3 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE SAM_ASSESSMENTGRADING_DELETED CASCADE CONSTRAINTS

(question)

?

 

DROP TABLE DUPLICATES_ALL2 CASCADE CONSTRAINTS

(question)

?

[1]

DROP TABLE DUPLICATE_COUNTS_ALL2 CASCADE CONSTRAINTS

(question)

?

[1]

DROP TABLE DUPLICATE_TEST_ALL2 CASCADE CONSTRAINTS

(question)

?

[1]

DROP TABLE SAKAI_REALM_RL_FN_SAK_1301 CASCADE CONSTRAINTS

(tick)

Jon

[2]

DROP TABLE SAKAI_REALM_RL_FN_TEST CASCADE CONSTRAINTS

(tick)

Jon

[3]

DROP TABLE DUPLICATE_TEST_ALL CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_COUNTS_ALL CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATES_ALL CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATES_SAS001 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_TEST_SAS001 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_COUNTS_SAS001 CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_TESTKDA CASCADE CONSTRAINTS

(tick)

'KDA' suggests that this is kirk's

[1]]

DROP TABLE ASSIGNMENT_SUBMISSION_BACKUP CASCADE CONSTRAINTS

(question)

?

[1]

DROP TABLE DUPLICATES CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE DUPLICATE_TEST CASCADE CONSTRAINTS

(tick)

?

[1]

DROP TABLE SAKAI_USER_ID_MAP_BACKUP CASCADE CONSTRAINTS

(tick)

kdalex

 

DROP TABLE SAKAI_REALM_PROVIDER_BACKUP CASCADE CONSTRAINTS

(tick)

kdalex

 

DROP TABLE BADSUBMITREC CASCADE CONSTRAINTS

(tick)

kdalex

 

DROP TABLE JOINABLE_SAKAI_COURSES CASCADE CONSTRAINTS

(tick)

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