summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/Pg-database.sql')
-rw-r--r--sql/Pg-database.sql2
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,