# HG changeset patch # User Alain Mazy # Date 1764341015 -3600 # Node ID 36f4a9992d1145238abe7d6691089e1000d977f6 # Parent 5019e732058d2745c1422394f8a721c19060acb2 rename diff -r 5019e732058d -r 36f4a9992d11 PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql Fri Nov 28 15:43:35 2025 +0100 @@ -0,0 +1,8 @@ +ALTER TABLE InvalidChildCounts DROP COLUMN pk; +ALTER TABLE GlobalIntegersChanges DROP COLUMN pk; +---------- + +-- set the global properties that actually documents the DB version, revision and some of the capabilities +-- modify only the ones that have changed +DELETE FROM GlobalProperties WHERE property IN (4); +INSERT INTO GlobalProperties VALUES (4, 6); -- GlobalProperty_DatabasePatchLevel diff -r 5019e732058d -r 36f4a9992d11 PostgreSQL/Plugins/SQL/Downgrades/Rev699ToRev6.sql --- a/PostgreSQL/Plugins/SQL/Downgrades/Rev699ToRev6.sql Fri Nov 28 15:38:54 2025 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,8 +0,0 @@ -ALTER TABLE InvalidChildCounts DROP COLUMN pk; -ALTER TABLE GlobalIntegersChanges DROP COLUMN pk; ----------- - --- set the global properties that actually documents the DB version, revision and some of the capabilities --- modify only the ones that have changed -DELETE FROM GlobalProperties WHERE property IN (4); -INSERT INTO GlobalProperties VALUES (4, 6); -- GlobalProperty_DatabasePatchLevel