db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andre Charles Legendre (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-19) index tag and unique tag exists in dtd but DatabaseIO().write generate XML without index and unique elements
Date Tue, 27 Sep 2005 15:04:47 GMT
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
 Assigned to: Thomas Dudziak 


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