Index: ./conf/master/turbine-schema.xml =================================================================== RCS file: /home/cvs/jakarta-turbine/conf/master/turbine-schema.xml,v retrieving revision 1.20 diff -u -r1.20 turbine-schema.xml --- ./conf/master/turbine-schema.xml 2001/06/27 20:32:59 1.20 +++ ./conf/master/turbine-schema.xml 2001/07/10 00:12:33 @@ -1,73 +1,78 @@ <?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> - - <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"/> - <column name="OBJECTDATA" type="VARBINARY"/> - +<!-- ======================================================================= --> +<!-- --> +<!-- 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> - + </unique> </table> - <table name="TURBINE_ROLE" idMethod="idbroker"> + + <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"/> - <column name="OBJECTDATA" type="VARBINARY"/> - + <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"/> - <column name="OBJECTDATA" type="VARBINARY"/> - + + <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="GROUP_NAME"/> + <unique-column name="PROJECT_NAME"/> </unique> - </table> - - <table name="TURBINE_ROLE_PERMISSION"> + + + <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"/> - + <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"> + + + <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="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"/> @@ -75,25 +80,24 @@ <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> - + </unique> </table> + - <table name="TURBINE_USER_GROUP_ROLE"> + <table name="TURBINE_USER_PROJECT_ROLE" idMethod="none"> <column name="USER_ID" required="true" primaryKey="true" type="INTEGER"/> - <column name="GROUP_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_GROUP"> - <reference local="GROUP_ID" foreign="GROUP_ID"/> + <foreign-key foreignTable="TURBINE_PROJECT"> + <reference local="PROJECT_ID" foreign="PROJECT_ID"/> </foreign-key> <foreign-key foreignTable="TURBINE_ROLE"> @@ -101,7 +105,8 @@ </foreign-key> </table> - <table name="TURBINE_SCHEDULED_JOB" idMethod="idbroker"> + + <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"/> @@ -111,6 +116,107 @@ <column name="TASK" required="true" size="99" type="VARCHAR"/> <column name="EMAIL" size="99" type="VARCHAR"/> <column name="PROPERTY" type="VARBINARY"/> + </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> </database> The command completed successfully. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
