portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject cvs commit: jakarta-jetspeed/src/sql dbpsml-schema.sql
Date Mon, 12 Nov 2001 03:41:30 GMT
taylor      01/11/11 19:41:30

  Added:       src/sql  dbpsml-schema.sql
  Log:
  - here is the dbpsml-schema.sql that was generated for hypersonic
  
  Revision  Changes    Path
  1.1                  jakarta-jetspeed/src/sql/dbpsml-schema.sql
  
  Index: dbpsml-schema.sql
  ===================================================================
  
  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)
  );
  
  CREATE  INDEX JETSPEED_USER_PROFILE_INDEX ON JETSPEED_USER_PROFILE (USER_NAME, MEDIA_TYPE,
LANGUAGE, COUNTRY, PAGE);
  
  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)
  );
  
  CREATE  INDEX JETSPEED_GROUP_PROFILE_INDEX ON JETSPEED_GROUP_PROFILE (GROUP_NAME, MEDIA_TYPE,
LANGUAGE, COUNTRY, PAGE);
  
  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)
  );
  
  CREATE  INDEX JETSPEED_ROLE_PROFILE_INDEX ON JETSPEED_ROLE_PROFILE (ROLE_NAME, MEDIA_TYPE,
LANGUAGE, COUNTRY, PAGE);
  
  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)
  );
  
  CREATE  INDEX JETSPEED_ANON_PROFILE_INDEX ON JETSPEED_ANON_PROFILE (MEDIA_TYPE, LANGUAGE,
COUNTRY, PAGE);
  
  

--
To unsubscribe, e-mail:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message