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

(-)a/Koha/Schema/Result/Suggestion.pm (-4 / +4 lines)
Lines 99-105 __PACKAGE__->table("suggestions"); Link Here
99
99
100
=head2 archived
100
=head2 archived
101
101
102
  data_type: 'integer'
102
  data_type: 'tinyint'
103
  default_value: 0
103
  default_value: 0
104
  is_nullable: 0
104
  is_nullable: 0
105
105
Lines 259-265 __PACKAGE__->add_columns( Link Here
259
    size => 10,
259
    size => 10,
260
  },
260
  },
261
  "archived",
261
  "archived",
262
  { data_type => "integer", default_value => 0, is_nullable => 0 },
262
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
263
  "note",
263
  "note",
264
  { data_type => "longtext", is_nullable => 1 },
264
  { data_type => "longtext", is_nullable => 1 },
265
  "author",
265
  "author",
Lines 484-491 __PACKAGE__->belongs_to( Link Here
484
);
484
);
485
485
486
486
487
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-27 06:55:24
487
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-14 20:04:28
488
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:shHAnURjxdagQdgu90WQuw
488
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BrvQGdgqpODl23IfwbqdUw
489
489
490
__PACKAGE__->belongs_to(
490
__PACKAGE__->belongs_to(
491
  "suggester",
491
  "suggester",
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 3014-3020 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
3014
   lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time
3014
   lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time
3015
   lastmodificationdate date default NULL, -- date of the last modification
3015
   lastmodificationdate date default NULL, -- date of the last modification
3016
  `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
3016
  `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED)
3017
  `archived` INT(1) NOT NULL DEFAULT 0, -- is the suggestion archived?
3017
  `archived` TINYINT(1) NOT NULL DEFAULT 0, -- is the suggestion archived?
3018
  `note` LONGTEXT, -- note entered on the suggestion
3018
  `note` LONGTEXT, -- note entered on the suggestion
3019
  `author` varchar(80) default NULL, -- author of the suggested item
3019
  `author` varchar(80) default NULL, -- author of the suggested item
3020
  `title` varchar(255) default NULL, -- title of the suggested item
3020
  `title` varchar(255) default NULL, -- title of the suggested item
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 21546-21552 $DBversion = '19.12.00.069'; Link Here
21546
if( CheckVersion( $DBversion ) ) {
21546
if( CheckVersion( $DBversion ) ) {
21547
    if( !column_exists( 'suggestions', 'archived' ) ) {
21547
    if( !column_exists( 'suggestions', 'archived' ) ) {
21548
        $dbh->do(q|
21548
        $dbh->do(q|
21549
            ALTER TABLE suggestions ADD COLUMN archived INT(1) NOT NULL DEFAULT 0 AFTER `STATUS`;
21549
            ALTER TABLE suggestions ADD COLUMN archived TINYINT(1) NOT NULL DEFAULT 0 AFTER `STATUS`;
21550
        |);
21550
        |);
21551
    }
21551
    }
21552
21552
21553
- 

Return to bug 22784