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.07025 @ 2013-12-23 16:39:42
392
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-06-25 15:02:46
384
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ji1W0q5g5xTw1J89cjVlWw
393
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+qhg5GixwXyxf99J5CUI4w
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 (-4 / +13 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 508-514 __PACKAGE__->belongs_to( Link Here
508
  {
517
  {
509
    is_deferrable => 1,
518
    is_deferrable => 1,
510
    join_type     => "LEFT",
519
    join_type     => "LEFT",
511
    on_delete     => "CASCADE",
520
    on_delete     => "RESTRICT",
512
    on_update     => "CASCADE",
521
    on_update     => "CASCADE",
513
  },
522
  },
514
);
523
);
Lines 528-534 __PACKAGE__->belongs_to( Link Here
528
  {
537
  {
529
    is_deferrable => 1,
538
    is_deferrable => 1,
530
    join_type     => "LEFT",
539
    join_type     => "LEFT",
531
    on_delete     => "CASCADE",
540
    on_delete     => "RESTRICT",
532
    on_update     => "CASCADE",
541
    on_update     => "CASCADE",
533
  },
542
  },
534
);
543
);
Lines 609-616 __PACKAGE__->might_have( Link Here
609
);
618
);
610
619
611
620
612
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-12-19 06:29:02
621
# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-06-25 15:02:46
613
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:h6fPG62SifJ5T8QKPZNBBw
622
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:65YUTXGvZEgL1A/sI4dh1Q
614
623
615
__PACKAGE__->belongs_to(
624
__PACKAGE__->belongs_to(
616
    "biblio",
625
    "biblio",
(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 920-925 CREATE TABLE `deleteditems` ( Link Here
920
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
920
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
921
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
921
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
922
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
922
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
923
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the toggle_new_status cronjob.
923
  PRIMARY KEY  (`itemnumber`),
924
  PRIMARY KEY  (`itemnumber`),
924
  KEY `delitembarcodeidx` (`barcode`),
925
  KEY `delitembarcodeidx` (`barcode`),
925
  KEY `delitemstocknumberidx` (`stocknumber`),
926
  KEY `delitemstocknumberidx` (`stocknumber`),
Lines 1216-1221 CREATE TABLE `items` ( -- holdings/item information Link Here
1216
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1217
  `enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1217
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1218
  `copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1218
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1219
  `stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
1220
  `new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intended to be managed by the toggle_new_status cronjob.
1219
  PRIMARY KEY  (`itemnumber`),
1221
  PRIMARY KEY  (`itemnumber`),
1220
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1222
  UNIQUE KEY `itembarcodeidx` (`barcode`),
1221
  KEY `itemstocknumberidx` (`stocknumber`),
1223
  KEY `itemstocknumberidx` (`stocknumber`),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
Lines 8560-8565 if ( CheckVersion($DBversion) ) { Link Here
8560
    SetVersion($DBversion);
8560
    SetVersion($DBversion);
8561
}
8561
}
8562
8562
8563
$DBversion = "3.17.00.XXX";
8564
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
8565
    $dbh->do(q{
8566
        ALTER TABLE `items` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
8567
    });
8568
    $dbh->do(q{
8569
        ALTER TABLE `deleteditems` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
8570
    });
8571
    print "Upgrade to $DBversion done (Bug 11023: Adds field 'new' in items and deleteditems tables)\n";
8572
    SetVersion($DBversion);
8573
}
8574
8563
=head1 FUNCTIONS
8575
=head1 FUNCTIONS
8564
8576
8565
=head2 TableExists($table)
8577
=head2 TableExists($table)
8566
- 

Return to bug 11023