Thanks for the follow up, and absolutely! I am doing a spike using a data model that’s more than just trivial to get a better comparison to a real world already existing product that we’ll be implenting with. The source for the database that I created is the SportsDB model (postgres version) sourced from here in case you’d like to try it yourself: The Sports Standards Alliance.
Here’s the echo of the command line that executed:
liquibase --driver=org.postgresql.Driver --referenceDriver=org.postgresql.Driver --url=jdbc:postgresql://localhost/emptydb
–referenceurl=jdbc:postgresql://localhost/testdb --classpath=postgresql-42.2.20.jar
–username=postgres --password=Password --defaultSchemaName=public --referenceusername=postgres --referencepassword=Password
–changeLogFile=/liquibase/changelog/diff_db_172_17_0_2_emptydb_public_to_db_172_17_0_2_testdb_public.sql
–liquibaseProLicenseKey=REDACTED diffChangeLog
Liquibase Pro 4.3.3 by Datical licensed to Liquibase Pro Evaluation until Wed May 26 00:00:00 UTC 2021
PARTIAL OUTPUT
UPDATE: The output is about 4 times longer than the message allows. I truncated enough off to get it to allow me to post which just shows the alter statements prior to any create table statements at all.
– liquibase formatted sql
– changeset ?:1619806142790-1
ALTER TABLE “public”.“baseball_event_states” ADD “batter_id” INTEGER;
– changeset ?:1619806142790-2
ALTER TABLE “public”.“baseball_event_states” ADD “pitcher_id” INTEGER;
– changeset ?:1619806142790-3
ALTER TABLE “public”.“addresses” ADD “postal_code” VARCHAR(100);
– changeset ?:1619806142790-4
ALTER TABLE “public”.“person_phases” ADD “end_season_id” INTEGER;
– changeset ?:1619806142790-5
ALTER TABLE “public”.“addresses” ADD “region” VARCHAR(100);
– changeset ?:1619806142790-6
ALTER TABLE “public”.“person_phases” ADD “start_season_id” INTEGER;
– changeset ?:1619806142790-7
ALTER TABLE “public”.“baseball_event_states” ADD “runner_on_third_id” INTEGER;
– changeset ?:1619806142790-8
ALTER TABLE “public”.“addresses” ADD “locality” VARCHAR(100);
– changeset ?:1619806142790-9
ALTER TABLE “public”.“baseball_event_states” ADD “runner_on_second_id” INTEGER;
– changeset ?:1619806142790-10
ALTER TABLE “public”.“standings” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-11
ALTER TABLE “public”.“documents” ADD “source_id” INTEGER;
– changeset ?:1619806142790-12
ALTER TABLE “public”.“baseball_event_states” ADD “runner_on_first_id” INTEGER;
– changeset ?:1619806142790-13
ALTER TABLE “public”.“american_football_event_states” ADD “team_in_possession_id” INTEGER;
– changeset ?:1619806142790-14
ALTER TABLE “public”.“documents” ADD “document_fixture_id” INTEGER NOT NULL;
– changeset ?:1619806142790-15
ALTER TABLE “public”.“persons” ADD “death_location_id” INTEGER;
– changeset ?:1619806142790-16
ALTER TABLE “public”.“media” ADD “creation_location_id” INTEGER NOT NULL;
– changeset ?:1619806142790-17
ALTER TABLE “public”.“person_event_metadata” ADD “team_id” INTEGER;
– changeset ?:1619806142790-18
ALTER TABLE “public”.“injury_phases” ADD “season_id” INTEGER;
– changeset ?:1619806142790-19
ALTER TABLE “public”.“team_phases” ADD “role_id” INTEGER;
– changeset ?:1619806142790-20
ALTER TABLE “public”.“persons” ADD “residence_location_id” INTEGER;
– changeset ?:1619806142790-21
ALTER TABLE “public”.“person_phases” ADD “regular_position_id” INTEGER;
– changeset ?:1619806142790-22
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_replacing_position_id” INTEGER;
– changeset ?:1619806142790-23
ALTER TABLE “public”.“documents” ADD “revision_id” VARCHAR(75);
– changeset ?:1619806142790-24
ALTER TABLE “public”.“person_event_metadata” ADD “position_id” INTEGER;
– changeset ?:1619806142790-25
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_replacing_id” INTEGER;
– changeset ?:1619806142790-26
ALTER TABLE “public”.“persons” ADD “hometown_location_id” INTEGER;
– changeset ?:1619806142790-27
ALTER TABLE “public”.“injury_phases” ADD “end_date_time” TIMESTAMP WITHOUT TIME ZONE;
– changeset ?:1619806142790-28
ALTER TABLE “public”.“media” ADD “credit_id” INTEGER NOT NULL;
– changeset ?:1619806142790-29
ALTER TABLE “public”.“stats” ADD “context” VARCHAR(40) NOT NULL;
– changeset ?:1619806142790-30
ALTER TABLE “public”.“stats” ADD “stat_coverage_id” INTEGER;
– changeset ?:1619806142790-31
ALTER TABLE “public”.“injury_phases” ADD “start_date_time” TIMESTAMP WITHOUT TIME ZONE;
– changeset ?:1619806142790-32
ALTER TABLE “public”.“person_event_metadata” ADD “role_id” INTEGER;
– changeset ?:1619806142790-33
ALTER TABLE “public”.“documents” ADD “priority” VARCHAR(100);
– changeset ?:1619806142790-34
ALTER TABLE “public”.“core_person_stats” ADD “position_id” INTEGER;
– changeset ?:1619806142790-35
ALTER TABLE “public”.“baseball_action_pitches” ADD “pitch_type” VARCHAR(100);
– changeset ?:1619806142790-36
ALTER TABLE “public”.“person_phases” ADD “phase_status” VARCHAR(40);
– changeset ?:1619806142790-37
ALTER TABLE “public”.“participants_events” ADD “event_outcome” VARCHAR(100);
– changeset ?:1619806142790-38
ALTER TABLE “public”.“persons” ADD “birth_location_id” INTEGER;
– changeset ?:1619806142790-39
ALTER TABLE “public”.“stats” ADD “stat_coverage_type” VARCHAR(100);
– changeset ?:1619806142790-40
ALTER TABLE “public”.“media” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-41
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_original_position_id” INTEGER;
– changeset ?:1619806142790-42
ALTER TABLE “public”.“affiliation_phases” ADD “end_season_id” INTEGER;
– changeset ?:1619806142790-43
ALTER TABLE “public”.“baseball_action_pitches” ADD “umpire_call” VARCHAR(100);
– changeset ?:1619806142790-44
ALTER TABLE “public”.“wagering_total_score_lines” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-45
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-46
ALTER TABLE “public”.“wagering_runlines” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-47
ALTER TABLE “public”.“wagering_odds_lines” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-48
ALTER TABLE “public”.“wagering_moneylines” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-49
ALTER TABLE “public”.“stats” ADD “stat_holder_id” INTEGER;
– changeset ?:1619806142790-50
ALTER TABLE “public”.“events” ADD “site_id” INTEGER;
– changeset ?:1619806142790-51
ALTER TABLE “public”.“american_football_action_participants” ADD “score_type” VARCHAR(100);
– changeset ?:1619806142790-52
ALTER TABLE “public”.“person_phases” ADD “role_id” INTEGER;
– changeset ?:1619806142790-53
ALTER TABLE “public”.“baseball_action_substitutions” ADD “person_original_id” INTEGER;
– changeset ?:1619806142790-54
ALTER TABLE “public”.“american_football_action_plays” ADD “drive_result” VARCHAR(100);
– changeset ?:1619806142790-55
ALTER TABLE “public”.“document_fixtures” ADD “document_class_id” INTEGER NOT NULL;
– changeset ?:1619806142790-56
ALTER TABLE “public”.“locations” ADD “country_code” VARCHAR(100);
– changeset ?:1619806142790-57
ALTER TABLE “public”.“media_captions” ADD “caption_author_id” INTEGER NOT NULL;
– changeset ?:1619806142790-58
ALTER TABLE “public”.“participants_events” ADD “alignment” VARCHAR(100);
– changeset ?:1619806142790-59
ALTER TABLE “public”.“team_phases” ADD “affiliation_id” INTEGER NOT NULL;
– changeset ?:1619806142790-60
ALTER TABLE “public”.“sub_seasons” ADD “sub_season_type” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-61
ALTER TABLE “public”.“standings” ADD “sub_season_id” INTEGER NOT NULL;
– changeset ?:1619806142790-62
ALTER TABLE “public”.“person_event_metadata” ADD “status” VARCHAR(100);
– changeset ?:1619806142790-63
ALTER TABLE “public”.“stats” ADD “stat_holder_type” VARCHAR(100);
– changeset ?:1619806142790-64
ALTER TABLE “public”.“affiliation_phases” ADD “start_season_id” INTEGER;
– changeset ?:1619806142790-65
ALTER TABLE “public”.“american_football_action_plays” ADD “score_attempt_type” VARCHAR(100);
– changeset ?:1619806142790-66
ALTER TABLE “public”.“affiliations” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-67
ALTER TABLE “public”.“baseball_defensive_players” ADD “position_id” INTEGER NOT NULL;
– changeset ?:1619806142790-68
ALTER TABLE “public”.“american_football_action_participants” ADD “participant_role” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-69
ALTER TABLE “public”.“person_phases” ADD “membership_id” INTEGER NOT NULL;
– changeset ?:1619806142790-70
ALTER TABLE “public”.“documents_media” ADD “media_caption_id” INTEGER NOT NULL;
– changeset ?:1619806142790-71
ALTER TABLE “public”.“sites” ADD “location_id” INTEGER;
– changeset ?:1619806142790-72
ALTER TABLE “public”.“bookmakers” ADD “location_id” INTEGER;
– changeset ?:1619806142790-73
ALTER TABLE “public”.“seasons” ADD “league_id” INTEGER NOT NULL;
– changeset ?:1619806142790-74
ALTER TABLE “public”.“document_fixtures_events” ADD “latest_document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-75
ALTER TABLE “public”.“teams” ADD “home_site_id” INTEGER;
– changeset ?:1619806142790-76
ALTER TABLE “public”.“participants_events” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-77
ALTER TABLE “public”.“team_phases” ADD “end_season_id” INTEGER;
– changeset ?:1619806142790-78
ALTER TABLE “public”.“document_package_entry” ADD “document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-79
ALTER TABLE “public”.“documents” ADD “date_time” TIMESTAMP WITHOUT TIME ZONE;
– changeset ?:1619806142790-80
ALTER TABLE “public”.“baseball_action_pitches” ADD “baseball_defensive_group_id” INTEGER;
– changeset ?:1619806142790-81
ALTER TABLE “public”.“stats” ADD “stat_repository_id” INTEGER NOT NULL;
– changeset ?:1619806142790-82
ALTER TABLE “public”.“team_phases” ADD “start_season_id” INTEGER;
– changeset ?:1619806142790-83
ALTER TABLE “public”.“sub_seasons” ADD “season_id” INTEGER NOT NULL;
– changeset ?:1619806142790-84
ALTER TABLE “public”.“teams” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-85
ALTER TABLE “public”.“sites” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-86
ALTER TABLE “public”.“seasons” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-87
ALTER TABLE “public”.“persons” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-88
ALTER TABLE “public”.“events” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-89
ALTER TABLE “public”.“documents” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-90
ALTER TABLE “public”.“document_fixtures” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-91
ALTER TABLE “public”.“bookmakers” ADD “publisher_id” INTEGER NOT NULL;
– changeset ?:1619806142790-92
ALTER TABLE “public”.“baseball_defensive_players” ADD “player_id” INTEGER NOT NULL;
– changeset ?:1619806142790-93
ALTER TABLE “public”.“baseball_action_plays” ADD “play_type” VARCHAR(100);
– changeset ?:1619806142790-94
ALTER TABLE “public”.“american_football_action_plays” ADD “play_type” VARCHAR(100);
– changeset ?:1619806142790-95
ALTER TABLE “public”.“american_football_action_participants” ADD “person_id” INTEGER NOT NULL;
– changeset ?:1619806142790-96
ALTER TABLE “public”.“participants_events” ADD “participant_id” INTEGER NOT NULL;
– changeset ?:1619806142790-97
ALTER TABLE “public”.“person_phases” ADD “membership_type” VARCHAR(40) NOT NULL;
– changeset ?:1619806142790-98
ALTER TABLE “public”.“media_keywords” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-99
ALTER TABLE “public”.“documents_media” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-100
ALTER TABLE “public”.“latest_revisions” ADD “latest_document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-101
ALTER TABLE “public”.“key_aliases” ADD “key_root_id” INTEGER NOT NULL;
– changeset ?:1619806142790-102
ALTER TABLE “public”.“injury_phases” ADD “injury_status” VARCHAR(100);
– changeset ?:1619806142790-103
ALTER TABLE “public”.“wagering_total_score_lines” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-104
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-105
ALTER TABLE “public”.“wagering_runlines” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-106
ALTER TABLE “public”.“wagering_odds_lines” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-107
ALTER TABLE “public”.“wagering_moneylines” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-108
ALTER TABLE “public”.“person_event_metadata” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-109
ALTER TABLE “public”.“document_fixtures_events” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-110
ALTER TABLE “public”.“baseball_event_states” ADD “current_state” SMALLINT;
– changeset ?:1619806142790-111
ALTER TABLE “public”.“american_football_event_states” ADD “current_state” SMALLINT;
– changeset ?:1619806142790-112
ALTER TABLE “public”.“affiliation_phases” ADD “ancestor_affiliation_id” INTEGER;
– changeset ?:1619806142790-113
ALTER TABLE “public”.“affiliations” ADD “affiliation_type” VARCHAR(100);
– changeset ?:1619806142790-114
ALTER TABLE “public”.“standing_subgroups” ADD “affiliation_id” INTEGER NOT NULL;
– changeset ?:1619806142790-115
ALTER TABLE “public”.“positions” ADD “abbreviation” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-116
ALTER TABLE “public”.“team_phases” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-117
ALTER TABLE “public”.“sub_seasons” ADD “sub_season_key” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-118
ALTER TABLE “public”.“events_sub_seasons” ADD “sub_season_id” INTEGER NOT NULL;
– changeset ?:1619806142790-119
ALTER TABLE “public”.“stats” ADD “stat_repository_type” VARCHAR(100);
– changeset ?:1619806142790-120
ALTER TABLE “public”.“outcome_totals” ADD “standing_subgroup_id” INTEGER NOT NULL;
– changeset ?:1619806142790-121
ALTER TABLE “public”.“standing_subgroups” ADD “standing_id” INTEGER NOT NULL;
– changeset ?:1619806142790-122
ALTER TABLE “public”.“sites” ADD “site_key” INTEGER NOT NULL;
– changeset ?:1619806142790-123
ALTER TABLE “public”.“seasons” ADD “season_key” INTEGER NOT NULL;
– changeset ?:1619806142790-124
ALTER TABLE “public”.“roles” ADD “role_key” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-125
ALTER TABLE “public”.“latest_revisions” ADD “revision_id” VARCHAR(75) NOT NULL;
– changeset ?:1619806142790-126
ALTER TABLE “public”.“publishers” ADD “publisher_key” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-127
ALTER TABLE “public”.“persons” ADD “person_key” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-128
ALTER TABLE “public”.“person_phases” ADD “person_id” INTEGER NOT NULL;
– changeset ?:1619806142790-129
ALTER TABLE “public”.“person_event_metadata” ADD “person_id” INTEGER NOT NULL;
– changeset ?:1619806142790-130
ALTER TABLE “public”.“injury_phases” ADD “person_id” INTEGER NOT NULL;
– changeset ?:1619806142790-131
ALTER TABLE “public”.“sub_periods” ADD “period_id” INTEGER NOT NULL;
– changeset ?:1619806142790-132
ALTER TABLE “public”.“participants_events” ADD “participant_type” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-133
ALTER TABLE “public”.“periods” ADD “participant_event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-134
ALTER TABLE “public”.“document_classes” ADD “name” VARCHAR(100);
– changeset ?:1619806142790-135
ALTER TABLE “public”.“teams_media” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-136
ALTER TABLE “public”.“persons_media” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-137
ALTER TABLE “public”.“media_contents” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-138
ALTER TABLE “public”.“media_captions” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-139
ALTER TABLE “public”.“events_media” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-140
ALTER TABLE “public”.“affiliations_media” ADD “media_id” INTEGER NOT NULL;
– changeset ?:1619806142790-141
ALTER TABLE “public”.“addresses” ADD “location_id” INTEGER NOT NULL;
– changeset ?:1619806142790-142
ALTER TABLE “public”.“key_roots” ADD “key_type” VARCHAR(100);
– changeset ?:1619806142790-143
ALTER TABLE “public”.“key_aliases” ADD “key_id” INTEGER NOT NULL;
– changeset ?:1619806142790-144
ALTER TABLE “public”.“document_fixtures” ADD “fixture_key” VARCHAR(100);
– changeset ?:1619806142790-145
ALTER TABLE “public”.“events” ADD “event_key” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-146
ALTER TABLE “public”.“weather_conditions” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-147
ALTER TABLE “public”.“tennis_event_states” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-148
ALTER TABLE “public”.“soccer_event_states” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-149
ALTER TABLE “public”.“motor_racing_event_states” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-150
ALTER TABLE “public”.“ice_hockey_event_states” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-151
ALTER TABLE “public”.“basketball_event_states” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-152
ALTER TABLE “public”.“baseball_event_states” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-153
ALTER TABLE “public”.“american_football_event_states” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-154
ALTER TABLE “public”.“affiliations_events” ADD “event_id” INTEGER NOT NULL;
– changeset ?:1619806142790-155
ALTER TABLE “public”.“document_package_entry” ADD “document_package_id” INTEGER NOT NULL;
– changeset ?:1619806142790-156
ALTER TABLE “public”.“teams_documents” ADD “document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-157
ALTER TABLE “public”.“persons_documents” ADD “document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-158
ALTER TABLE “public”.“events_documents” ADD “document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-159
ALTER TABLE “public”.“documents_media” ADD “document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-160
ALTER TABLE “public”.“document_contents” ADD “document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-161
ALTER TABLE “public”.“affiliations_documents” ADD “document_id” INTEGER NOT NULL;
– changeset ?:1619806142790-162
ALTER TABLE “public”.“document_fixtures_events” ADD “document_fixture_id” INTEGER NOT NULL;
– changeset ?:1619806142790-163
ALTER TABLE “public”.“documents” ADD “doc_id” VARCHAR(75) NOT NULL;
– changeset ?:1619806142790-164
ALTER TABLE “public”.“wagering_total_score_lines” ADD “bookmaker_id” INTEGER NOT NULL;
– changeset ?:1619806142790-165
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “bookmaker_id” INTEGER NOT NULL;
– changeset ?:1619806142790-166
ALTER TABLE “public”.“wagering_runlines” ADD “bookmaker_id” INTEGER NOT NULL;
– changeset ?:1619806142790-167
ALTER TABLE “public”.“wagering_odds_lines” ADD “bookmaker_id” INTEGER NOT NULL;
– changeset ?:1619806142790-168
ALTER TABLE “public”.“wagering_moneylines” ADD “bookmaker_id” INTEGER NOT NULL;
– changeset ?:1619806142790-169
ALTER TABLE “public”.“baseball_action_substitutions” ADD “baseball_event_state_id” INTEGER NOT NULL;
– changeset ?:1619806142790-170
ALTER TABLE “public”.“baseball_action_plays” ADD “baseball_event_state_id” INTEGER NOT NULL;
– changeset ?:1619806142790-171
ALTER TABLE “public”.“baseball_defensive_players” ADD “baseball_defensive_group_id” INTEGER NOT NULL;
– changeset ?:1619806142790-172
ALTER TABLE “public”.“baseball_action_pitches” ADD “baseball_action_play_id” INTEGER NOT NULL;
– changeset ?:1619806142790-173
ALTER TABLE “public”.“baseball_action_contact_details” ADD “baseball_action_pitch_id” INTEGER NOT NULL;
– changeset ?:1619806142790-174
ALTER TABLE “public”.“american_football_action_plays” ADD “american_football_event_state_id” INTEGER NOT NULL;
– changeset ?:1619806142790-175
ALTER TABLE “public”.“american_football_action_participants” ADD “american_football_action_play_id” INTEGER NOT NULL;
– changeset ?:1619806142790-176
ALTER TABLE “public”.“affiliations” ADD “affiliation_key” VARCHAR(100) NOT NULL;
– changeset ?:1619806142790-177
ALTER TABLE “public”.“standings” ADD “affiliation_id” INTEGER NOT NULL;
– changeset ?:1619806142790-178
ALTER TABLE “public”.“positions” ADD “affiliation_id” INTEGER NOT NULL;
– changeset ?:1619806142790-179
ALTER TABLE “public”.“affiliation_phases” ADD “affiliation_id” INTEGER NOT NULL;
– changeset ?:1619806142790-180
ALTER TABLE “public”.“db_info” ADD “version” VARCHAR(100) DEFAULT ‘16’ NOT NULL;
– changeset ?:1619806142790-181
ALTER TABLE “public”.“teams_media” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-182
ALTER TABLE “public”.“teams_documents” ADD “team_id” INTEGER NOT NULL;
– changeset ?:1619806142790-183
ALTER TABLE “public”.“persons_media” ADD “person_id” INTEGER NOT NULL;
– changeset ?:1619806142790-184
ALTER TABLE “public”.“persons_documents” ADD “person_id” INTEGER NOT NULL;
– changeset ?:1619806142790-185
ALTER TABLE “public”.“weather_conditions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-186
ALTER TABLE “public”.“wagering_total_score_lines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-187
ALTER TABLE “public”.“wagering_straight_spread_lines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-188
ALTER TABLE “public”.“wagering_runlines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-189
ALTER TABLE “public”.“wagering_odds_lines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-190
ALTER TABLE “public”.“wagering_moneylines” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-191
ALTER TABLE “public”.“tennis_service_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-192
ALTER TABLE “public”.“tennis_return_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-193
ALTER TABLE “public”.“tennis_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-194
ALTER TABLE “public”.“tennis_action_volleys” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-195
ALTER TABLE “public”.“tennis_action_points” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-196
ALTER TABLE “public”.“teams” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-197
ALTER TABLE “public”.“team_phases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-198
ALTER TABLE “public”.“team_american_football_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-199
ALTER TABLE “public”.“sub_seasons” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-200
ALTER TABLE “public”.“sub_periods” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-201
ALTER TABLE “public”.“stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-202
ALTER TABLE “public”.“standings” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-203
ALTER TABLE “public”.“standing_subgroups” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-204
ALTER TABLE “public”.“soccer_offensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-205
ALTER TABLE “public”.“soccer_foul_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-206
ALTER TABLE “public”.“soccer_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-207
ALTER TABLE “public”.“soccer_defensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-208
ALTER TABLE “public”.“sites” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-209
ALTER TABLE “public”.“seasons” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-210
ALTER TABLE “public”.“roles” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-211
ALTER TABLE “public”.“publishers” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-212
ALTER TABLE “public”.“positions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-213
ALTER TABLE “public”.“persons” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-214
ALTER TABLE “public”.“person_phases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-215
ALTER TABLE “public”.“person_event_metadata” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-216
ALTER TABLE “public”.“periods” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-217
ALTER TABLE “public”.“participants_events” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-218
ALTER TABLE “public”.“outcome_totals” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-219
ALTER TABLE “public”.“motor_racing_race_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-220
ALTER TABLE “public”.“motor_racing_qualifying_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-221
ALTER TABLE “public”.“motor_racing_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-222
ALTER TABLE “public”.“media_keywords” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-223
ALTER TABLE “public”.“media_contents” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-224
ALTER TABLE “public”.“media_captions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-225
ALTER TABLE “public”.“media” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-226
ALTER TABLE “public”.“locations” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-227
ALTER TABLE “public”.“latest_revisions” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-228
ALTER TABLE “public”.“key_roots” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-229
ALTER TABLE “public”.“key_aliases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-230
ALTER TABLE “public”.“injury_phases” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-231
ALTER TABLE “public”.“ice_hockey_player_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-232
ALTER TABLE “public”.“ice_hockey_offensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-233
ALTER TABLE “public”.“ice_hockey_event_states” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-234
ALTER TABLE “public”.“ice_hockey_defensive_stats” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-235
ALTER TABLE “public”.“ice_hockey_action_plays” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
– changeset ?:1619806142790-236
ALTER TABLE “public”.“ice_hockey_action_participants” ADD “id” INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL;
TRUNCATED HERE