Propel schema fails to import indexes

Question

When adding a Propel schema file, the Project tree doesn't show the indexes correctly.
It seems to recognize the indexes as per "they are there", but it doesn't show any information about them.

Example table schema:

  <table name="bank" description="A list of banks.">
        <column name="id" type="integer" autoIncrement="true" primaryKey="true" />
        <column name="name" type="varchar" size="255" required="true" primaryString="true" />
        <column name="code" type="varchar" size="8" required="true" />
        <column name="bic" type="varchar" size="11" required="true"
                description="The international business identifier code (BIC)." />

        <behavior name="versionable">
            <parameter name="log_created_at" value="true" />
        </behavior>

        <unique>
            <unique-column name="code" />
            <unique-column name="bic" />
        </unique>
  </table>

The unique index appears in the list of indexes, but no information about it is visible. It's not unique to unique indexes, but also happens to other indexes.

Comments

Thanks for posting. We will check it and let you know.

Answer 1

When I tried it it seems that index is imported correctly. Only issue is a missing name, but it's because the name is missing also in the input schema.xml.

Link to full image: http://postimage.org/image/fk7phhu37/#codes

I'm not sure how to handle this. ORM Designer can generates a missing name, but this name will be also exported to your XML file.

<unique name="IX_bank_field1_field2">
      <unique-column name="..."/>
</unique>

Comments

Ah, the name is missing, that's why it looks odd. Thank you!

I was looking into the "Properties" panel for the columns etc.