Bugzilla – Attachment 51944 Details for
Bug 16565
additional_fields and additional_field_values are not dropped in kohastructure.sql
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16565: Drop additional_fields and additional_field_values before creating them
Bug-16565-Drop-additionalfields-and-additionalfiel.patch (text/plain), 1.86 KB, created by
Marcel de Rooy
on 2016-06-01 13:19:54 UTC
(
hide
)
Description:
Bug 16565: Drop additional_fields and additional_field_values before creating them
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2016-06-01 13:19:54 UTC
Size:
1.86 KB
patch
obsolete
>From 0ddd22614748c0114a2a965c8bdd82513ede5fd5 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 23 May 2016 12:19:46 +0100 >Subject: [PATCH] Bug 16565: Drop additional_fields and > additional_field_values before creating them >Content-Type: text/plain; charset=utf-8 > >These 2 tables should be dropped before trying to create them > >Test plan: >From the SQL CLI, source the kohastructure.sql file >source it again >=> Without this patch you get 2 warnings >ERROR 1050 (42S01) at line 3580 in file: >'installer/data/mysql/kohastructure.sql': Table >'additional_fields' already exi >sts >ERROR 1050 (42S01) at line 3596 in file: >'installer/data/mysql/kohastructure.sql': Table >'additional_field_values' alrea >dy exists > >=> With this patch, you won't get them > >Signed-off-by: Mark Tompsett <mtompset@hotmail.com> >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/kohastructure.sql | 2 ++ > 1 file changed, 2 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 42bff46..c5a3f4a 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3577,6 +3577,7 @@ CREATE TABLE discharges ( > -- This table add the ability to add new fields for a record > -- > >+DROP TABLE IF EXISTS additional_fields; > CREATE TABLE `additional_fields` ( > `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier > `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field >@@ -3593,6 +3594,7 @@ CREATE TABLE `additional_fields` ( > -- This table store values for additional fields > -- > >+DROP TABLE IF EXISTS additional_field_values; > CREATE TABLE `additional_field_values` ( > `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier > `field_id` int(11) NOT NULL, -- foreign key references additional_fields(id) >-- >1.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 16565
:
51717
|
51811
| 51944