db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Dudziak <tom...@gmail.com>
Subject Re: oracle database model dangerously broken
Date Tue, 31 Jan 2006 17:31:03 GMT
On 1/31/06, Tim Dudgeon <tdudgeon@informaticsmatters.com> wrote:
> <database name="test">
>     <table name="MY_TABLE">
>       <column name="PROP_NAME" primaryKey="true" required="true"
> type="VARCHAR" size="200" autoIncrement="false"/>
>       <column name="PROP_VALUE" primaryKey="false" required="false"
> type="VARCHAR" size="200" autoIncrement="false"/>
>       <column name="PROP_VALUE_EXT" primaryKey="false" required="false"
> type="LONGVARBINARY" size="0" autoIncrement="false"/>
>     </table>
>   </database>
>
> this was the DDL that created it.
>
> CREATE TABLE MY_TABLE(
>     prop_name VARCHAR2(200) NOT NULL PRIMARY KEY,
>     prop_value VARCHAR2(200),
>     prop_value_ext LONG RAW NULL
> )

Ok, cool, I'll test that.

Tom

Mime
View raw message