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

(-)a/Koha/Schema/Result/Subscription.pm (-2 / +10 lines)
Lines 276-281 __PACKAGE__->table("subscription"); Link Here
276
  data_type: 'integer'
276
  data_type: 'integer'
277
  is_nullable: 1
277
  is_nullable: 1
278
278
279
=head2 ccode
280
281
  data_type: 'varchar'
282
  is_nullable: 1
283
  size: 80
284
279
=cut
285
=cut
280
286
281
__PACKAGE__->add_columns(
287
__PACKAGE__->add_columns(
Lines 365-370 __PACKAGE__->add_columns( Link Here
365
  { data_type => "varchar", is_nullable => 1, size => 10 },
371
  { data_type => "varchar", is_nullable => 1, size => 10 },
366
  "mana_id",
372
  "mana_id",
367
  { data_type => "integer", is_nullable => 1 },
373
  { data_type => "integer", is_nullable => 1 },
374
  "ccode",
375
  { data_type => "varchar", is_nullable => 1, size => 80 },
368
);
376
);
369
377
370
=head1 PRIMARY KEY
378
=head1 PRIMARY KEY
Lines 452-459 __PACKAGE__->has_many( Link Here
452
);
460
);
453
461
454
462
455
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39
463
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2019-07-21 22:34:06
456
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dTb/JOO3KQ3NZGypFbRiEw
464
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TS3fIO7Y11bAkj73Ak8ouA
457
465
458
__PACKAGE__->has_many(
466
__PACKAGE__->has_many(
459
  "additional_field_values",
467
  "additional_field_values",
(-)a/installer/data/mysql/atomicupdate/bug_23352-add_ccode_column_to_subscriptions_table.perl (+7 lines)
Line 0 Link Here
1
2
unless ( column_exists('subscription', 'ccode')) {
3
    $dbh->do(q{
4
        ALTER TABLE `subscription` 
5
        ADD `ccode` varchar (80) default NULL AFTER `mana_id`
6
    });
7
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2021-2026 CREATE TABLE `subscription` ( -- information related to the subscription Link Here
2021
  `itemtype` VARCHAR( 10 ) NULL,
2021
  `itemtype` VARCHAR( 10 ) NULL,
2022
  `previousitemtype` VARCHAR( 10 ) NULL,
2022
  `previousitemtype` VARCHAR( 10 ) NULL,
2023
  `mana_id` int(11) NULL DEFAULT NULL,
2023
  `mana_id` int(11) NULL DEFAULT NULL,
2024
  `ccode` varchar(80) DEFAULT NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
2024
  PRIMARY KEY  (`subscriptionid`),
2025
  PRIMARY KEY  (`subscriptionid`),
2025
  KEY `by_biblionumber` (`biblionumber`),
2026
  KEY `by_biblionumber` (`biblionumber`),
2026
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2027
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2027
- 

Return to bug 23352