Revision 34ea9b39
Von Kivitendo Admin vor etwa 9 Jahren hinzugefügt
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; |
Auch abrufbar als: Unified diff
Alte DB-Indizes entfernt/aufgeräumt
werden seit Einführung von Primary Keys in den entsprechenden Tabellen
nicht mehr benötigt.