CREATE TABLE JPDK_PREFERENCE_STORE ( 
  PATH_TYPE       VARCHAR2 (60)  NOT NULL, 
  LOCALE          VARCHAR2 (5)  NOT NULL, 
  REFERENCE_PATH  VARCHAR2 (250)  NOT NULL, 
  SEARCH_PATH     VARCHAR2 (250)  NOT NULL, 
  DEFAULT_FLAG    VARCHAR2 (1), 
  DATA_CLASS      VARCHAR2 (250), 
  LONG_VALUE      LONG RAW, 
  CONSTRAINT JPS_PK
  PRIMARY KEY ( REFERENCE_PATH, LOCALE, PATH_TYPE ) ) ; 


CREATE INDEX JPDK_DEFAULT_PREFS ON 
  JPDK_PREFERENCE_STORE(DEFAULT_FLAG) 
; 

CREATE INDEX JPDK_SEARCH_PREFS ON 
  JPDK_PREFERENCE_STORE(SEARCH_PATH) 
; 
