db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jun Li" <allanju...@gmail.com>
Subject Re: The DB created from XML has one more index for every table.
Date Sun, 19 Mar 2006 22:24:18 GMT
Tom,

Have you worked it out?

Thanks.


On 3/13/06, Jun Li <allanjunli@gmail.com> wrote:
>
>
>
> On 3/13/06, Thomas Dudziak <tomdzk@gmail.com> wrote:
> >
> > On 3/13/06, Jun Li <allanjunli@gmail.com> wrote:
> >
> > > I've reported this issue before, but I tried this with the latest
> > source
> > > just now, it hasn't been fixed from what I saw.
> > > I'm using SQL Server 2000, trying to create databases from XML file. I
> > tried
> > > with SQL Server 2005 JDBC driver also, just hasn't get it right.
> > >
> > > Can you do something on this?
> >
> > Please send me the schema you tried to insert (off-the-list if you
> > want) so that I can test it.
> >
> > Tom
> >
>
> Thanks for response, here is a portion of the schema:
>
>   <database name="build_test">
>     <table name="Accrual">
>       <column name="AccrualID" primaryKey="true" required="true"
> type="NUMERIC" size="8" autoIncrement="true"/>
>       <column name="PeriodFK" primaryKey="false" required="true"
> type="NUMERIC" size="8" autoIncrement="false"/>
>       <column name="FileNameChanged" primaryKey="false" required="true"
> type="VARCHAR" size="80" autoIncrement="false"/>
>       <column name="AccruedOn" primaryKey="false" required="false"
> type="TIMESTAMP" size="23" autoIncrement="false"/>
>       <foreign-key foreignTable="Period" name="FK_Accrual_Period">
>         <reference local="PeriodFK" foreign="PeriodID"/>
>       </foreign-key>
>       <unique name="PK_Accrual">
>         <unique-column name="AccrualID"/>
>       </unique>
>       <index name="IX_Accrual_Period">
>         <index-column name="PeriodFK"/>
>       </index>
>     </table>
>     <table name="Period">
>       <column name="PeriodID" primaryKey="true" required="true"
> type="NUMERIC" size="8" autoIncrement="true"/>
>       <column name="PeriodDesc" primaryKey="false" required="true"
> type="VARCHAR" size="50" autoIncrement="false"/>
>       <column name="StatementDate" primaryKey="false" required="false"
> type="TIMESTAMP" size="23" autoIncrement="false"/>
>       <column name="LastChangedOn" primaryKey="false" required="false"
> type="TIMESTAMP" size="23" autoIncrement="false"/>
>       <column name="PeriodMessage" primaryKey="false" required="false"
> type="VARCHAR" size="1000" autoIncrement="false"/>
>       <unique name="PK_Period">
>         <unique-column name="PeriodID"/>
>       </unique>
>     </table>
>  </database>
>
>
>
>
>
> --
> --------------
> Cheers,
> Jun
>



--
--------------
Cheers,
Jun

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message