diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-02-22 21:11:45 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-02-22 21:11:45 +0000 |
| commit | 239834db495d79c0e1d05ac0d9202dc76b1e6474 (patch) | |
| tree | f29c35158755638bb0b861a45c06676dc8e4d73f | |
| parent | 455e6e83674e0bf8e249fd81b8141c33af1b317b (diff) | |
Adding index on acc_trans(voucher_id)
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2077 4979c152-3d1c-0410-bac9-87ea11338e46
| -rw-r--r-- | sql/Pg-database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index d5d182dd..384e39eb 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -420,6 +420,8 @@ CREATE TABLE acc_trans ( voucher_id int references voucher(id), entry_id SERIAL PRIMARY KEY ); + +CREATE INDEX acc_trans_voucher_id_idx ON acc_trans(voucher_id); -- CREATE TABLE invoice ( id serial PRIMARY KEY, |