o :s i @sUdZddlmZmZddlmZddlZdZe e d<dZ ee dfe d<dZ ee ee dfe d <dZ ee ee dfe d <dd d ZdddZdS)zpwp_invoices schema v1 Revision ID: 6dc0a6517c68 Revises: 67b7d0a9f98e Create Date: 2025-11-04 03:30:02.634982 )SequenceUnion)opN 6dc0a6517c68revision 67b7d0a9f98e down_revision branch_labels depends_onreturncCstdtjdtddtjdtjddddtjd tjd dddtjd tjd dddtjd tjddddtjdtjd dddtjdtjdddddtjdtjdddddtjdtjdddddtjdtjdddddtd tjt ddd gddtdtjdtddtjdtddtjdtjd dddtjdtjddddtjdtjdddddtjd tjdd!dddtjd"tjdddddtj dgd#gd$d%td tjt d&ddgddd'S)(zUpgrade schema.invoicesidF)nullable supplier_name)lengthT supplier_abn@invoice_number invoice_date payment_methodtendered_total ) precisionscale items_sumgst grand_totalix_invoices_invoice_number)unique invoice_items invoice_idsku descriptioniqty unit_price line_totalz invoices.idCASCADE)ondeleteix_invoice_items_invoice_idN) r create_tablesaColumnIntegerStringNumericPrimaryKeyConstraint create_indexfForeignKeyConstraintr9r9Q/var/www/html/flask_server/alembic/versions/6dc0a6517c68_wp_invoices_schema_v1.pyupgrades4  r;cCs@tjtdddtdtjtdddtddS)zDowngrade schema.r.r#) table_namer!r N)r drop_indexr7 drop_tabler9r9r9r: downgrade5s r?)r N)__doc__typingrralembicr sqlalchemyr0rstr__annotations__rr r r;r?r9r9r9r:s