
    ɫf                     8    d Z ddlmZ ddlZdZdZdZdZd Z	d Z
y)zoadding invoice table

Revision ID: d718691d4a92
Revises: 968030faf65e
Create Date: 2024-08-01 13:46:29.122991

    )opNd718691d4a92968030faf65ec                     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gd
gt        j                  d            t        j                  dgdgt        j                  d            t        j                  dt        j                  d            	       t        j                  dd       5 } | j                  dt        j                  d      t        j                  d      d       | j                  dd       | j                  d       d d d        y # 1 sw Y   y xY w)Ncompany_planidFnullable
company_idTplan_id
start_dateend_datez
company.id"fk_company_plan_company_id_company)namezplan.idfk_company_plan_plan_id_planpk_company_plancompanyschemar   x   length   existing_typetype_existing_nullableuq_company_nameunique)r   
updated_at)r   create_tablesaColumnIntegerDateTimeForeignKeyConstraintfPrimaryKeyConstraintbatch_alter_tablealter_columnVARCHARStringdrop_constraintdrop_columnbatch_ops    hC:\Users\jakel\PycharmProjects\oakenCloudWebApp\migrations\versions\d718691d4a92_adding_invoice_table.pyupgrader2      sU   OONIIdBJJL51IIlBJJL48IIi5IIlBKKME:IIj"++-$7\N\NFjAklYK)244@^;_`Drtt,='>?	 
		i	5 +fZZs3YYc*!& 	 	( 	  !2( C\*+ + +s   ;A"G&&G/c                     t        j                  dd       5 } | j                  t        j                  dt        j
                         d             | j                  ddg       | j                  dt        j                  d	      t        j                  d
	      d       d d d        t        j                  d       y # 1 sw Y   xY w)Nr   r   r    Tr	   r   r   r   r   r   Fr   r   )r   r)   
add_columnr"   r#   DATETIMEcreate_unique_constraintr*   r,   r+   
drop_tabler/   s    r1   	downgrader8   *   s    			i	5 (BIIlBKKMDQR))*;fXFfYYc2ZZs+!& 	 	(( MM.!( (s   B
C  C	)__doc__alembicr   
sqlalchemyr"   revisiondown_revisionbranch_labels
depends_onr2   r8        r1   <module>rB      s2      
+.
"rA   