Revision 7c920e23
Von Moritz Bunkus vor fast 9 Jahren hinzugefügt
| sql/Pg-upgrade2/project_mtime_trigger.sql | ||
|---|---|---|
|
-- @depends: release_3_3_0
|
||
|
-- @encoding: utf-8
|
||
|
|
||
|
CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|
||
|
-- Bei LINET bereits existent:
|
||
|
-- CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|
||
| sql/Pg-upgrade2/remove_index.sql | ||
|---|---|---|
|
DROP INDEX chart_id_key;
|
||
|
REINDEX INDEX chart_pkey;
|
||
|
|
||
|
DROP INDEX customer_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX customer_id_key;
|
||
|
REINDEX INDEX customer_pkey;
|
||
|
|
||
|
DROP INDEX employee_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX employee_id_key;
|
||
|
REINDEX INDEX employee_pkey;
|
||
|
|
||
|
DROP INDEX vendor_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX vendor_id_key;
|
||
|
REINDEX INDEX vendor_pkey;
|
||
|
|
||
|
DROP INDEX ar_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX ar_id_key;
|
||
|
REINDEX INDEX ar_pkey;
|
||
|
|
||
|
DROP INDEX units_name_idx;
|
||
|
REINDEX INDEX units_pkey;
|
||
|
|
||
|
DROP INDEX ap_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX ap_id_key;
|
||
|
REINDEX INDEX ap_pkey;
|
||
|
|
||
|
DROP INDEX invoice_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX invoice_id_key;
|
||
|
REINDEX INDEX invoice_pkey;
|
||
|
|
||
|
DROP INDEX oe_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX oe_id_key;
|
||
|
REINDEX INDEX oe_pkey;
|
||
|
|
||
|
DROP INDEX parts_id_key;
|
||
| ... | ... | |
|
DROP INDEX project_id_key;
|
||
|
REINDEX INDEX project_pkey;
|
||
|
|
||
|
DROP INDEX gl_id_key;
|
||
|
-- Bei LINET nicht existent:
|
||
|
-- DROP INDEX gl_id_key;
|
||
|
REINDEX INDEX gl_pkey;
|
||
|
|
||
|
DROP INDEX department_id_key;
|
||
Auch abrufbar als: Unified diff
[LINET] Anpassung DB-Upgrades auf vorhandene LINET-Struktur