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 5 Next »

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

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

  • No labels