
    j                         U d dl mZ d dlZd dlmZ d dlmZ dZe	e
d<   dZe	dz  e
d<   dZe	ee	         z  dz  e
d<   dZe	ee	         z  dz  e
d	<   ddZddZdS )    )SequenceN)op)
postgresql001revisiondown_revisionbranch_labels
depends_onreturnc                     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          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t          j                    t          j	        d          d
          t          j        dt          j                    t          j	        d          d
          t          j
        d          d           t          j        dddgd           t          j        dddgd           t          j        t          j        d          ddgd           t          j        t          j        d          ddgd
d           t          j        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%          d
          t          j        d&t          j        d#          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#          d
          t          j        d.t          j        t          j                    /          d
          t          j        d0t          j        d          d
          t          j        d1t          j        d2          d
          t          j        d3t          j                    d
          t          j        d4t          j                    d
          t          j        d5t          j                    d
          t          j        dt          j                    t          j	        d          d
          t          j        dt          j                    t          j	        d          d
          t          j
        d          d           t          j        d6d!d	gd           t          j        d7d!d1gd           t          j        d8d!d4gd           t          j        d9d!d)gd           t          j        d:d!d0gd           t          j        t          j        d;          d!dgd           t          j        t          j        d<          d!d"gd
d           t          j        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#          d
          t          j        d@t          j        d          d          t          j        dAt          j                    d          t          j        dBt          j                    d
          t          j        dt          j                    t          j	        d          d
          t          j
        d          d
  
         t          j        dCd>dgd           t          j        dDd>d@gd           t          j        dEd>dgd           t          j        t          j        dF          d>dgd           d S )GNz'CREATE SCHEMA IF NOT EXISTS data_centerdata_processing_tasksidF)nullabletask_id2   )lengthcategory_idTmode   statusprogresstotal_countsuccess_countfailed_counterror_message
started_atcompleted_at
created_atznow())server_defaultr   
updated_atdata_centerschemaidx_task_createdidx_task_statusix_data_processing_tasks_id ix_data_processing_tasks_task_id)uniquer#   $ix_data_processing_tasks_category_idtax_documents
source_urli  
doc_numberd   titleissuing_authority   
issue_dateeffective_datecontent_htmlcontent_markdown	file_pathattachments)astext_typeprocessing_statuscontent_hash@   last_check_timeis_importedknowledge_doc_ididx_doc_categoryidx_doc_hashidx_doc_importedidx_doc_issue_dateidx_doc_statusix_tax_documents_idix_tax_documents_source_urlix_tax_documents_doc_numberprocessing_logsdocument_url	log_levelmessage	exceptionidx_log_createdidx_log_levelidx_log_taskix_processing_logs_id)r   executecreate_tablesaColumnIntegerStringTextDateTimetextPrimaryKeyConstraintcreate_indexfDater   JSONBoolean     X/lsinfo/ai/hellotax_ai/data_center/backend/alembic/versions/001_create_initial_tables.pyupgradera      s   J8999O+RYtRZ\\TY-Z-Z-Z\^\efoqsqz  CE  rF  rF  rF  QV  ]W  ]W  ]W  Y[  Yb  cp  rt  r|  r~  r~  IM  YN  YN  YN  PR  PY  Z`  bd  bk  su  bv  bv  bv  AF  PG  PG  PG  IK  IR  S[  ]_  ]f  np  ]q  ]q  ]q  |A  IB  IB  IB  DF  DM  NX  Z\  Zd  Zf  Zf  qu  Dv  Dv  Dv  xz  xA  BO  QS  Q[  Q]  Q]  hl  xm  xm  xm  oq  ox  yH  JL  JT  JV  JV  ae  of  of  of  hj  hq  r@  BD  BL  BN  BN  Y]  h^  h^  h^  `b  `i  jy  {}  {B	  {D	  {D	  O	S	  `T	  `T	  `T	  V	X	  V	_	  `	l	  n	p	  n	y	  n	{	  n	{	  F
J
  V	K
  V	K
  V	K
  M
O
  M
V
  W
e
  g
i
  g
r
  g
t
  g
t
  
C  M
D  M
D  M
D  FH  FO  P\  ^`  ^i  ^k  ^k  |~  |C  DK  |L  |L  W[  F\  F\  F\  ^`  ^g  ht  vx  vA  vC  vC  TV  T[  \c  Td  Td  os  ^t  ^t  ^t  vx  vM  NR  vS  vS  \i  j  j  j  jO&(?,XeffffO%'>
S`aaaaOBD6779PSWRXanooooOBD;<<>UXaWbko  yF  G  G  G  GOBD?@@BY\i[j  tA  B  B  B  BOORYtRZ\\E%R%R%RTVT]^jlnlu  ~A  mB  mB  mB  MR  US  US  US  UW  U^  _l  np  nx  nz  nz  EJ  UK  UK  UK  MO  MV  Wc  eg  en  vy  ez  ez  ez  EI  MJ  MJ  MJ  LN  LU  V]  _a  _h  ps  _t  _t  _t  D  LE  LE  LE  GI  GP  Qd  fh  fo  wz  f{  f{  f{  FJ  GK  GK  GK  MO  MV  Wc  eg  el  en  en  y}  M~  M~  M~  @B  @I  JZ  \^  \c  \e  \e  pt  @u  @u  @u  wy  w@  AO  QS  QX  QZ  QZ  ei  wj  wj  wj  ln  lu  vH	  J	L	  J	Q	  J	S	  J	S	  ^	b	  lc	  lc	  lc	  e	g	  e	n	  o	z	  |	~	  |	E
  M
P
  |	Q
  |	Q
  |	Q
  \
`
  e	a
  e	a
  e	a
  c
e
  c
l
  m
z
  |
F  |
K  XZ  X_  Xa  Xa  |
b  |
b  |
b  mq  c
r  c
r  c
r  tv  t}  ~Q  SU  S\  df  Sg  Sg  Sg  rv  tw  tw  tw  y{  yB  CQ  SU  S\  df  Sg  Sg  Sg  rv  yw  yw  yw  y{  yB  CT  VX  Va  Vc  Vc  nr  ys  ys  ys  uw  u~  L  NP  NX  NZ  NZ  ei  uj  uj  uj  ln  lu  vH  JL  JT  JV  JV  ae  lf  lf  lf  hj  hq  r~  @B  @K  @M  @M  ^`  ^e  fm  ^n  ^n  y}  h~  h~  h~  @B  @I  JV  XZ  Xc  Xe  Xe  vx  v}  ~E  vF  vF  QU  @V  @V  @V  XZ  Xo  pt  Xu  Xu  ~K  L  L  L  LO&-Q^____ONOn5Em\\\\O&-Q^____O(/L>R_````O$o8K7LUbccccOBD.//4&Q^____OBD677<.aen{||||OBD677<.anooooO%ryrz||e'T'T'TVXV_`ikmkt|~kkk  KO  WP  WP  WP  RT  R[  \j  ln  lu  }@  lA  lA  lA  LP  RQ  RQ  RQ  SU  S\  ]h  jl  js  {}  j~  j~  j~  IN  SO  SO  SO  QS  QZ  [d  fh  fm  fo  fo  z  Q@  Q@  Q@  BD  BK  LW  Y[  Y`  Yb  Yb  mq  Br  Br  Br  tv  t}  ~J  LN  LW  LY  LY  jl  jq  ry  jz  jz  EI  tJ  tJ  tJ  LN  Lc  dh  Li  Li  r  @  @  @  @O%'8<.Q^____OO%6m\\\\ON$5	{=YYYYOBD0113DtfUbccccccr_   c                      t          j        dd           t          j        dd           t          j        dd           d S )NrF   r!   r"   r*   r   )r   
drop_tabler^   r_   r`   	downgraderd   #   sI    M#M::::M/-8888M)-@@@@@@r_   )r   N)collections.abcr   
sqlalchemyrQ   alembicr   sqlalchemy.dialectsr   r   str__annotations__r   r	   r
   ra   rd   r^   r_   r`   <module>rk      s    $ $ $ $ $ $ $           * * * * * *#    sTz      ,0sXc]"T) 0 0 0)-
C(3-$& - - -d d d d.A A A A A Ar_   