Path	Lines of Code
PostgreSQL/sampledb/v1/README.md	86
PostgreSQL/sampledb/v1/install-postgresql.sql	62
PostgreSQL/sampledb/v1/schema/create-constraint.sql	142
PostgreSQL/sampledb/v1/schema/create-index.sql	53
PostgreSQL/sampledb/v1/schema/create-table.sql	250
PostgreSQL/sampledb/v1/schema/create-view.sql	32
PostgreSQL/sampledb/v1/schema/foreign-keys.sql	75
PostgreSQL/sampledb/v1/schema/functions/esubstr.sql	22
PostgreSQL/sampledb/v1/schema/functions/generatemlbseason.sql	212
PostgreSQL/sampledb/v1/schema/functions/generatenflseason.sql	419
PostgreSQL/sampledb/v1/schema/functions/generateseats.sql	117
PostgreSQL/sampledb/v1/schema/functions/generatesporttickets.sql	72
PostgreSQL/sampledb/v1/schema/functions/generateticketactivity.sql	60
PostgreSQL/sampledb/v1/schema/functions/generatetickets.sql	40
PostgreSQL/sampledb/v1/schema/functions/generatetransferactivity.sql	64
PostgreSQL/sampledb/v1/schema/functions/loadmlbplayers.sql	38
PostgreSQL/sampledb/v1/schema/functions/loadmlbteams.sql	39
PostgreSQL/sampledb/v1/schema/functions/loadnflplayers.sql	57
PostgreSQL/sampledb/v1/schema/functions/loadnflteams.sql	84
PostgreSQL/sampledb/v1/schema/functions/selltickets.sql	41
PostgreSQL/sampledb/v1/schema/functions/set_mlb_team_home_field.sql	30
PostgreSQL/sampledb/v1/schema/functions/setnflhomefield.sql	29
PostgreSQL/sampledb/v1/schema/functions/transferticket.sql	40
PostgreSQL/sampledb/v1/user/create-user.sql	5
README.md	2
exercises/mysql-shard-consolidation/README.md	96
exercises/mysql-shard-consolidation/create-shards.sql	74
exercises/mysql-shard-consolidation/schema/export_shard_data.sql	18
exercises/mysql-shard-consolidation/schema/generate_ticket_activity.sql	57
exercises/mysql-shard-consolidation/schema/load_person.sql	19
exercises/mysql-shard-consolidation/schema/load_sporting_event_ticket.sql	19
exercises/mysql-shard-consolidation/schema/unload_person.sql	19
exercises/mysql-shard-consolidation/schema/unload_sporting_event_ticket.sql	19
exercises/oracle-to-postgres/README.md	195
mongodb/sampledb/v1/README.md	172
mongodb/sampledb/v1/data/mlb_data.sql	2230
mongodb/sampledb/v1/data/name_data.sql	5373
mongodb/sampledb/v1/data/nfl_data.sql	2928
mongodb/sampledb/v1/data/nfl_stadium_data.sql	32
mysql/sampledb/v1/README.md	87
mysql/sampledb/v1/data/mlb_data.sql	2244
mysql/sampledb/v1/data/name_data.sql	5387
mysql/sampledb/v1/data/nfl_data.sql	2942
mysql/sampledb/v1/data/nfl_stadium_data.sql	46
mysql/sampledb/v1/install-rds.sql	46
mysql/sampledb/v1/remove-sampledb.sql	16
mysql/sampledb/v1/schema/create_dms_sample.sql	15
mysql/sampledb/v1/schema/generate_mlb_season.sql	92
mysql/sampledb/v1/schema/generate_nfl_season.sql	311
mysql/sampledb/v1/schema/generate_sport_tickets.sql	41
mysql/sampledb/v1/schema/generate_ticket_activity.sql	60
mysql/sampledb/v1/schema/generate_tickets.sql	61
mysql/sampledb/v1/schema/generate_transfer_activity.sql	67
mysql/sampledb/v1/schema/install_dms_sample_data.sql	97
mysql/sampledb/v1/schema/load_base_data.sql	33
mysql/sampledb/v1/schema/mlb_data.tab	44
mysql/sampledb/v1/schema/name_data.tab	19
mysql/sampledb/v1/schema/nfl_data.tab	29
mysql/sampledb/v1/schema/nfl_stadium_data.tab	24
mysql/sampledb/v1/schema/person.tab	28
mysql/sampledb/v1/schema/player.tab	99
mysql/sampledb/v1/schema/seat.tab	126
mysql/sampledb/v1/schema/seat_type.tab	32
mysql/sampledb/v1/schema/sell_tickets.sql	63
mysql/sampledb/v1/schema/set_mlb_team_home_field.sql	78
mysql/sampledb/v1/schema/set_nfl_team_home_field.sql	43
mysql/sampledb/v1/schema/sport_division.tab	52
mysql/sampledb/v1/schema/sport_league.tab	26
mysql/sampledb/v1/schema/sport_location.tab	107
mysql/sampledb/v1/schema/sport_team.tab	147
mysql/sampledb/v1/schema/sport_type.tab	23
mysql/sampledb/v1/schema/sporting_event.tab	30
mysql/sampledb/v1/schema/sporting_event_ticket.tab	33
mysql/sampledb/v1/schema/ticket_purchase_hist.tab	27
mysql/sampledb/v1/schema/transfer_tickets.sql	60
mysql/sampledb/v1/user/create_dms_user.sql	15
mysql/sampledb/v1/user/dms_user_privileges.sql	15
oracle/sampledb/v1/README.md	91
oracle/sampledb/v1/install-onprem.sql	11
oracle/sampledb/v1/install-rds.sql	12
oracle/sampledb/v1/remove-sampledb.sql	2
oracle/sampledb/v1/schema/generate_mlb_season.sql	42
oracle/sampledb/v1/schema/generate_nfl_season.sql	195
oracle/sampledb/v1/schema/install_dms_sample_data.sql	123
oracle/sampledb/v1/schema/load_base_data.sql	12
oracle/sampledb/v1/schema/mlb_data.sql	2232
oracle/sampledb/v1/schema/mlb_data.tab	31
oracle/sampledb/v1/schema/name_data.sql	5375
oracle/sampledb/v1/schema/name_data.tab	5
oracle/sampledb/v1/schema/nfl_data.sql	2930
oracle/sampledb/v1/schema/nfl_data.tab	15
oracle/sampledb/v1/schema/nfl_stadium_data.sql	34
oracle/sampledb/v1/schema/nfl_stadium_data.tab	10
oracle/sampledb/v1/schema/person.tab	16
oracle/sampledb/v1/schema/player.tab	61
oracle/sampledb/v1/schema/public_synonyms.sql	12
oracle/sampledb/v1/schema/seat.tab	72
oracle/sampledb/v1/schema/seat_type.tab	18
oracle/sampledb/v1/schema/set_mlb_team_home_field.sql	30
oracle/sampledb/v1/schema/set_nfl_team_home_field.sql	14
oracle/sampledb/v1/schema/sport_division.tab	38
oracle/sampledb/v1/schema/sport_league.tab	12
oracle/sampledb/v1/schema/sport_location.tab	107
oracle/sampledb/v1/schema/sport_team.tab	126
oracle/sampledb/v1/schema/sport_type.tab	9
oracle/sampledb/v1/schema/sporting_event.tab	29
oracle/sampledb/v1/schema/sporting_event_ticket.tab	22
oracle/sampledb/v1/schema/ticket_purchase_hist.tab	13
oracle/sampledb/v1/user/create_dms_sample.sql	17
oracle/sampledb/v1/user/create_dms_user.sql	3
oracle/sampledb/v1/user/dms_sample_dms_user_grants.sql	13
oracle/sampledb/v1/user/dms_sample_privileges.sql	32
oracle/sampledb/v1/user/dms_sample_privileges_onprem.sql	31
oracle/sampledb/v1/user/dms_user_privileges.sql	32
oracle/sampledb/v1/user/dms_user_privileges_onprem.sql	32
oracle/sampledb/v1/user/dms_user_sct_privileges.sql	3
sqlserver/sampledb/v1/README.md	99
sqlserver/sampledb/v1/install-onprem.sql	148
sqlserver/sampledb/v1/remove-sampledb.sql	54
sqlserver/sampledb/v1/schema/create_dms_sample.sql	4
sqlserver/sampledb/v1/schema/generateTicketActivity.sql	46
sqlserver/sampledb/v1/schema/generateTransferActivity.sql	45
sqlserver/sampledb/v1/schema/generate_mlb_season.sql	74
sqlserver/sampledb/v1/schema/generate_nfl_season.sql	253
sqlserver/sampledb/v1/schema/generate_tickets.sql	37
sqlserver/sampledb/v1/schema/load_mlb_tickets.sql	18
sqlserver/sampledb/v1/schema/load_nfl_tickets.sql	18
sqlserver/sampledb/v1/schema/mlb_data.sql	2231
sqlserver/sampledb/v1/schema/mlb_data.tab	30
sqlserver/sampledb/v1/schema/name_data.sql	5361
sqlserver/sampledb/v1/schema/name_data.tab	5
sqlserver/sampledb/v1/schema/nfl_data.sql	2929
sqlserver/sampledb/v1/schema/nfl_data.tab	15
sqlserver/sampledb/v1/schema/nfl_stadium_data.sql	33
sqlserver/sampledb/v1/schema/nfl_stadium_data.tab	10
sqlserver/sampledb/v1/schema/person.tab	14
sqlserver/sampledb/v1/schema/player.tab	78
sqlserver/sampledb/v1/schema/rand_int.sql	9
sqlserver/sampledb/v1/schema/seat.tab	124
sqlserver/sampledb/v1/schema/seat_type.tab	18
sqlserver/sampledb/v1/schema/sellTickets.sql	66
sqlserver/sampledb/v1/schema/set_mlb_team_home_field.sql	30
sqlserver/sampledb/v1/schema/set_nfl_team_home_field.sql	21
sqlserver/sampledb/v1/schema/sport_division.tab	38
sqlserver/sampledb/v1/schema/sport_league.tab	12
sqlserver/sampledb/v1/schema/sport_location.tab	102
sqlserver/sampledb/v1/schema/sport_team.tab	136
sqlserver/sampledb/v1/schema/sport_type.tab	9
sqlserver/sampledb/v1/schema/sporting_event.tab	19
sqlserver/sampledb/v1/schema/sporting_event_ticket.tab	20
sqlserver/sampledb/v1/schema/ticket_purchase_hist.tab	13
sqlserver/sampledb/v1/schema/transferTicket.sql	39
sqlserver/sampledb/v1/show_server.sql	3
sqlserver/sampledb/v1/system/dms_sample_backup.sql	18
sqlserver/sampledb/v1/system/enable_replication.sql	26
sqlserver/sampledb/v1/user/create_dms_user.sql	14