[ http://issues.apache.org/jira/browse/DDLUTILS-19?page=all ]
Thomas Dudziak updated DDLUTILS-19:
-----------------------------------
Component: Core (No specific database)
> 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
> Components: Core (No specific database)
> 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="'Y'::character varying"
> autoIncrement="false"/>
> <column name="created" primaryKey="false" required="true"
> type="TIMESTAMP" size="8" default="('now'::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="('now'::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
