diff options
Diffstat (limited to 'sql')
| -rwxr-xr-x | sql/Pg-functions.sql | 4 | ||||
| -rw-r--r-- | sql/Pg-upgrade-2.6.17-2.6.18.sql | 3 |
2 files changed, 7 insertions, 0 deletions
diff --git a/sql/Pg-functions.sql b/sql/Pg-functions.sql index c11def4d..26d23473 100755 --- a/sql/Pg-functions.sql +++ b/sql/Pg-functions.sql @@ -263,9 +263,11 @@ BEGIN RETURN NEW; END; ' LANGUAGE PLPGSQL; +-- end function CREATE TRIGGER parts_short AFTER UPDATE ON parts FOR EACH ROW EXECUTE PROCEDURE trigger_parts_short(); +-- end function CREATE OR REPLACE FUNCTION add_custom_field (VARCHAR, VARCHAR, VARCHAR) RETURNS BOOL AS @@ -296,6 +298,7 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function CREATE OR REPLACE FUNCTION drop_custom_field (VARCHAR, VARCHAR) RETURNS BOOL AS @@ -313,3 +316,4 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function diff --git a/sql/Pg-upgrade-2.6.17-2.6.18.sql b/sql/Pg-upgrade-2.6.17-2.6.18.sql index 39c726b6..b18e327e 100644 --- a/sql/Pg-upgrade-2.6.17-2.6.18.sql +++ b/sql/Pg-upgrade-2.6.17-2.6.18.sql @@ -94,6 +94,7 @@ BEGIN RETURN NEW; END; ' LANGUAGE PLPGSQL; +-- end function CREATE TRIGGER parts_short AFTER UPDATE ON parts FOR EACH ROW EXECUTE PROCEDURE trigger_parts_short(); @@ -263,6 +264,7 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function CREATE OR REPLACE FUNCTION drop_custom_field (VARCHAR, VARCHAR) RETURNS BOOL AS @@ -280,5 +282,6 @@ BEGIN RETURN TRUE; END; ' LANGUAGE PLPGSQL; +-- end function UPDATE defaults SET version = '2.6.18'; |