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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
