What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hey when I am extending a db table can I not add a unique column? ```

U01JBB8LNTE
U01JBB8LNTE Posts: 207 🧑🏻‍🚀 - Cadet
in Help

Hey when I am extending a db table can I not add a unique column?

    <table name="spy_stock">
            <unique name="spy_stock-other_id">
                <unique-column name="other_id" type="VARCHAR" size="10" required="false"/>
            </unique>
...

Executing migration PropelMigration_1615322855 up
Propel\Runtime\Exception\RuntimeException - Exception: <error>Failed to execute SQL "CREATE UNIQUE INDEX `spy_stock-other_id` ON `spy_stock` (`other_id`(10))". Aborting migration.</error>

Comments

  • U01A5ARAXP0
    U01A5ARAXP0 Posts: 119 🧑🏻‍🚀 - Cadet

    you need to define the column first and then create the unique index separately, not everything at once

  • U01JBB8LNTE
    U01JBB8LNTE Posts: 207 🧑🏻‍🚀 - Cadet

    oh are you saying like this

         <column name="content_type" required="true" size="100" type="VARCHAR"/> <- create column

        <unique>
            <unique-column name="content_type"/>  <- make unique?
        </unique>
  • U01JBB8LNTE
    U01JBB8LNTE Posts: 207 🧑🏻‍🚀 - Cadet

    alright think I got it here 🙏 @U01A5ARAXP0

  • U01A5ARAXP0
    U01A5ARAXP0 Posts: 119 🧑🏻‍🚀 - Cadet

    yes, exactly that... and usually we give a name to the unique index, like <unique name="table-unique-field"> . Not sure if it is mandatory though

Categories