o â¸gQã@s’UdZddlmZmZddlmZddlZdZe e d<dZee dfe d<dZee ee dfe d <dZ ee ee dfe d <dd„Zd d„ZdS)zÊDrop users.total_points, drop rewards/reward_redemptions and update transaction_type enum in point_transactions Revision ID: 5101c3bd185a Revises: b61c52e24249 Create Date: 2025-02-21 16:08:25.294712 é)ÚSequenceÚUnion)ÚopNZ5101c3bd185aÚrevisionZb61c52e24249Ú down_revisionÚ branch_labelsÚ depends_oncCs6t d¡t d¡t d¡t d¡t d¡dS)Nz’ALTER TABLE point_transactions MODIFY COLUMN transaction_type ENUM('step', 'referral', 'referral_bonus', 'redeem', 'admin_adjust', 'etc') NOT NULLzaUPDATE point_transactions SET transaction_type='referral_bonus' WHERE transaction_type='referral'z§ALTER TABLE point_transactions MODIFY COLUMN transaction_type ENUM('step', 'achievement', 'referral_bonus', 'referral_chain', 'redeem', 'admin_adjust', 'etc') NOT NULLÚreward_redemptionsÚrewards)rÚexecuteÚ drop_table©r r úK/app/alembic/versions/5101c3bd185a_drop_users_total_points_drop_rewards_.pyÚupgradesÿÿÿ rcCsPt d¡t dtjdtjdddddtjdt d¡d d tjdtjdd tjdtjd d tjd t d¡dd tjdtjd ddtjdtj d tj ¡dtjdtj d tj ¡tj ¡d¡ t dtjdtjdddddtjdtjddtjdddd d tjdtjddtjdddd d tjdtjd d tjdtj d tj ¡d¡dS)Nz€ALTER TABLE point_transactions MODIFY COLUMN transaction_type ENUM('step', 'referral', 'redeem', 'admin_adjust', 'etc') NOT NULLr ÚidT)Úunsigned)Úprimary_keyÚ autoincrementÚreward_nameédF)ÚnullableÚdescriptionÚpoints_requiredÚcountry_codeéÚactiveÚ1)rÚserver_defaultÚ created_atÚ updated_at)rrÚonupdater Úuser_idzusers.idÚCASCADE)ÚondeleteÚ reward_idz rewards.idÚpoints_spent) rrÚcreate_tableÚsaÚColumnÚ BigIntegerÚStringÚTextÚIntegerÚDateTimeÚfuncÚnowÚ ForeignKeyr r r rÚ downgrade/s,ÿ ÷""úr1)Ú__doc__ÚtypingrrÚalembicrÚ sqlalchemyr'rÚstrÚ__annotations__rrrrr1r r r rÚs