Attachment #102944 for bug #22784

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





=head2 archived

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0


    size => 10,
  },
  "archived",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "note",
  { data_type => "longtext", is_nullable => 1 },
  "author",

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-14 20:04:28
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BrvQGdgqpODl23IfwbqdUw

__PACKAGE__->belongs_to(
  "suggester",

Lines 3014-3020 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
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

Lines 21546-21552 $DBversion = '19.12.00.069'; Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
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

Lines 99-105 __PACKAGE__->table("suggestions"); Link Here

(-)a/Koha/Schema/Result/Suggestion.pm (-4 / +4 lines)
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",