1"use strict";(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[664],{29147:(e,t,n)=>{n.d(t,{Ks:()=>i,O$:()=>a,E3:()=>r,iK:()=>d});let a="^[a-z][a-z0-9_]*$";new RegExp(a);let d=["dev","admin","staff","media","user","email"],r="^[a-zA-Z][a-zA-Z0-9._]*$";new RegExp(r);let i=["opted_in","subscribed","unsubscribed"]},42777:(e,t,n)=>{n.d(t,{gf:()=>_,aL:()=>f,Ld:()=>o,g9:()=>s,gj:()=>u});var a=n(87173),d=n(72521);let r={CUSTOM_NODE_ENV:n(43641).env.CUSTOM_NODE_ENV},i="0123456789abcdefghijklmnopqrstuvwxyz",l=e=>"^[".concat(i,"]{").concat(e,"}$"),o=(0,a.d_)(i,12);new RegExp(l(12));let s=(0,a.d_)(i,16);l(16);let u=(0,a.d_)(i,8),_=l(8),c=(()=>{switch(r.CUSTOM_NODE_ENV){case"Unrivaled":return 1n;case"Dev":return 2n;case"Localhost":return 3n;default:return 4n}})(),p=new d.D0(1712448000000n),f=()=>p.generate({workerId:c})},50664:(e,t,n)=>{n.d(t,{UH2:()=>F,qM3:()=>tv,dnu:()=>ei,O2V:()=>eu,XF5:()=>e_,Ry5:()=>eg,l0r:()=>ex,P9E:()=>eA,DFL:()=>eX,K55:()=>T,Sj0:()=>e3,R9y:()=>tn,PPx:()=>tt,TWw:()=>e2,XJR:()=>ty,hHj:()=>ev,OZF:()=>c,TTn:()=>tL,rO6:()=>N,Y05:()=>m,_YT:()=>L,IvK:()=>P,eX_:()=>z,Td7:()=>O,fWE:()=>M,dtS:()=>J,jrl:()=>Y,As1:()=>eW,Dfq:()=>H,y0c:()=>V,AZP:()=>el,oWU:()=>eo,g7g:()=>ep,Z3I:()=>eQ,agh:()=>ew,zC:()=>eP,bjQ:()=>eE,HKy:()=>tH,j2p:()=>eS,VEA:()=>ts,AWp:()=>eZ,ibd:()=>B,fv0:()=>ti,paG:()=>tG,_V$:()=>e7,$2t:()=>to,RDd:()=>tY,Fk5:()=>e6,qYQ:()=>tW,c_T:()=>te,cox:()=>e4,B08:()=>tr,FCj:()=>tT,GG3:()=>tF,ke7:()=>tz,HxA:()=>tJ,gWH:()=>tC,$VH:()=>tN,DKp:()=>tl,H_Z:()=>tV,rXv:()=>tI,bJ2:()=>tQ,eD1:()=>tg,MVT:()=>ed,zZP:()=>eH,hTf:()=>tk,v8w:()=>tE,VVi:()=>tA,Ldt:()=>tS,VSM:()=>tU,a5g:()=>tD,yXm:()=>tj});var a=n(42777),d=n(28107),r=n(88373),i=n(56189),l=n(50554),o=n(45590),s=n(42422),u=n(78675),_=n(97650);let c=(0,r.cJ)("articles",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id),gameTab:(0,i.Qq)("game_tab",{enum:["preview","recap"]}),thumbnailId:(0,i.Qq)("thumbnail_id").unique().notNull().references(()=>eP.id),isThumbnailHero:(0,l.zM)("is_thumbnail_hero").default(!0).notNull(),slug:(0,i.Qq)("slug").unique().notNull(),title:(0,i.Qq)("title").unique().notNull(),content:(0,o.Fx)("content").$type().notNull(),contentJson:(0,o.Fx)("content_json").$type(),publicAt:(0,s.vE)("public_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.gameId,e.gameTab),(0,_.Pe)("articles_thumbnail_id_idx").on(e.thumbnailId),(0,_.Pe)("articles_public_at_idx").on(e.publicAt),(0,_.Pe)("articles_created_at_idx").on(e.createdAt)]);(0,d.K1)(c,e=>{let{one:t,many:n}=e;return{thumbnail:t(eP,{fields:[c.thumbnailId],references:[eP.id]}),imagesToArticles:n(eE),taggables:n(tN),game:t(ew,{fields:[c.gameId],references:[ew.id]})}});var p=n(30404),f=n(53183);(0,r.cJ)("accounts",{userId:(0,i.Qq)("userId").notNull().references(()=>tA.id,{onDelete:"cascade"}),type:(0,i.Qq)("type").$type().notNull(),provider:(0,i.Qq)("provider").notNull(),providerAccountId:(0,i.Qq)("providerAccountId").notNull(),refresh_token:(0,i.Qq)("refresh_token"),access_token:(0,i.Qq)("access_token"),expires_at:(0,p.nd)("expires_at"),token_type:(0,i.Qq)("token_type"),scope:(0,i.Qq)("scope"),id_token:(0,i.Qq)("id_token"),session_state:(0,i.Qq)("session_state")},e=>({compoundKey:(0,f.ie)({columns:[e.provider,e.providerAccountId]})})),(0,r.cJ)("sessions",{sessionToken:(0,i.Qq)("sessionToken").primaryKey(),userId:(0,i.Qq)("userId").notNull().references(()=>tA.id,{onDelete:"cascade"}),expires:(0,s.vE)("expires",{mode:"date"}).notNull()}),(0,r.cJ)("verification_codes",{identifier:(0,i.Qq)("identifier").notNull(),token:(0,i.Qq)("token").notNull(),expires:(0,s.vE)("expires",{mode:"date"}).notNull()},e=>({compoundKey:(0,f.ie)({columns:[e.identifier,e.token]})}));let m=(0,r.cJ)("better_sessions",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),userId:(0,i.Qq)("user_id").notNull().references(()=>tA.id,{onDelete:"cascade"}),token:(0,i.Qq)("token").unique().notNull(),expiresAt:(0,s.vE)("expires_at").notNull(),ipAddress:(0,i.Qq)("ip_address"),userAgent:(0,i.Qq)("user_agent"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("better_sessions_user_id_created_at_idx").on(e.userId,e.createdAt)]);(0,d.K1)(m,e=>{let{one:t}=e;return{user:t(tA,{fields:[m.userId],references:[tA.id]})}});let N=(0,r.cJ)("better_accounts",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),userId:(0,i.Qq)("user_id").notNull().references(()=>
1tA.id,{onDelete:"cascade"}),accountId:(0,i.Qq)("account_id").notNull(),providerId:(0,i.Qq)("provider_id").notNull(),accessToken:(0,i.Qq)("access_token"),refreshToken:(0,i.Qq)("refresh_token"),accessTokenExpiresAt:(0,s.vE)("access_token_expires_at"),refreshTokenExpiresAt:(0,s.vE)("refresh_token_expires_at"),scope:(0,i.Qq)("scope"),idToken:(0,i.Qq)("id_token"),password:(0,i.Qq)("password"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()});(0,d.K1)(N,e=>{let{one:t}=e;return{user:t(tA,{fields:[N.userId],references:[tA.id]})}}),(0,r.cJ)("better_verifications",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),identifier:(0,i.Qq)("identifier").notNull(),value:(0,i.Qq)("value").notNull(),expiresAt:(0,s.vE)("expires_at").notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()});var y=n(11477),I=n(73417),q=n(78119),v=n(93206);function g(){let e=(0,y._)([""," <> ",""]);return g=function(){return e},e}function Q(){let e=(0,y._)(["("," IS NULL) = ("," IS NULL)"]);return Q=function(){return e},e}function h(){let e=(0,y._)(["(("," IS NULL) AND ("," IS NULL)) = ("," IS NULL)"]);return h=function(){return e},e}function b(){let e=(0,y._)(["("," IS NULL) OR (("," IS NULL) <> ("," IS NULL))"]);return b=function(){return e},e}function w(){let e=(0,y._)([""," >= 1 AND "," % 2 = 1"]);return w=function(){return e},e}function x(){let e=(0,y._)([""," >= 1"]);return x=function(){return e},e}function A(){let e=(0,y._)([""," >= 1"]);return A=function(){return e},e}let P=(0,r.cJ)("brackets",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),seasonYear:(0,i.Qq)("season_year").references(()=>tr.year).notNull(),type:(0,i.Qq)("type",{enum:["1-on-1 Tournament","Playoffs"]}).notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.seasonYear,e.type)]);(0,d.K1)(P,e=>{let{many:t}=e;return{bracketNodes:t(L)}});let L=(0,r.cJ)("bracket_nodes",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),bracketId:(0,i.Qq)("bracket_id").references(()=>P.id).notNull(),nextNodeId:(0,i.Qq)("next_node_id"),notice:(0,i.Qq)("notice"),winnerNextSlot:(0,i.Qq)("winner_next_slot",{enum:["away","home"]}),round:(0,p.nd)("round").notNull(),roundName:(0,i.Qq)("round_name",{enum:["First Round","Second Round","Quarterfinals","Semifinals","Finals","Championship"]}).notNull(),position:(0,p.nd)("position").notNull(),bestOf:(0,p.nd)("best_of").default(1).notNull(),byePlayerId:(0,i.Qq)("bye_player_id").references(()=>e6.id),byeTeamId:(0,i.Qq)("bye_team_id").references(()=>tI.id),byeSlot:(0,i.Qq)("bye_slot",{enum:["away","home"]}),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,I.mt)({columns:[e.nextNodeId],foreignColumns:[e.id],name:"bracket_nodes_next_node_id_fk"}),(0,u.Am)().on(e.bracketId,e.round,e.position),(0,u.Am)().on(e.nextNodeId,e.winnerNextSlot),(0,q.z6)("bracket_nodes_next_node_not_self",(0,v.ll)(g(),e.id,e.nextNodeId)),(0,q.z6)("bracket_nodes_next_node_requires_slot",(0,v.ll)(Q(),e.nextNodeId,e.winnerNextSlot)),(0,q.z6)("bracket_nodes_bye_requires_slot",(0,v.ll)(h(),e.byePlayerId,e.byeTeamId,e.byeSlot)),(0,q.z6)("bracket_nodes_bye_player_xor_team",(0,v.ll)(b(),e.byeSlot,e.byePlayerId,e.byeTeamId)),(0,q.z6)("bracket_nodes_best_of_positive_odd",(0,v.ll)(w(),e.bestOf,e.bestOf)),(0,q.z6)("bracket_nodes_round_gte_1",(0,v.ll)(x(),e.round)),(0,q.z6)("bracket_nodes_position_gte_1",(0,v.ll)(A(),e.position)),(0,_.Pe)("bracket_nodes_bracket_id_idx").on(e.bracketId)]);function E(){let e=(0,y._)(["("," IS NULL) OR ("," IS NULL) OR ("," < ",")"]);return E=function(){return e},e}function k(){let e=(0,y._)(["("," IS NULL) OR ("," IS NOT NULL)"]);return k=function(){return e},e}function $(){let e=(0,y._)(["lower(",")"]);return $=function(){return e},e}function S(){let e=(0,y._)(["\n (\n ("," = 'player')\n AND ("," IS NOT NULL)\n AND ("," IS NULL)\n AND ("," IS NULL)\n )\n OR\n (\n ("," = 'team')\n AND ("," IS NOT NULL)\n AND ("," IS NULL)\n AND ("," IS NULL)\n )\n OR\n (\n ("," = 'value')\n AND ("," IS NULL)\n AND ("," IS NULL)\n AND ("," IS NOT NULL)\n )\n "]);return S=function(){return e},e}function K(){let e=(0,y._)([""," = 'correct'"]);return K=function(){return e},e}function U(){let e=(0,y._)([""," > 0"]);return U=function(){return e},e}function D(){let e=(0,y._)(["(("," IS NULL) = ("," IS NULL))"]);return D=function(){return e},e}(0,d.K1)(L,e=>{let{one:t,many:n}=e;return{bracket:t(P,{fields:[L.bracketId],references:[P.id]}),nextNode:t(L,{fields:[L.nextNodeId],references:[L.id]}),games:n(ew),byePlayer:t(e6,{fields:[L.byePlayerId],references:[e6.id]}),byeTeam:t(tI,{fields:[L.byeTeamId],references:[tI.id]})}});let F=["win_game","most_points","most_rebounds","most_assists","most_blocks","most_steals","other"],T=["player","team","value"],J=(0,r.cJ)("challenges",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),seasonYear:(0,i.Qq)("season_year").references(()=>tr.year).notNull(),logoId:(0,i.Qq)("logo_id").references(()=>eP.id),bannerId:(0,i.Qq)("banner_id").references(()=>eP.id),bannerText:(0,i.Qq)("banner_text"),bannerColor:(0,i.Qq)("banner_color"),scope:(0,i.Qq)("scope",{enum:["Single Game","Multi Game","No Game"]}).notNull(),category:(0,i.Qq)("category",{enum:["1-on-1","Academy","Playoffs","Championship"]}).notNull(),kind:(0,i.Qq)("kind",{enum:["Picks","Bracket","Video Submission"]}).notNull(),slug:(0,i.Qq)("slug").notNull().unique(),name:(0,i.Qq)("name").notNull(),description:(0,i.Qq)("description"),prize:(0,i.Qq)("prize"),rules:(0,o.Fx)("rules").$type(),maxEntries:(0,p.nd)("max_entries").default(1).notNull(),publicAt:(0,s.vE)("public_at"),openAt:(0,s.vE)("open_at"),closeAt:(0,s.vE)("close_at"),archivedAt:(0,s.vE)("archived_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.seasonYear,e.name),(0,q.z6)("challenges_open_before_close_chk",(0,v.ll)(E(),e.o
1penAt,e.closeAt,e.openAt,e.closeAt)),(0,q.z6)("challenges_close_requires_open_chk",(0,v.ll)(k(),e.closeAt,e.openAt)),(0,_.Pe)("challenges_season_year_idx").on(e.seasonYear),(0,_.Pe)("challenges_name_idx").on(e.name),(0,_.Pe)("challenges_public_at_idx").on(e.publicAt),(0,_.Pe)("challenges_open_at_idx").on(e.openAt),(0,_.Pe)("challenges_close_at_idx").on(e.closeAt),(0,_.Pe)("challenges_archived_at_idx").on(e.archivedAt),(0,_.Pe)("challenges_created_at_idx").on(e.createdAt)]);(0,d.K1)(J,e=>{let{one:t,many:n}=e;return{season:t(tr,{fields:[J.seasonYear],references:[tr.year]}),logo:t(eP,{fields:[J.logoId],references:[eP.id],relationName:"logo"}),banner:t(eP,{fields:[J.bannerId],references:[eP.id],relationName:"banner"}),entries:n(z),challengeGames:n(O),questions:n(M)}});let z=(0,r.cJ)("challenge_entries",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),challengeId:(0,i.Qq)("challenge_id").references(()=>J.id).notNull(),userId:(0,i.Qq)("user_id").references(()=>tA.id).notNull(),videoId:(0,i.Qq)("video_id").references(()=>tS.id),entryNumber:(0,p.nd)("entry_number").default(1).notNull(),score:(0,p.nd)("score"),reviewStatus:(0,i.Qq)("review_status",{enum:["pending","approved","rejected"]}),reviewNotes:(0,i.Qq)("review_notes"),reviewedAt:(0,s.vE)("reviewed_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.challengeId,e.userId,e.entryNumber),(0,_.Pe)("challenge_entries_challenge_id_idx").on(e.challengeId),(0,_.Pe)("challenge_entries_user_id_idx").on(e.userId),(0,_.Pe)("challenge_entries_video_id_idx").on(e.videoId),(0,_.Pe)("challenge_entries_challenge_review_status_idx").on(e.challengeId,e.reviewStatus),(0,_.Pe)("challenge_entries_challenge_score_idx").on(e.challengeId,e.score),(0,_.Pe)("challenge_entries_created_at_idx").on(e.createdAt)]);(0,d.K1)(z,e=>{let{one:t,many:n}=e;return{challenge:t(J,{fields:[z.challengeId],references:[J.id]}),user:t(tA,{fields:[z.userId],references:[tA.id]}),video:t(tS,{fields:[z.videoId],references:[tS.id]}),picks:n(j)}});let O=(0,r.cJ)("challenge_games",{challengeId:(0,i.Qq)("challenge_id").references(()=>J.id).notNull(),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,f.ie)({columns:[e.challengeId,e.gameId]}),(0,_.Pe)("challenge_games_challenge_id_idx").on(e.challengeId),(0,_.Pe)("challenge_games_game_id_idx").on(e.gameId),(0,_.Pe)("challenge_games_created_at_idx").on(e.createdAt)]);(0,d.K1)(O,e=>{let{one:t,many:n}=e;return{challenge:t(J,{fields:[O.challengeId],references:[J.id]}),game:t(ew,{fields:[O.gameId],references:[ew.id]}),challengeQuestions:n(M)}});let M=(0,r.cJ)("challenge_questions",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),challengeId:(0,i.Qq)("challenge_id").references(()=>J.id).notNull(),gameId:(0,i.Qq)("game_id").references(()=>ew.id),topic:(0,i.Qq)("topic",{enum:F}).notNull(),prompt:(0,i.Qq)("prompt").notNull(),order:(0,p.nd)("order").notNull(),lockAt:(0,s.vE)("lock_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,I.mt)({columns:[e.challengeId,e.gameId],foreignColumns:[O.challengeId,O.gameId],name:"challenge_questions_challenge_game_fk"}),(0,u.Am)().on(e.challengeId,e.order),(0,_.Pe)("challenge_questions_game_id_idx").on(e.gameId)]);(0,d.K1)(M,e=>{let{one:t,many:n}=e;return{challenge:t(J,{fields:[M.challengeId],references:[J.id]}),game:t(ew,{fields:[M.gameId],references:[ew.id]}),options:n(R),picks:n(j)}});let B=(0,r.cJ)("option_values",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),type:(0,i.Qq)("type",{enum:T}).notNull(),playerId:(0,i.Qq)("player_id").references(()=>e6.id).unique(),teamId:(0,i.Qq)("team_id").references(()=>tI.id).unique(),value:(0,i.Qq)("value"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.GL)("option_values_value_lower_uq").on((0,v.ll)($(),e.value)),(0,q.z6)("option_values_type_requires_correct_target",(0,v.ll)(S(),e.type,e.playerId,e.teamId,e.value,e.type,e.teamId,e.playerId,e.value,e.type,e.playerId,e.teamId,e.value))]);(0,d.K1)(B,e=>{let{one:t,many:n}=e;return{player:t(e6,{fields:[B.playerId],references:[e6.id]}),team:t(tI,{fields:[B.teamId],references:[tI.id]}),challengeOptions:n(R),challengePicks:n(j)}});let R=(0,r.cJ)("challenge_options",{questionId:(0,i.Qq)("question_id").references(()=>M.id).notNull(),optionValueId:(0,i.Qq)("option_value_id").references(()=>B.id).notNull(),order:(0,p.nd)("order").notNull(),outcome:(0,i.Qq)("outcome",{enum:["correct","incorrect","void"]}),resolvedAt:(0,s.vE)("resolved_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,f.ie)({columns:[e.questionId,e.optionValueId]}),(0,u.Am)("challenge_options_question_id_order_uq").on(e.questionId,e.order),(0,_.GL)("challenge_options_one_correct_uq").on(e.questionId).where((0,v.ll)(K(),e.outcome)),(0,q.z6)("challenge_options_order_positive_chk",(0,v.ll)(U(),e.order)),(0,q.z6)("challenge_options_resolution_pair_chk",(0,v.ll)(D(),e.outcome,e.resolvedAt)),(0,_.Pe)("challenge_options_question_id_idx").on(e.questionId),(0,_.Pe)("challenge_options_option_value_id_idx").on(e.optionValueId)]);(0,d.K1)(R,e=>{let{one:t,many:n}=e;return{question:t(M,{fields:[R.questionId],references:[M.id]}),optionValue:t(B,{fields:[R.optionValueId],references:[B.id]}),picks:n(j)}});let j=(0,r.cJ)("challenge_picks",{entryId:(0,i.Qq)("entry_id").references(()=>z.id).notNull(),questionId:(0,i.Qq)("question_id").references(()=>M.id).notNull(),optionValueId:(0,i.Qq)("option_value_id").references(()=>B.id).notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,f.ie)({columns:[e.entryId,e.questionId]}),(0,I.mt)({columns:[e.questionId,e.optionValueId],foreignColumns:[R.questionId,R.optionValueId],name:"challenge_entry_picks_question_option_value_fk"}).onDelete("cascade"),(0,_.Pe)("challenge_entry_picks_question_id_idx").on(e.questionId),(0,_.Pe)("challenge_entry_picks_option_value_id_idx").on(e.optionValueId),(0,_.Pe)("challenge_entry_picks_created_at_idx").on(e.createdAt)]);function C(){let e=(0,y._)(["(","->>'type')"]);return C=function(){return e},e}function G(){let e=(0,y._)(["(","->>'name')"]);return G=function(){return e},e}(0,d.K1)(j,e=>{let{one:t}=e;return{entry:t(z,{fields:[j.entryId],references:[z.id]}),question:t(M,{fields:[j.questionId],references:[M.id]}),challengeOption:t(R,{fields:[j.questionId,j.optionValueId],references:[R.questionId,R.optionValueId]})}});let V=(0,r.cJ)("devices",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.g9)()),type:(0,i.Qq)("type",{enum:["mobile","tablet","console","smarttv","wearable","xr","embedded","kiosk","desktop"]}).notNull(),manufacturer:(0,i.Qq)("manufacturer"),model:(0,i.Qq)("model"),os:(0,i.Qq)("os"),userAgent:(0,i.Qq)("user_agent"),client:(0,o.Fx)("client").$type().notNull(),screen:(0,o.Fx)("screen").$type(),isBot:(0,l.zM)("is_bot").notNull().default(!1),cookieExpiresAt:(0,s.vE)("cookie_expires_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("devices_created_at_idx").on(e.createdAt),(0,_.Pe)("devices_type_idx").on(e.type),(0,_.Pe)("devices_os_i
1dx").on(e.os),(0,_.Pe)("devices_is_bot_idx").on(e.isBot),(0,_.Pe)("devices_client_type_idx").on((0,v.ll)(C(),e.client)),(0,_.Pe)("devices_client_name_idx").on((0,v.ll)(G(),e.client))]);(0,d.K1)(V,e=>{let{many:t}=e;return{users:t(H),visits:t(tU),events:t(el),locations:t(Y),notificationSubscriptions:t(eW)}});let Y=(0,r.cJ)("device_locations",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.g9)()),deviceId:(0,i.Qq)("device_id").notNull().references(()=>V.id,{onDelete:"cascade"}),locationId:(0,i.Qq)("location_id").notNull().references(()=>eS.id),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("device_locations_location_id_idx").on(e.locationId),(0,_.Pe)("device_locations_created_at_idx").on(e.createdAt),(0,_.Pe)("device_locations_device_id_created_at_idx").on(e.deviceId,e.createdAt)]);(0,d.K1)(Y,e=>{let{one:t}=e;return{device:t(V,{fields:[Y.deviceId],references:[V.id]}),location:t(eS,{fields:[Y.locationId],references:[eS.id]})}});let H=(0,r.cJ)("device_users",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.g9)()),deviceId:(0,i.Qq)("device_id").notNull().references(()=>V.id,{onDelete:"cascade"}),userId:(0,i.Qq)("user_id").notNull().references(()=>tA.id,{onDelete:"cascade"}),count:(0,p.nd)("count").notNull().default(1),lastSeenAt:(0,s.vE)("last_seen_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)("device_users_unique").on(e.deviceId,e.userId),(0,_.Pe)("device_users_last_seen_at_idx").on(e.lastSeenAt),(0,_.Pe)("device_users_device_id_count_idx").on(e.deviceId,e.count),(0,_.Pe)("device_users_user_id_count_idx").on(e.userId,e.count)]);(0,d.K1)(H,e=>{let{one:t}=e;return{device:t(V,{fields:[H.deviceId],references:[V.id]}),user:t(tA,{fields:[H.userId],references:[tA.id]})}});var W=n(29147);function X(){let e=(0,y._)(["lower(",")"]);return X=function(){return e},e}function Z(){let e=(0,y._)([""," IS NULL"]);return Z=function(){return e},e}function ee(){let e=(0,y._)([""," IS NULL"]);return ee=function(){return e},e}function et(){let e=(0,y._)([""," ~ ",""]);return et=function(){return e},e}function en(){let e=(0,y._)([""," > 0"]);return en=function(){return e},e}let ea=(0,r.cJ)("email_topics",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),key:(0,i.Qq)("key").unique().notNull(),name:(0,i.Qq)("name").notNull(),description:(0,i.Qq)("description"),frequency:(0,i.Qq)("frequency",{enum:["daily","weekly","monthly","occasional"]}).notNull(),order:(0,p.nd)("order").notNull(),archivedAt:(0,s.vE)("archived_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.GL)("email_topics_name_lower_uq").on((0,v.ll)(X(),e.name)).where((0,v.ll)(Z(),e.archivedAt)),(0,_.GL)("email_topics_order_uq").on(e.order).where((0,v.ll)(ee(),e.archivedAt)),(0,q.z6)("email_topics_key_charset_chk",(0,v.ll)(et(),e.key,W.O$).inlineParams()),(0,q.z6)("email_topics_order_positive_chk",(0,v.ll)(en(),e.order))]);(0,d.K1)(ea,e=>{let{many:t}=e;return{userEmailSubscriptions:t(ed)}});let ed=(0,r.cJ)("user_email_subscriptions",{userId:(0,i.Qq)("user_id").references(()=>tA.id).notNull(),emailTopicId:(0,i.Qq)("email_topic_id").references(()=>ea.id).notNull(),status:(0,i.Qq)("status",{enum:["subscribed","unsubscribed"]}).notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,f.ie)({columns:[e.userId,e.emailTopicId]}),(0,_.Pe)("user_email_subscriptions_email_topic_id_idx").on(e.emailTopicId),(0,_.Pe)("user_email_subscriptions_status_idx").on(e.status)]);(0,d.K1)(ed,e=>{let{one:t}=e;return{user:t(tA,{fields:[ed.userId],references:[tA.id]}),emailTopic:t(ea,{fields:[ed.emailTopicId],references:[ea.id]})}});var er=n(12101);let ei=["user.signin","user.signout","user.update","user.follow","user.unfollow","email.subscription.update","honeypot.trigger","admin.user.update","admin.user.signout","submission.create","submission.update","page.view","button.click","qr.scan","dialog.open","dialog.close","newsletter.subscription.submit","shop.order.create"],el=(0,r.cJ)("events",{id:(0,er.o)("id",{mode:"bigint"}).primaryKey().$defaultFn(()=>(0,a.aL)()),userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"set null"}),deviceId:(0,i.Qq)("device_id").references(()=>V.id,{onDelete:"set null"}),visitId:(0,i.Qq)("visit_id").references(()=>tU.id,{onDelete:"set null"}),action:(0,i.Qq)("action",{enum:ei}).notNull(),domain:(0,i.Qq)("domain",{enum:["local","dev","www","mobile","shop"]}).notNull(),path:(0,i.Qq)("path").notNull(),properties:(0,o.Fx)("properties").$type().notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("user_events_user_id_idx").on(e.userId),(0,_.Pe)("user_events_device_id_idx").on(e.deviceId),(0,_.Pe)("user_events_visit_id_idx").on(e.visitId),(0,_.Pe)("user_events_action_idx").on(e.action),(0,_.Pe)("user_events_domain_idx").on(e.domain),(0,_.Pe)("user_events_path_idx").on(e.path),(0,_.Pe)("user_events_created_at_idx").on(e.createdAt)]);(0,d.K1)(el,e=>{let{one:t}=e;return{user:t(tA,{fields:[el.userId],references:[tA.id]}),device:t(V,{fields:[el.deviceId],references:[V.id]}),visit:t(tU,{fields:[el.visitId],references:[tU.id]})}}),(0,r.cJ)("failure_logs",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),target:(0,i.Qq)("target").notNull(),type:(0,i.Qq)("type",{enum:["r2_delete","db_delete"]}).notNull(),message:(0,i.Qq)("message").notNull(),error:(0,i.Qq)("failure_error").notNull(),status:(0,i.Qq)("status",{enum:["failed","pending","solved"]}).default("failed").notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>({typeIdx:(0,_.Pe)("failures_type_idx").on(e.type),statusIdx:(0,_.Pe)("failures_status_idx").on(e.status),createdAtIdx:(0,_.Pe)("failures_created_at_idx").on(e.createdAt)}));let eo=(0,r.cJ)("folders",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),parentId:(0,i.Qq)("parent_id"),name:(0,i.Qq)("name").notNull(),description:(0,i.Qq)("description"),order:(0,p.nd)("order").default(0).notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,I.mt)({columns:[e.parentId],foreignColumns:[e.id],name:"folders_parent_id_fk"}),(0,_.Pe)("folders_parent_id_idx").on(e.parentId),(0,_.Pe)("folders_name_idx").on(e.name),(0,_.Pe)("folders_order_idx").on(e.order),(0,_.Pe)("folders_created_at_idx").on(e.createdAt),(0,_.Pe)("folders_parent_order_idx").on(e.parentId,e.order)
1]);function es(){let e=(0,y._)(["("," IS NULL) OR ("," IS NULL) OR ("," >= ",")"]);return es=function(){return e},e}(0,d.K1)(eo,e=>{let{one:t,many:n}=e;return{parent:t(eo,{fields:[eo.parentId],references:[eo.id],relationName:"folderHierarchy"}),children:n(eo,{relationName:"folderHierarchy"}),images:n(eP),videos:n(tS),youtubeVideos:n(tj)}});let eu=["hq","players","tours","contests","fans","partners"],e_=["registration","guess","vote"],ec=(0,r.cJ)("forms",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),handle:(0,i.Qq)("handle").unique(),category:(0,i.Qq)("category").$type().notNull(),type:(0,i.Qq)("type").$type().notNull(),version:(0,p.nd)("version").notNull(),title:(0,i.Qq)("title"),description:(0,i.Qq)("description"),bannerImage:(0,i.Qq)("banner_image"),fields:(0,o.Fx)("fields").$type().notNull(),confirmationType:(0,i.Qq)("confirmation_type").$type(),confirmationMessage:(0,o.Fx)("confirmation_message").$type(),redirectUrl:(0,i.Qq)("redirect_url"),openAt:(0,s.vE)("open_at"),closeAt:(0,s.vE)("close_at"),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.category,e.type,e.version),(0,q.z6)("forms_open_close_order_chk",(0,v.ll)(es(),e.closeAt,e.openAt,e.closeAt,e.openAt)),(0,_.Pe)("forms_open_at_idx").on(e.openAt),(0,_.Pe)("forms_close_at_idx").on(e.closeAt),(0,_.Pe)("forms_created_at_idx").on(e.createdAt)]);(0,d.K1)(ec,e=>{let{many:t}=e;return{formSubmissions:t(ep)}});let ep=(0,r.cJ)("forms_submissions",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),formId:(0,i.Qq)("form_id").references(()=>ec.id).notNull(),userId:(0,i.Qq)("user_id").references(()=>tA.id),deviceId:(0,i.Qq)("device_id").references(()=>V.id).notNull(),newsletterOptIn:(0,l.zM)("newsletter_opt_in"),email:(0,i.Qq)("email"),data:(0,o.Fx)("data").$type().notNull(),audit:(0,o.Fx)("audit").$type().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("form_submissions_form_id_idx").on(e.formId),(0,_.Pe)("form_submissions_user_id_idx").on(e.userId),(0,_.Pe)("form_submissions_device_id_idx").on(e.deviceId),(0,_.Pe)("form_submissions_email_idx").on(e.email),(0,_.Pe)("form_submissions_created_at_idx").on(e.createdAt)]);(0,d.K1)(ep,e=>{let{one:t}=e;return{form:t(ec,{fields:[ep.formId],references:[ec.id]}),user:t(tA,{fields:[ep.userId],references:[tA.id]}),device:t(V,{fields:[ep.deviceId],references:[V.id]})}});var ef=n(21769),em=n(12165);function eN(){let e=(0,y._)([""," IS NULL OR ("," IS NOT NULL AND "," >= ",")"]);return eN=function(){return e},e}let ey=(e,t)=>(0,v.ll)(eN(),e,t,e,t);function eI(){let e=(0,y._)(["("," IS NULL) = ("," IS NULL)"]);return eI=function(){return e},e}function eq(){let e=(0,y._)([""," >= 1"]);return eq=function(){return e},e}let ev=["TNT","truTV","TBD","TNT/truTV"],eg=["Preseason","Regular Season","Playoffs","1-on-1 Tournament"],eQ=(0,r.cJ)("game_predictions",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),userId:(0,i.Qq)("user_id").references(()=>tA.id).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id),playerId:(0,i.Qq)("player_id").references(()=>e6.id),type:(0,i.Qq)("type",{enum:["who will win?","1-on-1 Bracket"]}).notNull(),outcome:(0,i.Qq)("outcome",{enum:["correct","incorrect","void"]}),resolvedAt:(0,s.vE)("resolved_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>({unique:(0,u.Am)().on(e.gameId,e.userId,e.type),userOutcomeIdx:(0,_.Pe)("game_predictions_user_outcome_idx").on(e.userId,e.outcome),teamIdIdx:(0,_.Pe)("game_predictions_team_id_idx").on(e.teamId),playerIdIdx:(0,_.Pe)("game_predictions_player_id_idx").on(e.playerId),userIdIndx:(0,_.Pe)("game_predictions_user_id_idx").on(e.userId)}));(0,d.K1)(eQ,e=>{let{one:t}=e;return{game:t(ew,{fields:[eQ.gameId],references:[ew.id]}),user:t(tA,{fields:[eQ.userId],references:[tA.id]}),team:t(tI,{fields:[eQ.teamId],references:[tI.id]}),player:t(e6,{fields:[eQ.playerId],references:[e6.id]})}});let eh=(0,r.cJ)("venues",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),name:(0,i.Qq)("name").notNull(),capacity:(0,p.nd)("capacity").notNull(),address:(0,i.Qq)("address").notNull(),city:(0,i.Qq)("city").notNull(),state:(0,i.Qq)("state").notNull(),country:(0,i.Qq)("country").notNull(),postalCode:(0,i.Qq)("postal_code").notNull(),lat:(0,ef._)("lat",{precision:8,scale:6}).notNull(),lng:(0,ef._)("lng",{precision:9,scale:6}).notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("venues_name_idx").on(e.name),(0,u.Am)("venues_name_state_unique").on(e.name,e.state)]);(0,d.K1)(eh,e=>{let{many:t}=e;return{gameEvents:t(eb)}});let eb=(0,r.cJ)("game_events",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),venueId:(0,i.Qq)("venue_id").references(()=>eh.id).notNull(),date:(0,s.vE)("date").notNull(),ticketUrl:(0,i.Qq)("ticket_url"),publicAt:(0,s.vE)("public_at"),venuePublicAt:(0,s.vE)("venue_public_at"),ticketUrlPublicAt:(0,s.vE)("ticket_url_public_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,q.z6)("game_events_venue_public_at_requires_public_at",ey(e.venuePublicAt,e.publicAt)),(0,q.z6)("game_events_ticket_url_public_at_requires_venue_public_at",ey(e.ticketUrlPublicAt,e.venuePublicAt)),(0,_.Pe)("game_events_date_idx").on(e.date),(0,_.Pe)("game_events_venue_id_idx").on(e.venueId),(0,_.Pe)("game_events_public_at_idx").on(e.publicAt)]);(0,d.K1)(eb,e=>{let{one:t,many:n}=e;return{venue:t(eh,{fields:[eb.venueId],references:[eh.id]}),games:n(ew)}});let ew=(0,r.cJ)("games",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),sportradarId:(0,i.Qq)("sportradar_id").unique(),scorebreakId:(0,p.nd)("scorebreak_id").unique(),seasonYear:(0,i.Qq)("season_year").notNull().references(()=>tr.year),gameEventId:(0,i.Qq)("game_event_id").notNull().references(()=>eb.id),bracketNodeId:(0,i.Qq)("bracket_node_id").references(()=>L.id),awayTeamId:(0,i.Qq)("away_team_id").references(()=>tI.id),homeTeamId:(0,i.Qq)("home_team_id").references(()=>tI.id),awayStartingLineupId:(0,i.Qq)("away_starting_lineup_id").references(()=>tH.id),homeStartingLineupId:(0,i.Qq)("home_starting_lineup_id").references(()=>tH.id),awayPlayerId:(0,i.Qq)("away_player_id").references(()=>e6.id),homePlayerId:(0,i.Qq)("home_player_id").references(()=>e6.id),awayParticipantId:(0,i.Qq)("away_participant_id").references(()=>eZ.id),homeParticipantId:(0,i.Qq)("home_participant_id").references(()=>eZ.id),type:(0,i.Qq)("type",{enum:eg}).notNull(),tv:(0,i.Qq)("tv",{enum:ev}).notNull(),status:(0,i.Qq)("status",{enum:["Scheduled","Live","Final","Canceled"]}).default("Scheduled").notNull(),round:(0,i.Qq)("round",{enum:["First Round","Second Round","Quarterfinals","Semifinals","Finals","Championship"]}),seriesGameNumber:(0,p.nd)("series_game_number"),notice:(0,i.Qq)("notice"),startAt:(0,s.vE)("start_at").unique().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.bracketNodeId,e.seriesGameNumber),(0,q.z6)("away_team_home_team_different",(0,em.ne)(e.awayTeamId,e.homeTeamId)),(0,q.z6)("away_player_home_player_different",(0,em.ne)(e.awayPlayerId,e.homePlayerId)),(0,q.z6)("games_bracket_node_requires_series_game_number",(0,v.ll)(eI(),e.bracketNodeId,e.seriesGameNumber)),(0,q.z6)("games_series_game_number_gte_1",(0,v.ll)(eq(),e.seriesGameNumber)),(0,_.Pe)("games_away_team_id_idx").on(e.awayTeamId),(0,_.Pe)("games_home_team_id_idx").on(e.homeTeamId),(0,_.Pe)("games_away_player_id_idx").on(e.awayPlayerId),(0,_.Pe)("games_home_player_id_idx").on(e.homePlayerId),(0,_.Pe)("games_season_year_idx").on(e.seasonYear),(0,_.Pe)("games_game_event_id_idx").on(e.gameEventId),(0,_.Pe)("games_type_idx").on(e.type),(0,_.Pe)("games_status_idx").on(e.status),(0,_.Pe)("games_start_at_idx").on(e.startAt),(0,q.z6)("away_participant_home_participant_different",(0,em.ne)(e.awayParticipantId,e.homeParticipantId)),(0,_.Pe)("games_away_participant_id_idx").on(e.awayParticipantId),(0,_.Pe)("games_home_participant_id_idx").on(e.homeParticipantId)]);(0,d.K1)(ew,e=>{let{one:t,many:n}=e;return{season:t(tr,{fields:[ew.seasonYear],references:[tr.year]}),gameEvent:t(eb,{fields:[ew.gameEventId],references:[eb.id]}),articles:n(c),youtubeVideos:n(tj),bracketNode:t(L,{fields:[ew.bracketNodeId],references:[L.id]}),gamePredictions:n(eQ),challengeGames:n(O),challengeQuestions:n(M),userNotificationSubscriptions:n(eH),deviceNotificationSubscriptions:n(eW),awayTeam:t(tI,{fields:[ew.awayTeamId],references:[tI.id],relationName:"away_team"}),homeTeam:t(tI,{fields:[ew.homeTeamId],references:[tI.id],relationName:"home_team"}),awayStartingLineup:t(tH,{fields:[ew.awayStartingLineupId],references:[tH.id],relationName:"away_starting_lineup"}),homeStartingLineup:t(tH,{fields:[ew.homeStartingLineupId],references:[tH.id],relationName:"home_starting_lineup"}),awayPlayer:t(e6,{fields:[ew.awayPlayerId],references:[e6.id],relationName:"away_player_1on1"}),homePlayer:t(e6,{fields:[ew.homePlayerId],references:[e6.id],relationName:"home_player_1on1"}),teamStatsNew:n(tV),playerStatsNew:n(tY),playByPlaysNew:n(tG),statEvents:n(tC),awayParticipant:t(eZ,{fields:[ew.awayParticipantId],references:[eZ.id],relationName:"away_participant"}),homeParticipant:t(eZ,{fields:[ew.homeParticipantId],references:[eZ.id],relationName:"home_participant"}),teamStats:n(tl),playerStats:n(to),oneOnOneStats:n(ts),playByPlayEvents:n(ti)}});let ex=["avif","webp","png","jpg","jpeg"],eA=["16x9","original"],eP=(0,r.cJ)("images",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),folderId:(0,i.Qq)("folder_id").references(()=>eo.id),originalFormat:(0,i.Qq)("original_format",{enum:ex}).notNull(),originalPath:(0,i.Qq)("original_path").unique().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("images_folder_id_idx").on(e.folderId),(0,_.Pe)("images_created_at_idx").on(e.createdAt)]);(0,d.K1)(eP,e=>{let{one:t,many:n}=e;return{folder:t(eo,{fields:[eP.folderId],references:[eo.id]}
1),variants:n(eL),imagesToArticles:n(eE),challengesByLogo:n(J,{relationName:"logo"}),challengesByBanner:n(J,{relationName:"banner"})}});let eL=(0,r.cJ)("image_variants",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),imageId:(0,i.Qq)("image_id").notNull().references(()=>eP.id,{onDelete:"cascade"}),width:(0,i.Qq)("width",{enum:["432","720","1440","1920"]}).notNull(),height:(0,i.Qq)("height").notNull(),ratio:(0,i.Qq)("ratio",{enum:eA}).notNull(),format:(0,i.Qq)("format",{enum:["jpg"]}).notNull(),path:(0,i.Qq)("path").unique().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("image_variants_image_id_idx").on(e.imageId),(0,_.Pe)("image_variants_width_idx").on(e.width),(0,_.Pe)("image_variants_ratio_idx").on(e.ratio),(0,_.Pe)("image_variants_format_idx").on(e.format),(0,_.Pe)("image_variants_created_at_idx").on(e.createdAt)]);(0,d.K1)(eL,e=>{let{one:t}=e;return{image:t(eP,{fields:[eL.imageId],references:[eP.id]})}});let eE=(0,r.cJ)("images_to_articles",{articleId:(0,i.Qq)("article_id").notNull().references(()=>c.id,{onDelete:"cascade"}),imageId:(0,i.Qq)("image_id").notNull().references(()=>eP.id)},e=>({pk:(0,f.ie)({columns:[e.articleId,e.imageId]}),articleIdIdx:(0,_.Pe)("images_to_articles_article_id_idx").on(e.articleId),imageIdIdx:(0,_.Pe)("images_to_articles_image_id_idx").on(e.imageId)}));(0,d.K1)(eE,e=>{let{one:t}=e;return{article:t(c,{fields:[eE.articleId],references:[c.id]}),image:t(eP,{fields:[eE.imageId],references:[eP.id]})}});let ek=(0,r.cJ)("jobs",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),status:(0,i.Qq)("status",{enum:["open","closed","hired"]}).default("open").notNull(),title:(0,i.Qq)("title").notNull(),departments:(0,i.Qq)("departments").array().$type(),workStyle:(0,i.Qq)("work_style",{enum:["Remote","Hybrid","On Site"]}),baseLocation:(0,i.Qq)("base_location",{enum:["North America","United States","Miami","New York City"]}),type:(0,i.Qq)("type",{enum:["Full-Time","Part-Time","Seasonal"]}),seasonalMonths:(0,o.Fx)("seasonal_months").$type(),content:(0,o.Fx)("content").$type(),publicAt:(0,s.vE)("public_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("jobs_status_idx").on(e.status),(0,_.Pe)("jobs_public_at_idx").on(e.publicAt),(0,_.Pe)("jobs_created_at_idx").on(e.createdAt)]);(0,d.K1)(ek,e=>{let{many:t}=e;return{applicants:t(e$)}});let e$=(0,r.cJ)("job_applicants",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),jobId:(0,i.Qq)("job_id").notNull().references(()=>ek.id,{onDelete:"cascade"}),rating:(0,i.Qq)("rating",{enum:["good_fit","maybe","not_a_fit"]}),firstName:(0,i.Qq)("first_name").notNull(),lastName:(0,i.Qq)("last_name").notNull(),email:(0,i.Qq)("email").notNull(),linkedinUrl:(0,i.Qq)("linkedin_url"),portfolioUrl:(0,i.Qq)("portfolio_url"),coverLetter:(0,i.Qq)("cover_letter"),resume:(0,i.Qq)("resume").notNull(),extra2:(0,i.Qq)("extra2"),extra3:(0,i.Qq)("extra3"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("job_applicants_job_id_idx").on(e.jobId),(0,_.Pe)("job_applicants_rating_idx").on(e.rating),(0,_.Pe)("job_applicants_first_name_idx").on(e.firstName),(0,_.Pe)("job_applicants_last_name_idx").on(e.lastName),(0,_.Pe)("job_applicants_email_idx").on(e.email),(0,_.Pe)("job_applicants_created_at_idx").on(e.createdAt)]);(0,d.K1)(e$,e=>{let{one:t}=e;return{job:t(ek,{fields:[e$.jobId],references:[ek.id]})}});let eS=(0,r.cJ)("locations",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),country:(0,i.Qq)("country").notNull(),region:(0,i.Qq)("region"),city:(0,i.Qq)("city"),timezone:(0,i.Qq)("timezone"),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)("locations_unique").on(e.country,e.region,e.city,e.timezone),(0,_.Pe)("locations_city_idx").on(e.city),(0,_.Pe)("locations_timezone_idx").on(e.timezone),(0,_.Pe)("locations_created_at_idx").on(e.createdAt)]);function eK(){let e=(0,y._)(["lower(",")"]);return eK=function(){return e},e}function eU(){let e=(0,y._)([""," IS NULL"]);return eU=function(){return e},e}function eD(){let e=(0,y._)([""," IS NULL"]);return eD=function(){return e},e}function eF(){let e=(0,y._)([""," ~ ",""]);return eF=function(){return e},e}function eT(){let e=(0,y._)([""," > 0"]);return eT=function(){return e},e}function eJ(){let e=(0,y._)(["num_nonnulls(",", ",", ",") <= 1"]);return eJ=function(){return e},e}function ez(){let e=(0,y._)(["num_nonnulls(",", ",", ",") = 0"]);return ez=function(){return e},e}function eO(){let e=(0,y._)([""," IS NOT NULL"]);return eO=function(){return e},e}function eM(){let e=(0,y._)([""," IS NOT NULL"]);return eM=function(){return e},e}function eB(){let e=(0,y._)([""," IS NOT NULL"]);return eB=function(){return e},e}function eR(){let e=(0,y._)(["num_nonnulls(",", ",", ",") <= 1"]);return eR=function(){return e},e}function ej(){let e=(0,y._)(["num_nonnulls(",", ",", ",") = 0"]);return ej=function(){return e},e}function eC(){let e=(0,y._)([""," IS NOT NULL"]);return eC=function(){return e},e}function eG(){let e=(0,y._)([""," IS NOT NULL"]);return eG=function(){return e},e}function eV(){let e=(0,y._)([""," IS NOT NULL"]);return eV=function(){return e},e}(0,d.K1)(eS,e=>{let{many:t}=e;return{devices:t(Y),shopifyOrders:t(tF)}}),(0,r.cJ)("newsletter_posts",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),beehiivId:(0,i.Qq)("beehiiv_id").unique().notNull(),data:(0,o.Fx)("data").$type().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>({createdAtIdx:(0,_.Pe)("newsletter_posts_created_at_idx").on(e.createdAt)}));let eY=(0,r.cJ)("notification_topics",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),key:(0,i.Qq)("key").unique().notNull(),name:(0,i.Qq)("name").notNull(),description:(0,i.Qq)("description"),format:(0,i.Qq)("format",{enum:["push","live_activity"]}).notNull(),targetScope:(0,i.Qq)("target_scope",{enum:["league","game_or_team","team","player"]}).notNull(),order:(0,p.nd)("order").notNull(),archivedAt:(0,s.vE)("archived_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.GL)("notification_topics_name_lower_uq").on((0,v.ll)(eK(),e.name)).where((0,v.ll)(eU(),e.archivedAt)),(0,_.GL)("notification_topics_order_uq").on(e.order).where((0,v.ll)(eD(),e.archivedAt)),(0,q.z6)("notification_topics_key_charset_chk",(0,v.ll)(eF(),e.key,W.O$).inlineParams()),(0,q.z6)("notification_topics_order_positive_chk",(0,v.ll)(eT(),e.order))]);(0,d.K1)(eY,e=>{let{many:t}=e;return{userNotificationSubscriptions:t(eH),deviceNotificationSubscriptions:t(eW)}});let eH=(0,r.cJ)("user_notification_subscriptions",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.g9)()),userId:(0,i.Qq)("user_id").references(()=>tA.id).notNull(),notificationTopicId:(0,i.Qq)("notification_topic_id").notNull(),gameId:(0,i.Qq)("game_id").references(()=>ew.id),teamId:(0,i.Qq)("team_id").references(()=>tI.id),playerId:(0,i.Qq)("player_id").references(()=>e6.id),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,I.mt)({name:"user_notification_subscriptions_notification_topic_id_fk",columns:[e.notificationTopicId],foreignColumns:[eY.id]}),(0,q.z6)("user_notification_subscriptions_single_target_chk",(0,v.ll)(eJ(),e.gameId,e.teamId,e.playerId)),(0,_.GL)("user_notification_subscriptions_league_uq").on(e.notificationTopicId,e.userId).where((0,v.ll)(ez(),e.gameId,e.teamId,e.playerId)),(0,_.GL)("user_notification_subscriptions_game_uq").on(e.notificationTopicId,e.gameId,e.userId).where((0,v.ll)(eO(),e.gameId)),(0,_.GL)("user_notification_subscriptions_team_uq").on(e.notificationTopicId,e.teamId,e.userId).where((0,v.ll)(eM(),e.teamId)),(0,_.GL)("user_notification_subscriptions_player_uq").on(e.notificationTopicId,e.playerId,e.userId).where((0,v.ll)(eB(),e.playerId)),(0,_.Pe)("user_notification_subscriptions_user_id_idx").on(e.userId)]);(0,d.K1)(eH,e=>{let{one:t}=e;return{user:t(tA,{fields:[eH.userId],references:[tA.id]}),notificationTopic:t(eY,{fields:[eH.notificationTopicId],references:[eY.id]}),game:t(ew,{fields:[eH.gameId],references:[ew.id]}),team:t(tI,{fields:[eH.teamId],references:[tI.id]}),player:t(e6,{fields:[eH.playerId],references:[e6.id]})}});let eW=(0,r.cJ)("device_notification_subscriptions",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.g9)()),deviceId:(0,i.Qq)("device_id").references(()=>V.id).notNull(),notificationTopicId:(0,i.Qq)("notification_topic_id").notNull(),gameId:(0,i.Qq)("game_id").references(()=>ew.id),teamId:(0,i.Qq)("team_id").references(()=>tI.id),playerId:(0,i.Qq)("player_id").references(()=>e6.id),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,I.mt)({name:"device_notification_subscriptions_notification_topic_id_fk",columns:[e.notificationTopicId],foreignColumns:[eY.id]}),(0,q.z6)("device_notification_subscriptions_single_target_chk",(0,v.ll)(eR(),e.gameId,e.teamId,e.playerId)),(0,_.GL)("device_notification_subscriptions_league_uq").on(e.notificationTopicId,e.deviceId).where((0,v.ll)(ej(),e.gameId,e.teamId,e.playerId)),(0,_.GL)("device_notification_subscriptions_game_uq").on(e.notificationTopicId,e.gameId,e.deviceId).where((0,v.ll)(eC(),e.gameId)),(0,_.GL)("device_notification_subscriptions_team_uq").on(e.notificationTopicId,e.teamId,e.deviceId).where((0,v.ll)(eG(),e.teamId)),(0,_.GL)("device_notification_subscriptions_player_uq").on(e.notificationTopicId,e.playerId,e.deviceId).where((0,v.ll)(eV(),e.playerId)),(0,_.Pe)("device_notification_subscriptions_device_id_idx").on(e.deviceId)]);(0,d.K1)(eW,e=>{let{one:t}=e;return{device:t(V,{fields:[eW.deviceId],references:[V.id]}),notificationTopic:t(eY,{fields:[eW.notificationTopicId],references:[eY.id]}),game:t(ew,{fields:[eW.gameId],references:[ew.id]}),team:t(tI,{fields:[eW.teamId],references:[tI.id]}),player:t(e6,{fields:[eW.playerId],references:[e6.id]})}});let eX=["A","B","C","D"],eZ=(0,r.cJ)("one_vs_one_participants",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),seasonYear:(0,i.Qq)("season_year").notNull().references(()=>tr.year),playerId:(0,i.Qq)("player_id").notNull().references(()=>e6.id),scorebreakTeamId:(0,p.nd)("scorebreak_team_id").unique(),pod:(0,i.Qq)("pod",{enum:eX}).notNull(),seed:(0,p.nd)("seed"),status:(0,i.Qq)("status",{enum:["Not Participating","Eliminated","Winner"]}),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.seasonYear,e.playerId),(0,_.Pe)("one_vs_one_participants_season_year_idx").on(e.seasonYear),(0,_.Pe)("one_vs_one_participants_player_id_idx").on(e.playerId),(0,_.Pe)("one_vs_one_participants_pod_idx").on(e.pod
1),(0,_.Pe)("one_vs_one_participants_status_idx").on(e.status),(0,_.Pe)("one_vs_one_participants_created_at_idx").on(e.createdAt)]);(0,d.K1)(eZ,e=>{let{one:t,many:n}=e;return{season:t(tr,{fields:[eZ.seasonYear],references:[tr.year]}),player:t(e6,{fields:[eZ.playerId],references:[e6.id]}),awayGames:n(ew,{relationName:"away_participant"}),homeGames:n(ew,{relationName:"home_participant"})}});let e0=(0,r.cJ)("one_vs_one_votes",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),participantId:(0,i.Qq)("participant_id").notNull().references(()=>eZ.id),email:(0,i.Qq)("email").notNull(),voter:(0,i.Qq)("voter",{enum:["user","media","player","coach"]}).default("user").notNull(),rank:(0,p.nd)("rank").notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.participantId,e.email),(0,_.Pe)("one_vs_one_votes_participant_id_idx").on(e.participantId),(0,_.Pe)("one_vs_one_votes_rank_idx").on(e.rank),(0,_.Pe)("one_vs_one_votes_created_at_idx").on(e.createdAt)]);(0,d.K1)(e0,e=>{let{one:t}=e;return{participant:t(eZ,{fields:[e0.participantId],references:[eZ.id]})}});var e1=n(47714);let e2=["Instagram","TikTok","Threads","X","Youtube"],e6=(0,r.cJ)("players",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),sportradarId:(0,i.Qq)("sportradar_id").unique(),sportradarId1on1:(0,i.Qq)("sportradar_id_1on1").unique(),firstName:(0,i.Qq)("first_name").notNull(),lastName:(0,i.Qq)("last_name").notNull(),headshot:(0,i.Qq)("headshot").unique(),height:(0,i.Qq)("height"),dateOfBirth:(0,e1.p6)("date_of_birth"),position:(0,i.Qq)("position"),school:(0,i.Qq)("school"),country:(0,i.Qq)("country"),mediaBio:(0,o.Fx)("media_bio").$type(),publicBio:(0,o.Fx)("public_bio").$type(),pronunciationGuide:(0,i.Qq)("pronunciation_guide"),featureImg:(0,i.Qq)("feature_img").unique(),achievements:(0,o.Fx)("achievements"),socialLinks:(0,o.Fx)("social_links").$type(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("players_sportradar_id_idx").on(e.sportradarId),(0,_.Pe)("players_first_name_idx").on(e.firstName),(0,_.Pe)("players_last_name_idx").on(e.lastName),(0,_.Pe)("players_created_at_idx").on(e.createdAt)]);(0,d.K1)(e6,e=>{let{many:t}=e;return{playerSeasons:t(e7),rosterHistory:t(e4),oneVsOneParticipations:t(eZ),gamePredictions:t(eQ),byeBracketNodes:t(L),optionValues:t(B),followers:t(tk),userNotificationSubscriptions:t(eH),deviceNotificationSubscriptions:t(eW),stats:t(to),oneOnOneStats:t(ts),playByPlayEvents:t(ti),playersToLineups:t(tW),playerStatsNew:t(tY),statEvents:t(tC),playByPlaysNew1on1:t(tG,{relationName:"player_1on1"}),possessionPlayByPlaysNew1on1:t(tG,{relationName:"possession_player_1on1"}),awayGames1on1:t(ew,{relationName:"away_player_1on1"}),homeGames1on1:t(ew,{relationName:"home_player_1on1"})}});let e3=["primary","pool"],e7=(0,r.cJ)("player_seasons",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),seasonYear:(0,i.Qq)("season_year").notNull().references(()=>tr.year),playerId:(0,i.Qq)("player_id").notNull().references(()=>e6.id),role:(0,i.Qq)("role",{enum:e3}).notNull(),publicAt:(0,s.vE)("public_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.seasonYear,e.playerId),(0,_.Pe)("player_seasons_player_id_idx").on(e.playerId)]);(0,d.K1)(e7,e=>{let{one:t,many:n}=e;return{season:t(tr,{fields:[e7.seasonYear],references:[tr.year]}),player:t(e6,{fields:[e7.playerId],references:[e6.id]}),rosterHistory:n(e4)}});let e4=(0,r.cJ)("roster_history",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),seasonYear:(0,i.Qq)("season_year").notNull().references(()=>tr.year),teamId:(0,i.Qq)("team_id").notNull().references(()=>tI.id),playerId:(0,i.Qq)("player_id").notNull().references(()=>e6.id),scorebreakId:(0,p.nd)("scorebreak_id"),jerseyNumber:(0,i.Qq)("jersey_number"),headshot:(0,i.Qq)("headshot").unique(),isRelief:(0,l.zM)("is_relief").default(!0).notNull(),startAt:(0,s.vE)("start_at").defaultNow().notNull(),endAt:(0,s.vE)("end_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("roster_history_season_year_idx").on(e.seasonYear),(0,_.Pe)("roster_history_team_id_idx").on(e.teamId),(0,_.Pe)("roster_history_player_id_idx").on(e.playerId),(0,_.Pe)("roster_history_start_at_idx").on(e.startAt),(0,_.Pe)("roster_history_end_at_idx").on(e.endAt),(0,_.Pe)("roster_history_created_at_idx").on(e.createdAt)]);function e9(){let e=(0,y._)(["("," IS NULL) OR ("," > 0)"]);return e9=function(){return e},e}function e5(){let e=(0,y._)(["(("," IS NULL) = ("," IS NULL))"]);return e5=function(){return e},e}function e8(){let e=(0,y._)(["("," IS NULL) OR (("," IS NULL) AND ("," IS NULL) AND ("," IS NULL))"]);return e8=function(){return e},e}(0,d.K1)(e4,e=>{let{one:t}=e;return{season:t(tr,{fields:[e4.seasonYear],references:[tr.year]}),team:t(tI,{fields:[e4.teamId],references:[tI.id]}),player:t(e6,{fields:[e4.playerId],references:[e6.id]}),playerSeason:t(e7,{fields:[e4.seasonYear,e4.playerId],references:[e7.seasonYear,e7.playerId]})}});let te=(0,r.cJ)("playoff_statuses",{seasonYear:(0,i.Qq)("season_year").references(()=>tr.year).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id).notNull(),finalSeed:(0,p.nd)("final_seed"),finalSeedAt:(0,s.vE)("final_seed_at"),clinchedSpotAt:(0,s.vE)("clinched_spot_at"),eliminatedAt:(0,s.vE)("eliminated_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,f.ie)({columns:[e.seasonYear,e.teamId]}),(0,u.Am)().on(e.seasonYear,e.finalSeed),(0,q.z6)("playoff_statuses_final_seed_positive_chk",(0,v.ll)(e9(),e.finalSeed,e.finalSeed)),(0,q.z6)("playoff_statuses_final_seed_pair_chk",(0,v.ll)(e5(),e.finalSeed,e.finalSeedAt)),(0,q.z6)("playoff_statuses_final_seed_after_clinch_chk",ey(e.finalSeedAt,e.clinchedSpotAt)),(0,q.z6)("playoff_statuses_eliminated_state_chk",(0,v.ll)(e8(),e.eliminatedAt,e.clinchedSpotAt,e.finalSeed,e.finalSeedAt))]);(0,d.K1)(te,e=>{let{one:t}=e;return{season:t(tr,{fields:[te.seasonYear],references:[tr.year]}),team:t(tI,{fields:[te.teamId],references:[tI.id]})}});let tt=["active","disabled","archived"],tn=["form","marketing","tickets","social","service","rsvp","contest","other"],ta=(0,r.cJ)("qr_codes",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.gj)()),status:(0,i.Qq)("status",{enum:tt}).default("active").notNull(),category:(0,i.Qq)("category",{enum:tn}).notNull(),name:(0,i.Qq)("name"),description:(0,i.Qq)("description"),campaign:(0,i.Qq)("campaign"),defaultImg:(0,i.Qq)("default_img"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull(),createdBy:(0,i.Qq)("created_by").references(()=>tA.id).notNull()},e=>[(0,_.Pe)("qr_codes_status_idx").on(e.status),(0,_.Pe)("qr_codes_category_idx").on(e.category),(0,_.Pe)("qr_codes_created_at_idx").on(e.createdAt)]);(0,d.K1)(ta,e=>{let{one:t,many:n}=e;return{versions:n(td),createdByUser:t(tA,{fields:[ta.createdBy],references:[tA.id]})}});let td=(0,r.cJ)("qr_code_versions",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),qrCodeId:(0,i.Qq)("qr_code_id").references(()=>
1ta.id,{onDelete:"cascade"}).notNull(),redirectUrl:(0,i.Qq)("redirect_url").notNull(),label:(0,i.Qq)("label").notNull(),metadata:(0,o.Fx)("metadata").$type(),activateAt:(0,s.vE)("activate_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull(),createdBy:(0,i.Qq)("created_by").references(()=>tA.id).notNull()},e=>[(0,_.Pe)("qr_code_versions_qr_code_id_activate_at_idx").on(e.qrCodeId,e.activateAt.desc()),(0,_.Pe)("qr_code_versions_created_at_idx").on(e.createdAt)]);(0,d.K1)(td,e=>{let{one:t}=e;return{qrCode:t(ta,{fields:[td.qrCodeId],references:[ta.id]}),createdByUser:t(tA,{fields:[td.createdBy],references:[tA.id]})}});let tr=(0,r.cJ)("seasons",{year:(0,i.Qq)("year").primaryKey().notNull(),scorebreakId:(0,p.nd)("scorebreak_id")});(0,d.K1)(tr,e=>{let{many:t}=e;return{games:t(ew),playerSeasons:t(e7),rosters:t(e4),oneVsOneParticipants:t(eZ),brackets:t(P),challenges:t(J),playoffStatuses:t(te)}});let ti=(0,r.cJ)("play_by_play_events",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),scorebreakId:(0,p.nd)("scorebreak_id").unique().notNull(),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id),playerId:(0,i.Qq)("player_id").references(()=>e6.id),points:(0,p.nd)("points").default(0).notNull(),actionType:(0,i.Qq)("action_type").notNull(),subType:(0,i.Qq)("sub_type"),result:(0,i.Qq)("result"),clockTime:(0,i.Qq)("clock_time"),duration:(0,p.nd)("duration"),period:(0,p.nd)("period").default(0).notNull(),systemTime:(0,s.vE)("system_time").notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()});(0,d.K1)(ti,e=>{let{one:t}=e;return{game:t(ew,{fields:[ti.gameId],references:[ew.id]}),team:t(tI,{fields:[ti.teamId],references:[tI.id]}),player:t(e6,{fields:[ti.playerId],references:[e6.id]})}});let tl=(0,r.cJ)("team_stats",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id).notNull(),fg2Attempts:(0,p.nd)("fg2_attempts").notNull(),fg2Made:(0,p.nd)("fg2_made").notNull(),fg3Attempts:(0,p.nd)("fg3_attempts").notNull(),fg3Made:(0,p.nd)("fg3_made").notNull(),ftAttempts:(0,p.nd)("ft_attempts").notNull(),ftMade:(0,p.nd)("ft_made").notNull(),rebounds:(0,p.nd)("rebounds").notNull(),defRebounds:(0,p.nd)("def_rebounds").notNull(),offRebounds:(0,p.nd)("off_rebounds").notNull(),assists:(0,p.nd)("assists").notNull(),steals:(0,p.nd)("steals").notNull(),blocks:(0,p.nd)("blocks").notNull(),turnovers:(0,p.nd)("turnovers").notNull(),fouls:(0,p.nd)("fouls").notNull(),points:(0,p.nd)("points").notNull(),seconds:(0,p.nd)("seconds").notNull(),win:(0,l.zM)("win"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>({gameTeamUnique:(0,u.Am)().on(e.gameId,e.teamId)}));(0,d.K1)(tl,e=>{let{one:t}=e;return{game:t(ew,{fields:[tl.gameId],references:[ew.id]}),team:t(tI,{fields:[tl.teamId],references:[tI.id]})}});let to=(0,r.cJ)("player_stats",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),playerId:(0,i.Qq)("player_id").references(()=>e6.id).notNull(),fg2Attempts:(0,p.nd)("fg2_attempts").notNull(),fg2Made:(0,p.nd)("fg2_made").notNull(),fg3Attempts:(0,p.nd)("fg3_attempts").notNull(),fg3Made:(0,p.nd)("fg3_made").notNull(),ftAttempts:(0,p.nd)("ft_attempts").notNull(),ftMade:(0,p.nd)("ft_made").notNull(),rebounds:(0,p.nd)("rebounds").notNull(),defRebounds:(0,p.nd)("def_rebounds").notNull(),offRebounds:(0,p.nd)("off_rebounds").notNull(),assists:(0,p.nd)("assists").notNull(),steals:(0,p.nd)("steals").notNull(),blocks:(0,p.nd)("blocks").notNull(),turnovers:(0,p.nd)("turnovers").notNull(),fouls:(0,p.nd)("fouls").notNull(),points:(0,p.nd)("points").notNull(),seconds:(0,p.nd)("seconds").notNull(),minutes:(0,p.nd)("minutes"),isStarter:(0,l.zM)("is_starter").default(!1).notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>({gamePlayerUnique:(0,u.Am)().on(e.gameId,e.playerId)}));(0,d.K1)(to,e=>{let{one:t}=e;return{game:t(ew,{fields:[to.gameId],references:[ew.id]}),player:t(e6,{fields:[to.playerId],references:[e6.id]})}});let ts=(0,r.cJ)("one_on_one_stats",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),playerId:(0,i.Qq)("player_id").references(()=>e6.id).notNull(),fg2Attempts:(0,p.nd)("fg2_attempts").notNull(),fg2Made:(0,p.nd)("fg2_made").notNull(),fg3Attempts:(0,p.nd)("fg3_attempts").notNull(),fg3Made:(0,p.nd)("fg3_made").notNull(),ftAttempts:(0,p.nd)("ft_attempts").notNull(),ftMade:(0,p.nd)("ft_made").notNull(),rebounds:(0,p.nd)("rebounds").notNull(),defRebounds:(0,p.nd)("def_rebounds").notNull(),offReboun
1ds:(0,p.nd)("off_rebounds").notNull(),assists:(0,p.nd)("assists").notNull(),steals:(0,p.nd)("steals").notNull(),blocks:(0,p.nd)("blocks").notNull(),turnovers:(0,p.nd)("turnovers").notNull(),fouls:(0,p.nd)("fouls").notNull(),awardedPoints:(0,p.nd)("awarded_points").notNull(),points:(0,p.nd)("points").notNull(),seconds:(0,p.nd)("seconds").notNull(),minutes:(0,p.nd)("minutes"),win:(0,l.zM)("win"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)("one_on_one_stats_game_player_unique").on(e.gameId,e.playerId)]);(0,d.K1)(ts,e=>{let{one:t}=e;return{game:t(ew,{fields:[ts.gameId],references:[ew.id]}),player:t(e6,{fields:[ts.playerId],references:[e6.id]})}});var tu=n(6171);function t_(){let e=(0,y._)(["coalesce(tag_id, player_id, team_id)"]);return t_=function(){return e},e}function tc(){let e=(0,y._)(["coalesce(article_id, video_id, image_id)"]);return tc=function(){return e},e}function tp(){let e=(0,y._)(["\n ("," = 'tag' AND "," IS NOT NULL AND "," IS NULL AND "," IS NULL) OR\n ("," = 'player' AND "," IS NOT NULL AND "," IS NULL AND "," IS NULL) OR\n ("," = 'team' AND "," IS NOT NULL AND "," IS NULL AND "," IS NULL)"]);return tp=function(){return e},e}function tf(){let e=(0,y._)(["\n ("," = 'article' AND "," IS NOT NULL AND "," IS NULL AND "," IS NULL) OR\n ("," = 'video' AND "," IS NOT NULL AND "," IS NULL AND "," IS NULL) OR\n ("," = 'image' AND "," IS NOT NULL AND "," IS NULL AND "," IS NULL)"]);return tf=function(){return e},e}let tm=(0,r.cJ)("tags",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),name:(0,tu.yf)("name",{length:50}).unique().notNull(),slug:(0,i.Qq)("slug").unique().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()});(0,d.K1)(tm,e=>{let{many:t}=e;return{taggables:t(tN)}});let tN=(0,r.cJ)("taggables",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),tagId:(0,i.Qq)("tag_id").references(()=>tm.id,{onDelete:"cascade"}),playerId:(0,i.Qq)("player_id").references(()=>e6.id,{onDelete:"cascade"}),teamId:(0,i.Qq)("team_id").references(()=>tI.id,{onDelete:"cascade"}),sourceType:(0,i.Qq)("source_type",{enum:["tag","player","team"]}).notNull(),sourceId:(0,i.Qq)("source_id").generatedAlwaysAs((0,v.ll)(t_())),articleId:(0,i.Qq)("article_id").references(()=>c.id,{onDelete:"cascade"}),videoId:(0,i.Qq)("video_id").references(()=>tS.id,{onDelete:"cascade"}),imageId:(0,i.Qq)("image_id").references(()=>eP.id,{onDelete:"cascade"}),contentType:(0,i.Qq)("content_type",{enum:["article","video","image"]}).notNull(),contentId:(0,i.Qq)("content_id").generatedAlwaysAs((0,v.ll)(tc())),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,q.z6)("taggables_source_chk",(0,v.ll)(tp(),e.sourceType,e.tagId,e.playerId,e.teamId,e.sourceType,e.playerId,e.tagId,e.teamId,e.sourceType,e.teamId,e.tagId,e.playerId)),(0,q.z6)("taggables_content_chk",(0,v.ll)(tf(),e.contentType,e.articleId,e.videoId,e.imageId,e.contentType,e.videoId,e.articleId,e.imageId,e.contentType,e.imageId,e.articleId,e.videoId)),(0,_.GL)("taggables_source_content_uq").on(e.sourceType,e.sourceId,e.contentType,e.contentId),(0,_.Pe)("taggables_source_idx").on(e.sourceType,e.sourceId),(0,_.Pe)("taggables_content_idx").on(e.contentType,e.contentId),(0,_.Pe)("taggables_source_content_type_idx").on(e.sourceType,e.contentType)]);(0,d.K1)(tN,e=>{let{one:t}=e;return{tag:t(tm,{fields:[tN.tagId],references:[tm.id]}),player:t(e6,{fields:[tN.playerId],references:[e6.id]}),team:t(tI,{fields:[tN.teamId],references:[tI.id]}),article:t(c,{fields:[tN.articleId],references:[c.id]}),video:t(tS,{fields:[tN.videoId],references:[tS.id]}),image:t(eP,{fields:[tN.imageId],references:[eP.id]})}});let ty=["Head Coach","Assistant Coach"],tI=(0,r.cJ)("teams",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),sportradarId:(0,i.Qq)("sportradar_id").unique(),scorebreakId:(0,p.nd)("scorebreak_id"),name:(0,i.Qq)("name").unique().notNull(),slug:(0,i.Qq)("slug").unique().notNull(),logo:(0,i.Qq)("logo").unique(),wordmark:(0,i.Qq)("wordmark").unique(),hero:(0,o.Fx)("hero").$type(),isPublic:(0,l.zM)("is_public").default(!1).notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("teams_sportradar_id_idx").on(e.sportradarId),(0,_.Pe)("teams_name_idx").on(e.name),(0,_.Pe)("teams_slug_idx").on(e.slug),(0,_.Pe)("teams_created_at_idx").on(e.createdAt)]);(0,d.K1)(tI,e=>{let{many:t}=e;return{awayGames:t(ew,{relationName:"away_team"}),homeGames:t(ew,{relationName:"home_team"}),rosterHistory:t(e4),staff:t(tq),gamePredictions:t(eQ),byeBracketNodes:t(L),playoffStatuses:t(te),optionValues:t(B),followers:t(tE),userNotificationSubscriptions:t(eH),deviceNotificationSubscriptions:t(eW),stats:t(tl),playByPlayEvents:t(ti),teamStatsNew:t(tV),playerStatsNew:t(tY),playByPlaysNew:t(tG,{relationName:"team"}),possessionPlayByPlaysNew:t(tG,{relationName:"possession_team"}),statEvents:t(tC),lineups:t(tH)}});let tq=(0,r.cJ)("team_staff",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),teamId:(0,i.Qq)("team_id").notNull().references(()=>tI.id),userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"set null"}),firstName:(0,i.Qq)("first_name").notNull(),lastName:(0,i.Qq)("last_name").notNull(),title:(0,i.Qq)("title").notNull(),department:(0,i.Qq)("department",{enum:["Coaching","Basketball Operations"]}).default("Coaching").notNull(),text:(0,i.Qq)("text"),headshot:(0,i.Qq)("headsh
1ot").unique(),order:(0,p.nd)("order").default(0).notNull(),startAt:(0,s.vE)("start_at").defaultNow().notNull(),endAt:(0,s.vE)("end_at"),createdAt:(0,s.vE)("created_at").defaultNow().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date)},e=>[(0,_.Pe)("team_staff_team_id_idx").on(e.teamId),(0,_.Pe)("team_staff_user_id_idx").on(e.userId),(0,_.Pe)("team_staff_title_idx").on(e.title),(0,_.Pe)("team_staff_department_idx").on(e.department),(0,_.Pe)("team_staff_start_at_idx").on(e.startAt),(0,_.Pe)("team_staff_end_at_idx").on(e.endAt)]);(0,d.K1)(tq,e=>{let{one:t}=e;return{team:t(tI,{fields:[tq.teamId],references:[tI.id]}),user:t(tA,{fields:[tq.userId],references:[tA.id]})}});let tv=["Business","Careers","Events","Feedback","Media","Merchandise","Teams & Players","Tickets","Watching Games","Website","Other"],tg=(0,r.cJ)("threads",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),type:(0,i.Qq)("type",{enum:["general","media",""]}).default("").notNull(),subject:(0,i.Qq)("subject",{enum:tv}).default("Other").notNull(),category:(0,i.Qq)("category"),senderEmail:(0,i.Qq)("sender_email").notNull(),senderMessage:(0,i.Qq)("sender_message").notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>({emailMessageUnique:(0,u.Am)().on(e.senderEmail,e.senderMessage),typeIdx:(0,_.Pe)("threads_type_idx").on(e.type),subjectIdx:(0,_.Pe)("threads_subject_idx").on(e.subject),categoryIdx:(0,_.Pe)("threads_category_idx").on(e.category),senderEmailIdx:(0,_.Pe)("threads_sender_email_idx").on(e.senderEmail),createdAtIdx:(0,_.Pe)("threads_created_at_idx").on(e.createdAt)}));(0,d.K1)(tg,e=>{let{many:t}=e;return{assignments:t(tL),messages:t(tQ)}});let tQ=(0,r.cJ)("thread_messages",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),threadId:(0,i.Qq)("thread_id").notNull().references(()=>tg.id,{onDelete:"cascade"}),userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"set null"}),messageId:(0,i.Qq)("message_id").notNull(),direction:(0,i.Qq)("direction",{enum:["inbound","outbound","forward","fwd_inbound","fwd_outbound"]}).notNull(),to:(0,i.Qq)("to"),from:(0,i.Qq)("from").notNull(),subject:(0,i.Qq)("subject").notNull(),message:(0,i.Qq)("message").notNull(),rawMessage:(0,i.Qq)("raw_message"),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>({threadIdIdx:(0,_.Pe)("thread_messages_thread_id_idx").on(e.threadId),userIdIdx:(0,_.Pe)("thread_messages_user_id_idx").on(e.userId),directionIdx:(0,_.Pe)("thread_messages_direction_idx").on(e.direction),fromIdx:(0,_.Pe)("thread_messages_from_idx").on(e.from),toIdx:(0,_.Pe)("thread_messages_to_idx").on(e.to),createdAtIdx:(0,_.Pe)("thread_messages_created_at_idx").on(e.createdAt)}));function th(){let e=(0,y._)(["lower(",")"]);return th=function(){return e},e}function tb(){let e=(0,y._)(["("," IS NULL) OR (char_length(",") BETWEEN 3 AND 20)"]);return tb=function(){return e},e}function tw(){let e=(0,y._)(["("," IS NULL) OR ("," ~ ",")"]);return tw=function(){return e},e}function tx(){let e=(0,y._)(["("," IS NULL) OR ("," !~ '[._]{2}')"]);return tx=function(){return e},e}(0,d.K1)(tQ,e=>{let{one:t}=e;return{thread:t(tg,{fields:[tQ.threadId],references:[tg.id]}),user:t(tA,{fields:[tQ.userId],references:[tA.id]})}});let tA=(0,r.cJ)("users",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),firstName:(0,i.Qq)("first_name"),lastName:(0,i.Qq)("last_name"),email:(0,i.Qq)("email").unique().notNull(),phone:(0,i.Qq)("phone"),emailVerified:(0,s.vE)("emailVerified",{mode:"date"}),betterEmailVerified:(0,l.zM)("better_email_verified").default(!1).notNull(),role:(0,i.Qq)("role",{enum:W.iK}).default("user").notNull(),newsletter:(0,o.Fx)("newsletter").$type().default({id:null,status:"inactive"}).notNull(),globalEmailStatus:(0,i.Qq)("global_email_status",{enum:W.Ks}).default("subscribed").notNull(),image:(0,i.Qq)("image"),name:(0,i.Qq)("name"),handle:(0,i.Qq)("handle"),dateOfBirthMonth:(0,i.Qq)("date_of_birth_month"),dateOfBirthYear:(0,i.Qq)("date_of_birth_year"),acceptTermsDate:(0,s.vE)("accept_terms_date",{mode:"date"}),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.GL)("users_handle_lower_uq").on((0,v.ll)(th(),e.handle)),(0,q.z6)("users_handle_length_chk",(0,v.ll)(tb(),e.handle,e.handle)),(0,q.z6)("users_handle_charset_chk",(0,v.ll)(tw(),e.handle,e.handle,W.E3).inlineParams()),(0,q.z6)("users_handle_no_consecutive_punct_chk",(0,v.ll)(tx(),e.handle,e.handle)),(0,_.Pe)("users_id_handle_idx").on(e.id,e.handle),(0,_.Pe)("users_handle_idx").on(e.handle),(0,_.Pe)("users_email_idx").on(e.email),(0,_.Pe)("users_role_idx").on(e.role),(0,_.Pe)("users_global_email_status_idx").on(e.globalEmailStatus),(0,_.Pe)("users_created_at_idx").on(e.createdAt)]);(0,d.K1)(tA,e=>{let{many:t}=e;return{devices:t(H),visits:t(tU),events:t(el),formSubmissions:t(ep),assignments:t(tL,{relationName:"user"}),sentMessages:t(tQ),activities:t(tP),gamePredictions:t(eQ),votes:t(tD),challengeEntries:t(z),videoUploads:t(tS),teamFollows:t(tE),playerFollows:t(tk),emailSubscriptions:t(ed),notificationSubscriptions:t(eH),sessions:t(m),accounts:t(N)}});let tP=(0,r.cJ)("user_activities",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.g9)()),userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"set null"}),action:(0,i.Qq)("action",{enum:ei}).notNull(),path:(0,i.Qq)("path"),properties:(0,o.Fx)("properties").$type().notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("user_activities_user_id_idx").on(e.userId),(0,_.Pe)("user_activities_action_idx").on(e.action),(0,_.Pe)("user_activities_path_idx").on(e.path),(0,_.Pe)("user_activities_created_at_idx").on(e.createdAt)]);(0,d.K1)(tP,e=>{let{one:t}=e;return{user:t(tA,{fields:[tP.userId],references:[tA.id]})}});let tL=(0,r.cJ)("assignments",{userId:(0,i.Qq)("user_id").references(()=>
1tA.id,{onDelete:"cascade"}).notNull(),threadId:(0,i.Qq)("thread_id").references(()=>tg.id,{onDelete:"cascade"}).notNull(),assignedById:(0,i.Qq)("assigned_by_id"),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.userId,e.threadId),(0,_.Pe)("assignments_user_id_idx").on(e.userId),(0,_.Pe)("assignments_thread_id_idx").on(e.threadId)]);(0,d.K1)(tL,e=>{let{one:t}=e;return{user:t(tA,{fields:[tL.userId],references:[tA.id],relationName:"user"}),thread:t(tg,{fields:[tL.threadId],references:[tg.id]}),assignedBy:t(tA,{fields:[tL.assignedById],references:[tA.id]})}});let tE=(0,r.cJ)("user_team_follows",{userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"cascade"}).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id,{onDelete:"cascade"}).notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,f.ie)({columns:[e.userId,e.teamId]}),(0,_.Pe)("user_team_follows_user_id_idx").on(e.userId),(0,_.Pe)("user_team_follows_team_id_idx").on(e.teamId),(0,_.Pe)("user_team_follows_created_at_idx").on(e.createdAt)]);(0,d.K1)(tE,e=>{let{one:t}=e;return{user:t(tA,{fields:[tE.userId],references:[tA.id]}),team:t(tI,{fields:[tE.teamId],references:[tI.id]})}});let tk=(0,r.cJ)("user_player_follows",{userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"cascade"}).notNull(),playerId:(0,i.Qq)("player_id").references(()=>e6.id,{onDelete:"cascade"}).notNull(),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,f.ie)({columns:[e.userId,e.playerId]}),(0,_.Pe)("user_player_follows_user_id_idx").on(e.userId),(0,_.Pe)("user_player_follows_player_id_idx").on(e.playerId),(0,_.Pe)("user_player_follows_created_at_idx").on(e.createdAt)]);(0,d.K1)(tk,e=>{let{one:t}=e;return{user:t(tA,{fields:[tk.userId],references:[tA.id]}),player:t(e6,{fields:[tk.playerId],references:[e6.id]})}});let t$=JSON.parse('[{"type": "paragraph", "children": [{"text": ""}]}]'),tS=(0,r.cJ)("videos",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),folderId:(0,i.Qq)("folder_id").references(()=>eo.id),thumbnailId:(0,i.Qq)("thumbnail_id").unique().references(()=>eP.id),courseId:(0,i.Qq)("course_id").references(()=>tK.id),type:(0,i.Qq)("type",{enum:["Academy","Challenge"]}).default("Academy").notNull(),subtype:(0,i.Qq)("subtype",{enum:["Lesson","Feature","User Submission"]}).default("Lesson").notNull(),title:(0,i.Qq)("title").default("Untitled").notNull(),description:(0,o.Fx)("description").$type().default(t$).notNull(),mux:(0,o.Fx)("mux").$type().notNull(),duration:(0,p.nd)("duration"),order:(0,p.nd)("order"),uploadedByUserId:(0,i.Qq)("uploaded_by_user_id").references(()=>tA.id).notNull(),publicAt:(0,s.vE)("public_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("videos_folder_id_idx").on(e.folderId),(0,_.Pe)("videos_thumbnail_id_idx").on(e.thumbnailId),(0,_.Pe)("videos_course_id_idx").on(e.courseId),(0,_.Pe)("videos_type_idx").on(e.type),(0,_.Pe)("videos_subtype_idx").on(e.subtype),(0,_.Pe)("videos_title_idx").on(e.title),(0,_.Pe)("videos_uploaded_by_user_id_idx").on(e.uploadedByUserId),(0,_.Pe)("videos_public_at_idx").on(e.publicAt),(0,_.Pe)("videos_created_at_idx").on(e.createdAt)]);(0,d.K1)(tS,e=>{let{one:t,many:n}=e;return{folder:t(eo,{fields:[tS.folderId],references:[eo.id]}),thumbnail:t(eP,{fields:[tS.thumbnailId],references:[eP.id]}),course:t(tK,{fields:[tS.courseId],references:[tK.id]}),challengeEntries:n(z),uploadedBy:t(tA,{fields:[tS.uploadedByUserId],references:[tA.id]})}});let tK=(0,r.cJ)("courses",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),thumbnailUrl:(0,i.Qq)("thumbnail_url"),type:(0,i.Qq)("type"),subtype:(0,i.Qq)("subtype"),title:(0,i.Qq)("title").default("Untitled").notNull(),description:(0,o.Fx)("description").$type().default(t$).notNull(),by:(0,i.Qq)("by").default("").notNull(),duration:(0,p.nd)("duration"),extra:(0,i.Qq)("extra"),publicAt:(0,s.vE)("public_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>
1[(0,_.Pe)("courses_title_idx").on(e.title),(0,_.Pe)("courses_public_at_idx").on(e.publicAt),(0,_.Pe)("courses_created_at_idx").on(e.createdAt)]);(0,d.K1)(tK,e=>{let{many:t,one:n}=e;return{videos:t(tS)}});let tU=(0,r.cJ)("visits",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.g9)()),userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"set null"}),deviceId:(0,i.Qq)("device_id").references(()=>V.id).notNull(),referrer:(0,i.Qq)("referrer"),utm:(0,o.Fx)("utm").$type(),network:(0,o.Fx)("network").$type(),source:(0,i.Qq)("source").notNull().default("direct"),medium:(0,i.Qq)("medium").notNull().default("none"),campaign:(0,i.Qq)("campaign"),acquisition:(0,i.Qq)("acquisition",{enum:["paid","organic"]}),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,_.Pe)("visits_device_id_idx").on(e.deviceId),(0,_.Pe)("visits_user_id_idx").on(e.userId),(0,_.Pe)("visits_source_idx").on(e.source),(0,_.Pe)("visits_medium_idx").on(e.medium),(0,_.Pe)("visits_campaign_idx").on(e.campaign),(0,_.Pe)("visits_acquisition_idx").on(e.acquisition),(0,_.Pe)("visits_created_at_idx").on(e.createdAt)]);(0,d.K1)(tU,e=>{let{one:t,many:n}=e;return{user:t(tA,{fields:[tU.userId],references:[tA.id]}),device:t(V,{fields:[tU.deviceId],references:[V.id]}),events:n(el)}});let tD=(0,r.cJ)("votes",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),seasonYear:(0,i.Qq)("season_year").notNull().references(()=>tr.year),userId:(0,i.Qq)("user_id").references(()=>tA.id,{onDelete:"set null"}),email:(0,i.Qq)("email").notNull(),voter:(0,i.Qq)("voter",{enum:["Kiosk","User","Media","Player","Coach"]}).notNull(),type:(0,i.Qq)("type",{enum:["MVP","1-on-1 Pods","All-Unrivaled Teams","Defensive Player of the Year","Coach of the Year"]}).notNull(),isSubscribing:(0,l.zM)("is_subscribing"),votes:(0,o.Fx)("votes").$type().notNull(),history:(0,o.Fx)("history").$type().default([]).notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)("votes_season_email_type_unique").on(e.seasonYear,e.email,e.type),(0,_.Pe)("votes_season_year_idx").on(e.seasonYear),(0,_.Pe)("votes_user_id_idx").on(e.userId),(0,_.Pe)("votes_email_idx").on(e.email),(0,_.Pe)("votes_type_idx").on(e.type),(0,_.Pe)("votes_created_at_idx").on(e.createdAt)]);(0,d.K1)(tD,e=>{let{one:t}=e;return{user:t(tA,{fields:[tD.userId],references:[tA.id]})}});let tF=(0,r.cJ)("shopify_orders",{id:(0,i.Qq)("id").primaryKey(),userId:(0,i.Qq)("user_id").references(()=>tA.id),locationId:(0,i.Qq)("location_id").references(()=>eS.id),store:(0,i.Qq)("store").$type().notNull(),channelName:(0,i.Qq)("channel_name"),orderName:(0,i.Qq)("order_name").notNull(),financialStatus:(0,i.Qq)("financial_status"),fulfillmentStatus:(0,i.Qq)("fulfillment_status").notNull(),subtotalLineItemsQuantity:(0,p.nd)("subtotal_line_items_quantity").notNull(),currentSubtotalLineItemsQuantity:(0,p.nd)("current_subtotal_line_items_quantity").notNull(),totalPrice:(0,ef._)("total_price",{precision:10,scale:2}).notNull(),originalTotalPrice:(0,ef._)("original_total_price",{precision:10,scale:2}).notNull(),currentTotalPrice:(0,ef._)("current_total_price",{precision:10,scale:2}).notNull(),originalPriceBreakdown:(0,o.Fx)("original_price_breakdown").$type().notNull(),currentPriceBreakdown:(0,o.Fx)("current_price_breakdown").$type().notNull(),totalReceived:(0,ef._)("total_received",{precision:10,scale:2}).notNull(),totalOutstanding:(0,ef._)("total_outstanding",{precision:10,scale:2}).notNull(),totalCapturable:(0,ef._)("total_capturable",{precision:10,scale:2}).notNull(),totalRefunded:(0,ef._)("total_refunded",{precision:10,scale:2}).notNull(),totalRefundedShipping:(0,ef._)("total_refunded_shipping",{precision:10,scale:2}).notNull(),totalTipReceived:(0,ef._)("total_tip_received",{precision:10,scale:2}).notNull(),netPayment:(0,ef._)("net_payment",{precision:10,scale:2}).notNull(),currency:(0,i.Qq)("currency").notNull(),discountCodes:(0,i.Qq)("discount_codes").array().notNull(),email:(0,i.Qq)("email"),phone:(0,i.Qq)("phone"),customer:(0,o.Fx)("customer").$type(),customerAcceptsMarketing:(0,l.zM)("customer_accepts_marketing").notNull(),shippingAddress:(0,o.Fx)("shipping_address").$type(),billingAddress:(0,o.Fx)("billing_address").$type(),refundable:(0,l.zM)("refundable").notNull(),taxesIncluded:(0,l.zM)("taxes_included").notNull(),requiresShipping:(0,l.zM)("requires_shipping").notNull(),riskRecommendation:(0,i.Qq)("risk_recommendation").notNull(),tags:(0,i.Qq)("tags").array().notNull(),note:(0,i.Qq)("note"),cancelReason:(0,i.Qq)("cancel_reason"),raw:(0,o.Fx)("raw").notNull().$type(),cancelledAt:(0,s.vE)("cancelled_at"),closedAt:(0,s.vE)("closed_at"),processedAt:(0,s.vE)("processed_at").notNull(),updatedAt:(0,s.vE)("updated_at").notNull(),createdAt:(0,s.vE)("created_at").notNull(),lastSyncedAt:(0,s.vE)("last_synced_at").defaultNow().notNull().$onUpdate(()=>new Date)},e=>[(0,_.Pe)("shopify_orders_created_at_idx").on(e.createdAt),(0,_.Pe)("shopify_orders_order_name_idx").on(e.orderName),(0,_.Pe)("shopify_orders_store_idx").on(e.store)]);(0,d.K1)(tF,e=>{let{one:t,many:n}=e;return{user:t(tA,{fields:[tF.userId],references:[tA.id]}),location:t(eS,{fields:[tF.locationId],references:[eS.id]}),lineItems:n(tT)}});let tT=(0,r.cJ)("shopify_line_items",{id:(0,i.Qq)("id").primaryKey(),orderId:(0,i.Qq)("order_id").references(()=>
1tF.id,{onDelete:"cascade"}).notNull(),productId:(0,i.Qq)("product_id").references(()=>tJ.id),variantId:(0,i.Qq)("variant_id").references(()=>tz.id),store:(0,i.Qq)("store").$type().notNull(),sku:(0,i.Qq)("sku"),name:(0,i.Qq)("name").notNull(),originalTotalPrice:(0,ef._)("original_total_price",{precision:10,scale:2}).notNull(),originalUnitPrice:(0,ef._)("original_unit_price",{precision:10,scale:2}).notNull(),currentTotalPrice:(0,ef._)("current_total_price",{precision:10,scale:2}).notNull(),currentUnitPrice:(0,ef._)("current_unit_price",{precision:10,scale:2}).notNull(),totalDiscount:(0,ef._)("total_discount",{precision:10,scale:2}).notNull(),originalQuantity:(0,p.nd)("original_quantity").notNull(),currentQuantity:(0,p.nd)("current_quantity").notNull(),refundableQuantity:(0,p.nd)("refundable_quantity").notNull(),unfulfilledQuantity:(0,p.nd)("unfulfilled_quantity").notNull(),taxLines:(0,o.Fx)("tax_lines").notNull(),isGiftCard:(0,l.zM)("is_gift_card").notNull(),requiresShipping:(0,l.zM)("requires_shipping").notNull(),raw:(0,o.Fx)("raw").notNull().$type()},e=>[(0,_.Pe)("shopify_line_items_order_id_idx").on(e.orderId),(0,_.Pe)("shopify_line_items_store_idx").on(e.store)]);(0,d.K1)(tT,e=>{let{one:t}=e;return{order:t(tF,{fields:[tT.orderId],references:[tF.id]}),product:t(tJ,{fields:[tT.productId],references:[tJ.id]}),variant:t(tz,{fields:[tT.variantId],references:[tz.id]})}});let tJ=(0,r.cJ)("shopify_products",{id:(0,i.Qq)("id").primaryKey(),store:(0,i.Qq)("store").$type().notNull(),status:(0,i.Qq)("status").notNull(),category:(0,i.Qq)("category"),handle:(0,i.Qq)("handle").notNull(),title:(0,i.Qq)("title").notNull(),description:(0,i.Qq)("description").notNull(),totalInventory:(0,p.nd)("total_inventory").notNull(),hasOutOfStockVariants:(0,l.zM)("has_out_of_stock_variants").notNull(),tracksInventory:(0,l.zM)("tracks_inventory").notNull(),vendor:(0,i.Qq)("vendor").notNull(),minVariantPrice:(0,ef._)("min_variant_price",{precision:10,scale:2}).notNull(),maxVariantPrice:(0,ef._)("max_variant_price",{precision:10,scale:2}).notNull(),variantsCount:(0,p.nd)("variants_count").notNull(),options:(0,o.Fx)("options").notNull(),collections:(0,o.Fx)("collections").notNull(),tags:(0,i.Qq)("tags").array().notNull(),onlineStoreUrl:(0,i.Qq)("online_store_url"),featuredMedia:(0,o.Fx)("featured_media"),media:(0,o.Fx)("media").notNull(),raw:(0,o.Fx)("raw").notNull().$type(),publishedAt:(0,s.vE)("published_at"),updatedAt:(0,s.vE)("updated_at").notNull(),createdAt:(0,s.vE)("created_at").notNull(),lastSyncedAt:(0,s.vE)("last_synced_at").defaultNow().notNull().$onUpdate(()=>new Date)},e=>[(0,_.Pe)("shopify_products_store_idx").on(e.store)]);(0,d.K1)(tJ,e=>{let{many:t}=e;return{variants:t(tz),lineItems:t(tT)}});let tz=(0,r.cJ)("shopify_product_variants",{id:(0,i.Qq)("id").primaryKey(),productId:(0,i.Qq)("product_id").references(()=>tJ.id,{onDelete:"cascade"}).notNull(),store:(0,i.Qq)("store").$type().notNull(),availableForSale:(0,l.zM)("available_for_sale").notNull(),sku:(0,i.Qq)("sku"),displayName:(0,i.Qq)("display_name").notNull(),title:(0,i.Qq)("title").notNull(),price:(0,ef._)("price",{precision:10,scale:2}).notNull(),unitCost:(0,ef._)("unit_cost",{precision:10,scale:2}),inventoryQuantity:(0,p.nd)("inventory_quantity"),inventoryPolicy:(0,i.Qq)("inventory_policy").notNull(),taxable:(0,l.zM)("taxable").notNull(),image:(0,o.Fx)("image"),media:(0,o.Fx)("media").notNull(),raw:(0,o.Fx)("raw").notNull().$type(),updatedAt:(0,s.vE)("updated_at").notNull(),createdAt:(0,s.vE)("created_at").notNull()},e=>[(0,_.Pe)("shopify_product_variants_sku_idx").on(e.sku),(0,_.Pe)("shopify_product_variants_store_idx").on(e.store)]);function tO(){let e=(0,y._)([""," is null"]);return tO=function(){return e},e}(0,d.K1)(tz,e=>{let{one:t,many:n}=e;return{product:t(tJ,{fields:[tz.productId],references:[tJ.id]}),lineItems:n(tT)}});let tM=(0,r.cJ)("ticketmaster_orders",{id:(0,i.Qq)("id").primaryKey(),userId:(0,i.Qq)("user_id").references(()=>tA.id),version:(0,i.Qq)("version").notNull(),creationDateTime:(0,s.vE)("creation_date_time").notNull(),timezone:(0,i.Qq)("timezone").notNull(),updatedSince:(0,s.vE)("updated_since").notNull(),type:(0,i.Qq)("type"),operator:(0,i.Qq)("operator"),customer:(0,o.Fx)("customer"),salesChannel:(0,o.Fx)("sales_channel"),payments:(0,o.Fx)("payments"),totals:(0,o.Fx)("totals"),deliveries:(0,o.Fx)("deliveries"),raw:(0,o.Fx)("raw").notNull()},e=>[(0,_.Pe)("ticketmaster_orders_updated_since_idx").on(e.updatedSince),(0,_.Pe)("ticketmaster_orders_user_id_null_idx").on(e.userId).where((0,v.ll)(tO(),e.userId)
1)]),tB=(0,r.cJ)("ticketmaster_items",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),orderId:(0,i.Qq)("order_id").references(()=>tM.id).notNull(),eventId:(0,i.Qq)("event_id").notNull(),ticketHolder:(0,l.zM)("ticket_holder").notNull(),type:(0,i.Qq)("type"),status:(0,i.Qq)("status"),price:(0,o.Fx)("price"),location:(0,o.Fx)("location"),offers:(0,o.Fx)("offers"),raw:(0,o.Fx)("raw").notNull()}),tR=(0,r.cJ)("ticketmaster_events",{id:(0,i.Qq)("id").primaryKey(),name:(0,i.Qq)("name").notNull(),raw:(0,o.Fx)("raw").notNull()});(0,d.K1)(tM,e=>{let{one:t,many:n}=e;return{user:t(tA,{fields:[tM.userId],references:[tA.id]}),items:n(tB)}}),(0,d.K1)(tB,e=>{let{one:t}=e;return{order:t(tM),event:t(tR,{fields:[tB.eventId],references:[tR.id]})}}),(0,d.K1)(tR,e=>{let{many:t}=e;return{items:t(tB)}});let tj=(0,r.cJ)("youtube_videos",{id:(0,i.Qq)("id").primaryKey(),folderId:(0,i.Qq)("folder_id").references(()=>eo.id),gameId:(0,i.Qq)("game_id").references(()=>ew.id),gameTag:(0,i.Qq)("game_tag",{enum:["Full Game"]}),channelId:(0,i.Qq)("channel_id").notNull(),channelTitle:(0,i.Qq)("channel_title").notNull(),title:(0,i.Qq)("title").notNull(),description:(0,i.Qq)("description"),durationSeconds:(0,p.nd)("duration_seconds"),liveStatus:(0,i.Qq)("live_status",{enum:["none","live","upcoming"]}).notNull(),thumbnails:(0,o.Fx)("thumbnails").$type().notNull(),statistics:(0,o.Fx)("statistics").$type(),tags:(0,i.Qq)("tags").array().notNull(),blockedCountries:(0,i.Qq)("blocked_countries").array().notNull(),publishedAt:(0,s.vE)("published_at"),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull(),lastSyncedAt:(0,s.vE)("last_synced_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.gameId,e.gameTag),(0,_.Pe)("youtube_videos_channel_id_idx").on(e.channelId),(0,_.Pe)("youtube_videos_folder_id_idx").on(e.folderId),(0,_.Pe)("youtube_videos_title_idx").on(e.title),(0,_.Pe)("youtube_videos_live_status_idx").on(e.liveStatus),(0,_.Pe)("youtube_videos_published_at_idx").on(e.publishedAt),(0,_.Pe)("youtube_videos_created_at_idx").on(e.createdAt),(0,_.Pe)("youtube_videos_last_synced_at_idx").on(e.lastSyncedAt)]);(0,d.K1)(tj,e=>{let{one:t}=e;return{folder:t(eo,{fields:[tj.folderId],references:[eo.id]}),game:t(ew,{fields:[tj.gameId],references:[ew.id]})}});let tC=(0,r.cJ)("stat_events",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),playByPlayId:(0,i.Qq)("play_by_play_id").references(()=>tG.id,{onDelete:"cascade"}).notNull(),playerId:(0,i.Qq)("player_id").references(()=>e6.id),teamId:(0,i.Qq)("team_id").references(()=>tI.id),type:(0,i.Qq)("type",{enum:["fieldgoal","freethrow","assist","rebound","turnover","steal","block","attemptblocked","fouldrawn","offensivefoul","personalfoul","unknown"]}).notNull(),subtype:(0,i.Qq)("subtype",{enum:["jump shot","layup","offensive","defensive","offensive foul","bad pass","lost ball","weighted","unknown"]}),pointType:(0,i.Qq)("point_type",{enum:["one point","two point","three point"]}),made:(0,l.zM)("made"),points:(0,p.nd)("points").default(0).notNull(),shotDistance:(0,ef._)("shot_distance",{precision:6,scale:2}),updatedAt:(0,s.vE)("updated_at").notNull(),createdAt:(0,s.vE)("created_at").notNull()},e=>[(0,_.Pe)("stat_events_game_id_idx").on(e.gameId),(0,_.Pe)("stat_events_play_by_play_id_idx").on(e.playByPlayId),(0,_.Pe)("stat_events_player_id_idx").on(e.playerId),(0,_.Pe)("stat_events_team_id_idx").on(e.teamId)]);(0,d.K1)(tC,e=>{let{one:t}=e;return{game:t(ew,{fields:[tC.gameId],references:[ew.id]}),playByPlay:t(tG,{fields:[tC.playByPlayId],references:[tG.id]}),player:t(e6,{fields:[tC.playerId],references:[e6.id]}),team:t(tI,{fields:[tC.teamId],references:[tI.id]})}});let tG=(0,r.cJ)("play_by_plays_new",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),sportradarId:(0,i.Qq)("sportradar_id").unique().notNull(),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id),possessionTeamId:(0,i.Qq)("possession_team_id").references(()=>tI.id),awayLineupId:(0,i.Qq)("away_lineup_id").references(()=>tH.id),homeLineupId:(0,i.Qq)("home_lineup_id").references(()=>tH.id),playerId1on1:(0,i.Qq)("player_id_1on1").references(()=>e6.id),possessionPlayerId1on1:(0,i.Qq)("possession_player_id_1on1").references(()=>e6.id),period:(0,p.nd)("period").notNull(),clock:(0,i.Qq)("clock").notNull(),elapsedSeconds:(0,p.nd)("elapsed_seconds").notNull(),type:(0,i.Qq)("type",{enum:["lineupchangethree","opentip","openinbound","endperiod","twopointmade","twopointmiss","threepointmiss","threepointmade","freethrowmade","freethrowmiss","rebound","turnover","shootingfoul","personalfoul","technicalfoul","offensivefoul","clearpathfoul","ejection","flagrantone","jumpball","deadball","kickball","tvtimeout","teamtimeout","officialtimeout","delay","requestreview","challengetimeout","challengereview","unknown"]}).notNull(),description:(0,i.Qq)("description").notNull(),score:(0,o.Fx)("score").$type().notNull(),teamBasket:(0,i.Qq)("team_basket",{enum:["left","right"]}),locationX:(0,p.nd)("location_x"),locationY:(0,p.nd)("location_y"),locationArea:(0,i.Qq)("location_area"),raw:(0,o.Fx)("raw").notNull(),updatedAt:(0,s.vE)("updated_at").notNull(),createdAt:(0,s.vE)("created_at").notNull()},e=>[(0,_.Pe)("play_by_plays_game_id_idx").on(e.gameId),(0,_.Pe)("play_by_plays_team_id_idx").on(e.teamId),(0,_.Pe)("play_by_plays_created_at_idx").on(e.createdAt)]);(0,d.K1)(tG,e=>{let{one:t,many:n}=e;return{game:t(ew,{fields:[tG.gameId],references:[ew.id]}),statEvents:n(tC),team:t(tI,{fields:[tG.teamId],references:[tI.id],relationName:"team"}),possessionTeam:t(tI,{fields:[tG.possessionTeamId],references:[tI.id],relationName:"possession_team"}),awayLineup:t(tH,{fields:[tG.awayLineupId],references:[tH.id],relationName:"away_lineup"}),homeLineup:t(tH,{fields:[tG.homeLineupId],references:[tH.id],relationName:"home_lineup"}),player1on1:t(e6,{fields:[tG.playerId1on1],references:[e6.id],relationName:"player_1on1"}),possessionPlayer1on1:t(e6,{fields:[tG.possessionPlayerId1on1],references:[e6.id],relationName:"possession_player_1on1"})}});let tV=(0,r.cJ)("team_stats_new",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id).notNull(),win:(0,l.zM)("win"),points:(0,p.nd)("points").notNull(),secondsPlayed:(0,p.nd)("seconds_played").notNull(),twoPointersAttempted:(0,p.nd)("two_pointers_attempted").notNull(),twoPointersMade:(0,p.nd)("two_pointers_made").notNull(),threePointersAttempted:(0,p.nd)("three_pointers_attempted").notNull(),threePointersMade:(0,p.nd)("three_pointers_made").notNull(),freeThrowsAttempted:(0,p.nd)("free_throws_attempted").notNull(),freeThrowsMade:(0,p.nd)("free_throws_made").notNull(),freeThrowPoints:(0,p.nd)("free_throw_points").notNull(),rebounds:(0,p.nd)("rebounds").notNull(),reboundsDefensive:(0,p.nd)("rebounds_defensive").notNull(),reboundsOffensive:(0,p.nd)("rebounds_offensive").notNull(),assists:(0,p.nd)("assists").notNull(),turnovers:(0,p.nd)("turnovers").notNull(),steals:(0,p.nd)("steals").notNull(),blocks:(0,p.nd)("blocks").notNull(),blockedAttempts:(0,p.nd)("blocked_attempts").notNull(),foulsPersonal:(0,p.nd)("fouls_personal").notNull(),foulsOffensive:(0,p.nd)("fouls_offensive").notNull(),foulsTechnical:(0,p.nd)("fouls_technical").notNull(),foulsFlagrant:(0,p.nd)("fouls_flagrant").notNull(),foulsDrawn:(0,p.nd)("fouls_drawn").notNull(),pointsInPaint:(0,p.nd)("points_in_paint").notNull(),pointsInPaintAttempted:(0,p.nd)("points_in_paint_attempted").notNull(),pointsInPaintMade:(0,p.nd)("points_in_paint_made").notNull(),secondChancePoints:(0,p.nd)("second_chance_points").notNull(),fastBreakPoints:(0,p.nd)("fast_break_points").notNull(),plusMinus:(0,p.nd)("plus_minus").notNull(),largestLead:(0,p.nd)("largest_lead").notNull(),advancedStats:(0,o.Fx)("advanced_stats").$type().notNull(),periods:(0,o.Fx)("periods").$type().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.gameId,e.teamId),(0,_.Pe)("team_stats_new_team_id_idx").on(e.teamId)]);(0,d.K1)(tV,e=>{let{one:t}=e;return{game:t(ew,{fields:[tV.gameId],references:[ew.id]}),team:t(tI,{fields:[tV.teamId],references:[tI.id]})}});let tY=(0,r.cJ)("player_stats_new",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),gameId:(0,i.Qq)("game_id").references(()=>ew.id).notNull(),playerId:(0,i.Qq)("player_id").references(()=>e6.id).notNull(),teamId:(0,i.Qq)("team_id").references(()=>tI.id),win:(0,l.zM)("win"),points:(0,p.nd)("points").notNull(),secondsPlayed:(0,p.nd)("seconds_played").notNull(),twoPointersAttempted:(0,p.nd)("two_pointers_attempted").notNull(),twoPointersMade:(0,p.nd)("two_pointers_made").notNull(),threePointersAttempted:(0,p.nd)("three_pointers_attempted").notNull(),threePointersMade:(0,p.nd)("three_pointers_made").notNull(),freeThrowsAttempted:(0,p.nd)("free_throws_attempted").notNull(),freeThrowsMade:(0,p.nd)("free_throws_made").notNull(),freeThrowPoints:(0,p.nd)("free_throw_points").notNull(),rebounds:(0,p.nd)("rebounds").notNull(),reboundsDefensive:(0,p.nd)("rebounds_defensive").notNull(),reboundsOffensive:(0,p.nd)("rebounds_offensive").notNull(),assists:(0,p.nd)("assists").notNull(),turnovers:(0,p.nd)("turnovers").notNull(),steals:(0,p.nd)("steals").notNull(),blocks:(0,p.nd)("blocks").notNull(),blockedAttempts:(0,p.nd)("blocked_attempts").notNull(),foulsPersonal:(0,p.nd)("fouls_personal").notNull(),foulsOffensive:(0,p.nd)("fouls_offensive").notNull(),foulsTechnical:(0,p.nd)("fouls_technical").notNull(),foulsFlagrant:(0,p.nd)("fouls_flagrant").notNull(),foulsDrawn:(0,p.nd)("fouls_drawn").notNull(),pointsInPaint:(0,p.nd)("points_in_paint").notNull(),pointsInPaintAttempted:(0,p.nd)("points_in_paint_attempted").notNull(),pointsInPaintMade:(0,p.nd)("points_in_paint_made").notNull(),secondChancePoints:(0,p.nd)("second_chance_points").notNull(),awardedPoints:(0,p.nd)("awarded_points").notNull(),plusMinus:(0,p.nd)("plus_minus").notNull(),doubleDouble:(0,l.zM)("double_double").notNull(),tripleDouble:(0,l.zM)("triple_double").notNull(),winningBasket:(0,l.zM)("winning_basket").notNull(),advancedStats:(0,o.Fx)("advanced_stats").$type().notNull(),periods:(0,o.Fx)("periods").$type().notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.gameId,e.playerId),(0,_.Pe)("player_stats_new_player_id_idx").on(e.playerId),(0,_.Pe)("player_stats_new_team_id_idx").on(e.teamId)]);(0,d.K1)(tY,e=>{let{one:t}=e;return{game:t(ew,{fields:[tY.gameId],references:[ew.id]}),player:t(e6,{fields:[tY.playerId],references:[e6.id]}),team:t(tI,{fields:[tY.teamId],references:[tI.id]})}});let tH=(0,r.cJ)("lineups",{id:(0,i.Qq)("id").primaryKey().$defaultFn(()=>(0,a.Ld)()),teamId:(0,i.Qq)("team_id").references(()=>tI.id).notNull(),playerIdsFlat:(0,i.Qq)("player_ids_flat").notNull(),updatedAt:(0,s.vE)("updated_at").defaultNow().notNull().$onUpdate(()=>new Date),createdAt:(0,s.vE)("created_at").defaultNow().notNull()},e=>[(0,u.Am)().on(e.teamId,e.playerIdsFlat)]);(0,d.K1)(tH,e=>{let{one:t,many:n}=e;
1return{team:t(tI,{fields:[tH.teamId],references:[tI.id]}),playersToLineups:n(tW),awayPlayByPlays:n(tG,{relationName:"away_lineup"}),homePlayByPlays:n(tG,{relationName:"home_lineup"}),awayStartingGames:n(ew,{relationName:"away_starting_lineup"}),homeStartingGames:n(ew,{relationName:"home_starting_lineup"})}});let tW=(0,r.cJ)("players_to_lineups",{lineupId:(0,i.Qq)("lineup_id").references(()=>tH.id,{onDelete:"cascade"}).notNull(),playerId:(0,i.Qq)("player_id").references(()=>e6.id).notNull()},e=>[(0,f.ie)({columns:[e.lineupId,e.playerId]}),(0,_.Pe)("players_to_lineups_player_id_idx").on(e.playerId)]);(0,d.K1)(tW,e=>{let{one:t}=e;return{lineup:t(tH,{fields:[tW.lineupId],references:[tH.id]}),player:t(e6,{fields:[tW.playerId],references:[e6.id]})}})}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.