taylor 2002/10/18 12:16:32
Modified: build/torque build.properties dbpsml.properties
build/torque/schema dbpsml-schema.xml security-schema.xml
turbine-schema.xml
lib torque-3.0-b5-dev.jar
src/java/org/apache/jetspeed/services/security/turbine
TurbineGroupManagement.java
TurbinePermissionManagement.java
TurbineRoleManagement.java
src/sql/external populate-sqlserver.sql
turbine-sqlserver.sql
webapp/WEB-INF/conf JetspeedSecurity.properties
Torque.properties
webapp/WEB-INF/db jetspeed.properties jetspeed.script
Log:
1. Fixed the hypersonic functionality by switching back to idbroker mode as default
looks like Torque doesnt support 'native' for Hypersonic DB
will have to fix the Hypersonic Adaptor in Torque to handle native mode
For now, the syndication-schema.xml will need to be EDITED to use 'native' mode
when other dbs
if you want to use native mode:
change
<table name="TURBINE_USER" idMethod="idbroker">
to
<table name="TURBINE_USER" idMethod="native">
etc
2. MS SQL support
- patched Torque to fix MS SQL bugs
- updated MS SQL scripts
- ran unit tests with MS SQL
Revision Changes Path
1.9 +1 -0 jakarta-jetspeed/build/torque/build.properties
Index: build.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/build.properties,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- build.properties 18 Oct 2002 00:50:10 -0000 1.8
+++ build.properties 18 Oct 2002 19:16:31 -0000 1.9
@@ -48,6 +48,7 @@
torque.database=hypersonic
### torque.database=mysql
### database=oracle
+### database=mssql
# -------------------------------------------------------------------
#
1.7 +1 -0 jakarta-jetspeed/build/torque/dbpsml.properties
Index: dbpsml.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/dbpsml.properties,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- dbpsml.properties 18 Oct 2002 00:50:10 -0000 1.6
+++ dbpsml.properties 18 Oct 2002 19:16:31 -0000 1.7
@@ -48,6 +48,7 @@
torque.database=hypersonic
### torque.database=mysql
### torque.database=oracle
+### torque.database=mssql
# -------------------------------------------------------------------
#
1.6 +4 -7 jakarta-jetspeed/build/torque/schema/dbpsml-schema.xml
Index: dbpsml-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/schema/dbpsml-schema.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- dbpsml-schema.xml 18 Oct 2002 00:50:10 -0000 1.5
+++ dbpsml-schema.xml 18 Oct 2002 19:16:31 -0000 1.6
@@ -20,8 +20,7 @@
<table name="JETSPEED_USER_PROFILE" idMethod="native" >
- <column name="PSML_ID" required="true" primaryKey="true"
- autoIncrement="true" type="INTEGER"/>
+ <column name="PSML_ID" required="true" primaryKey="true" autoIncrement="true"
type="INTEGER"/>
<column name="USER_NAME" required="true" size="32" type="VARCHAR"/>
<column name="MEDIA_TYPE" size="99" type="VARCHAR"/>
<column name="LANGUAGE" size="2" type="VARCHAR"/>
@@ -41,8 +40,7 @@
<table name="JETSPEED_GROUP_PROFILE" idMethod="native" >
- <column name="PSML_ID" required="true" primaryKey="true"
- autoIncrement="true" type="INTEGER"/>
+ <column name="PSML_ID" required="true" primaryKey="true" autoIncrement="true"
type="INTEGER"/>
<column name="GROUP_NAME" required="true" size="99" type="VARCHAR"/>
<column name="MEDIA_TYPE" size="99" type="VARCHAR"/>
<column name="LANGUAGE" size="2" type="VARCHAR"/>
@@ -62,8 +60,7 @@
<table name="JETSPEED_ROLE_PROFILE" idMethod="native" >
- <column name="PSML_ID" required="true" primaryKey="true"
- autoIncrement="true" type="INTEGER"/>
+ <column name="PSML_ID" required="true" primaryKey="true" autoIncrement="true"
type="INTEGER"/>
<column name="ROLE_NAME" required="true" size="99" type="VARCHAR"/>
<column name="MEDIA_TYPE" size="99" type="VARCHAR"/>
<column name="LANGUAGE" size="2" type="VARCHAR"/>
1.5 +16 -12 jakarta-jetspeed/build/torque/schema/security-schema.xml
Index: security-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/schema/security-schema.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- security-schema.xml 18 Oct 2002 00:50:10 -0000 1.4
+++ security-schema.xml 18 Oct 2002 19:16:31 -0000 1.5
@@ -18,8 +18,9 @@
<database>
- <table name="TURBINE_USER" idMethod="native">
- <column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/>
+ <!-- for dbs other than HYPERSONIC: <table name="TURBINE_USER" idMethod="native">
-->
+ <table name="TURBINE_USER" idMethod="idbroker">
+ <column name="USER_ID" required="true" primaryKey="true" autoIncrement="true"
type="INTEGER"/>
<column name="LOGIN_NAME" required="true" size="32" type="VARCHAR"/>
<column name="PASSWORD_VALUE" required="true" size="32" type="VARCHAR"/>
<column name="FIRST_NAME" required="true" size="99" type="VARCHAR"/>
@@ -38,9 +39,10 @@
</unique>
</table>
-
- <table name="TURBINE_ROLE" idMethod="native" >
- <column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>
+
+ <!-- for dbs other than HYPERSONIC: <table name="TURBINE_ROLE" idMethod="native">
-->
+ <table name="TURBINE_ROLE" idMethod="idbroker" >
+ <column name="ROLE_ID" required="true" primaryKey="true" autoIncrement="true"
type="INTEGER"/>
<column name="ROLE_NAME" required="true" size="99" type="VARCHAR"/>
<column name="OBJECTDATA" type="BINARY"/>
@@ -50,8 +52,9 @@
</table>
- <table name="TURBINE_GROUP" idMethod="native" >
- <column name="GROUP_ID" required="true" primaryKey="true" type="INTEGER"/>
+ <!-- for dbs other than HYPERSONIC: <table name="TURBINE_GROUP"
idMethod="native"> -->
+ <table name="TURBINE_GROUP" idMethod="idbroker" >
+ <column name="GROUP_ID" required="true" primaryKey="true" autoIncrement="true"
type="INTEGER"/>
<column name="GROUP_NAME" required="true" type="VARCHAR" size="99"/>
<column name="OBJECTDATA" type="BINARY"/>
@@ -60,9 +63,10 @@
</unique>
</table>
-
- <table name="TURBINE_PERMISSION" idMethod="native" >
- <column name="PERMISSION_ID" required="true" primaryKey="true" type="INTEGER"/>
+
+ <!-- for dbs other than HYPERSONIC: <table name="TURBINE_PERMISSION"
idMethod="native"> -->
+ <table name="TURBINE_PERMISSION" idMethod="idbroker" >
+ <column name="PERMISSION_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="PERMISSION_NAME" required="true" size="99" type="VARCHAR"/>
<column name="OBJECTDATA" type="BINARY"/>
@@ -73,7 +77,7 @@
</table>
<table name="TURBINE_ROLE_PERMISSION" idMethod="none">
- <column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>
+ <column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="PERMISSION_ID" required="true" primaryKey="true" type="INTEGER"/>
<foreign-key foreignTable="TURBINE_ROLE" onDelete="cascade">
1.6 +2 -2 jakarta-jetspeed/build/torque/schema/turbine-schema.xml
Index: turbine-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/build/torque/schema/turbine-schema.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- turbine-schema.xml 18 Oct 2002 00:50:10 -0000 1.5
+++ turbine-schema.xml 18 Oct 2002 19:16:31 -0000 1.6
@@ -18,7 +18,7 @@
<database>
- <table name="TURBINE_SCHEDULED_JOB" idMethod="native">
+ <table name="TURBINE_SCHEDULED_JOB" idMethod="idbroker">
<column name="JOB_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="SECOND" default="-1" required="true" type="INTEGER"/>
<column name="MINUTE" default="-1" required="true" type="INTEGER"/>
1.2 +17 -17 jakarta-jetspeed/lib/torque-3.0-b5-dev.jar
<<Binary file>>
1.4 +3 -1
jakarta-jetspeed/src/java/org/apache/jetspeed/services/security/turbine/TurbineGroupManagement.java
Index: TurbineGroupManagement.java
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed/src/java/org/apache/jetspeed/services/security/turbine/TurbineGroupManagement.java,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- TurbineGroupManagement.java 15 Oct 2002 17:35:33 -0000 1.3
+++ TurbineGroupManagement.java 18 Oct 2002 19:16:32 -0000 1.4
@@ -366,7 +366,9 @@
TurbineGroupPeer.doDelete(criteria, conn);
PsmlManager.removeGroupDocuments(group);
+
conn.commit();
+
}
catch(Exception e)
{
1.5 +3 -2
jakarta-jetspeed/src/java/org/apache/jetspeed/services/security/turbine/TurbinePermissionManagement.java
Index: TurbinePermissionManagement.java
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed/src/java/org/apache/jetspeed/services/security/turbine/TurbinePermissionManagement.java,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- TurbinePermissionManagement.java 15 Oct 2002 17:35:33 -0000 1.4
+++ TurbinePermissionManagement.java 18 Oct 2002 19:16:32 -0000 1.5
@@ -317,8 +317,9 @@
TurbineRolePermissionPeer.doDelete(critRolePerm, conn);
}
TurbinePermissionPeer.doDelete(criteria, conn);
+
conn.commit();
-
+
if (cachingEnable)
{
JetspeedSecurityCache.removeAllPermissions(permissionName);
1.5 +3 -2
jakarta-jetspeed/src/java/org/apache/jetspeed/services/security/turbine/TurbineRoleManagement.java
Index: TurbineRoleManagement.java
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed/src/java/org/apache/jetspeed/services/security/turbine/TurbineRoleManagement.java,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- TurbineRoleManagement.java 15 Oct 2002 17:35:33 -0000 1.4
+++ TurbineRoleManagement.java 18 Oct 2002 19:16:32 -0000 1.5
@@ -378,7 +378,8 @@
TurbineRolePeer.doDelete(criteria, conn);
PsmlManager.removeRoleDocuments(role);
- conn.commit();
+
+ conn.commit();
if (cachingEnable)
{
1.2 +30 -26 jakarta-jetspeed/src/sql/external/populate-sqlserver.sql
Index: populate-sqlserver.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-sqlserver.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- populate-sqlserver.sql 10 Jun 2002 15:23:56 -0000 1.1
+++ populate-sqlserver.sql 18 Oct 2002 19:16:32 -0000 1.2
@@ -1,17 +1,19 @@
-INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL);
-INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL);
-INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL);
-INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL);
-INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL);
-INSERT INTO TURBINE_PERMISSION VALUES(6,'info',NULL);
-INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL);
-INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
-INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
-INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
-INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
-INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
-INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Raphael','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
-INSERT INTO TURBINE_USER
VALUES(2,'turbine','turbine','David','Turbine','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478');
+INSERT INTO TURBINE_PERMISSION VALUES('view',NULL);
+INSERT INTO TURBINE_PERMISSION VALUES('customize',NULL);
+INSERT INTO TURBINE_PERMISSION VALUES('maximize',NULL);
+INSERT INTO TURBINE_PERMISSION VALUES('minimize',NULL);
+INSERT INTO TURBINE_PERMISSION VALUES('personalize',NULL);
+INSERT INTO TURBINE_PERMISSION VALUES('info',NULL);
+INSERT INTO TURBINE_PERMISSION VALUES('close',NULL);
+INSERT INTO TURBINE_PERMISSION VALUES('detach',NULL);
+INSERT INTO TURBINE_ROLE VALUES('user',NULL);
+INSERT INTO TURBINE_ROLE VALUES('admin',NULL);
+INSERT INTO TURBINE_ROLE VALUES('guest',NULL);
+INSERT INTO TURBINE_GROUP VALUES('Jetspeed',NULL);
+INSERT INTO TURBINE_GROUP VALUES('apache',NULL);
+INSERT INTO TURBINE_USER
VALUES('admin','jetspeed','Jetspeed','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,'2002-10-15
18:45:41.671','F',NULL, NULL);
+INSERT INTO TURBINE_USER
VALUES('turbine','turbine','Tommy','Turbine','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,'2002-10-15
18:45:41.671','F',NULL, NULL);
+INSERT INTO TURBINE_USER
VALUES('anon','anon','Anonymous','User','[EMAIL PROTECTED]','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);
@@ -25,19 +27,21 @@
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 ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10);
-INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10);
-INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10);
-INSERT INTO ID_TABLE VALUES(4,'TURBINE_USER',120,10);
-INSERT INTO ID_TABLE VALUES(5,'TURBINE_SCHEDULED_JOB',100,10);
-INSERT INTO ID_TABLE VALUES(6,'TURBINE_ROLE_PERMISSION',100,10);
-INSERT INTO ID_TABLE VALUES(7,'TURBINE_USER_GROUP_ROLE',100,10);
-INSERT INTO ID_TABLE VALUES(8,'JETSPEED_USER_PROFILE',120,10);
-INSERT INTO ID_TABLE VALUES(9,'JETSPEED_GROUP_PROFILE',120,10);
-INSERT INTO ID_TABLE VALUES(10,'JETSPEED_ROLE_PROFILE',120,10);
-INSERT INTO ID_TABLE VALUES(11,'JETSPEED_ANON_PROFILE',120,10);
-
+INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3);
+INSERT INTO COFFEES VALUES('ColombianGrade',5,7.99,1,2);
+INSERT INTO COFFEES VALUES('KonaGrade',6,7.99,1,2);
+INSERT INTO COFFEES VALUES('FrenchRoastGrade',7,7.99,1,2);
+INSERT INTO COFFEES VALUES('HazelNutGrade',8,7.99,1,2);
+INSERT INTO COFFEES VALUES('VanillaGrade',9,7.99,1,2);
+INSERT INTO COFFEES VALUES('JavaGrade',10,7.99,1,2);
+INSERT INTO COFFEES VALUES('IndonesianGrade',11,7.99,1,2);
+INSERT INTO COFFEES VALUES('OotyGrade',1,7.99,1,2);
+INSERT INTO COFFEES VALUES('KenyanGrade',2,7.99,1,2);
+INSERT INTO COFFEES VALUES('JoeGrade',3,7.99,1,2);
+INSERT INTO COFFEES VALUES('CantThinkOfAnymoreGrade',4,7.99,1,2);
1.3 +1 -227 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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- turbine-sqlserver.sql 10 Jun 2002 15:56:54 -0000 1.2
+++ turbine-sqlserver.sql 18 Oct 2002 19:16:32 -0000 1.3
@@ -1,227 +1 @@
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'ID_TABLE')
-BEGIN
- DROP TABLE ID_TABLE
-END
-;
-
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'TURBINE_SCHEDULED_JOB')
-BEGIN
- DROP TABLE TURBINE_SCHEDULED_JOB
-END
-;
-
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='TURBINE_USER_GROUP_ROLE_FK_1')
- ALTER TABLE TURBINE_USER_GROUP_ROLE DROP CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1
-;
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='TURBINE_USER_GROUP_ROLE_FK_2')
- ALTER TABLE TURBINE_USER_GROUP_ROLE DROP CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2
-;
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='TURBINE_USER_GROUP_ROLE_FK_3')
- ALTER TABLE TURBINE_USER_GROUP_ROLE DROP CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3
-;
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'TURBINE_USER_GROUP_ROLE')
-BEGIN
- DROP TABLE TURBINE_USER_GROUP_ROLE
-END
-;
-
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_USER')
-BEGIN
- DROP TABLE TURBINE_USER
-END
-;
-
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='TURBINE_ROLE_PERMISSION_FK_1')
- ALTER TABLE TURBINE_ROLE_PERMISSION DROP CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1
-;
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='TURBINE_ROLE_PERMISSION_FK_2')
- ALTER TABLE TURBINE_ROLE_PERMISSION DROP CONSTRAINT TURBINE_ROLE_PERMISSION_FK_2
-;
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'TURBINE_ROLE_PERMISSION')
-BEGIN
- DROP TABLE TURBINE_ROLE_PERMISSION
-END
-;
-
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_GROUP')
-BEGIN
- DROP TABLE TURBINE_GROUP
-END
-;
-
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_ROLE')
-BEGIN
- DROP TABLE TURBINE_ROLE
-END
-;
-
-
-/* ---------------------------------------------------------------------- */
-/* TURBINE_PERMISSION */
-/* ---------------------------------------------------------------------- */
-
-IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'TURBINE_PERMISSION')
-BEGIN
- DROP TABLE TURBINE_PERMISSION
-END
-;
-
-CREATE TABLE TURBINE_PERMISSION
-(
- PERMISSION_ID INT NOT NULL,
- PERMISSION_NAME VARCHAR (99) NOT NULL,
- OBJECTDATA VARCHAR(5000),
- CONSTRAINT TURBINE_PERMISSION_PK PRIMARY KEY(PERMISSION_ID),
- UNIQUE (PERMISSION_NAME)
-);
-
-
-
-
-/* ---------------------------------------------------------------------- */
-/* TURBINE_ROLE */
-/* ---------------------------------------------------------------------- */
-
-CREATE TABLE TURBINE_ROLE
-(
- ROLE_ID INT NOT NULL,
- ROLE_NAME VARCHAR (99) NOT NULL,
- OBJECTDATA VARCHAR(5000),
- CONSTRAINT TURBINE_ROLE_PK PRIMARY KEY(ROLE_ID),
- UNIQUE (ROLE_NAME)
-);
-
-
-
-
-/* ---------------------------------------------------------------------- */
-/* TURBINE_GROUP */
-/* ---------------------------------------------------------------------- */
-
-CREATE TABLE TURBINE_GROUP
-(
- GROUP_ID INT NOT NULL,
- GROUP_NAME VARCHAR (99) NOT NULL,
- OBJECTDATA VARCHAR(5000),
- CONSTRAINT TURBINE_GROUP_PK PRIMARY KEY(GROUP_ID),
- UNIQUE (GROUP_NAME)
-);
-
-
-
-
-/* ---------------------------------------------------------------------- */
-/* TURBINE_ROLE_PERMISSION */
-/* ---------------------------------------------------------------------- */
-
-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)
-);
-
-ALTER TABLE TURBINE_ROLE_PERMISSION
- ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1 FOREIGN KEY (ROLE_ID)
- REFERENCES TURBINE_ROLE (ROLE_ID)
-;
-
-ALTER TABLE TURBINE_ROLE_PERMISSION
- ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_2 FOREIGN KEY (PERMISSION_ID)
- REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
-;
-
-
-CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION (ROLE_ID,
PERMISSION_ID);
-
-
-/* ---------------------------------------------------------------------- */
-/* TURBINE_USER */
-/* ---------------------------------------------------------------------- */
-
-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 DATETIME,
- CREATED DATETIME,
- LAST_LOGIN DATETIME,
- DISABLED VARCHAR(1),
- OBJECTDATA VARCHAR(5000),
- CONSTRAINT TURBINE_USER_PK PRIMARY KEY(USER_ID),
- UNIQUE (LOGIN_NAME)
-);
-
-
-
-
-/* ---------------------------------------------------------------------- */
-/* TURBINE_USER_GROUP_ROLE */
-/* ---------------------------------------------------------------------- */
-
-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)
-);
-
-ALTER TABLE TURBINE_USER_GROUP_ROLE
- ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USER_ID)
- REFERENCES TURBINE_USER (USER_ID)
-;
-
-ALTER TABLE TURBINE_USER_GROUP_ROLE
- ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUP_ID)
- REFERENCES TURBINE_GROUP (GROUP_ID)
-;
-
-ALTER TABLE TURBINE_USER_GROUP_ROLE
- ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID)
- REFERENCES TURBINE_ROLE (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 INT NOT NULL,
- SECOND INT default -1 NOT NULL,
- MINUTE INT default -1 NOT NULL,
- HOUR INT default -1 NOT NULL,
- WEEK_DAY INT default -1 NOT NULL,
- DAY_OF_MONTH INT default -1 NOT NULL,
- TASK VARCHAR (99) NOT NULL,
- EMAIL VARCHAR (99),
- CONSTRAINT TURBINE_SCHEDULED_JOB_PK PRIMARY KEY(JOB_ID)
-);
-
-
-
-/* ----------------------------------------------------------------------------- */
-/* -- ID_TABLE */
-/* ----------------------------------------------------------------------------- */
-
-CREATE TABLE ID_TABLE
-(
- ID_TABLE_ID INT NOT NULL,
- TABLE_NAME VARCHAR (255) NOT NULL,
- NEXT_ID INT,
- QUANTITY INT,
- CONSTRAINT ID_TABLE_PK PRIMARY KEY(ID_TABLE_ID),
- UNIQUE (TABLE_NAME)
-);
-
-
+/* ---------------------------------------------------------------------- */
/*
TURBINE_USER */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_USER')
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
= 'TURBINE_USER'
OPEN refcursor
FETCH NEXT from refcursor into @reftable_1,
@constraintname_1
while @@FETCH_STATUS = 0
BEGIN
exec ('alter table
'+@reftable_1+' drop constraint '+@constraintname_1)
FETCH NEXT from refcursor
into @reftable_1, @constraintname_1
END
CLOSE refcursor
DEALLOCATE
refcursor
DROP TABLE TURBINE_USER
END
CREATE TABLE TURBINE_USER
(
USER_ID INT NOT NULL IDENTITY (1,1),
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)
NULL,
CONFIRM_VALUE VARCHAR (99) NULL,
MODIFIED DATETIME NULL,
CREATED DATETIME NULL,
LAST_LOGIN DATETIME NULL,
DISABLED CHAR (1) NULL,
OBJECTDATA BINARY(7132) NULL,
PASSWORD_CHANGED DATETIME NULL,
CONSTRAINT TURBINE_USER_PK PRIMARY KEY(USER_ID),
UNIQUE (LOGIN_NAME));
/*
---------------------------------------------------------------------- */
/*
TURBINE_ROLE */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_ROLE')
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
= 'TURBINE_ROLE'
OPEN refcursor
FETCH NEXT from refcursor into @reftable_2,
@constraintname_2
while @@FETCH_STATUS = 0
BEGIN
exec ('alter table
'+@reftable_2+' drop constraint '+@constraintname_2)
FETCH NEXT from refcursor
into @reftable_2, @constraintname_2
END
CLOSE refcursor
DEALLOCATE
refcursor
DROP TABLE TURBINE_ROLE
END
CREATE TABLE TURBINE_ROLE
(
ROLE_ID INT NOT NULL IDENTITY (1,1),
ROLE_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BINARY(7132) NULL,
CONSTRAINT TURBINE_ROLE_PK PRIMARY
KEY(ROLE_ID),
UNIQUE (ROLE_NAME));
/*
---------------------------------------------------------------------- */
/*
TURBINE_GROUP */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_GROUP')
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
= 'TURBINE_GROUP'
OPEN refcursor
FETCH NEXT from refcursor into @reftable_3,
@constraintname_3
while @@FETCH_STATUS = 0
BEGIN
exec ('alter table
'+@reftable_3+' drop constraint '+@constraintname_3)
FETCH NEXT from refcursor
into @reftable_3, @constraintname_3
END
CLOSE refcursor
DEALLOCATE
refcursor
DROP TABLE TURBINE_GROUP
END
CREATE TABLE TURBINE_GROUP
(
GROUP_ID INT NOT NULL IDENTITY (1,1),
GROUP_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BINARY(7132) NULL,
CONSTRAINT TURBINE_GROUP_PK PRIMARY
KEY(GROUP_ID),
UNIQUE (GROUP_NAME));
/*
---------------------------------------------------------------------- */
/*
TURBINE_PERMISSION */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_PERMISSION')
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
= 'TURBINE_PERMISSION'
OPEN refcursor
FETCH NEXT from refcursor into
@reftable_4, @constraintname_4
while @@FETCH_STATUS = 0
BEGIN
exec
('alter table '+@reftable_4+' drop constraint '+@constraintname_4)
FETCH NEXT
from refcursor into @reftable_4, @constraintname_4
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE TURBINE_PERMISSION
END
CREATE TABLE
TURBINE_PERMISSION
(
PERMISSION_ID INT NOT NULL IDENTITY (1,1),
PERMISSION_NAME VARCHAR (99) NOT NULL,
OBJECTDATA BINARY(7132) NULL,
CONSTRAINT TURBINE_PERMISSION_PK PRIMARY KEY(PERMISSION_ID),
UNIQUE
(PERMISSION_NAME));
/*
---------------------------------------------------------------------- */
/*
TURBINE_ROLE_PERMISSION */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type ='RI' AND name='TURBINE_ROLE_PERMISSION_FK_1')
ALTER TABLE TURBINE_ROLE_PERMISSION DROP CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1;
IF
EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='TURBINE_ROLE_PERMISSION_FK_2')
ALTER TABLE TURBINE_ROLE_PERMISSION DROP
CONSTRAINT TURBINE_ROLE_PERMISSION_FK_2;
IF EXISTS (SELECT 1 FROM sysobjects WHERE
type = 'U' AND name = 'TURBINE_ROLE_PERMISSION')
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 =
'TURBINE_ROLE_PERMISSION'
OPEN refcursor
FETCH NEXT from refcursor into
@reftable_5, @constraintname_5
while @@FETCH_STATUS = 0
BEGIN
exec
('alter table '+@reftable_5+' drop constraint '+@constraintname_5)
FETCH NEXT
from refcursor into @reftable_5, @constraintname_5
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE TURBINE_ROLE_PERMISSION
END
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));
/*
---------------------------------------------------------------------- */
/*
TURBINE_USER_GROUP_ROLE */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type ='RI' AND name='TURBINE_USER_GROUP_ROLE_FK_1')
ALTER TABLE TURBINE_USER_GROUP_ROLE DROP CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1;
IF
EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND
name='TURBINE_USER_GROUP_ROLE_FK_2')
ALTER TABLE TURBINE_USER_GROUP_ROLE DROP
CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2;
IF EXISTS (SELECT 1 FROM sysobjects WHERE
type ='RI' AND name='TURBINE_USER_GROUP_ROLE_FK_3')
ALTER TABLE
TURBINE_USER_GROUP_ROLE DROP CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3;
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_USER_GROUP_ROLE')
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
= 'TURBINE_USER_GROUP_ROLE'
OPEN refcursor
FETCH NEXT from refcursor into
@reftable_6, @constraintname_6
while @@FETCH_STATUS = 0
BEGIN
exec
('alter table '+@reftable_6+' drop constraint '+@constraintname_6)
FETCH NEXT
from refcursor into @reftable_6, @constraintname_6
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE TURBINE_USER_GROUP_ROLE
END
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));
/*
---------------------------------------------------------------------- */
/*
TURBINE_USER_GROUP_ROLE */
/*
---------------------------------------------------------------------- */
/*
---------------------------------------------------------------------- */
/*
TURBINE_USER */
/*
---------------------------------------------------------------------- */
/*
---------------------------------------------------------------------- */
/*
TURBINE_ROLE */
/*
---------------------------------------------------------------------- */
/*
---------------------------------------------------------------------- */
/*
TURBINE_GROUP */
/*
---------------------------------------------------------------------- */
/*
---------------------------------------------------------------------- */
/*
TURBINE_PERMISSION */
/*
---------------------------------------------------------------------- */
BEGIN
ALTER
TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1 FOREIGN
KEY (ROLE_ID)
REFERENCES TURBINE_ROLE (ROLE_ID)
ON DELETE CASCADE
END
;
BEGIN
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT
TURBINE_ROLE_PERMISSION_FK_2 FOREIGN KEY (PERMISSION_ID)
REFERENCES
TURBINE_PERMISSION (PERMISSION_ID)
ON DELETE CASCADE
END
;
/*
---------------------------------------------------------------------- */
/*
TURBINE_ROLE_PERMISSION */
/*
---------------------------------------------------------------------- */
BEGIN
ALTER
TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN
KEY (USER_ID)
REFERENCES TURBINE_USER (USER_ID)
ON DELETE CASCADE
END
;
BEGIN
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT
TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUP_ID)
REFERENCES TURBINE_GROUP
(GROUP_ID)
ON DELETE CASCADE
END
;
BEGIN
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID)
REFERENCES
TURBINE_ROLE (ROLE_ID)
ON DELETE CASCADE
END
;
/*
---------------------------------------------------------------------- */
/*
JETSPEED_USER_PROFILE */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'JETSPEED_USER_PROFILE')
BEGIN
DECLARE @reftable_11 nvarchar(60), @constraintname_11 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
= 'JETSPEED_USER_PROFILE'
OPEN refcursor
FETCH NEXT from refcursor into
@reftable_11, @constraintname_11
while @@FETCH_STATUS = 0
BEGIN
exec
('alter table '+@reftable_11+' drop constraint '+@constraintname_11)
FETCH NEXT
from refcursor into @reftable_11, @constraintname_11
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE JETSPEED_USER_PROFILE
END
CREATE TABLE
JETSPEED_USER_PROFILE
(
PSML_ID INT NOT NULL IDENTITY (1,1),
USER_NAME VARCHAR (32) NOT NULL,
MEDIA_TYPE VARCHAR (99) NULL,
LANGUAGE VARCHAR (2) NULL,
COUNTRY VARCHAR (2) NULL,
PAGE
VARCHAR (99) NULL,
PROFILE BINARY NULL,
CONSTRAINT
JETSPEED_USER_PROFILE_PK PRIMARY KEY(PSML_ID),
UNIQUE (USER_NAME, MEDIA_TYPE,
LANGUAGE, COUNTRY, PAGE));
/*
---------------------------------------------------------------------- */
/*
JETSPEED_GROUP_PROFILE */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'JETSPEED_GROUP_PROFILE')
BEGIN
DECLARE @reftable_12 nvarchar(60), @constraintname_12 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
= 'JETSPEED_GROUP_PROFILE'
OPEN refcursor
FETCH NEXT from refcursor into
@reftable_12, @constraintname_12
while @@FETCH_STATUS = 0
BEGIN
exec
('alter table '+@reftable_12+' drop constraint '+@constraintname_12)
FETCH NEXT
from refcursor into @reftable_12, @constraintname_2
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE JETSPEED_GROUP_PROFILE
END
CREATE TABLE
JETSPEED_GROUP_PROFILE
(
PSML_ID INT NOT NULL IDENTITY (1,1),
GROUP_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99) NULL,
LANGUAGE VARCHAR (2) NULL,
COUNTRY VARCHAR (2) NULL,
PAGE
VARCHAR (99) NULL,
PROFILE BINARY NULL,
CONSTRAINT
JETSPEED_GROUP_PROFILE_PK PRIMARY KEY(PSML_ID),
UNIQUE (GROUP_NAME, MEDIA_TYPE,
LANGUAGE, COUNTRY, PAGE));
/*
---------------------------------------------------------------------- */
/*
JETSPEED_ROLE_PROFILE */
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'JETSPEED_ROLE_PROFILE')
BEGIN
DECLARE @reftable_13 nvarchar(60), @constraintname_13 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
= 'JETSPEED_ROLE_PROFILE'
OPEN refcursor
FETCH NEXT from refcursor into
@reftable_13, @constraintname_13
while @@FETCH_STATUS = 0
BEGIN
exec
('alter table '+@reftable_13+' drop constraint '+@constraintname_13)
FETCH NEXT
from refcursor into @reftable_13, @constraintname_13
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE JETSPEED_ROLE_PROFILE
END
CREATE TABLE
JETSPEED_ROLE_PROFILE
(
PSML_ID INT NOT NULL IDENTITY (1,1),
ROLE_NAME VARCHAR (99) NOT NULL,
MEDIA_TYPE VARCHAR (99) NULL,
LANGUAGE VARCHAR (2) NULL,
COUNTRY VARCHAR (2) NULL,
PAGE
VARCHAR (99) NULL,
PROFILE BINARY NULL,
CONSTRAINT
JETSPEED_ROLE_PROFILE_PK PRIMARY KEY(PSML_ID),
UNIQUE (ROLE_NAME, MEDIA_TYPE,
LANGUAGE, COUNTRY, PAGE));
/*
---------------------------------------------------------------------- */
/* COFFEES
*/
/*
---------------------------------------------------------------------- */
IF EXISTS
(SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'COFFEES')
BEGIN
DECLARE
@reftable_14 nvarchar(60), @constraintname_14 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 =
'COFFEES'
OPEN refcursor
FETCH NEXT from refcursor into @reftable_14,
@constraintname_14
while @@FETCH_STATUS = 0
BEGIN
exec ('alter table
'+@reftable_14+' drop constraint '+@constraintname_14)
FETCH NEXT from
refcursor into @reftable_14, @constraintname_14
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE COFFEES
END
CREATE TABLE COFFEES
(
COF_NAME VARCHAR (50) NULL,
SUP_ID INT NULL,
PRICE FLOAT NULL,
SALES INT NULL,
TOTAL INT NULL,
);
\ No newline at end of file
1.34 +0 -0 jakarta-jetspeed/webapp/WEB-INF/conf/JetspeedSecurity.properties
Index: JetspeedSecurity.properties
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed/webapp/WEB-INF/conf/JetspeedSecurity.properties,v
retrieving revision 1.33
retrieving revision 1.34
diff -u -r1.33 -r1.34
1.5 +10 -1 jakarta-jetspeed/webapp/WEB-INF/conf/Torque.properties
Index: Torque.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/conf/Torque.properties,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- Torque.properties 18 Oct 2002 00:50:11 -0000 1.4
+++ Torque.properties 18 Oct 2002 19:16:32 -0000 1.5
@@ -46,6 +46,7 @@
torque.database.default.adapter=hypersonic
### torque.database.default.adapter=mysql
### torque.database.default.adapter=oracle
+### torque.database.default.adapter=mssql
##
## Using torque's old pool
@@ -54,6 +55,7 @@
torque.dsfactory.default.connection.url =
jdbc:HypersonicSQL:${webappRoot}/WEB-INF/db/jetspeed
torque.dsfactory.default.connection.user = sa
torque.dsfactory.default.connection.password =
+
torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
# The number of database connections to cache per ConnectionPool instance
(specified per database)
torque.dsfactory.default.pool.defaultMaxConnections=10
@@ -69,6 +71,13 @@
### torque.dsfactory.default.connection.url = jdbc:oracle:thin:@server:1521:sid
### torque.dsfactory.default.connection.user = jetspeed
### torque.dsfactory.default.connection.password = password
+### Microsoft SQL
+### torque.dsfactory.default.connection.driver = net.avenir.jdbc3.Driver
+### torque.dsfactory.default.connection.url = jdbc:
AvenirDriver://localhost:1433/jetspeed
+### torque.dsfactory.default.connection.user = jetspeed
+### torque.dsfactory.default.connection.password = jetspeed
+
+
# The interval (in milliseconds) between which the PoolBrokerService logs
# the status of it's ConnectionPools.
1.20 +1 -1 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties
Index: jetspeed.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- jetspeed.properties 17 Oct 2002 21:11:01 -0000 1.19
+++ jetspeed.properties 18 Oct 2002 19:16:32 -0000 1.20
@@ -1,4 +1,4 @@
#Hypersonic SQL database
-#Thu Oct 17 13:22:20 PDT 2002
+#Fri Oct 18 12:09:24 PDT 2002
version=1.4
modified=yes
1.22 +5 -4 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script
Index: jetspeed.script
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -r1.21 -r1.22
--- jetspeed.script 17 Oct 2002 21:11:01 -0000 1.21
+++ jetspeed.script 18 Oct 2002 19:16:32 -0000 1.22
@@ -123,10 +123,11 @@
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(3,1,3)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(560,1,1)
-INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',440,10)
-INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',520,10)
-INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',450,10)
-INSERT INTO ID_TABLE VALUES(4,'TURBINE_USER',570,10)
+INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(570,1,1)
+INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',450,10)
+INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',530,10)
+INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',460,10)
+INSERT INTO ID_TABLE VALUES(4,'TURBINE_USER',580,10)
INSERT INTO ID_TABLE VALUES(5,'TURBINE_SCHEDULED_JOB',100,10)
INSERT INTO ID_TABLE VALUES(6,'TURBINE_ROLE_PERMISSION',100,10)
INSERT INTO ID_TABLE VALUES(7,'TURBINE_USER_GROUP_ROLE',100,10)
--
To unsubscribe, e-mail: <mailto:jetspeed-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@;jakarta.apache.org>
