Ryan Kent
Well-known member
Thank you Brogan, Dismounted and Shelley. You can now count me amongst the happy XenMood family of users.
Dismounted, if I can make a couple suggestions for your use of tables:
- Instead of naming the table xf_moods, I would recommend something like dm_moods (dm=Dismounted). As a database user I would presume any tables with the xf prefix are native to the default install of xf.
- Instead of altering the existing xf_user table by adding the mood_id field I would recommend adding a new table dm_user and linking the table to the xf_user table on the user_id field.
From a database design perspective, this approach is better for add-ons.
Dismounted, if I can make a couple suggestions for your use of tables:
- Instead of naming the table xf_moods, I would recommend something like dm_moods (dm=Dismounted). As a database user I would presume any tables with the xf prefix are native to the default install of xf.
- Instead of altering the existing xf_user table by adding the mood_id field I would recommend adding a new table dm_user and linking the table to the xf_user table on the user_id field.
From a database design perspective, this approach is better for add-ons.