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 )
zkadding invoicing

Revision ID: 19522332ad22
Revises: 945cc1e54aeb
Create Date: 2024-08-02 13:53:46.169479

é    )ÚopNÚ19522332ad22Ú945cc1e54aebc                  C   sô  t jdd dé} |  tjdt ¡ dd¡ |  tjdt ¡ dd¡ |  tjdtjdd	dd¡ |  tjd
t ¡ dd¡ |  tjdtjdd	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t ¡ dd¡ |  tjdt ¡ dd¡ |  tjdt ¡ dd¡ |  tjdt 	¡ dd¡ |  
|  d¡ddgdg¡ |  
|  d¡dd
gdg¡ |  d¡ |  d¡ |  d¡ |  d¡ |  d¡ W d   ƒ d S 1 sów   Y  d S )NÚinvoice©ÚschemaÚcustomer_idF©ÚnullableÚ
order_dateÚshipped_electronically_toéx   ©ÚlengthÚplan_idÚplan_descriptioné   ÚpriceÚqtyÚextended_priceÚsubtotalÚ	sales_taxÚtotalÚbalance_dueÚis_paidÚfk_invoice_customer_id_userÚuserÚidÚfk_invoice_plan_id_planÚplanÚdue_dateÚ
created_atÚ	paid_dateÚstatusÚamount)r   Úbatch_alter_tableÚ
add_columnÚsaÚColumnÚIntegerÚDateTimeÚStringÚFloatÚBooleanÚcreate_foreign_keyÚfÚdrop_column©Úbatch_op© r3   úH/home/ubuntu/webapp/migrations/versions/19522332ad22_adding_invoicing.pyÚupgrade   s,   



"ìr5   c                  C   sd  t jdd d¡} |  tjdt ¡ dd¡ |  tjdtjdddd¡ |  tjd	t ¡ d
d¡ |  tjdt ¡ d
d¡ |  tjdt ¡ dd¡ | j|  	d¡dd | j|  	d¡dd |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ |  
d¡ W d   ƒ d S 1 s«w   Y  d S )Nr   r   r$   Fr	   r#   é2   r   r"   Tr!   r    r   Ú
foreignkey)Útype_r   r   r   r   r   r   r   r   r   r   r   r   r   r   )r   r%   r&   r'   r(   ÚFLOATÚVARCHARÚDATETIMEÚdrop_constraintr/   r0   r1   r3   r3   r4   Ú	downgrade.   s,   











"ìr=   )Ú__doc__Úalembicr   Ú
sqlalchemyr'   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr5   r=   r3   r3   r3   r4   Ú<module>   s    