morciuch 2004/04/05 08:00:12
Added: src/torque-schema turbine-schema.xml security-schema.xml
email.xml dbpsml-schema.xml coffees-schema.xml
Log:
Initial check in
Revision Changes Path
1.1 jakarta-jetspeed/src/torque-schema/turbine-schema.xml
Index: turbine-schema.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!--
Copyright 2004 The Apache Software Foundation
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.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.1 2004/04/05 15:00:12 morciuch Exp $
-->
<!-- ==================================================================== -->
<database package="org.apache.jetspeed.om.apps.turbine">
<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"/>
<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="BINARY"/>
</table>
<table name="ID_TABLE" idMethod="idbroker">
<column name="ID_TABLE_ID" required="true" primaryKey="true"
type="INTEGER"/>
<column name="TABLE_NAME" required="true" size="255" type="VARCHAR"/>
<column name="NEXT_ID" type="INTEGER"/>
<column name="QUANTITY" type="INTEGER"/>
<unique>
<unique-column name="TABLE_NAME"/>
</unique>
</table>
</database>
1.1 jakarta-jetspeed/src/torque-schema/security-schema.xml
Index: security-schema.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!--
Copyright 2004 The Apache Software Foundation
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";>
<!-- ==================================================================== -->
<!-- -->
<!-- B A S E J E T S P E E D S E C U R I T Y 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 Jetspeed default security -->
<!-- Torque creates SQL for the database required by Jetspeed, and the -->
<!-- Peer-based Object Model used by Jetspeed internally to manage -->
<!-- users, and security. -->
<!-- ==================================================================== -->
<!-- @author: <a href="mailto:[EMAIL PROTECTED]">David Sean Taylor</a> -->
<!-- @version $Id: security-schema.xml,v 1.1 2004/04/05 15:00:12 morciuch Exp $ -->
<!-- ==================================================================== -->
<database package="org.apache.jetspeed.om.security.turbine">
<table name="TURBINE_USER" idMethod="native">
<column name="USER_ID" required="true" primaryKey="true"
autoIncrement="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="BINARY"/>
<column name="PASSWORD_CHANGED" type="TIMESTAMP"/>
<unique>
<unique-column name="LOGIN_NAME"/>
</unique>
</table>
<table name="TURBINE_ROLE" idMethod="native">
<column name="ROLE_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="ROLE_NAME" required="true" size="99" type="VARCHAR"/>
<column name="OBJECTDATA" type="BINARY"/>
<unique>
<unique-column name="ROLE_NAME"/>
</unique>
</table>
<table name="TURBINE_GROUP" idMethod="native">
<column name="GROUP_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="GROUP_NAME" required="true" type="VARCHAR" size="99"/>
<column name="OBJECTDATA" type="BINARY"/>
<unique>
<unique-column name="GROUP_NAME"/>
</unique>
</table>
<table name="TURBINE_PERMISSION" idMethod="native">
<column name="PERMISSION_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="PERMISSION_NAME" required="true" size="99"
type="VARCHAR"/>
<column name="OBJECTDATA" type="BINARY"/>
<unique>
<unique-column name="PERMISSION_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" onDelete="cascade">
<reference local="ROLE_ID" foreign="ROLE_ID"/>
</foreign-key>
<foreign-key foreignTable="TURBINE_PERMISSION" onDelete="cascade">
<reference local="PERMISSION_ID" foreign="PERMISSION_ID"/>
</foreign-key>
</table>
<table name="TURBINE_USER_GROUP_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="ROLE_ID" required="true" primaryKey="true"
type="INTEGER"/>
<foreign-key foreignTable="TURBINE_USER" onDelete="cascade">
<reference local="USER_ID" foreign="USER_ID"/>
</foreign-key>
<foreign-key foreignTable="TURBINE_GROUP" onDelete="cascade">
<reference local="GROUP_ID" foreign="GROUP_ID"/>
</foreign-key>
<foreign-key foreignTable="TURBINE_ROLE" onDelete="cascade">
<reference local="ROLE_ID" foreign="ROLE_ID"/>
</foreign-key>
</table>
</database>
1.1 jakarta-jetspeed/src/torque-schema/email.xml
Index: email.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!--
Copyright 2004 The Apache Software Foundation
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";>
<!-- ==================================================================== -->
<!-- -->
<!-- T U R B I N E P R O J E C T S C H E M A -->
<!-- -->
<!-- ==================================================================== -->
<!-- This is an example Turbine project schema. -->
<!-- ==================================================================== -->
<database package="org.apache.jetspeed.om.apps.email">
<!-- EmailInbox -->
<table name="EMAIL_INBOX" idMethod="idbroker">
<column name="EMAIL_INBOX_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
<column name="MESSAGE_ID" size="255" type="VARCHAR"/>
<column name="FILENAME" size="255" type="VARCHAR"/>
<column name="ATTACHMENT" type="BLOB"/>
<column name="READFLAG" type="INTEGER"/>
</table>
</database>
1.1 jakarta-jetspeed/src/torque-schema/dbpsml-schema.xml
Index: dbpsml-schema.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!--
Copyright 2004 The Apache Software Foundation
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";>
<!-- ==================================================================== -->
<!-- -->
<!-- B A S E J E T S P E E D S E C U R I T Y 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 Jetspeed default security -->
<!-- Torque creates SQL for the database required by Jetspeed, and the -->
<!-- Peer-based Object Model used by Jetspeed internally to manage -->
<!-- users, and security. -->
<!-- ==================================================================== -->
<!-- @author: <a href="mailto:[EMAIL PROTECTED]">David Sean Taylor</a> -->
<!-- @version $Id: dbpsml-schema.xml,v 1.1 2004/04/05 15:00:12 morciuch Exp $ -->
<!-- ==================================================================== -->
<database package="org.apache.jetspeed.om.dbpsml">
<table name="JETSPEED_USER_PROFILE" idMethod="native">
<column name="PSML_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="USER_NAME" required="true" size="32" type="VARCHAR"/>
<column name="MEDIA_TYPE" size="99" type="VARCHAR"/>
<column name="LANGUAGE" size="2" type="VARCHAR"/>
<column name="COUNTRY" size="2" type="VARCHAR"/>
<column name="PAGE" size="99" type="VARCHAR"/>
<column name="PROFILE" type="BINARY"/>
<unique name="JETSPEED_USER_PROFILE_UNIQUE">
<unique-column name="USER_NAME"/>
<unique-column name="MEDIA_TYPE"/>
<unique-column name="LANGUAGE"/>
<unique-column name="COUNTRY"/>
<unique-column name="PAGE"/>
</unique>
</table>
<table name="JETSPEED_GROUP_PROFILE" idMethod="native">
<column name="PSML_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="GROUP_NAME" required="true" size="99" type="VARCHAR"/>
<column name="MEDIA_TYPE" size="99" type="VARCHAR"/>
<column name="LANGUAGE" size="2" type="VARCHAR"/>
<column name="COUNTRY" size="2" type="VARCHAR"/>
<column name="PAGE" size="99" type="VARCHAR"/>
<column name="PROFILE" type="BINARY"/>
<unique name="JETSPEED_GROUP_PROFILE_UNIQUE">
<unique-column name="GROUP_NAME"/>
<unique-column name="MEDIA_TYPE"/>
<unique-column name="LANGUAGE"/>
<unique-column name="COUNTRY"/>
<unique-column name="PAGE"/>
</unique>
</table>
<table name="JETSPEED_ROLE_PROFILE" idMethod="native">
<column name="PSML_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="ROLE_NAME" required="true" size="99" type="VARCHAR"/>
<column name="MEDIA_TYPE" size="99" type="VARCHAR"/>
<column name="LANGUAGE" size="2" type="VARCHAR"/>
<column name="COUNTRY" size="2" type="VARCHAR"/>
<column name="PAGE" size="99" type="VARCHAR"/>
<column name="PROFILE" type="BINARY"/>
<unique name="JETSPEED_ROLE_PROFILE_UNIQUE">
<unique-column name="ROLE_NAME"/>
<unique-column name="MEDIA_TYPE"/>
<unique-column name="LANGUAGE"/>
<unique-column name="COUNTRY"/>
<unique-column name="PAGE"/>
</unique>
</table>
</database>
1.1 jakarta-jetspeed/src/torque-schema/coffees-schema.xml
Index: coffees-schema.xml
===================================================================
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!--
Copyright 2004 The Apache Software Foundation
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";>
<!-- ==================================================================== -->
<!-- -->
<!-- DatabaseBrowser coffees example S C H E M A -->
<!-- -->
<!-- ==================================================================== -->
<!--
Note: the name= attribute in the database tag represents what
you would use to map to a specific database named in the
TurbineResources.properties file. If you just want to use
the defaults, please do not specify a name= attribute.
The benefit is that you can have one database talking to
one system and another talking to an entirely different
system.
Example:
database.INTERPLANETARY.driver=org.postgresql.Driver
database.INTERPLANETARY.url=jdbc:postgresql:test
database.INTERPLANETARY.username=graeme
database.INTERPLANETARY.password=password
database.SIMPLE.driver=org.postgresql.Driver
database.SIMPLE.url=jdbc:postgresql:foo
database.SIMPLE.username=foo
database.SIMPLE.password=bar
-->
<database package="org.apache.jetspeed.om.apps.coffees">
<table name="COFFEES" idMethod="native">
<column name="COFFEE_ID" required="true" primaryKey="true"
autoIncrement="true" type="INTEGER"/>
<column name="COFFEE_NAME" type="VARCHAR" size="50"/>
<column name="SUPPLIER_ID" type="INTEGER"/>
<column name="PRICE" type="FLOAT"/>
<column name="SALES" type="INTEGER"/>
<column name="TOTAL" type="INTEGER"/>
</table>
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
