Bugzilla – Attachment 51811 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.76 KB, created by
Mark Tompsett
on 2016-05-26 02:32:11 UTC
(
hide
)
Description:
Bug 16565: Drop additional_fields and additional_field_values before creating them
Filename:
MIME Type:
Creator:
Mark Tompsett
Created:
2016-05-26 02:32:11 UTC
Size:
1.76 KB
patch
obsolete
>From b130736e5f7dda59fef30cb84ba9d763a776245b 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 > >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> >--- > 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) >-- >2.1.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