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 we...@apache.org on 2004/02/24 01:48:21 UTC

cvs commit: jakarta-jetspeed-2/components/registry/src/sql/hsql create-db.sql drop-db.sql

weaver      2004/02/23 16:48:21

  Added:       components/registry/src/sql/hsql create-db.sql drop-db.sql
  Log:
  add sql for registry creation
  
  Revision  Changes    Path
  1.1                  jakarta-jetspeed-2/components/registry/src/sql/hsql/create-db.sql
  
  Index: create-db.sql
  ===================================================================
  ----------------------------------------------------------------------------
  -- Create Portlet Application Dublin Core Table
  ----------------------------------------------------------------------------
  CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE
  ( 
      ID INTEGER NOT NULL PRIMARY KEY
  );
  
  ----------------------------------------------------------------------------
  -- Create Portlet Application Dublin Core Fields Table
  ----------------------------------------------------------------------------
  
  CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE_FIELDS
  (
  	ID INTEGER NOT NULL PRIMARY KEY,
      OBJECT_ID INTEGER NOT NULL,
      VALUE LONGVARCHAR NOT NULL,
      LOCALE_STRING VARCHAR(50) NOT NULL
  );
  
  ----------------------------------------------------------------------------
  -- Create Portlet Application Table
  ----------------------------------------------------------------------------
  CREATE TABLE PORTLET_APPLICATION
  ( 
      APPLICATION_ID INTEGER NOT NULL PRIMARY KEY,
      APP_NAME VARCHAR(80) NOT NULL,
      APP_IDENTIFIER VARCHAR(80), 
      VERSION VARCHAR(80),
      APP_TYPE INTEGER, 
      DESCRIPTION VARCHAR(80),
      WEB_APP_ID INTEGER NOT NULL,
      DUBLIN_CORE_ID INTEGER NOT NULL
  );
  
  ALTER TABLE PORTLET_APPLICATION ADD CONSTRAINT UK_APPLICATION UNIQUE (APP_NAME);
  
  ----------------------------------------------------------------------------
  -- Create Web Application Table
  ----------------------------------------------------------------------------
  
  CREATE TABLE WEB_APPLICATION(
      ID INTEGER NOT NULL PRIMARY KEY,
      CONTEXT_ROOT VARCHAR(255)  NOT NULL
  );
  
  
  ----------------------------------------------------------------------------
  -- Create Portlet Definition Table
  ----------------------------------------------------------------------------
  
  CREATE TABLE PORTLET_DEFINITION(
      ID INTEGER NOT NULL PRIMARY KEY,
      NAME VARCHAR(80),
      CLASS_NAME VARCHAR(100),
      APPLICATION_ID INTEGER NOT NULL,
      PORTLET_IDENTIFIER VARCHAR(80),
      EXPIRATION_CACHE VARCHAR(30),
      PREFERENCE_VALIDATOR VARCHAR(255),
      UNIQUE(APPLICATION_ID, NAME)
  );
  ----------------------- This breaks some tests since portlet identifier is not required
  -- ALTER TABLE PORTLET_DEFINITION ADD CONSTRAINT UK_PORTLET_IDENT UNIQUE (PORTLET_IDENTIFIER);
  -----------------------
  ----------------------------------------------------------------------------
  -- Create Language  Table
  ----------------------------------------------------------------------------
  
  CREATE TABLE LANGUAGE(
      ID INTEGER NOT NULL PRIMARY KEY,
      PORTLET_ID INTEGER NOT NULL,
      TITLE VARCHAR(100),
      SHORT_TITLE VARCHAR(50),
      LOCALE_STRING VARCHAR(50) NOT NULL,
      KEYWORDS LONGVARCHAR
  );
  
  ----------------------------------------------------------------------------
  -- Create Content Type Table
  ----------------------------------------------------------------------------
  
  CREATE TABLE PORTLET_CONTENT_TYPE(
      CONTENT_TYPE_ID INTEGER PRIMARY KEY,
      PORTLET_ID INTEGER NOT NULL,
      CONTENT_TYPE VARCHAR(30) NOT NULL,
      MODES LONGVARCHAR
  );
  
  ----------------------------------------------------------------------------
  -- Create Parameter Table
  -- NOTE: This table supports both Servlet and Portlet parameters
  -- Class name is required to decide if this is a portlet or servlet parameter
  ----------------------------------------------------------------------------
  
  CREATE TABLE PARAMETER(
      PARAMETER_ID INTEGER PRIMARY KEY,
      PARENT_ID INTEGER NOT NULL,
      CLASS_NAME VARCHAR(30) NOT NULL,
      NAME VARCHAR(80) NOT NULL,
      PARAMETER_VALUE LONGVARCHAR NOT NULL
  );
  
  
  
  ------------------------------------------------------------------------------
  -- Preference and Preference Values
  ------------------------------------------------------------------------------
  CREATE TABLE PORTLET_PREFERENCE(
      ID INTEGER PRIMARY KEY,
      PARENT_ID INTEGER NOT NULL,
      NAME VARCHAR(80) NOT NULL,
      CLASS_NAME VARCHAR(50) NOT NULL,
      READ_ONLY CHAR(1) DEFAULT '1'
  
  );
  
  CREATE TABLE PREFERENCE_VALUE(
         ID INTEGER,
      PREFERENCE_ID INTEGER,    
      VALUE LONGVARCHAR,
      CONSTRAINT PK
       PRIMARY KEY (ID)
  
  );
  
  
  -------------------------------------------------------------------------------
  -- Portlet Entity
  -- Represents the managed state of individual portlet
  -- intance within a "page"
  -------------------------------------------------------------------------------
  CREATE TABLE PORTLET_ENTITY(
      ID INTEGER PRIMARY KEY,
      PORTLET_DEFINITION_ID INTEGER NOT NULL,
      GUID VARCHAR(255) NOT NULL
  );
  
  
  ------------------------------------------------------------------------------
  -- Security Role Reference
  ------------------------------------------------------------------------------
  CREATE TABLE SECURITY_ROLE_REFERENCE(
      ID INTEGER PRIMARY KEY,
      PORTLET_DEFINITION_ID INTEGER NOT NULL,
      ROLE_NAME VARCHAR(150),
      ROLE_LINK VARCHAR(150)
  );
  
  
  ------------------------------------------------------------------------------
  -- Localized Descriptions
  ------------------------------------------------------------------------------
  CREATE TABLE LOCALIZED_DESCRIPTION(
      ID INTEGER PRIMARY KEY,
      OBJECT_ID INTEGER NOT NULL,
      CLASS_NAME VARCHAR(255) NOT NULL,
      DESCRIPTION LONGVARCHAR NOT NULL,
      LOCALE_STRING VARCHAR(50) NOT NULL
  );
  
  ------------------------------------------------------------------------------
  -- Localized Display Names
  ------------------------------------------------------------------------------
  CREATE TABLE LOCALIZED_DISPLAY_NAME(
      ID INTEGER PRIMARY KEY,
      OBJECT_ID INTEGER NOT NULL,
      CLASS_NAME VARCHAR(255),
      DISPLAY_NAME LONGVARCHAR NOT NULL,
      LOCALE_STRING VARCHAR(50) NOT NULL
  );
  
  
  
  
  1.1                  jakarta-jetspeed-2/components/registry/src/sql/hsql/drop-db.sql
  
  Index: drop-db.sql
  ===================================================================
  DROP TABLE PORTLET_APPLICATION_DUBLIN_CORE IF EXISTS;
  DROP TABLE PORTLET_APPLICATION_DUBLIN_CORE_FIELDS IF EXISTS;
  DROP TABLE PARAMETER IF EXISTS; 
  DROP TABLE PORTLET_CONTENT_TYPE IF EXISTS; 
  DROP TABLE LANGUAGE IF EXISTS; 
  DROP TABLE PORTLET_DEFINITION IF EXISTS; 
  DROP TABLE WEB_APPLICATION IF EXISTS; 
  DROP TABLE PORTLET_APPLICATION IF EXISTS; 
  DROP TABLE PORTLET_PREFERENCE IF EXISTS; 
  DROP TABLE PREFERENCE_VALUE IF EXISTS; 
  DROP TABLE USER_PREFERENCE_VALUE IF EXISTS; 
  DROP TABLE PORTLET_ENTITY IF EXISTS; 
  DROP TABLE LOCALIZED_DESCRIPTION IF EXISTS; 
  DROP TABLE LOCALIZED_DISPLAY_NAME IF EXISTS; 
  DROP TABLE SECURITY_ROLE_REFERENCE IF EXISTS;
  
  
  
  

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