You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by jv...@apache.org on 2001/08/31 08:50:35 UTC
cvs commit: jakarta-turbine-fulcrum scheduler-schema.xml turbine-schema.xml build.properties
jvanzyl 01/08/30 23:50:35
Modified: . build.properties
Added: . scheduler-schema.xml turbine-schema.xml
Log:
- place the security service schema and the scheduler service schema
in the base fulcrum directory for now.
eventually each of these schemas will reside in the build directory
for the respective service, but this decouples the fulcrum build
from the turbine repo for now.
Revision Changes Path
1.15 +1 -3 jakarta-turbine-fulcrum/build.properties
Index: build.properties
===================================================================
RCS file: /home/cvs/jakarta-turbine-fulcrum/build.properties,v
retrieving revision 1.14
retrieving revision 1.15
diff -u -r1.14 -r1.15
--- build.properties 2001/08/23 07:20:21 1.14
+++ build.properties 2001/08/31 06:50:35 1.15
@@ -15,8 +15,6 @@
build.dir = ./bin
build.src = ${build.dir}/src
src.dir = ./src
-turbine.dir = ${basedir}/../jakarta-turbine-3
-turbine.conf.dir = ${turbine.dir}/conf
torque.dir = ${basedir}/../jakarta-turbine-torque
docs.src = ./xdocs
@@ -65,7 +63,7 @@
basePrefix=Base
templatePath = ${torque.dir}/src/templates
-schemaDirectory=${turbine.conf.dir}/master
+schemaDirectory=.
SQLControlTemplate = sql/base/Control.vm
OMControlTemplate = om/Control.vm
1.1 jakarta-turbine-fulcrum/scheduler-schema.xml
Index: scheduler-schema.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd">
<!-- ==================================================================== -->
<!-- -->
<!-- S C H E D U L E R T U R B I N E S C H E M A -->
<!-- -->
<!-- ==================================================================== -->
<!-- This is the the XML schema used by Torque to generate the necessary -->
<!-- sources used to create/initialize the Turbine scheduler service. -->
<!-- Torque will create the SQL for the database, and the Peer-based -->
<!-- Object Model. -->
<!-- ==================================================================== -->
<!-- @author: <a href="mailto:jvanzyl@apache.org">Jason van Zyl</a> -->
<!-- @version $Id: scheduler-schema.xml,v 1.1 2001/08/31 06:50:35 jvanzyl Exp $ -->
<!-- ==================================================================== -->
<database>
<table name="TURBINE_SCHEDULED_JOB" idMethod="idbroker" javaName="JobEntry">
<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"/>
<column name="HOUR" default="-1" required="true" type="INTEGER"/>
<column name="WEEK_DAY" default="-1" required="true" type="INTEGER"/>
<column name="DAY_OF_MONTH" default="-1" required="true" type="INTEGER"/>
<column name="TASK" required="true" size="99" type="VARCHAR"/>
<column name="EMAIL" size="99" type="VARCHAR"/>
<column name="PROPERTY" type="VARBINARY"/>
</table>
</database>
1.1 jakarta-turbine-fulcrum/turbine-schema.xml
Index: turbine-schema.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd">
<!-- ==================================================================== -->
<!-- -->
<!-- B A S E T U R B I N E S C H E M A -->
<!-- -->
<!-- ==================================================================== -->
<!-- This is the the XML schema used by Torque to generate the necessary -->
<!-- sources used to create/initialize the base Turbine system. Torque -->
<!-- will create the SQL for the database required by Turbine, and the -->
<!-- Peer-based Object Model used by Turbine internally to manage -->
<!-- users and security. -->
<!-- ==================================================================== -->
<!-- @author: <a href="mailto:jvanzyl@apache.org">Jason van Zyl</a> -->
<!-- @version $Id: turbine-schema.xml,v 1.1 2001/08/31 06:50:35 jvanzyl Exp $ -->
<!-- ==================================================================== -->
<database>
<table name="TURBINE_PERMISSION" idMethod="idbroker">
<column name="PERMISSION_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="PERMISSION_NAME" required="true" size="99" type="VARCHAR" javaName="Name"/>
<unique>
<unique-column name="PERMISSION_NAME"/>
</unique>
</table>
<table name="TURBINE_ROLE" idMethod="idbroker">
<column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="ROLE_NAME" required="true" size="99" type="VARCHAR" javaName="Name"/>
<unique>
<unique-column name="ROLE_NAME"/>
</unique>
</table>
<table name="TURBINE_GROUP" idMethod="idbroker">
<column name="GROUP_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="GROUP_NAME" required="true" type="VARCHAR" size="99" javaName="Name"/>
<unique>
<unique-column name="GROUP_NAME"/>
</unique>
</table>
<table name="TURBINE_ROLE_PERMISSION">
<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">
<reference local="ROLE_ID" foreign="ROLE_ID"/>
</foreign-key>
<foreign-key foreignTable="TURBINE_PERMISSION">
<reference local="PERMISSION_ID" foreign="PERMISSION_ID"/>
</foreign-key>
</table>
<table name="TURBINE_USER" idMethod="idbroker">
<column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="LOGIN_NAME" required="true" size="32" type="VARCHAR" javaName="UserName"/>
<column name="PASSWORD_VALUE" required="true" size="32" type="VARCHAR" javaName="Password"/>
<column name="FIRST_NAME" required="true" size="99" type="VARCHAR"/>
<column name="LAST_NAME" required="true" size="99" type="VARCHAR"/>
<column name="EMAIL" size="99" type="VARCHAR"/>
<column name="CONFIRM_VALUE" size="99" type="VARCHAR" javaName="Confirmed"/>
<column name="MODIFIED" type="TIMESTAMP"/>
<column name="CREATED" type="TIMESTAMP" javaName="CreateDate"/>
<column name="LAST_LOGIN" type="TIMESTAMP"/>
<column name="OBJECTDATA" type="VARBINARY"/>
<unique>
<unique-column name="LOGIN_NAME"/>
</unique>
</table>
<table name="TURBINE_USER_GROUP_ROLE">
<column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="GROUP_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="ROLE_ID" required="true" primaryKey="true" type="INTEGER"/>
<foreign-key foreignTable="TURBINE_USER">
<reference local="USER_ID" foreign="USER_ID"/>
</foreign-key>
<foreign-key foreignTable="TURBINE_GROUP">
<reference local="GROUP_ID" foreign="GROUP_ID"/>
</foreign-key>
<foreign-key foreignTable="TURBINE_ROLE">
<reference local="ROLE_ID" foreign="ROLE_ID"/>
</foreign-key>
</table>
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org