From 046aec62960a06b27e6cd624d8cd97842cbe0277 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Tue, 12 Aug 2008 00:48:13 +0000 Subject: upper casing some SQL statements git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2243 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index aae27abc..40a1c8bf 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -578,7 +578,7 @@ 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; CREATE RULE ap_id_track_i AS ON insert TO ap DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ap'); @@ -586,7 +586,7 @@ DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ap'); CREATE RULE ap_id_track_u AS ON update TO ap DO UPDATE transactions SET id = new.id WHERE id = old.id; -insert into transactions (id, table_name) SELECT id, 'ar' FROM ap; +INSERT INTO transactions (id, table_name) SELECT id, 'ar' FROM ap; CREATE RULE ar_id_track_i AS ON insert TO ar DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ar'); -- cgit v1.2.3