Bug 36790: List table columns for 230600052 queries
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Mon, 6 May 2024 10:58:33 +0000 (12:58 +0200)
committerKatrin Fischer <katrin.fischer@bsz-bw.de>
Mon, 6 May 2024 13:04:30 +0000 (15:04 +0200)
commitff183612043b8f37d74fbbd9c306a54c48329d99
tree814576e86b129337db449a95a42876577119b8a7
parent34b3becef2c38804153f062f4043b47fb23143a4
Bug 36790: List table columns for 230600052 queries

We must list the columns, or the db rev will fail when a new column is
added. It happened here when 33478 added 'style'

Also remove id and dates

To test:
1. On current main, run:
   $ ktd --shell
  k$ perl /kohadevbox/misc4dev/run_tests.pl --koha-dir=. --run-db-upgrade-only
=> FAIL: Tests explode for DB query issues
2. Apply this patch
3. Repeat 1
=> SUCCESS: Tests pass!
4. Sign off :-D

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
installer/data/mysql/db_revs/230600052.pl