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

(-)a/installer/data/mysql/atomicupdate/bug_14246-add_news_author.sql (-2 / +1 lines)
Lines 1-2 Link Here
1
ALTER TABLE `opac_news` ADD `borrowernumber` int(11) AFTER `number` default NULL;
1
ALTER TABLE `opac_news` ADD `borrowernumber` int(11) default NULL AFTER `number`;
2
ALTER TABLE `opac_news` ADD CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers`(`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE;
2
ALTER TABLE `opac_news` ADD CONSTRAINT `borrowernumber_fk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers`(`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE;
3
- 

Return to bug 14246