Revision 7c920e23
Von Moritz Bunkus vor mehr als 8 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 |
CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime(); |
|
| 6 |
-- Bei LINET bereits existent: |
|
| 7 |
-- 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 |
DROP INDEX customer_id_key; |
|
| 11 |
-- Bei LINET nicht existent: |
|
| 12 |
-- DROP INDEX customer_id_key; |
|
| 12 | 13 |
REINDEX INDEX customer_pkey; |
| 13 | 14 |
|
| 14 |
DROP INDEX employee_id_key; |
|
| 15 |
-- Bei LINET nicht existent: |
|
| 16 |
-- DROP INDEX employee_id_key; |
|
| 15 | 17 |
REINDEX INDEX employee_pkey; |
| 16 | 18 |
|
| 17 |
DROP INDEX vendor_id_key; |
|
| 19 |
-- Bei LINET nicht existent: |
|
| 20 |
-- DROP INDEX vendor_id_key; |
|
| 18 | 21 |
REINDEX INDEX vendor_pkey; |
| 19 | 22 |
|
| 20 |
DROP INDEX ar_id_key; |
|
| 23 |
-- Bei LINET nicht existent: |
|
| 24 |
-- DROP INDEX ar_id_key; |
|
| 21 | 25 |
REINDEX INDEX ar_pkey; |
| 22 | 26 |
|
| 23 | 27 |
DROP INDEX units_name_idx; |
| 24 | 28 |
REINDEX INDEX units_pkey; |
| 25 | 29 |
|
| 26 |
DROP INDEX ap_id_key; |
|
| 30 |
-- Bei LINET nicht existent: |
|
| 31 |
-- DROP INDEX ap_id_key; |
|
| 27 | 32 |
REINDEX INDEX ap_pkey; |
| 28 | 33 |
|
| 29 |
DROP INDEX invoice_id_key; |
|
| 34 |
-- Bei LINET nicht existent: |
|
| 35 |
-- DROP INDEX invoice_id_key; |
|
| 30 | 36 |
REINDEX INDEX invoice_pkey; |
| 31 | 37 |
|
| 32 |
DROP INDEX oe_id_key; |
|
| 38 |
-- Bei LINET nicht existent: |
|
| 39 |
-- DROP INDEX oe_id_key; |
|
| 33 | 40 |
REINDEX INDEX oe_pkey; |
| 34 | 41 |
|
| 35 | 42 |
DROP INDEX parts_id_key; |
| ... | ... | |
| 38 | 45 |
DROP INDEX project_id_key; |
| 39 | 46 |
REINDEX INDEX project_pkey; |
| 40 | 47 |
|
| 41 |
DROP INDEX gl_id_key; |
|
| 48 |
-- Bei LINET nicht existent: |
|
| 49 |
-- DROP INDEX gl_id_key; |
|
| 42 | 50 |
REINDEX INDEX gl_pkey; |
| 43 | 51 |
|
| 44 | 52 |
DROP INDEX department_id_key; |
Auch abrufbar als: Unified diff
[LINET] Anpassung DB-Upgrades auf vorhandene LINET-Struktur