Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Schema diff attached

reverse rev 4449

2-4-x should have banner_cm_section not banner_section

remove courseset_temp1

grademode might be a good thing to keep (trunk):

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

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