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