diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/Pg-database.sql | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 866a89f3..d5d182dd 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -1066,9 +1066,9 @@ CREATE TABLE jcitems ( ); -insert into transactions (id, table_name) SELECT id, 'ap' FROM ap; +INSERT INTO transactions (id, table_name) SELECT id, 'ap' FROM ap; -insert into transactions (id, table_name) SELECT id, 'ar' FROM ap; +INSERT INTO transactions (id, table_name) SELECT id, 'ar' FROM ap; INSERT INTO transactions (id, table_name) SELECT id, 'gl' FROM gl; @@ -1091,14 +1091,14 @@ BEGIN END; $$ LANGUAGE PLPGSQL; -CREATE TRIGGER ap_track_global_sequence before insert or update on ap -for each row execute procedure track_global_sequence(); +CREATE TRIGGER ap_track_global_sequence BEFORE INSERT OR UPDATE ON ap +FOR EACH ROW EXECUTE PROCEDURE track_global_sequence(); -CREATE TRIGGER ar_track_global_sequence before insert or update on ar -for each row execute procedure track_global_sequence(); +CREATE TRIGGER ar_track_global_sequence BEFORE INSERT OR UPDATE ON ar +FOR EACH ROW EXECUTE PROCEDURE track_global_sequence(); -CREATE TRIGGER gl_track_global_sequence before insert or update on gl -for each row execute procedure track_global_sequence(); +CREATE TRIGGER gl_track_global_sequence BEFORE INSERT OR UPDATE ON gl +FOR EACH ROW EXECUTE PROCEDURE track_global_sequence(); CREATE TABLE custom_table_catalog ( table_id SERIAL PRIMARY KEY, |