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 Wed, 27 Feb 2002 21:26:47 GMT
taylor      02/02/27 13:26:47

  Modified:    src/sql  dbpsml-schema.sql
  Log:
  - dbpsml-schema.sql for Oracle
  
  Revision  Changes    Path
  1.2       +75 -35    jakarta-jetspeed/src/sql/dbpsml-schema.sql
  
  Index: dbpsml-schema.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed/src/sql/dbpsml-schema.sql,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- dbpsml-schema.sql	12 Nov 2001 03:41:30 -0000	1.1
  +++ dbpsml-schema.sql	27 Feb 2002 21:26:47 -0000	1.2
  @@ -1,59 +1,99 @@
   
  +-----------------------------------------------------------------------------
  +-- JETSPEED_USER_PROFILE
  +-----------------------------------------------------------------------------
  +DROP TABLE JETSPEED_USER_PROFILE CASCADE CONSTRAINTS;
  +
   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),
  +    PSML_ID INT NOT NULL,
  +    USER_NAME VARCHAR2 (32) NOT NULL,
  +    MEDIA_TYPE VARCHAR2 (99),
  +    LANGUAGE VARCHAR2 (2),
  +    COUNTRY VARCHAR2 (2),
  +    PAGE VARCHAR2 (99),
  +    PROFILE LONG RAW,
       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);
  +ALTER TABLE JETSPEED_USER_PROFILE
  +    ADD CONSTRAINT JETSPEED_USER_PROFILE_PK 
  +PRIMARY KEY (PSML_ID);
  +
  +
  +
  +-----------------------------------------------------------------------------
  +-- JETSPEED_GROUP_PROFILE
  +-----------------------------------------------------------------------------
  +DROP TABLE JETSPEED_GROUP_PROFILE CASCADE CONSTRAINTS;
   
   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),
  +    PSML_ID INT NOT NULL,
  +    GROUP_NAME VARCHAR2 (99) NOT NULL,
  +    MEDIA_TYPE VARCHAR2 (99),
  +    LANGUAGE VARCHAR2 (2),
  +    COUNTRY VARCHAR2 (2),
  +    PAGE VARCHAR2 (99),
  +    PROFILE LONG RAW,
       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);
  +ALTER TABLE JETSPEED_GROUP_PROFILE
  +    ADD CONSTRAINT JETSPEED_GROUP_PROFILE_PK 
  +PRIMARY KEY (PSML_ID);
  +
  +
  +
  +-----------------------------------------------------------------------------
  +-- JETSPEED_ROLE_PROFILE
  +-----------------------------------------------------------------------------
  +DROP TABLE JETSPEED_ROLE_PROFILE CASCADE CONSTRAINTS;
   
   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),
  +    PSML_ID INT NOT NULL,
  +    ROLE_NAME VARCHAR2 (99) NOT NULL,
  +    MEDIA_TYPE VARCHAR2 (99),
  +    LANGUAGE VARCHAR2 (2),
  +    COUNTRY VARCHAR2 (2),
  +    PAGE VARCHAR2 (99),
  +    PROFILE LONG RAW,
       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);
  +ALTER TABLE JETSPEED_ROLE_PROFILE
  +    ADD CONSTRAINT JETSPEED_ROLE_PROFILE_PK 
  +PRIMARY KEY (PSML_ID);
  +
  +
  +
  +-----------------------------------------------------------------------------
  +-- JETSPEED_ANON_PROFILE
  +-----------------------------------------------------------------------------
  +DROP TABLE JETSPEED_ANON_PROFILE CASCADE CONSTRAINTS;
   
   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),
  +    PSML_ID INT NOT NULL,
  +    MEDIA_TYPE VARCHAR2 (99),
  +    LANGUAGE VARCHAR2 (2),
  +    COUNTRY VARCHAR2 (2),
  +    PAGE VARCHAR2 (99),
  +    PROFILE LONG RAW,
       UNIQUE (MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE)
   );
   
  -CREATE  INDEX JETSPEED_ANON_PROFILE_INDEX ON JETSPEED_ANON_PROFILE (MEDIA_TYPE, LANGUAGE,
COUNTRY, PAGE);
  \ No newline at end of file
  +ALTER TABLE JETSPEED_ANON_PROFILE
  +    ADD CONSTRAINT JETSPEED_ANON_PROFILE_PK 
  +PRIMARY KEY (PSML_ID);
  +
  +
  +
  +
  +
  +
  +
  +
  +
  +
  
  
  

--
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