From a5492ce96bf4cbf93b91014b8b1b0fbb839a5084 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 31 Jul 2018 08:30:53 -0300 Subject: [PATCH] Bug 19166: Remove 'IF NOT EXISTS' in kohastructure The table is removed just before, this clause is useless. It also fixes a test: t/db_dependent/Creators/Lib.t .. 1/645 # Failed test 'get_table_names return all tables matching' # at t/db_dependent/Creators/Lib.t line 1258. # Structures begin differing at: # $got->[10] = 'aqinvoice_adjustments' # $expected->[10] = 'aqinvoices' # Looks like you failed 1 test of 645. Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 206959f48e..10b90bd15b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3147,7 +3147,7 @@ CREATE TABLE aqinvoices ( -- DROP TABLE IF EXISTS aqinvoice_adjustments; -CREATE TABLE IF NOT EXISTS aqinvoice_adjustments ( +CREATE TABLE aqinvoice_adjustments ( adjustment_id int(11) NOT NULL AUTO_INCREMENT, -- primary key for adjustments invoiceid int(11) NOT NULL, -- foreign key to link an adjustment to an invoice adjustment decimal(28,6), -- amount of adjustment -- 2.20.1