Bugzilla – Attachment 173573 Details for
Bug 35625
Add support for system flag to additional fields
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35625: Add is_system to additional_fields table
Bug-35625-Add-issystem-to-additionalfields-table.patch (text/plain), 2.14 KB, created by
Martin Renvoize (ashimema)
on 2024-10-28 17:14:24 UTC
(
hide
)
Description:
Bug 35625: Add is_system to additional_fields table
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2024-10-28 17:14:24 UTC
Size:
2.14 KB
patch
obsolete
>From d53039145e77e794b86009576174dbfebd110ef1 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 21 Dec 2023 09:05:54 +0000 >Subject: [PATCH] Bug 35625: Add is_system to additional_fields table > >--- > installer/data/mysql/atomicupdate/bug_35625.pl | 17 +++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 18 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_35625.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_35625.pl b/installer/data/mysql/atomicupdate/bug_35625.pl >new file mode 100755 >index 00000000000..f47131d9baf >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_35625.pl >@@ -0,0 +1,17 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "35625", >+ description => "Add is_system field to additional_fields table", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ unless ( column_exists( 'additional_fields', 'is_system' ) ) { >+ $dbh->do( >+ "ALTER TABLE `additional_fields` ADD COLUMN `is_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is this field required for system operation' AFTER `tablename`" >+ ); >+ say $out "Added column 'additional_fields.is_system'"; >+ } >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 269ab71815a..15720a807a2 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -260,6 +260,7 @@ DROP TABLE IF EXISTS `additional_fields`; > CREATE TABLE `additional_fields` ( > `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key identifier', > `tablename` varchar(255) NOT NULL DEFAULT '' COMMENT 'tablename of the new field', >+ `is_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is this field required for system operation', > `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'name of the field', > `authorised_value_category` varchar(32) DEFAULT NULL COMMENT 'is an authorised value category', > `marcfield` varchar(16) NOT NULL DEFAULT '' COMMENT 'contains the marc field to copied into the record', >-- >2.47.0
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 35625
:
160171
|
160172
|
160173
|
160174
|
160175
|
160176
|
173567
|
173568
|
173569
|
173570
|
173571
| 173573 |
173574
|
173575
|
173576
|
173577
|
173578