diff options
-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, |