QS: add missing indices #24

New issue

Open

opened 2022-09-13 15:33:22 +02:00 by tk · 0 comments

tk commented

2022-09-13 15:33:22 +02:00

Owner

/home/i/workspace/foodsoft/db/schema.rb:85 - always add db index (bank_accounts => [bank_gateway_id])
/home/i/workspace/foodsoft/db/schema.rb:95 - always add db index (bank_gateways => [unattended_user_id])
/home/i/workspace/foodsoft/db/schema.rb:102 - always add db index (bank_transactions => [bank_account_id])
/home/i/workspace/foodsoft/db/schema.rb:136 - always add db index (financial_transaction_types => [financial_transaction_class_id])
/home/i/workspace/foodsoft/db/schema.rb:136 - always add db index (financial_transaction_types => [bank_account_id])
/home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [user_id])
/home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [financial_transaction_type_id])
/home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [financial_link_id])
/home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [group_order_id])
/home/i/workspace/foodsoft/db/schema.rb:217 - always add db index (invites => [group_id])
/home/i/workspace/foodsoft/db/schema.rb:217 - always add db index (invites => [user_id])
/home/i/workspace/foodsoft/db/schema.rb:226 - always add db index (invoices => [financial_link_id])
/home/i/workspace/foodsoft/db/schema.rb:276 - always add db index (messages => [sender_id])
/home/i/workspace/foodsoft/db/schema.rb:276 - always add db index (messages => [group_id])
/home/i/workspace/foodsoft/db/schema.rb:326 - always add db index (order_articles => [article_price_id])
/home/i/workspace/foodsoft/db/schema.rb:340 - always add db index (order_comments => [user_id])
/home/i/workspace/foodsoft/db/schema.rb:348 - always add db index (orders => [supplier_id])
/home/i/workspace/foodsoft/db/schema.rb:348 - always add db index (orders => [invoice_id])
/home/i/workspace/foodsoft/db/schema.rb:443 - always add db index (printer_jobs => [order_id])
/home/i/workspace/foodsoft/db/schema.rb:462 - always add db index (stock_changes => [order_id])
/home/i/workspace/foodsoft/db/schema.rb:472 - always add db index (stock_events => [invoice_id])
/home/i/workspace/foodsoft/db/schema.rb:482 - always add db index (supplier_categories => [financial_transaction_class_id])
/home/i/workspace/foodsoft/db/schema.rb:482 - always add db index (supplier_categories => [bank_account_id])
/home/i/workspace/foodsoft/db/schema.rb:489 - always add db index (suppliers => [supplier_category_id])
/home/i/workspace/foodsoft/db/schema.rb:511 - always add db index (tasks => [periodic_task_group_id])

``` /home/i/workspace/foodsoft/db/schema.rb:85 - always add db index (bank_accounts => [bank_gateway_id]) /home/i/workspace/foodsoft/db/schema.rb:95 - always add db index (bank_gateways => [unattended_user_id]) /home/i/workspace/foodsoft/db/schema.rb:102 - always add db index (bank_transactions => [bank_account_id]) /home/i/workspace/foodsoft/db/schema.rb:136 - always add db index (financial_transaction_types => [financial_transaction_class_id]) /home/i/workspace/foodsoft/db/schema.rb:136 - always add db index (financial_transaction_types => [bank_account_id]) /home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [user_id]) /home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [financial_transaction_type_id]) /home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [financial_link_id]) /home/i/workspace/foodsoft/db/schema.rb:144 - always add db index (financial_transactions => [group_order_id]) /home/i/workspace/foodsoft/db/schema.rb:217 - always add db index (invites => [group_id]) /home/i/workspace/foodsoft/db/schema.rb:217 - always add db index (invites => [user_id]) /home/i/workspace/foodsoft/db/schema.rb:226 - always add db index (invoices => [financial_link_id]) /home/i/workspace/foodsoft/db/schema.rb:276 - always add db index (messages => [sender_id]) /home/i/workspace/foodsoft/db/schema.rb:276 - always add db index (messages => [group_id]) /home/i/workspace/foodsoft/db/schema.rb:326 - always add db index (order_articles => [article_price_id]) /home/i/workspace/foodsoft/db/schema.rb:340 - always add db index (order_comments => [user_id]) /home/i/workspace/foodsoft/db/schema.rb:348 - always add db index (orders => [supplier_id]) /home/i/workspace/foodsoft/db/schema.rb:348 - always add db index (orders => [invoice_id]) /home/i/workspace/foodsoft/db/schema.rb:443 - always add db index (printer_jobs => [order_id]) /home/i/workspace/foodsoft/db/schema.rb:462 - always add db index (stock_changes => [order_id]) /home/i/workspace/foodsoft/db/schema.rb:472 - always add db index (stock_events => [invoice_id]) /home/i/workspace/foodsoft/db/schema.rb:482 - always add db index (supplier_categories => [financial_transaction_class_id]) /home/i/workspace/foodsoft/db/schema.rb:482 - always add db index (supplier_categories => [bank_account_id]) /home/i/workspace/foodsoft/db/schema.rb:489 - always add db index (suppliers => [supplier_category_id]) /home/i/workspace/foodsoft/db/schema.rb:511 - always add db index (tasks => [periodic_task_group_id]) ```