View Single Post
  #9  
Old 10-29-2021, 05:19 PM
Garral
Fire Beetle
 
Join Date: Oct 2012
Location: Earth, Sol
Posts: 9
Default

Quote:
Originally Posted by Nukerella View Post
vw_bot_character_mobs ---This is the table, it is located under Views.

My database has 4 tables under this heading "vw_bot_character_mobs", "vw_bot_groups", "vw_groups", and "vw_guild_members". You only need to add the deleted_at to "vw_bot_character_mobs".
I admit my knowledge of MySQL is limited.

I am under the impression that the view pulls that information from the table. When I attempted to add the 'deleted_at' to the 'vw_bot_character_mobs' view it told me it couldn't add it. I was going to add 'deleted_at' to the 'bot_data' table as it seems that is where it's pulling the info from.

Either I'm trying to add it to the wrong location or I'm using the wrong syntax to edit the view.

I appreciate the hell out of the information and help you're all providing!
Reply With Quote