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

(-)a/installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql (-2 / +2 lines)
Lines 1-2 Link Here
1
ALTER TABLE `opac_news` ADD `borrowernumber` INT(11) default NULL;
1
ALTER TABLE `opac_news` ADD `borrowernumber` int(11) AFTER `number` default NULL;
2
ALTER TABLE `opac_news` ADD CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers`(`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL;
2
ALTER TABLE `opac_news` ADD CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers`(`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1687-1693 CREATE TABLE `opac_news` ( -- data from the news tool Link Here
1687
  `number` int(11) default NULL, -- the order in which this article appears in that specific location
1687
  `number` int(11) default NULL, -- the order in which this article appears in that specific location
1688
  `borrowernumber` int(11) default NULL, -- The user who created the news article
1688
  `borrowernumber` int(11) default NULL, -- The user who created the news article
1689
  PRIMARY KEY  (`idnew`),
1689
  PRIMARY KEY  (`idnew`),
1690
  CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
1690
  CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
1691
  CONSTRAINT opac_news_branchcode_ibfk FOREIGN KEY (branchcode) REFERENCES branches (branchcode)
1691
  CONSTRAINT opac_news_branchcode_ibfk FOREIGN KEY (branchcode) REFERENCES branches (branchcode)
1692
    ON DELETE CASCADE ON UPDATE CASCADE
1692
    ON DELETE CASCADE ON UPDATE CASCADE
1693
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1693
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1694
- 

Return to bug 14246