Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Current »

Schema diff attached

(tick) reverse rev 4449

(tick) 2-4-x should have banner_cm_section not banner_section

(tick) remove courseset_temp1

(tick) remove COURSEMANAGEMENT_INST_OLD

(tick) remove CRS_ENR_OLD

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

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

(tick) 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

(tick)

mothra_person

no case, single quotes

Upper(), double quotes

no index ddl

no index ddl

no index ddl

(tick)

  • No labels