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 Mon, 13 Mar 2006 00:28:03 GMT
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

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