0 votes

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.

in Solved by (600 points)
recategorized by

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

1 Answer

0 votes
Best answer

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
enter image description here

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>
by Skipper developer (141k points)
selected by

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

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