a
    .i.	                     @   sT   d Z ddlmZ ddlZddlmZ ddlmZ dZ	dZ
dZdZdd	 Zd
d ZdS )zjCustom polygons

Revision ID: f67c2bcbfcfa
Revises: c408dad8b7ed
Create Date: 2025-08-11 12:23:33.198154

    )opN)
postgresql)GeometryZf67c2bcbfcfac408dad8b7edc                   C   s   t jddd t jddd t dddg t jddd	d
 t dd t jd	ddd	gdgd t dtjdt	 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ddddtd	gdgtd	 d S )N(custom_points_custom_point_group_id_fkeycustom_pointsconstraint_name
table_nameZcustom_point_groups_name_keycustom_point_groupsZcustom_groups_name_keynamecustom_point_group_idcustom_group_idnew_column_namecustom_groupsidr	   source_tablereferent_table
local_colsremote_colscustom_polygonsTF)autoincrementnullable)r   	reference
created_at
updated_atgeometryPOLYGONi  ST_GeomFromEWKT)geometry_typesrid	from_textzcustom_groups.id)r   drop_constraintcreate_unique_constraintalter_columnrename_tablecreate_foreign_keycreate_tablesaColumnIntegerString	TIMESTAMPr   ForeignKeyConstraintPrimaryKeyConstraint r1   r1   V/var/www/staging/api/app_home/migrations/insar/alembic/versions/025_custom_polygons.pyupgrade   s*    r3   c                   C   sP   t d t jddd t jdddd t dd t jd	dddgd
gd d S )Nr   r   r   r   r   r   r   r   r   r   r   )r   
drop_tabler$   r&   r'   r(   r1   r1   r1   r2   	downgrade.   s    
r5   )__doc__alembicr   
sqlalchemyr*   Zsqlalchemy.dialectsr   geoalchemy2r   revisiondown_revisionbranch_labels
depends_onr3   r5   r1   r1   r1   r2   <module>   s   