Forums

mysql - adding column to filesetfiles table

Permalink
Hi guys,

I need to add additional columns to the FileSetFiles table however when I do this files can no longer be added to sets through file manager.

Is there a core php file that I need to add the additional column values to upon a file being being added to a set?

thanks,
 
beebs93 replied on at Permalink Reply
beebs93
Let's back up a step. Why do you need an extra column for a core table?

Messing with the core database tables is inviting complications right away or down the line.
JohntheFish replied on at Permalink Best Answer Reply
JohntheFish
I think what you probably need to do is add a file attribute to files for the extra information you would have liked to put in a column.

Think of attributes as optional extra columns.
waynethorley replied on at Permalink Reply
Of course, attributes!

Thanks John
waynethorley replied on at Permalink Reply
I confess.... I can call file attributes quite easily but im struggling with setting attributes. What I had before would decode json and then update the database. What I'm struggling with is decoding the json to update the file attributes, as opposed to running the query.