Magento modify/add columns to model resource

Question

I have a module whose flat table I may need to add columns to and remove columns from. I know this can be done in setup, but I have to import data into the table nightly from a web service. The web service may occasionally change their column names.

First of all, does anyone know how to alter table structure in Magento without using raw SQL? Second, does anyone know the best way to do this?

I haven't yet mastered the EAV data pattern used in Magento but would someday like to learn. Any help appreciated.

score 0 · Accepted Answer · edited May 23 '17 at 12:00

0

I had the same thought (or similar) a while ago.
ALTER TABLE in Magento setup script without using SQL

Ivan's answer was particularly good and I still refer to it often. It is essential reading.

edited May 23 '17 at 12:00

Community

1
1

answered Apr 11 '11 at 18:07

clockworkgeek

37,650
9
89
127

Thanks, clockwork. However, that class is awkward working with. – Apr 14 '11 at 03:58

Magento modify/add columns to model resource

1 Answers1