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

(-)a/installer/data/mysql/atomicupdate/mana_01-add_mana_id_in_subscription.sql (-2 / +2 lines)
Lines 1-2 Link Here
1
ALTER TABLE subscription ADD mana_id int(11);
1
ALTER TABLE subscription ADD mana_id int(11) NULL DEFAULT NULL;
2
ALTER TABLE saved_sql ADD mana_id int(11);
2
ALTER TABLE saved_sql ADD mana_id int(11) NULL DEFAULT NULL;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 1464-1469 CREATE TABLE saved_sql ( -- saved sql reports Link Here
1464
    report_area varchar(6) default NULL,
1464
    report_area varchar(6) default NULL,
1465
    report_group varchar(80) default NULL,
1465
    report_group varchar(80) default NULL,
1466
    report_subgroup varchar(80) default NULL,
1466
    report_subgroup varchar(80) default NULL,
1467
    `mana_id` int(11) NULL DEFAULT NULL,
1467
   PRIMARY KEY  (`id`),
1468
   PRIMARY KEY  (`id`),
1468
   KEY sql_area_group_idx (report_group, report_subgroup),
1469
   KEY sql_area_group_idx (report_group, report_subgroup),
1469
   KEY boridx (`borrowernumber`)
1470
   KEY boridx (`borrowernumber`)
Lines 2121-2126 CREATE TABLE `subscription` ( -- information related to the subscription Link Here
2121
  `reneweddate` date default NULL, -- date of last renewal for the subscription
2122
  `reneweddate` date default NULL, -- date of last renewal for the subscription
2122
  `itemtype` VARCHAR( 10 ) NULL,
2123
  `itemtype` VARCHAR( 10 ) NULL,
2123
  `previousitemtype` VARCHAR( 10 ) NULL,
2124
  `previousitemtype` VARCHAR( 10 ) NULL,
2125
  `mana_id` int(11) NULL DEFAULT NULL,
2124
  PRIMARY KEY  (`subscriptionid`),
2126
  PRIMARY KEY  (`subscriptionid`),
2125
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2127
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2126
  CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
2128
  CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
2127
- 

Return to bug 17047