Revision 773

Date:
2019/04/17 23:51:00
Author:
ahitrov
Revision Log:
Counter indexes

Files:

Legend:

 
Added
 
Removed
 
Modified

  • utf8/plugins/webshop/lib/webshop/SQL/Order.pm

     
    31 31 _vault_filter
    32 32 _postman_filter
    33 33 _sync_filter
    34 _yandex_id_filter
    35 _google_id_filter
    34 36 )];
    35 37
    36 38 sub available_filters {
    … …  
    276 278 return &SQL::Common::_generic_int_filter('d.uid', $opts{uid});
    277 279 }
    278 280
    281 sub _yandex_id_filter {
    282 my ($self,%opts)=@_;
    283 return undef unless ( exists $opts{yandex_id} );
    284 return &SQL::Common::_generic_text_filter('d.yandex_id', $opts{yandex_id});
    285 }
    286
    287 sub _google_id_filter {
    288 my ($self,%opts)=@_;
    289 return undef unless ( exists $opts{google_id} );
    290 return &SQL::Common::_generic_text_filter('d.google_id', $opts{google_id});
    291 }
    292
    279 293 sub _company_filter {
    280 294 my ($self,%opts)=@_;
    281 295 return undef unless ( exists $opts{company_id} );

  • utf8/plugins/webshop/sql/TOAST/orders.update.773.sql

     
    1 CREATE INDEX orders_yandex_id ON orders USING btree (yandex_id) where yandex_id is not null;
    2 CREATE INDEX orders_google_id ON orders USING btree (google_id) where google_id is not null;