This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository lima. See https://gitlab.nuiton.org/chorem/lima.git commit 5e4483e4c0fc18b4631825d0d059595c96d6502a Author: David Cossé <cosse@codelutin.com> Date: Wed Oct 18 00:54:20 2017 +0200 refs #1394 ajout d'indexes --- .../db/migration/V0_8_7_0__1394_add_indexes.sql | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) diff --git a/lima-callao/src/main/resources/db/migration/V0_8_7_0__1394_add_indexes.sql b/lima-callao/src/main/resources/db/migration/V0_8_7_0__1394_add_indexes.sql new file mode 100644 index 00000000..fc08ad7c --- /dev/null +++ b/lima-callao/src/main/resources/db/migration/V0_8_7_0__1394_add_indexes.sql @@ -0,0 +1,31 @@ +--- +-- #%L +-- Lima :: callao +-- %% +-- Copyright (C) 2008 - 2015 CodeLutin +-- %% +-- This program is free software: you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as +-- published by the Free Software Foundation, either version 3 of the +-- License, or (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public +-- License along with this program. If not, see +-- <http://www.gnu.org/licenses/gpl-3.0.html>. +-- #L% +--- + +CREATE INDEX idx_FinancialTransaction_transactionDate ON FINANCIALTRANSACTION (transactionDate); +CREATE INDEX idx_FinancialTransaction_transactionDateentryBook ON FINANCIALTRANSACTION (transactionDate, entryBook); +CREATE INDEX idx_FinancialPeriod_beginDate ON FINANCIALPERIOD (beginDate); +CREATE INDEX idx_FinancialPeriod_endDate ON FINANCIALPERIOD (endDate); +CREATE INDEX idx_FiscalPeriod_beginDateendDate ON FINANCIALPERIOD (beginDate,endDate); +CREATE INDEX idx_FinancialStatement_CreateDate ON FinancialStatement (topiaCreateDate); +CREATE INDEX idx_EntryBook_label ON ENTRYBOOK (label); +CREATE INDEX idx_ClosedPeriodicEntryBook_locked ON CLOSEDPERIODICENTRYBOOK (locked); +CREATE INDEX idx_Account_label ON ACCOUNT (label); \ No newline at end of file -- To stop receiving notification emails like this one, please contact chorem.org SCM administrator <admin+scm@chorem.org>.