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

(-)a/Koha/Schema/Result/Deleteditem.pm (-2 / +11 lines)
Lines 265-270 __PACKAGE__->table("deleteditems"); Link Here
265
  is_nullable: 1
265
  is_nullable: 1
266
  size: 32
266
  size: 32
267
267
268
=head2 new
269
270
  accessor: undef
271
  data_type: 'varchar'
272
  is_nullable: 1
273
  size: 32
274
268
=cut
275
=cut
269
276
270
__PACKAGE__->add_columns(
277
__PACKAGE__->add_columns(
Lines 365-370 __PACKAGE__->add_columns( Link Here
365
  { data_type => "varchar", is_nullable => 1, size => 32 },
372
  { data_type => "varchar", is_nullable => 1, size => 32 },
366
  "stocknumber",
373
  "stocknumber",
367
  { data_type => "varchar", is_nullable => 1, size => 32 },
374
  { data_type => "varchar", is_nullable => 1, size => 32 },
375
  "new",
376
  { accessor => undef, data_type => "varchar", is_nullable => 1, size => 32 },
368
);
377
);
369
378
370
=head1 PRIMARY KEY
379
=head1 PRIMARY KEY
Lines 380-387 __PACKAGE__->add_columns( Link Here
380
__PACKAGE__->set_primary_key("itemnumber");
389
__PACKAGE__->set_primary_key("itemnumber");
381
390
382
391
383
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-24 09:58:16
392
# Created by DBIx::Class::Schema::Loader v0.07041 @ 2014-11-05 09:42:42
384
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ru5DyaIlWJcMNAgpZRjOLg
393
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FuMIqaxfqRuclwG/pxrTtA
385
394
386
395
387
# You can replace this text with custom content, and it will be preserved on regeneration
396
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/Koha/Schema/Result/Item.pm (-2 / +11 lines)
Lines 268-273 __PACKAGE__->table("items"); Link Here
268
  is_nullable: 1
268
  is_nullable: 1
269
  size: 32
269
  size: 32
270
270
271
=head2 new
272
273
  accessor: undef
274
  data_type: 'varchar'
275
  is_nullable: 1
276
  size: 32
277
271
=cut
278
=cut
272
279
273
__PACKAGE__->add_columns(
280
__PACKAGE__->add_columns(
Lines 373-378 __PACKAGE__->add_columns( Link Here
373
  { data_type => "varchar", is_nullable => 1, size => 32 },
380
  { data_type => "varchar", is_nullable => 1, size => 32 },
374
  "stocknumber",
381
  "stocknumber",
375
  { data_type => "varchar", is_nullable => 1, size => 32 },
382
  { data_type => "varchar", is_nullable => 1, size => 32 },
383
  "new",
384
  { accessor => undef, data_type => "varchar", is_nullable => 1, size => 32 },
376
);
385
);
377
386
378
=head1 PRIMARY KEY
387
=head1 PRIMARY KEY
Lines 609-616 __PACKAGE__->might_have( Link Here
609
);
618
);
610
619
611
620
612
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-10-24 09:58:16
621
# Created by DBIx::Class::Schema::Loader v0.07041 @ 2014-11-05 09:42:42
613
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2slVK/FjcRDiYLeufoOFQQ
622
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yCum/5krRX5Yv+qXQJ1QPg
614
623
615
__PACKAGE__->belongs_to(
624
__PACKAGE__->belongs_to(
616
    "biblio",
625
    "biblio",
(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 946-951 CREATE TABLE `deleteditems` ( Link Here
946
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
946
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
947
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
947
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
948
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
948
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
949
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
949
  PRIMARY KEY  (`itemnumber`),
950
  PRIMARY KEY  (`itemnumber`),
950
  KEY `delitembarcodeidx` (`barcode`),
951
  KEY `delitembarcodeidx` (`barcode`),
951
  KEY `delitemstocknumberidx` (`stocknumber`),
952
  KEY `delitemstocknumberidx` (`stocknumber`),
Lines 1245-1250 CREATE TABLE `items` ( -- holdings/item information Link Here
1245
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1246
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1246
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1247
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1247
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1248
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1249
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
1248
  PRIMARY KEY  (`itemnumber`),
1250
  PRIMARY KEY  (`itemnumber`),
1249
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1251
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1250
  KEY `itemstocknumberidx` (`stocknumber`),
1252
  KEY `itemstocknumberidx` (`stocknumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
Lines 9669-9674 if ( CheckVersion($DBversion) ) { Link Here
9669
    SetVersion ($DBversion);
9669
    SetVersion ($DBversion);
9670
}
9670
}
9671
9671
9672
$DBversion = "3.19.00.XXX";
9673
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
9674
    $dbh->do(q{
9675
        ALTER TABLE `items` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
9676
    });
9677
    $dbh->do(q{
9678
        ALTER TABLE `deleteditems` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
9679
    });
9680
    print "Upgrade to $DBversion done (Bug 11023: Adds field 'new' in items and deleteditems tables)\n";
9681
    SetVersion($DBversion);
9682
}
9683
9672
=head1 FUNCTIONS
9684
=head1 FUNCTIONS
9673
9685
9674
=head2 TableExists($table)
9686
=head2 TableExists($table)
9675
- 

Return to bug 11023