You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2002/02/27 22:26:47 UTC
cvs commit: jakarta-jetspeed/src/sql dbpsml-schema.sql
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>