U
    ©½c:  ã                   @   s<   d Z ddlmZ ddlZdZdZdZdZdd„ Z	dd	„ Z
dS )
zhempty message

Revision ID: 9a76db159a34
Revises: 0a2e13051c18
Create Date: 2023-01-09 15:30:04.845686

é    )ÚopNZ9a76db159a34Z0a2e13051c18c                   C   sh  t  dtjdt ¡ dd¡ t  d¡ t  d¡ t  dtjdt ¡ dd¡ t  d¡ t  d	¡ t  d
¡ t  d¡ t  dtjdt ¡ dd¡ t  d¡ t  d¡ t  dtjdt ¡ dd¡ t  d¡ t  d¡ t  dtjdt ¡ dd¡ t  d¡ t  d¡ t  dtjdt ¡ dd¡ t  d¡ t  d¡ t  dtjdt ¡ dd¡ t  d¡ t  d¡ t  dtjdt ¡ dd¡ t  d¡ t  d¡ t  d¡ t  d¡ t  d tjdt ¡ dd¡ t  d!¡ t  d"¡ t  d#tjdt ¡ dd¡ t  d$¡ t  d%¡ t  d&tjdt ¡ dd¡ t  d'¡ t  d(¡ t  d)¡ t  d*¡ t  d+tjdt ¡ dd¡ t  d,¡ t  d-¡ t  d.tjdt ¡ dd¡ t  d/¡ t  d0¡ t  d1¡ t  d2¡ t  d3tjdt ¡ dd¡ t  d4¡ t  d5¡ t  d6tjdt ¡ dd¡ t  d7¡ t  d8¡ t  d9¡ t  d:¡ t  d;tjdt ¡ dd¡ t  d<¡ t  d=¡ d S )>NÚcmf_access_listÚimport_raw_jsonT)Únullablez>DROP INDEX IF EXISTS ix_cmf_access_list_cmf_owner_assistant_idzHALTER TABLE cmf_access_list DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_access_rulez>DROP INDEX IF EXISTS ix_cmf_access_rule_cmf_owner_assistant_idzHALTER TABLE cmf_access_rule DROP COLUMN IF EXISTS cmf_owner_assistant_idz7DROP INDEX IF EXISTS ix_cmf_auth_cmf_owner_assistant_idzAALTER TABLE cmf_auth DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_auth_ldap_pluginzCDROP INDEX IF EXISTS ix_cmf_auth_ldap_plugin_cmf_owner_assistant_idzMALTER TABLE cmf_auth_ldap_plugin DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_commentz:DROP INDEX IF EXISTS ix_cmf_comment_cmf_owner_assistant_idzDALTER TABLE cmf_comment DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_documentz;DROP INDEX IF EXISTS ix_cmf_document_cmf_owner_assistant_idzEALTER TABLE cmf_document DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_document_historyzCDROP INDEX IF EXISTS ix_cmf_document_history_cmf_owner_assistant_idzMALTER TABLE cmf_document_history DROP COLUMN IF EXISTS cmf_owner_assistant_idÚ
cmf_filterz9DROP INDEX IF EXISTS ix_cmf_filter_cmf_owner_assistant_idzCALTER TABLE cmf_filter DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_global_settingszBDROP INDEX IF EXISTS ix_cmf_global_settings_cmf_owner_assistant_idzLALTER TABLE cmf_global_settings DROP COLUMN IF EXISTS cmf_owner_assistant_idz=DROP INDEX IF EXISTS ix_cmf_global_var_cmf_owner_assistant_idzGALTER TABLE cmf_global_var DROP COLUMN IF EXISTS cmf_owner_assistant_idÚ
cmf_importz9DROP INDEX IF EXISTS ix_cmf_import_cmf_owner_assistant_idzCALTER TABLE cmf_import DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_linkz7DROP INDEX IF EXISTS ix_cmf_link_cmf_owner_assistant_idzAALTER TABLE cmf_link DROP COLUMN IF EXISTS cmf_owner_assistant_idÚ
cmf_notifyz9DROP INDEX IF EXISTS ix_cmf_notify_cmf_owner_assistant_idzCALTER TABLE cmf_notify DROP COLUMN IF EXISTS cmf_owner_assistant_idz8DROP INDEX IF EXISTS ix_cmf_patch_cmf_owner_assistant_idzBALTER TABLE cmf_patch DROP COLUMN IF EXISTS cmf_owner_assistant_idÚ
cmf_personz9DROP INDEX IF EXISTS ix_cmf_person_cmf_owner_assistant_idzCALTER TABLE cmf_person DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_person_groupz?DROP INDEX IF EXISTS ix_cmf_person_group_cmf_owner_assistant_idzIALTER TABLE cmf_person_group DROP COLUMN IF EXISTS cmf_owner_assistant_idz>DROP INDEX IF EXISTS ix_cmf_person_sign_cmf_owner_assistant_idzHALTER TABLE cmf_person_sign DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_person_varz=DROP INDEX IF EXISTS ix_cmf_person_var_cmf_owner_assistant_idzGALTER TABLE cmf_person_var DROP COLUMN IF EXISTS cmf_owner_assistant_idÚ
cmf_pluginz9DROP INDEX IF EXISTS ix_cmf_plugin_cmf_owner_assistant_idzCALTER TABLE cmf_plugin DROP COLUMN IF EXISTS cmf_owner_assistant_idz7DROP INDEX IF EXISTS ix_cmf_sign_cmf_owner_assistant_idzAALTER TABLE cmf_sign DROP COLUMN IF EXISTS cmf_owner_assistant_idÚcmf_taskz7DROP INDEX IF EXISTS ix_cmf_task_cmf_owner_assistant_idzAALTER TABLE cmf_task DROP COLUMN IF EXISTS cmf_owner_assistant_id)r   Ú
add_columnÚsaÚColumnÚTEXTÚexecute© r   r   ú./opt/account/alembic/versions/9a76db159a34_.pyÚupgrade   st    








































r   c                	   C   s2  t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jdddgdd	 t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jdddgdd	 t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jdddgdd	 t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jdddgdd	 t  dd
¡ t  dtjdtjddddd¡ t jd ddgdd	 t  d!tjdtjddddd¡ t jd"d!dgdd	 t  d!d
¡ t  d#tjdtjddddd¡ t jd$d#dgdd	 t  d#d
¡ t  d%tjdtjddddd¡ t jd&d%dgdd	 t  d%d
¡ t  d'tjdtjddddd¡ t jd(d'dgdd	 t  d'd
¡ t  d)tjdtjddddd¡ t jd*d)dgdd	 t  d)d
¡ t  d+tjdtjddddd¡ t jd,d+dgdd	 t  d+d
¡ t  d-tjdtjddddd¡ t jd.d-dgdd	 t  d/tjdtjddddd¡ t jd0d/dgdd	 t  d/d
¡ t  d1tjdtjddddd¡ t jd2d1dgdd	 t  d1d
¡ d S )3Nr   Zcmf_owner_assistant_idé@   )ÚlengthFT)Úautoincrementr   Z"ix_cmf_task_cmf_owner_assistant_id)Úuniquer   Úcmf_signZ"ix_cmf_sign_cmf_owner_assistant_idr   Z$ix_cmf_plugin_cmf_owner_assistant_idr   Z(ix_cmf_person_var_cmf_owner_assistant_idÚcmf_person_signZ)ix_cmf_person_sign_cmf_owner_assistant_idr   Z*ix_cmf_person_group_cmf_owner_assistant_idr   Z$ix_cmf_person_cmf_owner_assistant_idÚ	cmf_patchZ#ix_cmf_patch_cmf_owner_assistant_idr   Z$ix_cmf_notify_cmf_owner_assistant_idr   Z"ix_cmf_link_cmf_owner_assistant_idr   Z$ix_cmf_import_cmf_owner_assistant_idÚcmf_global_varZ(ix_cmf_global_var_cmf_owner_assistant_idr   Z-ix_cmf_global_settings_cmf_owner_assistant_idr   Z$ix_cmf_filter_cmf_owner_assistant_idr
   Z.ix_cmf_document_history_cmf_owner_assistant_idr	   Z&ix_cmf_document_cmf_owner_assistant_idr   Z%ix_cmf_comment_cmf_owner_assistant_idr   Z.ix_cmf_auth_ldap_plugin_cmf_owner_assistant_idÚcmf_authZ"ix_cmf_auth_cmf_owner_assistant_idr   Z)ix_cmf_access_rule_cmf_owner_assistant_idr   Z)ix_cmf_access_list_cmf_owner_assistant_id)r   r   r   r   ÚVARCHARÚcreate_indexÚdrop_columnr   r   r   r   Ú	downgrade|   st    """""""""""""""""""""r)   )Ú__doc__Úalembicr   Ú
sqlalchemyr   ÚrevisionÚdown_revisionÚbranch_labelsÚ
depends_onr   r)   r   r   r   r   Ú<module>   s   i