Adding new column in database table

Hi,

Can I add a new column to the existing table in server. For example, if I add a new column for display table, whether it is going to effect the current working of xibo? Can I modify the database ?

You should not modify the database. If you do, the it’s likely future upgrades will fail as they won’t expect your modifications.

If you need to store additional data, then the best plan would be to create a new table in the database, prefixed with some unlikely prefix (eg diljith_media) and then link the data in that table to the target table (eg the media table) by ID on a 1:1 basis.

You can then simply join diljith_media to the Xibo media table based on mediaId.

Alex

Don’t create a foreign key though - as that will break any display delete functionality in the CMS.