Really useful software project management and source code hosting. tell me more...
| #2 |
Creating a column named "group" new |
There seems to be an issue with a migration that has a column named "group"
Here is my migration code:
`UP:
add_field:
attachments:
group:
type: string
DOWN:
drop_field:
attachments: group`
And here is the SQL error:
`[1254764276] Add Group To Attachments ...
adding column 'group' on 'attachments'
_doQuery: [Error message: Could not execute statement] [Last executed query: ALTER TABLE attachments ADD group VARCHAR(255) DEFAULT NULL] [Native code: 1064] [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group VARCHAR(255) DEFAULT NULL' at line 1]`
| made changes 10 months ago |
| left a comment 10 months ago |
UP:
add_field:
attachments:
groups:
type: string
DOWN:
drop_field:
attachments: group
UP:
rename_field:
attachments:
groups: `group`
DOWN:
rename_field:
attachments:
group: 'groups'
Don't know if this is proper but it seems to work.
follow Codaset on Twitter
