Database svn branch-trunk cleanup

Database svn branch-trunk cleanup

Schema diff attached

reverse rev 4449

2-4-x should have banner_cm_section not banner_section

remove courseset_temp1

remove COURSEMANAGEMENT_INST_OLD

remove CRS_ENR_OLD

(the name has 'save' in it ... do we need this?) remove CRS_SECT_SAVE

(this is used by ats [contact emschellhouse] ) remove ext_course_roster ddl

grademode missing (trunk and 2-4-x, etc):

CREATE TABLE BANNER_GRADEMODE ( GRADE_MODE VARCHAR2(3) NOT NULL, DESCRIPTION VARCHAR2(90) NULL, ACTIVITY_DATE DATE NOT NULL ) ALTER TABLE BANNER_GRADEMODE ADD ( CONSTRAINT PK_STVGMOD PRIMARY KEY (GRADE_MODE) NOT DEFERRABLE INITIALLY IMMEDIATE ) CREATE UNIQUE INDEX PK_STVGMOD ON BANNER_GRADEMODE(GRADE_MODE)

object

caje

hammer

1202 branch

2-4-x branch

trunk

fixed

object

caje

hammer

1202 branch

2-4-x branch

trunk

fixed

mothra_person

pidm varchar

pidm number

number

varchar

number

mothra_person

no case, single quotes

Upper(), double quotes

no index ddl

no index ddl

no index ddl