Here is a SAP DB schema that I've been working with recently - I have not tried all of
the
elements so if anyone uses it and finds a problem - post it back to the list with the
fix....for
instance
I am not sure about some of the date/time stuff, among other things...
Cheers
Ray Harrison
<?xml version="1.0"?>
<!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
"http://www.orionserver.com/dtds/database-schemas.dtd">
<database-schema name="SapDB" not-null="not null" null="" primary-key="primary key"
max-table-name-lenght="32">
<type-mapping type="boolean" name="boolean" />
<type-mapping type="java.lang.Boolean" name="boolean" />
<type-mapping type="byte" name="byte" />
<type-mapping type="java.lang.Byte" name="byte" />
<type-mapping type="char" name="char" />
<type-mapping type="java.lang.Character" name="char" />
<type-mapping type="double" name="double precision" />
<type-mapping type="java.lang.Double" name="double precision" />
<type-mapping type="float" name="float" />
<type-mapping type="java.lang.Float" name="float" />
<type-mapping type="int" name="integer" />
<type-mapping type="java.lang.Integer" name="integer" />
<type-mapping type="long" name="integer" />
<type-mapping type="java.lang.Long" name="integer" />
<type-mapping type="short" name="smallint" />
<type-mapping type="java.lang.Short" name="smallint" />
<type-mapping type="java.lang.String" name="varchar(255)" />
<type-mapping type="java.math.BigDecimal" name="fixed(15,15)" />
<type-mapping type="byte[]" name="long byte" />
<type-mapping type="java.sql.Date" name="date" />
<type-mapping type="java.sql.Time" name="time" />
<type-mapping type="java.sql.Timestamp" name="timestamp" />
<type-mapping type="java.util.Date" name="timestamp" />
<type-mapping type="java.io.Serializable" name="long byte" />
<disallowed-field name="key" />
<disallowed-field name="date" />
<disallowed-field name="timestamp" />
<disallowed-field name="time" />
<disallowed-field name="username" />
<disallowed-field name="password" />
<disallowed-field name="order" />
<disallowed-field name="table" />
</database-schema>
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/