vYj]UdZddlmZddlmZddlZddlmZdZ e e d<dZ e dze d<dZ ee dze d <dZee dze d <d Zd Zd Zdeej&fdZdeej&fdZde deej&fdZddZddZy)zdInitial BF4 Player Stats schema. Revision ID: 0001_initial_schema Revises: Create Date: 2026-10-02 )Sequence)opN) postgresql0001_initial_schemarevision down_revision branch_labels depends_on)pcps4xboxone)detailedprofileweaponsvehicles)never_attemptedsuccesstemporary_failure unavailablereturnc tjdtjddtjdtjdtjddtjdgS)N created_atTtimezoneFnow()nullableserver_default updated_at)saColumnDateTimetext*migrations/versions/0001_initial_schema.py _timestampsr's\ , T :U[][b[bcj[kl , T :U[][b[bcj[kl r%c"gtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjd tjdtjd tjdtjd tjdtjd tjdtjd tjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjdtjd tjdtjd!tjdtjd"tjdtjd#tjdtjd$tjdtjd%tjdtjd&tjdtjd'tjdtjd(tjdtjd)tjd*d+dtjd,tjdtjd-tjdtjd.tjdtjd/tjdtjd0tjdtjd1tjdtjd2tjd3d4dtjd5tjdtjd6tjdtjd7tjdS)8NrankTrtime_played_seconds assault_scoreengineer_score support_score recon_scorecommander_score squad_score vehicle_score award_score unlock_score total_score combat_scoreconquest_score rush_scoreteam_deathmatch_scoredomination_scoreobliteration_score defuse_scorecapture_the_flag_scoreair_superiority_scorecarrier_assault_scorechain_link_scoregun_master_scorekillsdeaths kill_assistswinslosses shots_fired shots_hitrepairsrevivesheals resupplies avenger_kills savior_killssuppression_assistsquit_percentage flags_capturedflags_defended dogtags_takenvehicles_destroyedvehicle_damage headshotslongest_headshothighest_kill_streak nemesis_killshighest_nemesis_streak)r r! BigIntegerNumericr$r%r&_detailed_columnsras2  &"--/D92  '4H2  /2==?TB2  "BMMOdC 2  /2==?TB 2  -4@ 2  #R]]_tD2  -4@2  /2==?TB2  -4@2  ."--/DA2  -4@2  ."--/DA2  "BMMOdC2  , $?2  )2==?TJ!2 " $bmmoE#2 $ & $G%2 & ."--/DA'2 ( *BMMOdK)2 * )2==?TJ+2 , )2==?TJ-2 . $bmmoE/2 0 $bmmoE12 2 '2==?T:32 4 (BMMOd;52 6 ."--/DA72 8 &"--/D992 : (BMMOd;;2 < -4@=2 > +r}}>?2 @ )R]]_t[2 \ $bjjQ&7$G]2 ^ '4H_2 ` /2==?TBa2 b *BMMOdKc2 2r%prefixc ~tj|dtjddtj|dtjddtj|d tjddtj|d tjddtj|d tjdd tj|d tjdtj|dtjdgS)N_stateFrr_last_attempt_atTrr*_last_success_at _next_due_at_consecutive_failures0_last_error_class_last_error_message)r r!Textr"Integer)rbs r&_state_columnsrnVs VHF#RWWYO`a VH,-r{{D/ITXY VH,-r{{D/ITXY VHL)2;;+EPTU VH12BJJL5ade VH-. DI VH/0"'')dK r%c">tjdtjdtjdtj tj ddtjdtj d tjd tjd tjd tjd tjd tjd d tjdtjd d gttjdd dtjddtjddtjddtjdgtjdddgtjdtjdtj tjdddtjdtjdtjd tjd d tjdtjd d tjddtjdtjd tj tj ddtjdtj tjddd tjd!tjd tjd tjd d tjdtjd d tjdd!d"tjd#d$tjd%dtjd&gtjd'tjd(tj tj ddtjd)tjd tjd*tj d tjd+tjd,-d tjd.tjd tjd/tjd tjd0tjd d tjd1tjd d tjd2tjd g ttjd3d4tjd5d6tjd7d'tjd8gd9tjd:tjd(tj tjd;ddtjdtj tjdddtjd tjd d tjdtjd d tjdtjd dtjd?@tjdAtjdBtj tj ddtjdtj tjddd gt!tjdCtjd d tjdDdAdtjdEgtjdFtjdGtj tj ddtjdHtjddItjd!tjd tjdJtjd tjdKtjd tjd tjd d tjdtjd d tjdLtjdtj tjdddtjdGtj tjdMddtjdNtj d tjdOtj d tjdPtj d tjdQtj d tjdRtj d tjd=tjd d tjd>tjd dtjd?@ tjdStjdTtj tj ddtjdUtjddItjd!tjd tjdJtjd tjdKtjd tjd tjd d tjdtjd d tjdVtjdtj tjdddtjdTtj tjdWddtjdNtj d tjdXtj d tjdYtj d tjd=tjd d tjd>tjd dtjd?@g}t"D]}|j%t'|t"Dcgc] }tj|dZd[|d\"}}t"Dcgc] }tj|d]d[|d^"}}tjd_tjdtj tjdddg|tjd>tjd dtjd?@||t"D]9}tjd`|dad_|dbgtj|dcd;tjdetjdftjdtjdgtj ddh@tjditjd d tjd1tjd d tjd2tjd tjd>tjd dtjd?@tjdjdktjdltjdmt)j*dndtjdoptjdqtjd tjdrtjd tjdstjd tjdttjd tjdutj,dtjdv@tjdwtj,dtjdx@tjdytjd tjdztjd d tjd{tjd d tjd|tjdd}@tjd~tjd d tjdtj d gttjdtjd d tjddtjddtjddtjddtjddtjddltjdgdtjdtjddld|d{gtjddtjddldtgtjddtjdtjdtj tj ddtjdtj tjddd tjdtjd tjdstjd tjdtjd tjdtjd tjdtjdd@tjdtj.ddh@tjdtjd dtjd?@tjdtj.ddh@tjdmt)j*dntjddd tjdt)j*dnd tjdtjd d tjdztjd d tjdtjd d tjdtjd tjdtjd d gttjdddtjddtjddtjddtjddtjddtjddtjdddsdtjddddgtjddtjddddgtjddtjdddmgtjddtj0ddlddgdgdtjdtjdtj tj ddtjdtjd dtjd?@tjdmt)j*dntjddd tjdtjd tjdtjd tjdtjd tjdtj d tjdtj tjddd tjdtj d tjd tjd tjdtjd tjdstjd tjdtjd tjdtj.d tjdtjd tjdtj d tjdtj.d tjdtjd tjdtjd tjdt)j*dnd tjdt)j2d tjddƬtjddȬtjddʬtjdd̬tjddάtjddЬtjddҬtjddtjdԫgtjdddmtjdԫgtjdddtjdԫgtjd׫dtjddd dtjdԫgtjd٫dtjddddgtjd۫dtjdddtjdԫgtjdddtjdԫgtjdޫdycc}wcc}w)Nz'CREATE EXTENSION IF NOT EXISTS pgcryptosoldiers soldier_idT)always) primary_key persona_idFr*platform current_name first_seen_atr last_seen_atuq_soldiers_persona_platform)namez"platform IN ('pc','ps4','xboxone')soldiers_platform_checkzbtrim(current_name) <> ''soldiers_name_nonemptyix_soldiers_current_name_lowerzlower(current_name)ix_soldiers_last_seensoldier_sourceszsoldiers.soldier_idCASCADE)ondelete source_typez!source_type IN ('bf4sw','manual')soldier_sources_type_check soldier_namessoldier_name_idrzuq_soldier_names_soldier_namezbtrim(name) <> ''soldier_names_name_nonemptyix_soldier_names_name_lowerz lower(name)battlelog_profiles profile_idbattlelog_usernamebattlelog_user_id country_code)length country_name access_statelast_checked_atlast_success_at last_errorzYaccess_state IN ('public_country','public_no_country','friends_only','not_found','error')%battlelog_profiles_access_state_checkz:country_code IS NULL OR country_code = upper(country_code)&battlelog_profiles_country_upper_check$uq_battlelog_profiles_username_lowerzlower(battlelog_username))uniqueprofile_soldierszbattlelog_profiles.profile_iddetailed_stats_currentsource_fetched_atrrrdetailed_stats_history snapshot_id observed_at$ix_detailed_history_soldier_observedzobserved_at DESCweapon_catalog weapon_id weapon_guid)rrslugcategorysoldier_weapon_statszweapon_catalog.weapon_idrBrXrGrHtime_equipped_secondsvehicle_catalog vehicle_id vehicle_guidsoldier_vehicle_statszvehicle_catalog.vehicle_idtime_in_secondsdestroy_x_in_yzI_state IN ('never_attempted','success','temporary_failure','unavailable')collection_state_ _state_checkz_consecutive_failures >= 0_failures_checkcollection_stateix_collection_state__duergz_next_due_at IS NOT NULL)postgresql_wherediscovery_state source_name last_alias_idri last_poll_atzlast_alias_id >= 0discovery_state_alias_id_check collectorscollector_uuid)as_uuidzgen_random_uuid())rsrcollector_namehostnamelane egress_keyenabledtruedrainedfalsesoftware_version started_atlast_heartbeat_atheartbeat_stateunknownheartbeat_lost_atcurrent_job_id retired_atzbtrim(collector_name) <> ''collectors_name_nonemptyzbtrim(hostname) <> ''collectors_hostname_nonemptyzbtrim(egress_key) <> ''collectors_egress_nonemptyz$lane IN ('background','interactive')collectors_lane_checkz/heartbeat_state IN ('unknown','healthy','lost') collectors_heartbeat_state_checkuq_collectors_active_namezlower(collector_name)zretired_at IS NULL)rrix_collectors_heartbeatix_collectors_egresscollection_jobsjob_idresourcepriority_classreasonstatuspendingpriority_value eligible_at attempt_countzcollectors.collector_uuidzSET NULL lease_token claimed_atlease_expires_atlast_error_class last_error_at#uq_collection_jobs_soldier_resourcez7resource IN ('detailed','profile','weapons','vehicles')collection_jobs_resource_checkcollection_jobs_lane_checkz?priority_class IN ('interactive','active','recent','bootstrap')$collection_jobs_priority_class_checkz)status IN ('pending','claimed','running')collection_jobs_status_checkzattempt_count >= 0#collection_jobs_attempt_count_checka((status = 'pending' AND collector_uuid IS NULL AND lease_token IS NULL AND claimed_at IS NULL AND started_at IS NULL AND lease_expires_at IS NULL) OR (status = 'claimed' AND collector_uuid IS NOT NULL AND lease_token IS NOT NULL AND claimed_at IS NOT NULL AND started_at IS NULL AND lease_expires_at IS NOT NULL) OR (status = 'running' AND collector_uuid IS NOT NULL AND lease_token IS NOT NULL AND claimed_at IS NOT NULL AND started_at IS NOT NULL AND lease_expires_at IS NOT NULL))!collection_jobs_lease_shape_checkix_collection_jobs_claimzpriority_value DESCrzstatus = 'pending' ix_collection_jobs_expired_leasezstatus IN ('claimed','running')ix_collection_jobs_collectorzcollector_uuid IS NOT NULLfk_collectors_current_jobcollection_eventsevent_id occurred_atcollector_name_snapshothostname_snapshotegress_key_snapshot event_typeattempt_numberresult duration_ms http_status error_class error_messagemetadatazKresource IS NULL OR resource IN ('detailed','profile','weapons','vehicles') collection_events_resource_checkz4lane IS NULL OR lane IN ('background','interactive')collection_events_lane_checkz6platform IS NULL OR platform IN ('pc','ps4','xboxone') collection_events_platform_checkz-attempt_number IS NULL OR attempt_number >= 0collection_events_attempt_checkz'duration_ms IS NULL OR duration_ms >= 0 collection_events_duration_checkz6http_status IS NULL OR http_status BETWEEN 100 AND 599#collection_events_http_status_checkzbtrim(event_type) <> ''%collection_events_event_type_nonemptyix_collection_events_timezoccurred_at DESC#ix_collection_events_collector_time!ix_collection_events_soldier_timezsoldier_id IS NOT NULL!ix_collection_events_persona_timezpersona_id IS NOT NULLix_collection_events_jobzjob_id IS NOT NULLix_collection_events_type_time ix_collection_events_http_errorszhttp_status IS NOT NULL)rexecute create_tabler r!r_Identityrlr"r'UniqueConstraintCheckConstraint create_indexr# ForeignKeyStringra RESOURCESextendrnrUUIDBooleanrmcreate_foreign_keyJSONB) state_columnsr state_checksfailure_checkss r&upgraderbsJJ89OO , D1IW[\ , %@ *bggi%8 ."'')e< /2;;#=N ."++t"Eab OO #R]]_bkk6N\`a , ?T_h1ityz &"'')e4 /2;;#=N ."++t"Xcl0m{ A '2==?U; +r}}? -5A +r}}? )2==?UK %r{{D'AER , T :U[][b[bcj[kl OO , D1IW[\ ."'')eDI &"'')e4 &"'')d3 *bggi$7 /2;;#=N ."++t" *bggi%8 &"'')e4 , E: )RZZ\E"''RX/Z )RZZ\E"''RYJZ[ $bggi$? , T :TJ %r{{D'ADQ #RWWYyY %r{{D'ADQ "BMMOdC  , T :TJ!" 8?YZ#$ 29WX%& 4;WX'( AH_`)* LSuv+.OO/H_@`?ajnBDBIBIJ^B_`OO-|>OQd=exzxxAUyVWOO*L<.[][b[bcw[xyOO (BMMOR[[-ESWX , ?T_h1ityz *bggi%8 &"'')e4 "BGGI> (BGGI6 (BGGIiP "BJJL5QTU -d!;e\^\c\cdk\lm /2::<%PST "JOOD$A2==QlxBDCNR S -!>N , T :TJ , T :TJ $bkk4&@4P $bggi$? /2;;#=M%& '( L*;`a)* T[{|+, AHde-. \dJ K/0 FMkl12 /6[\34 BIl m58OO.0AFL\^`^e^ef{^|LNZ\dDexzxx@TxUVOO68IL^`hKi|~}D}DEf}ghOO24EHXGYlnlslsuQmRS5|EVYiXjmulvBLMOO *bmmor{{$/GUYZ -d!;e\^\c\cdk\lm "JOOD$A2==QlxBDCNR S +RWWYF %rwwy4@ 'TB (BMMOd; , ?T_i1juyz , $? *bggi$7 *bggi$7 &"'')d3 , E: "BJJL4@ (BGGI5 -4@ -= -T: /2779t< -!>N *j..04@ hpR S QXvw SZ|} JQrs DKmn SZ A 4;bc;>OO/1DrwwOaGbFcdOO9;NQacecjcjk}c~PAOO79L|]_]d]dew]xNyMOMTMTUmMnoOO79Lz[gikipiprDjEOFY[Y`Y`ayYz{OO.0ChP]E^qsqxqxzNrOPOO46ILZ\ZaZabtZuKvwOO68Km]_]d]dew]xMyMOMTMTUnMops%A}.%A}3ctjdtjdddtjdtjdtjdtjdtjd tjd tjd tjd tjd tjdtjdtjdtjdtjdtjdy)Nrrr foreignkey)type_rrrrrrrrrrrrrrp)r drop_tabledrop_constraintr$r%r& downgrader!gsMM%&2L UMM#$MM,MM#$MM$%MM)*MM#$MM()MM"#MM*+MM*+MM$%MM&'MM/"MM#$MM*r%)rN)__doc__collections.abcralembicr sqlalchemyr sqlalchemy.dialectsrrstr__annotations__rr r PLATFORMSrCOLLECTION_RESULTSlistr!r'rarnrr!r$r%r&r,s%*%#% sTz &* x}t#*#' HSMD ' $ : WT"))_44 ?4n 3 4 ? BpJr%