changes: * removed all blobs * renamed TURBINE_GROUP to TURBINE_PROJECT * added tables to handle attributes (to replace user.perm-storage, job.properties) I propose to generate the om/peer classes to org.apache.turbine.om martin <?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, security, and job scheduling. --> <!-- ======================================================================= --> <!-- @author: <a href="mailto:[EMAIL PROTECTED]";>Jason van Zyl</a> --> <!-- @version $Id: turbine-schema.xml,v 1.20 2001/06/27 20:32:59 jon Exp $ --> <!-- ======================================================================= --> <database defaultIdMethod="idbroker"> <table name="TURBINE_PERMISSION"> <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"> <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_PROJECT"> <column name="PROJECT_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="PROJECT_NAME" required="true" type="VARCHAR" size="99" javaName="Name"/> <unique> <unique-column name="PROJECT_NAME"/> </unique> </table> <table name="TURBINE_ROLE_PERMISSION" idMethod="none"> <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"> <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"/> <unique> <unique-column name="LOGIN_NAME"/> </unique> </table> <table name="TURBINE_USER_PROJECT_ROLE" idMethod="none"> <column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="PROJECT_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_PROJECT"> <reference local="PROJECT_ID" foreign="PROJECT_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_ROLE"> <reference local="ROLE_ID" foreign="ROLE_ID"/> </foreign-key> </table> <table name="TURBINE_SCHEDULED_JOB"> <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"/> </table> <table name="TURBINE_ATTRIBUTE"> <column name="ATTRIBUTE_ID" primaryKey="true" required="true" type="INTEGER"/> <column name="ATTRIBUTE_NAME" javaName="Name" required="true" type="VARCHAR" size="255"/> <column name="ATTRIBUTE_TYPE_ID" javaName="TypeId" required="true" type="INTEGER"/> <column name="PERMISSION" required="false" type="VARCHAR" size="255"/> <column name="REQUIRED_OPTION_ID" type="INTEGER"/> <column name="DESCRIPTION" javaName="Description" required="true" type="VARCHAR" size="255"/> <column name="CREATED_BY" javaName="CreatedBy" required="false" type="INTEGER"/> <column name="CREATED_DATE" javaName="CreatedDate" required="false" type="TIMESTAMP"/> <column name="DELETED" required="false" type="BOOLEANINT" default="0" size="1"/> <foreign-key foreignTable="TURBINE_ATTRIBUTE_TYPE"> <reference local="ATTRIBUTE_TYPE_ID" foreign="ATTRIBUTE_TYPE_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_ATTRIBUTE_OPTION"> <reference local="REQUIRED_OPTION_ID" foreign="OPTION_ID"/> </foreign-key> </table> <table name="TURBINE_ATTRIBUTE_CLASS"> <column name="ATTRIBUTE_CLASS_ID" primaryKey="true" required="true" type="INTEGER"/> <column name="ATTRIBUTE_CLASS_NAME" javaName="Name" required="true" type="VARCHAR" size="255"/> <column name="ATTRIBUTE_CLASS_DESC" javaName="Desc" required="true" type="VARCHAR" size="255"/> <column name="JAVA_CLASS_NAME" required="false" type="VARCHAR" size="255"/> </table> <table name="TURBINE_ATTRIBUTE_OPTION"> <column name="OPTION_ID" primaryKey="true" required="true" type="INTEGER"/> <column name="ATTRIBUTE_ID" required="true" type="INTEGER"/> <column name="OPTION_NAME" javaName="Name" required="true" type="VARCHAR" size="255"/> <column name="NUMERIC_VALUE" required="false" type="INTEGER"/> <column name="DELETED" required="false" type="BOOLEANINT" default="0" size="1"/> <foreign-key foreignTable="TURBINE_ATTRIBUTE"> <reference local="ATTRIBUTE_ID" foreign="ATTRIBUTE_ID"/> </foreign-key> </table> <table name="TURBINE_ATTRIBUTE_TYPE"> <column name="ATTRIBUTE_TYPE_ID" primaryKey="true" required="true" type="INTEGER"/> <column name="ATTRIBUTE_CLASS_ID" javaName="ClassId" required="true" type="INTEGER"/> <column name="ATTRIBUTE_TYPE_NAME" javaName="Name" required="true" type="VARCHAR" size="255"/> <column name="JAVA_CLASS_NAME" required="false" type="VARCHAR" size="255"/> <column name="VALIDATION_KEY" required="false" type="VARCHAR" size="20"/> <foreign-key foreignTable="TURBINE_ATTRIBUTE_CLASS"> <reference local="ATTRIBUTE_CLASS_ID" foreign="ATTRIBUTE_CLASS_ID"/> </foreign-key> </table> <table name="TURBINE_USER_ATTRIBUTE"> <column name="ATTRIBUTE_ID" primaryKey="true" required="true" type="INTEGER" inheritance="single"/> <column name="OPTION_ID" required="false" type="INTEGER"/> <column name="DELETED" required="false" type="BOOLEANINT" default="0" size="1"/> <foreign-key foreignTable="TURBINE_ATTRIBUTE"> <reference local="ATTRIBUTE_ID" foreign="ATTRIBUTE_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_ATTRIBUTE_OPTION"> <reference local="OPTION_ID" foreign="OPTION_ID"/> </foreign-key> </table> <table name="TURBINE_USER_ATTRIBUTE_VALUE"> <column name="USER_ID" primaryKey="true" required="true" type="INTEGER"/> <column name="TURBINE_USER_ATTRIBUTE_ID" primaryKey="true" required="true" type="INTEGER" inheritance="single"/> <column name="VALUE" required="false" type="VARCHAR" size="255"/> <foreign-key foreignTable="TURBINE_USER"> <reference local="USER_ID" foreign="USER_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_USER_ATTRIBUTE"> <reference local="TURBINE_USER_ATTRIBUTE_ID" foreign="ATTRIBUTE_ID"/> </foreign-key> </table> <table name="TURBINE_JOB_ATTRIBUTE"> <column name="ATTRIBUTE_ID" primaryKey="true" required="true" type="INTEGER" inheritance="single"/> <column name="OPTION_ID" required="false" type="INTEGER"/> <column name="DELETED" required="false" type="BOOLEANINT" default="0" size="1"/> <foreign-key foreignTable="TURBINE_ATTRIBUTE"> <reference local="ATTRIBUTE_ID" foreign="ATTRIBUTE_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_ATTRIBUTE_OPTION"> <reference local="OPTION_ID" foreign="OPTION_ID"/> </foreign-key> </table> <table name="TURBINE_JOB_ATTRIBUTE_VALUE"> <column name="JOB_ID" primaryKey="true" required="true" type="INTEGER"/> <column name="TURBINE_JOB_ATTRIBUTE_ID" primaryKey="true" required="true" type="INTEGER" inheritance="single"/> <column name="VALUE" required="false" type="VARCHAR" size="255"/> <foreign-key foreignTable="TURBINE_SCHEDULED_JOB"> <reference local="JOB_ID" foreign="JOB_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_JOB_ATTRIBUTE"> <reference local="TURBINE_JOB_ATTRIBUTE_ID" foreign="ATTRIBUTE_ID"/> </foreign-key> </table> </database> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
