In object_data is it safe to delete entries where CharacterID equals 0?

[DY357LX]

According to an from PetuniaEpoch and vbawol, the data in CharacterID in object_data represents:
Key IDs for cars / character IDs for buildables and combinations for safes.

 

In an attempt to clean up over database a little, I noticed we have quite a lot of entries with 0 in CharacterID. (291 in fact.)

 

Is it safe to delete these? 99% appear to be vehicles with empty inventories.

[TheVampire]

Make sure that they are not unlocked buildables (like cinderblock walls and such) as they also have a CharID of 0.

Cars/Aircraft/Boats with a CharID of 0 are vehicles that are not keyed, and are either random generated, or mission saved (if you have vehicle saving missions).

Buildables with a CharID are lockable such as doors, safes, lockboxes, etc.

[RimBlock]

Make sure that they are not unlocked buildables (like cinderblock walls and such) as they also have a CharID of 0.

Cars/Aircraft/Boats with a CharID of 0 are vehicles that are not keyed, and are either random generated, or mission saved (if you have vehicle saving missions).

Buildables with a CharID are lockable such as doors, safes, lockboxes, etc.

 

err, all buildables in vanilla Epoch have a characterID of the builders characterID at the time of building.

 

It is what is checked when players interact with them (i.e. remove, upgrade, downgrade).  Locked buildables overwrite it with the door / lock code.

 

@OP,

 

Try running the following in a sql client to get an idea of what object type in your DB have a characterID of 0.

select distinct classname from object_data where characterID = 0;

You will get a list of classes which should give you a fair idea of what the items are and then can decide based on that.

 

Only non-owned items have a characterID of 0 but be careful as players may be using cars etc they have found (and so do not own).  I would check the lastupdated date and inventory as well.