taylor 2002/06/20 17:04:17
Modified: build/torque/schema Tag: security_14 turbine-schema.xml
Removed: build/torque/schema Tag: security_14 dbpsml-schema.xml
project-schema.xml
Log:
cleanup up db scripts. Security-schema.xml is now the default torque script.
Revision Changes Path
No revision
No revision
1.2.2.1 +1 -85 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.2
retrieving revision 1.2.2.1
diff -u -r1.2 -r1.2.2.1
--- turbine-schema.xml 25 Feb 2002 04:15:23 -0000 1.2
+++ turbine-schema.xml 21 Jun 2002 00:04:17 -0000 1.2.2.1
@@ -18,90 +18,6 @@
<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="99" type="VARCHAR"/>
- <column name="OBJECTDATA" type="VARBINARY"/>
-
- <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"/>
- <column name="OBJECTDATA" type="VARBINARY"/>
-
- <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"/>
- <column name="OBJECTDATA" type="VARBINARY"/>
-
- <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"/>
- <column name="PASSWORD_VALUE" required="true" size="32" type="VARCHAR"/>
- <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"/>
- <column name="MODIFIED" type="TIMESTAMP"/>
- <column name="CREATED" type="TIMESTAMP"/>
- <column name="LAST_LOGIN" type="TIMESTAMP"/>
- <column name="DISABLED" size="1" type="CHAR"/>
- <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>
-
<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"/>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
