Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
18 lines (16 sloc) 581 Bytes
--
-- Type: TABLE; Owner: SEARCHAPP; Name: SEARCH_USER_SETTINGS
--
CREATE TABLE "SEARCHAPP"."SEARCH_USER_SETTINGS"
( "ID" NUMBER NOT NULL ENABLE,
"USER_ID" NUMBER NOT NULL ENABLE,
"SETTING_NAME" VARCHAR2(255 BYTE) NOT NULL ENABLE,
"SETTING_VALUE" VARCHAR2(1024 BYTE) NOT NULL ENABLE,
CONSTRAINT "SEARCH_USER_SETTINGS_PKEY" PRIMARY KEY ("ID")
USING INDEX
TABLESPACE "INDX" ENABLE,
CONSTRAINT "SEARCH_USER_SETTINGS_UK" UNIQUE ("USER_ID", "SETTING_NAME", "SETTING_VALUE")
USING INDEX
TABLESPACE "INDX" ENABLE
) SEGMENT CREATION IMMEDIATE
TABLESPACE "TRANSMART" ;