
-----------------------------------------------------------------------------
-- JETSPEED_USER_PROFILE
-----------------------------------------------------------------------------
CREATE TABLE JETSPEED_USER_PROFILE
(
    PSML_ID integer IDENTITY,
    USER_NAME VARCHAR (32),
    MEDIA_TYPE VARCHAR (99),
    LANGUAGE VARCHAR (2),
    COUNTRY VARCHAR (2),
    PAGE VARCHAR (99),
    PROFILE BINARY,
    PRIMARY KEY(PSML_ID),
    UNIQUE (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);


-----------------------------------------------------------------------------
-- JETSPEED_GROUP_PROFILE
-----------------------------------------------------------------------------
CREATE TABLE JETSPEED_GROUP_PROFILE
(
    PSML_ID integer IDENTITY,
    GROUP_NAME VARCHAR (99),
    MEDIA_TYPE VARCHAR (99),
    LANGUAGE VARCHAR (2),
    COUNTRY VARCHAR (2),
    PAGE VARCHAR (99),
    PROFILE BINARY,
    PRIMARY KEY(PSML_ID),
    UNIQUE (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);


-----------------------------------------------------------------------------
-- JETSPEED_ROLE_PROFILE
-----------------------------------------------------------------------------
CREATE TABLE JETSPEED_ROLE_PROFILE
(
    PSML_ID integer IDENTITY,
    ROLE_NAME VARCHAR (99),
    MEDIA_TYPE VARCHAR (99),
    LANGUAGE VARCHAR (2),
    COUNTRY VARCHAR (2),
    PAGE VARCHAR (99),
    PROFILE BINARY,
    PRIMARY KEY(PSML_ID),
    UNIQUE (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);


-----------------------------------------------------------------------------
-- JETSPEED_ANON_PROFILE
-----------------------------------------------------------------------------
CREATE TABLE JETSPEED_ANON_PROFILE
(
    PSML_ID integer IDENTITY,
    MEDIA_TYPE VARCHAR (99),
    LANGUAGE VARCHAR (2),
    COUNTRY VARCHAR (2),
    PAGE VARCHAR (99),
    PROFILE BINARY,
    PRIMARY KEY(PSML_ID),
    UNIQUE (MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
);

