portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wea...@apache.org
Subject cvs commit: jakarta-jetspeed-2/portal/src/sql/hsql create-db.sql
Date Fri, 17 Oct 2003 20:08:37 GMT
weaver      2003/10/17 13:08:37

  Modified:    portal/src/sql/hsql create-db.sql
  Log:
  added security role table
  fixed misspellings of description
  
  Revision  Changes    Path
  1.8       +11 -13    jakarta-jetspeed-2/portal/src/sql/hsql/create-db.sql
  
  Index: create-db.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/portal/src/sql/hsql/create-db.sql,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -r1.7 -r1.8
  --- create-db.sql	7 Oct 2003 00:17:45 -0000	1.7
  +++ create-db.sql	17 Oct 2003 20:08:36 -0000	1.8
  @@ -85,17 +85,17 @@
       ID INTEGER PRIMARY KEY,
       PARENT_ID INTEGER NOT NULL,
       NAME VARCHAR(80) NOT NULL,
  -    TYPE VARCHAR(30) NOT NULL,
  +	CLASS_NAME VARCHAR(50) NOT NULL,
       READ_ONLY CHAR(1) DEFAULT '1'
   
   );
   
   CREATE TABLE PREFERENCE_VALUE(
  -    PREFERENCE_ID INTEGER,
  -	ID INTEGER,
  +   	ID INTEGER,
  +    PREFERENCE_ID INTEGER,    
       VALUE LONGVARCHAR,
       CONSTRAINT PK
  - 	PRIMARY KEY (PREFERENCE_ID, ID)
  + 	PRIMARY KEY (ID)
   
   );
   
  @@ -108,27 +108,25 @@
   CREATE TABLE PORTLET_ENTITY(
       ID INTEGER PRIMARY KEY,
   	PORTLET_DEFINITION_ID INTEGER NOT NULL,
  -	GUID VARCHAR(50) NOT NULL
  +	GUID VARCHAR(255) NOT NULL
   );
   
   
   ------------------------------------------------------------------------------
  --- User Preference 
  +-- Security Role Reference
   ------------------------------------------------------------------------------
  -CREATE TABLE USER_PORTLET_PREFERENCE(
  +CREATE TABLE SECURITY_ROLE_REFERENCE(
       ID INTEGER PRIMARY KEY,
  -    PORTLET_ENTITY_ID INTEGER NOT NULL,
  -    USER_NAME VARCHAR(50),
  -    NAME VARCHAR(80) NOT NULL
  -
  +	PORTLET_DEFINITION_ID INTEGER NOT NULL,
  +	ROLE_NAME VARCHAR(150),
  +	ROLE_LINK VARCHAR(150)
   );
   
   
  -
   ------------------------------------------------------------------------------
   -- Localized Descriptions
   ------------------------------------------------------------------------------
  -CREATE TABLE LOCALIZED_DESCRITPION(
  +CREATE TABLE LOCALIZED_DESCRIPTION(
       ID INTEGER PRIMARY KEY,
       OBJECT_ID INTEGER NOT NULL,
       TYPE VARCHAR(25) NOT NULL,
  
  
  

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


Mime
View raw message