View | Details | Raw Unified | Return to bug 31374
Collapse All | Expand All

(-)a/Koha/Schema/Result/Suggestion.pm (+9 lines)
Lines 136-141 is the suggestion archived? Link Here
136
136
137
note entered on the suggestion
137
note entered on the suggestion
138
138
139
=head2 privatenote
140
141
  data_type: 'longtext'
142
  is_nullable: 1
143
144
non-public note entered on the suggestion
145
139
=head2 author
146
=head2 author
140
147
141
  data_type: 'varchar'
148
  data_type: 'varchar'
Lines 326-331 __PACKAGE__->add_columns( Link Here
326
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
333
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
327
  "note",
334
  "note",
328
  { data_type => "longtext", is_nullable => 1 },
335
  { data_type => "longtext", is_nullable => 1 },
336
  "privatenote",
337
  { data_type => "longtext", is_nullable => 1 },
329
  "author",
338
  "author",
330
  { data_type => "varchar", is_nullable => 1, size => 80 },
339
  { data_type => "varchar", is_nullable => 1, size => 80 },
331
  "title",
340
  "title",
(-)a/installer/data/mysql/atomicupdate/bug_31374.pl (+20 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "31374",
5
    description => "Add a non-public note cololumn to the suggestions table",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        if( !column_exists( 'suggestions', 'privatenote' ) ) {
10
            $dbh->do(q{
11
                    ALTER TABLE suggestions
12
                    ADD COLUMN privatenote longtext NULL DEFAULT NULL
13
                    COMMENT "suggestions table non-public note"
14
                    AFTER note
15
            });
16
        }
17
        # Print useful stuff here
18
        say $out "Add privatenote column to suggestions table";
19
    },
20
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 5185-5190 CREATE TABLE `suggestions` ( Link Here
5185
  `STATUS` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)',
5185
  `STATUS` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)',
5186
  `archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the suggestion archived?',
5186
  `archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the suggestion archived?',
5187
  `note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'note entered on the suggestion',
5187
  `note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'note entered on the suggestion',
5188
  `privatenote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public note entered on the suggestion',
5188
  `author` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'author of the suggested item',
5189
  `author` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'author of the suggested item',
5189
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'title of the suggested item',
5190
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'title of the suggested item',
5190
  `copyrightdate` smallint(6) DEFAULT NULL COMMENT 'copyright date of the suggested item',
5191
  `copyrightdate` smallint(6) DEFAULT NULL COMMENT 'copyright date of the suggested item',
5191
- 

Return to bug 31374