cvs commit: jakarta-jetspeed/src/sql dbpsml-schema.sql

[ta...@apache.org]

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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>