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