Deprecated tables?

I was going through the mbdump downloads, as well as the table creation SQL in the server, and I noticed that there are 155 tables created that aren’t included in any of the downloads. Is this because those tables are no longer used, or are they somewhere I haven’t found?

Thanks,
Lisa

I suspect that at least some of them contain personal information about the users which should be maintained as confidential, and are thus not available for download. Not sure about all of them though.

2 Likes

Some of this tables are updated using triggers, AFAIK.
Maybe @yvanzo can tell you more about it.

2 Likes

Both of the above answers are correct, however the count of 155 tables seems to be overestimated.

I mean…

alternative_medium
alternative_medium_track
alternative_release
alternative_track
application
area_attribute
area_attribute_type
area_attribute_type_allowed_value
area_containment
area_tag_raw
artist_attribute
artist_attribute_type
artist_attribute_type_allowed_value
artist_rating_raw
artist_release
artist_release_group
artist_release_group_pending_update
artist_release_pending_update
artist_tag_raw
autoeditor_election
autoeditor_election_vote
edit_genre
edit_mood
editor
editor_collection
editor_collection_area
editor_collection_artist
editor_collection_collaborator
editor_collection_deleted_entity
editor_collection_event
editor_collection_gid_redirect
editor_collection_instrument
editor_collection_label
editor_collection_place
editor_collection_recording
editor_collection_release
editor_collection_release_group
editor_collection_series
editor_collection_work
editor_language
editor_oauth_token
editor_preference
editor_subscribe_artist
editor_subscribe_artist_deleted
editor_subscribe_collection
editor_subscribe_editor
editor_subscribe_label
editor_subscribe_label_deleted
editor_subscribe_series
editor_subscribe_series_deleted
editor_watch_artist
editor_watch_preferences
editor_watch_release_group_type
editor_watch_release_status
event_attribute
event_attribute_type
event_attribute_type_allowed_value
event_rating_raw
event_tag_raw
genre_alias_type
genre_annotation
instrument_attribute
instrument_attribute_type
instrument_attribute_type_allowed_value
instrument_tag_raw
l_area_artist
l_area_genre
l_area_label
l_area_mood
l_area_place
l_area_release_group
l_artist_genre
l_artist_mood
l_event_genre
l_event_instrument
l_event_label
l_event_mood
l_genre_genre
l_genre_instrument
l_genre_label
l_genre_mood
l_genre_place
l_genre_recording
l_genre_release
l_genre_release_group
l_genre_series
l_genre_url
l_genre_work
l_instrument_mood
l_instrument_place
l_instrument_recording
l_instrument_release
l_instrument_release_group
l_instrument_series
l_instrument_work
l_label_mood
l_mood_mood
l_mood_place
l_mood_recording
l_mood_release
l_mood_release_group
l_mood_series
l_mood_url
l_mood_work
l_place_release_group
l_recording_release_group
l_release_group_work
l_release_release_group
l_release_work
l_url_url
label_attribute
label_attribute_type
label_attribute_type_allowed_value
label_rating_raw
label_tag_raw
latest
medium_attribute
medium_attribute_type
medium_attribute_type_allowed_format
medium_attribute_type_allowed_value
medium_attribute_type_allowed_value_allowed_format
mood
mood_alias
mood_alias_type
mood_annotation
old_editor_name
place_attribute
place_attribute_type
place_attribute_type_allowed_value
place_rating_raw
place_tag_raw
recording_attribute
recording_attribute_type
recording_attribute_type_allowed_value
recording_first_release_date
recording_rating_raw
recording_tag_raw
release_attribute
release_attribute_type
release_attribute_type_allowed_value
release_first_release_date
release_group_attribute
release_group_attribute_type
release_group_attribute_type_allowed_value
release_group_rating_raw
release_group_tag_raw
release_tag_raw
series_attribute
series_attribute_type
series_attribute_type_allowed_value
series_tag_raw
tag
tag_relation
work_rating_raw
work_tag_raw

1 Like

I posted the list below. But yes, I can see why a bunch of them wouldn’t be made available. Thanks.

That actually leads me to another question. Many of the triggers call procedures. But there doesn’t seem to be any list of those procedures in the server download. Aren’t they needed for a server setup?

I’m not perfectly sure, but I think this “procedures” are called “functions” and defined in CreateFunctions.sql
For example the function b_upd_last_updated_table() is defined in CreateFunctions.sql as

CREATE OR REPLACE FUNCTION b_upd_last_updated_table() RETURNS trigger AS $$
BEGIN
    NEW.last_updated = NOW();
    RETURN NEW;
END;

The content of these tables is not discarded, they are just empty.
See Area-Artist Relationship Types - MusicBrainz
In the event that they would become populated, they would be replicated on mirrors as well:

1 Like