ALTER TABLE REPOSITORY ADD (
  IS_PUBLIC VARCHAR2(1) DEFAULT 'Y' NULL, 
  FRONT_PATH VARCHAR2(300) DEFAULT NULL NULL, 
  DEFAULT_LANGUAGE NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE REPOSITORY ADD CONSTRAINT CHECK_REPOSITORY_PUBLIC CHECK ("IS_PUBLIC" IN ('Y', 'N'))