kivitendo/sql/Pg-upgrade2/remove_index.sql @ 46584b73
| 34ea9b39 | Geoffrey Richardson | -- @tag: remove_index
|
||
-- @description: Nicht mehr benötigte Indizes löschen (es gibt nun einen Primary Key)
|
||||
-- @depends: release_3_3_0
|
||||
DROP INDEX orderitems_id_key;
|
||||
REINDEX INDEX orderitems_pkey;
|
||||
DROP INDEX chart_id_key;
|
||||
REINDEX INDEX chart_pkey;
|
||||
| a53be3c5 | Moritz Bunkus | DROP INDEX customer_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX customer_pkey;
|
||
| a53be3c5 | Moritz Bunkus | DROP INDEX employee_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX employee_pkey;
|
||
| a53be3c5 | Moritz Bunkus | DROP INDEX vendor_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX vendor_pkey;
|
||
| a53be3c5 | Moritz Bunkus | DROP INDEX ar_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX ar_pkey;
|
||
DROP INDEX units_name_idx;
|
||||
REINDEX INDEX units_pkey;
|
||||
| a53be3c5 | Moritz Bunkus | DROP INDEX ap_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX ap_pkey;
|
||
| a53be3c5 | Moritz Bunkus | DROP INDEX invoice_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX invoice_pkey;
|
||
| a53be3c5 | Moritz Bunkus | DROP INDEX oe_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX oe_pkey;
|
||
DROP INDEX parts_id_key;
|
||||
REINDEX INDEX parts_pkey;
|
||||
DROP INDEX project_id_key;
|
||||
REINDEX INDEX project_pkey;
|
||||
| a53be3c5 | Moritz Bunkus | DROP INDEX gl_id_key;
|
||
| 34ea9b39 | Geoffrey Richardson | REINDEX INDEX gl_pkey;
|
||
DROP INDEX department_id_key;
|
||||
REINDEX INDEX department_pkey;
|