sql/Pg-upgrade2/remove_index.sql

   1 -- @tag: remove_index
   2 -- @description: Nicht mehr benötigte Indizes löschen (es gibt nun einen Primary Key)
   3 -- @depends: release_3_3_0
   4
   5 DROP    INDEX orderitems_id_key;
   6 REINDEX INDEX orderitems_pkey;
   7
   8 DROP    INDEX chart_id_key;
   9 REINDEX INDEX chart_pkey;
  10
  11 DROP    INDEX customer_id_key;
  12 REINDEX INDEX customer_pkey;
  13
  14 DROP    INDEX employee_id_key;
  15 REINDEX INDEX employee_pkey;
  16
  17 DROP    INDEX vendor_id_key;
  18 REINDEX INDEX vendor_pkey;
  19
  20 DROP    INDEX ar_id_key;
  21 REINDEX INDEX ar_pkey;
  22
  23 DROP    INDEX units_name_idx;
  24 REINDEX INDEX units_pkey;
  25
  26 DROP    INDEX ap_id_key;
  27 REINDEX INDEX ap_pkey;
  28
  29 DROP    INDEX invoice_id_key;
  30 REINDEX INDEX invoice_pkey;
  31
  32 DROP    INDEX oe_id_key;
  33 REINDEX INDEX oe_pkey;
  34
  35 DROP    INDEX parts_id_key;
  36 REINDEX INDEX parts_pkey;
  37
  38 DROP    INDEX project_id_key;
  39 REINDEX INDEX project_pkey;
  40
  41 DROP    INDEX gl_id_key;
  42 REINDEX INDEX gl_pkey;
  43
  44 DROP    INDEX department_id_key;
  45 REINDEX INDEX department_pkey;