
    ju                     F    d dl Zd dlmZ d dlmZ dZdZdZdZ	ddZ
ddZdS )	    N)op)
postgresql001_expert_training_modelsreturnc                  r   t          j        d           t          j        dt          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j        t          j                              d          t          j        dt          j        t          j                              d          t          j        d	t          j                    d
          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j	                    d          t          j        dt          j                    d          t          j        dt          j
                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d
          t          j        dt          j                    d
          t          j        d          d           t          j        dddgd           t          j        dddgd
d           t          j        dt          j        dt          j                    d          t          j        dt          j                    d          t          j        d t          j        d!          d          t          j        d"t          j                    d          t          j        d#t          j	                    d
          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d
          t          j        dt          j                    d
          t          j        d          d           t          j        d$ddgd           t          j        d%t          j        dt          j                    d          t          j        d&t          j        d'          d          t          j        d(t          j                    d
          t          j        d)t          j                    d          t          j        d*t          j        d!          d          t          j        d+t          j        d!          d,          t          j        d-t          j        d!          d.          t          j        d/t          j                    d
          t          j        d0t          j                    d
          t          j        d1t          j                    d
          t          j        d2t          j                    d
          t          j        d3t          j                    d
          t          j        d4t          j                    d
          t          j        d#t          j	                    d
          t          j        d5t          j                    d
          t          j        d6t          j
                    d
          t          j        dt          j
                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d
          t          j        dt          j                    d
          t          j        d          d           t          j        d7d%d+gd           t          j        d8d%d0gd           t          j        d9t          j        dt          j                    d          t          j        d:t          j        d'          d          t          j        d(t          j                    d
          t          j        d;t          j        d!          d          t          j        d<t          j                    d=          t          j        d>t          j                    d
          t          j        d?t          j                    d          t          j        d@t          j                    d          t          j        dAt          j                    d          t          j        dBt          j                    d          t          j        d2t          j                    d
          t          j        dt          j
                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d
          t          j        dt          j                    d
          t          j        d          d           t          j        dCt          j        dt          j                    d          t          j        dDt          j                    d          t          j        d)t          j                    d          t          j        dEt          j        d'          d          t          j        dFt          j        d!          dG          t          j        dHt          j                    d
          t          j        dt          j
                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d          t          j        dt          j                    d
          t          j        dt          j                    d
          t          j        d          t          j        dDgdIg          d           d S )JNz&CREATE SCHEMA IF NOT EXISTS hub_globalexpert_profilesidF)nullableuser_idexpertise_areasskillsbioTtotal_annotations0)server_defaulttotal_reviewsavg_quality_scorez0.0reputation_score	meta_dataz{}
created_at
updated_at
is_deletedfalse
deleted_at
deleted_by
hub_globalschemaix_expert_profiles_idix_expert_profiles_user_id)uniquer   expert_contributionscontribution_type2   task_idquality_scoreix_expert_contributions_user_idannotation_taskstitle   descriptioncontent	task_typestatuspendingprioritymediumdeadlineassigned_toassigned_by
created_bycompleted_atreviewed_byreviewer_feedbackannotation_dataix_annotation_tasks_statusix_annotation_tasks_assigned_totraining_datasetsnamedataset_typeversion1parent_version_idtotal_samplestrain_samplesvalidation_samplestest_samplesdataset_samples
dataset_idlabelsplittrainsource_task_idzhub_global.training_datasets.id)r   executecreate_tablesaColumnIntegerr   ARRAYTextFloatJSONBDateTimeBooleanPrimaryKeyConstraintcreate_indexStringForeignKeyConstraint     e/lsinfo/ai/hellotax_ai/training_center/backend/alembic/versions/001_initial_expert_training_models.pyupgrader^   
   s   J7888O%ryrz||e'T'T'TVXV_`ikmkukwkw  CH  WI  WI  WI  KM  KT  Uf  hr  hx  y{  y@  yB  yB  hC  hC  NS  KT  KT  KT  VX  V_  `h  jt  jz  {}  {B  {D  {D  jE  jE  PU  VV  VV  VV  XZ  Xa  bg  ik  ip  ir  ir  }A  XB  XB  XB  DF  DM  Na  ce  cm  co  co  @C  DD  DD  DD  FH  FO  P_  ac  ak  am  am  ~A  FB  FB  FB  DF  DM  Na  ce  ck  cm  cm  ~C  DD  DD  DD  FH  FO  Pb  df  dn  dp  dp  A	D	  FE	  FE	  FE	  G	I	  G	P	  Q	\	  ^	h	  ^	n	  ^	p	  ^	p	  A
E
  G	F
  G	F
  G	F
  H
J
  H
Q
  R
^
  `
b
  `
k
  `
m
  `
m
  x
}
  H
~
  H
~
  H
~
  @B  @I  JV  XZ  Xc  Xe  Xe  pu  @v  @v  @v  xz  xA  BN  PR  PZ  P\  P\  mt  xu  xu  xu  wy  w@  AM  OQ  OZ  O\  O\  gk  wl  wl  wl  np  nw  xD  FH  FP  FR  FR  ]a  nb  nb  nb  df  d{  |@  dA  dA  JV  W  W  W  WO+->|\\\\O02Ci[Y]frssssO*BIdBJLLSX,Y,Y,Y[][denprpzp|p|  HM  \N  \N  \N  PR  PY  Zm  oq  ox  y{  o|  o|  GL  PM  PM  PM  OQ  OX  Yb  df  dn  dp  dp  {@  OA  OA  OA  CE  CL  M\  ^`  ^f  ^h  ^h  sw  Cx  Cx  Cx  z|  zC  DP  RT  R]  R_  R_  jo  zp  zp  zp  rt  r{  |H  JL  JU  JW  JW  bg  rh  rh  rh  jl  js  t@  BD  BL  BN  BN  _f  jg  jg  jg  ik  ir  s  AC  AL  AN  AN  Y]  i^  i^  i^  `b  `i  jv  xz  xB	  xD	  xD	  O	S	  `T	  `T	  `T	  V	X	  V	m	  n	r	  V	s	  V	s	  |	H
  I
  I
  I
  I
O57MPY{coppppO&	$
u(U(U(UWYW`ahjljstwjxjx  DI  XJ  XJ  XJ  LN  LU  Vc  eg  el  en  en  y}  L~  L~  L~  @B  @I  JS  UW  U\  U^  U^  in  @o  @o  @o  qs  qz  {F  HJ  HQ  RT  HU  HU  `e  qf  qf  qf  hj  hq  rz  |~  |E  FH  |I  |I  Zc  hd  hd  hd  fh  fo  pz  |~  |E  FH  |I  |I  Zb  fc  fc  fc  eg  en  oy  {}  {F  {H  {H  SW  eX  eX  eX  Z\  Zc  dq  su  s}  s  s  JN  ZO  ZO  ZO  QS  QZ  [h  jl  jt  jv  jv  A	E	  QF	  QF	  QF	  H	J	  H	Q	  R	^	  `	b	  `	j	  `	l	  `	l	  w	{	  H	|	  H	|	  H	|	  ~	@
  ~	G
  H
V
  X
Z
  X
c
  X
e
  X
e
  p
t
  ~	u
  ~	u
  ~	u
  w
y
  w
@  AN  PR  PZ  P\  P\  gk  w
l  w
l  w
l  np  nw  xG  IK  IQ  IS  IS  ^b  nc  nc  nc  eg  en  oB  DF  DK  DM  DM  X\  e]  e]  e]  _a  _h  iz  |F  |L  |N  |N  Y]  _^  _^  _^  `b  `i  ju  wA  wG  wI  wI  Z^  `_  `_  `_  ac  aj  kw  y{  yD  yF  yF  QV  aW  aW  aW  Y[  Yb  co  qs  q|  q~  q~  IN  YO  YO  YO  QS  QZ  [g  ik  is  iu  iu  FM  QN  QN  QN  PR  PY  Zf  hj  hs  hu  hu  @D  PE  PE  PE  GI  GP  Q]  _a  _i  _k  _k  vz  G{  G{  G{  }  }T  UY  }Z  }Z  co  p  p  p  pO02DxjYeffffO57IM?coppppO'4PU)V)V)VXZXabhjljstwjxjx  DI  YJ  YJ  YJ  LN  LU  Vc  eg  el  en  en  y}  L~  L~  L~  @B  @I  JX  Z\  Zc  df  Zg  Zg  rw  @x  @x  @x  z|  zC  DM  OQ  OY  O[  O[  lo  zp  zp  zp  rt  r{  |O  QS  Q[  Q]  Q]  hl  rm  rm  rm  oq  ox  yH  JL  JT  JV  JV  gj  ok  ok  ok  mo  mv  wF  HJ  HR  HT  HT  eh  mi  mi  mi  km  kt  uI  KM  KU  KW  KW  hk  kl  kl  kl  np  nw  xF	  H	J	  H	R	  H	T	  H	T	  e	h	  ni	  ni	  ni	  k	m	  k	t	  u	A
  C
E
  C
M
  C
O
  C
O
  Z
^
  k	_
  k	_
  k	_
  a
c
  a
j
  k
v
  x
B  x
H  x
J  x
J  [_  a
`  a
`  a
`  bd  bk  lx  z|  zE  zG  zG  RW  bX  bX  bX  Z\  Zc  dp  rt  r}  r  r  JO  ZP  ZP  ZP  RT  R[  \h  jl  jt  jv  jv  GN  RO  RO  RO  QS  QZ  [g  ik  it  iv  iv  AE  QF  QF  QF  HJ  HQ  R^  `b  `j  `l  `l  w{  H|  H|  H|  ~@  ~U  VZ  ~[  ~[  dp  q  q  q  qO%ryrz||e'T'T'TVXV_`lnpnxnznz  FK  WL  WL  WL  NP  NW  Xa  ce  cj  cl  cl  w|  N}  N}  N}  A  H  IP  RT  R[  \_  R`  R`  kp  q  q  q  su  s|  }D  FH  FO  PR  FS  FS  dk  sl  sl  sl  np  nw  xH  JL  JT  JV  JV  ae  nf  nf  nf  hj  hq  r}  I  O  Q  Q  bf  hg  hg  hg  ik  ir  s  AC  AL  AN  AN  Y^  i_  i_  i_  ac  aj  kw  y{  yD  yF  yF  QV  aW  aW  aW  Y[  Yb  co  qs  q{  q}  q}  N	U	  YV	  YV	  YV	  X	Z	  X	a	  b	n	  p	r	  p	{	  p	}	  p	}	  H
L
  X	M
  X	M
  X	M
  O
Q
  O
X
  Y
e
  g
i
  g
q
  g
s
  g
s
  ~
B  O
C  O
C  O
C  EG  E\  ]a  Eb  Eb  df  d{  }I  |J  Mn  Lo  dp  dp  yE  F  F  F  F  F  Fr\   c                      t          j        dd           t          j        dd           t          j        dd           t          j        dd           t          j        dd           d S )NrF   r   r   r<   r(   r"   r   )r   
drop_tabler[   r\   r]   	downgradera      sv    M#L9999M%l;;;;M$\::::M(>>>>M#L999999r\   )r   N)
sqlalchemyrN   alembicr   sqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onr^   ra   r[   r\   r]   <module>ri      s              * * * * * *'
F F F F: : : : : :r\   