taylor 2004/07/21 15:04:40
Modified: src/sql/external turbine-oracle.sql turbine-sqlserver.sql
turbine-mysql-4.sql turbine-mysql.sql
Log:
updated db scripts for db registry
CVS: ----------------------------------------------------------------------
CVS: PR:
CVS: If this change addresses a PR in the problem report tracking
CVS: database, then enter the PR number(s) here.
CVS: Obtained from:
CVS: If this change has been taken from another system, such as NCSA,
CVS: then name the system in this line, otherwise delete it.
CVS: Submitted by:
CVS: If this code has been contributed to Apache by someone else; i.e.,
CVS: they sent us a patch or a new module, then include their name/email
CVS: address here. If this is your work then delete this line.
CVS: Reviewed by:
CVS: If we are doing pre-commit code reviews and someone else has
CVS: reviewed your changes, include their name(s) here.
CVS: If you have not had it reviewed then delete this line.
Revision Changes Path
1.11 +210 -1 jakarta-jetspeed/src/sql/external/turbine-oracle.sql
Index: turbine-oracle.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-oracle.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- turbine-oracle.sql 22 Mar 2004 22:26:58 -0000 1.10
+++ turbine-oracle.sql 21 Jul 2004 22:04:39 -0000 1.11
@@ -308,4 +308,213 @@
ADD CONSTRAINT EMAIL_INBOX
PRIMARY KEY (EMAIL_INBOX_ID);
-CREATE SEQUENCE EMAIL_INBOX_SEQ START WITH 1 INCREMENT BY 1 NOMAXVALUE;
\ No newline at end of file
+CREATE SEQUENCE EMAIL_INBOX_SEQ START WITH 1 INCREMENT BY 1 NOMAXVALUE;
+
+
+-----------------------------------------------------------------------------
+-- portlet
+-----------------------------------------------------------------------------
+DROP TABLE portlet CASCADE CONSTRAINTS;
+DROP SEQUENCE portlet_SEQ;
+
+CREATE TABLE portlet
+(
+ ID NUMBER (20, 0) NOT NULL,
+ NAME VARCHAR2 (128) NOT NULL,
+ HIDDEN NUMBER default 0,
+ CLASSNAME VARCHAR2 (255),
+ TYPE VARCHAR2 (32) NOT NULL,
+ APPLICATION NUMBER default 0,
+ PARENT VARCHAR2 (128),
+ URL VARCHAR2 (255),
+ CACHED_ON_URL NUMBER default 1,
+ TITLE VARCHAR2 (128),
+ DESCRIPTION VARCHAR2 (255),
+ IMAGE VARCHAR2 (128),
+ SECURITY VARCHAR2 (128),
+ CONSTRAINT uk_portlet_name UNIQUE (NAME)
+);
+
+ALTER TABLE portlet
+ ADD CONSTRAINT portlet_PK
+PRIMARY KEY (ID);
+
+
+CREATE SEQUENCE portlet_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE
ORDER;
+
+-----------------------------------------------------------------------------
+-- portlet_category
+-----------------------------------------------------------------------------
+DROP TABLE portlet_category CASCADE CONSTRAINTS;
+DROP SEQUENCE portlet_category_SEQ;
+
+CREATE TABLE portlet_category
+(
+ ID NUMBER (20, 0) NOT NULL,
+ NAME VARCHAR2 (128) NOT NULL,
+ GROUPE VARCHAR2 (128) NOT NULL,
+ PORTLET_ID NUMBER (20, 0)
+);
+
+ALTER TABLE portlet_category
+ ADD CONSTRAINT portlet_category_PK
+PRIMARY KEY (ID);
+
+
+CREATE SEQUENCE portlet_category_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
+
+-----------------------------------------------------------------------------
+-- portlet_parameter
+-----------------------------------------------------------------------------
+DROP TABLE portlet_parameter CASCADE CONSTRAINTS;
+DROP SEQUENCE portlet_parameter_SEQ;
+
+CREATE TABLE portlet_parameter
+(
+ ID NUMBER (20, 0) NOT NULL,
+ NAME VARCHAR2 (128) NOT NULL,
+ VALUE VARCHAR2 (255) default '0',
+ TYPE VARCHAR2 (64),
+ HIDDEN NUMBER default 0,
+ CACHED_ON_VALUE NUMBER default 1,
+ CACHED_ON_NAME NUMBER default 1,
+ TITLE VARCHAR2 (128),
+ DESCRIPTION VARCHAR2 (255),
+ IMAGE VARCHAR2 (128),
+ PORTLET_ID NUMBER (20, 0),
+ SECURITY VARCHAR2 (128)
+);
+
+ALTER TABLE portlet_parameter
+ ADD CONSTRAINT portlet_parameter_PK
+PRIMARY KEY (ID);
+
+
+CREATE SEQUENCE portlet_parameter_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE
NOCYCLE NOCACHE ORDER;
+
+-----------------------------------------------------------------------------
+-- portlet_mediatype
+-----------------------------------------------------------------------------
+DROP TABLE portlet_mediatype CASCADE CONSTRAINTS;
+DROP SEQUENCE portlet_mediatype_SEQ;
+
+CREATE TABLE portlet_mediatype
+(
+ ID NUMBER (20, 0) NOT NULL,
+ NAME VARCHAR2 (128) NOT NULL,
+ PORTLET_ID NUMBER (20, 0)
+);
+
+ALTER TABLE portlet_mediatype
+ ADD CONSTRAINT portlet_mediatype_PK
+PRIMARY KEY (ID);
+
+
+CREATE SEQUENCE portlet_mediatype_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE
NOCYCLE NOCACHE ORDER;
+
+-----------------------------------------------------------------------------
+-- security_entry
+-----------------------------------------------------------------------------
+DROP TABLE security_entry CASCADE CONSTRAINTS;
+DROP SEQUENCE security_entry_SEQ;
+
+CREATE TABLE security_entry
+(
+ ID NUMBER (20, 0) NOT NULL,
+ NAME VARCHAR2 (128) NOT NULL,
+ TITLE VARCHAR2 (128),
+ DESCRIPTION VARCHAR2 (255),
+ CONSTRAINT uk_constraint_name UNIQUE (NAME)
+);
+
+ALTER TABLE security_entry
+ ADD CONSTRAINT security_entry_PK
+PRIMARY KEY (ID);
+
+
+CREATE SEQUENCE security_entry_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
+
+-----------------------------------------------------------------------------
+-- security_access
+-----------------------------------------------------------------------------
+DROP TABLE security_access CASCADE CONSTRAINTS;
+DROP SEQUENCE security_access_SEQ;
+
+CREATE TABLE security_access
+(
+ ID NUMBER (20, 0) NOT NULL,
+ ACTION VARCHAR2 (32) NOT NULL,
+ ENTRY_ID NUMBER (20, 0)
+);
+
+ALTER TABLE security_access
+ ADD CONSTRAINT security_access_PK
+PRIMARY KEY (ID);
+
+
+CREATE SEQUENCE security_access_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
+
+-----------------------------------------------------------------------------
+-- security_allow
+-----------------------------------------------------------------------------
+DROP TABLE security_allow CASCADE CONSTRAINTS;
+DROP SEQUENCE security_allow_SEQ;
+
+CREATE TABLE security_allow
+(
+ ID NUMBER (20, 0) NOT NULL,
+ ALLOW_TYPE VARCHAR2 (32) NOT NULL,
+ ALLOW_VALUE VARCHAR2 (32) NOT NULL,
+ ALLOW_GROUP VARCHAR2 (32),
+ ACCESS_ID NUMBER (20, 0)
+);
+
+ALTER TABLE security_allow
+ ADD CONSTRAINT security_allow_PK
+PRIMARY KEY (ID);
+
+
+CREATE SEQUENCE security_allow_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE
NOCACHE ORDER;
+
+
+ALTER TABLE portlet_category
+ ADD CONSTRAINT portlet_category_FK_1 FOREIGN KEY (PORTLET_ID)
+ REFERENCES portlet (ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE portlet_parameter
+ ADD CONSTRAINT portlet_parameter_FK_1 FOREIGN KEY (PORTLET_ID)
+ REFERENCES portlet (ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE portlet_mediatype
+ ADD CONSTRAINT portlet_mediatype_FK_1 FOREIGN KEY (PORTLET_ID)
+ REFERENCES portlet (ID)
+ON DELETE CASCADE
+;
+
+
+
+
+
+ALTER TABLE security_access
+ ADD CONSTRAINT security_access_FK_1 FOREIGN KEY (ENTRY_ID)
+ REFERENCES security_entry (ID)
+ON DELETE CASCADE
+;
+
+
+
+ALTER TABLE security_allow
+ ADD CONSTRAINT security_allow_FK_1 FOREIGN KEY (ACCESS_ID)
+ REFERENCES security_access (ID)
+ON DELETE CASCADE
+;
+
+
1.7 +419 -0 jakarta-jetspeed/src/sql/external/turbine-sqlserver.sql
Index: turbine-sqlserver.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-sqlserver.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- turbine-sqlserver.sql 22 Mar 2004 22:26:59 -0000 1.6
+++ turbine-sqlserver.sql 21 Jul 2004 22:04:39 -0000 1.7
@@ -567,3 +567,422 @@
CONSTRAINT EMAIL_INBOX_PK
PRIMARY KEY (EMAIL_INBOX_ID)
)
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'portlet')
+BEGIN
+ DECLARE @reftable_1 nvarchar(60), @constraintname_1 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'portlet'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_1, @constraintname_1
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL PROTECTED])
+ FETCH NEXT from refcursor into @reftable_1, @constraintname_1
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE portlet
+END
+;
+
+CREATE TABLE portlet
+(
+ ID BIGINT NOT NULL IDENTITY (1,1),
+ NAME VARCHAR (128) NOT NULL,
+ HIDDEN INT default 0 NULL,
+ CLASSNAME VARCHAR (255) NULL,
+ TYPE VARCHAR (32) NOT NULL,
+ APPLICATION INT default 0 NULL,
+ PARENT VARCHAR (128) NULL,
+ URL VARCHAR (255) NULL,
+ CACHED_ON_URL INT default 1 NULL,
+ TITLE VARCHAR (128) NULL,
+ DESCRIPTION VARCHAR (255) NULL,
+ IMAGE VARCHAR (128) NULL,
+ SECURITY VARCHAR (128) NULL,
+
+ CONSTRAINT portlet_PK PRIMARY KEY(ID),
+ UNIQUE (NAME));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet_category */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='portlet_category_FK_1')
+ ALTER TABLE portlet_category DROP CONSTRAINT portlet_category_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'portlet_category')
+BEGIN
+ DECLARE @reftable_2 nvarchar(60), @constraintname_2 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'portlet_category'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_2, @constraintname_2
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL PROTECTED])
+ FETCH NEXT from refcursor into @reftable_2, @constraintname_2
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE portlet_category
+END
+;
+
+CREATE TABLE portlet_category
+(
+ ID BIGINT NOT NULL IDENTITY (1,1),
+ NAME VARCHAR (128) NOT NULL,
+ GROUPE VARCHAR (128) NOT NULL,
+ PORTLET_ID BIGINT NULL,
+
+ CONSTRAINT portlet_category_PK PRIMARY KEY(ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet_parameter */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='portlet_parameter_FK_1')
+ ALTER TABLE portlet_parameter DROP CONSTRAINT portlet_parameter_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'portlet_parameter')
+BEGIN
+ DECLARE @reftable_3 nvarchar(60), @constraintname_3 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'portlet_parameter'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_3, @constraintname_3
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL PROTECTED])
+ FETCH NEXT from refcursor into @reftable_3, @constraintname_3
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE portlet_parameter
+END
+;
+
+CREATE TABLE portlet_parameter
+(
+ ID BIGINT NOT NULL IDENTITY (1,1),
+ NAME VARCHAR (128) NOT NULL,
+ VALUE VARCHAR (255) default '0' NULL,
+ TYPE VARCHAR (64) NULL,
+ HIDDEN INT default 0 NULL,
+ CACHED_ON_VALUE INT default 1 NULL,
+ CACHED_ON_NAME INT default 1 NULL,
+ TITLE VARCHAR (128) NULL,
+ DESCRIPTION VARCHAR (255) NULL,
+ IMAGE VARCHAR (128) NULL,
+ PORTLET_ID BIGINT NULL,
+ SECURITY VARCHAR (128) NULL,
+
+ CONSTRAINT portlet_parameter_PK PRIMARY KEY(ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet_mediatype */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='portlet_mediatype_FK_1')
+ ALTER TABLE portlet_mediatype DROP CONSTRAINT portlet_mediatype_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'portlet_mediatype')
+BEGIN
+ DECLARE @reftable_4 nvarchar(60), @constraintname_4 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'portlet_mediatype'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_4, @constraintname_4
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL PROTECTED])
+ FETCH NEXT from refcursor into @reftable_4, @constraintname_4
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE portlet_mediatype
+END
+;
+
+CREATE TABLE portlet_mediatype
+(
+ ID BIGINT NOT NULL IDENTITY (1,1),
+ NAME VARCHAR (128) NOT NULL,
+ PORTLET_ID BIGINT NULL,
+
+ CONSTRAINT portlet_mediatype_PK PRIMARY KEY(ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* security_entry */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'security_entry')
+BEGIN
+ DECLARE @reftable_5 nvarchar(60), @constraintname_5 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'security_entry'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_5, @constraintname_5
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL PROTECTED])
+ FETCH NEXT from refcursor into @reftable_5, @constraintname_5
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE security_entry
+END
+;
+
+CREATE TABLE security_entry
+(
+ ID BIGINT NOT NULL IDENTITY (1,1),
+ NAME VARCHAR (128) NOT NULL,
+ TITLE VARCHAR (128) NULL,
+ DESCRIPTION VARCHAR (255) NULL,
+
+ CONSTRAINT security_entry_PK PRIMARY KEY(ID),
+ UNIQUE (NAME));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* security_access */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='security_access_FK_1')
+ ALTER TABLE security_access DROP CONSTRAINT security_access_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'security_access')
+BEGIN
+ DECLARE @reftable_6 nvarchar(60), @constraintname_6 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'security_access'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_6, @constraintname_6
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL PROTECTED])
+ FETCH NEXT from refcursor into @reftable_6, @constraintname_6
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE security_access
+END
+;
+
+CREATE TABLE security_access
+(
+ ID BIGINT NOT NULL IDENTITY (1,1),
+ ACTION VARCHAR (32) NOT NULL,
+ ENTRY_ID BIGINT NULL,
+
+ CONSTRAINT security_access_PK PRIMARY KEY(ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* security_allow */
+/* ---------------------------------------------------------------------- */
+
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND name='security_allow_FK_1')
+ ALTER TABLE security_allow DROP CONSTRAINT security_allow_FK_1;
+IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'security_allow')
+BEGIN
+ DECLARE @reftable_7 nvarchar(60), @constraintname_7 nvarchar(60)
+ DECLARE refcursor CURSOR FOR
+ select reftables.name tablename, cons.name constraintname
+ from sysobjects tables,
+ sysobjects reftables,
+ sysobjects cons,
+ sysreferences ref
+ where tables.id = ref.rkeyid
+ and cons.id = ref.constid
+ and reftables.id = ref.fkeyid
+ and tables.name = 'security_allow'
+ OPEN refcursor
+ FETCH NEXT from refcursor into @reftable_7, @constraintname_7
+ while @@FETCH_STATUS = 0
+ BEGIN
+ exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL PROTECTED])
+ FETCH NEXT from refcursor into @reftable_7, @constraintname_7
+ END
+ CLOSE refcursor
+ DEALLOCATE refcursor
+ DROP TABLE security_allow
+END
+;
+
+CREATE TABLE security_allow
+(
+ ID BIGINT NOT NULL IDENTITY (1,1),
+ ALLOW_TYPE VARCHAR (32) NOT NULL,
+ ALLOW_VALUE VARCHAR (32) NOT NULL,
+ ALLOW_GROUP VARCHAR (32) NULL,
+ ACCESS_ID BIGINT NULL,
+
+ CONSTRAINT security_allow_PK PRIMARY KEY(ID));
+
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* security_allow */
+/* ---------------------------------------------------------------------- */
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE portlet_category
+ ADD CONSTRAINT portlet_category_FK_1 FOREIGN KEY (PORTLET_ID)
+ REFERENCES portlet (ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet_category */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE portlet_parameter
+ ADD CONSTRAINT portlet_parameter_FK_1 FOREIGN KEY (PORTLET_ID)
+ REFERENCES portlet (ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet_parameter */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE portlet_mediatype
+ ADD CONSTRAINT portlet_mediatype_FK_1 FOREIGN KEY (PORTLET_ID)
+ REFERENCES portlet (ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* portlet_mediatype */
+/* ---------------------------------------------------------------------- */
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* security_entry */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE security_access
+ ADD CONSTRAINT security_access_FK_1 FOREIGN KEY (ENTRY_ID)
+ REFERENCES security_entry (ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
+
+/* ---------------------------------------------------------------------- */
+/* security_access */
+/* ---------------------------------------------------------------------- */
+
+BEGIN
+ALTER TABLE security_allow
+ ADD CONSTRAINT security_allow_FK_1 FOREIGN KEY (ACCESS_ID)
+ REFERENCES security_access (ID)
+ ON DELETE CASCADE
+END
+;
+
+
+
1.2 +1 -144 jakarta-jetspeed/src/sql/external/turbine-mysql-4.sql
Index: turbine-mysql-4.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-mysql-4.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- turbine-mysql-4.sql 23 May 2004 12:11:08 -0000 1.1
+++ turbine-mysql-4.sql 21 Jul 2004 22:04:39 -0000 1.2
@@ -1,144 +1 @@
------------------------------------------------------------------------------
--- Copyright 2004 The Apache Software Foundation
---
--- Licensed under the Apache License, Version 2.0 (the "License");
--- you may not use this file except in compliance with the License.
--- You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
------------------------------------------------------------------------------
-
------------------------------------------------------------------------------
--- TURBINE_PERMISSION
------------------------------------------------------------------------------
-CREATE TABLE TURBINE_PERMISSION
-(
- PERMISSION_ID integer NOT NULL PRIMARY KEY,
- PERMISSION_NAME VARCHAR (99) NOT NULL UNIQUE ,
- OBJECTDATA BLOB
-);
-
-
-
------------------------------------------------------------------------------
--- TURBINE_ROLE
------------------------------------------------------------------------------
-CREATE TABLE TURBINE_ROLE
-(
- ROLE_ID integer NOT NULL PRIMARY KEY ,
- ROLE_NAME VARCHAR (99) NOT NULL UNIQUE,
- OBJECTDATA BLOB
-);
-
-
-
------------------------------------------------------------------------------
--- TURBINE_GROUP
------------------------------------------------------------------------------
-CREATE TABLE TURBINE_GROUP
-(
- GROUP_ID integer NOT NULL PRIMARY KEY ,
- GROUP_NAME VARCHAR (99) NOT NULL UNIQUE,
- OBJECTDATA BLOB
-);
-
-
-
------------------------------------------------------------------------------
--- TURBINE_ROLE_PERMISSION
------------------------------------------------------------------------------
-CREATE TABLE TURBINE_ROLE_PERMISSION
-(
- ROLE_ID integer NOT NULL,
- PERMISSION_ID integer NOT NULL,
- PRIMARY KEY(ROLE_ID,PERMISSION_ID)
-);
-
-
-CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION (ROLE_ID,
PERMISSION_ID);
-
------------------------------------------------------------------------------
--- TURBINE_USER
------------------------------------------------------------------------------
-CREATE TABLE TURBINE_USER
-(
- USER_ID integer NOT NULL PRIMARY KEY ,
- LOGIN_NAME VARCHAR (32) NOT NULL UNIQUE,
- PASSWORD_VALUE VARCHAR (32) NOT NULL,
- FIRST_NAME VARCHAR (99) NOT NULL,
- LAST_NAME VARCHAR (99) NOT NULL,
- EMAIL VARCHAR (99),
- CONFIRM_VALUE VARCHAR (99),
- MODIFIED timestamp,
- CREATED timestamp,
- LAST_LOGIN timestamp,
- DISABLED CHAR,
- OBJECTDATA BLOB,
- PASSWORD_CHANGED DATE,
-);
-
-
-
------------------------------------------------------------------------------
--- TURBINE_USER_GROUP_ROLE
------------------------------------------------------------------------------
-CREATE TABLE TURBINE_USER_GROUP_ROLE
-(
- USER_ID integer NOT NULL,
- GROUP_ID integer NOT NULL,
- ROLE_ID integer NOT NULL,
- PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID)
-);
-
-CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID,
ROLE_ID);
-
------------------------------------------------------------------------------
--- TURBINE_SCHEDULED_JOB
------------------------------------------------------------------------------
-CREATE TABLE TURBINE_SCHEDULED_JOB
-(
- JOB_ID integer NOT NULL,
- SECOND integer default -1 NOT NULL,
- MINUTE integer default -1 NOT NULL,
- HOUR integer default -1 NOT NULL,
- WEEK_DAY integer default -1 NOT NULL,
- DAY_OF_MONTH integer default -1 NOT NULL,
- TASK VARCHAR (99) NOT NULL,
- EMAIL VARCHAR (99),
- PRIMARY KEY(JOB_ID)
-);
-
-
------------------------------------------------------------------------------
--- COFFEES
------------------------------------------------------------------------------
-CREATE TABLE COFFEES
-(
- COFFEE_ID integer PRIMARY KEY,
- COFFEE_NAME VARCHAR (50),
- SUPPLIER_ID integer,
- PRICE FLOAT,
- SALES integer,
- TOTAL integer
-);
-
-
------------------------------------------------------------------------------
--- EMAIL
------------------------------------------------------------------------------
-
-CREATE TABLE EMAIL_INBOX (
- EMAIL_INBOX_ID integer(11) NOT NULL auto_increment,
- MESSAGE_ID varchar(255) default NULL,
- FILENAME varchar(255) default NULL,
- ATTACHMENT longblob,
- READFLAG int(11) default NULL,
- PRIMARY KEY (EMAIL_INBOX_ID)
-);
-
+-----------------------------------------------------------------------------
-- Copyright 2004 The Apache Software Foundation
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
-- TURBINE_PERMISSION
-----------------------------------------------------------------------------
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID integer NOT NULL PRIMARY KEY,
PERMISSION_NAME VARCHAR (99) NOT NULL UNIQUE ,
OBJECTDATA BLOB
);
-----------------------------------------------------------------------------
-- TURBINE_ROLE
-----------------------------------------------------------------------------
CREATE TABLE TURBINE_ROLE
(
ROLE_ID integer NOT NULL PRIMARY KEY ,
ROLE_NAME VARCHAR (99) NOT NULL UNIQUE,
OBJECTDATA BLOB
);
-----------------------------------------------------------------------------
-- TURBINE_GROUP
-----------------------------------------------------------------------------
CREATE TABLE TURBINE_GROUP
(
GROUP_ID integer NOT NULL PRIMARY KEY ,
GROUP_NAME VARCHAR (99) NOT NULL UNIQUE,
OBJECTDATA BLOB
);
-----------------------------------------------------------------------------
-- TURBINE_ROLE_PERMISSION
-----------------------------------------------------------------------------
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLE_ID integer NOT NULL,
PERMISSION_ID integer NOT NULL,
PRIMARY KEY(ROLE_ID,PERMISSION_ID)
);
CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION (ROLE_ID,
PERMISSION_ID);
-----------------------------------------------------------------------------
-- TURBINE_USER
-----------------------------------------------------------------------------
CREATE TABLE TURBINE_USER
(
USER_ID integer NOT NULL PRIMARY KEY ,
LOGIN_NAME VARCHAR (32) NOT NULL UNIQUE,
PASSWORD_VALUE VARCHAR (32) NOT NULL,
FIRST_NAME VARCHAR (99) NOT NULL,
LAST_NAME VARCHAR (99) NOT NULL,
EMAIL VARCHAR (99),
CONFIRM_VALUE VARCHAR (99),
MODIFIED timestamp,
CREATED timestamp,
LAST_LOGIN timestamp,
DISABLED CHAR,
OBJECTDATA BLOB,
PASSWORD_CHANGED DATE,
);
-----------------------------------------------------------------------------
-- TURBINE_USER_GROUP_ROLE
-----------------------------------------------------------------------------
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID integer NOT NULL,
GROUP_ID integer NOT NULL,
ROLE_ID integer NOT NULL,
PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID)
);
CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID,
ROLE_ID);
-----------------------------------------------------------------------------
-- TURBINE_SCHEDULED_JOB
-----------------------------------------------------------------------------
CREATE TABLE TURBINE_SCHEDULED_JOB
(
JOB_ID integer NOT NULL,
SECOND integer default -1 NOT NULL,
MINUTE integer default -1 NOT NULL,
HOUR integer default -1 NOT NULL,
WEEK_DAY integer default -1 NOT NULL,
DAY_OF_MONTH integer default -1 NOT NULL,
TASK VARCHAR (99) NOT NULL,
EMAIL VARCHAR (99),
PRIMARY KEY(JOB_ID)
);
-----------------------------------------------------------------------------
-- COFFEES
-----------------------------------------------------------------------------
CREATE TABLE COFFEES
(
COFFEE_ID integer PRIMARY KEY,
COFFEE_NAME VARCHAR (50),
SUPPLIER_ID integer,
PRICE FLOAT,
SALES integer,
TOTAL integer
);
-----------------------------------------------------------------------------
-- EMAIL
-----------------------------------------------------------------------------
CREATE TABLE EMAIL_INBOX (
EMAIL_INBOX_ID integer(11) NOT NULL auto_increment,
MESSAGE_ID varchar(255) default NULL,
FILENAME varchar(255) default NULL,
ATTACHMENT longblob,
READFLAG int(11) default NULL,
PRIMARY KEY (EMAIL_INBOX_ID)
);
# -----------------------------------------------------------------------
# portlet
# -----------------------------------------------------------------------
drop table if exists portlet;
CREATE TABLE portlet
(
ID BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR (128) NOT NULL,
HIDDEN INTEGER default 0,
CLASSNAME VARCHAR (255),
TYPE VARCHAR (32) NOT NULL,
APPLICATION INTEGER default 0,
PARENT VARCHAR (128),
URL VARCHAR (255),
CACHED_ON_URL INTEGER default 1,
TITLE VARCHAR (128),
DESCRIPTION VARCHAR (255),
IMAGE VARCHAR (128),
SECURITY VARCHAR (128),
PRIMARY KEY(ID),
UNIQUE (NAME)
);
# -----------------------------------------------------------------------
# portlet_category
# -----------------------------------------------------------------------
drop table if exists portlet_category;
CREATE TABLE portlet_category
(
ID BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR (128) NOT NULL,
GROUPE VARCHAR (128) NOT NULL,
PORTLET_ID BIGINT,
PRIMARY KEY(ID),
FOREIGN KEY (PORTLET_ID) REFERENCES portlet (ID)
ON DELETE CASCADE
);
# -----------------------------------------------------------------------
# portlet_parameter
# -----------------------------------------------------------------------
drop table if exists portlet_parameter;
CREATE TABLE portlet_parameter
(
ID BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR (128) NOT NULL,
VALUE VARCHAR (255) default '0',
TYPE VARCHAR (64),
HIDDEN INTEGER default 0,
CACHED_ON_VALUE INTEGER default 1,
CACHED_ON_NAME INTEGER default 1,
TITLE VARCHAR (128),
DESCRIPTION VARCHAR (255),
IMAGE VARCHAR (128),
PORTLET_ID BIGINT,
SECURITY VARCHAR (128),
PRIMARY KEY(ID),
FOREIGN KEY (PORTLET_ID) REFERENCES portlet (ID)
ON DELETE CASCADE
);
# -----------------------------------------------------------------------
# portlet_mediatype
# -----------------------------------------------------------------------
drop table if exists portlet_mediatype;
CREATE TABLE portlet_mediatype
(
ID BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR (128) NOT NULL,
PORTLET_ID BIGINT,
PRIMARY KEY(ID),
FOREIGN KEY (PORTLET_ID) REFERENCES portlet (ID)
ON DELETE CASCADE
);
# -----------------------------------------------------------------------
# security_entry
# -----------------------------------------------------------------------
drop table if exists security_entry;
CREATE TABLE security_entry
(
ID BIGINT NOT NULL AUTO_INCREMENT,
NAME VARCHAR (128) NOT NULL,
TITLE VARCHAR (128),
DESCRIPTION VARCHAR (255),
PRIMARY KEY(ID),
UNIQUE (NAME)
);
# -----------------------------------------------------------------------
# security_access
# -----------------------------------------------------------------------
drop table if exists security_access;
CREATE TABLE security_access
(
ID BIGINT NOT NULL AUTO_INCREMENT,
ACTION VARCHAR (32) NOT NULL,
ENTRY_ID BIGINT,
PRIMARY KEY(ID),
FOREIGN KEY (ENTRY_ID) REFERENCES security_entry (ID)
ON DELETE CASCADE
);
# -----------------------------------------------------------------------
# security_allow
# -----------------------------------------------------------------------
drop table if exists security_allow;
CREATE TABLE security_allow
(
ID BIGINT NOT NULL AUTO_INCREMENT,
ALLOW_TYPE VARCHAR (32) NOT NULL,
ALLOW_VALUE VARCHAR (32) NOT NULL,
ALLOW_GROUP VARCHAR (32),
ACCESS_ID BIGINT,
PRIMARY KEY(ID),
FOREIGN KEY (ACCESS_ID) REFERENCES security_access (ID)
ON DELETE CASCADE
);
\ No newline at end of file
1.11 +132 -0 jakarta-jetspeed/src/sql/external/turbine-mysql.sql
Index: turbine-mysql.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/turbine-mysql.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- turbine-mysql.sql 5 Jun 2004 18:57:16 -0000 1.10
+++ turbine-mysql.sql 21 Jul 2004 22:04:39 -0000 1.11
@@ -197,3 +197,135 @@
PRIMARY KEY (EMAIL_INBOX_ID)
);
+# -----------------------------------------------------------------------
+# portlet
+# -----------------------------------------------------------------------
+drop table if exists portlet;
+
+CREATE TABLE portlet
+(
+ ID BIGINT NOT NULL AUTO_INCREMENT,
+ NAME VARCHAR (128) NOT NULL,
+ HIDDEN INTEGER default 0,
+ CLASSNAME VARCHAR (255),
+ TYPE VARCHAR (32) NOT NULL,
+ APPLICATION INTEGER default 0,
+ PARENT VARCHAR (128),
+ URL VARCHAR (255),
+ CACHED_ON_URL INTEGER default 1,
+ TITLE VARCHAR (128),
+ DESCRIPTION VARCHAR (255),
+ IMAGE VARCHAR (128),
+ SECURITY VARCHAR (128),
+ PRIMARY KEY(ID),
+ UNIQUE (NAME)
+);
+
+# -----------------------------------------------------------------------
+# portlet_category
+# -----------------------------------------------------------------------
+drop table if exists portlet_category;
+
+CREATE TABLE portlet_category
+(
+ ID BIGINT NOT NULL AUTO_INCREMENT,
+ NAME VARCHAR (128) NOT NULL,
+ GROUPE VARCHAR (128) NOT NULL,
+ PORTLET_ID BIGINT,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (PORTLET_ID) REFERENCES portlet (ID)
+ ON DELETE CASCADE
+
+);
+
+# -----------------------------------------------------------------------
+# portlet_parameter
+# -----------------------------------------------------------------------
+drop table if exists portlet_parameter;
+
+CREATE TABLE portlet_parameter
+(
+ ID BIGINT NOT NULL AUTO_INCREMENT,
+ NAME VARCHAR (128) NOT NULL,
+ VALUE VARCHAR (255) default '0',
+ TYPE VARCHAR (64),
+ HIDDEN INTEGER default 0,
+ CACHED_ON_VALUE INTEGER default 1,
+ CACHED_ON_NAME INTEGER default 1,
+ TITLE VARCHAR (128),
+ DESCRIPTION VARCHAR (255),
+ IMAGE VARCHAR (128),
+ PORTLET_ID BIGINT,
+ SECURITY VARCHAR (128),
+ PRIMARY KEY(ID),
+ FOREIGN KEY (PORTLET_ID) REFERENCES portlet (ID)
+ ON DELETE CASCADE
+
+);
+
+# -----------------------------------------------------------------------
+# portlet_mediatype
+# -----------------------------------------------------------------------
+drop table if exists portlet_mediatype;
+
+CREATE TABLE portlet_mediatype
+(
+ ID BIGINT NOT NULL AUTO_INCREMENT,
+ NAME VARCHAR (128) NOT NULL,
+ PORTLET_ID BIGINT,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (PORTLET_ID) REFERENCES portlet (ID)
+ ON DELETE CASCADE
+
+);
+
+# -----------------------------------------------------------------------
+# security_entry
+# -----------------------------------------------------------------------
+drop table if exists security_entry;
+
+CREATE TABLE security_entry
+(
+ ID BIGINT NOT NULL AUTO_INCREMENT,
+ NAME VARCHAR (128) NOT NULL,
+ TITLE VARCHAR (128),
+ DESCRIPTION VARCHAR (255),
+ PRIMARY KEY(ID),
+ UNIQUE (NAME)
+);
+
+# -----------------------------------------------------------------------
+# security_access
+# -----------------------------------------------------------------------
+drop table if exists security_access;
+
+CREATE TABLE security_access
+(
+ ID BIGINT NOT NULL AUTO_INCREMENT,
+ ACTION VARCHAR (32) NOT NULL,
+ ENTRY_ID BIGINT,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (ENTRY_ID) REFERENCES security_entry (ID)
+ ON DELETE CASCADE
+
+);
+
+# -----------------------------------------------------------------------
+# security_allow
+# -----------------------------------------------------------------------
+drop table if exists security_allow;
+
+CREATE TABLE security_allow
+(
+ ID BIGINT NOT NULL AUTO_INCREMENT,
+ ALLOW_TYPE VARCHAR (32) NOT NULL,
+ ALLOW_VALUE VARCHAR (32) NOT NULL,
+ ALLOW_GROUP VARCHAR (32),
+ ACCESS_ID BIGINT,
+ PRIMARY KEY(ID),
+ FOREIGN KEY (ACCESS_ID) REFERENCES security_access (ID)
+ ON DELETE CASCADE
+
+);
+
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
