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 2003/05/13 07:46:19 UTC
cvs commit: jakarta-jetspeed/src/sql/external populate-sapdb.sql turbine-sapdb.sql
taylor 2003/05/12 22:46:19
Added: src/sql/external populate-sapdb.sql turbine-sapdb.sql
Log:
added SAP DB population scripts
Revision Changes Path
1.1 jakarta-jetspeed/src/sql/external/populate-sapdb.sql
Index: populate-sapdb.sql
===================================================================
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'view',NULL)
//
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'customize',NULL)
//
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'maximize',NULL)
//
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'minimize',NULL)
//
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'personalize',NULL)
//
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'info',NULL)
//
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'close',NULL)
//
INSERT INTO TURBINE_PERMISSION VALUES(turbine_permission_seq.nextval,'detach',NULL)
//
INSERT INTO TURBINE_ROLE VALUES(turbine_role_seq.nextval,'user',NULL)
//
INSERT INTO TURBINE_ROLE VALUES(turbine_role_seq.nextval,'admin',NULL)
//
INSERT INTO TURBINE_ROLE VALUES(turbine_role_seq.nextval,'guest',NULL)
//
INSERT INTO TURBINE_GROUP VALUES(turbine_group_seq.nextval,'Jetspeed',NULL)
//
INSERT INTO TURBINE_GROUP VALUES(turbine_group_seq.nextval,'apache',NULL)
//
INSERT INTO TURBINE_USER VALUES(turbine_user_seq.nextval,'admin','jetspeed','Jetspeed','Admin','admin@jakarta-jetspeed.com','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL)
//
INSERT INTO TURBINE_USER VALUES(turbine_user_seq.nextval,'turbine','turbine','Tommy','Turbine','tommy@jakarta-jetspeed.com','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL)
//
INSERT INTO TURBINE_USER VALUES(turbine_user_seq.nextval,'anon','anon','Anonymous','User','anon@jakarta-jetspeed.com','CONFIRMED',NULL,NULL,'2002-10-15 18:45:41.671','F',NULL, NULL)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1)
//
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6)
//
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1)
//
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1)
//
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2)
//
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'ColombianGrade',5,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'KonaGrade',6,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'FrenchRoastGrade',7,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'HazelNutGrade',8,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'VanillaGrade',9,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'JavaGrade',10,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'IndonesianGrade',11,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'OotyGrade',1,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'KenyanGrade',2,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'JoeGrade',3,7.99,1,2)
//
INSERT INTO COFFEES VALUES(coffees_seq.nextval,'CantThinkOfAnymoreGrade',4,7.99,1,2)
//
1.1 jakarta-jetspeed/src/sql/external/turbine-sapdb.sql
Index: turbine-sapdb.sql
===================================================================
-----------------------------------------------------------------------------
-- TURBINE_USER
-----------------------------------------------------------------------------
DROP TABLE TURBINE_USER
//
DROP SEQUENCE TURBINE_USER_SEQ
//
CREATE TABLE TURBINE_USER
(
USER_ID INT NOT NULL ,
LOGIN_NAME VARCHAR (32) NOT NULL,
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 (1),
OBJECTDATA LONG,
PASSWORD_CHANGED TIMESTAMP,
CONSTRAINT TURBINE_USER_U_1 UNIQUE (LOGIN_NAME),
CONSTRAINT TURBINE_USER_PK PRIMARY KEY (USER_ID)
)
//
CREATE SEQUENCE TURBINE_USER_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- TURBINE_ROLE
-----------------------------------------------------------------------------
DROP TABLE TURBINE_ROLE
//
DROP SEQUENCE TURBINE_ROLE_SEQ
//
CREATE TABLE TURBINE_ROLE
(
ROLE_ID INT NOT NULL ,
ROLE_NAME VARCHAR (99) NOT NULL,
OBJECTDATA LONG,
CONSTRAINT TURBINE_ROLE_U_1 UNIQUE (ROLE_NAME),
CONSTRAINT TURBINE_ROLE_PK PRIMARY KEY (ROLE_ID)
)
//
CREATE SEQUENCE TURBINE_ROLE_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- TURBINE_GROUP
-----------------------------------------------------------------------------
DROP TABLE TURBINE_GROUP
//
DROP SEQUENCE TURBINE_GROUP_SEQ
//
CREATE TABLE TURBINE_GROUP
(
GROUP_ID INT NOT NULL ,
GROUP_NAME VARCHAR (99) NOT NULL,
OBJECTDATA LONG,
CONSTRAINT TURBINE_GROUP_U_1 UNIQUE (GROUP_NAME),
CONSTRAINT TURBINE_GROUP_PK PRIMARY KEY (GROUP_ID)
)
//
CREATE SEQUENCE TURBINE_GROUP_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- TURBINE_PERMISSION
-----------------------------------------------------------------------------
DROP TABLE TURBINE_PERMISSION
//
DROP SEQUENCE TURBINE_PERMISSION_SEQ
//
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID INT NOT NULL ,
PERMISSION_NAME VARCHAR (99) NOT NULL,
OBJECTDATA LONG,
CONSTRAINT TURBINE_PERMISSION_U_1 UNIQUE (PERMISSION_NAME),
CONSTRAINT TURBINE_PERMISSION_PK PRIMARY KEY (PERMISSION_ID)
)
//
CREATE SEQUENCE TURBINE_PERMISSION_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- TURBINE_ROLE_PERMISSION
-----------------------------------------------------------------------------
DROP TABLE TURBINE_ROLE_PERMISSION
//
DROP SEQUENCE TURBINE_ROLE_PERMISSION_SEQ
//
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLE_ID INT NOT NULL,
PERMISSION_ID INT NOT NULL,
CONSTRAINT TURBINE_ROLE_PERMISSION_PK PRIMARY KEY (ROLE_ID,PERMISSION_ID)
)
//
CREATE SEQUENCE TURBINE_ROLE_PERMISSION_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- TURBINE_USER_GROUP_ROLE
-----------------------------------------------------------------------------
DROP TABLE TURBINE_USER_GROUP_ROLE
//
DROP SEQUENCE TURBINE_USER_GROUP_ROLE_SEQ
//
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID INT NOT NULL,
GROUP_ID INT NOT NULL,
ROLE_ID INT NOT NULL,
CONSTRAINT TURBINE_USER_GROUP_ROLE_PK PRIMARY KEY (USER_ID,GROUP_ID,ROLE_ID)
)
//
CREATE SEQUENCE TURBINE_USER_GROUP_ROLE_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
ALTER TABLE TURBINE_ROLE_PERMISSION
FOREIGN KEY TURBINE_ROLE_PERMISSION_FK_1 (ROLE_ID)
REFERENCES TURBINE_ROLE (ROLE_ID)
ON DELETE CASCADE
//
ALTER TABLE TURBINE_ROLE_PERMISSION
FOREIGN KEY TURBINE_ROLE_PERMISSION_FK_2 (PERMISSION_ID)
REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
ON DELETE CASCADE
//
ALTER TABLE TURBINE_USER_GROUP_ROLE
FOREIGN KEY TURBINE_USER_GROUP_ROLE_FK_1 (USER_ID)
REFERENCES TURBINE_USER (USER_ID)
ON DELETE CASCADE
//
ALTER TABLE TURBINE_USER_GROUP_ROLE
FOREIGN KEY TURBINE_USER_GROUP_ROLE_FK_2 (GROUP_ID)
REFERENCES TURBINE_GROUP (GROUP_ID)
ON DELETE CASCADE
//
ALTER TABLE TURBINE_USER_GROUP_ROLE
FOREIGN KEY TURBINE_USER_GROUP_ROLE_FK_3 (ROLE_ID)
REFERENCES TURBINE_ROLE (ROLE_ID)
ON DELETE CASCADE
//
-----------------------------------------------------------------------------
-- JETSPEED_USER_PROFILE
-----------------------------------------------------------------------------
DROP TABLE JETSPEED_USER_PROFILE
//
DROP SEQUENCE JETSPEED_USER_PROFILE_SEQ
//
CREATE TABLE JETSPEED_USER_PROFILE
(
PSML_ID INT NOT NULL,
USER_NAME VARCHAR (32) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE LONG,
CONSTRAINT JETSPEED_USER_PROFILE_UNIQUE UNIQUE (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE),
CONSTRAINT JETSPEED_USER_PROFILE_PK PRIMARY KEY (PSML_ID)
)
//
CREATE SEQUENCE JETSPEED_USER_PROFILE_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- JETSPEED_GROUP_PROFILE
-----------------------------------------------------------------------------
DROP TABLE JETSPEED_GROUP_PROFILE
//
DROP SEQUENCE JETSPEED_GROUP_PROFILE_SEQ
//
CREATE TABLE JETSPEED_GROUP_PROFILE
(
PSML_ID INT NOT NULL,
GROUP_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE LONG,
CONSTRAINT JETSPEED_GROUP_PROFILE_UNIQUE UNIQUE (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE),
CONSTRAINT JETSPEED_GROUP_PROFILE_PK
PRIMARY KEY (PSML_ID)
)
//
CREATE SEQUENCE JETSPEED_GROUP_PROFILE_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- JETSPEED_ROLE_PROFILE
-----------------------------------------------------------------------------
DROP TABLE JETSPEED_ROLE_PROFILE
//
DROP SEQUENCE JETSPEED_ROLE_PROFILE_SEQ
//
CREATE TABLE JETSPEED_ROLE_PROFILE
(
PSML_ID INT NOT NULL,
ROLE_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99),
LANGUAGE VARCHAR (2),
COUNTRY VARCHAR (2),
PAGE VARCHAR (99),
PROFILE LONG,
CONSTRAINT JETSPEED_ROLE_PROFILE_UNIQUE UNIQUE (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE),
CONSTRAINT JETSPEED_ROLE_PROFILE_PK
PRIMARY KEY (PSML_ID)
)
//
CREATE SEQUENCE JETSPEED_ROLE_PROFILE_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
-----------------------------------------------------------------------------
-- COFFEES
-----------------------------------------------------------------------------
DROP TABLE COFFEES
//
DROP SEQUENCE COFFEES_SEQ
//
CREATE TABLE COFFEES
(
COFFEE_ID INT NOT NULL,
COFFEE_NAME VARCHAR (50),
SUPPLIER_ID INT,
PRICE FLOAT,
SALES INT,
TOTAL INT,
CONSTRAINT COFFEES_PK
PRIMARY KEY (COFFEE_ID)
)
//
CREATE SEQUENCE COFFEES_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE NOCACHE ORDER
//
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org