summaryrefslogtreecommitdiff
path: root/sql/Pg-indices.sql
blob: 1da593f6471a05c66d6a14e966c68d62f77de207 (plain) 
    

  1. create index acc_trans_trans_id_key on acc_trans (trans_id);
    2. 

  2. create index acc_trans_chart_id_key on acc_trans (chart_id);
    3. 

  3. create index acc_trans_transdate_key on acc_trans (transdate);
    4. 

  4. create index acc_trans_source_key on acc_trans (lower(source));
    5. 

  5. --
    6. 

  6. create index ap_id_key on ap (id);
    7. 

  7. create index ap_transdate_key on ap (transdate);
    8. 

  8. create index ap_invnumber_key on ap (invnumber);
    9. 

  9. create index ap_ordnumber_key on ap (ordnumber);
    10. 

  10. create index ap_vendor_id_key on ap (vendor_id);
    11. 

  11. create index ap_employee_id_key on ap (employee_id);
    12. 

  12. create index ap_quonumber_key on ap (quonumber);
    13. 

  13. --
    14. 

  14. create index ar_id_key on ar (id);
    15. 

  15. create index ar_transdate_key on ar (transdate);
    16. 

  16. create index ar_invnumber_key on ar (invnumber);
    17. 

  17. create index ar_ordnumber_key on ar (ordnumber);
    18. 

  18. create index ar_customer_id_key on ar (customer_id);
    19. 

  19. create index ar_employee_id_key on ar (employee_id);
    20. 

  20. create index ar_quonumber_key on ar (quonumber);
    21. 

  21. --
    22. 

  22. create index assembly_id_key on assembly (id);
    23. 

  23. --
    24. 

  24. create index chart_id_key on chart (id);
    25. 

  25. create unique index chart_accno_key on chart (accno);
    26. 

  26. create index chart_category_key on chart (category);
    27. 

  27. create index chart_link_key on chart (link);
    28. 

  28. create index chart_gifi_accno_key on chart (gifi_accno);
    29. 

  29. --
    30. 

  30. create index customer_id_key on customer (id);
    31. 

  31. create index customer_customernumber_key on customer (customernumber);
    32. 

  32. create index customer_name_key on customer (lower(name));
    33. 

  33. create index customer_contact_key on customer (lower(contact));
    34. 

  34. create index customer_customer_id_key on customertax (customer_id);
    35. 

  35. --
    36. 

  36. create index employee_id_key on employee (id);
    37. 

  37. create unique index employee_login_key on employee (login);
    38. 

  38. create index employee_name_key on employee (lower(name));
    39. 

  39. --
    40. 

  40. create index exchangerate_ct_key on exchangerate (curr, transdate);
    41. 

  41. --
    42. 

  42. create unique index gifi_accno_key on gifi (accno);
    43. 

  43. --
    44. 

  44. create index gl_id_key on gl (id);
    45. 

  45. create index gl_transdate_key on gl (transdate);
    46. 

  46. create index gl_reference_key on gl (reference);
    47. 

  47. create index gl_description_key on gl (lower(description));
    48. 

  48. create index gl_employee_id_key on gl (employee_id);
    49. 

  49. --
    50. 

  50. create index invoice_id_key on invoice (id);
    51. 

  51. create index invoice_trans_id_key on invoice (trans_id);
    52. 

  52. --
    53. 

  53. create index makemodel_parts_id_key on makemodel (parts_id);
    54. 

  54. create index makemodel_make_key on makemodel (lower(make));
    55. 

  55. create index makemodel_model_key on makemodel (lower(model));
    56. 

  56. --
    57. 

  57. create index oe_id_key on oe (id);
    58. 

  58. create index oe_transdate_key on oe (transdate);
    59. 

  59. create index oe_ordnumber_key on oe (ordnumber);
    60. 

  60. create index oe_employee_id_key on oe (employee_id);
    61. 

  61. create index orderitems_trans_id_key on orderitems (trans_id);
    62. 

  62. create index orderitems_id_key on orderitems (id);
    63. 

  63. --
    64. 

  64. create index parts_id_key on parts (id);
    65. 

  65. create index parts_partnumber_key on parts (lower(partnumber));
    66. 

  66. create index parts_description_key on parts (lower(description));
    67. 

  67. create index partstax_parts_id_key on partstax (parts_id);
    68. 

  68. --
    69. 

  69. create index vendor_id_key on vendor (id);
    70. 

  70. create index vendor_name_key on vendor (lower(name));
    71. 

  71. create index vendor_vendornumber_key on vendor (vendornumber);
    72. 

  72. create index vendor_contact_key on vendor (lower(contact));
    73. 

  73. create index vendortax_vendor_id_key on vendortax (vendor_id);
    74. 

  74. --
    75. 

  75. create index shipto_trans_id_key on shipto (trans_id);
    76. 

  76. --
    77. 

  77. create index project_id_key on project (id);
    78. 

  78. create unique index projectnumber_key on project (projectnumber);
    79. 

  79. --
    80. 

  80. create index partsgroup_id_key on partsgroup (id);
    81. 

  81. create unique index partsgroup_key on partsgroup (partsgroup);
    82. 

  82. --
    83. 

  83. create index status_trans_id_key on status (trans_id);
    84. 

  84. --
    85. 

  85. create index department_id_key on department (id);
    86. 

  86. --
    87. 

  87. create index partsvendor_vendor_id_key on partsvendor (vendor_id);
    88. 

  88. create index partsvendor_parts_id_key on partsvendor (parts_id);
    89. 

  89. --
    90. 

  90. create index pricegroup_pricegroup_key on pricegroup (pricegroup);
    91. 

  91. create index pricegroup_id_key on pricegroup (id);
    92. 

  92. --
    93. 

  93. create index audittrail_trans_id_key on audittrail (trans_id);
    94. 

  94. --
    95. 

  95. create index translation_trans_id_key on translation (trans_id);
    96. 

  96. --
    97. 

  97. create unique index language_code_key on language (code);
    98. 

  98. --
    99. 

  99. create index jcitems_id_key on jcitems (id);
    100. 

  100.
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-04 21:24:32 +0000