db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DDLUTILS-19) index tag and unique tag exists in dtd but DatabaseIO().write generate XML without index and unique elements
Date Thu, 13 Jul 2006 06:13:36 GMT
     [ http://issues.apache.org/jira/browse/DDLUTILS-19?page=all ]

Thomas Dudziak updated DDLUTILS-19:
-----------------------------------

    Fix Version: 1.0

> index tag and unique tag exists in dtd but DatabaseIO().write generate XML without index
and unique elements
> ------------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-19
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-19
>      Project: DdlUtils
>         Type: Bug

>  Environment: Linux Fedora 4 jdk1.5.0_04
>     Reporter: Andre Charles Legendre
>     Assignee: Thomas Dudziak
>      Fix For: 1.0

>
> index tag and unique tag exists in both dtd but I
> found no index element nor unique element created when
> I have generated XML from our database using
> DatabaseIO().write
> For example a postgres table created by :
> CREATE TABLE MFG_BatchType
>   (
>     Id            numeric(10,0)   unique not null,
>     AD_Client_ID  numeric(10,0)   not null,
>     AD_Org_ID     numeric(10,0)   not null,
>     IsActive      varchar(1)      not null default 'Y',
>     Created       timestamp       not null default CURRENT_TIMESTAMP,
>     CreatedBy     numeric(10,0)   not null,
>     Updated       timestamp       not null default CURRENT_TIMESTAMP,
>     UpdatedBy     numeric(10,0)   not null,
>     Name          varchar(200)    not null,
>     No_version    varchar(32)     not null,
>     Description   varchar(2000)   not null,
>     Cycle_Time    numeric(10,0)   not null,
>     Cycle_Qty     float8          not null,
>     primary key(Id)
>   );
> CREATE INDEX MFG_BatchTypeNDX1 ON MFG_BatchType(Id);
> -- ----------------------------------------------------------------------
> COMMENT ON COLUMN MFG_BatchType.Description is 'Cycle, one shot or when completed';
> COMMENT ON COLUMN MFG_BatchType.Cycle_Time is 'if batch type is cycle';
> COMMENT ON COLUMN MFG_BatchType.Cycle_Qty is 'Number of work orders to introduce when
WIP minimum is reached';
> Give this XML :
>     <table name="mfg_batchtype">
>       <column name="id" primaryKey="false" required="true" type="NUMERIC" size="10"
autoIncrement="false"/>
>       <column name="ad_client_id" primaryKey="false" required="true" type="NUMERIC"
size="10" autoIncrement="false"/>
>       <column name="ad_org_id" primaryKey="false" required="true" type="NUMERIC" size="10"
autoIncrement="false"/>
>       <column name="isactive" primaryKey="false" required="true" type="VARCHAR" size="1"
default="&apos;Y&apos;::character varying" autoIncrement="false"/>
>       <column name="created" primaryKey="false" required="true" type="TIMESTAMP" size="8"
default="(&apos;now&apos;::text)::timestamp(6) with time zone" autoIncrement="false"/>
>       <column name="createdby" primaryKey="false" required="true" type="NUMERIC" size="10"
autoIncrement="false"/>
>       <column name="updated" primaryKey="false" required="true" type="TIMESTAMP" size="8"
default="(&apos;now&apos;::text)::timestamp(6) with time zone" autoIncrement="false"/>
>       <column name="updatedby" primaryKey="false" required="true" type="NUMERIC" size="10"
autoIncrement="false"/>
>       <column name="name" primaryKey="false" required="true" type="VARCHAR" size="200"
autoIncrement="false"/>
>       <column name="no_version" primaryKey="false" required="true" type="VARCHAR"
size="32" autoIncrement="false"/>
>       <column name="description" primaryKey="false" required="true" type="VARCHAR"
size="2000" autoIncrement="false"/>
>       <column name="cycle_time" primaryKey="false" required="true" type="NUMERIC"
size="10" autoIncrement="false"/>
>       <column name="cycle_qty" primaryKey="false" required="true" type="DOUBLE" size="8"
autoIncrement="false"/>
>     </table>
> As you can see index and comment disapear for comment, it is not an issue but for index
yes.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message