o p i. @sUdZddlmZmZddlmZddlZdZe e d<dZ ee dfe d<dZ ee ee dfe d<dZ ee ee dfe d <dd d Zdd dZdS)ziinitial wp_invoices schema Revision ID: 67b7d0a9f98e Revises: Create Date: 2025-11-03 17:01:50.714214 )SequenceUnion)opN 67b7d0a9f98erevision 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_indexfForeignKeyConstraintr8r8V/var/www/html/flask_server/alembic/versions/67b7d0a9f98e_initial_wp_invoices_schema.pyupgrades4  r:cCs,tdtjtdddtddS)zDowngrade schema.r"r r ) table_nameN)r drop_table drop_indexr6r8r8r8r9 downgrade5s r>)r N)__doc__typingrralembicr sqlalchemyr/rstr__annotations__rrr r:r>r8r8r8r9s