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

(-)a/C4/Serials.pm (-1 / +1 lines)
Lines 746-752 sub SearchSubscriptions { Link Here
746
            record_id => $subscription->{subscriptionid},
746
            record_id => $subscription->{subscriptionid},
747
            tablename => 'subscription'
747
            tablename => 'subscription'
748
        });
748
        });
749
        $subscription->{addition_fields} = $additional_field_values->{$subscription->{subscriptionid}};
749
        $subscription->{additional_fields} = $additional_field_values->{$subscription->{subscriptionid}};
750
    }
750
    }
751
751
752
    return @$results;
752
    return @$results;
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 3387-3393 CREATE TABLE IF NOT EXISTS marc_modification_template_actions ( Link Here
3387
  CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
3387
  CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
3388
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
3388
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
3389
3389
3390
-- Table structure for table addition_fields
3390
-- Table structure for table additional_fields
3391
-- This table add the ability to add new fields for a record
3391
-- This table add the ability to add new fields for a record
3392
--
3392
--
3393
3393
Lines 3409-3415 CREATE TABLE `additional_fields` ( Link Here
3409
3409
3410
CREATE TABLE `additional_field_values` (
3410
CREATE TABLE `additional_field_values` (
3411
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3411
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3412
  `field_id` int(11) NOT NULL, -- foreign key references addition_fields(id)
3412
  `field_id` int(11) NOT NULL, -- foreign key references additional_fields(id)
3413
  `record_id` int(11) NOT NULL, -- record_id
3413
  `record_id` int(11) NOT NULL, -- record_id
3414
  `value` varchar(255) NOT NULL DEFAULT '', -- value for this field
3414
  `value` varchar(255) NOT NULL DEFAULT '', -- value for this field
3415
  PRIMARY KEY (`id`),
3415
  PRIMARY KEY (`id`),
3416
- 

Return to bug 10855