henning 2003/02/18 07:56:45 Added: src/schema torque-security-schema.xml Log: add schema for the Torque Security Service Revision Changes Path 1.1 jakarta-turbine-2/src/schema/torque-security-schema.xml Index: torque-security-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:[EMAIL PROTECTED]";>Henning P. Schmiedehausen</a> --> <!-- @version $Id: torque-security-schema.xml,v 1.1 2003/02/18 15:56:44 henning Exp $ --> <!-- ==================================================================== --> <database name="@DATABASE_DEFAULT@"> <table name="TURBINE_PERMISSION" idMethod="idbroker"> <column name="PERMISSION_ID" required="true" primaryKey="true" type="INTEGER"/> <column name="PERMISSION_NAME" required="true" size="64" 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="64" 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="64" 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="64" type="VARCHAR" javaName="UserName"/> <column name="PASSWORD_VALUE" required="true" size="16" type="VARCHAR" javaName="Password"/> <column name="FIRST_NAME" required="true" size="64" type="VARCHAR"/> <column name="LAST_NAME" required="true" size="64" type="VARCHAR"/> <column name="EMAIL" size="64" type="VARCHAR"/> <column name="CONFIRM_VALUE" size="16" 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
