o
    f                     @   s<   d Z ddlmZ ddlZdZdZdZdZdd Z	dd	 Z
dS )
zoadding invoice table

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

    )opNd718691d4a92968030faf65ec                  C   s  t dtjdt ddtjdt ddtjdt ddtjdt ddtjd	t ddtjdgd
gt ddtjdgdgt ddtjdt dd	 t j	dd d&} | j
dtjddtjdddd | jddd | d W d    d S 1 sw   Y  d S )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_op r/   L/home/ubuntu/webapp/migrations/versions/d718691d4a92_adding_invoice_table.pyupgrade   s&   


"r1   c                  C   s   t jdd d-} | tjdt dd | ddg | jdtjdd	tj	d
d	dd W d    n1 s7w   Y  t 
d d S )Nr   r   r   Tr   r   r   r   r   r   Fr   r   )r   r'   
add_columnr    r!   DATETIMEcreate_unique_constraintr(   r*   r)   
drop_tabler-   r/   r/   r0   	downgrade*   s   

r6   )__doc__alembicr   
sqlalchemyr    revisiondown_revisionbranch_labels
depends_onr1   r6   r/   r/   r/   r0   <module>   s    