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):
Code Block |
---|
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() used in indexes, double quotes | no index ddl | no index ddl | no index ddl |
|