o
    F+i1                     @   s"   d dl mZ G dd dejZdS )    )
migrationsc                   @   s"   e Zd ZdgZejdddgZdS )	Migration)users!0002_alter_clientlog_performed_bya  
                CREATE INDEX IF NOT EXISTS idx_client_ref_client ON clients (ref_client_id);
                CREATE INDEX IF NOT EXISTS idx_client_is_active ON clients (is_active);
                CREATE INDEX IF NOT EXISTS idx_client_client_status ON clients (client_status);
                CREATE INDEX IF NOT EXISTS idx_client_client_code ON clients (client_code);
                CREATE INDEX IF NOT EXISTS idx_client_email ON clients (email);
                CREATE INDEX IF NOT EXISTS idx_client_contact_no ON clients (contact_no);
                CREATE INDEX IF NOT EXISTS idx_client_residential_city ON clients (residential_city);
                CREATE INDEX IF NOT EXISTS idx_client_residential_state ON clients (residential_state);
                CREATE INDEX IF NOT EXISTS idx_client_residential_country ON clients (residential_country);
                CREATE INDEX IF NOT EXISTS idx_client_country_code ON clients (country_code);
                CREATE INDEX IF NOT EXISTS idx_client_ref_preferred_airline ON clients (ref_preferred_airline);
                CREATE INDEX IF NOT EXISTS idx_client_created_by ON clients (created_by);
                CREATE INDEX IF NOT EXISTS idx_client_updated_by ON clients (updated_by);
            a  
                DROP INDEX IF EXISTS idx_client_ref_client ON clients;
                DROP INDEX IF EXISTS idx_client_is_active ON clients;
                DROP INDEX IF EXISTS idx_client_client_status ON clients;
                DROP INDEX IF EXISTS idx_client_client_code ON clients;
                DROP INDEX IF EXISTS idx_client_email ON clients;
                DROP INDEX IF EXISTS idx_client_contact_no ON clients;
                DROP INDEX IF EXISTS idx_client_residential_city ON clients;
                DROP INDEX IF EXISTS idx_client_residential_state ON clients;
                DROP INDEX IF EXISTS idx_client_residential_country ON clients;
                DROP INDEX IF EXISTS idx_client_country_code ON clients;
                DROP INDEX IF EXISTS idx_client_ref_preferred_airline ON clients;
                DROP INDEX IF EXISTS idx_client_created_by ON clients;
                DROP INDEX IF EXISTS idx_client_updated_by ON clients;
            )sqlreverse_sqlN)__name__
__module____qualname__dependenciesr   RunSQL
operations r   r   \/var/www/html/myvaluetrips/my_value_trip_new/my_value_trip/users/migrations/0003_indexing.pyr      s     br   N)	django.dbr   r   r   r   r   r   <module>   s    