oqiq<dZddlmZddlZdZdZdZdZddZ ddZ y) zdadd pos analytics tables Revision ID: aa3e4f5g6h7i8 Revises: a3f4g5h6i7j8 Create Date: 2026-05-06 )opN aa3e4f5g6h7i8 a3f4g5h6i7j8c ,tjdtjdtjdtjdtjtj ddd tjd tjtj d d d tjdtjtj ddd tjdtj d tjdtj d tjdtjd dtjdtjddd dtjdtjddd dtjdtjd tjd tjdddgtjddgdtjd tjdtjdtjdtjtj ddd tjd!tjtj d"dd tjd#tjtj d$dd tjd%tj d tjd&tjd tjd'tjd(d tjd)tjd*d tjd+tjd*d tjd,tjd(d tjd-tjd.d tjd/tjd*d tjd0tjd1d tjd2tjddd dtjd3tjddd dtjd4tjd*d tjd5tjd(d tjd6tjd1d tjd7tjd(d tjd8tjd9d tjd:tjd*d tjd;tjd<d tjd=tjd1d tjd>tjd(d tjd?d dgtjd@d d!gtjdAd d7gtjdBd d%gtjdCd d#gtjdDd gdEy)FNpos_upload_batchidT) primary_keyspbu_idzmaster_spbu.idCASCADE)ondeleteF)nullable produk_idzmaster_produk.idRESTRICTuploaded_by_idzmaster_user.idzSET NULL tanggal_mulaitanggal_selesai total_rows0)r server_default total_volume total_nilai created_atznow()ix_pos_upload_batch_spbuuq_pos_upload_batch_period)r rrrpos_transaksi_pertaminabatch_idzpos_upload_batch.idshift_idzmaster_spbu_shift.idtanggaljamcode_morprovincedcityno_spbu_pertamina no_nozzle no_dispenser produk_raw2volumenilai operator_nameno_hp delivery_type plat_nomornikinstansi timestamp)timezone island_raw nozzle_rawix_pos_transaksi_spbuix_pos_transaksi_batchix_pos_transaksi_platix_pos_transaksi_tanggalix_pos_transaksi_shiftuq_pos_transaksi_dedup)r r7r+)r create_tablesaColumnInteger ForeignKeyDateNumericDateTimetext create_indexcreate_unique_constraintTimeStringY/var/www/html/spbu.com/backend/alembic/versions/aa3e4f5g6h7i8_add_pos_analytics_tables.pyupgraderQshOO $ $7 )RZZ\2==9IT]+^ino +rzz|R]];MXb-cnst "BJJL"--@P[e2fquv /2779u= #RWWY? , uSQ ."**R"3eTWX -B!2USVW , bggV]N^_ OO.0BYKP$D OO! $ $7 )RZZ\2==9IT]+^ino *bjjlBMM:OZc,dotu *bjjlBMM:P[e,fquv )RWWY7 %U3 *biimd; *biint< &"))C.48 %ryy}tD +ryy}t< ."))C.5A , " > (BJJr1-cR '2::b!,uSQ /299S>DA '299R=48 /299R=4@ , " = %26 *biint< +r{{D9EJ , " = , " =36OO+-F TOO,.G*VOO+-FWOO.0II;WOO,.G*V !0rOcXtjdtjdy)Nrr)r drop_tablerNrOrP downgraderTMsMM+,MM$%rO)returnN) __doc__alembicr sqlalchemyrBrevision down_revision branch_labels depends_onrQrTrNrOrPr]s1    9x&rO