
    e                     D    d Z ddlmZ ddlZddlmZ dZdZdZ	dZ
d Zd Zy)	z`asset

Revision ID: 04e5270f74a3
Revises: 183ded3722ad
Create Date: 2024-02-27 21:33:15.364821

    )opN)
postgresql04e5270f74a3183ded3722adc                  V   t        j                  g dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d t        j                  d      d      t        j                  d!t        j                  d      d      t        j                  d"t        j                  d      d      t        j                  d#t        j                  d      d      t        j                  d$t        j                  d      d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  d%gd(g      t        j                  d        t        j                  d)t        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d*t        j                  d+      d      t        j                  d#t        j                  d      d      t        j                  d$t        j                  d      d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  d             t        j                  d,t        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d-t        j                         d      t        j                  d#t        j                  d      d      t        j                  d$t        j                  d      d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  d.t        j                  d      d      t        j                  d%gd/g      t        j                  d.gd0g      t        j                  d             t        j                  g d1t        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  d2t        j                  d      d      t        j                  d3t        j                         d      t        j                  d4t        j                         d      t        j                  d5t        j                         d      t        j                  d6t        j                         d      t        j                  d7t        j                         d      t        j                  d8t        j                         d      t        j                  d9t        j                         d      t        j                  d:t        j                         d      t        j                  d;t        j                         d      t        j                  d<t        j                         d      t        j                  d=t        j                         d      t        j                  d>t        j                         d      t        j                  d?t        j                         d      t        j                  d@t        j                         d      t        j                  dAt        j                  d      d      t        j                  dBt        j                  d      d      t        j                  dCt        j                  d      d      t        j                  dDt        j                         d      t        j                  dEt        j                         d      t        j                  dFt        j                         d      t        j                  dGt        j                         d      t        j                  dHt        j                         d      t        j                  dIt        j                         d      t        j                  dJt        j                  d+      d      t        j                  dKt        j                         d      t        j                  dLt        j
                  d	      d      t        j                  dMt        j
                  d	      d      t        j                  dNt        j
                  d	      d      t        j                  dOt        j
                  d	      d      t        j                  dPt        j
                  d	      d      t        j                  dQt        j                         d      t        j                  dRt        j                         d      t        j                  dSt        j                  d+      d      t        j                  dTt        j
                  d	      d      t        j                  dUt        j
                  d	      d      t        j                  dVt        j
                  d	      d      t        j                  dWt        j
                  d	      d      t        j                  dXt        j
                  d	      d      t        j                  dYt        j                  d+      d      t        j                  dZt        j                         d      t        j                  d[t        j                         d      t        j                  d\t        j                  d+      d      t        j                  d]t        j                         d      t        j                  d^t        j                         d      t        j                  d_t        j                  d+      d      t        j                  d`t        j                  d+      d      t        j                  dat        j                  d+      d      t        j                  dbt        j                  d+      d      t        j                  dct        j                  d+      d      t        j                  ddt        j                  d      d      t        j                  det        j                  d      d      t        j                  dft        j                  d      d      t        j                  dgt        j                  d      d      t        j                  dht        j                  d      d      t        j                  dit        j                  d      d      t        j                  djt        j                         d      t        j                  dkt        j                         d      t        j                  dlt        j                         d      t        j                  dmt        j                  d+      d      t        j                  dnt        j                  d+      d      t        j                  dot        j                  d      d      t        j                  dpt        j                  d+      d      t        j                  dqt        j                  d+      d      t        j                  drt        j                  d      d      t        j                  dst        j                  d      d      t        j                  dtt        j                  d+      d      t        j                  dut        j                  d      d      t        j                  dvt        j                         d      t        j                  dwt        j                         d      t        j                  dxt        j                         d      t        j                  d#t        j                  d      d      t        j                  d$t        j                  d      d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  dyt        j                  d      d      t        j                  d.t        j                  d      d      t        j                  dzt        j                  d      d      t        j                  d{t        j                  d      d      t        j                  d|t        j                  d      d      t        j                  d}t        j                  d      d      t        j                  d~t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dgdg      t        j                  dgd0g      t        j                  dgdg      t        j                  dygdg      t        j                  dgdg      t        j                  d~gdg      t        j                  dgdg      t        j                  dgd(g      t        j                  dgdg      t        j                  d%gd/g      t        j                  d{gdg      t        j                  dgdg      t        j                  dgdg      t        j                  dgdg      t        j                  d}gdg      t        j                  d        t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dTgd       t        j                  t        j                  d      d1d^gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d\gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d#gd       t        j                  t        j                  d      d1d
gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dygd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d'gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d&gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d$gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d2gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d~gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dZgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dIgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d=gd       t        j                  t        j                  d      d1d%gd       t        j                  t        j                  d      d1dKgd       t        j                  t        j                  d      d1d{gd       t        j                  t        j                  d      d1d|gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dzgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d.gd       t        j                  t        j                  d      d1dgd       t        j                  t        j                  d      d1d}gd       t        j                  t        j                  d«      d,d#gd       t        j                  t        j                  dë      d,d
gd       t        j                  t        j                  dī      d,dgd       t        j                  t        j                  dū      d,dgd       t        j                  t        j                  dƫ      d,d'gd       t        j                  t        j                  dǫ      d,dgd       t        j                  t        j                  dȫ      d,d&gd       t        j                  t        j                  dɫ      d,d$gd       t        j                  t        j                  dʫ      d,dgd       t        j                  t        j                  d˫      d,dgd       t        j                  t        j                  d̫      d,d%gd       t        j                  t        j                  dͫ      d,d.gd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d֫      ddgd       t        j                  t        j                  d׫      dd%gd       t        j                  t        j                  dث      ddgd       t        j                  t        j                  d٫      ddgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d۫      ddgd       t        j                  t        j                  dܫ      dd%gd       t        j                  t        j                  dݫ      ddgd       t        j                  t        j                  dޫ      ddgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd%gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd%gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd%gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd%gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      d)d#gd       t        j                  t        j                  d      d)d
gd       t        j                  t        j                  d      d)dgd       t        j                  t        j                  d      d)dgd       t        j                  t        j                  d      d)d'gd       t        j                  t        j                  d      d)dgd       t        j                  t        j                  d      d)d&gd       t        j                  t        j                  d      d)d$gd       t        j                  t        j                  d      d)dgd       t        j                  t        j                  d      d)dgd       t        j                  t        j                  d      d)d*gd       t        j                  t        j                  d      d)d%gd       t        j                  d t        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      d dgd       t        j                  t        j                  d      d d%gd       t        j                  t        j                  d      d dgd       t        j                  t        j                  d      d dgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd%gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d	      ddgd       t        j                  d
t        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      d
dgd       t        j                  t        j                  d      d
d%gd       t        j                  t        j                  d      d
dgd       t        j                  t        j                  d      d
dgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd%gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  dt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      dd%gd       t        j                  t        j                  d      ddgd       t        j                  t        j                  d      ddgd       t        j                  dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  d-t        j                         d      t        j                  d#t        j                  d      d      t        j                  d$t        j                  d      d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  d.t        j                  d      d      t        j                  d%gd/g      t        j                  d.gdg      t        j                  d             t        j                  dt        j                  dt        j                  d      d      t        j                  dt        j
                  d	      d      t        j                  d
t        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j
                  d	      d      t        j                  dt        j                         d      t        j                  dt        j                         d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                         d      t        j                  d t        j                  d      d      t        j                  d!t        j                  d      d      t        j                  d#t        j                  d      d      t        j                  d$t        j                  d      d      t        j                  d%t        j                  d      d      t        j                  d&t        j                  d      d      t        j                  d't        j                  d      d      t        j                  d"t        j                  d      d      t        j                  d"gdg      t        j                  d%gd/g      t        j                  d             t        j                  d#t        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dgdg      t        j                  dgd$g      t        j                  d             t        j                  t        j                  d%      dd"gd       t        j                  t        j                  d&      dd#gd       t        j                  t        j                  d'      dd
gd       t        j                  t        j                  d(      ddgd       t        j                  t        j                  d)      ddgd       t        j                  t        j                  d*      dd'gd       t        j                  t        j                  d+      ddgd       t        j                  t        j                  d,      dd&gd       t        j                  t        j                  d-      dd$gd       t        j                  t        j                  d.      ddgd       t        j                  t        j                  d/      ddgd       t        j                  t        j                  d0      dd%gd       t        j                  t        j                  d1      dd#gd       t        j                  t        j                  d2      dd
gd       t        j                  t        j                  d3      ddgd       t        j                  t        j                  d4      ddgd       t        j                  t        j                  d5      dd'gd       t        j                  t        j                  d6      ddgd       t        j                  t        j                  d7      dd&gd       t        j                  t        j                  d8      dd$gd       t        j                  t        j                  d9      ddgd       t        j                  t        j                  d:      ddgd       t        j                  t        j                  d;      dd%gd       t        j                  t        j                  d<      dd.gd       t        j                  d=t        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  d>      d=dgd       t        j                  t        j                  d?      d=d%gd       t        j                  t        j                  d@      d=dgd       t        j                  t        j                  dA      d=dgd       t        j                  dBt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  dC      dBdgd       t        j                  t        j                  dD      dBd%gd       t        j                  t        j                  dE      dBdgd       t        j                  t        j                  dF      dBdgd       t        j                  dGt        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  d      
       t        j                  t        j                  dH      dGdgd       t        j                  t        j                  dI      dGd%gd       t        j                  t        j                  dJ      dGdgd       t        j                  t        j                  dK      dGdgd       t        j                  t        j                  dL      dd#gd       t        j                  t        j                  dM      dd
gd       t        j                  t        j                  dN      ddgd       t        j                  t        j                  dO      ddgd       t        j                  t        j                  dP      dd'gd       t        j                  t        j                  dQ      ddgd       t        j                  t        j                  dR      dd&gd       t        j                  t        j                  dS      dd$gd       t        j                  t        j                  dT      ddgd       t        j                  t        j                  dU      ddgd       t        j                  dVddgddWddXiY       t        j                  t        j                  dZ      dd%gd       t        j                  d[t        j                  dt        j                  dϬ      d      t        j                  d%t        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dt        j                  d      d      t        j                  dgd\g      t        j                  dgdg      t        j                  d             t        j                  t        j                  d]      d[dgd       t        j                  t        j                  d^      d[d%gd       t        j                  t        j                  d_      d[dgd       t        j                  t        j                  d`      d[dgd       t        j                  t        j                  da      ddgd       t        j                  t        j                  db      dd%gd       t        j                  t        j                  dc      ddgd       t        j                  t        j                  dd      ddgd       t        j                  t        j                  de      d#dgd       t        j                  t        j                  df      d#d%gd       t        j                  t        j                  dg      d#dgd       t        j                  t        j                  dh      d#dgd       y (i  Ncmf_locationid@   )lengthF)nullablecmf_locked_atT)timezonecmf_created_atcmf_modified_atcmf_viewed_atcmf_deletedcmf_versionnamei   country   country_codezip_code	area_codeareacitystreetdistrictmun_district
settlementcity_districtlocality	territoryhouse_numberfloorflatroomcmf_author_idcmf_owner_id	parent_idcmf_modified_by_idcmf_locked_by_idzcmf_location.idcmf_asset_schemecode_prefix    cmf_asset_catis_abstracttree_parent_idzcmf_asset_scheme.idzcmf_asset_cat.id	cmf_assetcodesystemtextimport_originalimport_raw_jsonext_idcmf_archivedis_favoritehas_tree_nodestree_node_is_branchtree_hiddenordernoperm_publicperm_has_aclperm_inheritperm_parent_owner_idperm_inherit_acl_idperm_effective_acl_id%perm_security_level_allowed_ids_cacheperm_encrypt	is_publicis_public_editableis_public_commentslogic_prefixui_view_formparent_logic_prefixstatus_modified_atstatus_in_progress_startstatus_in_progress_endstatus_review_atstatus_closed_at
no_controlprioritymark
alarm_datedeadlineplan_start_dateplan_end_dateperiod_next_dateperiod_intervalis_template
is_penaltycache_status_typecache_fieldsapprovedperm_policyperm_policy_guestperm_policy_anonymousperm_policy_sharelinksharelink_hash	asset_tagserial_number	po_numberinvoice_numberlease_contractmaintenance_contractpurchase_daterefresh_datelast_scan_dateownership_typedevice_type
os_versionenabled_statusoperational_statusimeiphone_number	ip_adressdomain_namewarranty_expirationrelease_datewriteoff_datecmf_import_idroot_parent_idperm_acl_idperm_parent_idworkflow_iddefault_task_workflow_idlogic_type_idscheme_wf_idcmf_owner_assistant_idperm_security_level_id	status_id
company_idresponsible_idwaiting_for_idcloned_from_idactivity_idcache_status_opt_idasset_cat_idlocation_idincluded_in_idzcmf_activity.idzcmf_status_opt.idzcmf_import.idzcmf_company.idzcmf_workflow.idzcmf_asset.idzcmf_logic_type.idzcmf_access_list.idzcmf_security_level.idzcmf_scheme_wf.idzcmf_status.idix_cmf_asset_activity_id)uniqueix_cmf_asset_alarm_dateix_cmf_asset_approvedix_cmf_asset_asset_cat_id ix_cmf_asset_cache_status_opt_idix_cmf_asset_cache_status_typeix_cmf_asset_cloned_from_idix_cmf_asset_cmf_author_idix_cmf_asset_cmf_created_atix_cmf_asset_cmf_deletedix_cmf_asset_cmf_import_idix_cmf_asset_cmf_locked_atix_cmf_asset_cmf_locked_by_idix_cmf_asset_cmf_modified_atix_cmf_asset_cmf_modified_by_id#ix_cmf_asset_cmf_owner_assistant_idix_cmf_asset_cmf_owner_idix_cmf_asset_cmf_versionix_cmf_asset_cmf_viewed_atix_cmf_asset_codeix_cmf_asset_company_id%ix_cmf_asset_default_task_workflow_idix_cmf_asset_included_in_idix_cmf_asset_is_templateix_cmf_asset_location_idix_cmf_asset_logic_prefixix_cmf_asset_logic_type_idix_cmf_asset_nameix_cmf_asset_ordernoix_cmf_asset_parent_id ix_cmf_asset_parent_logic_prefixix_cmf_asset_perm_acl_idix_cmf_asset_perm_parent_id#ix_cmf_asset_perm_security_level_idix_cmf_asset_responsible_idix_cmf_asset_root_parent_idix_cmf_asset_scheme_wf_idix_cmf_asset_status_idix_cmf_asset_tree_parent_idix_cmf_asset_waiting_for_idix_cmf_asset_workflow_idix_cmf_asset_cat_cmf_author_idix_cmf_asset_cat_cmf_created_atix_cmf_asset_cat_cmf_deletedix_cmf_asset_cat_cmf_locked_at!ix_cmf_asset_cat_cmf_locked_by_id ix_cmf_asset_cat_cmf_modified_at#ix_cmf_asset_cat_cmf_modified_by_idix_cmf_asset_cat_cmf_owner_idix_cmf_asset_cat_cmf_versionix_cmf_asset_cat_cmf_viewed_atix_cmf_asset_cat_parent_idix_cmf_asset_cat_tree_parent_idcmf_asset_cat_role_developer   root_iddescriptionleft_idright_idleft_name_cacheright_name_cache'ix_cmf_asset_cat_role_developer_left_id)ix_cmf_asset_cat_role_developer_parent_id(ix_cmf_asset_cat_role_developer_right_id'ix_cmf_asset_cat_role_developer_root_idcmf_asset_cat_role_manager%ix_cmf_asset_cat_role_manager_left_id'ix_cmf_asset_cat_role_manager_parent_id&ix_cmf_asset_cat_role_manager_right_id%ix_cmf_asset_cat_role_manager_root_idcmf_asset_cat_role_usercmf_asset_cmf_owner_assistants)ix_cmf_asset_cmf_owner_assistants_left_id+ix_cmf_asset_cmf_owner_assistants_parent_id*ix_cmf_asset_cmf_owner_assistants_right_id)ix_cmf_asset_cmf_owner_assistants_root_idcmf_asset_executorsix_cmf_asset_executors_left_id ix_cmf_asset_executors_parent_idix_cmf_asset_executors_right_idix_cmf_asset_executors_root_idcmf_asset_local_links ix_cmf_asset_local_links_left_id"ix_cmf_asset_local_links_parent_id!ix_cmf_asset_local_links_right_id ix_cmf_asset_local_links_root_idcmf_asset_owner_group ix_cmf_asset_owner_group_left_id"ix_cmf_asset_owner_group_parent_id!ix_cmf_asset_owner_group_right_id ix_cmf_asset_owner_group_root_id!ix_cmf_asset_scheme_cmf_author_id"ix_cmf_asset_scheme_cmf_created_atix_cmf_asset_scheme_cmf_deleted!ix_cmf_asset_scheme_cmf_locked_at$ix_cmf_asset_scheme_cmf_locked_by_id#ix_cmf_asset_scheme_cmf_modified_at&ix_cmf_asset_scheme_cmf_modified_by_id ix_cmf_asset_scheme_cmf_owner_idix_cmf_asset_scheme_cmf_version!ix_cmf_asset_scheme_cmf_viewed_atix_cmf_asset_scheme_code_prefixix_cmf_asset_scheme_parent_idcmf_asset_scheme_role_developer*ix_cmf_asset_scheme_role_developer_left_id,ix_cmf_asset_scheme_role_developer_parent_id+ix_cmf_asset_scheme_role_developer_right_id*ix_cmf_asset_scheme_role_developer_root_idcmf_asset_scheme_role_manager(ix_cmf_asset_scheme_role_manager_left_id*ix_cmf_asset_scheme_role_manager_parent_id)ix_cmf_asset_scheme_role_manager_right_id(ix_cmf_asset_scheme_role_manager_root_idcmf_asset_scheme_role_user%ix_cmf_asset_scheme_role_user_left_id'ix_cmf_asset_scheme_role_user_parent_id&ix_cmf_asset_scheme_role_user_right_id%ix_cmf_asset_scheme_role_user_root_idcmf_asset_spectatorsix_cmf_asset_spectators_left_id!ix_cmf_asset_spectators_parent_id ix_cmf_asset_spectators_right_idix_cmf_asset_spectators_root_idcmf_asset_support_group"ix_cmf_asset_support_group_left_id$ix_cmf_asset_support_group_parent_id#ix_cmf_asset_support_group_right_id"ix_cmf_asset_support_group_root_idcmf_asset_type_catzcmf_asset_type_cat.idcmf_asset_typemodel_idbar_codeproduct_information
unit_priceversion
short_nameasset_type_cat_idcmf_asset_cmf_asset_typezcmf_asset_type.id#ix_cmf_asset_type_asset_type_cat_idix_cmf_asset_type_cmf_author_id ix_cmf_asset_type_cmf_created_atix_cmf_asset_type_cmf_deletedix_cmf_asset_type_cmf_locked_at"ix_cmf_asset_type_cmf_locked_by_id!ix_cmf_asset_type_cmf_modified_at$ix_cmf_asset_type_cmf_modified_by_idix_cmf_asset_type_cmf_owner_idix_cmf_asset_type_cmf_versionix_cmf_asset_type_cmf_viewed_atix_cmf_asset_type_parent_id#ix_cmf_asset_type_cat_cmf_author_id$ix_cmf_asset_type_cat_cmf_created_at!ix_cmf_asset_type_cat_cmf_deleted#ix_cmf_asset_type_cat_cmf_locked_at&ix_cmf_asset_type_cat_cmf_locked_by_id%ix_cmf_asset_type_cat_cmf_modified_at(ix_cmf_asset_type_cat_cmf_modified_by_id"ix_cmf_asset_type_cat_cmf_owner_id!ix_cmf_asset_type_cat_cmf_version#ix_cmf_asset_type_cat_cmf_viewed_atix_cmf_asset_type_cat_parent_id$ix_cmf_asset_type_cat_tree_parent_id!cmf_asset_type_cat_role_developer,ix_cmf_asset_type_cat_role_developer_left_id.ix_cmf_asset_type_cat_role_developer_parent_id-ix_cmf_asset_type_cat_role_developer_right_id,ix_cmf_asset_type_cat_role_developer_root_idcmf_asset_type_cat_role_manager*ix_cmf_asset_type_cat_role_manager_left_id,ix_cmf_asset_type_cat_role_manager_parent_id+ix_cmf_asset_type_cat_role_manager_right_id*ix_cmf_asset_type_cat_role_manager_root_idcmf_asset_type_cat_role_user'ix_cmf_asset_type_cat_role_user_left_id)ix_cmf_asset_type_cat_role_user_parent_id(ix_cmf_asset_type_cat_role_user_right_id'ix_cmf_asset_type_cat_role_user_root_idix_cmf_location_cmf_author_idix_cmf_location_cmf_created_atix_cmf_location_cmf_deletedix_cmf_location_cmf_locked_at ix_cmf_location_cmf_locked_by_idix_cmf_location_cmf_modified_at"ix_cmf_location_cmf_modified_by_idix_cmf_location_cmf_owner_idix_cmf_location_cmf_versionix_cmf_location_cmf_viewed_atix_cmf_location_name_gin_trgmgingin_trgm_ops)r   postgresql_usingpostgresql_opsix_cmf_location_parent_idcmf_task_cmf_assetzcmf_task.idix_cmf_task_cmf_asset_left_idix_cmf_task_cmf_asset_parent_idix_cmf_task_cmf_asset_right_idix_cmf_task_cmf_asset_root_id"ix_cmf_asset_cat_role_user_left_id$ix_cmf_asset_cat_role_user_parent_id#ix_cmf_asset_cat_role_user_right_id"ix_cmf_asset_cat_role_user_root_id#ix_cmf_asset_cmf_asset_type_left_id%ix_cmf_asset_cmf_asset_type_parent_id$ix_cmf_asset_cmf_asset_type_right_id#ix_cmf_asset_cmf_asset_type_root_id)r   create_tablesaColumnString	TIMESTAMPBooleanBIGINTForeignKeyConstraintPrimaryKeyConstraintTEXTIntegerDATEcreate_indexf     3/opt/eva-app/alembic/versions/04e5270f74a3_asset.pyupgradern     sKA   OO !N !IIdBIIR(59!IIor||T:TJ! IId ;eL! IIt!<uM	!
 IIor||T:TJ! IImRZZ\E:! IImRYY[48! IIfbiit,u=! IIi#.>! IInbiis3dC! IIj"))3/$?! IIk299C04@! IIfbiis+d;! IIfbiis+d;! IIh		-=!  IIj"))3/$?!!" IInbiis3dC#!$ IIlBIIS1DA%!& IIoryy4tD'!( IIj"))3/$?)!* IIk299C04@+!, IInbiis3dC-!. IIgryy,t</!0 IIfbiis+d;1!2 IIfbiis+d;3!4 IIoryy3dC5!6 IInbiir2TB7!8 IIk299B/$?9!: II"BIIR$84H;!< II "))2"6F=!> [M,=+>A?!@ D!A!D OO&IIdBIIR(59IIor||T:TJIId ;eLIIt!<uMIIor||T:TJIImRZZ\E:IImRYY[48IImRYYb1EBIIoryy3dCIInbiir2TBIIk299B/$?II"BIIR$84HII "))2"6FD!" OOOIIdBIIR(59IIor||T:TJIId ;eLIIt!<uMIIor||T:TJIImRZZ\E:IImRYY[48IImRZZ\E:IIoryy3dCIInbiir2TBIIk299B/%@II"BIIR$84HII "))2"6FII		 4tD[M,A+BE-.1C0DGD!#& OO zK zIIdBIIR(59zIIor||T:TJz IId ;eLz IIt!<uM	z
 IIor||T:TJz IImRZZ\E:z IImRYY[48z IIfbiis+d;z IIfbiir*T:z IIh

u5z IIfbggi$/z II=z IIT:z IIh		d3z IInbjjlU;z  IImRZZ\D9!z" II

t<#z$ II#RZZ\DA%z& IImRZZ\D9'z( IIi5)z* IImRZZ\D9+z, IInbjjlT:-z. IInbjjlT:/z0 II$biir&:TJ1z2 II#RYYb%9DI3z4 II%ryy';dK5z6 II5rwwy4P7z8 IInbjjlT:9z: IIk2::<$7;z< II"BJJL4@=z> II"BJJL4@?z@ IInbiikD9AzB IInbiir2UCCzD II#RYY[4@EzF II"BLL$$?$OGzH II(",,*EPTUIzJ II&d(CdSKzL II ",,"=MMzN II ",,"=MOzP IIlBJJL48QzR IIj"**,7SzT IIfbiir*T:UzV IIlBLL$7$GWzX IIj",,5EYzZ IIt!<tL[z\ IIor||T:TJ]z^ II ",,"=M_z` II"!5Eazb IImRZZ\D9czd IIlBJJL48ezf II!299B#7$Ggzh IInbggi$7izj IIj"**,7kzl IImRYYb1EBmzn II!299B#7%Hozp II%ryy';eLqzr II%ryy';eLszt II		 4tDuzv IIk299C04@wzx IIoryy4tDyzz IIk299C04@{z| II		 5E}z~ II		 5Ez@ II$biis&;dKAzB IIorwwy48CzD IInbggi$7EzF II	D9GzH II		 4tDIzJ IImRYYb1DAKzL IIlBIIS1DAMzN II		 4tDOzP II"BIIR$84HQzR IIfbiis+d;SzT IInbiis3dCUzV IIk299B/$?WzX IImRYYc2TBYzZ II#RWWY>[z\ IInbggi$7]z^ IIorwwy48_z` IIoryy3dCazb IInbiir2TBczd IIk299B/%@ezf II"BIIR$84Hgzh II "))2"6Fizj IIoryy3dCkzl II		 4tDmzn II		 4tDozp IImRYYb1DAqzr II		 4tDszt IImRYYb1DAuzv II("))2*>Nwzx IIoryy3dCyzz IInbiir2TB{z| II&		(<tL}z~ II&		(<tLz@ IIk299B/$?AzB IIlBIIR04@CzD II		 4tDEzF II		 4tDGzH II		 4tDIzJ IImRYYb1DAKzL II#RYYb%9DIMzN IInbiir2UCOzP IImRYYb1DAQzR II		 4tDSzT ]O.?-@CUzV ^,/A.BEWzX 236I5JMYzZ _-/@C[z\ \N-=,>A]z^ 78;L:MP_z` -.0@Cazb ]O.?-@Cczd _-0C/DGezf [M,A+BEgzh ]O.B-CFizj 569P8QTkzl ^,/A.BEmzn [MO+<?ozp ]O.?-@Cqzr D!szv OOBDD34kM?[`aOOBDD23[<.Y^_OOBDD01;UZ[OOBDD45{^DT]bcOOBDD;<kLaKbkpqOOBDD9:KJ]I^glmOOBDD67GWFXafgOOBDD56oEV_deOOBDD67GWFXafgOOBDD34kM?[`aOOBDD56oEV_deOOBDD56oEV_deOOBDD89;I[H\ejkOOBDD78+HYGZchiOOBDD:;[K_J`inoOOBDD>?OgNhqvwOOBDD45{^DT]bcOOBDD34kM?[`aOOBDD56oEV_deOOBDD,-{VHTROOBDD23[<.Y^_OOBDD@A;QkPluz{OOBDD67GWFXafgOOBDD34kM?[`aOOBDD34kM?[`aOOBDD45{^DT]bcOOBDD56oEV_deOOBDD,-{VHUSOOBDD/0+	{SXYOOBDD12K+W\]OOBDD;<kLaKbkpqOOBDD34kM?[`aOOBDD67GWFXafgOOBDD>?OgNhqvwOOBDD67GWFXafgOOBDD67GWFXafgOOBDD45{^DT]bcOOBDD12K+W\]OOBDD67GWFXafgOOBDD67GWFXafgOOBDD34kM?[`aOOBDD9:OoM^glmOOBDD:;_O_N`inoOOBDD78/M?chiOOBDD9:OoM^glmOOBDD<=QcPdmrsOOBDD;<oPaObkpqOOBDD>?SgRhqvwOOBDD89?^L\ejkOOBDD78/M?chiOOBDD9:OoM^glmOOBDD56+_deOOBDD:;_O_N`inoOO2IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDBCEcfoepy~OOBDDDEGehsgt  ~C  DOOBDDCDFdgqfr  |A  BOOBDDBCEcfoepy~OO0IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD@AC_bkaluz{OOBDDBCEadocpy~OOBDDABD`cmbnw|}OOBDD@AC_bkaluz{OO-IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OO4IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDDEGgjsit  ~C  DOOBDDFGIilwkx  BG  HOOBDDEFHhkujv  @E  FOOBDDDEGgjsit  ~C  DOO)IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD9:<QT]S^glmOOBDD;<>SVaUbkpqOOBDD:;=RU_T`inoOOBDD9:<QT]S^glmOO+IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD;<>UXaWbkpqOOBDD=>@WZeYfotuOOBDD<=?VYcXdmrsOOBDD;<>UXaWbkpqOO+IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD;<>UXaWbkpqOOBDD=>@WZeYfotuOOBDD<=?VYcXdmrsOOBDD;<>UXaWbkpqOOBDD<=?QTcSdmrsOOBDD=>@RUeTfotuOOBDD:;=OR_Q`inoOOBDD<=?QTcSdmrsOOBDD?@BTWiVjsxyOOBDD>?ASVgUhqvwOOBDDABDVYmXnw|}OOBDD;<>PSaRbkpqOOBDD:;=OR_Q`inoOOBDD<=?QTcSdmrsOOBDD:;=OR_Q`imnOOBDD89;MP[}ejkOO5IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDEFHilukv  @E  FOOBDDGHJknymz  DI  JOOBDDFGIjmwlx  BG  HOOBDDEFHilukv  @E  FOO3IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDCDFehqgr  |A  BOOBDDEFHgjuiv  @E  FOOBDDDEGfisht  ~C  DOOBDDCDFehqgr  |A  BOO0IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD@AC_bkaluz{OOBDDBCEadocpy~OOBDDABD`cmbnw|}OOBDD@AC_bkaluz{OO*IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD:;=SV_U`inoOOBDD<=?UXcWdmrsOOBDD;<>TWaVbkpqOOBDD:;=SV_U`inoOO-IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDD=>@Y\e[fotuOOBDD?@B[^i]jsxyOOBDD>?AZ]g\hqvwOOBDD=>@Y\e[fotuOO(IIdBIIR(59IIor||T:TJIId ;eLIIt!<uMIIor||T:TJIImRZZ\E:IImRYY[48IImRZZ\E:IIoryy3dCIInbiir2TBIIk299B/%@II"BIIR$84HII "))2"6FII		 4tD[M,A+BE-.1H0ILD!#& OO$IIdBIIR(59IIor||T:TJIId ;eLIIt!<uMIIor||T:TJIImRZZ\E:IImRYY[48IIj"))3/$?IIj"))3/$?II#RYYc%:TJIIlBJJL48IIi#.>IIlBIIS1DAIIoryy3dCIInbiir2TBIIk299B/%@II"BIIR$84HII "))2"6FII!299B#7%H014K3LO[M,A+BED!-0 OO.IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GYK.)9<ZL+>*?BD! OOBDD>?AQTgShqvwOOBDD:;=MP_O`inoOOBDD;<>NQaPbkpqOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD=>@PSeRfotuOOBDD<=?ORcQdmrsOOBDD?@BRUiTjsxyOOBDD9:<L~N^glmOOBDD89;Km_ejkOOBDD:;=MP_O`inoOOBDD679IK=afgOOBDD>?AUXgWhqvwOOBDD?@BVYiXjsxyOOBDD<=?SVcUdmrsOOBDD>?AUXgWhqvwOOBDDABDX[mZnw|}OOBDD@ACWZkYluz{OOBDDCDFZ]q\r  |A  BOOBDD=>@TWeVfotuOOBDD<=?SVcUdmrsOOBDD>?AUXgWhqvwOOBDD:;=QT_S`inoOOBDD?@BVYiXjsxyOO7IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDGHJmpyoz  DI  JOOBDDIJLor}q~  HM  NOOBDDHIKnq{p|  FK  LOOBDDGHJmpyoz  DI  JOO5IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDEFHilukv  @E  FOOBDDGHJknymz  DI  JOOBDDFGIjmwlx  BG  HOOBDDEFHilukv  @E  FOO2IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GD!
 OOBDDBCEcfoepy~OOBDDDEGehsgt  ~C  DOOBDDCDFdgqfr  |A  BOOBDDBCEcfoepy~OOBDD89>OK\ejkOOBDD9:NM]L^glmOOBDD67-afgOOBDD89>OK\ejkOOBDD;<nOaNbkpqOOBDD:;^N_M`inoOOBDD=>QePfotuOOBDD78.>JZchiOOBDD67-afgOOBDD89>OK\ejkOO3^fXV[ns  FL  N\  E]  ^OOBDD45~}]bcOO(IIdBIIS)E:IIk299B/$?IIi"-=IImRYYd3dCIIi"-=IIj"))2.>II#!6FII "))3"7$GYK-;ZL>*:=D! OOBDD89;OR[Q\ejkOOBDD:;=QT_S`inoOOBDD9:<PS]R^glmOOBDD89;OR[Q\ejkOOBDD=>@Y\e[fotuOOBDD?@B[^i]jsxyOOBDD>?AZ]g\hqvwOOBDD=>@Y\e[fotuOOBDD>?A[^g]hqvwOOBDD@AC]`k_luz{OOBDD?@B\_i^jsxyOOBDD>?A[^g]hqvwrl  c                   ;   t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  d	dd
ddi       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d       d       t        j                  t        j                  d!      d       t        j                  d       t        j                  t        j                  d"      d#       t        j                  t        j                  d$      d#       t        j                  t        j                  d%      d#       t        j                  t        j                  d&      d#       t        j                  d#       t        j                  t        j                  d'      d(       t        j                  t        j                  d)      d(       t        j                  t        j                  d*      d(       t        j                  t        j                  d+      d(       t        j                  t        j                  d,      d(       t        j                  t        j                  d-      d(       t        j                  t        j                  d.      d(       t        j                  t        j                  d/      d(       t        j                  t        j                  d0      d(       t        j                  t        j                  d1      d(       t        j                  t        j                  d2      d(       t        j                  t        j                  d3      d(       t        j                  d(       t        j                  t        j                  d4      d5       t        j                  t        j                  d6      d5       t        j                  t        j                  d7      d5       t        j                  t        j                  d8      d5       t        j                  t        j                  d9      d5       t        j                  t        j                  d:      d5       t        j                  t        j                  d;      d5       t        j                  t        j                  d<      d5       t        j                  t        j                  d=      d5       t        j                  t        j                  d>      d5       t        j                  t        j                  d?      d5       t        j                  t        j                  d@      d5       t        j                  d5       t        j                  t        j                  dA      dB       t        j                  t        j                  dC      dB       t        j                  t        j                  dD      dB       t        j                  t        j                  dE      dB       t        j                  dB       t        j                  t        j                  dF      dG       t        j                  t        j                  dH      dG       t        j                  t        j                  dI      dG       t        j                  t        j                  dJ      dG       t        j                  dG       t        j                  t        j                  dK      dL       t        j                  t        j                  dM      dL       t        j                  t        j                  dN      dL       t        j                  t        j                  dO      dL       t        j                  dL       t        j                  t        j                  dP      dQ       t        j                  t        j                  dR      dQ       t        j                  t        j                  dS      dQ       t        j                  t        j                  dT      dQ       t        j                  dQ       t        j                  t        j                  dU      dV       t        j                  t        j                  dW      dV       t        j                  t        j                  dX      dV       t        j                  t        j                  dY      dV       t        j                  dV       t        j                  t        j                  dZ      d[       t        j                  t        j                  d\      d[       t        j                  t        j                  d]      d[       t        j                  t        j                  d^      d[       t        j                  t        j                  d_      d[       t        j                  t        j                  d`      d[       t        j                  t        j                  da      d[       t        j                  t        j                  db      d[       t        j                  t        j                  dc      d[       t        j                  t        j                  dd      d[       t        j                  t        j                  de      d[       t        j                  t        j                  df      d[       t        j                  d[       t        j                  t        j                  dg      dh       t        j                  t        j                  di      dh       t        j                  t        j                  dj      dh       t        j                  t        j                  dk      dh       t        j                  dh       t        j                  t        j                  dl      dm       t        j                  t        j                  dn      dm       t        j                  t        j                  do      dm       t        j                  t        j                  dp      dm       t        j                  dm       t        j                  t        j                  dq      dr       t        j                  t        j                  ds      dr       t        j                  t        j                  dt      dr       t        j                  t        j                  du      dr       t        j                  dr       t        j                  t        j                  dv      dw       t        j                  t        j                  dx      dw       t        j                  t        j                  dy      dw       t        j                  t        j                  dz      dw       t        j                  dw       t        j                  t        j                  d{      d|       t        j                  t        j                  d}      d|       t        j                  t        j                  d~      d|       t        j                  t        j                  d      d|       t        j                  d|       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d      d       t        j                  t        j                  d«      d       t        j                  t        j                  dë      d       t        j                  t        j                  dī      d       t        j                  t        j                  dū      d       t        j                  d       y )NrT  rP  )
table_namerS  rR  rQ  rO  r   rJ  rK  r   rL  )rp  rM  rN  rI  rH  rG  rF  rE  rD  rC  rB  rA  r@  r?  r;  r>  r=  r<  r:  r6  r9  r8  r7  r5  r1  r4  r3  r2  r0  r  r/  r.  r-  r,  r+  r*  r)  r(  r'  r&  r%  r$  r  r#  r"  r!  r   r  r  r  r  r  r  r  r  r
  r  r  r  r	  r  r  r  r  r  r   r  r  r  r   r   r   r   r   r   r   r   r   r   r   r,   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r\  r  r[  rZ  rY  rX  r   rW  rV  rU  r   r   r   r   r   r   r   r   r   r   r   r/   r   r   r   r   r   r   r   r   r   r   r   r   r2   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   )r   
drop_indexrj  
drop_tablerk  rl  rm  	downgraders  l  sx   MM"$$67DXYMM"$$78EYZMM"$$89FZ[MM"$$67DXYMM&'MM"$$23OMM1n_dv|  M  vN  OMM"$$67NSMM"$$45.QMM"$$56>RMM"$$;<XMM"$$89nUMM"$$9:~VMM"$$67NSMM"$$45.QMM"$$78^TMM"$$67NSMM.!MM"$$@ANlmMM"$$ABOmnMM"$$BCPnoMM"$$@ANlmMM01MM"$$CDQrsMM"$$DERstMM"$$EFStuMM"$$CDQrsMM34MM"$$EFSvwMM"$$FGTwxMM"$$GHUxyMM"$$EFSvwMM56MM"$$=>K_`MM"$$89FZ[MM"$$<=J^_MM"$$:;H\]MM"$$;<I]^MM"$$ABOcdMM"$$>?L`aMM"$$?@MabMM"$$<=J^_MM"$$:;H\]MM"$$=>K_`MM"$$<=J^_MM&'MM"$$45BRSMM"$$89FVWMM"$$67DTUMM"$$78EUVMM"$$=>K[\MM"$$:;HXYMM"$$;<IYZMM"$$89FVWMM"$$67DTUMM"$$9:GWXMM"$$89FVWMM"$$<=JZ[MM"#MM"$$;<IbcMM"$$<=JcdMM"$$=>KdeMM"$$;<IbcMM+,MM"$$89F\]MM"$$9:G]^MM"$$:;H^_MM"$$89F\]MM()MM"$$>?LhiMM"$$?@MijMM"$$@ANjkMM"$$>?LhiMM./MM"$$ABOnoMM"$$BCPopMM"$$CDQpqMM"$$ABOnoMM12MM"$$CDQrsMM"$$DERstMM"$$EFStuMM"$$CDQrsMM34MM"$$67DVWMM"$$89FXYMM"$$:;HZ[MM"$$89FXYMM"$$9:GYZMM"$$?@M_`MM"$$<=J\]MM"$$=>K]^MM"$$:;HZ[MM"$$89FXYMM"$$;<I[\MM"$$:;HZ[MM$%MM"$$9:G^_MM"$$:;H_`MM"$$;<I`aMM"$$9:G^_MM)*MM"$$9:G^_MM"$$:;H_`MM"$$;<I`aMM"$$9:G^_MM)*MM"$$78EZ[MM"$$89F[\MM"$$9:G\]MM"$$78EZ[MM'(MM"$$BCPpqMM"$$CDQqrMM"$$DERrsMM"$$BCPpqMM23MM"$$<=JdeMM"$$=>KefMM"$$>?LfgMM"$$<=JdeMM,-MM"$$;<IbcMM"$$<=JcdMM"$$=>KdeMM"$$;<IbcMM+,MM"$$>?LhiMM"$$?@MijMM"$$@ANjkMM"$$>?LhiMM./MM"$$@ANlmMM"$$ABOmnMM"$$BCPnoMM"$$@ANlmMM01MM"$$89oVMM"$$34QMM"$$78_UMM"$$56?SMM"$$67OTMM"$$<=/ZMM"$$9:WMM"$$:;XMM"$$78_UMM"$$56?SMM"$$89oVMM"$$78_UMM/"MM"$$12{KMM"$$45+NMM"$$45+NMM"$$/0[IMM"$$23LMM"$$45+NMM"$$45+NMM"$$<=+VMM"$$45+NMM"$$12{KMM"$$9:{SMM"$$/0[IMM"$$-.;GMM"$$*+DMM"$$34MMM"$$23LMM"$$12{KMM"$$12{KMM"$$45+NMM"$$>?KXMM"$$01kJMM"$$*+DMM"$$34MMM"$$12{KMM"$$23LMM"$$<=+VMM"$$89kRMM"$$56;OMM"$$67KPMM"$$34MMM"$$34MMM"$$12{KMM"$$45+NMM"$$34MMM"$$45+NMM"$$78[QMM"$$9:{SMM"$$23LMM"$$./KHMM"$$01kJMM"$$12{KMM+rl  )__doc__alembicr   
sqlalchemyr^  sqlalchemy.dialectsr   revisiondown_revisionbranch_labels
depends_onrn  rs  rk  rl  rm  <module>r|     s9      * 
U	xrArl  