Revision a53be3c5
Von Moritz Bunkus vor fast 9 Jahren hinzugefügt
| sql/Pg-upgrade2/project_mtime_trigger.sql | ||
|---|---|---|
| 3 | 3 |
-- @depends: release_3_3_0 |
| 4 | 4 |
-- @encoding: utf-8 |
| 5 | 5 |
|
| 6 |
-- Bei LINET bereits existent: |
|
| 7 |
-- CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime(); |
|
| 6 |
CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime(); |
|
| sql/Pg-upgrade2/remove_index.sql | ||
|---|---|---|
| 8 | 8 |
DROP INDEX chart_id_key; |
| 9 | 9 |
REINDEX INDEX chart_pkey; |
| 10 | 10 |
|
| 11 |
-- Bei LINET nicht existent: |
|
| 12 |
-- DROP INDEX customer_id_key; |
|
| 11 |
DROP INDEX customer_id_key; |
|
| 13 | 12 |
REINDEX INDEX customer_pkey; |
| 14 | 13 |
|
| 15 |
-- Bei LINET nicht existent: |
|
| 16 |
-- DROP INDEX employee_id_key; |
|
| 14 |
DROP INDEX employee_id_key; |
|
| 17 | 15 |
REINDEX INDEX employee_pkey; |
| 18 | 16 |
|
| 19 |
-- Bei LINET nicht existent: |
|
| 20 |
-- DROP INDEX vendor_id_key; |
|
| 17 |
DROP INDEX vendor_id_key; |
|
| 21 | 18 |
REINDEX INDEX vendor_pkey; |
| 22 | 19 |
|
| 23 |
-- Bei LINET nicht existent: |
|
| 24 |
-- DROP INDEX ar_id_key; |
|
| 20 |
DROP INDEX ar_id_key; |
|
| 25 | 21 |
REINDEX INDEX ar_pkey; |
| 26 | 22 |
|
| 27 | 23 |
DROP INDEX units_name_idx; |
| 28 | 24 |
REINDEX INDEX units_pkey; |
| 29 | 25 |
|
| 30 |
-- Bei LINET nicht existent: |
|
| 31 |
-- DROP INDEX ap_id_key; |
|
| 26 |
DROP INDEX ap_id_key; |
|
| 32 | 27 |
REINDEX INDEX ap_pkey; |
| 33 | 28 |
|
| 34 |
-- Bei LINET nicht existent: |
|
| 35 |
-- DROP INDEX invoice_id_key; |
|
| 29 |
DROP INDEX invoice_id_key; |
|
| 36 | 30 |
REINDEX INDEX invoice_pkey; |
| 37 | 31 |
|
| 38 |
-- Bei LINET nicht existent: |
|
| 39 |
-- DROP INDEX oe_id_key; |
|
| 32 |
DROP INDEX oe_id_key; |
|
| 40 | 33 |
REINDEX INDEX oe_pkey; |
| 41 | 34 |
|
| 42 | 35 |
DROP INDEX parts_id_key; |
| ... | ... | |
| 45 | 38 |
DROP INDEX project_id_key; |
| 46 | 39 |
REINDEX INDEX project_pkey; |
| 47 | 40 |
|
| 48 |
-- Bei LINET nicht existent: |
|
| 49 |
-- DROP INDEX gl_id_key; |
|
| 41 |
DROP INDEX gl_id_key; |
|
| 50 | 42 |
REINDEX INDEX gl_pkey; |
| 51 | 43 |
|
| 52 | 44 |
DROP INDEX department_id_key; |
Auch abrufbar als: Unified diff
Revert "[LINET] Anpassung DB-Upgrades auf vorhandene LINET-Struktur"
This reverts commit 7c920e235989b809f3a546a17f31507d62c00f88.