View Single Post
  #5  
Old 10-17-2021, 01:34 AM
Garral
Fire Beetle
 
Join Date: Oct 2012
Location: Earth, Sol
Posts: 9
Default

Quote:
Originally Posted by joligario View Post
Ok, so that is bots. Looks like the deleted_at would need to apply to those tables/views.
Thank you for the help. Just to make sure I understand as MySQL is not my forte or something I work in regularly and I'd rather not mess up the database:

My understanding is that the table "vw_bot_character_mobs" is missing the "deleted_at" column. Running the following should fix this?

Code:
ALTER TABLE `vw_bot_character_mobs` ADD COLUMN `deleted_at` datetime NULL DEFAULT NULL;
Would I also have to apply this to the "vw_guild_members" table as well?
Reply With Quote