Re: Graphical design tool to generate Torque XML schema

[Bogdan Vatkov]

Hi Emmanuel,
I've have found a little bug ... may be it is some DTD issue ..but maybe i
am wrong
the effect is th following:
when i open any-schema.xml file from the ones that are build upon the rules
as described in the torque package
all the tables from the xml file when loaded in the devaki workspace become
with doubled columns...

ex: the file attached
..in the devaki workspace table user gets has the following columns:

id
first_name
...
passw
id
first_name
...
passw

or maybe i am doing something wrong ?

With best regards,
Bogdan
----- Original Message -----
From: "Emmanuel Florent" <[EMAIL PROTECTED]>
To: "Apache Torque Users List" <[EMAIL PROTECTED]>
Sent: Friday, December 12, 2003 22:41
Subject: Re: Graphical design tool to generate Torque XML schema



<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";>
<!-- Autogenerated by JDBCToXMLSchema! -->
<database name="fksu" defaultIdMethod="idbroker">
    <table name="academic_user">
        <column  name="id" primaryKey="true" required="true" type="INTEGER"/>
        <column  name="user_id" required="true" type="INTEGER"/>
        <column  name="tu_phone" size="16" type="VARCHAR"/>
        <column  name="room_numbers" size="32" type="VARCHAR"/>
        <column  name="position" type="SMALLINT"/>
        <column  name="sci_level" type="SMALLINT"/>
        
        <foreign-key foreignTable="user">
           <reference
              local="user_id"
              foreign="id"/>
        </foreign-key>
        
    </table>
    <table name="administrative_user">
        <column  name="id" primaryKey="true" required="true" type="INTEGER"/>
        <column  name="user_id" required="true" type="INTEGER"/>
        <column  name="position" type="SMALLINT"/>
        <column  name="room_numbers" size="32" type="VARCHAR"/>
        <column  name="tu_phone" size="16" type="VARCHAR"/>
        
        <foreign-key foreignTable="user">
           <reference
              local="user_id"
              foreign="id"/>
        </foreign-key>
        
    </table>
    <table name="student_user">
        <column  name="id" primaryKey="true" required="true" type="INTEGER"/>
        <column  name="user_id" required="true" type="INTEGER"/>
        <column  name="course_number" type="SMALLINT"/>
        <column  name="stream" type="SMALLINT"/>
        <column  name="group_id" type="INTEGER"/>
        <column  name="faculty_number" size="16" type="VARCHAR"/>
        <column  name="edu_method" type="SMALLINT"/>
        <column  name="edu_status" type="SMALLINT"/>
        
        <foreign-key foreignTable="user">
           <reference
              local="user_id"
              foreign="id"/>
        </foreign-key>
        
    </table>
    <table name="user" idMethod="idbroker">
        <column  name="id" primaryKey="true" required="true" type="INTEGER"/>
        <column  name="first_name" size="32" type="VARCHAR"/>
        <column  name="second_name" size="32" type="VARCHAR"/>
        <column  name="family_name" size="32" type="VARCHAR"/>
        <column  name="birthdate" type="DATE"/>
        <column  name="phone_number" size="20" type="VARCHAR"/>
        <column  name="address" size="64" type="VARCHAR"/>
        <column  name="email" size="64" type="VARCHAR"/>
        <column  name="user_type" type="SMALLINT"/>
        <column  name="sex" type="SMALLINT"/>
        <column  name="log_name" size="32" type="VARCHAR"/>
        <column  name="passw" size="32" type="VARCHAR"/>
    </table>
</database>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]