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? ```
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
-
you need to define the column first and then create the unique index separately, not everything at once
0 -
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>
0 -
alright think I got it here π @U01A5ARAXP0
0 -
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 though0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 75 Spryker News
- 924 Developer Corner
- 783 Spryker Development
- 88 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 35 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 25 Job Opportunities
- 3.2K π Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random