
    h;                         U d Z ddlmZmZ ddlZddlmZ ddlZddl	m
Z
 ddlmZ ddlmZ ddlmZ dd	lmZ dd
lmZ ddlmZ ddlmZ ddlmZ dZeed<   dZeeee   df   ed<   dZeeee   df   ed<   dZ eeee   df   ed<   ddZ!ddZ"y)z`Initial migration

Revision ID: 6ea9569ac8a9
Revises: 
Create Date: 2025-07-30 17:32:32.002414

    )SequenceUnionN)op)RoleType)	UserState)PaymentMethod)PaymentState)GeneralState)ChatFileType)CertificateState)RegistrationState)RegistrationTrackingState6ea9569ac8a9revisiondown_revisionbranch_labels
depends_onc                  fE   t        j                  dt        j                  dt        j                  dd      t        j                  dt        j
                        t        j                  dt        j                               t        j                  dt        j                               t        j                  dt        j                  t              t        j                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                                      t        j                  dt        j                  dt        j
                  ddt        j                        t        j                  dt        j
                        t        j                  dt        j
                        t        j                  dt        j
                  dd      t        j                  dt        j                        t        j                  dt        j
                        t        j                  dt        j                        t        j                  dt        j
                        t        j                  dt        j
                        t        j                  dt        j
                        t        j                  dt        j                  t              t        j                   	      t        j                  dt        j
                        t        j                  dt        j
                        t        j                  dt        j                  d	      t        j                  dt        j
                  d 	      t        j                  dt        j                  t              t        j                  	      t        j                  d!t        j                         d"      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  d#t        j                  t        j"                  d$                   t        j                  d%t        j                  dt        j                  dd      t        j                  d&t        j$                  d"      t        j                  d't        j                  t&              t&        j(                  "      t        j                  dt        j                  t*              t*        j,                  "      t        j                  d(t        j$                  d"      t        j                  d)t        j
                  dd*      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  d+t        j
                  t        j"                  d,            
       t        j                  d-t        j                  dt        j                  dd      t        j                  dt        j
                  d"      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d.t        j                  d	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  d+t        j
                  t        j"                  d,                   t        j                  d/t        j                  dt        j                  dd      t        j                  d0t        j
                  t        j"                  d,            t        j                  d1t        j
                  t        j"                  d,      d"      t        j                  d2t        j
                  d"      t        j                  d3t        j
                  d"      t        j                  d4t        j                  t2              dt2        j4                        t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  d#t        j                  t        j"                  d$                   t        j                  d5t        j                  dt        j                  dd      t        j                  d6t        j
                  d"      t        j                  d7t        j
                  d"      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                                      t        j                  d8t        j                  dt        j                  dd      t        j                  dt        j
                  d"      t        j                  d2t        j
                  d"      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                                      t        j                  d9t        j                  dt        j                  dd      t        j                  d)t        j
                  d"      t        j                  dt        j                  t6              t6        j8                  	      t        j                  d:t        j                  dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                                      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                  dAt        j$                  d"      t        j                  dBt        j
                  ddC      t        j                  dt        j                  t.              t.        j0                  	      t        j                  dDt        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dEt        j                  t        j"                  dF                   t        j                  dGt        j                  dt        j                  dd      t        j                  dt        j
                  d"      t        j                  d>t        j
                  d"      t        j                  dBt        j
                  ddH      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                                      t        j                  dIt        j                  dt        j                  dd      t        j                  dJt        j                  d"      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dKt        j                  t        j"                  dL            t        j                  dMt        j                  t        j"                  dN                   t        j                  dOt        j                  dt        j                  dd      t        j                  dt        j
                  d"      t        j                  dPt        j                  d"      t        j                  dBt        j
                  ddQ      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dKt        j                  t        j"                  dL            	       t        j                  dRt        j                  dt        j                  dd      t        j                  d2t        j
                  d"      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dSt        j                  t        j"                  dT                   t        j                  dUt        j                  dt        j                  dd      t        j                  d2t        j
                  d"      t        j                  dVt        j                  d	      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dWt        j                  t        j"                  dX                   t        j                  dYt        j                  dt        j                  dd      t        j                  dt        j
                  d"      t        j                  d2t        j
                  d"      t        j                  dZt        j
                  d"      t        j                  dJt        j                  d"      t        j                  d[t        j                  d"      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dSt        j                  t        j"                  dT                   t        j                  d\t        j                  dt        j                  dd      t        j                  d]t        j                  dd^      t        j                  d_t        j                  t:              t:        j<                  	      t        j                  dt        j                  t>              t>        j@                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  d`t        j                  t        j"                  da            t        j                  d+t        j
                  t        j"                  d,            t        j                  d#t        j                  t        j"                  d$            t        j                  dbt        j                  t        j"                  dc            t        j                  ddt        j                  t        j"                  de            t        j                  dMt        j                  t        j"                  dN            t        j                  dSt        j                  t        j"                  dT            t        j                  dKt        j                  t        j"                  dL                   t        j                  dft        j                  dt        j                  dd      t        j                  dt        j
                  d"      t        j                  d>t        j
                  d"      t        j                  dgt        j$                  d"      t        j                  dt        j                  t.              t.        j0                  	      t        j                  dt        j                         d"      t        j                  dt        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dSt        j                  t        j"                  dT            t        j                  dht        j                  t        j"                  di                   t        j                  djt        j                  dt        j                  dd      t        j                  dt        j                  t.              t.        j0                  	      t        j                  d
t        j                         dt        j                  j                               t        j                  dt        j                         dt        j                  j                         t        j                  j                               t        j                  dkt        j                  t        j"                  dl            t        j                  dWt        j                  t        j"                  dX                   y )mNwavesidT)primary_keyindextitle
start_dateend_datestate)default
created_atF)nullabler   
updated_at)r   r   onupdateusers)r   r   r   	firstnamelastnameemail)uniquer   email_verifyphonephone_verifyotpcountry_codepasswordroleaddressdevice_tokenis_newavatarzfiles/default.pngotp_expiration)r   wave_idzwaves.idpaymentsamountmethodpayment_value	reference)r&   r   user_idzusers.idnotificationsis_readchats	sender_idreceiver_idcontent	file_path	file_typereviewsnotecomment
categoriescertificates
issue_dateprogramsnamedurationdescriptionprerequisitespriceprice_discountimagezfiles/programs/default.pngpublication_datecategory_idzcategories.idcourseszfiles/courses/default.pngcourses_programsorder	course_idz
courses.id
program_idzprograms.idmodules	quizCountzfiles/modules/default.png	questions	module_idz
modules.idanswers
is_correctquestion_idzquestions.idlessonsresourcexp_countregistrationstracking_xp_countr   tracking_state	lesson_idz
lessons.id	review_idz
reviews.idcertificate_idzcertificates.idquizzesscoreregistration_idzregistrations.idquizzes_questionsquiz_idz
quizzes.id)!r   create_tablesaColumnIntegerStringDateTimeEnumr   INACTIVEfunccurrent_timestampuuiduuid4Booleanr   STUDENT
ForeignKeyFloatr   CASHr	   PENDINGr
   ACTIVEr   TEXTr   	AVAILABLEr   IN_PROGRESSr   WAITING     v/Users/theessential/Documents/Github/KofAcademy/kof-academy-backend/alembic/versions/6ea9569ac8a9_initial_migration.pyupgrader       sG   __WIIdBJJDMIIgryy1IIlR[[];IIj2;;=9IIgrwwy'99CUCUVIIlBKKMESUSZSZSlSlSnoIIlBKKMESUSZSZSlSlSny{  zA  zA  zS  zS  zU  V	 __
		$		t4T
		+ryy)
		*bii(
		'299T>
		."**-
		'299%
		."**-
		%#
		.")),
		*bii(
		&"''(+X5E5EF
		)RYY'
		.")),
		(BJJ5
		(BII/BC
		'2779-y7I7IJ
		"BKKMDA
		,rwwG`G`Gbc
		,rwwG`G`Gbmomtmt  nG  nG  nI  	J
		)RZZz)BC+0 __

))D"**$d
C
))Hbhh
7
))Hbggm4}?Q?Q
R
))GRWW\2\=Q=Q
R
))ORXX
>
))K4%
H
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))Iryy"--
*C
D __

))D"**$d
C
))GRYY
7
))GRWW\2L<O<O
P
))Irzz5
9
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))Iryy"--
*C
D	 __

))D"**$d
C
))KBMM*,E
F
))M299bmmJ.GRV
W
))Iryy5
9
))KT
:
))K!6P\PaPa
b
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))Irzz2==+D
E __

))D"**$d
C
))FBII
6
))Iryy4
8
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L __

))D"**$d
C
))GRYY
7
))Iryy4
8
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L __

))D"**$d
C
))KU
;
))GRWW%56@P@Z@Z
[
))L"++rwwG`G`Gb
c
))L"++-%IbIbIdoqovov  pI  pI  pK  L __

))D"**$d
C
))FBII
6
))J

T
:
))M299t
<
))ORYY
>
))GRXX
6
))$bhh
>
))GRYY?[
\
))GRWW\2L<O<O
P
))&rwwOhOhOj
k
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))M2::r}}_/M
N" __

))D"**$d
C
))GRYY
7
))M299t
<
))GRYY?Z
[
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L	 __

))D"**$d
C
))GRZZ%
8
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))KR]]<-H
I
))L"**bmmM.J
K	 __

))D"**$d
C
))GRYY
7
))Kd
;
))GRYY?Z
[
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))KR]]<-H
I

 __

))D"**$d
C
))Iryy5
9
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))KR]]<-H
I
 __

))D"**$d
C
))Iryy5
9
))L"**e
<
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))M2::r}}^/L
M	
 __

))D"**$d
C
))GRYY
7
))Iryy5
9
))J		D
9
))GRZZ%
8
))J

U
;
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))KR]]<-H
I
 __

))D"**$d
C
))'dA
N
))$bgg.G&HRkRwRw
x
))GRWW%67ARAZAZ
[
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))KR]]<-H
I
))Iryy"--
*C
D
))Irzz2==+D
E
))KR]]<-H
I
))$bjj"--@Q2R
S
))L"**bmmM.J
K
))KR]]<-H
I
))KR]]<-H
I
$ __

))D"**$d
C
))GRYY
7
))M299t
<
))GRXX
5
))GRWW\2L<O<O
P
))J
>
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))KR]]<-H
I
))%rzz2==AS3T
U
 __

))D"**$d
C
))GRWW\2L<O<O
P
))L"++-%IbIbId
e
))L"++-%IbIbIdoqovov  pI  pI  pK  L
))Irzz2==+F
G
))M2::r}}^/L
M
r   c                  "   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       y )Nquiz_questionsrg   ra   r^   r[   rY   rW   rS   rR   rH   rF   rE   rB   r<   r:   r4   r"   r   )r   
drop_tabler   r   r   	downgrader   	  s    MM"#MM)MM/"MM)MM)MM)MM+MM)MM$%MM)MM*MM.!MM,MM)MM'MM/"MM*MM'MM'r   )returnN)#__doc__typingr   r   rv   alembicr   
sqlalchemyrm   app.enums.role_typer   app.enums.user_stater   app.enums.payment_methodr   app.enums.payment_stater	   app.enums.general_stater
   app.enums.chat_file_typer   app.enums.certificate_stater   app.enums.registration_stater   %app.enums.registration_tracking_stater   r   str__annotations__r   r   r   r   r   r   r   r   <module>r      s    #    ( * 2 0 0 1 8 : K # 15uS(3--. 515uS(3--. 5.2
E#x}d*+ 2f
Rr   