diff options
author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-12 00:48:13 +0000 |
---|---|---|
committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-08-12 00:48:13 +0000 |
commit | 046aec62960a06b27e6cd624d8cd97842cbe0277 (patch) | |
tree | 1af5efc5976442d94fae2605fb3b1c32221b7302 /sql | |
parent | 315091c89469e67358649f4062264445bc6e937e (diff) |
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
Diffstat (limited to 'sql')
-rw-r--r-- | sql/Pg-database.sql | 4 |
1 files 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'); |